Mergers and Acquisitions Model Overview

Building an M&A Model from Scratch

Learn about the intricacies of Mergers and Acquisitions (M&A), with a specific focus on building an M&A Model in Excel and performing accretion/dilution analysis. This content provides a step by step guide, including images, to facilitate the understanding of such complex financial transactions.

Key Insights

  • Mergers and Acquisitions (M&A) refer to consolidation of companies or assets through different types of financial transactions.
  • An M&A model is built in Excel to perform an accretion/dilution analysis.
  • The M&A model is created in 4 steps: deal assumptions, acquirer shares issued, pro forma net income, and accretion/dilution analysis.
  • Pro Forma earnings are hypothetical amounts built into the data to show a company's profit if certain nonrecurring items were excluded.
  • Accretion/dilution analysis is a simple test used to evaluate the merit of a proposed merger or acquisition deal, determining if the post-transaction earnings per share (EPS) are increased or decreased.
  • Both quantitative and qualitative analyses are crucial when analyzing an M&A deal to ensure that the transaction strategically makes sense for both the acquirer and the target.

M&A Model Build

  1. Sources & Uses

    Purchase price funded by cash, debt, and acquirer stock.

  2. Combined Income Statement

    Pro forma after acquisition with synergies and amortization.

  3. Accretion / Dilution Analysis

    Combined EPS vs acquirer's standalone EPS.

  4. Sensitivity

    Test impact of synergy assumptions and purchase price.

Play video

Mergers and acquisitions (M&A) is a general term that describes the consolidation of companies or assets through various types of financial transactions.

You can find separate videos on M&A theory and accounting. In this video, we will actually build an M&A Model in Excel and perform accretion/dilution analysis for that.

We have acquired Google and target company Motorola. We’ll perform the model in 4 steps.

Step 1: Deal Assumptions

M&A accretion/dilution analysis showing impact on earnings per share
Financial Modeling Bootcamp: Live & Hands-on, In NYC or Online, Learn From Experts, Free Retake, Small Class Sizes,  1-on-1 Bonus Training. Named a Top Bootcamp by Forbes, Fortune, & Time Out. Noble Desktop. Learn More.

Step 2: Acquirer shares issued, Target offer value and standalone pretax net income for both

M&A model income statement with combined revenue and expense projections

Step 3: Pro Forma Net Income

Pro Forma earnings describe a financial statement that has hypothetical amounts (estimates) built into the data to give a picture of a company’s profit if certain nonrecurring items were excluded. Pro forma earnings usually leave out one-time expenses that are not a part of normal company operations such as restructuring costs following a merger.

Mergers and acquisitions financial model spreadsheet overview

Step 4: Accretion / Dilution Analysis

An accretion/dilution analysis is a simple test used to evaluate the merit of a proposed merger or acquisition deal. The accretion/dilution analysis determines if the post-transaction earnings per share (EPS) are increased or decreased.

Screenshot of a Microsoft Excel workbook labeled 'M&A Model, ' displaying an acquisition scenario with line items for purchase price, new share issuance, synergy assumptions, financing terms, interest rates, and transaction fees, culminating in calculations for overall deal costs and outcomes.

If we see accretion, it’s a good sign and the M&A transaction seems to make sense. However, you need to take into consideration not only quantitative analysis when analyzing an M&A deal but a qualitative as well to make sure that strategically the M&A transaction makes sense for both acquirer and target.

Topics

Learn more in these courses

How to Learn Financial Modeling

Master financial modeling with hands-on training. Financial modeling is a technique for predicting the financial performance of a business or other type of institution over time using real-world data.

Yelp Facebook LinkedIn YouTube Twitter Instagram