please answer G

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 an 8% 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 a 10% annual coupon, matures in 12 years, and has a $1,000 face value. Each bond has a yield to maturity of 9%. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Use a minus sign to enter negative values, if any. If an answer is zero, enter " 0 ". Download spreadsheet Bond Valuation-e55f43.xlsx a. Before calculating the prices of the bonds, indicate whether each bond is trading at a premium, at a discount, or at par. g. Calculate the price of each bond (A,B, and C) at the end of each year until maturity, assuming interest rates remain constant. Round your answers to the nearest cent. Create a araph showina the time Dath of cach bond's value. Choose the correct araoh