In: Finance
What is the Macaulay duration of a bond with a coupon of 6.6 percent, seven years to maturity, and a current price of $1,069.40? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
K = N |
Bond Price =∑ [( Coupon)/(1 + YTM)^k] + Par value/(1 + YTM)^N |
k=1 |
K =7 |
1069.4 =∑ [(6.6*1000/100)/(1 + YTM/100)^k] + 1000/(1 + YTM/100)^7 |
k=1 |
YTM% = 5.38 |
Period | Cash Flow | Discounting factor | PV Cash Flow | Duration Calc |
0 | ($1,069.40) | =(1+YTM/number of coupon payments in the year)^period | =cashflow/discounting factor | =PV cashflow*period |
1 | 66.00 | 1.05 | 62.63 | 62.63 |
2 | 66.00 | 1.11 | 59.43 | 118.87 |
3 | 66.00 | 1.17 | 56.40 | 169.20 |
4 | 66.00 | 1.23 | 53.52 | 214.08 |
5 | 66.00 | 1.30 | 50.79 | 253.94 |
6 | 66.00 | 1.37 | 48.19 | 289.17 |
7 | 1,066.00 | 1.44 | 738.67 | 5,170.68 |
Total | 6,278.55 |
Macaulay duration =(∑ Duration calc)/(bond price*number of coupon per year) |
=6278.55/(1069.4*1) |
=5.871 |
Modified duration = Macaulay duration/(1+YTM) |
=5.87/(1+0.0538) |
=5.571 |