Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financial planner has suggested the following bonds . 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 veld to maturity of 9%. Before calculating the prices of the bonds, indicate whether each bond is trading at a premium, at a discount, or at par a. 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 of your spreadsheet solution. You must then go on to work part g with the spreadsheet. b. Calculate the price of each of the three bonds. Basic Input Data Years to maturitv Periods per year Periods to maturitv Bond A Bond B Bond C 12 12 12 12 796 $1,000 $70 9% 12 9% S1,000 S90 9% 12 11% $1,000 $110 9% oupon rate Par value Periodic payment Yield to maturity BO