excel formula

Stone Sour Corp.issued 20-year bonds two years ago at a coupon rate of 71 percent. The bonds make semiannual payments. If these bonds currently sell for 105 percent of par value what is the YTM? Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of pary Bond price (% of par) 1/1/2000 1/1/2018 17.10% 2 100 105 Complete the following analysis. Do not hard code values in your answers. 7 8 Yield to maturity 19 20