skills.rest
LynxLabVN
LynxLabVNOFFICIAL
Explore all skills by this author →
GitHub

merger-model

Automate accretion/dilution models for M&A transactions with pro forma EPS calculations.

Updated Jul 3, 2026
Search Tags:#financial analysis#M&A#accretion dilution#merger modeling#pro forma analysis
One-click install
npx skills add https://github.com/LynxLabVN/office-agent --skill merger-model-lynxlabvn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/LynxLabVN/office-agent/tree/main/agent-core/optional-skills/finance/merger-model
Command: npx skills add https://github.com/LynxLabVN/office-agent --skill merger-model-lynxlabvn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, excel-author, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps to automate the construction of accretion/dilution models for M&A transactions, simplifying the process of financial analysis and providing a comprehensive view of potential deals.

Core Features & Use Cases

  • Accretion/Dilution Analysis: Models the impact of a merger or acquisition on financial metrics.
  • Pro Forma EPS Calculation: Projects the effect of the deal on the combined entity's earnings per share.
  • Synergy Sensitivity Analysis: Evaluates the impact of various synergy scenarios on the deal's success.
  • Use Case: A financial analyst can use this Skill to prepare a pro forma financial statement for a potential acquisition target, considering various deal terms and synergy scenarios.

Quick Start

Run the 'merger-model' skill to build a pro forma P&L and assess the EPS impact of a merger transaction.

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 for M&A transactions?▼

M&A accretion dilution analysis measures the impact of a merger or acquisition on the combined entity's earnings per share. This skill automates the process by constructing pro forma statements and calculating the projected EPS impact.

What's the best way to calculate pro forma EPS impact for an acquisition target?▼

Pro forma EPS calculation requires combining financial statements and modeling synergies. This skill automates pro forma financial statement construction to project the exact effect of deal terms on the combined earnings per share.

How does synergy sensitivity analysis work in merger modeling?▼

Synergy sensitivity analysis evaluates the impact of various synergy scenarios on a deal's success. The skill automates this by adjusting pro forma financial statement inputs to measure how different synergy levels affect the EPS impact.

Do I need openpyxl to generate Excel output for M&A financial analysis?▼

Yes, you need the headless openpyxl library and the 'excel-author' skill installed as dependencies. This skill requires them to generate Excel outputs for your M&A financial analysis and accretion dilution models.

Can I use Excel to automate pro forma analysis for different deal terms?▼

Yes, you can automate pro forma analysis for different deal terms in Excel. The skill uses openpyxl and excel-author to construct statements and evaluate how various transaction structures and synergy scenarios affect financial metrics.

Related Skills

Explore More Finance & Accounting Skills→
aayushsoamaayushsoam
1

3-statement-model

Automate creation and analysis of integrated income statement, balance sheet, and cash flow models.

Community
Advanced
SignmanalSignmanal
1

merger-model

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

Community
Intermediate
guoliang1114-boopguoliang1114-boop
43

valuation-and-pricing

Generate corporate valuation reports with DCF, comps, precedents, and LBO pricing.

Community
Advanced
davpatel605-beepdavpatel605-beep

merger-model

Build accretion and dilution merger models for acquisition evaluations.

Community
Advanced