Download the data on prices and coupon rates for 6 government bonds maturing in consecutive six-month intervals. The first payment of each of these bonds should come in approximately 6 months. For example, if today’s date is March 2nd, 2016, the first bond should mature on August 31st, 2016, the second on February 28th of 2017, and so on. [1]
Convert price quotes into the actual prices (multiply by 10).
Convert annual coupon rates into the actual semi-annual coupons, expressed in dollars.
Show the cash flow table (time line) for your bonds. This table should organize each payment of each bond according to the time when it will be paid.
Using the same bootstrapping method as in the example on pages 8--10 of your Review of Bond Concepts handout, calculate the first six rates of the term structure of interest rates.
Show equations which you used to find each of the six rates with the data plugged into them (use Insert – Equation in Word to type your equations).
Present annualized rates.
Using Excel Chart menu, “draw” the graph of the term structure: time on the horizontal axis, corresponding term structure rates on the vertical axis. Is it increasing or decreasing?
Briefly explain your findings: Comment on the implications of the observed term structure for the economic conditions as perceived by market participants.
In the report for the second empirical part of this LE, show price conversion (the actual price of the bond for the actual $1000 of face value), coupon calculations (i.e. from the coupon rate to the dollar amount), cash flow table (i.e time line), all your calculations for the term structure rates, graph of the term structure and explanations. Report (including all equations) should be typed.
[1] Notice that bonds that mature on March 15th and September 15th of any year are not a good choice here since all of them will pay coupons on March 15th 2016 (i.e. 13 days from now and not six months).