Calculating average return of an investment in a bond
Not what you're looking for?
Suppose an 8% coupon, ?1000 face value, 30-year bond that makes semiannual coupon payments is selling ?1276.76. What average rate of return would be earned by an investor purchasing this bond at this price?
Purchase this Solution
Solution Summary
The solution describes the methodology to calculate average return earned on an investment in a coupon paying bond by using functions in MS Excel and without using MS Excel.
Solution Preview
Please refer attached file for calculating Return by using Excel. Following is the methodology to calculate average return without using MS Excel.
Solution :
Mathematically price of a bond is defined as summation of all PV's of all future payments
No. of periods=60
Coupon payment=40
Price=1276.76
Sum of all PVs of future ...
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
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.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.