Untitled
Untitled
Untitled
a) Cashflow 100000
PV 100000
b) Cashflow 180000
t 5
PV 102136.83402935
e) Cashflow 6500
Growth 5%
PV 92857.142857143
3) compounded Semiannually
YTM 6.91%
t 5
Coupon rate 8.20%
P 139.55 (Let face value be 100)
PV 108.42 (t=5)
Year Dividend P
1 5.00 4.5454545454546
2 6.00 4.9586776859504
3 7.20 5.4094665664914
4 8.64 5.9012362543542
5 10.368 6.4377122774773
6 12.442 70.229588481571
97.482135811299
P 142.86
P 166.67
P 148.2082926
Year Dividend P
1 5.00 4.672897196
2 6.00 5.24063237
3 7.20 5.877344714
4 8.64 6.591414632
5 10.368 7.392240709
6 12.442 118.433763
148.2082926
2) Year Nominal Rate(%) Inflation(%) Real return%
2013 4.50% 7.40% -2.7%
2014 10.50% 6% 4.2%
2015 32% 2% 29.4%
2016 -0.90% -2.50% 1.6%
2017 3.90% 3.70% 0.2%
Average 10.0% 6.6%
Variance 0.0168 (Manual)
SD 12.95%
SD 12.95% (Excel Formula)