Model walk-through
Building a recovery waterfall in Excel
From an empty sheet to a working waterfall with pari passu classes, three valuation cases and a fulcrum that names itself.
Credit InvestorBuilding a recovery waterfall in ExcelComing soon
18:00We build the Recovery sheet from the capital structure template one formula at a time: the claim for each class, the value left after the classes ahead of it, and the recovery that falls out.
The whole thing rests on two SUMIF formulas and a MIN. Once those are in place, adding a tranche or a valuation case takes one row or one column.