merger-model

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

1|Updated Jun 25, 2026
One-click install
npx skills add https://github.com/Signmanal/VIGIL --skill merger-model-signmanal
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/Signmanal/VIGIL/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/Signmanal/VIGIL --skill merger-model-signmanal

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manual M&A accretion/dilution modeling is slow, error-prone, and requires specialized financial modeling expertise, leading to inconsistent deal analysis and delayed decision-making for corporate development and investment banking teams.

Core Features & Use Cases

  • End-to-End Merger Model Build: Generates full pro-forma P&L, sources & uses, and purchase price allocation for M&A transactions.
  • EPS Impact & Sensitivity Analysis: Calculates year-by-year accretion/dilution, runs synergy and premium sensitivity tables, and computes breakeven synergy thresholds.
  • Use Case: Use this Skill to prepare merger consequences analysis for an acquisition pitch, board materials, or internal deal evaluation, ensuring consistent, auditable financial outputs.

Quick Start

Use the merger-model skill to build a full accretion/dilution analysis for the Acme-Target acquisition with a 25% cash consideration mix and $50M annual cost synergies.

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 M&A accretion/dilution model in Excel without manual calculation errors?

You can build an M&A accretion/dilution model in Excel by using this skill to automatically generate pro-forma P&L, sources and uses, and purchase price allocation, eliminating manual effort and calculation errors for investment banking workflows.

What is included in a full merger consequences analysis for pitch books?

A full merger consequences analysis includes pro-forma income statements, sources and uses tables, purchase price allocation, year-by-year EPS impact, and synergy sensitivity tables formatted for compliant Excel workbooks to support pitch books and board materials.

How do I calculate breakeven synergy thresholds and run sensitivity tables for an acquisition?

To calculate breakeven synergy thresholds, this skill runs synergy and premium sensitivity tables automatically, computing year-by-year accretion/dilution and EPS impact to identify the exact synergy levels required for a transaction to be neutral.

Can I generate formatted Excel workbooks for corporate development deal evaluation using openpyxl?

Yes, you can generate formatted Excel workbooks for corporate development deal evaluation because this skill uses openpyxl and excel-author conventions to produce compliant outputs with structured assumptions, pro-forma income statements, and sensitivity tables.

What is the best way to automate pro-forma P&L construction and purchase price allocation for M&A transactions?

The best way to automate pro-forma P&L construction and purchase price allocation is to use this skill, which supports end-to-end merger transaction analysis and generates auditable financial outputs for internal deal evaluation.

Does this M&A modeling approach support testing different cash and stock consideration mixes?

Yes, this M&A modeling approach supports testing different consideration mixes, allowing you to specify cash and stock ratios like a 25% cash consideration mix and immediately assess the resulting accretion/dilution impact and synergy sensitivities.