skills.rest
projectedanx
projectedanxCOMMUNITY
Explore all skills by this author →
𝕏@ALifeInArtifyAIGitHub

merger-model

Construct accretion and dilution models for M&A transactions with pro-forma P&L and synergy sensitivity analysis.

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

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 pro-forma analysis for deal evaluation.

Core Features & Use Cases

  • Accretion/Dilution Analysis: Automatically models EPS impact, synergy sensitivities, and purchase price allocation.
  • Deal Structuring: Evaluates various financing mixes (cash vs. stock) and debt scenarios.
  • Use Case: Use this when preparing a merger consequences analysis for a pitch book or evaluating the financial viability of a potential acquisition.

Quick Start

Use the merger-model skill to generate a pro-forma EPS analysis for the proposed acquisition of TargetCorp by AcquirerInc using the provided deal terms.

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 pro-forma EPS accretion and dilution model for an M&A transaction?▼

This M&A accretion and dilution model automatically calculates EPS impact, synergy sensitivities, and purchase price allocation to generate a structured Excel workbook for evaluating deal viability.

What is the best way to evaluate various financing mixes and debt scenarios for a merger?▼

Evaluating financing mixes for a merger requires modeling cash versus stock scenarios and debt structures to assess pro-forma financials. This skill structures these scenarios to assess acquisition viability and financing impacts.

Does this M&A modeling tool require openpyxl to generate Excel workbooks?▼

Yes, this M&A modeling tool requires headless openpyxl integration to generate structured Excel workbooks containing deal assumptions, sources and uses, and sensitivity tables for financial decision-making.

How do I generate a merger consequences analysis with synergy sensitivity tables for an investment banking pitch?▼

Generating a merger consequences analysis requires building pro-forma P&L and synergy sensitivity tables. This skill produces structured Excel outputs for investment banking pitches and corporate development deal evaluations.

Can I use this skill to evaluate the financial viability of a potential acquisition for corporate development?▼

Yes, you can evaluate acquisition financial viability by modeling pro-forma EPS impact, structuring purchase price allocation, and analyzing synergy sensitivities. It outputs structured Excel workbooks for corporate development deal evaluations.

Related Skills

Explore More Finance & Accounting Skills→
w95w95
145

Merger Model

Generates merger models calculating pro forma EPS accretion/dilution and synergy sensitivity analysis for M&A deals.

Community
Advanced
SignmanalSignmanal
1

merger-model

Generate M&A accretion/dilution models with pro-forma P&L and sensitivity tables.

Community
Intermediate
icyzhicyzh
1

merger-model

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

Community
Advanced
zeronx798zeronx798

merger-model

Construct accretion and dilution merger models in Excel with openpyxl.

Community
Advanced