skills.rest
robertbr123
robertbr123COMMUNITY
Explore all skills by this author →
WebsiteGitHub

merger-model

Automate merger model creation with pro forma EPS and synergy analysis.

Updated May 9, 2026
Search Tags:#financial analysis#M&A#merger model#EPS analysis#accretion-dilution
One-click install
npx skills add https://github.com/robertbr123/Linket-Agent --skill merger-model-robertbr123
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/robertbr123/Linket-Agent/tree/main/optional-skills/finance/merger-model
Command: npx skills add https://github.com/robertbr123/Linket-Agent --skill merger-model-robertbr123

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of building detailed merger models, allowing for efficient financial analysis and deal evaluation.

Core Features & Use Cases

  • Build Accretion/Dilution Models: Construct comprehensive financial models for M&A transactions.
  • Pro Forma EPS Impact: Analyze the impact on earnings per share before and after a merger.
  • Synergy Sensitivities: Evaluate potential synergies and their impact on the deal.
  • Use Case: Utilize this Skill to prepare a merger model for a potential acquisition, helping to understand the financial implications and make informed decisions.

Quick Start

Run the 'merger-model' skill to generate a financial model for your M&A deal.

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 an M&A transaction?▼

To build an accretion dilution model, you need a tool that automates pro forma EPS impact analysis and purchase price allocation. This Skill generates detailed financial models for M&A transactions by evaluating synergies and structuring deal assumptions to show earnings impact.

What is pro forma EPS impact analysis in a merger model?▼

Pro forma EPS impact analysis in a merger model measures earnings per share changes before and after an acquisition. This Skill automates that calculation, alongside synergy sensitivities and purchase price allocation, to show whether a deal is accretive or dilutive.

How do I analyze synergy sensitivities for a potential acquisition?▼

To analyze synergy sensitivities, you input structured M&A data into a financial model that adjusts synergy assumptions. This Skill evaluates potential synergies and calculates their impact on the deal, allowing you to test various scenarios and make informed decisions.

Do I need openpyxl to generate Excel financial models for M&A deals?▼

Yes, you need openpyxl installed because this Skill requires it for Excel file manipulation. It relies on openpyxl to write the structured financial model outputs, including purchase price allocation and EPS analysis, directly into spreadsheet format.

What is the best way to automate purchase price allocation in a merger model?▼

The best way to automate purchase price allocation is using a dedicated financial modeling tool that accepts structured data inputs. This Skill automates that allocation process alongside pro forma EPS impact and synergy sensitivity analysis for comprehensive deal evaluation.

Related Skills

Explore More Finance & Accounting Skills→
seb1nseb1n
147

financial-report-generation

Generate formatted financial statements and executive summaries from trial balance data.

Community
Advanced
chekoschekos
5

financial-models

Provide financial modeling templates for revenue forecasting and P&L statements.

Community
Basic
ganoroganoro

Valuation Analysis

Perform fair value analysis for PE/VC portfolio companies using DCF, comparables, and precedent transactions.

Community
Advanced
davpatel605-beepdavpatel605-beep

lbo-model

Build leveraged buyout models with Excel valuation and financing analyses.

Community
Advanced