Model the waterfall from the same live pro forma as the deal. Keeping tiers, hurdles, catch-ups, and clawbacks connected to the power-aware model helps keep assumptions aligned with distributions to LPs.
Where spreadsheet waterfalls can fall out of sync
Four issues can become visible at distribution time:
- Separate calculations: The waterfall and pro forma live in different files, so assumptions can drift.
- Manually entered tiers: For example, 8% pref / 70-30 / 80-20 with a catch-up may be typed in rather than linked by formulas.
- Limited change history: It may be hard to see who changed a hurdle and when.
- Repeated reporting work: Quarterly LP reporting may require copying and pasting.
On a $150M data center deal, a 100 bps tier error can shift millions between GP and LP.
What to look for in waterfall software
- Connected inputs: Cash flow, invested capital, and exit proceeds feed into the tiers.
- Configurable terms: Pref, IRR hurdles, catch-up, promote, and clawback are structured inputs rather than freeform cells.
- Scenario links: Changing the exit cap or timing updates the waterfall live.
- LP reporting: The investor report comes from the model used to calculate the distribution.
Connect the waterfall to underwriting
The waterfall is the last step in underwriting, not a separate sheet. In DIJASOFT, it reads from the portfolio model—phased construction, lease-up, operations, and exit—so each distribution can be traced to its source lease and capex line.
Next step: Start with Data Center Investment Management Software, which includes a comparison table and FAQ.
*Related: Underwriting Platform Checklist · Pro Forma: Excel vs Platform*