1. 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 todays 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] Maturity Coupon Bid Asked

Maturity	Coupon	Bid	Asked	Chg	Asked yield
4/15/2018	0.750	99.7344	99.7500	-0.0078	1.240
10/15/2018	0.875	99.4453	99.4609	-0.0234	1.412
4/15/2019	0.875	99.1016	99.1172	-0.0156	1.467
10/15/2019	1.000	98.9531	98.9688	-0.0391	1.522
4/30/2020	1.125	98.8047	98.8203	-0.0234	1.598
10/31/2020	1.375	99.0781	99.0938	-0.0234	1.680

a. Convert price quotes into the actual prices (multiply by 10).

b. Convert annual coupon rates into the actual semi-annual coupons, expressed in dollars.

c. 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.

d. 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.

1. 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).

2. Present annualized rates.

e. 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?

g. 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).