Hello, can I get a step by step solution using excel to this problem??? Thank you!

Consider Pacic Energy Company and Atlantic Energy, Inc., both of which reported earnings of $962,000. Without new projects, both rms will continue to generate earnings of $962,000 in perpetuity. Assume that all earnings are paid as dividends and that both rms require a return of 12 percent. a. What is the current PE ratio for each company? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Pacific Energy Company has a new project that will generate additional earnings of $112,000 each year in perpetuity. Calculate the new PE ratio of the company. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 3216) c. Atlantic Energy has a new project that will increase earnings by $212,000 in perpetuity. Calculate the new PE ratio of the firm. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) \" a um am