# ABS / CLO Model Model asset-backed securities or collateralized loan obligations with precision waterfall logic, CPR and CDR assumptions, sequential tranche payments, and overcollateralisation triggers that match real deal structures. - Canonical: https://finamodel.com/templates/abs-clo-model - Excel download: https://finamodel.com/templates/abs-clo.xlsx - Category: Capital Markets - Model type: Portfolio - Difficulty: Advanced - Audiences: Bankers & advisors, Credit & risk, Credit analysts, Structured finance teams, Portfolio managers, Investors - Tags: structured finance, securitization, ABS, CLO, waterfall ## Overview An ABS/CLO cash flow model projects the financial performance of asset-backed securities or collateralized loan obligations by simulating a diversified loan pool through prepayment, default, and recovery scenarios. The model answers whether a CLO structure can generate target returns for equity investors (typically 12% cash-on-cash) while protecting each rated tranche through interest and principal waterfalls, overcollateralisation (OC) tests, and interest coverage (IC) mechanics that trigger automatic amortisation when leverage ratios breach trigger levels. The pool performance is driven by weighted average coupon (WAC), conditional prepayment rate (CPR), conditional default rate (CDR), and recovery rates, all of which vary by credit cycle and economic assumptions. The workbook contains a detailed collateral pool roll-forward tracking performing balances, scheduled amortisation, prepayments, defaults, and reinvested principal during the reinvestment period, plus a combined interest and principal waterfall that prioritises senior fee recovery and sequential tranche payments according to the deal's capital structure. Overcollateralisation and interest coverage tests divert excess cash to senior tranche pay-down (turbo amortisation) whenever credit metrics weaken, automatically protecting rated investors. Equity returns are tracked separately from tranche payments, with incentive fee mechanics that align the CLO manager's upside with equity holder returns above a specified hurdle. Structured credit investors, rating agencies, and commercial lenders rely on CLO models to stress test collateral performance, confirm that DSCR and subordination levels will weather recession scenarios, and project equity distribution waterfalls across the reinvestment and amortisation periods. ## What's included - Loan pool detail with coupon, maturity, and amortisation schedule - Prepayment and default assumptions using CPR and CDR curves - Combined interest and principal waterfall with priority rules - OC and IC test mechanics with turbo amortisation triggers - Tranche-level IRR, MOIC, and equity distribution waterfall - Loan pool detail with coupon, maturity, and amortization schedule - Prepayment and delinquency assumptions with CPR and CDR - Waterfall mechanics with priority rules and tranche definitions - Interest and principal distributions across tranches - Expected loss and recovery timing scenarios - Cashflow reconciliation and waterfall audit ## ABS/CLO Cash Flow Waterfall Model: Key Mechanics and Outputs This ABS/CLO model specification explains how one annual cash flow engine builds collateral performance, waterfall allocations and tranche-level returns for a deal. It sets out the drivers of interest and principal, the seniority rules that redirect cash when coverage ratios breach, and the equity and incentive mechanics, so readers can judge how closely the structure mirrors real managed deals. ### The Operating Drivers Behind Collateral Cash Flow This ABS/CLO model is built around a collateral pool of leveraged loans that generates cash in three ways: interest on the performing balance at a weighted average coupon, principal from scheduled amortisation and prepayments, and recoveries on defaulted loans that arrive with a lag. - The pool roll-forward applies annual prepayment and default rates to an opening balance, adds reinvestment while the deal is still in its reinvestment period, and produces a closing performing balance that drives the next period. Defaulted loans stop accruing interest, so weak credit immediately suppresses income rather than only affecting principal. - Reinvestment, default, prepayment, recovery and coupon assumptions are all named inputs, which makes stress testing specific credit and prepayment views straightforward. ### How the Cash Flow Waterfall Allocates Proceeds Once period cash is available, the waterfall applies fees first, then steps through tranches in rating order, running overcollateralisation and interest coverage tests at successive levels. Each test compares available collateral or interest against the tranches it protects, and a breach diverts everything remaining in the waterfall into turbo amortisation of the most senior outstanding tranche. - That cure continues until the breached test passes again, which means junior noteholders lose interest and equity receives nothing during a cure. Principal follows a separate rule: reinvested while the deal is inside its reinvestment period, then paid sequentially from the top of the capital structure down. - Because the whole pass is computed in one sequential sheet, waterfall payments and tranche balances stay internally consistent. ### What the Model Tracks Across Tranches and Equity Every rated tranche is tracked with an opening balance, interest paid, principal paid, closing balance and weighted average life, allowing a reviewer to see how each layer of the capital structure behaves as collateral seasons. - Equity is treated differently: its notional remains constant, distributions accumulate separately, and cash-on-cash and internal rate of return are derived from the distribution stream. - The manager's incentive fee is calculated on equity distributions above a cumulative hurdle that grows with the equity notional each year, so the fee only appears once a defined excess is generated rather than reducing equity from the first period. - Together these outputs describe protective and return dynamics rather than individual deal results. ### Practical Use and Documented Model Integrity Checks The model is organised with an assumptions area, a collateral cash flow sheet, a combined waterfall sheet, a returns summary and a checks sheet covering ten integrity tests. - A single waterfall pass avoids the circularity between payments and balances, and the checks confirm that cash is conserved, balances tie out, tranche balances never turn negative and no tranche is overpaid. - The assumption layout is positioned to support sensitivity work on default rate, prepayment rate, recovery, coupon compression and reinvestment period length, though these are not shipped as scenario toggles. - A practical reading is to focus on how defaults, coverage breaches and reinvestment decisions interact, since those relationships drive tranche outcomes more than any single input. ## Built for structured credit underwriting Use this model when prepayment speeds, default timing, and tranche subordination drive deal economics. ## Handles real waterfall mechanics A useful ABS/CLO model enforces sequential payments, OC/IC trigger diversions, and reserve account funding rather than approximating with simple cash splits. ## Stress-ready for credit cycles Swap in different prepay speeds, default curves, or recovery assumptions to test tranche resilience under recession scenarios. ## Built for structured credit underwriting Use this model when prepayment speeds, default timing, and tranche subordination drive deal economics. ## Handles real waterfall mechanics A useful ABS/CLO model enforces sequential payments, OC/IC trigger diversions, and reserve account funding rather than approximating with simple cash splits. ## Stress-ready for credit cycles Swap in different prepay speeds, default curves, or recovery assumptions to test tranche resilience under recession scenarios. ## Features - **Realistic prepayment and loss modeling:** CPR and CDR assumptions flow through a timing-aware waterfall so you see how prepay refinancing or loss curves affect tranche cash flows. - **Flexible tranche hierarchy:** Model senior, mezzanine, and equity tranches with real deal subordination and reserve account rules. - **Scenario and sensitivity ready:** Swap in different prepay speeds, default curves, or recovery rates to test deal performance under stress. ## Use cases - **Deal underwriting and due diligence:** Evaluate loan pool risk, tranche yields, and loss distribution for a new ABS or CLO issuance. - **Portfolio performance monitoring:** Track actual versus projected cashflows and update assumptions as delinquencies or prepays evolve. - **Investor yield analysis:** Calculate expected returns by tranche under base and stress scenarios. ## Frequently asked questions ### What is an ABS/CLO cash flow model? It is a model that projects pool cash flows through a deal waterfall, allocating interest and principal to each tranche under prepay, default, and recovery assumptions. ### What are CPR and CDR? CPR (Conditional Prepayment Rate) and CDR (Conditional Default Rate) are the annualised percentages of the remaining loan balance that prepay or default each period. ### How does the waterfall prioritise payments? Senior interest is paid first, then senior principal, then mezzanine interest and principal, then reserves, then equity - with any shortfall cascading down priority. ### What are OC and IC tests? Overcollateralisation and interest coverage tests divert excess cash to senior tranche pay-down when leverage or coverage ratios breach trigger levels, protecting rated investors. ### Can I model multiple tranches? Yes. The model supports senior, mezzanine, and equity tranches with real deal subordination, coupon spreads, and reserve account rules. ## Related templates - [Loan Portfolio CDR Model](https://finamodel.com/templates/loan-portfolio-cdr-model) - [Mortgage Portfolio Model](https://finamodel.com/templates/mortgage-portfolio-model) - [Credit Portfolio CDO Model](https://finamodel.com/templates/credit-portfolio-cdo-model)