What is a Merger Model?
A merger model (also called a merger consequences analysis or accretion/dilution analysis) is a financial model that answers the fundamental question in any acquisition: “What happens to the acquirer’s earnings per share (EPS) when they buy the target?” If pro forma EPS goes up, the deal is accretive (good for shareholders). If it goes down, the deal is dilutive (requires justification). The mechanics work like this: when Company A buys Company B, Company A gains Company B’s net income (plus expected synergies) but also incurs costs — the financing expense of debt raised to fund the deal, the dilution from new shares issued if paying with stock, the amortization of intangible assets created in purchase price allocation, and the loss of interest income on cash used. The merger model combines all of these effects to calculate whether the combined entity earns more or less per share than the acquirer did alone. Merger models are built for every M&A transaction at every investment bank. They are a core component of board presentations, fairness opinions, proxy statements, and negotiation discussions. An investment banking analyst will typically build dozens of merger models during their first two years.Why It Matters
- Board-level decision making: The acquirer’s board of directors needs to see accretion/dilution before approving any deal. A significantly dilutive deal requires compelling strategic justification
- Negotiation tool: Sensitivity tables showing accretion/dilution at different prices and synergy levels help both sides understand the economics during negotiations
- Fairness opinions: The financial advisor’s formal opinion on whether a deal is “fair” to shareholders relies heavily on merger model outputs
- Deal structure optimization: Merger models help determine the optimal cash/stock mix, how much debt to raise, and what synergy targets are needed for the deal to work financially
- Regulatory filings: Accretion/dilution data appears in proxy statements filed with the SEC
Key Concepts
| Term | Definition |
|---|---|
| Accretive | Pro forma EPS is higher than standalone EPS — the deal adds value per share |
| Dilutive | Pro forma EPS is lower than standalone EPS — the deal reduces value per share |
| Sources & Uses | How the deal is funded (sources: cash, debt, stock) and where the money goes (uses: equity purchase, debt payoff, fees) |
| Synergies | Cost savings or revenue enhancements expected from combining the two companies |
| Purchase Price Allocation (PPA) | Accounting exercise that allocates the purchase price to identifiable assets, with the remainder as goodwill |
| Goodwill | The premium paid over the fair value of identifiable assets — tested annually for impairment |
| Intangible Amortization | Non-cash expense from amortizing identified intangible assets (customer relationships, technology, brand) |
| Breakeven Synergies | The minimum synergies needed for the deal to be EPS-neutral in Year 1 |
| Exchange Ratio | In a stock deal, the number of acquirer shares issued per target share |
Worked Example: Acme Corp Acquires WidgetTech
Walk through a complete merger model from inputs to accretion/dilution.Step 1: Gather Inputs
Acquirer: Acme Corp (ACM)| Metric | Value |
|---|---|
| Share Price | $50.00 |
| Shares Outstanding | 200M |
| Market Cap | $10.0B |
| Net Income (NTM) | $800M |
| EPS (NTM) | $4.00 |
| P/E Multiple | 12.5x |
| Pre-tax Cost of Debt | 5.5% |
| Tax Rate | 25% |
| Cash on Balance Sheet | $2.0B |
| Existing Debt | $3.0B |
| Metric | Value |
|---|---|
| Share Price | $30.00 |
| Shares Outstanding | 50M |
| Market Cap | $1.5B |
| Net Income (NTM) | $100M |
| EPS (NTM) | $2.00 |
| P/E Multiple | 15.0x |
| Net Debt | $200M |
| Term | Value |
|---|---|
| Offer Price | $40.00 per share (33% premium) |
| Consideration | 50% cash / 50% stock |
| New Debt | $800M at 5.5% |
| Expected Cost Synergies | $50M pre-tax (Year 2 run-rate) |
| Synergy Phase-in | 50% in Year 1, 100% in Year 2 |
| Transaction Fees | $50M |
| Financing Fees | 800M debt) |
| PPA: Intangible Assets | $500M (amortized over 10 years) |
Step 2: Purchase Price Analysis
Step 3: Sources and Uses
Step 4: Pro Forma EPS Calculation
- Acme is paying 20x P/E for a target (WidgetTech’s implied P/E at the offer price) when Acme itself only trades at 12.5x P/E. Buying a higher-multiple company with stock is inherently dilutive.
- Intangible amortization of $37.5M per year (after tax) is a significant drag on pro forma EPS.
Step 5: Sensitivity Analysis
Accretion/Dilution vs. Synergies and Offer Premium:| $0M Syn | $25M Syn | $50M Syn | $75M Syn | $100M Syn | |
|---|---|---|---|---|---|
| 20% premium ($36) | (3.2%) | (1.5%) | 0.2% | 1.9% | 3.6% |
| 25% premium ($37.50) | (4.1%) | (2.4%) | (0.7%) | 1.0% | 2.7% |
| 33% premium ($40.00) | (7.5%) | (5.8%) | (4.1%) | (2.4%) | (0.7%) |
| 40% premium ($42.00) | (9.3%) | (7.6%) | (5.9%) | (4.2%) | (2.6%) |
| 100% Cash | 75/25 | 50/50 | 25/75 | 100% Stock | |
|---|---|---|---|---|---|
| Year 1 | (3.8%) | (4.5%) | (5.8%) | (7.1%) | (8.4%) |
| Year 2 | (0.8%) | (1.5%) | (3.3%) | (4.8%) | (6.1%) |
Step 6: Breakeven Synergies
Step 7: One-Page Summary
Full Skill Workflow (From SKILL.md)
Phase 1: Gather Inputs
Acquirer data: Share price, shares outstanding, NTM EPS (GAAP and adjusted), P/E multiple, pre-tax cost of debt, tax rate, cash on balance sheet, existing debt. Target data: Share price (if public), shares outstanding, NTM EPS or net income, enterprise value, net debt. Deal terms: Offer price or premium, consideration mix (% cash vs. % stock), new debt to raise, expected synergies and phase-in, transaction fees and financing fees, PPA assumptions (intangible value and amortization period), expected close date.Phase 2: Purchase Price Analysis
Calculate: offer price per share, premium to current, equity value, enterprise value, and implied multiples (EV/EBITDA, P/E).Phase 3: Sources and Uses
Build the funding table. Sources must equal uses. Common sources: new debt, cash on hand, new equity issued. Common uses: equity purchase price, refinance target debt, transaction fees, financing fees.Phase 4: Pro Forma EPS Calculation
Year-by-year (Year 1-3):- Start with acquirer standalone net income
- Add target net income
- Add synergies (after tax, with phase-in schedule)
- Subtract foregone interest on cash used (after tax)
- Subtract new debt interest expense (after tax)
- Subtract intangible amortization (after tax)
- Divide by pro forma share count (standalone + new shares)
- Compare to standalone EPS for accretion/dilution percentage
Phase 5: Sensitivity Analysis
Build two sensitivity tables:- Accretion/Dilution vs. Synergies and Offer Premium: Vary synergy amounts across columns and premium levels across rows
- Accretion/Dilution vs. Cash/Stock Mix: Vary consideration mix from 100% cash to 100% stock
Phase 6: Breakeven Synergies
Calculate the minimum pre-tax synergies for EPS neutrality in Year 1. This is a key negotiation data point.Phase 7: Deliver Output
Excel workbook with: assumptions tab, sources and uses, pro forma income statement, accretion/dilution summary, sensitivity tables, and breakeven analysis. Plus a one-page merger consequences summary for pitch book use.Common Mistakes (and How to Avoid Them)
Mistake 1: Forgetting Foregone Interest on Cash
Mistake 1: Forgetting Foregone Interest on Cash
What goes wrong: Acme uses 200M. Pro forma EPS is overstated.How to avoid it: Always calculate: Cash Used x Pre-tax Interest Rate x (1 - Tax Rate) and subtract from pro forma income. Even at low rates (2-3%), 3-4.5M of after-tax income that is lost when the cash is spent.
Mistake 2: Assuming Full Synergies in Year 1
Mistake 2: Assuming Full Synergies in Year 1
What goes wrong: The model projects 50M in Year 1. In reality, synergies take time to achieve — restructuring must occur, systems must be integrated, and cost savings must materialize. Year 1 typically captures only 25-50% of run-rate synergies.How to avoid it: Apply a phase-in schedule: 25-50% in Year 1, 75-100% in Year 2, 100% in Year 3. For the pitch book, show accretion/dilution both with and without synergies so the board can assess the deal on standalone economics.
Mistake 3: Ignoring Purchase Price Allocation
Mistake 3: Ignoring Purchase Price Allocation
What goes wrong: The model calculates accretion on a cash EPS basis (excluding intangible amortization) and presents it as “the deal is accretive.” But GAAP EPS includes amortization, and the deal is actually dilutive on a GAAP basis. The board sees a different number in the proxy statement.How to avoid it: Show both GAAP and adjusted (cash) EPS. GAAP includes intangible amortization. Adjusted excludes it. Many boards focus on cash EPS, but the proxy statement reports GAAP. Present both so there are no surprises.
Mistake 4: Sources Do Not Equal Uses
Mistake 4: Sources Do Not Equal Uses
What goes wrong: The sources total 2.3B. There is a 200M more debt, $200M more equity, or the assumptions are wrong. The model is broken but the error is not caught.How to avoid it: Build a formula check: =Sources - Uses. This cell should always equal zero. If it does not, the model has an error. This is the most basic integrity check in a merger model.
Mistake 5: Wrong Share Count in Pro Forma Calculation
Mistake 5: Wrong Share Count in Pro Forma Calculation
Mistake 6: Inconsistent Tax Rate
Mistake 6: Inconsistent Tax Rate
What goes wrong: Synergies are taxed at 25%, interest adjustments at 21%, and amortization at 28%. Three different tax rates for items that should all use the acquirer’s marginal rate. The result is internally inconsistent.How to avoid it: Use one tax rate (the acquirer’s marginal tax rate) for all adjustments: synergies, foregone interest, new debt interest, and intangible amortization. Typically 25% for US companies (21% federal + state).
Mistake 7: Not Showing the Breakeven Clearly
Mistake 7: Not Showing the Breakeven Clearly
What goes wrong: The merger model shows the deal is dilutive, but the presentation does not include the breakeven synergy number. The board asks “how much more savings do we need to make this work?” and the analyst cannot answer immediately.How to avoid it: Always calculate and prominently display the breakeven synergy number. This is the single most important negotiation data point. If breakeven synergies are 50M, the board needs to understand that gap.
Mistake 8: Using Wrong EPS Basis for Accretion/Dilution
Mistake 8: Using Wrong EPS Basis for Accretion/Dilution
What goes wrong: The acquirer trades at 12.5x trailing P/E but the model uses forward P/E for the accretion/dilution calculation. The comparison periods are mismatched, making the result unreliable.How to avoid it: Use NTM (next twelve months) EPS for both the acquirer standalone and the pro forma. This ensures an apples-to-apples comparison. If using LTM, use LTM for both. Never mix trailing and forward.
Mistake 9: Not Testing Multiple Deal Structures
Mistake 9: Not Testing Multiple Deal Structures
What goes wrong: The model shows one deal structure (50/50 cash/stock). The board asks “what if we used more cash?” or “what if we offered more stock?” and the analyst has to rebuild the model from scratch.How to avoid it: Build the sensitivity table for cash/stock mix from the start (100% cash to 100% stock in 25% increments). This shows the board how deal structure affects shareholder value and enables real-time negotiation support.
Mistake 10: Presenting Dilution Without Strategic Context
Mistake 10: Presenting Dilution Without Strategic Context
What goes wrong: The model shows 5.8% dilution in Year 1. The board rejects the deal because “it is dilutive.” But the strategic value (market entry, technology acquisition, competitive elimination) is worth far more than 5.8% EPS dilution.How to avoid it: Always present accretion/dilution alongside strategic rationale. “The deal is 5.8% dilutive in Year 1, but the acquisition provides: (1) entry into a $3B adjacent market, (2) proprietary technology that would take 3-5 years to develop internally, and (3) elimination of our most disruptive competitor. The NPV of these strategic benefits exceeds the dilution.”
Practice Exercise
Exercise: Build a Merger Model Mega Industries (MEGA) is considering acquiring SmallCo (SMCO). Acquirer (MEGA): Share price 2.0B, NTM EPS 5.0B. Target (SMCO): Share price 200M, net debt $500M. Deal terms: 30% premium (80M pre-tax (50% Year 1, 100% Year 2), transaction fees 20M, PPA intangibles $800M (15-year amortization). Task 1: Calculate the purchase price analysis (equity value, enterprise value, implied multiples). Task 2: Build the sources and uses table. Verify sources = uses. Task 3: Calculate pro forma EPS for Year 1 and Year 2. Is the deal accretive or dilutive? Task 4: Calculate breakeven synergies. Are management’s projected synergies ($80M) sufficient? Task 5: Build the sensitivity table for accretion/dilution at different premium levels (20%, 25%, 30%, 35%, 40%) and synergy levels (40M, 120M, $160M).How to Add to Your Local Context
Best Practices
- Include purchase price allocation: Goodwill and intangible amortization matter for GAAP EPS
- Synergy phase-in is critical: Year 1 typically captures only 25-50% of run-rate synergies
- Do not forget foregone interest: Cash used to fund the deal was earning interest
- Tax rate consistency: All adjustments should use the acquirer’s marginal tax rate
- Show the breakeven clearly: Boards want to know the minimum needed for the deal to work
- Test multiple structures: Run cash/stock mix sensitivity to show structural impact
Dependencies
Required:- XLSX skill for Excel model creation
- Market data for real-time share prices
- Financial data for consensus estimates