Please answer questions C and D

nsive/Spreadsheet Problem BOND VALUATION Clifford Clark is a recent retiree who is interested in investi his savings in corporate bonds. His financial planner has suggestedthelow Bond A has a 7% annual coupon, matures in 12 years, and has a $1,000 f Bond B has a 9% annual coupon, matures in 12 years, and has a $1,000 face value . Bond C has an 11% annual coupon, matures in 12 years, and has a $1,000 face Each bond has a yield to maturity of 9%. 19 following bonds face value. Value a. Before calculating the prices of the bonds, indicate whether each bond is tradine a premium, at a discount, or at par. b. Calculate the price of each of the three bonds. c. Calculate the current yield for each of the three bonds. (Hint: Refer to footnote 7 for the definition of the current yield and to Table 7.1.) If the yield to maturity for each bond remains at 9%, what will be the price of each bond 1 year from now? What is the expected capital gains yield for each bond? What is the expected total return for each bond? d