SHOW ALL WORK PLEASE!! Sheel Inc. has 7 percent annual coupon (compounded semiannually) bonds on the...

SHOW ALL WORK PLEASE!!

Sheel Inc. has 7 percent annual coupon (compounded semiannually) bonds on the market with 22 years to maturity, and the par value of $1,000. At what price should the bonds be selling for if YTM is 5%? Had the bond been selling at $983.55, what would be the YTM (assuming the same coupon, maturity and par value)? Based on your answers above, what is the relationship between YTM and bond price?

Solutions

Expert Solution

Price of a bond is the present value of its cash flows. The cash flows are the coupon payments and the face value receivable on maturity

Price of bond is calculated using PV function in Excel :

rate = 5%/2 (Semiannual YTM of bonds = annual YTM / 2)

nper = 22 * 2 (22 years remaining until maturity with 2 semiannual coupon payments each year)

pmt = -1000 * 7% / 2 (semiannual coupon payment = face value * coupon rate / 2)

fv = -1000 (face value receivable on maturity)

PV is calculated to be $1,265.04

YTM is calculated using RATE function in Excel with these inputs :

nper = 22 * 2 (22 years remaining until maturity with 2 semiannual coupon payments each year)

pmt = 1000 * 7% / 2 (semiannual coupon payment = face value * coupon rate / 2)

pv = -983.55 (Current bond price. This is a negative figure as it is an outflow to the buyer of the bond)

fv = 1000 (face value of the bond receivable on maturity. This is a positive figure as it is an inflow to the bondholder)

The RATE calculated is the semiannual YTM. To calculate the annual YTM, we multiply by 2.

Annual YTM is 7.15%

The relationship between bond price and YTM is :

Higher the YTM, lower the bond price
Lower the YTM, higher the bond price
If YTM > coupon rate, bond price < par value of bond
If YTM < coupon rate, bond price > par value of bond

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Sheel Inc. has a 6 percent coupon (compounded semiannually) bonds on the market with 16 years...

Sheel Inc. has a 6 percent coupon (compounded semiannually) bonds on the market with 16 years to maturity, and the par value of $1,000. At what price should the bonds be selling for if TYM is 5%? Had the bond been selling at $919.50, what should be the YTM (assuming the same coupon, maturity, and par value)? Based on your answers above, what is the relationship between YTM and bond price? ***Please show all work***

A bond you are evaluating has a 7 percent coupon rate (compounded semiannually), a $1,000 face...

A bond you are evaluating has a 7 percent coupon rate (compounded semiannually), a $1,000 face value, and is 10 years from maturity. (LG 3-4) a. If the required rate of return on the bond is 6 percent, what is its fair present value? b. If the required rate of return on the bond is 8 percent, what is its fair present value? c. What do your answers to parts (a) and (b) say about the relation between required rates...

Enterprise, Inc. bonds have an annual coupon rate of 14 percent. The interest is paid semiannually...

Enterprise, Inc. bonds have an annual coupon rate of 14 percent. The interest is paid semiannually and the bonds mature in 14 years. Their par value is $1,000. If the market's required yield to maturity on a comparable-risk bond is 9 percent, what is the value of the bond? What is its value if the interest is paid annually? A. The value of the Enterprise bonds if the interest is paid semiannually is..

Enterprise,Inc. bonds have an annual coupon rate of13 percent. The interest is paid semiannually and the...

Enterprise,Inc. bonds have an annual coupon rate of13 percent. The interest is paid semiannually and the bonds mature in7years. Their par value is$1000If the market's required yield to maturity on a comparable-risk bond is 15percent, what is the value of the bond? What is its value if the interest is paid annually?a. The value of the Enterprise bonds if the interest is paid semiannually is $? (Round to the nearest cent.)

Calculate the effective annual rate for each. 6 percent compounded annually. % 6 percent compounded semiannually....

Calculate the effective annual rate for each. 6 percent compounded annually. % 6 percent compounded semiannually. % 6 percent compounded quarterly. % 6 percent compounded monthly. %

A bond you are evaluating has a 6.5 percent coupon rate (compounded semiannually), a $1,000 face...

A bond you are evaluating has a 6.5 percent coupon rate (compounded semiannually), a $1,000 face value, and is 10 years from maturity. (LG 3-4) a. If the required rate of return on the bond is 6 percent, what is its fair present value? b. If the required rate of return on the bond is 8 percent, what is its fair present value? c. What do your answers to parts (a) and (b) say about the relation between required rates...

Excey Corp. has 7 percent coupon bonds making annual payments with a YTM of 6.4 percent. The current yield on these bonds is 6.75 percent.

Problem 7-25 Finding the Bond Maturity [LO2]Excey Corp. has 7 percent coupon bonds making annual payments with a YTM of 6.4 percent. The current yield on these bonds is 6.75 percent.How many years do these bonds have left until they mature?

Hamilton, Inc. bonds have a coupon rate of 11 percent. The interest is paid semiannually, and...

Hamilton, Inc. bonds have a coupon rate of 11 percent. The interest is paid semiannually, and the bonds mature in 11 years. Their par value is $1,000. If your required rate of return is 9 percent, what is the value of the bond? What is the value if the interest is paid annually?

Hamilton, Inc. bonds have a coupon rate of 13 percent. The interest is paid semiannually, and...

Hamilton, Inc. bonds have a coupon rate of 13 percent. The interest is paid semiannually, and the bonds mature in 13 years. Their par value is $1,000. If your required rate of return is 8 percent, what is the value of the bond? What is the value if the interest is paid annually?

Hamilton, Inc. bonds have a coupon rate of 1414 percent. The interest is paid semiannually, and...

Hamilton, Inc. bonds have a coupon rate of 1414 percent. The interest is paid semiannually, and the bonds mature in 77 years. Their par value is $1 comma 0001,000. If your required rate of return is 1212 percent, what is the value of the bond? What is the value if the interest is paid annually?a. If the interest is paid semiannually, the value of the bond is $nothing. (Round to the nearest cent.)b. If the interest is paid annually, the...

Subjects