Ercel Activity: Bond Valuation CEfford Clark is a recent retiree who is interested in investing seme of his savings in corporate bends. His financial planner has suggested the following bonds: - Bond A has a 12% annual coupon, matures in 12 years, and has a $1,000 face value. - Bond B has a 6% annual coupon, matures in 12 years, and has a $1,000 face value. - Bond C has a 9% annual coupon, matures in 12 years, and has a $1,000 face value. Each bond has a yieid to maturity of 9 th- The data has been colected in the Microsoft Excel tle below. Downioad the spreadsheet and perform the required analysis to answer the questions beiow. Do net round intermediate calculations. Use a minus sign to enter negative values, If asy. If an answer is zero, enter "or, Darmisad sareadsheet Bood valvation=-5-1a28. x/3x a. Before calculating the prices of the bonds, indicate whether each bond is tradieg at a premium, at a decceunt, or at part t. Calculate the price of each of the three bones. Round your answers to the nearest cent. Price (Bond A): $ Price (Eond B): $ Price (Bond C): $ c. Calculate the current yield for each of the three bonds. (Hint: The expected current vield is calculated as the annual interest divided by the price of the bond.) Round your answers to two decimal places. Current vield (Hend A): Current yield (Bond B): Current yield (Bend C): d. If the yield to maturity for each bond remains at 9%, what will be the price of each bend 1 year from now? Reund your answers to the nearest cent. Price (Bond A): $ Price ( Bons B):1 Price (Bond C): $ What is the expected capital gains yieid for each bond? What is the expected total return for each bond? Round your answers to two decimal places