Following is information about bonds that are identical except for their terms to maturity:

Coupon Maturity Price Yield (%)

4.375 12/31/19 0.9892 5.50

6.000 12/31/20 1.0150 ?

5.250 12/31/21 ? 5.58

7.750 12/31/22 ? 5.54

5.375 12/31/23 0.9818 ?

December 31 every year.

Based on the given information, complete the computations and answer the questions that follow. All of the computations should be completed using the functions in a spreadsheet.

2. Using the spreadsheet function, draw the yield curve that is represented by the above information. Discuss and interpret the term structure of these rates.