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
code
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
code
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