skills.rest
AnandaAnugrahHandyanto
AnandaAnugrahHandyantoCOMMUNITY
Explore all skills by this author →
GitHub

merger-model

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

Updated Jun 19, 2026
Search Tags:#excel#financial-analysis#synergies#accretion-dilution#deal-evaluation#merger-modeling
One-click install
npx skills add https://github.com/AnandaAnugrahHandyanto/savarez_agent --skill merger-model-anandaanugrahhandyanto
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/AnandaAnugrahHandyanto/savarez_agent/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/AnandaAnugrahHandyanto/savarez_agent --skill merger-model-anandaanugrahhandyanto

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps finance teams build rigorous merger models in Excel to analyze accretion/dilution, pro-forma P&L, synergy effects, and financing impact for deal evaluation.

Core Features & Use Cases

  • Pro-forma P&L construction and EPS impact assessment across multiple scenarios.
  • Synergy realization, financing mix planning, and sensitivity analyses for deal terms.
  • Use in M&A pitches, board materials, and diligence work to compare offers and financing structures.

Quick Start

Open the merger-model workbook, input the deal terms and financials, and review the resulting pro-forma EPS and P&L impact.

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 merger model in Excel?▼

To build an accretion dilution merger model in Excel, input deal terms and financials into the workbook to generate pro-forma P&L, synergy assumptions, and financing structures for EPS impact analysis.

What is accretion dilution analysis in M&A deal evaluation?▼

Accretion dilution analysis in M&A deal evaluation measures the pro-forma EPS impact of a transaction. It compares offer terms and financing mix to determine whether a deal increases or decreases shareholder value.

Can I run sensitivity analyses for financing structures and synergy realization in Excel?▼

Yes, you can run sensitivity analyses for financing structures and synergy realization in Excel. The workflow supports multiple scenarios to compare deal terms, financing mix, and synergy effects within a reproducible environment.

Does this merger modeling workflow require specific Excel plugins or dependencies?▼

No specific Excel plugins or dependencies are required. The workflow operates headlessly using openpyxl, allowing you to generate board materials and pitch decks without manual Excel intervention.

What is the best way to compare multiple M&A offers and financing terms?▼

The best way to compare M&A offers and financing terms is constructing a pro-forma P&L with synergy assumptions. This approach evaluates EPS impact across scenarios to identify the optimal deal structure.

When should I not use a simplified pro-forma P&L for deal evaluation?▼

A simplified pro-forma P&L is insufficient when evaluating complex transactions requiring detailed synergy realization schedules and financing mix sensitivity. Advanced models are necessary for rigorous board materials and diligence work.

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
SignmanalSignmanal
1

merger-model

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

Community
Intermediate
ronnycodingronnycoding
20

analyzing-financial-statements

Calculate and interpret financial ratios from income statements, balance sheets, and cash flow data.

Community
Intermediate
RheasilviaRheasilvia

merger-model

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

Community
Advanced