Joint Venture Waterfall Templates

These meticulously designed templates incorporate sophisticated logic to illustrate profit distribution dynamics within a joint venture. The spreadsheets are tailored with diverse terms encompassing internal rate of return (IRR) thresholds, preferred equity, preferred return, simple interest, or cumulative distributions, providing you with a range of analytical perspectives. The prevalent theme sees cash splits favoring the General Partner (GP) as the Limited Partner (LP) surpasses progressively challenging hurdles. This design ingeniously incentivizes the GP to strive for superior returns on behalf of the LP.

A select number of templates within this collection are dedicated to real estate models, incorporating the most commonly utilized waterfall structures. These integrated models offer a more in-depth exploration of potential profit distribution scenarios in the real estate sector, further broadening the range of applications for these comprehensive tools.

$199.00 USD

(Bundle Downloadable After Purchase)

 

Waterfall Spreadsheet Templates:

• 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 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.

Learn more about the differences between a preferred return deal structure and IRR Hurdles.

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.