please solve :

- please use the same format when solving the problem.

- show on excel

- show work

- show formulas

-explain

Thank you!

P9-17M (see problem below for revisions) The 20-year, $1,000 par value bonds of Waco Industries pay 6 percent annual interest and makes interest payments on a semiannual basis. The market price of the bond is $925, and the market's required yield to maturity on a comparable-risk bond is 6.5 percent. a. Compute the bond's Yield to Maturity. b. Determine the value of the bond to you given the market's required yield to maturity on a comparable-risk bond. c. Should you purchase the bond? a. Coupon rate PV (market price) Par (FV) PMT (semi-annual) Nper (years) Frequency (m) Rate (calculate) YTM (annual rate ) b. Coupon rate Par (FV) PMT (semi-annual) Nper (years) Frequency (m) Rate YTM Yield to maturity on a comparable bond PV (calculate price)