EXCEL ONLY

Problem 3: A firm can grow at a high rate of 15% for the next 5-years; and hence its dividends. It has an expected long-run constant dividend growth rate of 7%, and the most recent dividend Do, was $5.00. The required rate of return on the stock is 20%. Calculate the current price of the stock using "two-stage dividend growth model