These downloadable Excel waterfall templates help model joint venture profit distributions with built-in logic for IRR hurdles, preferred equity, preferred returns, simple interest, and cumulative distributions. Nearly all of them contain single-tab logic for easy importing into your other models. With these tools, it is easier to show alignment between operator and investor incentives. The logic can be easily demonstrated and explained.
Waterfall Spreadsheet Templates:
- Preferred Return - Investor Thresholds - 100% capital repaid, accrued pref., remaining split.
- Cash Flow IRR Waterfall - 3 IRR hurdles and summary views per hurdle.
- Cash Flow IRR Waterfall (2) - 3 IRR hurdles and GP catch-up option.
- Preferred Return - Two versions: pref. rate with single profit share; pref. rate with 2 hurdles.
- Preferred Return (2) - Simple Interest / Multiple Hurdles / Non-Compounding.
- Preferred Return (3) - Option for two GP catch-ups after pref. and after investment repaid.
- Preferred Return (4) - Option for rate splits during preferred return phase, detailed callouts.
- Preferred Return (5) - Tier 3 can be an IRR or MOIC hurdle (whatever hits first).
- Preferred Equity - Single hurdle, but assumes 100% of equity also repaid before profit share.
- Preferred Equity (2) - Hurdle 1 = equity repaid, Hurdle 2 = MOIC
- Cumulative Distribution - Adjust cash splits as more total cash has been distributed to LPs.
- Preferred Return Fund Tracker - Uses IRR hurdles for investors / dynamic fund cash planner.
- Multi-Member Fund - Track long-only crypto/stock investments and distributions.
- Hedge Fund - Soft Hurdle - Uses a high watermark and a resetting hurdle rate.
- Real Estate + Business Acquisition Model - Includes preferred return, dynamic loans.
- Single Tenant Industrial - Rent per sq. ft., lease-up costs, waterfalls, opex, disposition.
- LBO Model with T12 Reference - Underwrite new business acquisitions.
- Mixed-Use Real Estate With Built-in Waterfall - Includes monthly IRR hurdle waterfall.
- Multi-family Real Estate Acquisition - Includes annual IRR hurdle waterfall.
- Monthly Waterfall - Basic real estate opco with monthly joint venture IRR hurdles.
- Self Storage: Up to 6 Funds - Each fund is based on IRR hurdles and GP/LP structure.
- Business Turnaround Framework - Model a deal based on business improvement.
Learn more about monthly cash flow scenarios here: IRR hurdles vs Simple Preferred Rate.
Most of these spreadsheets are to be used in the context of real estate acquisition, but the preferred return and preferred equity templates could be used to define cash distribution splits for any kind of joint venture deal.
All of these templates and spreadsheets let the user drop in contributions/distributions manually except for the real estate acquisition model, which has bottom up assumptions for driving revenues/expenses/debt/and the resulting cash flow.
If you are interested in specific pro forma templates that contain joint venture distribution waterfalls built in below operating assumptions (revenues, expenses, cash requirements, cash distributions) then these real estate models are worth a look.
Purchasing on a mobile device? No problem. You will receive an email with a download link for the purchased files that you can access on any spreadsheet friendly device later (desktop / laptop).
Check out all financial model templates in one bundle here. There are also great discounts when buying by category.
