skills.rest
Rheasilvia
RheasilviaCOMMUNITY
Explore all skills by this author →
GitHub

merger-model

Construct M&A accretion and dilution workbooks with openpyxl for Excel.

Updated Jun 25, 2026
Search Tags:#finance#excel#modeling#investment-banking#accretion-dilution#m-and-a
One-click install
npx skills add https://github.com/Rheasilvia/hermes-desktop --skill merger-model-rheasilvia
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/Rheasilvia/hermes-desktop/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/Rheasilvia/hermes-desktop --skill merger-model-rheasilvia

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This skill removes the manual complexity of building M&A financial models, ensuring consistent, error-free accretion/dilution analysis for potential acquisitions.

Core Features & Use Cases

  • Pro Forma Modeling: Automatically calculates EPS impact, synergy sensitivities, and purchase price allocation.
  • Sensitivity Analysis: Generates tables for synergy and premium scenarios to stress-test deal terms.
  • Use Case: Use this when evaluating a potential acquisition to quickly determine if a deal is accretive or dilutive to your company's EPS.

Quick Start

Use the merger-model skill to build an accretion dilution analysis for an acquisition of Target Corp by Acquirer Inc using the provided financial inputs.

Frequently Asked Questions about merger-model

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

FAQPage Schema
How do I build an M&A accretion dilution model in Excel?▼

To build an M&A accretion dilution model, you need structured financial inputs to calculate pro forma EPS impact, purchase price allocation, and synergy sensitivities using standardized investment banking conventions.

What is accretion dilution analysis in investment banking?▼

Accretion dilution analysis evaluates a potential acquisition by calculating the pro forma EPS impact to determine if a deal is accretive (increases EPS) or dilutive (decreases EPS) for the acquiring company.

Can I generate sensitivity tables for M&A deal scenarios automatically?▼

Yes, you can generate sensitivity tables for M&A deal scenarios to stress-test synergy and premium variations, allowing you to evaluate deal terms across multiple pro forma EPS impact scenarios.

Does openpyxl support creating financial modeling workbooks without Excel installed?▼

Yes, openpyxl supports headless Excel workbook generation, allowing you to construct comprehensive M&A financial models and write them to Excel files without needing the Excel application installed.

What is the best way to calculate purchase price allocation for an acquisition?▼

The best way to calculate purchase price allocation is using standardized investment banking modeling conventions that automatically distribute the purchase price across target assets and goodwill within a pro forma model.

Why does my accretion dilution model need structured financial inputs?▼

Your accretion dilution model needs structured financial inputs because the automated calculation of EPS impact, purchase price allocation, and sensitivity analysis requires standardized data to adhere to investment banking conventions.

Related Skills

Explore More Finance & Accounting Skills→
jleechanorgjleechanorg

merger-model

Automate accretion/dilution merger modeling in Excel workbooks.

Official
Advanced
pynbj1001pynbj1001
4

Merger Model

Build merger models quantifying accretion/dilution and pro forma EPS impact.

Community
Advanced
blueskies1818blueskies1818
1

merger-model

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

Community
Advanced
cxnaivecxnaive

merger-model

Build M&A accretion and dilution analysis workbooks in Excel format.

Community
Advanced