please answer all parts in excel.

thank you

does not NEED to be in excel

18-11 (similar to) EPS and postmerger price Data for Henry Company and Mayer Services are given in the following table !! Henry Company is considering merging with Mayer by swapping 1.35 shares of its stock for each share of Mayer stock. Henry Company expects its stock to sell at the same pricelearnings (P/E) multiple after the merger as before merging. a. Calculate the ratio of exchange in market price. b. Calculate the earnings per share (EPS) and pricelearnings (P/E) ratio for each company. c. Calculate the pricelearnings (P/E) ratio used to purchase Mayer Services. d. Calculate the post-merger earnings per share (EPS) for Henry Company, e. Calculate the expected market price per share of the merged firm. a. The ratio of exchange in market price is (Round to two decimal places.) i Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Item Henry Company Mayer Services Earnings available for common stock $205,000 $85.000 Number of shares of common stock outstanding 80,000 10,000 Market price per share $61 $153 Enter your answer in th Print Done 7 parts remaining C (A po ovxa wi@4:10