Problem
What excel formulas would you use to solve the following:
LLOP Corporation just paid a $4 dividend per share, you expect the dividend to grow at 8% for the next 2 yearsand expect to sell the stock at $50 at the end of year 2. What is the maximum price you would pay to buy the stock? The required rate of return is 15%.
The risk-free rate is 4%; the market risk premium is 8%. VVH Company's stock has a beta of 3. The lastdividend was $4 per share. The dividend is expected to grow at 5%. What is the expected price of the stock?