Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Municipal Finances A Handbook For Local Governments

Authors: Catherine D. Farvacque-Vitkovic, Mihaly Kopanyi

1st Edition

ISBN: 082139830X, 978-0821398302

More Books

Students also viewed these Finance questions

Question

What is job rotation ?

Answered: 1 week ago