Calculating the value of a bond
Not what you're looking for?
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 ...
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.