In: Finance
A bond pays annual interest. Its coupon rate is 9%. Its value at maturity is $1,000. It matures in 4 years. Its yield to maturity (YTM) is currently 6%.
a. Calculate the Macaulay's duration.
b. Calculate the modified duration
c. Calculate the percentage change in bond price if YTM increases by 1%
| K = N |
| Bond Price =∑ [( Coupon)/(1 + YTM)^k] + Par value/(1 + YTM)^N |
| k=1 |
| K =4 |
| Bond Price =∑ [(9*1000/100)/(1 + 6/100)^k] + 1000/(1 + 6/100)^4 |
| k=1 |
| Bond Price = 1103.95 |
a

| Period | Cash Flow | Discounting factor | PV Cash Flow | Duration Calc |
| 0 | ($1,103.95) | =(1+YTM/number of coupon payments in the year)^period | =cashflow/discounting factor | =PV cashflow*period |
| 1 | 90.00 | 1.06 | 84.91 | 84.91 |
| 2 | 90.00 | 1.12 | 80.10 | 160.20 |
| 3 | 90.00 | 1.19 | 75.57 | 226.70 |
| 4 | 1,090.00 | 1.26 | 863.38 | 3,453.53 |
| Total | 3,925.33 |
| Macaulay duration =(∑ Duration calc)/(bond price*number of coupon per year) |
| =3925.33/(1103.95*1) |
| =3.555714 |
b
| Modified duration = Macaulay duration/(1+YTM) |
| =3.56/(1+0.06) |
| =3.354447 |
c
| Using only modified duration |
| Mod.duration prediction = -Mod. Duration*Yield_Change*Bond_Price |
| =-3.35*0.01*1103.95 |
| =-37.03 |
| %age change in bond price=Mod.duration prediction/bond price |
| =-37.03/1103.95 |
| =-3.35% |