CLO Valuation
Cashflow Waterfall

Model Assumptions

Every CLO valuation model begins with a set of portfolio and market assumptions. These drive both the income available for distribution and the credit stress scenarios that test structural resilience. Below are the base-case assumptions used throughout this tutorial — all numbers that follow are derived from exactly these inputs.

The portfolio is a diversified pool of 187 leveraged loans with a combined par value of £500m. The gross yield of 9.08% reflects the current SOFR base rate plus the weighted average spread on loans. Credit assumptions — CDR 2.5%, recovery 65%, CPR 18% — represent a benign-to-moderate credit environment consistent with historical norms outside of recession.

Capital Structure

The CLO issues seven classes of securities totalling £500m — the same amount as the loan portfolio par. Six classes are rated debt tranches (A through F), and one is unrated equity. Each tranche has a fixed spread over SOFR; its all-in coupon resets quarterly as SOFR moves.

The capital stack is arranged so that credit losses are absorbed from the bottom up: equity bears the first loss, then Class F, then Class E, and so on. Conversely, cash flows from the portfolio are distributed top-down, with Class A receiving its interest before any other tranche is paid. This seniority structure is enforced mechanically through the waterfall.

The Equity Tranche — What Residual Holders Receive

The table above shows no coupon for the equity tranche because equity holders do not receive a fixed payment. They receive whatever cash remains after every debt tranche and every fee has been paid in full each quarter. Summing the six debt coupons from the table above gives total quarterly debt service of £8.092m. After deducting that and the £0.919m in quarterly fees (senior expenses £0.200m + senior management fee £0.219m + subordinated management fee £0.500m) from the £11.350m of gross quarterly interest income, the equity residual is:

Annualised, the £9.36m represents a 15.6% gross return on the £60m equity investment. This return is generated entirely by structural leverage: the CLO borrows £440m at a blended cost of 7.35% p.a. and invests those funds — alongside the equity — in loans yielding 9.08% p.a.

Excess Spread — Reconciling the Two Rates

The 7.35% blended debt cost is the face-value-weighted average of the six tranche coupons, calculated against the £440m of total debt outstanding. The 9.08% portfolio yield is measured against the full £500m of assets. To compare them on equal terms, the debt cost must be scaled to a £500m base — dividing total annual debt interest (£32.37m) by portfolio par (£500m) gives 6.47%, not 7.35%. The table below sets out the correct decomposition:

After Expected Credit Losses

The £9.35m excess spread is the income available to equity before accounting for loan defaults. Under the base-case CDR of 2.5% p.a. with a 65% recovery rate, the loss-given-default (LGD) on each defaulting loan is 35%:

During the four-year reinvestment period the CLO manager reinvests recovered principal and prepayment proceeds to maintain portfolio par at £500m, so gross interest income remains stable at £11.35m per quarter even as individual loans default. The credit losses therefore reduce the terminal principal available to equity rather than cutting quarterly distributions pound-for-pound. On a simple annualised basis, netting losses against the pre-loss excess spread gives an indicative equity cash yield:

The 8.3% is a simplified single-year estimate. The full lifecycle equity IRR — which captures the compounding effect of reinvestment, the timing of principal amortisation post-reinvestment-period, and the residual principal returned to equity at deal maturity — is 16.2% in the base case. That full scenario analysis is set out in Section 09.

Quarterly Cashflow Waterfall — Q1 Base Case

The interest waterfall runs every quarter on a payment date. Cash enters at the top as gross interest income from the loan portfolio. It then flows step-by-step down the priority of payments: fees first, then senior debt, then junior debt, then subordinated fees, and finally any residual to equity. OC and IC tests are checked at designated points; a failure diverts cash upward to cure the breach.

The table below shows every step of the Q1 waterfall in the base case (CDR 2.5%, 65% recovery, portfolio par maintained at £500m through reinvestment). Amounts in red are outflows; amounts in green are cumulative cash remaining after each payment.

Starting cash (gross interest):        £11.350m
  Less: Senior expenses                 £0.200m
  Less: Senior management fee           £0.219m
  Less: Class A interest                £5.424m   (6.78% ÷ 4 on £320m)
  Less: Class B interest                £0.764m   (7.28% ÷ 4 on £42m)
  Less: Class C interest                £0.552m   (7.88% ÷ 4 on £28m)
  Less: Class D interest                £0.488m   (8.88% ÷ 4 on £22m)
  Less: Class E interest                £0.512m   (11.38% ÷ 4 on £18m)
  Less: Class F interest                £0.352m   (14.08% ÷ 4 on £10m)
  Less: Sub management fee              £0.500m
─────────────────────────────────────────────────
Equity residual:                       £2.339m
Annualised yield on £60m equity:       15.6%
All OC tests:                          PASS (min cushion +11.6pp, Class F)

