skills.rest
zeronx798
zeronx798COMMUNITY
Explore all skills by this author →
GitHub

merger-model

Construct accretion and dilution merger models in Excel with openpyxl.

Updated Jul 13, 2026
Search Tags:#finance#excel#modeling#investment-banking#merger#accretion-dilution#m-and-a
One-click install
npx skills add https://github.com/zeronx798/demo-hermes-agent --skill merger-model-zeronx798
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/zeronx798/demo-hermes-agent/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/zeronx798/demo-hermes-agent --skill merger-model-zeronx798

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 calculations for accretion/dilution analysis and pro-forma financial statements.

Core Features & Use Cases

  • Pro-Forma Modeling: Automatically structures P&L, synergy sensitivities, and financing mixes.
  • Deal Evaluation: Quickly assess the impact of acquisitions on EPS and breakeven synergies.
  • Use Case: Use this to generate a comprehensive merger consequences analysis for a pitch book or board presentation by inputting acquirer and target financial data.

Quick Start

Use the merger-model skill to build a pro-forma accretion analysis for the proposed 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 for an M&A transaction?▼

Yes, synergy sensitivity analysis is fully supported in the merger model. The skill evaluates varying synergy assumptions to determine breakeven points and their direct impact on pro-forma EPS.

Can I generate a pro-forma P&L for a merger using Python?▼

Yes, purchase price allocation is automatically calculated during the merger modeling process. The skill structures the acquisition financing mix and evaluates the resulting impact on the acquirer's financial statements.

Do I need openpyxl to create Excel merger models?▼

This skill is designed for investment banking workflows to produce pitch book and board presentation materials. It follows standardized financial modeling conventions to ensure the generated Excel outputs are presentation-ready.

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

The best way to calculate breakeven synergies is to use a dedicated merger consequences analysis. This skill assesses acquisition impacts on EPS and runs sensitivity analysis to pinpoint exact breakeven synergy requirements.

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
AnandaAnugrahHandyantoAnandaAnugrahHandyanto

merger-model

Build accretion/dilution merger models in Excel to analyze EPS impact.

Community
Advanced
davpatel605-beepdavpatel605-beep

lbo-model

Build leveraged buyout models with Excel valuation and financing analyses.

Community
Advanced
RheasilviaRheasilvia

merger-model

Construct M&A accretion and dilution workbooks with openpyxl for Excel.

Community
Advanced