Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financlal planner has suggested the following bonds: - Bond A has a 6% annual coupon, matures in 12 years, and has a $1,000 face value. - Bond B has a 10% annual coupon, matures in 12 years, and has a $1,000 face value. - Bond Chas a 14% annual coupon, matures in 12 years, and has a $1,000 face value. tach bond has a yield to maturity of 10%.. The data has been collected in the Microsoft Excel fite below. Downioad the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Use a minus sign to enter negative values, if any. If an answer is zero, enter " 0 ", 9. Calculate the price of each bond (A,B, and C) at the end of each year until maturity, assuming interest rates remain constant. Round your answers to the nearest cent