Question: Can you please show process in Excel? C. The annual growth rate in EPS is 5%. The P/E ratio is 12x. EPS last year was

Can you please show process in Excel?
C. The annual growth rate in EPS is 5%. The P/E ratio is 12x. EPS last year was $1.00. What should the stock price be in 5 years? (3) d. Find the price today of a stock that will pay dividends as follows: Next year: $2.00 Two years from now: $2.15 (8) Beginning in year three the dividend will begin to grow constant at 3%. So the year 3 dividend is $2.21. The discount rate is 10% You should use the year three dividend in the constant growth model to find a future stock price. Find the present value of that price, along with the present value of the first two divdends to solve for the price today. Show you work below or to the right of the green column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
