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.

1. Compute the values Assume that today is January 2, 2019. Each bond pays interest semiannually, on June 30 and that are missing in the above table