Purchase Solution

Calculating the value of a bond

Not what you're looking for?

Ask Custom Question

Assume Venture Healthcare sold bonds that have a ten-year maturity, a 12 percent coupon rate with annual payments, and a $1,000 par value.

a. Suppose that two years after the bonds were issued, the required interest rate fell to 7 percent. What would be the bond's value?
b. Suppose that two years after the bonds were issued, the required interest rate rose to 13 percent. What would be the bond's value?
c. What would be the value of the bonds three years after issue in each scenario above, assuming that interest rates stayed steady at either 7 percent or 13 percent?

Purchase this Solution

Solution Summary

Solution describes the steps to calculate the value of a coupon bond in the given scenarios. Calculations are carried out with the help of functions in MS Excel.

Solution Preview

Please refer attached file for better clarity of functions in MS Excel.

a. Suppose that two years after the bonds were issued, the required interest rate fell to 7 percent. What would be the bond's value?

Coupon amount=PMT=1000*12%=$120
Number of coupon payments left=NPER=8
Required interest rate=RATE=7%
Maturity amount=FV=$1,000
Bond value can be found by ...

Solution provided by:
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution


Free BrainMass Quizzes
Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.