Excel Online Structured Activity: Bond valuation 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.1%. Bond C pays a 10.5% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online fle 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.1 calculations. Round your answers to the nearest cent. over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not found intermediate Years to Maturity Price of Bond C Price of Bond 2 1 Bond valuation Bond C Bond Z 4 Length of maturity in years Face value Yield to maturity Annual coupon $1,000 8.10% 10.50% $1,000 8.10% 0.00% 7 Formulas Price of Bond C Years to Maturity Price of Bond Z Price of Bond C #N/A #N/A #N/A #N/A #N/A Price of Bond Z #N/A #N/A #N/A #N/A #N/A Time Paths of Bonds C and Z Bond Value $350 -Bond C Bond Z - Years Remaining Until Maturity