name: merger-model-builder
description: M&A merger model construction skill with accretion/dilution analysis and synergy modeling
allowed-tools:
- Read
- Write
- Glob
- Grep
- Bash
metadata:
specialization: finance-accounting
domain: business
category: investment-analysis
priority: medium
graph:
domains: [domain:finance]
specializations: [specialization:corporate-finance]
skillAreas: [skill-area:financial-modeling, skill-area:budgeting-forecasting, skill-area:investment-analysis, skill-area:valuation-analysis]
workflows: [workflow:financial-planning, workflow:budget-planning]
roles: [role:financial-analyst]
Merger Model Builder
Overview
The Merger Model Builder skill creates comprehensive merger models for M&A transaction analysis. It enables purchase price allocation, accretion/dilution analysis, and pro forma financial modeling for deal evaluation.
Capabilities
Purchase Price Allocation
- Fair value determination
- Asset identification
- Liability assumption
- Intangible asset valuation
- Contingent consideration
- Working capital adjustments
Goodwill Calculation
- Purchase consideration
- Fair value of net assets
- Bargain purchase assessment
- Measurement period adjustments
- Allocation documentation
- Impairment considerations
Accretion/Dilution Analysis
- Pro forma EPS calculation
- Standalone EPS comparison
- Breakeven synergy analysis
- Sensitivity tables
- Year-by-year analysis
- Cash vs. stock consideration impact
Synergy Modeling
- Revenue synergy identification
- Cost synergy quantification
- Phase-in timing
- Integration cost estimation
- Run-rate calculation
- Synergy NPV analysis
Pro Forma Financials
- Combined income statement
- Combined balance sheet
- Combined cash flow statement
- Financing adjustments
- Transaction accounting
- Stub period handling
Contribution Analysis
- Revenue contribution
- EBITDA contribution
- Net income contribution
- Ownership percentage
- Value creation allocation
- Exchange ratio analysis
Usage
Deal Evaluation
Input: Acquirer and target financials, deal terms, synergy assumptions
Process: Build pro forma model, analyze accretion/dilution
Output: Merger analysis, contribution metrics, board presentation
Deal Structuring
Input: Valuation targets, EPS constraints, financing capacity
Process: Optimize consideration mix, model scenarios
Output: Recommended deal structure, sensitivity analysis
Integration
Used By Processes
- M&A Financial Due Diligence
- Comparable Company Analysis
- Discounted Cash Flow (DCF) Valuation
Tools and Libraries
- Financial modeling templates
- Deal structuring tools
- Purchase accounting modules
Best Practices
- Align accounting treatment with deal structure
- Build flexibility for multiple scenarios
- Model synergies conservatively
- Include integration costs realistically
- Sensitivity test key assumptions
- Document all adjustments and sources