Please using Excel Software!!

Please using Excel Software!!

1) Hope Industries just paid a dividend of $2.00 per share (i.e., D0 = $2.00). Analysts expect the company's dividend to grow 40 percent this year, and 20 percent in second year. After two years the dividend is expected to grow at a constant rate of 6 percent. The risk free rate is 4% and expected market risk premium is 6% and the rm is twice as risky as market. First calculate the current stock price using Excel. If the target price of the company's stock is $80.00, what should be the expected stable constant growth rate after two years? You must use "Goal Seek" command in Excel and show me the screen shot. (5 points) Hint: First, solve the problem as it is and use the "Goal Seek" from "What-If Analysis". You can start from "Ch7 dividend discounted model