Joint venture and waterfall models
Make the economics clear before the cash starts moving.
A focused collection of editable Excel models for preferred returns, preferred equity, IRR and MOIC hurdles, GP catch-ups, promote splits, cumulative distributions, funds and deal-specific waterfalls.
Explore everything included
Search all models or filter the collection by preferred return structures, waterfalls, funds and deal models with built-in distribution logic.
Loading models...
Loading the included models...
Browse all SmartHelping templates
No exact match found
Try a broader waterfall term, return hurdle or deal type.
Follow every dollar through the waterfall
Choose the structure closest to your agreement, then configure contributions, timing, hurdle definitions and splits around the actual deal terms.
Define capital contributions
Set GP and LP investment amounts, ownership, funding timing and the capital that must be returned.
Calculate the preferred return
Model simple or compounding preferences, accrual balances, current payments and unpaid amounts.
Test each distribution tier
Apply return-of-capital rules, IRR or MOIC hurdles, high-water marks and GP catch-up provisions.
Allocate cash and returns
Calculate promote or carry splits, residual distributions, partner cash flows, IRR and equity multiples.
This bundle is a strong fit if...
You evaluate or structure multiple joint ventures and need several ways to allocate cash between sponsors, operators and investors.
An individual model may be enough if...
You have one fixed distribution structure and do not expect to model alternative waterfalls.
Turn agreement language into working logic
Make each distribution tier explicit.
The templates show when cash moves from one tier to the next and how that change affects both investor and operator economics.
Frequently asked questions
The practical details about selecting, adapting and using the waterfall models.
Can I buy individual models instead?
Yes. Every template in the catalog links to its individual model page. The bundle is best for buyers who expect to compare or reuse several waterfall structures.
Can I add this logic to another financial model?
Yes. Nearly all of these waterfall tools use compact single-tab logic, making them easier to study and import. You will still need to connect the distribution cash flow and timing to your main model carefully.
What is the difference between a hard and soft hurdle?
A hard hurdle generally applies the performance allocation only above the hurdle. A soft hurdle can apply it more broadly once the hurdle is met. Always configure the spreadsheet to match the governing agreement.
Do the templates support multiple hurdles?
Several models support multiple IRR, MOIC or cumulative distribution tiers, while others focus on one preferred return or preferred equity structure. Each model card describes its primary design.
Are the spreadsheets fully editable?
Yes. Formulas and tabs are visible and editable so you can change assumptions, trace the logic and adapt the framework to the actual joint venture.
How is the bundle delivered?
The files are immediately downloadable after purchase. You will also receive an email with a download link, which is helpful when purchasing on a mobile device.
One-time purchase
Get the complete Joint Venture Waterfall Bundle.
Download all models immediately and compare the distribution structures before adapting one to your deal.