Overcollateralisation & Interest Coverage Tests

OC and IC tests are the structural guardrails that protect senior noteholders. They run at every payment date. When a test fails, cash that would otherwise flow to junior tranches and equity is instead trapped and used to pay down senior principal — reducing the denominator and restoring the ratio above the floor.

The OC ratio for any class is calculated as: portfolio par divided by the outstanding balance of that class plus all classes senior to it. Note that CCC-rated and defaulted assets are subject to haircuts in this calculation — a key mechanism that tightens ratios when credit quality deteriorates.

OC Test Results — Q1 Base Case

Interest Coverage Tests — Q1 Base Case

The IC test compares quarterly interest income (£11.35m) against the cumulative interest due to all classes at and senior to each test class. Unlike the OC test, which uses par values, the IC test uses actual cash interest.

Senior Tranche Valuation — Class A (AAA)

CLO AAA notes trade as spread products. Because the coupon floats with SOFR, interest rate duration is minimal — price sensitivity is driven almost entirely by credit spread movements, expressed as a discount margin (DM). The DM is the constant spread over SOFR that, when applied to each future cash flow, equates the present value to the observed market price.

Class A has a WAL of approximately 5.5 years (22 quarters in the base model). At issuance, it priced at par (100.00) with a coupon spread of 148bps. The current secondary market DM of 140bps reflects marginal tightening — the note trades slightly above par at 100.37.

Class A — DM vs. Price Sensitivity

Mezzanine Tranche Valuation — Classes B, C, D

Mezzanine tranches (AA to BBB) are valued on the same DM framework as the senior, but carry meaningfully wider spreads to compensate for their subordinated position. Their price sensitivity to spread movements is slightly higher because their shorter WALs mean a faster return of principal in amortisation — but they face greater OC test diversion risk when credit deteriorates.

Base Case Pricing — Classes B, C, D

OC Failure Stress Scenario — Class D Impact

Consider a stressed scenario where the CDR rises to 7.0% and the CCC bucket reaches 15% of par (£75m). Rating agencies require CCC assets above the 7.5% bucket limit to be carried at market value, say 70 cents. The OC haircut on the excess £37.5m = £37.5m × (1 − 0.70) = £11.25m. Adjusted portfolio par falls to £452m.

Junior Tranche Valuation — Classes E & F

Junior tranches (BB and B rated) sit just above equity in the capital stack. They offer materially higher spreads — 608bps and 878bps respectively — but face significantly higher risk of OC test diversion and, in severe scenarios, principal impairment. Their valuation is still DM-based, but with much wider spread ranges and greater sensitivity to default assumptions.

Class E — BB Rated, WAL 4.5 Years

Class F — B Rated, WAL 4.2 Years

Equity Tranche Valuation

CLO equity receives no fixed coupon — it is the residual claimant after all debt service, fees, and OC/IC test requirements are met. Valuation therefore requires a full cashflow model over the CLO's life: project quarterly waterfall distributions, account for OC diversion in adverse scenarios, and discount the resulting cashflow stream to a net present value or internal rate of return.

NAV-Based Valuation (Mark-to-Market)

Quarterly Distribution Projection — 5-Year Model

During the reinvestment period (Quarters 1–16), the manager reinvests principal proceeds to maintain portfolio par at £500m. Quarterly distributions to equity are approximately stable at £2.35m. After the reinvestment period (Quarters 17–20), loans begin to mature and prepay; principal is used to sequentially repay tranches starting with Class A, causing interest income to fall and equity distributions to decline before the final NAV is returned.

IRR Scenario Matrix — Equity Tranche

The equity IRR is highly non-linear with respect to credit assumptions. At low default rates, equity captures the full excess spread over 6 years. As defaults rise, OC tests begin to divert cash upward, equity distributions are delayed or eliminated, and ultimately — in severe scenarios — the residual par returned at maturity is insufficient to recover the £60m investment.

The matrix below shows the estimated equity IRR across a 5×4 grid of CDR (rows) versus Recovery Rate (columns). The base case (CDR 2.5%, Recovery 65%) is highlighted. Each cell represents a full waterfall model run over 24 quarters (6 years), applying the relevant default and recovery assumptions to the portfolio and computing the discounted return on the £60m equity investment.

Valuation Summary — All Tranches

The table below consolidates the valuation of all seven tranches on a mark-to-market basis using the base-case assumptions and current secondary market discount margins. The total portfolio market value of £492.5m against £500m par reflects a small portfolio discount (98.5% MV/par), distributed unevenly across the capital stack based on each tranche's sensitivity to credit spread movements.

Consolidated Mark-to-Market Summary