Merger Model Builder
Businessmerger-model-builderMerger Model Builder is an Agent Skill for business published in the a5c-ai/babysitter repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
M&A merger model construction skill with accretion/dilution analysis and synergy modeling
QUICK START
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/a5c-ai/babysitter/blob/HEAD/library/specializations/domains/business/finance-accounting/skills/merger-model-builder/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/merger-model-builder, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
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