Calculate the YTM using excel formula and cells.

Settlement date = D7

Maturity date= D8

Annual coupon rate = D9

Coupons per year = D10

Face value = D11

Bond Price = D12

A1 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 10 12 13 14 15 16 17 18 19 20 21 Complete the following analysis. Do not hard code values in your answers Yield to maturity Sheet1 | 100%