In: Finance
Calculation of Macaulay duration of the bond
Maturity Period = | 8 years | |||
Face value (assumed) = | $1,000 | |||
Coupon Rate = | 3.80% | |||
Coupon payment at 3.8% of face value | $38.00 | |||
Yield-to-maturity | 5.60% | |||
Year (t) | Cash Flow from coupon payments and maturity amount (CF) | Present value (PV) discounted at 5.6% [=CF/(1+5.6%)^t] | PV *t | |
1 | $38.00 | $35.98 | $35.98 | |
2 | $38.00 | $34.08 | $68.15 | |
3 | $38.00 | $32.27 | $96.81 | |
4 | $38.00 | $30.56 | $122.23 | |
5 | $38.00 | $28.94 | $144.69 | |
6 | $38.00 | $27.40 | $164.42 | |
7 | $38.00 | $25.95 | $181.65 | |
8 | $1,038.00 | $671.25 | $5,370.02 | |
sum | $886.43 | $6,183.96 | ||
Bond's Price↑ | ||||
Macaulay duration = sum of (PV*t)/sum of PVs = | $6183.96/$886.43 | 6.98 | Years |
Macaulay duration of the bond is 6.98 years
Formulas used in excel calculation: