Question
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
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started