merger-model

Automate merger model construction in Excel to quantify accretion and dilution.

Updated May 2, 2026
One-click install
npx skills add https://github.com/AlvaroBiano/hermes-agent --skill merger-model-alvarobiano
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/AlvaroBiano/hermes-agent/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/AlvaroBiano/hermes-agent --skill merger-model-alvarobiano

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Build accurate, ready-to-use merger models in Excel to quantify accretion/dilution, EPS impacts, and financing effects for M&A scenarios.

Core Features & Use Cases

  • Pro-forma P&L construction for acquirer and target.
  • Synergy and financing mix modeling with sensitivity options.
  • Use Case: Prepare deal materials for board pitches or due-diligence packets.

Quick Start

Provide deal inputs and run the model to generate a pro forma merger analysis in Excel.

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 in Excel for deal analysis?

A merger model quantifies the EPS impact of an acquisition by combining the acquirer and target pro forma income statements. It accounts for purchase price, financing mix, synergies, and amortization to determine whether a deal is accretive or dilutive to earnings.

What is an accretion dilution analysis and when do I need it for M&A?

Accretion dilution analysis calculates the EPS impact of an M&A transaction by merging pro forma income statements. You need it during deal evaluation, board material preparation, and investor pitches to determine if an acquisition increases or decreases the acquirer's earnings per share.

Can I model different purchase prices and financing mixes in a merger model?

Yes, you can model varying purchase prices, financing mixes, and synergies in a merger model. The framework supports structured inputs for deal terms and generates sensitivity tables to evaluate multiple acquirer and target scenarios simultaneously.

How do I create pro forma financial statements for an acquisition?

You create pro forma financial statements by combining acquirer and target income statements and adjusting for financing mix, synergies, and amortization. The model automates this in Excel to generate a ready-to-use pro forma P&L for M&A deal evaluation.

Does this merger model require Excel for accretion dilution analysis?

Yes, the merger model requires Excel-based financial modeling to perform accretion dilution analysis. It automates pro forma income statements, sensitivity tables, and structured deal inputs directly within Excel.

What is the best way to prepare M&A deal materials for board pitches?

The best way to prepare M&A deal materials is to build a structured merger model quantifying accretion dilution and EPS impacts. This provides pro forma analysis with sensitivity tables that can be directly exported for board pitches and due-diligence packets.