use Excel to do the calculations

4. (25 points) Juggernaut Satellite Corporation earned $24 million for the fiscal year ending yesterday. The firm also paid out 35 percent of its earnings as dividends yesterday. The firm will continue to pay out 35 percent of its earnings as annual, end-of-year dividends. The remaining 65 percent of earnings is retained by the company for use in projects. The company has 2 million shares of common stock outstanding. The current stock price is $95. The historical return on equity (ROE) of 14 percent is expected to continue in the future. What is the required rate of return on the stock