please show how to solve in msft excl with simple steps

11. A 2-year maturity bond with face value of $1,000 makes annual coupon payments of $80 and is selling at face value. What will be the rate of return on the bond if its YTM at the end of the year is... 6% b. 8% 10% a. c