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