in excel please and thank you!

5. (Measuring growth) Awesome Inc. has common stock that is selling for $230.77. It expects its next year's dividend to be $7.80. What is Awesome's expected growth rate if the discount rate is 11% ? 6. (Common stock valuation) You are looking to purchase BA Plastics common stock at $1.75 per share, hold it I year, and sell after a dividend of $.50 is paid. How much will the stock price have to increase to in order to satisfy your required rate of return of 20% and growth is expected at 7%