Agent skill · business finance · nousresearch
merger-model
Build M&A accretion/dilution workbooks in Excel.
Why this skill is useful
Provides specific modeling techniques and Excel workflows for M&A accretion/dilution analysis that the AI wouldn't reliably generate on its own.
What it needs
Requires openpyxl installed locally. About 3k tokens when loaded. Last updated 2026-08-07. 226,679 stars on the source repository.
What this skill does
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 …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills nousresearch/merger-model