Merger Model Guide: How to Build an M&A Model Step by Step
When You Build a Merger Model
Investment bankers build merger models to advise on buy-side and sell-side M&A transactions. The model helps answer the fundamental questions: Can the buyer afford this? Will it create or destroy value for shareholders? How should the deal be structured? It’s used alongside standalone valuations (DCF, comps) to support deal recommendations.
Core Components
| Component | What It Covers | Key Outputs |
|---|---|---|
| Deal Assumptions | Offer price, premium, consideration mix (cash vs. stock) | Purchase price, implied multiples |
| Sources & Uses | How the deal is funded and where the money goes | Total sources = total uses |
| Purchase Price Allocation | Goodwill, asset write-ups, deferred taxes | Balance sheet adjustments |
| Pro Forma Financials | Combined income statement and balance sheet | Pro forma EPS, leverage, margins |
| Accretion/Dilution | Impact on acquirer’s EPS | Accretive or dilutive by $ and % |
| Synergies | Cost savings and revenue synergies | Impact on combined EBITDA and EPS |
Step-by-Step: Building the Model
Step 1 — Transaction Assumptions
Define the offer price per share and the implied premium over the target’s current stock price (typically 20–40% for public deals). Determine the consideration mix: all cash, all stock, or a combination. Each has different implications for accretion/dilution and the acquirer’s balance sheet.
Step 2 — Sources and Uses
Build a sources and uses table. Uses include: equity purchase price, repayment of target’s existing debt, and transaction fees (advisory, legal, financing). Sources include: acquirer’s cash on hand, new debt, and new equity (stock issued to target shareholders). Sources must equal uses.
| Sources | Uses |
|---|---|
| Cash from acquirer’s balance sheet | Equity purchase price (offer × diluted shares) |
| New term loan / bonds | Refinance target’s existing debt |
| Revolver draw | Advisory fees (1–2% of EV) |
| Stock issued to target shareholders | Financing fees (2–3% of new debt) |
| Total Sources | Total Uses |
Step 3 — Purchase Price Allocation (PPA)
Under acquisition accounting, the purchase price must be allocated to the target’s assets and liabilities at fair value. The excess over fair value of net identifiable assets is recorded as goodwill. Key adjustments include writing up PP&E, recognizing intangible assets (customer relationships, trade names, technology), and creating deferred tax liabilities on the write-ups.
Step 4 — Pro Forma Income Statement
Combine the acquirer’s and target’s income statements line by line. Then apply adjustments: add synergies (cost savings), subtract incremental D&A from asset write-ups, subtract incremental interest expense on new debt, and add back interest income lost on cash used. Apply the combined tax rate to get pro forma net income.
Step 5 — Pro Forma EPS and Accretion/Dilution
Divide pro forma net income by the new diluted share count (acquirer’s existing shares + new shares issued). Compare to the acquirer’s standalone EPS. If pro forma EPS is higher, the deal is accretive. If lower, it’s dilutive.
Step 6 — Pro Forma Balance Sheet
Combine balance sheets and apply PPA adjustments: eliminate target’s existing equity, add goodwill and intangible write-ups, layer in new debt, remove cash used, and add any new equity issued. Check that the pro forma balance sheet balances and review the resulting leverage ratios.
Deal Consideration: Cash vs. Stock
| Dimension | Cash Deal | Stock Deal |
|---|---|---|
| EPS Impact | More accretive (no dilution from new shares) | More dilutive (new shares reduce EPS) |
| Balance Sheet | Increases leverage | No additional debt |
| Risk Sharing | Acquirer bears all integration risk | Target shareholders share risk |
| Tax to Target Shareholders | Taxable event immediately | Tax-deferred (if structured correctly) |
| Signal | Acquirer believes its stock is undervalued | Acquirer may believe its stock is overvalued |
Key Takeaways
- A merger model combines two companies’ financials and tests whether the deal creates or destroys value.
- Sources must equal uses — this is the anchor of the deal structure.
- Purchase price allocation creates goodwill and intangible write-ups with real P&L impacts (incremental D&A).
- Cash deals are more accretive but increase leverage; stock deals are more dilutive but share risk.
- Synergies are the key to making a premium-price deal accretive — always model them with realistic phase-in timing.
Frequently Asked Questions
What does it mean for a deal to be accretive vs. dilutive?
Accretive means the acquirer’s pro forma EPS is higher than its standalone EPS — the deal adds to earnings. Dilutive means pro forma EPS is lower. While accretion/dilution isn’t the only consideration (strategic fit, growth, synergies matter too), it’s the most common headline metric boards and investors focus on.
How do synergies affect the merger model?
Synergies — cost savings and revenue enhancements — flow directly into the pro forma income statement. Cost synergies (headcount reduction, facility consolidation) are more predictable and hit within 1–3 years. Revenue synergies (cross-selling, market expansion) are harder to achieve and should be modeled conservatively.
What transaction fees should I include?
Advisory fees (1–2% of enterprise value), legal fees, accounting fees, and financing fees (2–3% of new debt issued). Advisory and legal fees are expensed or capitalized into goodwill. Financing fees are amortized over the debt term as additional interest expense.
How do I handle the target’s existing debt?
Check if the target’s debt has change-of-control provisions that trigger repayment upon acquisition. If so, refinancing the target’s debt is a “use” in your sources and uses table. If the debt stays in place, it simply carries over to the pro forma balance sheet.
What’s the difference between a merger model and an LBO model?
A merger model evaluates a strategic acquisition — one operating company buying another. The key metric is accretion/dilution to EPS. An LBO model evaluates a financial sponsor (private equity firm) buying a company using significant leverage. The key metric is IRR to the sponsor. The mechanics overlap (sources & uses, pro forma financials), but the buyer type and return targets differ.