Equity Waterfall - with CoC and Multiple
Unlock a streamlined way to model equity waterfalls that balance simplicity with real-world accuracy. This Excel-based module helps sponsors and investors quickly project equity splits based on cash-on-cash return hurdles and equity multiple thresholds—without diving into IRR complexity.
- Simple, visual tiers: Begin with a cash-on-cash return hurdle—ensuring limited partners receive a baseline return before the promote kicks in.
- Custom promotes: Easily define equity multiple thresholds (e.g., 1.5×, 2×), beyond which carry structures shift to favor sponsor upside.
- Plug-and-play design: Drop the waterfall sheet into your existing property-level cash flow model and link just a few key cells (e.g., net levered cash flow, sale proceeds).
- Dual-period support: Includes both annual and monthly versions to match your modeling cadence.
- Transparent logic: No hidden assumptions—built so both sponsor and LP can walk through every tier confidently.
- Pay-what-you-can pricing: Get it at any price you choose (enter $0 if you'd like)—your support helps sustain updates and future tools.
Ideal for value-add and multifamily investors who want clear, defensible waterfall modeling—without overengineering or hidden math.