In: Finance
Frequency in a year | 2 | ||||||||
YTM | |||||||||
Coupon rate | 3.00% | ||||||||
Face value | $ 1,000 | ||||||||
Coupon payment | $ 15.00 | =1000*3%/2 | |||||||
Years to maturity | 5 | ||||||||
No. of periods | 10 | ||||||||
Maturity conversion | 25 shares | ||||||||
Maturity share price | 50 | ||||||||
Total maturity amount | $ 1,250 | 25*50 | |||||||
3.00% | 4.00% | ||||||||
Year | Cash Flow | PV factor = 1/ (1+r)^t | PV | PV factor = 1/ (1+r)^t | PV | ||||
0 | $ (1,000.00) | 1.000 | $(1,000.00) | 1.000 | $(1,000.00) | ||||
1 | $ 15.00 | 0.971 | $ 14.56 | 0.962 | $ 14.42 | ||||
2 | $ 15.00 | 0.943 | $ 14.14 | 0.925 | $ 13.87 | ||||
3 | $ 15.00 | 0.915 | $ 13.73 | 0.889 | $ 13.33 | ||||
4 | $ 15.00 | 0.888 | $ 13.33 | 0.855 | $ 12.82 | ||||
5 | $ 15.00 | 0.863 | $ 12.94 | 0.822 | $ 12.33 | ||||
6 | $ 15.00 | 0.837 | $ 12.56 | 0.790 | $ 11.85 | ||||
7 | $ 15.00 | 0.813 | $ 12.20 | 0.760 | $ 11.40 | ||||
8 | $ 15.00 | 0.789 | $ 11.84 | 0.731 | $ 10.96 | ||||
9 | $ 15.00 | 0.766 | $ 11.50 | 0.703 | $ 10.54 | ||||
10 | $ 15.00 | 0.744 | $ 11.16 | 0.676 | $ 10.13 | ||||
10 | $ 1,250.00 | 0.744 | $ 930.12 | 0.676 | $ 844.46 | ||||
Total | $ 58.07 | Total | $ (33.88) | ||||||
NPV @ 0.03 | 58.07 | ||||||||
NPV @ 0.04 | (33.88) | ||||||||
Difference in both | 91.95 | ||||||||
Investor return | =Lower rate + Difference in rates*(NPV at lower rate)/(Lower rate NPV-Higher rate NPV) | ||||||||
'=3%+ (4%-3%)*(58.070/(58.070+33.881) | |||||||||
Investor return= | 3.62% |