Question: a ) A bond has 1 5 years left to maturity. The annual coupon rate is 9 % , and face value is $ 1

a)
A bond has 15 years left to maturity. The annual coupon rate is 9%, and face value is $1,000. If the YTM =12%, what is the bond price?
b) An annual coupon bond has coupon payment = $500, YTM =8%, and maturity =5 years. If the price ofthe bond is $9,400, what must be the face value?
c)A bond has 15 years left to maturity. The semi-annual coupon rate is 9%, and face value is $1,000. If the YTM =12%, what is the bond price?
for all 3 parts please show all calculations via excel, and how you got them in excel (formulas). thanks.

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!

Q:

510. Definitions for a multicomponent flash are as follows: x, yi liquid and vapor mole fractions, respectively = feed mole fraction Zj K =y/x-equilibrium constant L,V, F liquid, vapor, and feed...

Q:

You just paid out the $4 dividend and it is expected to grow at 5% annually, and your stock price is $24 with 5 million outstanding shares. You also issued a bond that has ten years left to maturity...

Q:

No excel 2. You just paid out the $4 dividend and it is expected to grow at 5% annually, and your stock price is $24 with 5 million outstanding shares. You also issued a bond that has ten years left...

Q:

2. You just paid out the $4 dividend and it is expected to grow at 5% annually, and your stock price is $24 with 5 million outstanding shares. You also issued a bond that has ten years left to...

Q:

What is the correct formula for B9? Choose all that apply. A B Bond Valuation 1 2 Settlement Date 3 Maturity Date 4 Coupon Rate Face Value 5 6 Frequency 7 Basis 8 Price 9 Yield to Maturity 10...

Q:

PLEASE SHOW WORKING. A. An asset yields the following year-end cash flows: $8,000 per year for years 1-3; $10,000 per year for years 4-7; $12,000 per year for years 8-15; $15,000 per year for years...

Q:

Part I Bonds Assume that all bonds have a face value of $1,000 unless otherwise noted. 1. What is the price of a 30-year, zero coupon bond with a YTM of 5%? 2. Take the bond above and add an annual...

Q:

a ) A bond has 1 5 years left to maturity. The annual coupon rate is 9 % , and face value is $ 1 , 0 0 0 . If the YTM = 1 2 % , what is the bond price? b ) An annual coupon bond has coupon payment =...

Q:

a ) A bond has 1 5 years left to maturity. The annual coupon rate is 9 % , and face value is $ 1 , 0 0 0 . If the YTM = 1 2 % , what is the bond price? b ) An annual coupon bond has coupon payment =...

Q:

You have just purchased a 10-year zero-coupon bond with a yield to maturity of 10% and a par value of $1,000. What would the rate of return on your investment at the end of the year be if you sold...

Q:

A bond has coupon rate=5%, YTM=8%, and maturity=5 years. If the price of the bond is $10,000, what must be the face value? A stock pays a quarterly dividend of $5. The first dividend will be received...

Q:

As a securities analyst you have been asked to review a valuation of a closely held business, Wigwam Autoparts Heaven, Inc. (WAH), prepared by the Red Rocks Group (RRG). You are to give an opinion on...

Q:

Determine the tension in the cord and the horizontal and vertical components of reaction at support A of the beam in Prob. 54.

Q:

Investors make arbitrage profit, if: Select one: a . Arbitrage profit does not exist in forward contracts b . The forward price deviates from the theoretical price ( F 0 = S 0 ert ) . c . The forward...

Q:

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Q:

Have you ever had a sense that a speaker was intentionally leaving some information out or that the information was somehow unreliable? How did it make you feel about the speaker? Did it change the...

Q:

10. Is your speech within the required time limits for the assignment?

Q:

After you have practiced in front of one or more friends, family members, or classmates, consider their feedback. Was anything about the feedback surprising? Did they note the strengths and...