Fill in the yellow shaded cells below. Greg Greely 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 yield to maturity of $9\%.1.$ Before calculating the prices of the bonds, indicate whether each bond is trading at a premium, at a discount, or at par. Bond A is selling at a discount because its coupon rate $(7\%)$ is less than the going interest rate $($YTM $=9\%).$ Bond B is selling at par because its coupon rate $(9\%)$ is equal to the going interest rate $($YTM $=9\%).$ Bond C is selling at a premium because its coupon rate $(11\%)$ is greater than the going interest rate $($YTM $=9\%).$ 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. $2.$ Calculate the price of each of the three bonds by filling in the yellow shaded cells below. Basic Input Data Bond A Bond B Bond C Years to maturity Periods per year Periods to maturity Coupon rate Par value Periodic payment Yield to maturity VB$0=$ $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$