Stone Sour Corp Issued 20 years Bonds. 2 years ago at a coupon rate of 7.1%. The bond make as semi-annual payment. If these bonds currently sell at 105% of Par value.

Using Excel Formula, 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

Complete the Following : YTM = ?

My excel given sheet doe not allow me to calculate the Rate as you did. It only asked to calculate YTM, and only YTM yellow box is allowed. My question to you is that How can I calculate YTM directly using Excel, and by passing the rate formula? or any formula to calculate YTM using the rate formula and multiply time 2 inside that formula?