Mergers & Acquisition: Combination Analysis

PLEASE READ THE INSTRUCTIONS:It is common in Mergers & Acquisitions to create pro forma combined financial statements (and resulting key ratios) for a potential merger or acquisition scenario. The ability to successfully complete a Combination Analysis is critical due to the importance of a firm’s EPS and targeted capital structure/credit rating.  The format in the attached Excel file is specific to this assignment.Download the attached Excel File and complete the prompts within.For more information about this activity, please refer to theCombination Analysis Assignment Document.