skills.rest
ldzhhxx
ldzhhxxCOMMUNITY
Explore all skills by this author →
GitHub

merger-model

Automate merger model creation in Excel with accretion/dilution analysis.

1|1|Updated May 9, 2026
Search Tags:#financial modeling#Excel#accretion dilution#merger modeling#M&A analysis
One-click install
npx skills add https://github.com/ldzhhxx/Hermes_offline_v2 --skill merger-model-ldzhhxx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/ldzhhxx/Hermes_offline_v2/tree/main/hermes-agent/optional-skills/finance/merger-model
Command: npx skills add https://github.com/ldzhhxx/Hermes_offline_v2 --skill merger-model-ldzhhxx

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 creation of accretion/dilution (merger) models in Excel, making M&A analysis more efficient and accurate.

Core Features & Use Cases

  • Accretion/Dilution Analysis: Models pro forma EPS impact, synergy sensitivities, and purchase price allocation.
  • Use Case: Ideal for M&A pitches, board materials, or deal evaluation, it pairs with excel-author to build financial models in Excel.

Quick Start

Build a merger model for a potential acquisition using the 'merger-model' skill with the necessary inputs like acquirer and target financials, deal terms, and synergy assumptions.

Frequently Asked Questions about merger-model

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

FAQPage Schema
How do I automate accretion dilution analysis in Excel for an M&A deal?▼

You can automate accretion dilution analysis in Excel by providing acquirer and target financials, deal terms, and synergy assumptions to generate pro forma EPS impact and purchase price allocation automatically.

What is merger modeling and how does Excel automation handle synergy sensitivities?▼

Merger modeling evaluates the financial impact of an acquisition. Excel automation calculates synergy sensitivities by applying predefined assumptions to generate pro forma financial metrics and purchase price allocations.

Do I need openpyxl to build financial models for M&A analysis?▼

Yes, you need the openpyxl library to execute headless Excel operations. It works with the excel-author skill to programmatically generate and manipulate the merger model workbook.

Can I use this approach to generate board materials for deal evaluation?▼

Yes, this approach is ideal for generating board materials and deal evaluation documents. It outputs pro forma EPS impacts, synergy sensitivities, and purchase price allocations directly into Excel.

What inputs are required to create a merger model for acquisition analysis?▼

Creating a merger model requires predefined inputs including acquirer financials, target financials, deal terms, and synergy assumptions to accurately calculate the pro forma EPS and purchase price allocation.

Are there limitations when using headless openpyxl for purchase price allocation?▼

Using headless openpyxl restricts you to programmatic workbook manipulation without a graphical interface. It relies entirely on predefined inputs for purchase price allocation and does not support interactive Excel features.

Related Skills

Explore More Finance & Accounting Skills→
blueskies1818blueskies1818
1

merger-model

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

Community
Advanced
robertbr123robertbr123

merger-model

Automate merger model creation with pro forma EPS and synergy analysis.

Community
Advanced
robertbr123robertbr123

excel-author

Automate Excel workbook creation with formulas, named ranges, and cell formatting.

Community
Advanced
icyzhicyzh
1

merger-model

Calculate M&A accretion and dilution with pro forma income statements.

Community
Advanced