How M&A Merger Model Builder Works
The Merger Model Builder helps investment bankers, corporate development teams, and finance students evaluate the financial impact of a proposed acquisition on the acquiring company's earnings per share. It determines whether a deal is accretive (increases EPS) or dilutive (decreases EPS) under various financing assumptions and purchase price scenarios.
The tool takes the financial profiles of both the acquirer and target — including net income, share count, P/E ratio, and growth rates — along with deal terms such as purchase price premium, financing mix (cash, debt, stock), and expected synergies. It then builds a combined pro forma income statement that shows the merged entity's earnings and share count.
The accretion/dilution analysis is the core output. When an acquirer uses stock to fund a deal, new shares are issued, diluting existing ownership. When debt is used, interest expense reduces combined earnings. The model quantifies these effects and shows the net impact on EPS in year one and beyond, incorporating projected synergies that phase in over time.
Advanced features include sensitivity tables that show accretion/dilution across a range of purchase prices and financing structures, goodwill and intangible asset creation calculations, and the ability to model earnout provisions. The tool also computes the breakeven synergy amount — the minimum cost savings needed to make a dilutive deal accretive. Use it alongside the SAFE Note Conversion Calculator when analyzing acquisitions of venture-backed targets with complex cap tables.
Key Terms Explained
- Accretion
- When a merger increases the acquirer's earnings per share relative to its standalone EPS.
- Dilution
- When a merger decreases the acquirer's earnings per share due to new share issuance or financing costs.
- Synergies
- Cost savings or revenue enhancements expected from combining two businesses, typically phased in over 1-3 years.
- Goodwill
- The excess of purchase price over the fair market value of a target's identifiable net assets.
- Purchase Price Premium
- The percentage above the target's current market value that the acquirer offers to complete the transaction.
Who Needs This Tool
Building a merger model to present accretion/dilution analysis in a board pitch book for a proposed acquisition.
Evaluating multiple acquisition targets to determine which deal structure maximizes EPS accretion.
Modeling bolt-on acquisitions for a portfolio company to show how add-ons enhance platform value.
Practicing M&A modeling concepts for investment banking interviews by building merger models with realistic assumptions.
Stress-testing a proposed acquisition across different synergy realization scenarios before presenting to the board.
Methodology & Formulas
Pro Forma EPS = Combined Net Income / Combined Share Count. Combined Net Income = Acquirer NI + Target NI + Synergies - Foregone Interest on Cash - After-Tax Interest on New Debt - Amortization of Intangibles. Combined Shares = Acquirer Shares + New Shares Issued (if stock consideration). Accretion/Dilution % = (Pro Forma EPS - Acquirer Standalone EPS) / Acquirer Standalone EPS × 100. Goodwill = Purchase Price - Target Book Value - Identified Intangibles. Breakeven Synergies = Dilution Amount / (1 - Tax Rate).
Pro Tips
- Always model synergies with a phase-in schedule (e.g., 25% Year 1, 75% Year 2, 100% Year 3) rather than assuming full realization immediately.
- A deal that is dilutive in year one can still be value-creating if the target's growth rate exceeds the acquirer's — check the crossover year.
- Include transaction costs (advisory fees, financing fees, integration costs) to avoid overstating accretion.
- Remember that stock-for-stock deals at equal P/E ratios are neither accretive nor dilutive — the math only changes when P/E ratios differ.
- Sensitivity tables showing accretion across premium levels and financing mixes are the most valuable output for decision-makers.