An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8%. Bond C pays a 11.5% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Assuming that the yield to maturity of each bond remains at 8% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent. 69 $ Years to Maturity Price of Bond C Price of Bond Z 4 $ 3 2 1 $ 69 69 69 S 3+ $ 69 $ $ 69 60 B