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.
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 investors1 · Collateral pool
3 · Behaviour assumptions
2 · Tranches (sequential pay)
Tranche results
Cash to each tranche, by year
₹ croreOutstanding balances
Pool vs notes, ₹ croreAnnual cash-flow schedule
The model runs monthly; the table sums each yearAllocate a cumulative pool loss bottom-up
Net loss = defaults × (1 − recovery). The equity tranche absorbs the first rupee of loss; the senior tranche is hit only after every junior layer is exhausted.
Capital structure
Edit sizes (% of pool). Attachment = protection below a tranche; detachment = attachment + size.
Loss allocation
CPR ↔ SMM converter
Pass-through payment for one month
Prepayment speed changes the life of the pool
Faster prepayment returns principal sooner: weighted average life (WAL) falls (contraction risk, usually when rates fall). Slower prepayment stretches it (extension risk, usually when rates rise). The pool here has no defaults so that only speed changes.
Same expected loss, different tranche risk
A large pool of similar loans with a one-factor (Vasicek) model. Every loan has the same default probability; correlation ρ decides whether defaults arrive scattered or together.
Expected loss by tranche
Distribution of pool loss
Probability that pool loss exceeds xSimplifications: immediate recoveries, no servicer advances, no performance triggers, OC tests or reserve account, a single fixed rate pool. Real transactions add all of these; the documents govern.
Teaching tool with hypothetical pools; not investment advice and not a description of any actual transaction. https://themountainpathacademy.com