Knowledge Base: Merger Model Tutorials
Merger Models are used to analyze the effects of a merger or acquisition in which one company acquires another company.
A “merger” means the companies are similarly sized, and the deal may be 100% Stock or have a high Stock component; in an acquisition, one company is substantially bigger than the other.
But there is always a buyer or seller in any M&A deal.
The basic idea behind a merger model is that an acquirer pays a Purchase Price for the target company and may fund the deal with a combination of Cash, Stock, and Debt (or just one or two of these).
Each funding source has a different “cost,” so from a financial perspective, acquirers want to use the lowest-cost funding source (Cash) as much as possible.
When the deal closes, you combine the financial statements of the acquirer and target and calculate metrics like EPS accretion/dilution to determine if the acquirer is better or worse off on a per-share basis.
EPS accretion/dilution is significant because Earnings per Share (EPS) is the only Income Statement metric that reflects the full impact of the deal financing: Foregone Interest Income on Cash Used, Interest Expense on Debt Used, and the additional shares from Stock Issued.
Since EPS is defined as Net Income / Shares Outstanding, and since Net Income includes Interest Income and Interest Expense, this metric is very useful for analyzing M&A deals.
We present below merger model-related tutorials, samples, and excerpts from our courses:
-
Cost Synergies in M&A Deals and Merger Models: Full Tutorial and Sample Excel Model
-
Deferred Tax Liabilities in M&A Deals: Why They Get Created (13:23)
-
Definitive Agreement (21:40)
-
Divestitures: Strategies, Mechanics, and Examples
-
Earnout Modeling in M&A Deals and Merger Models (21:49)
-
Enterprise Value vs. Purchase Price: What is the “True” Purchase Price in M&A Deals?
-
EPS Accretion Dilution – Rules of Thumb for Merger Models (13:24)
-
Exchange Ratios in M&A Deals: Fixed, Floating, and Collars (20:05)
-
How to Calculate Goodwill in M&A Deals and Merger Models (17:33)
-
Merger Model Interview Questions: What to Expect (18:38)
-
Merger Model Walkthrough: Combining the Income Statements (19:25)
-
Merger Model: Assessment Centre Case Study (24:14)
-
Merger Model: Cash, Debt, and Stock Mix (19:58)
-
Negative Goodwill and Bargain Purchases in Merger Models (16:09)
-
Section 382 Limitations and Net Operating Losses (NOLs) in the U.S. Tax Code
-
Video Tutorial: Purchase Price Allocation Example and Walkthrough