skills.rest
Plaidmustache
PlaidmustacheCOMMUNITY
Explore all skills by this author →
GitHub

merger-model

Automate accretion/dilution modeling and pro forma financial analysis in Excel.

Updated May 4, 2026
Search Tags:#excel#financial-modeling#synergies#investment-banking#merger#accretion-dilution
One-click install
npx skills add https://github.com/Plaidmustache/hermes-nulab --skill merger-model-plaidmustache
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/Plaidmustache/hermes-nulab/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/Plaidmustache/hermes-nulab --skill merger-model-plaidmustache

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

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.

Core Features & Use Cases

  • Accretion/dilution modeling: Pro forma EPS impact, synergy sensitivity, and purchase price allocation.
  • Finance workflow integration: Aligns with excel-author conventions for cell formatting, named ranges, and sensitivity tables.
  • Use Case: Prepare merger consequences analyses for pitches or board materials.

Quick Start

Use the merger-model skill to build a complete merger accretion/dilution model in Excel.

Frequently Asked Questions about merger-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What is accretion dilution modeling in Excel for mergers?▼

Accretion/dilution modeling in Excel projects pro forma EPS impact from a merger, calculating whether a deal increases or decreases earnings per share. It incorporates synergies, purchase price allocation, and financing mix into the financial analysis.

How do I build a merger model with synergies and financing mix in Excel?▼

You can build a complete merger model by automating pro forma P&L, synergy sensitivity, and purchase price allocation. The model applies Excel conventions for cell styling, formulas, named ranges, and sensitivity tables with a recalculation step.

Does this merger modeling approach work with openpyxl for headless Excel generation?▼

Yes, the merger modeling process requires headless openpyxl to generate Excel files programmatically. It follows excel-author conventions for cell styling, formulas, named ranges, and sensitivity tables, executing a recalculation step to finalize the output.

Can I use this for M&A pitch materials and board deal evaluation scenarios?▼

Yes, this approach prepares merger consequences analyses specifically for M&A pitches and board materials. It evaluates deal scenarios by generating pro forma financial analysis, synergy sensitivity tables, and EPS impact calculations.

What is the best way to calculate pro forma EPS impact for an acquisition?▼

The best way to calculate pro forma EPS impact is using an automated accretion/dilution model that integrates purchase price allocation, financing mix, and synergy projections, outputting formatted sensitivity tables directly into Excel.

Do I need excel-author conventions to format merger sensitivity tables in Excel?▼

Yes, the model aligns with excel-author conventions for cell formatting, named ranges, and sensitivity tables. This integration ensures the generated Excel merger model maintains consistent financial modeling standards and proper recalculation.

Related Skills

Explore More Finance & Accounting Skills→
nadicodeainadicodeai

merger-model

Build an end-to-end merger model in Excel with pro forma EPS impact, synergies, and financing effects.

Official
Advanced
auldsyababuaauldsyababua
6

Creating Financial Models

Build Excel financial models with DCF, sensitivity, Monte Carlo, and scenario analyses.

Community
Advanced
carterwayneskhizeinecarterwayneskhizeine
19

merger-model

Build accretion/dilution and merger consequences Excel models for M&A decisions.

Community
Intermediate
blueskies1818blueskies1818
1

merger-model

Construct M&A financial models with pro-forma statements, synergy analysis, and EPS impact.

Community
Advanced