** please answer in excel format please! thank you

What is the yield to maturity on a 10-year, 9% annual coupon, $1,000 par value bond that sells for $887.00? That sells for $1,134.20? N PMT FV PRICE N PMT FV PRICE YTM YTM How does the equation for valuing a bond change if semiannual payments are made? Find the value of a 10-year, semiannual payment, 10% coupon bond if nominal ra = 13%. Periods per year = N I/YR CPN % FV PRICE