Can Someone help me out with this problem ? I need to see excel formulas for it also. Thank you!

Problem 1 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 $1,000 face value. -Bond B has a 9% annual coupon, matures in 12 years, and has $1,000 face value -Bond C has an 11% annual coupon, matures in 12 years, and has $1,000 face value. Each bond has a yield to maturity of 9%. a. Before calculating the prices of the bonds, indicate whether each bond is trading at a premium, at a discount, or at par. b. Calculate the price of each of the three bonds. C. If the yield to maturity for each bond remains at 9%, what will be the price of each bond 1 year from now? d. Mr. Clark is considering another bond, Bond D. It has an 8% semiannual coupon and a $1,000 face value Bond D is scheduled to mature in 9 years and has a price of $1,150. Calculate YTM for the bond