Purchase Solution

Determining The Fair Value of A Bond

Not what you're looking for?

Ask Custom Question

You purchased a $1,000 five percent coupon bond that matures in 10 years.

How much would your bond be worth if interest rates fall to 4% the day after you purchase the bond? What would the bond be worth in one year if interest rates fell to 4% at that point need calculations in excel

Purchase this Solution

Solution Summary

Using an Excel spreadsheet, this solution demonstrates and explains how to compute the fair value of a bond when the prevailing interest rate differs from the bond's coupon rate.

Solution Preview

I have solved the problem using the PV function in Excel. The purchaser of a bond purchases two income streams: the periodic interest payment (in this case, $50 per year) and the terminal face value payment (in this case, $1,000). Therefore, ...

Purchase this Solution


Free BrainMass Quizzes
Understanding Management

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

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Lean your Process

This quiz will help you understand the basic concepts of Lean.