Please do this in Excel with formulas!

One bond has a coupon rate of 7.0%, another a coupon rate of 9.0%. Both bonds pay interest annually, have 5-year maturities, and sell at a yield to maturity of 8.0%.

If their yields to maturity next year are still 8.0%, what is the rate of return on each bond?

Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 1 decimal place.

Does the higher-coupon bond give a higher rate of return over this period?