merger-model

Automate accretion/dilution model creation for M&A transactions with openpyxl.

Updated Jun 26, 2026
One-click install
npx skills add https://github.com/NITISH-gitbit/hermes-custom --skill merger-model-nitish-gitbit
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/NITISH-gitbit/hermes-custom/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/NITISH-gitbit/hermes-custom --skill merger-model-nitish-gitbit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, excel-author, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the building of accretion/dilution models for M&A transactions, streamlining the analysis of pro-forma P&Ls, synergies, financing mix, and EPS impact.

Core Features & Use Cases

  • Automated Model Creation: Build pro-forma P&Ls, synergy sensitivities, and purchase price allocation for M&A deals.
  • Use Case: Use this Skill to evaluate potential acquisitions, prepare merger consequences analysis for pitches, or advise on deal terms.

Quick Start

Build an accretion/dilution model for a merger deal using the merger-model skill and provide the necessary inputs such as acquirer and target company details, deal terms, and synergy information.

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 accretion dilution model for M&A analysis?

An accretion/dilution model for M&A analysis is built by calculating pro-forma financials, synergy sensitivities, and EPS impact. This Skill automates that process, requiring only acquirer and target details, deal terms, and synergy information to generate the analysis.

What is accretion dilution analysis in merger modeling?

Accretion/dilution analysis in merger modeling evaluates how an M&A transaction impacts the acquirer's earnings per share (EPS). It combines pro-forma P&Ls, purchase price allocation, and financing mix to determine if a deal increases or decreases shareholder value.

Can I automate pro-forma P&L and synergy sensitivity calculations for M&A deals?

Yes, you can automate pro-forma P&L and synergy sensitivity calculations for M&A deals. The Skill streamlines the creation of these models, allowing you to evaluate acquisitions and prepare merger consequences analysis for pitches automatically.

Do I need openpyxl to generate Excel-based M&A financial models?

Yes, you need openpyxl to generate Excel-based M&A financial models. This dependency is required for Excel file manipulation, and the Skill integrates with excel-author to handle formatting and calculations for the output models.

What inputs are required to calculate EPS impact for a merger deal?

To calculate EPS impact for a merger deal, the required inputs include acquirer and target company details, deal terms, and synergy information. These inputs drive the automated calculation of pro-forma financials and financing mix.

Best way to evaluate acquisition terms and financing mix for M&A transactions?

The best way to evaluate acquisition terms and financing mix for M&A transactions is using an automated accretion/dilution model. This approach calculates the exact pro-forma P&L and EPS impact, allowing you to advise on deal terms efficiently.