skills.rest
cxnaive
cxnaiveCOMMUNITY
Explore all skills by this author →
GitHub

merger-model

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

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

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 EPS Modeling: Automatically calculates the impact of M&A transactions on earnings per share.
  • Sensitivity Analysis: Generates tables for synergy and offer premium sensitivities to stress-test deal terms.
  • Use Case: When evaluating a potential acquisition, use this skill to quickly build a pro forma income statement and determine the breakeven synergies required to keep the deal EPS-neutral.

Quick Start

Use the merger-model skill to build an accretion and dilution analysis for the proposed acquisition of Target Corp by Acquirer Inc using the provided deal terms.

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 and dilution analysis in Excel?▼

To build an M&A accretion and dilution analysis in Excel, this skill automatically generates a pro forma income statement, calculates EPS impact, and tests synergy sensitivities. It uses the openpyxl dependency for headless spreadsheet generation.

What is pro forma EPS modeling for merger transactions?▼

Pro forma EPS modeling calculates the impact of M&A transactions on earnings per share. This skill automatically computes the combined company's earnings to determine if a proposed acquisition is accretive or dilutive to existing shareholders.

How do I test synergy sensitivity for an acquisition offer premium?▼

You can test synergy sensitivity and offer premium impacts using this skill to generate sensitivity tables. It stress-tests deal terms to determine the breakeven synergies required to keep a proposed acquisition EPS-neutral.

Does this merger modeling tool require openpyxl for purchase price allocation?▼

Yes, this merger modeling tool requires openpyxl to generate purchase price allocation workbooks. The dependency enables headless spreadsheet generation for investment banking workflows without needing Excel installed locally.

Can I integrate financial data sources for M&A valuation inputs?▼

Yes, this skill supports integration with financial data sources for accurate valuation inputs. It uses these data feeds to drive the M&A accretion and dilution analysis alongside pro forma income statement calculations.

Related Skills

Explore More Finance & Accounting Skills→
vignesh2027vignesh2027
6

ma-dealmaker

Automate M&A valuation, due diligence, and deal-memo generation from structured target data.

Community
Advanced
SignmanalSignmanal
1

merger-model

Generate M&A accretion/dilution models with pro-forma P&L and sensitivity tables.

Community
Intermediate
fall-development-robfall-development-rob
7

Financial Analyst - Core

Perform CFA-level financial analysis and valuation with structured outputs and sensitivity matrices.

Community
Advanced
davpatel605-beepdavpatel605-beep

lbo-model

Build leveraged buyout models with Excel valuation and financing analyses.

Community
Advanced