Question
Mr. Clark is considering another bond, Bond D. It has a 8% semiannual coupon and a $1000 face value (i.e., it pays 40$ coupon every
Mr. Clark is considering another bond, Bond D. It has a 8% semiannual coupon and a $1000 face value (i.e., it pays 40$ coupon every 6 months). Bond D is schedualed to mature in 9 years and has a price of $1150. It is also callable in 5 years with a call price of $1040. 1. What is the bonds nominal yield to maturity? 2. What is the bonds nomianl yield to call?
I see that people say to use
A | B | C | D | E | F | |
1 |
|
|
|
|
|
|
2 |
|
|
|
|
|
|
3 |
| Face Value | 1000 |
|
|
|
4 |
| Coupon | 8% |
|
|
|
5 |
| PMT | 40 |
|
|
|
6 |
| Years to maturity | 9 |
|
|
|
7 |
| Market Price | 1150 |
|
|
|
8 |
| Years to Call | 5 |
|
|
|
9 |
| Call Price | 1040 |
|
|
|
10 |
|
|
|
|
|
|
11 |
| 1. YTM | 5.83% | =RATE(C6*2,C5,-C7,C3)*2 |
| |
12 |
|
|
|
|
|
|
13 |
| 2.YTC | 5.26% | =RATE(C8*2,C5,-C7,C9)*2 |
But could someone please explain to me the formula? like the (C6*2, part I don't understand why there are commas in the formula please help so I can do it right so i can get the 5.83 and 5.26 myself thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started