Menu
Use when financial-services work requires merger Model.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Use when financial-services work requires processes an earnings event end to end — reads the call transcript and filings, updates the coverage model, and drafts the post-earnings note. Use when a covered name reports; for a single name interactively, or fanned out across a coverage list as a managed agent..
Use when financial-services work requires reconciles general ledger to subledger across asset classes for a trade date — finds breaks, traces root cause, and routes the exception report for sign-off. Use for daily or month-end recon runs; not for journal-entry posting (use month-end-closer for that)..
Use when financial-services work requires parses an onboarding document packet, runs the firm's KYC/AML rules engine, screens against sanctions and PEP lists, and flags gaps for escalation. Use for new-client onboarding or periodic refresh — not for transaction monitoring..
Use when financial-services work requires produces sector or thematic market research — industry overview, competitive landscape, trading-comps spread of the peer set, and a thematic ideas shortlist — packaged as a research note with optional slides. Use when an analyst or PM asks for a primer on a sector or theme; not for single-name coverage updates (use earnings-reviewer for that)..
Use when financial-services work requires builds a briefing pack before a client or prospect meeting — relationship history from CRM, holdings and recent activity, market context, and a suggested agenda. Use ahead of any client meeting; pairs with a calendar event..
Use when financial-services work requires builds DCF, LBO, three-statement, and trading-comps models live in Excel from a ticker and assumption set. Use when you need a clean model from scratch — not for updating an existing coverage model (use earnings-reviewer for that)..
| name | merger-model |
| description | Use when financial-services work requires merger Model. |
| version | 0.1.0 |
| author | Changhochien |
| license | MIT |
| platforms | ["linux","macos","windows"] |
| metadata | {"hermes":{"tags":["banking","financial-services","investment-banking"],"related_skills":[]}} |
description: Build accretion/dilution analysis for M&A transactions. Models pro forma EPS impact, synergy sensitivities, and purchase price allocation. Use when evaluating a potential acquisition, preparing merger consequences analysis for a pitch, or advising on deal terms. Triggers on "merger model", "accretion dilution", "M&A model", "pro forma EPS", "merger consequences", or "deal impact analysis".
Acquirer:
Target:
Deal Terms:
| Item | Value |
|---|---|
| Offer price per share | |
| Premium to current | |
| Equity value | |
| Plus: net debt assumed | |
| Enterprise value | |
| EV / EBITDA implied | |
| P/E implied |
| Sources | $ | Uses | $ |
|---|---|---|---|
| New debt | Equity purchase price | ||
| Cash on hand | Refinance target debt | ||
| New equity issued | Transaction fees | ||
| Financing fees | |||
| Total | Total |
Calculate year-by-year (Year 1-3):
| Standalone | Pro Forma | Accretion/(Dilution) | |
|---|---|---|---|
| Acquirer net income | |||
| Target net income | |||
| Synergies (after tax) | |||
| Foregone interest on cash (after tax) | |||
| New debt interest (after tax) | |||
| Intangible amortization (after tax) | |||
| Pro forma net income | |||
| Pro forma shares | |||
| Pro forma EPS | |||
| Accretion / (Dilution) % |
Accretion/Dilution vs. Synergies and Offer Premium:
| $0M syn | $25M syn | $50M syn | $75M syn | $100M syn | |
|---|---|---|---|---|---|
| 15% premium | |||||
| 20% premium | |||||
| 25% premium | |||||
| 30% premium |
Accretion/Dilution vs. Cash/Stock Mix:
| 100% cash | 75/25 | 50/50 | 25/75 | 100% stock | |
|---|---|---|---|---|---|
| Year 1 | |||||
| Year 2 |
Calculate the minimum synergies needed for the deal to be EPS-neutral in Year 1.
This skill was packaged from pi-financial-services source path plugins/vertical-plugins/investment-banking/skills/merger-model for the Hermes financial-services profile. Use institutional data connectors first when available, cite sources, and stage outputs for qualified human review.
