In: Finance
Assume that the 1-year zero-coupon bond is sold at $88.97 and the yields to maturity for the coupon bonds selling at market prices equal to their face values are 12% and 14% for 1-year and 1.5-year issues respectively. Coupons are paid every 6 months and face values are $100 for all the bonds.
(a) Calculate the spot rate curve (s0.5, s1, s1.5).
(Keep your answer in decimal format 4 decimal places, e.g. 0.1234. Do not give in percent format e.g. 12.34%.)
s0.5: s1: s1.5 :
(b) Compute the quasi-modified duration for each of these bonds. (Keep 2 decimal places, e.g. xx.12.)
Zero-coupon bond:
12% coupon bond:
14% coupon bond:
(c) Determine the current price of an 10% coupon bond with face value $100 and 18 months to maturity. (Keep 2 decimal places, e.g. xx.12.)
Part (a)
Let S0.5, S1, S1.5 be the spot rates. Then,
1-year zero-coupon bond is sold at $88.97
Hence, 88.97 = 100 / (1 + S1 / 2)2
Hence, S1 = [(100/88.97)1/2 - 1] x 2 = 0.1204
The yields to maturity for the coupon bonds selling at market prices equal to their face values are 12% and 14% for 1-year and 1.5-year issues respectively. For bonds selling at par, coupon rate = yield
Hence, for the one year bond, coupon per period = 12% / 2 x 100 = 6% = 6
Price = 100 = 6 / (1 + S0.5 / 2) + 106 / (1 + S1 / 2)2 = 6 / (1 + S0.5 / 2) + 106 / (1 + 0.1204/ 2)2
Hence, S0.5 = 0.1083
For the one and half year bond, coupon per period = 14% / 2 x 100 = 7
Price = 100 = 7 / (1 + S0.5 / 2) + 7 / (1 + S1 / 2)2 + 107 / (1 + S1.5 / 2)3 = 7 / (1 + 0.1083 / 2) + 7 / (1 + 0.1204/ 2)2 + 107 / (1 + S1.5 / 2)3
Hence, S1.5 = 0.1417
Hence, spot rate curve is:
S0.5 = 0.1083
S1 = 0.1204
S1.5 = 0.1417
---------------------------------------------
Part (b)
I have used Excel to get the quasi modified duration.
Please see the table below. The column highlighted in yellow contains your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.
Part (c)
Coupon per period = 10% / 2 x 100 = 5
Hence, Price = 5 / (1 + S0.5 / 2) + 5 / (1 + S1 / 2)2 + 105 / (1 + S1.5 / 2)3 = 5 / (1 + 0.1083 / 2) + 5 / (1 + 0.1204 / 2)2 = 105 / (1 + 0.1417 / 2)3 = $ 94.69