Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate financial planner has suggested the following bonds bonds. His Bond A has a 7% annual coupon, matures in 12 years, and has a $1,000 face value. 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 value. Each bond has a yield to maturity of 9%. Before calculating the prices of the bonds, indicate whether each bond is trading at a premium, at a discount, a. Bond A is trading at a discount. Bond B is trading at Par Bond C is trading at a premium. Work parts b through e with a spreadsheet. You can also work these parts with a calculator to check your spreadsheet answers if you aren't confident ofy part g with the sprea our sprea dsheet solution.You must th en go on to work dsheet. b. Calculate the price of each of the three bonds. Basic Input Data Years to maturity Periods per year Periods to maturity Coupon rate Par value Periodic payment Yield to maturity Bond ABond B Bond C 12 12 12 12 7% $1,000 $70 9% 12 9% $1,000 $90 9% 11% $1,000 $110 9% $856.79$1.000.00$1,143.21 c. Calculate the current yield tor each of the three bonds. (Hint: Keter to Footnotetor the detinition of the current eld and to Tahle 7.1.) Current yield-Annual coupon/Price Current yield- d. If the yield to maturity for each bond remains at 9%, what will be the price of each bond 1 year from now? Bond ABond B 8, 1 7% Bond C 9.62% 9.00% What is the expected capital gains yield for each bond? What is the expected total return for each bond? Basic Input Data Years to maturity Periods per year Periods to maturity Coupon rate Par value Periodic payment Yield to maturity Bond ABond B Bond C 7% $1,000 $70 9% 9% $1,000 $90 9% 11% $1,000 $110 9% Expected CG Yield- Expected Total Return