(Problem must be answered in excel formulas)

Stone Sour Corp. issued 20-year bonds two years ago at a coupon rate of 7.1 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 par) Bond price (% of par) 1/1/2000 1/1/2018 7.10% 2 100 105 Complete the following analysis. Do not hard code values in your answers. Yield to maturity