Environment
This skill assumes headless openpyxl — you are producing an .xlsx file on disk.
Follow the excel-author skill's conventions for cell coloring, formulas, named ranges, and sensitivity tables.
Recalculate before delivery: python /path/to/excel-author/scripts/recalc.py ./out/model.xlsx.
Merger Model
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.
Workflow
Step 1: Gather Inputs
Acquirer:
- Company name, current share price, shares outstanding
- LTM and NTM EPS (GAAP and adjusted)
- P/E multiple
- Pre-tax cost of debt, tax rate
- Cash on balance sheet, existing debt
Target:
- Company name, current share price, shares outstanding (if public)
- LTM and NTM EPS or net income
- Enterprise value or equity value
Deal Terms:
- Offer price per share (or premium to current)
- Consideration mix: % cash vs. % stock
- New debt raised to fund cash portion
- Expected synergies (revenue and cost) and phase-in timeline
- Transaction fees and financing costs
- Expected close date
Step 2: Purchase Price Analysis
| Item |
Value |
| Offer price per share |
|
| Premium to current |
|
| Equity value |
|
| Plus: net debt assumed |
|
| Enterprise value |
|
| EV / EBITDA implied |
|
| P/E implied |
|
Step 3: Sources & Uses
| Sources |
$ |
Uses |
$ |
| New debt |
|
Equity purchase price |
|
| Cash on hand |
|
Refinance target debt |
|
| New equity issued |
|
Transaction fees |
|
|
|
Financing fees |
|
| Total |
|
Total |
|
Step 4: Pro Forma EPS (Accretion / Dilution)
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) % |
|
|
|
Step 5: Sensitivity Analysis
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 |
|
|
|
|
|
Step 6: Breakeven Synergies
Calculate the minimum synergies needed for the deal to be EPS-neutral in Year 1.
Step 7: Output
- Excel workbook with:
- Assumptions tab
- Sources & uses
- Pro forma income statement
- Accretion/dilution summary
- Sensitivity tables
- Breakeven analysis
- One-page merger consequences summary for pitch book
Important Notes
- Always show both GAAP and adjusted (cash) EPS where relevant
- Stock deals: use acquirer's current price for exchange ratio, note dilution from new shares
- Include purchase price allocation — goodwill and intangible amortization matter for GAAP EPS
- Synergy phase-in is critical — Year 1 is often only 25-50% of run-rate synergies
- Don't forget foregone interest income on cash used and new interest expense on debt raised
- Tax rate on synergies and interest adjustments should match the acquirer's marginal rate
Data sources — MCP first, web fallback
Many passages below say "use the S&P Kensho MCP / Daloopa MCP / FactSet MCP". Those are commercial financial-data MCPs from the original Cowork plugin context. In Hermes:
- If you have any structured financial-data MCP configured (Hermes supports MCP — see
native-mcp skill), prefer it for point-in-time comps, precedent transactions, and filings.
- Otherwise, fall back to:
web_search / web_extract against SEC EDGAR (https://www.sec.gov/cgi-bin/browse-edgar) for US filings
- Company IR pages for press releases, earnings decks
browser_navigate for interactive data portals
- User-provided data (explicitly ask when the context doesn't have it)
- Never fabricate. If a multiple, precedent, or filing number can't be sourced, flag the cell as
[UNSOURCED] and surface it to the user.
Attribution
This skill is adapted from Anthropic's Claude for Financial Services plugin suite (Apache-2.0). The Office-JS / Cowork live-Excel paths have been removed; this version targets headless openpyxl via the excel-author skill's conventions. Original: https://github.com/anthropics/financial-services
1---2name: merger-model3description: "Build accretion/dilution (merger) models in Excel — pro-forma P&L, synergies, financing mix, EPS impact. Pairs with excel-author. Use for M&A pitches, board materials, or deal evaluation."4version: 1.0.05author: Anthropic (adapted by Nous Research)6license: Apache-2.07platforms: [linux, macos, windows]8category: finance9tags: [finance, m-and-a, merger, accretion-dilution, excel, openpyxl, modeling, investment-banking]10compatible: [claude-code, openai-agents, hermes-agent, autogen, langchain, any-llm]11source: optional12metadata:13 source: https://skillmd.com/skills/lord1egypt/merger-model14---1516## Environment1718This skill assumes **headless openpyxl** — you are producing an .xlsx file on disk.19Follow the `excel-author` skill's conventions for cell coloring, formulas, named ranges, and sensitivity tables.20Recalculate before delivery: `python /path/to/excel-author/scripts/recalc.py ./out/model.xlsx`.2122# Merger Model2324Build 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.2526## Workflow2728### Step 1: Gather Inputs2930**Acquirer:**31- Company name, current share price, shares outstanding32- LTM and NTM EPS (GAAP and adjusted)33- P/E multiple34- Pre-tax cost of debt, tax rate35- Cash on balance sheet, existing debt3637**Target:**38- Company name, current share price, shares outstanding (if public)39- LTM and NTM EPS or net income40- Enterprise value or equity value4142**Deal Terms:**43- Offer price per share (or premium to current)44- Consideration mix: % cash vs. % stock45- New debt raised to fund cash portion46- Expected synergies (revenue and cost) and phase-in timeline47- Transaction fees and financing costs48- Expected close date4950### Step 2: Purchase Price Analysis5152| Item | Value |53|------|-------|54| Offer price per share | |55| Premium to current | |56| Equity value | |57| Plus: net debt assumed | |58| Enterprise value | |59| EV / EBITDA implied | |60| P/E implied | |6162### Step 3: Sources & Uses6364| Sources | $ | Uses | $ |65|---------|---|------|---|66| New debt | | Equity purchase price | |67| Cash on hand | | Refinance target debt | |68| New equity issued | | Transaction fees | |69| | | Financing fees | |70| **Total** | | **Total** | |7172### Step 4: Pro Forma EPS (Accretion / Dilution)7374Calculate year-by-year (Year 1-3):7576| | Standalone | Pro Forma | Accretion/(Dilution) |77|---|-----------|-----------|---------------------|78| Acquirer net income | | | |79| Target net income | | | |80| Synergies (after tax) | | | |81| Foregone interest on cash (after tax) | | | |82| New debt interest (after tax) | | | |83| Intangible amortization (after tax) | | | |84| Pro forma net income | | | |85| Pro forma shares | | | |86| **Pro forma EPS** | | | |87| **Accretion / (Dilution) %** | | | |8889### Step 5: Sensitivity Analysis9091**Accretion/Dilution vs. Synergies and Offer Premium:**9293| | $0M syn | $25M syn | $50M syn | $75M syn | $100M syn |94|---|---------|----------|----------|----------|-----------|95| 15% premium | | | | | |96| 20% premium | | | | | |97| 25% premium | | | | | |98| 30% premium | | | | | |99100**Accretion/Dilution vs. Cash/Stock Mix:**101102| | 100% cash | 75/25 | 50/50 | 25/75 | 100% stock |103|---|-----------|-------|-------|-------|------------|104| Year 1 | | | | | |105| Year 2 | | | | | |106107### Step 6: Breakeven Synergies108109Calculate the minimum synergies needed for the deal to be EPS-neutral in Year 1.110111### Step 7: Output112113- Excel workbook with:114 - Assumptions tab115 - Sources & uses116 - Pro forma income statement117 - Accretion/dilution summary118 - Sensitivity tables119 - Breakeven analysis120- One-page merger consequences summary for pitch book121122## Important Notes123124- Always show both GAAP and adjusted (cash) EPS where relevant125- Stock deals: use acquirer's current price for exchange ratio, note dilution from new shares126- Include purchase price allocation — goodwill and intangible amortization matter for GAAP EPS127- Synergy phase-in is critical — Year 1 is often only 25-50% of run-rate synergies128- Don't forget foregone interest income on cash used and new interest expense on debt raised129- Tax rate on synergies and interest adjustments should match the acquirer's marginal rate130131132## Data sources — MCP first, web fallback133134Many passages below say "use the S&P Kensho MCP / Daloopa MCP / FactSet MCP". Those are commercial financial-data MCPs from the original Cowork plugin context. In Hermes:135136- **If you have any structured financial-data MCP configured** (Hermes supports MCP — see `native-mcp` skill), prefer it for point-in-time comps, precedent transactions, and filings.137- **Otherwise**, fall back to:138 - `web_search` / `web_extract` against SEC EDGAR (`https://www.sec.gov/cgi-bin/browse-edgar`) for US filings139 - Company IR pages for press releases, earnings decks140 - `browser_navigate` for interactive data portals141 - User-provided data (explicitly ask when the context doesn't have it)142- **Never fabricate**. If a multiple, precedent, or filing number can't be sourced, flag the cell as `[UNSOURCED]` and surface it to the user.143144## Attribution145146This skill is adapted from Anthropic's Claude for Financial Services plugin suite (Apache-2.0). The Office-JS / Cowork live-Excel paths have been removed; this version targets headless openpyxl via the `excel-author` skill's conventions. Original: https://github.com/anthropics/financial-services