merger-model

Build merger and acquisition financial models with Python and openpyxl.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation of detailed merger and acquisition financial models, enabling precise evaluation of deal impacts.

Core Features & Use Cases

  • Pro Forma Financial Modeling: Construct accretion/dilution analyses including pro forma P&L, EPS, and cash flow impacts.
  • Deal Structuring Analysis: Calculate purchase price, sources & uses, and sensitivities to synergies and premiums.
  • Use Case: Use it to evaluate a potential acquisition by modeling various deal structures, synergies, and financing options to inform strategic decisions.

Quick Start

Input deal assumptions into the provided Excel template to generate a full merger impact analysis with sensitivity tables and breakeven points.

Frequently Asked Questions about merger-model

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

FAQPage Schema
How do I build a merger model for accretion dilution analysis?

To build a merger model for accretion dilution analysis, input your deal assumptions into the provided Excel template to generate a full pro forma P&L, EPS, and cash flow impact analysis.

What is a sensitivity analysis in M&A deal valuation?

Sensitivity analysis in M&A deal valuation calculates how variations in synergies and purchase price premiums impact the overall deal economics, generating sensitivity tables and breakeven points to inform strategic decisions.

Can I use Python openpyxl to automate financial modeling for acquisitions?

Yes, you can use Python openpyxl to automate financial modeling for acquisitions, as this Skill ensures compliance with financial conventions using the openpyxl library for headless Excel operations.

Does this M&A financial model include sources and uses and purchase price calculations?

Yes, this M&A financial model includes deal structuring analysis that calculates the purchase price, sources and uses of funds, and sensitivities to synergies and premiums for comprehensive transaction evaluation.

What is the best way to evaluate target companies for an acquisition?

The best way to evaluate target companies for an acquisition is by modeling various deal structures, synergies, and financing options to generate a detailed merger impact analysis with breakeven points.

Are there limitations when using Excel templates for pro forma financial modeling?

A key limitation is that pro forma financial modeling requires accurate deal assumptions to be input into the provided Excel template, meaning the output analysis is entirely dependent on the quality of your input data.