Question 17. Random Company's most recent dividend was $1.55 with a dividend growth rate will be constant at 1.5% for 2 yrs. , after that point the dividends are estimated to grow at a 5.0% rate forever. If Random Company's required return (rs) is 12.0%.

a. What will be the dividends from Yr 1 to Yr 3?

b. Whats the best estimate of the stocks current value?

c. If the stock price currently is $50 per share. Would you recommend to BUY or SELL this stock?

Answer in Excel and please screenshot formulas.