What is fair value of bond using Excel to calculate.
Not what you're looking for?
A $1,000 face value bond has a remaining maturity of 10 years and a
required return of 9%. The bond's coupon rate is 7.4%. What is the fair value of this bond?
Using a financial calculator:
Number of years (N) = 10, future value (FV) = 1000, interest rate (I/YR) = 9
To calculate the annual payment: 0.074 * 1000 = 74 = PMT (in calculator terminology)
After pressing CPT to compute the price of the bond, then press PV.
Therefore, the fair value of the bond is $897.32.
Please prepare response in Excel.
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation to answer what is fair value of bond using Excel to calculate.
Purchase this Solution
Free BrainMass Quizzes
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the 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.
Operations Management
This quiz tests a student's knowledge about Operations Management
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.