Transcribed Image Text
Excel Online Structured Activity: Bond valuation An investor hastwo bonds in her portfolio, Bond C and Bond Z. Each bond matures in4 years, has a face value of $1,000, and has a yield to maturity of9.1%. Bond C pays a 10.5% annual coupon, while Bond Z is a zerocoupon bond. The data has been collected in the Microsoft ExcelOnline file below. Open the spreadsheet and perform the requiredanalysis to answer the questions below. Open spreadsheet Assumingthat the yield to maturity of each bond remains at 9.1% over thenext 4 years, calculate the price of the bonds at each of thefollowing years to maturity. Do not round intermediatecalculations. Round your answers to the nearest cent. Years toMaturity Price of Bond C Price of Bond Z 4 $ $ 3 $ $ 2 $ $ 1 $ $ 0$ $