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 $9\mathrm{.}1\%.$ Bond C pays a $10\mathrm{.}5\%$ annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.