Home / Financial Tools / Securitization Tranche Waterfall & Credit Enhancement Modeler
Graduate-Level Modeling · Structured Finance
Securitization Tranche Waterfall & Credit Enhancement Modeler
A senior tranche isn't safe because the loans underneath it are safe. It's safe because everyone below it in the capital structure gets wiped out first.
How To Use This Model
Reading This Tool
Structure a collateral pool into senior, mezzanine and equity tranches, then set a default rate and severity assumption.
Losses hit the capital structure from the bottom up, equity absorbs first, then mezzanine, then senior only once the tranches beneath it are wiped out, exactly how a CLO, CMBS or ABS deal actually allocates credit risk.
Collateral Pool
Capital Structure
Loss Allocation Waterfall
-Total Collateral Losses
-
Equity Tranche (First Loss)
-
Senior Credit Enhancement
-
Mezz Credit Enhancement
-
Tranche Balances: Original vs. After Losses