In: Finance
A semiannual payment bond with a $1,000 par has a 7 percent quoted coupon rate, a 7 percent promised YTM, and 10 years to maturity. Find the bond's duration.
Answer :
Calculation of Bond's Duration :
Below is the table showing calculation of Bond's Duration:
Year (Weights) | Cah Flows | PVF @3.5% | Discounted Cash Flows | Weights * Discounted Cash Flows |
1 | 35 | 0.966183575 | 33.81642512 | 33.81642512 |
2 | 35 | 0.9335107 | 32.67287451 | 65.34574903 |
3 | 35 | 0.901942706 | 31.5679947 | 94.7039841 |
4 | 35 | 0.871442228 | 30.50047797 | 122.0019119 |
5 | 35 | 0.841973167 | 29.46906084 | 147.3453042 |
6 | 35 | 0.813500644 | 28.47252255 | 170.8351353 |
7 | 35 | 0.785990961 | 27.50968362 | 192.5677854 |
8 | 35 | 0.759411556 | 26.57940447 | 212.6352357 |
9 | 35 | 0.733730972 | 25.68058403 | 231.1252562 |
10 | 35 | 0.708918814 | 24.81215848 | 248.1215848 |
11 | 35 | 0.684945714 | 23.97309998 | 263.7040998 |
12 | 35 | 0.661783298 | 23.16241544 | 277.9489853 |
13 | 35 | 0.639404153 | 22.37914535 | 290.9288896 |
14 | 35 | 0.61778179 | 21.62236266 | 302.7130772 |
15 | 35 | 0.596890619 | 20.89117165 | 313.3675748 |
16 | 35 | 0.576705912 | 20.18470691 | 322.9553106 |
17 | 35 | 0.557203779 | 19.50213228 | 331.5362488 |
18 | 35 | 0.53836114 | 18.84263988 | 339.1675179 |
19 | 35 | 0.52015569 | 18.20544916 | 345.9035341 |
20 | 1035 | 0.502565884 | 520.1556904 | 10403.11381 |
Total | 1000 | 14709.83742 |
Coupon Payment in every six month = 1000 * 7%/2 = 35
Years to maturity = 10 * 2 = 20 (Multiplied by 2 as semi annual coupon payment)
Yield to maturity = 7% / 2 = 3.5%
Duration = [Sum of (Weights * Discounted Cash Flows)] / Discounted Cash Flows
= 14,709.83742 / 1000
= 14.70983742 half years or 7.354918709 years or 7.35 years.