skills.rest
markwang2658
markwang2658COMMUNITY
Explore all skills by this author →
GitHub

merger-model

Build accretion/dilution merger models in Excel with pro-forma P&L and EPS impact.

31|3|Updated May 7, 2026
Search Tags:#excel#eps#synergies#financial-modelling#accretion-dilution#pro-forma#merger-modeling
One-click install
npx skills add https://github.com/markwang2658/hermes-windows-native --skill merger-model-markwang2658
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/markwang2658/hermes-windows-native/tree/main/hermes-agent/optional-skills/finance/merger-model
Command: npx skills add https://github.com/markwang2658/hermes-windows-native --skill merger-model-markwang2658

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Builds structured merger models in Excel to quantify accretion/dilution, pro-forma P&L, synergy effects, and financing impact for deal analysis and board materials.

Core Features & Use Cases

  • Pro-forma EPS impact analysis for potential mergers and financing scenarios.
  • Synergy capture, phasing, and sensitivity adjustments with a clear purchase-price allocation.
  • End-to-end workflow from input collection to a summarized, presentation-ready workbook.

Quick Start

Open the Excel workbook, input acquirer and target data, and generate the pro forma results.

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 a merger?▼

An accretion/dilution model in Excel requires gathering acquirer and target data, performing purchase price analysis, and computing pro forma metrics to quantify EPS impact and synergy effects for deal evaluation.

What is pro forma EPS impact analysis and when do I need it?▼

Pro forma EPS impact analysis calculates the combined earnings per share of merging entities post-transaction. It is needed when evaluating potential acquisitions to determine whether a deal increases or decreases shareholder value.

How do I calculate synergy capture and phasing for an acquisition?▼

Synergy capture and phasing are calculated by inputting cost savings and revenue enhancements into the model, then applying sensitivity adjustments alongside purchase price allocation to project incremental cash flows.

Can I assess different financing structures for merger analysis in Excel?▼

Yes, merger analysis in Excel supports assessing various financing structures by inputting different debt and equity assumptions to evaluate their impact on pro forma P&L and accretion/dilution metrics.

What's the best way to present pro forma P&L for board materials?▼

Presenting pro forma P&L for board materials is best done by generating an organized Excel workbook that summarizes assumptions, purchase price details, and pro forma outputs into a presentation-ready format.

Does this merger modeling approach require specific Excel add-ins or dependencies?▼

No specific Excel add-ins or dependencies are required. The end-to-end workflow operates within a standard Excel workbook to collect inputs, perform analysis, and deliver summarized pro forma results.

Related Skills

Explore More Finance & Accounting Skills→
jleechanorgjleechanorg

merger-model

Automate accretion/dilution merger modeling in Excel workbooks.

Official
Advanced
SignmanalSignmanal
1

merger-model

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

Community
Intermediate
davpatel605-beepdavpatel605-beep

dcf-model

Build Excel-based discounted cash flow valuation models with WACC and scenario analysis.

Community
Advanced
InverterNetworkInverterNetwork

merger-model

Construct M&A accretion and dilution financial models in Excel format.

Official
Advanced