Question:
Suppose a ten-year, $1000 bond with an 8% coupon rate and semiannual coupons is trading for a price of $1,034.74. What is the bond's yield to maturity (expressed as an APR with semiannual compounding)? If the bond's yield to maturity changes to 9% APR, what will the bond's price be? Please show in excel.