The following table contains the six-year EPS history for Corporation X. The dividend payout ratio is 30%.

Year	EPS
2013	0.75
2014	0.78
2015	0.81
2016	0.82
2017	0.85
2018	0.90

5) How does the calculated intrinsic value compare to the current stock price of $5? Use IF statement.

Answer:

Enter "Overvalued", "Undervalued" or "fairly-valued".

6) Use the Goal Seek or Solver option to find the dividend growth rate which will make the stock fair-valued (i.e., current stock price = intrinsic value).