In: Finance
Find the duration of a 5% coupon bond making annual coupon payments if it has three years until maturity and a yield to maturity of 6.3%. What is the duration if the yield to maturity is 10.3%?
K = N |
Bond Price =∑ [( Coupon)/(1 + YTM)^k] + Par value/(1 + YTM)^N |
k=1 |
K =3 |
Bond Price =∑ [(5*1000/100)/(1 + 6.3/100)^k] + 1000/(1 + 6.3/100)^3 |
k=1 |
Bond Price = 965.44 |
Period | Cash Flow | Discounting factor | PV Cash Flow | Duration Calc | Convexity Calc |
0 | ($965.44) | =(1+YTM/number of coupon payments in the year)^period | =cashflow/discounting factor | =PV cashflow*period | =duration calc*(1+period)/(1+YTM/N)^2 |
1 | 50.00 | 1.06 | 47.04 | 47.04 | 83.25 |
2 | 50.00 | 1.13 | 44.25 | 88.50 | 234.96 |
3 | 1,050.00 | 1.20 | 874.16 | 2,622.47 | 9,283.34 |
Total | 2,758.01 | 9,601.55 |
Macaulay duration =(∑ Duration calc)/(bond price*number of coupon per year) |
=2758.01/(965.44*1) |
=2.856735 |
K = N |
Bond Price =∑ [( Coupon)/(1 + YTM)^k] + Par value/(1 + YTM)^N |
k=1 |
K =3 |
Bond Price =∑ [(5*1000/100)/(1 + 10.3/100)^k] + 1000/(1 + 10.3/100)^3 |
k=1 |
Bond Price = 868.89 |
Period | Cash Flow | Discounting factor | PV Cash Flow | Duration Calc | Convexity Calc |
0 | ($868.89) | =(1+YTM/number of coupon payments in the year)^period | =cashflow/discounting factor | =PV cashflow*period | =duration calc*(1+period)/(1+YTM/N)^2 |
1 | 50.00 | 1.10 | 45.33 | 45.33 | 74.52 |
2 | 50.00 | 1.22 | 41.10 | 82.20 | 202.68 |
3 | 1,050.00 | 1.34 | 782.46 | 2,347.38 | 7,717.79 |
Total | 2,474.91 | 7,994.99 |
Macaulay duration =(∑ Duration calc)/(bond price*number of coupon per year) |
=2474.91/(868.89*1) |
=2.848358 |