The Pioneer Corporation currently paid a $3.00 per share dividend on itscommon stock.Dividends are expected to grow forever at 3%, and investorsrequire a 12% rate of return.Pioneer's management is planning to enter new, risky markets to increase its expected dividend growth.However, in response tothe increased risk, the investors' required rate of return will increase to 15%.What must be the new value for the dividend growth to justify entering the new,risky markets and to keep the stock price from decreasing?

Please show/explain using excel