skills.rest
AlexZWANG1
AlexZWANG1COMMUNITY
Explore all skills by this author →
GitHub

Merger Model

Build accretion/dilution and pro forma EPS merger models in Excel.

Updated Mar 17, 2026
Search Tags:#synergies#accretion-dilution#sources-uses#deal-analysis#merger-model#pro-forma-eps
One-click install
npx skills add https://github.com/AlexZWANG1/Prism --skill merger-model-alexzwang1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Merger Model
Source: https://github.com/AlexZWANG1/Prism/tree/main/financial-services-plugins/investment-banking/skills/merger-model
Command: npx skills add https://github.com/AlexZWANG1/Prism --skill merger-model-alexzwang1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the quantitative analysis of mergers, enabling rapid assessment of accretion/dilution, pro forma EPS impacts, and purchase-price allocations to support deal decision-making.

Core Features & Use Cases

  • End-to-end merger modeling: gather inputs for acquirer, target, and deal terms to compute accretion/dilution, pro forma EPS, and purchase-price allocations.
  • Scenario analysis: build sensitivity tables for synergies, financing mix, and deal premiums to stress-test outcomes.
  • Output and communication: generate an Excel workbook with Sources & Uses, pro forma statements, and a concise pitch-ready summary.

Quick Start

Input acquirer/target data, deal terms, and synergy assumptions to generate a merger-model workbook.

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 to forecast accretion dilution for an M&A deal?▼

To build a merger model, input acquirer and target financials, debt and cash considerations, synergies, and financing terms to compute pro forma EPS impacts and purchase-price allocations.

What inputs are needed for an accretion dilution analysis?▼

Accretion dilution analysis requires acquirer and target details, deal terms, financing mix, and synergy assumptions to generate the pro forma EPS model and purchase-price allocations.

Can I generate a sources and uses table and pro forma statements in Excel?▼

Yes, the merger model outputs an Excel workbook containing Sources and Uses tables, pro forma statements, sensitivity tables, and PPA allocations for your deal analysis.

How do I run sensitivity tables for M&A synergies and deal premiums?▼

You run sensitivity tables by inputting varying synergy assumptions, financing mixes, and deal premiums to stress-test the accretion dilution and pro forma EPS outcomes.

Does this merger model handle purchase-price allocations and deal-term negotiations?▼

Yes, the merger model computes purchase-price allocations and analyzes merger consequences to support quantitative decision-making during deal-term negotiations.

What is the best way to analyze M&A deal opportunities for a pitch?▼

The best way to analyze M&A deal opportunities for pitches is generating a merger-model workbook with pro forma EPS, sensitivity tables, and a concise pitch-ready summary.

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
open-nekoopen-neko
11

merger-model

Generate Excel accretion/dilution merger models with sensitivity and breakeven synergy analyses.

Official
Advanced
mouseqiao85mouseqiao85
1

merger-model

Generate accretion and dilution analysis for M&A transactions with financial parameters and synergies.

Community
Advanced
davpatel605-beepdavpatel605-beep

lbo-model

Build leveraged buyout models with Excel valuation and financing analyses.

Community
Advanced