LP and GP cash flows split across four IRR hurdles.
Model investor and sponsor distributions through a four-tier IRR promote with monthly compounding, sponsor fees and annual or monthly schedules.
Equity waterfall
4 tiers
Investor
14.0% IRR
1.8x multiple · $9.5M in
Sponsor
22.0% IRR
2.5x multiple · $1.1M in
Custom LP/GP splits and four promote tiers.
Set how equity is funded between investors and sponsors, then configure the IRR hurdle range and profit split for each tier.
- Custom LP and GP equity contribution split
- Four promote tiers with editable IRR hurdles
- Return of capital and preferred return per tier
- Investor, Sponsor and Project return summary cards
Promote structure
Investor / sponsor
Compounded monthly, viewed annually or monthly.
Preferred returns compound monthly from close to exit, and partner IRRs are calculated via XIRR on actual calendar dates.
- Monthly capital account tracking
- Partner IRRs calculated via XIRR on monthly dates
- One-click toggle between annual and monthly tables
- Consolidated project, fee and partner cash flow view
Distributions by year
7-year hold
Acquisition, asset management and exit fees.
Include upfront acquisition fees, annual asset management fees and disposition fees so LP and GP returns reflect the full partnership structure.
- Acquisition fee as a percentage of purchase price
- Upfront closing fees to sponsor
- Annual asset management fee on equity
- Disposition fee as a percentage of net sale price
Partnership fees
Paid to sponsor
Included with every deal
Partner return cards
See equity, distributions, profit, multiple and IRR for LP and GP.
Instant adjustments
Change a hurdle rate or split and see returns update immediately.
Project cash flow tab
View unlevered cash flow, debt, fees and partner splits together.
Excel export
Export both the waterfall and project cash flow tables with live formulas.