NEWStock Market Analysis — Sector Performance Analyzer · Metals & Automobiles deep dives · Global Markets Open →
◆Financial Derivatives — In Progress Please await announcements of new courses and upcoming batches. Course Updates →
The Mountain Path Academy

Securitisation Waterfall Simulator

Build a loan pool, set prepayment and default speeds, tranche it, and watch the cash flow down and the losses flow up.

By Prof. V. Ravichandran · Interactive teaching tool · Monthly pool model with sequential tranches, loss write-downs, WAL and yields · Companion to Securitisation, MBS, ABS and CDOs

THE MOUNTAIN PATH ACADEMYFinance · Risk Management · Quantitative Analytics

Securitisation Waterfall Simulator

Mortgage or loan pool → SPV → senior, mezzanine and equity tranches · amounts in ₹ crore

Who does what · click a step

Investors fund the SPV; borrowers’ repayments fund the investors

1 · Collateral pool

3 · Behaviour assumptions

2 · Tranches (sequential pay)

Class A · senior
Class B · mezzanine
Class C · equity / first loss

Pool cumulative net loss–

Class A senior · loss / yield–

Class B mezzanine · loss / yield–

Class C equity · IRR–

Tranche results

Cash to each tranche, by year

₹ crore
Class AClass BClass C

Outstanding balances

Pool vs notes, ₹ crore
Pool collateralClass AClass BClass C

Annual cash-flow schedule

The model runs monthly; the table sums each year
Prof. V. Ravichandran · The Mountain Path Academy
How to use this tool: start with the base deal, then raise the default rate and watch losses climb from Class C to Class B to Class A. Switch to a refinancing boom to see contraction risk shorten every tranche. The concepts, worked examples and Excel companion are in Securitisation, MBS, ABS and CDOs →

Teaching tool with hypothetical pools; not investment advice and not a description of any actual transaction. https://themountainpathacademy.com