In: Finance
b) Calculate the missing spot rates for the following Treasury yields. (All yields are shown on a bond equivalent basis). All the securities maturing from 1.5 years on are selling at par. The 0.5 and 1.0-year securities are zero-coupon instruments.
Year (Period) |
Yield to Maturity (%) |
Spot Rate (%) |
0.5 (1) |
4.00 |
4.00 |
1.0 (2) |
4.25 |
4.25 |
1.5 (3) |
4.50 |
4.51 |
2.0 (4) |
4.75 |
4.78 |
2.5 (5) |
5.00 |
? |
3.0 (6) |
5.25 |
5.32 |
3.5 (7) |
5.50 |
5.58 |
4.0 (8) |
5.75 |
5.85 |
4.5 (9) |
6.00 |
6.12 |
5.0 (10) |
6.25 |
? |
Since the Bonds are trading at par, the coupopon rate = yield to maturity
For 2.5 year bond
Coupon per period = (Coupon rate / No of coupon payments per year) * Face value
Coupon per period = (5% / 2) * $100
Coupon per period = $2.5
Bond Price = Coupon / (1 + 0.5 year spot rate / 2)1 + Coupon / (1 + 1 year spot rate / 2)2 + Coupon / (1 + 1.5 year spot rate / 2)3 + Coupon / (1 + 2 year spot rate / 2)4 + Coupon / (1 + 2.5 year spot rate / 2)5 + Face value / (1 + 2.5 year spot rate / 2)5
$100 = $2.5 / (1 + 4% / 2)1 + $2.5 / (1 + 4.25% / 2)2 + $2.5 / (1 + 4.51% / 2)3 + $2.5 / (1 + 4.78% / 2)4 + $2.5 / (1 + 2.5 year spot rate / 2)5 + $100 / (1 + 2.5 year spot rate / 2)5
90.5391 = 102.5 / (1 + 2.5 year spot rate / 2)5
(1 + 2.5 year spot rate / 2)5 = 102.5 / 90.5391
(1 + 2.5 year spot rate / 2)5 = 1.1321
(1 + 2.5 year spot rate / 2) = (1.1321)(1/5)
(1 + 2.5 year spot rate / 2) = 1.02512
2.5 year spot rate / 2 = 0.02512
2.5 year spot rate = 5.025 or 5.03%
For 5 year bond
Coupon per period = (Coupon rate / No of coupon payments per year) * Face value
Coupon per period = (6.25% / 2) * $100
Coupon per period = $3.125
Bond Price = Coupon / (1 + 0.5 year spot rate / 2)1 + Coupon / (1 + 1 year spot rate / 2)2 + Coupon / (1 + 1.5 year spot rate / 2)3 + Coupon / (1 + 2 year spot rate / 2)4 + Coupon / (1 + 2.5 year spot rate / 2)5 + Coupon / (1 + 3 year spot rate / 2)6 + Coupon / (1 + 3.5 year spot rate / 2)7 + Coupon / (1 + 4 year spot rate / 2)8 + Coupon / (1 + 4.5 year spot rate / 2)9 + Coupon / (1 + 5 year spot rate / 2)10 + Face value / (1 + 5 year spot rate / 2)10
$100 = $3.125 / (1 + 4% / 2)1 + $3.125 / (1 + 4.25% / 2)2 + $3.125 / (1 + 4.51% / 2)3 + $3.125 / (1 + 4.78% / 2)4 + $3.125 / (1 + 5.03% / 2)5 + $3.125 / (1 + 5.32% / 2)6 + $3.125 / (1 + 5.58% / 2)7 + $3.125 / (1 + 5.85% / 2)8 + $3.125 / (1 + 6.12% / 2)9 + $3.125 / (1 + 5 year spot rate / 2)10 + $100 / (1 + 5 year spot rate / 2)10
75.3030 = 103.125 / (1 + 5 year spot rate / 2)10
(1 + 5 year spot rate / 2)10 = 102.5 / 75.3030
(1 + 5 year spot rate / 2)10 = 1.3695
(1 + 5 year spot rate / 2) = (1.3695)(1/10)
(1 + 5 year spot rate / 2) = 1.03194
5 year spot rate / 2 = 0.03194
5 year spot rate = 6.388 or 6.39%