Menu
Use when financial-services work requires merger Model.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle SOC
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.
