Back to Templates

Try this template
Finance
M&A Merger Model (Accretion/Dilution Analysis)
A merger model that builds standalone acquirer and target financials, allocates the purchase price to goodwill, and combines the income statement, balance sheet, and cash flow to test accretion or dilution to EPS, with a separate contribution analysis showing each side's share of the combined entity.
Ideal for corporate development and investment banking teams evaluating M&A transaction structures. Completes the DCF, LBO, comps, and merger model set.
Contents:
- Cover
- Transaction Summary Dashboard
- Assumptions & Standalone Financials
- Sources & Uses of Funds
- Purchase Price Allocation & Goodwill
- Combined Income Statement & Accretion/Dilution
- Pro Forma Balance Sheet at Close
- Combined Cash Flow & Credit Statistics
- Contribution Analysis
- Sensitivity Analysis
M&A Merger Model (Accretion/Dilution Analysis).xlsx




