Problem 14-23

A 2-year bond with par value $1,000 making annual coupon payments of $118 is priced at $1,000.

a. What is the yield to maturity of the bond? (Round your answer to 1 decimal place.)

b. What will be the realized compound yield to maturity if the 1-year interest rate next year turns out to be (i) 8%, (ii) 11%, (iii) 14%? (Round your answers to 2 decimal places.)

If you can do this in excel that would be appreciated for part B