Financial Analysis Using Excel: Bond Valuation
Not what you're looking for?
After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semi-annual payments):
Bond A Bond B
Settlement Date 12/15/2007 12/15/2007
Maturity Date 4/15/2014 6/15/2025
Coupon Rate 5.00% 9.50%
Price $890 $1,040
Face Value $1,000 $1,000
Required Return 7.25% 8.75%
a) Using the PRICE function, calculate the intrinsic value of each bond. Is either bond currently undervalued? How much accrued interest would you have to pay for each bond?
b) Using the YIELD function, calculate the yield to maturity of each bond using the current market prices
c) Using the DURATION function, which bond would you rather own if you expect market rates to fall by 2% across the maturity spectrum? What if rates will rise by 2%? Why?
Purchase this Solution
Solution Summary
This tutorial provides guidelines on how to calculate bond valuation on Excel.
Solution Preview
See the attached file. The text here may not print correctly. Look at the formulas in Excel file.
Bond Valuation
After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume SEMI-ANNUAL payments):
Bond A Bond B
Settlement Date 15/12/2007 15/12/2007
Maturity Date 15/04/2014 15/06/2025
Coupon ...
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
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.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
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.