The Merger Model skill provides a structured workflow for analyzing mergers and acquisitions (M&A) transactions, focusing on the financial implications such as accretion and dilution of earnings per share (EPS). This skill is particularly useful for financial analysts, investment bankers, and corporate finance professionals who need to assess the potential outcomes of a merger or acquisition. By following a systematic approach, users can gather necessary inputs for both the acquirer and the target company, evaluate deal terms, and analyze the financial impact of the transaction.

The skill begins with gathering critical inputs, including the current share prices, earnings per share (EPS), and deal specifics such as offer price and consideration mix. After establishing these parameters, users can perform a purchase price analysis to determine the equity value and enterprise value of the deal. The skill also guides users through the sources and uses of funds in the transaction, ensuring a comprehensive understanding of the financial structure.

One of the key features of the Merger Model is its focus on pro forma EPS calculations, allowing users to project the earnings impact over several years. Sensitivity analysis is also included, enabling users to see how changes in assumptions regarding synergies and offer premiums affect the overall financial outcome. Additionally, the model facilitates the calculation of breakeven synergies necessary for maintaining EPS neutrality, providing valuable insights for decision-making.

Finally, the output of the skill includes an Excel workbook with detailed analyses and a one-page summary suitable for pitch books. This comprehensive approach helps professionals prepare for M&A discussions and negotiations, making it an essential tool for anyone involved in the financial aspects of mergers and acquisitions.