Hurricane Corporation expects to grow its dividend by 5% per year. The current dividend is $2 per share. The required return is 8%.

A. What is the estimated value of a share of common stock?

B. If price is $40 and dividends were $1.50 per share but expected to grow at 4% per year, what would be the required rate of return?

Please use excel to answer. Thank you.