skills.rest
SriRamkunamsetty
SriRamkunamsettyCOMMUNITY
Explore all skills by this author →
𝕏@SriRam41258GitHub

merger-model

Compute accretion/dilution analysis for M&A transactions with pro forma EPS and synergy sensitivity.

Updated May 20, 2026
Search Tags:#finance#excel#model#valuation#dilution#merger#accretion
One-click install
npx skills add https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent --skill merger-model-sriramkunamsetty
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merger-model
Source: https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent/tree/main/hermes-agent/optional-skills/finance/merger-model
Command: npx skills add https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent --skill merger-model-sriramkunamsetty

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Builds and analyzes merger scenarios in Excel to show accretion/dilution impact for an M&A deal, including EPS effects, synergies, and financing considerations.

Core Features & Use Cases

  • Pro forma EPS impact: Calculate standalone vs. pro forma earnings per share.
  • Synergy modeling: Quantify revenue and cost savings and their tax effects.
  • Sources & Uses and PPA: Allocate deal financing and capture goodwill/intangibles implications.

Quick Start

Provide deal inputs (acquirer/target data, offer terms, and expected synergies) and execute the merger-model workflow to produce pro forma EPS and sensitivity outputs.

Frequently Asked Questions about merger-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate accretion and dilution for an M&A transaction in Excel?▼

Accretion/dilution analysis calculates standalone vs. pro forma earnings per share to determine if a merger increases or decreases the buyer's EPS. This Skill computes M&A pro forma EPS impacts directly in Excel.

What inputs do I need to build a pro forma EPS model for a merger?▼

Building a pro forma EPS model requires acquirer and target financial data, offer terms, and expected synergies. The workflow gathers these inputs to calculate consolidated EPS and produce sensitivity outputs.

Can I model synergy sensitivity and tax effects in a merger analysis?▼

Yes, synergy sensitivity modeling quantifies revenue and cost savings along with their tax effects. The analysis applies these synergy inputs to generate pro forma EPS and sensitivity tables for the M&A deal.

How does a sources and uses analysis work for acquisition financing?▼

Sources and uses analysis allocates deal financing by mapping where acquisition funds come from and where they are applied. The Skill generates a consolidated output workbook detailing this financing allocation.

Does this merger model capture purchase price allocation and goodwill?▼

Yes, the merger model captures purchase price allocation (PPA) and its implications for goodwill and intangibles. It integrates these PPA outputs into the consolidated Excel workbook alongside EPS summaries.

What is the best way to evaluate deal financing scenarios for an acquisition?▼

Evaluating deal financing scenarios requires combining sources and uses, synergy impacts, and pro forma EPS calculations. This Skill produces a consolidated Excel workbook mapping these assumptions to deal evaluation outputs.

Related Skills

Explore More Finance & Accounting Skills→
mouseqiao85mouseqiao85
1

merger-model

Generate accretion and dilution analysis for M&A transactions with financial parameters and synergies.

Community
Advanced
blueskies1818blueskies1818
1

merger-model

Construct M&A financial models with pro-forma statements, synergy analysis, and EPS impact.

Community
Advanced
executiveusaexecutiveusa

Merger Model

Calculate merger accretion/dilution and pro forma EPS impact for M&A deals.

Community
Advanced
LerianStudioLerianStudio
205

financial-modeling

Automate construction and validation of DCF, LBO, merger, and operating financial models.

Official
Advanced