Financing schedules · in 1 model

CLO collateral roll-forward: defaults, recoveries and reinvestment

Performing par, defaults, a recovery lag, reinvestment.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: clo collateral roll-forward: defaults, recoveries and reinvestment.Updated 14 November 2026

Part of credit and restructuring models, with the models, labs and guides around it.

What it does

The collateral schedule turns a loan pool into the two streams of cash the notes are paid from. Performing par defaults and prepays at constant annual rates applied each quarter on the opening balance; defaulted par earns nothing and is recovered in cash some quarters later, at a recovery rate, with the difference a realised loss. Interest is the base rate plus the weighted average spread on opening performing par. In the reinvestment period principal proceeds buy new loans at a price, so par can rise when loans are bought below par; afterwards they are passed to the principal waterfall. Everything is charged on opening balances, which is what keeps the quarter free of circular references.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

CLO cash flow and waterfall model
  • Assumptions, rows 11–16: Performing par at close, Weighted average spread over the base rate, Reinvestment price, Liquidation price at the call…
  • Collateral, rows 6–10: Annual constant default rate, Recovery rate on defaulted loans, Annual constant prepayment rate, Quarterly default rate…
  • Collateral, rows 13–14: In the reinvestment period, Call quarter
  • Collateral, rows 17–22: Performing par, opening, Defaults, Prepayments, Par bought with principal proceeds…
  • Collateral, rows 25–28: Defaulted par, opening, Defaulted par resolved, Defaulted par, closing, Recovery proceeds
  • Collateral, rows 31–35: Interest collected, Principal collected: prepayments and recoveries, Spent on new loans, Sale proceeds at the call…
  • Collateral, rows 38–40: Cumulative defaults, Cumulative defaults, % of original par, Cumulative loss on resolved defaults

What a reviewer looks for

  • An annual default rate applied as if it were quarterly.
  • Recoveries received in the quarter of the default.
  • Interest earned on defaulted loans.
  • Reinvesting principal proceeds after the reinvestment period ends.

Learn it, then build it

Vocabulary: Securitisation, Loss Given Default (LGD), Credit Spread.

Other financing schedules