troel Oniline 5 tructured Activity. Bond valuation An ivvestor has two bonds in her portelio, Bond C and Bond Z. Each bond matures in 4 yarm. has a face value of $1, o00, and has a yield to maturity of A.9es. Bsnd C paps a 11.5Ne annual ceuson, while Bond Z is a zere coupen bond. The data has been collected in the Microsoft Excel Dritine file below, Open the spreadsheet and perform the required analysis to ansier the questions below. Copen sprendehet Assuming that the yield to maturity of each bone memairs at 8.9% over the next 4 years, caleulate the price of the bonds at each of the fallowing years to mabu fity. Do not round intemediate calculations: Round your answers to the nearest cont