home / skills / a5c-ai / babysitter / lbo-model-builder

lbo-model-builder skill

safe

/plugins/babysitter/skills/babysit/process/specializations/domains/business/finance-accounting/skills/lbo-model-builder

This skill helps you build comprehensive Leveraged Buyout models for private equity analysis, detailing debt structures, equity waterfalls, and exit scenarios.

npx playbooks add skill a5c-ai/babysitter --skill lbo-model-builder

Review the files below or copy the command above to add this skill to your agents.

Files (1)

SKILL.md

2.8 KB

---
name: lbo-model-builder
description: Leveraged Buyout model construction skill for private equity transaction analysis
allowed-tools:
  - Read
  - Write
  - Glob
  - Grep
  - Bash
metadata:
  specialization: finance-accounting
  domain: business
  category: financial-modeling
  priority: lower
---

# 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

1. Stress test debt paydown under downside scenarios
2. Validate exit assumptions against comparable transactions
3. Model realistic covenant cushion requirements
4. Include management equity and incentive impacts
5. Consider refinancing optionality
6. Build in flexibility for multiple exit pathways

Overview

This skill builds detailed Leveraged Buyout (LBO) financial models to evaluate private equity transactions. It constructs sources & uses, multi-layered debt schedules, equity waterfalls, and exit scenarios to quantify returns and capital structure impacts. The output is designed to support investment decision-making with IRR, MOIC, cash flow, and sensitivity analyses.

How this skill works

The skill ingests target financial statements, purchase price inputs, debt instrument terms, and sponsor requirements, then constructs a full-period model that projects operating cash flows, interest and principal schedules, and equity distributions. It models PIK toggles, amortization, revolvers, and covenant checks while tracking accrued interest and balloon payments. Equity waterfalls calculate preferred/common splits, management pools, and promote mechanics. Results include levered/unlevered IRR, MOIC, debt capacity, and scenario sensitivity tables.

When to use it

Evaluating a potential private equity acquisition to estimate sponsor returns
Running debt capacity and covenant headroom analysis during financing negotiations
Comparing exit paths (trade sale, IPO, dividend recap) across multiple hold periods
Stress-testing transaction resilience under downside operating scenarios
Sizing management equity pools and modeling carry/promote effects

Best practices

Stress test multiple downside revenue and margin scenarios to validate debt paydown
Validate exit multiples and timing against comparable transactions and market data
Model realistic covenant cushions and include automatic covenant breach flags
Include explicit management equity grants and dilution impacts in the waterfall
Allow refinancing options and optional prepayments to assess optionality

Example use cases

Build a full LBO model from target historics to five-year projection, produce IRR and MOIC outputs
Optimize capital structure to maximize returns while preserving covenant headroom
Compare seller-financed vs. institutional debt outcomes including PIK toggles
Run sensitivity matrices on entry multiple, exit multiple, and EBITDA growth
Model partial exits and dividend recaps to show alternative liquidity paths

FAQ

Can the model handle multiple debt tranches with different amortization schedules?

Yes. The skill supports layered debt structures including term loans, revolvers, second lien, mezzanine, and bonds with independent amortization and interest treatments.

How are equity waterfalls and promotes modeled?

Waterfalls include preferred vs. common allocations, management equity pools, catch-up mechanics, and sponsor promote/carry structures, producing distribution schedules and net returns by stakeholder.