I am really interested in question 3, but any help is appreciated.
1. Shown below are selected annualized spot interest rates, rt, for U.S. Treasury Strips for Monday, January
(in years) rt
(a) Calculate the price of a Strip for each maturity, per $100 of par value.
(b) Calculate the forward rates, ft, for t=2, 3, 4, and 5.
(c) Using the spot rates, calculate the price (per $100 par) of a Treasury note that matures in 5 years and has a coupon rate of 5.5% (assuming annual coupon payments).
(d) Calculate the yield to maturity on the bond in (c) above.
I plan to use the yield function in excel
(e) Calculate the modified duration (MD) of the bond in (c) above.
I plan to use excel's mduration function
Essentially, the price of your bond is equivalent to the sum of several zero-coupon bonds being paid off annually. In this case, your $100 face value bond that is worth $112.33 today is equivalent to getting $5.5 in periods plus $100 in period . In other words, you would get the same value if you had instead buy: (1) one $100 bond expiring five years from now plus (2) five $5.5 bonds, each expiring one year after another.
Note that in general, if the coupon rate is higher than the discount rate, the present value of the bond will be greater than its value (as in, it's sold at a premium).
To find the yield in part d, recall that the yield of a bond is sort of a weighted average of the spot rates. So to solve for yield, denoted by the variable "Y", solve:
I have not done the calculation, but I suspect that the yield should be close to the period 5 spot rate, as that is when the largest cash flow is placed (the payment of $100 face value). So the yield should be slightly below 2.86%.