Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Merger Accretion Model

    1

    Use to build a merger accretion/dilution model in Excel: pro-forma P&L, synergies, financing mix, ownership percentages, EPS impact and full deal math walkthrou

    Free

    4 usesSecurity scanned
    Merger Accretion Model

    Merger Accretion Model

    Example session with this skill installed

    Build a merger accretion model for a $500M acquisition at a 20% premium. The buyer is paying with a 60/40 stock-to-cash mix. Include a sensitivity table for synergies vs. premium.

    • Read your context and instructions
    • Compiled the merger accretion model

    I have structured the Excel model with 7 sheets. The Assumptions sheet captures the $500M base price and 20% premium ($600M deal value). Pro-forma EPS is calculated by combining Net Incomes, adjusting for $240M in new cash debt interest, and adding $360M in new equity shares.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    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.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    Does not handle LBO-style debt waterfalls, tax structuring, or mark-to-market accounting. Focuses on EPS impact rather than full cash flow returns.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    4 uses

    Times used to date

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 3 months ago

    • Free with an Agensi account

    Permissions

    No special permissions declared or detected

    Listed3 months ago

    What's inside

    Frequently Asked Questions

    This skill generates a complete, professional-grade Excel or Google Sheets workbook structure, including assumptions, standalone P&Ls, pro-forma consolidation, and detailed accretion/dilution sensitivity tables.

    Yes, the model is built following standard investment banking protocols, accounting for nuanced factors like financing costs, tax-effected synergies, and pro-forma share count adjustments.

    This skill is designed for use with AI agents that have file-system access or spreadsheet integration capabilities, such as ChatGPT with Data Analysis or specialized financial assistant agents.

    The skill focuses on P&L impact and deal math; it does not currently support complex LBO debt waterfalls, detailed balance sheet mark-to-market adjustments, or legal tax structuring.

    No specialized installation is required; simply activate the skill within your preferred AI agent interface to begin generating your structured M&A workbook.

    Upon purchase, you receive the full skill logic and a structured verification checklist to ensure your deal math balances perfectly across all pro-forma sheets.

    New in Finance & Accounting

    Free