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 Vield to maturity of 8.4%. Bond C pays a 10% annual coupon, while Bond 2 is a zero coupon bond. The data has been collected in the Micro Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. THITHI Open spreadsheet Assuming that the yield to maturity of each bond remains at 8,4% 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. Years to Maturity Price of Bond C Price of Bond Z $ I $ $ 3 $ N $ $ 1 $ s 0 $ Excel template Search (Alto File Home Insett Draw Page Layout Formulas Data Review View Help Editing Arial 10 B G A y Currency 39 -10 B D G Bond valuation 1 2 3 4 5 6 7 Length of maturity in years Face value Yield to maturity Annual coupon Bond C 4 $1,000 8.40% 10.00% Bond Z 4 $1,000 8.40% 0.00% Formulas Price of Bond C Price of Bond 2 9 10 Yearn to Maturity 4 3 2 Price of Bond Z WNIA Price of Bond C NIA NIA NIA WNIA 12 #N/A NIA WNIA WNIA WNIA 15 Time Paths of Bonds C and Z 16 19 20 Bond Value 5550 20 Sheet + Calculation Mode: Automatic Woo Static a ** A o li Type here to search