Answer has to go in the table. I need help with the values that go in each section of the spreadsheet

2. Show the cash flows and prices for the following four bonds, each with a par value of $1,000 and paying interest semi-annually: # Coupon Rate Years to Maturity Market Yield A 1.8% 10 3.90 B 4.2% 6 5.2 7.1% 5 4.4 D 0.0% 9 9 5.4 B C. D Answer Yield Price 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0