Merger Accretion Model

The problem

Manual M&A modeling is prone to circular reference errors and inconsistent financing assumptions. Financial analysts often struggle to accurately calculate the break-even synergy point or quantify the specific EPS impact of varying stock-to-cash mixes.

What it does

• Generates a structured multi-sheet Excel architecture including Assumptions, Standalone P&Ls, and Pro-forma sheets.
• Calculates precise deal math covering offer premiums, equity purchase prices, and uses of funds.
• Orchestrates pro-forma ownership logic to determine new share counts and ownership percentages.
• Builds dynamic accretion/dilution analysis that measures EPS impact in both currency and percentage terms.
• Constructs sensitivity data tables to visualize how changes in premium and synergy levels affect deal viability.

Frameworks & tools

Microsoft Excel, Google Sheets, Investment Banking Financial Modeling standards.

Why this beats prompting it yourself

Generic prompts often miss the nuances of financing costs, tax effects on synergies, and share count dilution. This skill enforces a rigorous sheet-by-sheet order and verification checklist to ensure your deal math balances to the dollar.

Use cases

• Screening potential acquisition targets for EPS impact.
• Building sensitivity tables for investment banking case studies or board decks.
• Determining the required synergies to reach a break-even accretion level.
• Validating the financing mix impact on pro-forma ownership.

Known limitations

Does not handle complex LBO debt waterfalls or mark-to-market accounting adjustments. Not designed for tax or legal structuring opinions.