For Average annual Compound growth rate (CAGR) for 5-year
2012-2016 ,
year |
2012 |
2012 |
2013 |
2014 |
2015 |
2016 |
NAV at beginning |
-10.7 |
|
|
|
|
|
Dividend |
|
0.6 |
0.71 |
0.87 |
0.85 |
0.93 |
Capital gain |
|
0 |
1.03 |
0 |
1.09 |
1.01 |
NAV at end |
|
|
|
|
|
16.01 |
Net cash flow |
-10.7 |
0.6 |
1.74 |
0.87 |
1.94 |
17.95 |
|
Use of IRR
() function |
|
|
|
|
Calculating CAGR |
24.19% |
|
|
|
|
|
For Average annual Compound growth rate (CAGR) for 3-year
2014-2016 ,
year |
2014 |
2014 |
2015 |
2016 |
NAV at beginning |
-10.79 |
|
|
|
Dividend |
|
0.87 |
0.85 |
0.93 |
Capital gain |
|
0 |
1.09 |
1.01 |
NAV at end |
|
|
|
16.01 |
Net cash flow |
-10.79 |
0.87 |
1.94 |
17.95 |
|
Use of IRR
() function |
|
|
Calculating CAGR |
41.39% |
|
|
|
Total profit in terms of dollar,
year |
2014 |
2012 |
2013 |
2014 |
2015 |
2016 |
NAV at beginning |
-10.79 |
|
|
|
|
|
Dividend |
|
0.6 |
0.71 |
0.87 |
0.85 |
0.93 |
Capital gain |
|
0 |
1.03 |
0 |
1.09 |
1.01 |
NAV at end |
|
|
|
|
|
16.01 |
Net cash flow |
-10.79 |
0.6 |
1.74 |
0.87 |
1.94 |
17.95 |
|
Sum of cash flow for 5 year |
|
|
|
Total return |
12.31 |
|
|
|
|
|