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

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= 1/1/2000

Maturity Date= 1/1/2018

Annual Coupon Rate =7.10%

Coupon per Year=2

Face Value(%of Par)=100

Bond Price (%of Par)=105

Calculate Yield to Maturity in Excel using above Information. Provide excel formula