merger-model

Construct accretion and dilution merger models with pro-forma P&L forecasts.

Updated Jul 13, 2026
One-click install
npx skills add https://github.com/zangjeicy/Hermes --skill merger-model-zangjeicy
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/zangjeicy/Hermes/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/zangjeicy/Hermes --skill merger-model-zangjeicy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This skill eliminates the manual complexity of building M&A financial models, ensuring consistent, error-free analysis of pro-forma EPS impact and deal synergies.

Core Features & Use Cases

  • Accretion/Dilution Analysis: Automatically models the EPS impact of acquisitions over a 3-year horizon.
  • Sensitivity Modeling: Generates tables to test deal outcomes against varying synergy levels and financing mixes.
  • Use Case: Use this during the evaluation phase of a potential acquisition to quickly determine if a deal is accretive or dilutive based on different purchase price premiums and debt/equity structures.

Quick Start

Use the merger-model skill to build a pro-forma analysis for the acquisition of TargetCorp by AcquirerInc 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 accretion dilution model in Excel for an M&A transaction?

An accretion dilution model evaluates the pro-forma EPS impact of an M&A transaction. This skill constructs comprehensive merger models in Excel, projecting P&L over a 3-year horizon to determine if a deal is accretive or dilutive.

How do I run a sensitivity analysis on deal synergies and financing mixes?

Sensitivity analysis tests deal outcomes against varying synergy levels and financing mixes. The skill generates automated sensitivity tables in Excel workbooks, allowing you to evaluate different purchase price premiums and debt/equity structures.

What is purchase price allocation in a merger model and how is it handled?

Purchase price allocation distributes the acquisition cost across target assets in a merger model. This skill supports automated purchase price allocation calculations within the pro-forma analysis to evaluate the financial impact of M&A transactions.

Can I generate Excel workbooks for investment banking workflows without Excel installed?

Yes, the skill uses headless openpyxl integration to generate structured Excel workbooks. It constructs professional M&A accretion and dilution models with automated sensitivity tables and breakeven calculations without requiring a local Excel installation.

What is the best way to calculate breakeven synergies for an acquisition?

Breakeven calculations determine the synergy level needed for an acquisition to become accretive. This skill automates breakeven calculations alongside synergy sensitivity analysis to evaluate whether a deal is accretive or dilutive under varying assumptions.

Does merger-model support pro-forma P&L forecasting for multiple years?

Yes, merger-model supports pro-forma P&L forecasting over a 3-year horizon. It models the EPS impact of acquisitions and constructs comprehensive accretion and dilution merger models for investment banking workflows.