Please show all steps, if done in excel that would be preferred. Thank you.

10. Suppose that a bond makes annual coupon payments at a 7% coupon rate, has 10 years until maturity, and is currently trading to yield 6%. If the yield to maturity on the bond remains unchanged over the next year, what will be the capital gains return on the bond over the period