Vide Excel One Structured Activity Bond valuation An investor has two Ends in her portiols, and C and Bond 2. Each bond matures is 4 years, has a face value of 1,000, and has a vild to maturity of 80% Bond C paysa 11.5% anual coupon, while und 2 is a wond The data has been collected in the Morisoft Excel Online file beton. Cpen the spreadsheit and performs the required analysis to awer the question Open spreadshest Assuring that the yield to maturity of each band remains at 8% over the next years, calculate the price of the bonds heart cont years to maturity. Do not round intermediate closed your answers to the Years to Maturity Price of Bond C Price of d 4 3 1 2 1 4 1 U Check My W P Bond valuation Length of maturity in years Face value Yield to maturity Annual coupon Years to Maturity 4 3210 Bond Value $350 $0 8 4 Bond C 4 $1,000 8.60% 11.50% Price of Bond C Bond Z 4 $1,000 8.60% 0.00% Price of Bond Z Price of Bond C #N/A #N/A #N/A #N/A #N/A Time Paths of Bonds C and Z 3 2 1 0 Years Remaining Until Maturity G Formulas H Price of Bond Z #N/A #N/A #N/A #N/A #N/A Bond C Bond 2