Fundamentals & Valuation
lbo-model-builder
LBO Model Builder constructs full-featured leveraged buyout models to evaluate private equity acquisitions, optimize capital structure, and quantify investor returns.
Resumen
LBO Model Builder constructs full-featured leveraged buyout models to evaluate private equity acquisitions, optimize capital structure, and quantify investor returns.
LBO Model Builder constructs full-featured leveraged buyout models to evaluate private equity acquisitions, optimize capital structure, and quantify investor returns. Key features include sources & uses and purchase price calibration, detailed debt schedules (senior loans, revolver, second lien, mezzanine, high-yield) with amortization, PIK toggle and accrued interest tracking, and comprehensive equity waterfall modeling (preferred/common equity, management pool, promote/catch-up). The skill computes levered and unlevered IRR, MOIC, cash-on-cash and gross/net return measures, and runs exit scenario and sensitivity analysis (exit multiples, IPO vs strategic sale, dividend recaps, partial exits, hold periods). Typical use cases are deal screening, debt capacity and covenant headroom analysis, financing negotiation support, and board-level returns reporting. Advantages include standardized templates, customizable assumptions, stress testing, and clear outputs for transaction decision-making.
Skill.md
Cómo funciona esta Skill
LBO Model Builder constructs full-featured leveraged buyout models to evaluate private equity acquisitions, optimize capital structure, and quantify investor returns.
LBO Model Builder
Overview
The LBO Model Builder skill creates comprehensive Leveraged Buyout models for private equity transaction analysis. It enables detailed modeling of debt structures, equity returns, and exit scenarios to evaluate potential acquisitions.
Capabilities
Sources and Uses of Funds
- Purchase price calculation
- Transaction fee estimation
- Financing fee capitalization
- Equity contribution sizing
- Debt quantum determination
- Working capital adjustments
- Balance sheet cash treatment
Debt Schedule Construction
- Senior secured term loans
- Revolving credit facility
- Second lien debt
- Subordinated notes
- High yield bonds
- Mezzanine financing
- Amortization schedules
PIK Toggle Modeling
- Payment-in-kind interest calculation
- PIK toggle conditions
- Accrued interest tracking
- Covenant considerations
- Tax treatment modeling
- Balloon payment timing
Equity Waterfall Calculations
- Preferred equity treatment
- Common equity allocation
- Management equity pool
- Promote/carry structures
- Catch-up provisions
- Distribution priorities
IRR and MOIC Computation
- Levered IRR calculation
- Unlevered IRR analysis
- Multiple of invested capital
- Cash-on-cash returns
- Time-weighted returns
- Gross vs. net returns
Exit Scenario Analysis
- Exit multiple assumptions
- Strategic vs. financial buyer
- IPO exit modeling
- Dividend recapitalization
- Partial exit scenarios
- Hold period sensitivity
Usage
Transaction Evaluation
Input: Target financials, purchase price, debt terms, sponsor requirements
Process: Build LBO model with debt paydown and exit scenarios
Output: Returns analysis, debt capacity assessment, sensitivity tables
Debt Capacity Analysis
Input: Cash flow projections, covenant requirements, market terms
Process: Optimize capital structure for returns while maintaining covenants
Output: Maximum debt capacity, recommended structure, covenant headroom
Integration
Used By Processes
- M&A Financial Due Diligence
- Capital Investment Appraisal
- Discounted Cash Flow (DCF) Valuation
Tools and Libraries
- Python financial libraries
- Excel automation
- Private equity modeling templates
Best Practices
- Stress test debt paydown under downside scenarios
- Validate exit assumptions against comparable transactions
- Model realistic covenant cushion requirements
- Include management equity and incentive impacts
- Consider refinancing optionality
- Build in flexibility for multiple exit pathways
Ideal para
Cuándo usarla
LBO Model Builder constructs full-featured leveraged buyout models to evaluate private equity acquisitions, optimize capital structure, and quantify investor returns.
01 · ANTES DE LA REUNIÓN
Prepara un informe de decisión
Convierte evidencia dispersa en un caso estructurado antes del comité de inversión.
02 · FLUJO DE EQUIPO
Estandariza los traspasos
Genera resultados de research consistentes entre analistas, gestores de cartera y agents.
03 · ACTUALIZACIÓN EN VIVO
Refresca la tesis
Actualiza los escenarios tras un nuevo catalizador, la publicación de un KPI o un resultado trimestral.
Notas de la comunidad
Mejora a medida que se usa.
Los comentarios aparecerán aquí a medida que esta Skill se use y se revise.
Descubre más
Skills relacionadas
Ver todasIndustry Primer
Analyze an industry's structure, profit pools, key players, supply chain, and regime drivers. Use when starting research on an industry, mapping market structure, or framing sector-level opportunity…
Bear Case Builder
Stress test consensus with bearish counter-narratives, failure modes, and probability-severity analysis. Use when building downside cases, short theses, or risk scenarios against a bullish narrative.
Business Model Comp Matching
Match a company to the right peer set by business model, revenue mix, margin structure, and economics. Use when standard comp sets are misleading or when the user asks for more precise peer selection.