Valuing Firms Stocks And Bonds In Excel
Not what you're looking for?
The meeting with Bob went well. Now Kim wants you to turn your focus to valuing the firm's stock and bonds. She likes to use the dividend discount model to value the firm's stock and the present value formula to value bonds.
With that in mind, you decide to put an Excel spreadsheet together to value the firm's stock and bonds. The company's stock trades for US$30 per share, with an annual dividend payment of US$1.67, which is expected to grow to US$1.75 next year. The required return on stocks is 12%, and the dividend is expected to increase by 5% for the foreseeable future. The bonds you are valuing have 3 years to maturity, a 6% annual coupon, and a face value of US$1,000. The market interest rates are 5%.
Use Microsoft Excel to calculate the value of the stocks and the bonds. In addition, answer these questions:
At the current trading price of US$30 per share, is the dividend discount model value of the stock equal to the market value? If they are different, explain why.
At the face value of US$1,000, is the bond trading price greater than, equal to, or less than its face value? Explain your answer.
Your submission should include the Excel spreadsheet and explanation slides of your analysis and answers to the two additional questions.
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation in an excel spreadsheet and 5 pages in powerpoint.
Purchase this Solution
Free BrainMass Quizzes
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.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media