In: Finance
Please rank the duration of the following bonds and explain the
reason: (4 points)
Bond A: 5-year bond, coupon rate of 3% selling at par
Bond B: 5-year bond, coupon rate of 3% selling at discount
Bond C: 10-year bond, coupon rate of 2% selling at par
Bond D: 10-year bond, coupon rate of 2% selling at premium
Term | coupon | yield | duration | ranking | |
1 | 5 | 3 | 3 | 4.71 | 2 |
2 | 5 | 3 | 4 | 4.736842 | 1 |
3 | 10 | 2 | 2 | 8.78 | 3 |
4 | 10 | 2 | 1.5 | 9.230769 | 4 |
Workings for duration is given below
Years T | NCF | PV@3% | Duration D | Convexity |
NCF(1+0.03)TNCF(1+0.03)T |
(PV*T)(PV*T) |
D∗(T+1)(100)(1+0.03)2D∗(T+1)(100)(1+0.03)2 |
||
1 | 3 | 2.9126 | 2.9126 | 0.0549 |
2 | 3 | 2.8278 | 5.6556 | 0.1599 |
3 | 3 | 2.7454 | 8.2363 | 0.3105 |
4 | 3 | 2.6655 | 10.662 | 0.5025 |
5 | 3+100 =103 | 88.849 | 444.24 | 25.125 |
100 | 471.7 | 26.15 | ||
Years T | NCF | PV@4% | Duration D | Convexity |
NCF(1+0.04)TNCF(1+0.04)T |
(PV*T)(PV*T) |
D∗(T+1)(95.548177669)(1+0.04)2D∗(T+1)(95.548177669)(1+0.04)2 |
||
1 | 3 | 2.8846 | 2.8846 | 0.0558 |
2 | 3 | 2.7737 | 5.5473 | 0.161 |
3 | 3 | 2.667 | 8.001 | 0.3097 |
4 | 3 | 2.5644 | 10.258 | 0.4963 |
5 | 3+100 =103 | 84.658 | 423.29 | 24.576 |
95.55 | 450 | 25.6 | ||
Years T | NCF | PV@2% | Duration D | Convexity |
NCF(1+0.02)TNCF(1+0.02)T |
(PV*T)(PV*T) |
D∗(T+1)(100)(1+0.02)2D∗(T+1)(100)(1+0.02)2 |
||
1 | 3 | 2.9126 | 2.9126 | 0.0549 |
2 | 3 | 2.8278 | 5.6556 | 0.1599 |
3 | 3 | 2.7454 | 8.2363 | 0.3105 |
4 | 3 | 2.6655 | 10.662 | 0.5025 |
5 | 3 | 2.5878 | 12.939 | 0.7318 |
6 | 3 | 2.5125 | 15.075 | 0.9947 |
7 | 3 | 2.4393 | 17.075 | 1.2876 |
8 | 3 | 2.3682 | 18.946 | 1.6072 |
9 | 3 | 2.2993 | 20.693 | 1.9505 |
10 | 3+100 =103 | 76.642 | 766.42 | 79.466 |
100 | 878.6 | 87.07 | ||
Years T | NCF | [email protected]% | Duration D | Convexity |
NCF(1+0.015)TNCF(1+0.015)T |
(PV*T)(PV*T) |
D∗(T+1)(104.611092276)(1+0.015)2D∗(T+1)(104.611092276)(1+0.015)2 |
||
1 | 2 | 1.9704 | 1.9704 | 0.0366 |
2 | 2 | 1.9413 | 3.8826 | 0.1081 |
3 | 2 | 1.9126 | 5.7379 | 0.213 |
4 | 2 | 1.8844 | 7.5375 | 0.3497 |
5 | 2 | 1.8565 | 9.2826 | 0.5168 |
6 | 2 | 1.8291 | 10.975 | 0.7128 |
7 | 2 | 1.8021 | 12.614 | 0.9364 |
8 | 2 | 1.7754 | 14.203 | 1.1861 |
9 | 2 | 1.7492 | 15.743 | 1.4607 |
10 | 2+100 =102 | 87.89 | 878.9 | 89.706 |