complete the problems using Excel formula

P-3: Dilution effect of stock issue (LO15-3) American Health Systems currently has 6,400,000 shares of stock outstanding and will report earnings of $10 million in the current year. The company is considering the issuance of 1,700,000 additional shares that will net $30 per share to the corporation. o. b. What is the immediate dilution potential for this new stock issue? Assume that American Health Systems can eam 9 percent on the proceeds of the stock issue in time to include them in the current year's results. Calculate earnings per share. c. Should the new issue be undertaken based on earnings per share? P-4: Dilution effect of stock issue (to15-3) American Health Systems has 6,400,000 shares of stock outstanding and will report earnings of $10 milion in the current year. The company is considering the issuance of 1,700,000 additional shares, which can only be issued at $18 per share. c. Assume that American Heal th Systems can earn 6 percent on the proceeds. Calculate camings per share. b. Should the new issue be undertaken based on earnings per share