Consider the following information about XYZ Company: The investor's required rate of return is 10 percent The expected level of earnings at the end of the year (E) is $10: Return on equity (ROE) is 14 percent Similar shares of stock sell at multiples of 14.44 times earnings per share. 1. Consider that the company will distribute $3 in dividend. Determine the expected growth rate for dividends. 2. Estimate the stock price using the dividend discount model 3. Consider now that the company increases the dividend to $5 per share. Re-estimate the value of the stock 4. Would you recommend the change of dividend 5. Estimate the stock value using the P/E ratio valuation method (method of the multiples). 6. Explain the difference between the two estimates Excel sheet