using only cell references. I am not sure how to get payments.

Suppose a 10-year, $1,000 bond with an 8% coupon rate and semiannual coupons is trading for $1,034.74 What is the bond's yield to maturity (expressed as an APR with semiannual compounding)? a. b. If the bond's yield to maturity changes to 9% APR, what will the bond's price be? Maturity (years) Face value Coupon rate Bond price 10 $ 1,000 8% S 1.034.74 a. What is the bond's yield to maturity (expressed as an APR with semiannual compounding)? Coupon Number of periods Yield to maturity b. If the bond's yield to maturity changes to 9% APR, what will the bond's price be? Yield to maturity 996 Semiannual yield Bond price