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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!