Question

Solve using excel SHOES "R" US has bonds on their balance sheet in the amount of $5,000,000 in book value. Those bonds mature |

in six years. The Company is thinking of buying the bonds back now because yields are 3% while their bond pays 7% |

annually. |

1. What should be the price in the market of 1 SHOES "R" US bond today? |

2. How much money would SHOES "R" US need to raise to return the entire amount of bonds outstanding? |

Answer #1

Price of the bond is the present value of all the future cash flows discounted at the yield to maturity

Price of the bond = Face value / ( 1 + yield to maturity)^n + coupon [ 1 - ( 1 + r ) ^-n] / r

where n = years to maturity

r = yield to maturity

Price = 1000 / 1.03^6 + 70 * [ 1 - 1.03^-6] / 0.03

= 1000 / 1.194052297 + 70 *( 1 - 1/1.03^6 ) / 0.03

= 837.48 + 70 ( 1 - 1 / 1.194052297) / 0.03

= 837.48 + 70* 5.417191467

= $1216.68

Amount of money would SHOES "R" US need to raise to return the entire amount of bonds outstanding

= 5000000/ 1000 * 1216.68

= **$6,083,400**

Solve the following question by using the excel sheet on your
computer
If a bond pays $70 in one year and $140 in two years, its
present value is $200. Find the interest rate which equates the
price of the bonds with the future values discounted. Use in your
experiment 10 interest rates (hint: start your calculation
from interest rate =1%). Based on your results what is the
relationship between the interest rate and the price of the
bond?

Bank of America has bonds that have a 6.5% coupon, payable
annually, and mature in 5 years. If an investor has a required rate
of return of 4.3% per annum, compounded annually, what is the price
of the bond? What happens to the return if the investor pays more
or less than the amount calculated? Show steps of how to solve
using excel including the formulas and manually

2. Suppose you will receive $1,000 in 4 years. If your
opportunity cost is 6% annually, what is the present value of this
amount if interest is compounded every six months? (8 points) What
is the effective annual rate? (8 points) 3. Suppose you have
deposited $10,000 in your high-yield saving account today. The
savings account pays an annual interest rate of 4%, compounded
semi-annually. Two years from today you will withdraw R dollars.
You will continue to make additional...

What role could the governance of ethics have played
if it had been in existence in the organization? Assess the
leadership of Enron from an ethical perspective.
THE FALL OF ENRON: A STAKEHOLDER FAILURE
Once upon a time, there was a gleaming headquarters
office tower in Houston, with a giant tilted "£"' in front, slowly
revolving in the Texas sun. The Enron Corporation, which once
ranked among the top Fortune 500 companies, collapsed in 2001 under
a mountain of debt...

Discuss ethical issues that can be identified in this
case and the mode of managing ethics Enron finds itself in this
case. How would you describe the ethical culture and levels of
trust at Enron? Provide reasons for your assessment.
THE FALL OF ENRON: A STAKEHOLDER FAILURE
Once upon a time, there was a gleaming headquarters
office tower in Houston, with a giant tilted "£"' in front, slowly
revolving in the Texas sun. The Enron Corporation, which once
ranked among...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 11 minutes ago

asked 15 minutes ago

asked 16 minutes ago

asked 18 minutes ago

asked 20 minutes ago

asked 24 minutes ago

asked 25 minutes ago

asked 28 minutes ago

asked 29 minutes ago

asked 32 minutes ago

asked 36 minutes ago

asked 42 minutes ago