skills.rest
open-neko
open-nekoOFFICIAL
Explore all skills by this author →
GitHub

merger-model

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

11|Updated May 6, 2026
Search Tags:#excel#financial-modeling#investment-banking#accretion-dilution#merger-model#synergy-analysis#m-and-a
One-click install
npx skills add https://github.com/open-neko/openneko --skill merger-model-open-neko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/open-neko/openneko/tree/main/packages/llm/assets/builtin-skills/merger-model
Command: npx skills add https://github.com/open-neko/openneko --skill merger-model-open-neko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Building accurate accretion/dilution merger models for M&A transactions is time-consuming, requires deep financial modeling expertise, and is prone to critical errors that can mislead deal decisions. This Skill automates the end-to-end creation of these models, eliminating manual spreadsheet work and ensuring consistency with industry-standard M&A analysis practices.

Core Features & Use Cases

  • Full Pro Forma M&A Modeling: Automatically generates complete accretion/dilution analyses including purchase price allocation, pro-forma P&L, and EPS impact calculations for Year 1-3.
  • Sensitivity & Breakeven Analysis: Builds dynamic sensitivity tables for synergies, offer premium, and cash/stock mix, plus calculates the minimum synergies required for a deal to be EPS-neutral.
  • Use Case: An investment banker preparing a board presentation for a $200M acquisition can use this Skill to quickly model multiple deal term scenarios, validate EPS impact, and produce a polished Excel workbook and one-page summary for stakeholders.

Quick Start

Use the merger-model skill to build a full accretion/dilution analysis for the acquisition of Target Corp by Acme Inc with a 25% cash / 75% stock consideration mix, 20% offer premium, and $40M in phased 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 accretion dilution merger model in Excel for M&A deal analysis?▼

An accretion/dilution merger model evaluates the financial impact of M&A transactions on acquirer earnings per share. This Skill automates building Excel workbooks with pro-forma income statements, sources and uses tables, purchase price allocation, and EPS impact calculations.

Can I automatically generate sensitivity analysis and breakeven synergy calculations for an LBO or M&A model?▼

Yes, you can generate dynamic sensitivity tables for synergies, offer premium, and cash/stock mix. The model also calculates the minimum synergies required for a deal to be EPS-neutral, automating breakeven synergy calculations for M&A analysis.

How does purchase price allocation work in a pro-forma M&A financial model?▼

Purchase price allocation in a pro-forma M&A model distributes the acquisition price across target assets and equity. This Skill automates the allocation process and generates complete pro-forma P&L and EPS impact calculations for public and private company acquisitions.

What is the best way to model multiple deal term scenarios for an investment banking board presentation?▼

Modeling multiple deal term scenarios requires varying cash/stock consideration, offer premium, and synergy inputs. This Skill generates a polished Excel workbook and summary, allowing investment bankers to validate EPS impact and model various acquisition scenarios quickly.

Do I need openpyxl to create financial modeling workbooks for acquisition accretion dilution analysis?▼

The Skill generates Excel workbooks following openpyxl and excel-author skill conventions, producing formatted pro-forma income statements and sensitivity tables. It handles the spreadsheet generation end-to-end, eliminating manual Excel work for M&A analysis.

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
RheasilviaRheasilvia

merger-model

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

Community
Advanced
open-nekoopen-neko
11

dcf-model

Build DCF valuation models with live Excel workbooks and sensitivity tables.

Official
Advanced
zangjeicyzangjeicy

lbo-model

Construct dynamic leveraged buyout models in Excel with formula-based projections.

Community
Advanced