Discounted dividend model for constant growth stocks

Assignment Help Financial Management

Reference no: EM131552828

A. Using Apple stock. Utilizing Bloomberg (or other financial websites) as a source of data, collect the following information:

a. The stock’s Beta

b. The rate of return on the market (S&P 500 Index)

c. The risk-free rate ()

d. The last dividend paid ()

e. The annual expected growth rate of earnings

B. In Excel, use the Discounted Dividend Model for Constant Growth Stocks and solve for the intrinsic stock price ()

Based on your above calculations, compare the calculated price with the current market price and indicate whether is the stock price overvalued, undervalued, or at equilibrium? Explain.

C. Now, assume that your company has just released a new product and will be experiencing supernormal growth of 25% for the next three years. In Excel, use the information in “A” and the Discounted Dividend Model for Nonconstant Growth Stocks and solve for the intrinsic stock price ).

Reference no: EM131552828

Questions Cloud

Presented proposal for project : You are presented proposal for project. project costs $10 million and will produce after-tax cash flows of $2 million at the end of year 1,

You make last of your thirty investments : how much will you have on the day that you make the last of your thirty investments?

What should be the required rate of return : The market risk premium is 5% then according to the Capital Asset Pricing Model, what should be the required rate of return?

What is your annual rate of return : exclusive of leverage and transactions costs, what is your annual rate of return?

Discounted dividend model for constant growth stocks : In Excel, use the Discounted Dividend Model for Constant Growth Stocks and solve for the intrinsic stock price ()

Explain the limitations of loan appraisal : Please state and explain the limitations of loan appraisal.

Estimating the weighted average cost of capital : You are tasked with estimating the weighted average cost of capital for Lockheed Martin (ticker=LMT). Estimate the impact on the WACC.

Assume an interest rate for the whole time period : What is the annual payment you expect to receive beginning in year 21 if you assume an interest rate of 7 percent for the whole time period?

Hybrid electric vehicle-what is the payback of this project : Safi's Gluten-free bakery is thinking of buying a hybrid electric vehicle. What is the payback of this project?

User Account

All Pages