Distribution Waterfall Introduction

Finance-specific summary (Distribution Waterfall / Private Equity)

The video explains how a private equity distribution waterfall allocates investment proceeds between LPs (limited partners) and the GP (general partner). It covers common fee/catch-up structures (often called “ketchup”) and shows how to model the mechanics in Excel.

Instruments / tickers / assets mentioned

• None (no public market tickers, ETFs, bonds, commodities, or crypto mentioned)

Key concepts and structure

• Step 1 & 2 (LP priority):

  1. Return principal to LPs
  2. Pay a preferred return on that principal

• “Ketchup” / Catch-up to GP: A transitional allocation that allows the GP to receive additional distributions before the final split.

• Final split: After hurdles/catch-up, remaining proceeds are split:

  • 80% to LP
  • 20% to GP

Explicit framework / step-by-step methodology

The video repeatedly references the logic of “steps” used to compute each distribution amount:

• Step 1: Distribute cash to LPs to return original invested principal (“first dollars out”).
• Step 2: Pay LPs the preferred return on principal (example uses 8% cumulative).
• Step 3 (“ketchup” / catch-up):
  • GP receives a catch-up amount intended to be 20% of specified cash flows depending on the template variant.
  • The ketchup computation uses an 80% divisor (i.e., divide by 0.80) to align the post-catch-up relationship with an 80/20 structure.
• Final split (after catch-up): Remaining proceeds are distributed 80% LP / 20% GP.

Key numbers & timeline

• Preferred return: 8%
• Annualized timing example: from 12/31/2020 to 12/31/2025 (5-year horizon)
• Example valuation output (preferred return + principal):
  • $14,693,281 (shown in the explanation after applying the formula)

Carry / catch-up mechanics

• “Ketchup” is described as generally equivalent to 20% of earlier cash inflows (wording varies by template version).
• Example proceeds scenarios mentioned include:
  • $30M
  • A hypothetical $15M
  • Testing inputs such as $12M to determine whether the waterfall can fully complete ketchup/hurdles

Method details (how ketchup is calculated)

Template 1 (simplified / earlier example; broader cash-flow base)

Ketchup required is computed via:

• ketchup value = (total proceeds in steps 1 & 2) / 80% − (principal + preferred return)

Interpretation provided:

• Steps 1 & 2 represent 80% of the relevant total, so dividing by 80% effectively “back-solves” the total needed to trigger the GP catch-up.

Template 3 (most common example; narrower base)

Catch-up is based only on later-step distributions:

• Catch-up is only 20% of distributions realized in step 2 + step 3 (i.e., a narrower base than Template 1)

Practical effect shown in Excel:

• Prior ketchup ≈ $3.7M
• Revised ketchup ≈ $1.2M

The video describes the cell-logic approach as:

• Take the “divided-by-80%” back-solved amount, then subtract:
  • the principal
  • and then subtract the preferred return
• What remains is the ketchup portion.

Performance/risk metrics mentioned

• IRR / hurdle language appears (including reference to preferred return and IRR-style hurdle concepts).
• No broader portfolio performance metrics are discussed (e.g., Sharpe, drawdown, volatility).
• The focus is on correct waterfall allocation logic, not portfolio performance measurement.

Explicit recommendations / cautions

• Check your math when building waterfall templates.
• Use min/max functions to handle insufficient proceeds scenarios:
  • If total proceeds are too low to complete later steps, distributions should cap at available proceeds.
• Recommended scenario testing:
  • Test lower proceeds (e.g., $15M vs $30M and $12M) to confirm schedule behavior and ensure the min/max logic works.

Disclosures / disclaimers

• No explicit “not financial advice” disclaimer appears in the provided subtitles.

Presenters / sources

• The subtitles refer to “guys/teams” but do not name a specific presenter or provide an identifiable external source.