CMD WIRE
WhatDoYouGot? CONSOLIDATED MARKET DATA
Home > Tools > Structured Credit & RV > CLO Tranche Waterfall Simulator
Active Desk: Financial Tools & Quantitative Models
SWITCH DESK Commercial & Small Business Credit Desk →
DESK 11 // STRUCTURED CREDIT & RELATIVE VALUE FULL PERFORMANCE // NORMAL WATERFALL DISTRIBUTION

CLO Tranche Waterfall & Loss Absorption Simulator

Model a standard $500M institutional Collateralized Loan Obligation (CLO 2.0/3.0) capital structure. Evaluate priority of payments waterfalls, Overcollateralization (OC) test diversion triggers, subordination cushions, and tranche loss attachment under stress default rates.

Authoritative Reference METHODOLOGY • COVENANTS • PROOF

Institutional Methodology & Underwriting Dossier

Simulates a $500M institutional Collateralized Loan Obligation (CLO 2.0/3.0) debt capital structure, evaluating interest and principal waterfalls, Overcollateralization (OC) and Interest Coverage (IC) test diversion triggers, and tranche loss attachment under stress default rates.

1. Target Audience & Practical Application

How different financial market participants apply this quantitative model to real-world capital allocation:

Structured Credit & CLO Debt Investors

Assess subordination credit enhancement, rating migration risk, and cash flow priority across AAA to BB tranches.

Private Credit & Leveraged Loan Desks

Underwrite syndicated senior secured loan portfolio default absorption and recovery rate expectations.

CLO Equity Fund Managers

Model residual cash distributions, reinvestment period optionality, and collateral par-building mechanics.

Institutional Insurance & Pension Allocators

Verify regulatory capital risk-weighting charges (NAIC / Solvency II) and ratings downgrade sensitivities.

2. CLO Cash Flow Waterfall & Coverage Test Formulations

1. Overcollateralization (OC) Ratio:
OC_Ratio = (Performing_Loan_Par + Cash + Recovery_from_Defaults) / Cumulative_Senior_Debt_Par
Breached if OC_Ratio < Contractual_Threshold (e.g., 120%). Triggers senior note amortisation.

2. Interest Coverage (IC) Ratio:
IC_Ratio = Net_Collateral_Interest_Income / Due_Senior_Tranche_Interest
Breached if IC_Ratio < 115%. Forces equity/mezz cash diversion to senior debt paydown.

3. Tranche Loss Attachment & Detachment (%):
Attachment_Point = Subordinated_Capital / Total_Pool_Par
Net Cumulative Loss = Cumulative_Default_Rate × (1 - Recovery_Rate)

3. CLO Structural Protections & Liquidity Covenants

  • Sequential Cash Flow Enforcement: CLO waterfalls mandate that senior AAA notes receive full contractual interest and scheduled principal before any junior mezzanine tranche receives payments.
  • OC / IC Test Auto-Remediation: When cumulative loan defaults or CCC rating downgrades erode collateral par below contractual OC thresholds, all cash flows destined for junior debt and equity tranches are automatically diverted to pay down senior AAA notes at par, restoring credit enhancement.
  • Reinvestment Period Covenants: During the initial 4-5 year reinvestment period, the collateral manager can reinvest loan prepayments into new loans, preserving equity optionality as long as weighted average spread (WAS) and rating factor (WARF) covenants are met.

4. Frequently Asked Questions (FAQ)

How does a Collateralized Loan Obligation (CLO) debt waterfall work?
A CLO pools hundreds of syndicated senior secured corporate loans (typically $500M) and issues tranches of rated debt securities (AAA, AA, A, BBB, BB) and an unrated Equity tranche. Interest and principal payments from the underlying loans flow strictly sequentially from the top (AAA) to bottom (Equity).
What happens when a CLO Overcollateralization (OC) test is breached?
When loan defaults or severe rating downgrades reduce collateral par value below the required threshold, the OC test trips. Junior coupon payments and equity distributions are immediately cut off and redirected to pay down the most senior AAA notes until the required coverage ratio is restored.
Why have AAA-rated CLO tranches historically experienced near-zero defaults?
AAA CLO tranches typically feature 35% to 40% subordination, meaning more than a third of the entire underlying collateral pool must suffer a total loss before the AAA tranche loses a single dollar of principal. Even during the 2008 GFC, US CLO AAA tranches did not default.
What determines the returns to the CLO Equity tranche?
CLO Equity receives the residual spread between the interest collected from leveraged loans (typically SOFR + 350-450 bps) and the blended borrowing cost of the rated debt tranches (typically SOFR + 150-200 bps), minus management fees and actual default losses.
Collateral Pool & Default Shocks $500M Structure
Net Lifetime Portfolio Loss 3.4% CDR × (1 - Recovery) × Life
Cumulative Dollar Loss $16.8M Absorbed by subordinated stack
Senior Class A/B OC Ratio 132.4% Contractual trigger: 121.5%
Equity Cash Distribution Yield 14.6% Residual cash flow APY
Class A (AAA) Impairment $0.00 (Unimpaired) Subordination cushion: 38.0%
Equity Principal Loss -$16.8M (34%) First-loss protection absorb
CLO Capital Structure Tranche Stack Subordination & Loss Absorption
AAA Senior ($310M): Performing (Par $310M) Subordination: 38.0% | S+140 AA Mezz ($55M): Performing Subordination: 27.0% | S+185 A Mezz ($30M): Performing Subordination: 21.0% | S+235 BBB Mezz ($30M): Performing Subordination: 15.0% | S+350 BB Junior ($25M): Performing Subordination: 10.0% | S+675 Equity Sub ($50M): First-Loss Absorber Residual Cash Flow
• Losses flow upward: Equity → BB → BBB → A → AA → AAA • AAA has 38% subordination cushion (unimpaired in GFC)
2D Credit Loss & Tranche Impairment Matrix Cumulative Life Loss & Vulnerability
Annual Default (CDR) 40% Recovery 50% Recovery 60% Recovery 65% Recovery 75% Recovery

Stress matrix simulates cumulative 5-year loan defaults and recoveries. Shows whether equity retains residual value or whether losses reach rated debt tranches.