SmartHelping / Joint Venture Waterfalls / Excel
Cumulative Distribution Waterfall
Split joint venture cash flow between the limited partner and general partner based on the total cash distributed to the LP. Set up to six tiers, adjust the split as each threshold is reached, and review the results across up to 60 periods.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through the cumulative distribution waterfall.
See how the LP distribution thresholds and cash flow splits connect to the period-by-period results.
How the distribution tiers work
The next split begins when the LP reaches a defined cash amount.
The waterfall tracks cumulative cash distributions to the LP. Those dollar thresholds determine when the configured LP / GP split changes.
Set the LP thresholds
Define the cumulative amounts the LP must receive before the next distribution tier applies.
Assign the split for each tier
Configure the LP and GP percentages for each threshold range, including a higher GP share at later tiers when the deal calls for it.
Handle a threshold mid-period
If a period crosses a hurdle, the model allocates the cash needed to finish the current tier using that tier’s split and applies the next split to the remaining cash.
Review the blended result
A period that spans multiple tiers can have an effective LP / GP percentage that differs from any single tier. The model displays that effective share.
Configure the deal
Set the cash flows, thresholds, and partner shares.
Up to six distribution tiers
Enter the cumulative LP distribution hurdles and the cash flow split that applies within each tier.
Up to 60 periods
Use a consistent period schedule, such as monthly or annual, for the contributions and distributions in the analysis.
Contributions and available distributions
Enter the joint venture cash flows for each period and configure the LP / GP contribution structure.
Flexible LP and GP funding
Model a larger initial LP contribution or a structure where the GP contributes no capital, with distribution shares configured to match the deal.
Fewer than six active tiers
If the deal uses fewer tiers, repeat the final “thereafter” distribution rate in the subsequent tiers as described in the walkthrough.
Adjustable hurdles and splits
Change the cumulative distribution amounts and LP / GP percentages to evaluate different deal structures. The allocation logic updates from those assumptions.
Ways to configure the waterfall
Tie changes in participation to the cash the LP has received.
The initial hurdle amount and the split for each tier determine how the structure behaves.
Initial capital recovery threshold
Set the first threshold to an amount equal to the LP’s initial investment, then choose the LP / GP split that applies until that distribution amount is reached.
Pari passu starting split
Begin with a split that reflects the partners’ participation and change it once the LP reaches the configured cumulative distribution threshold.
Increasing GP participation
Give the GP a larger share of later distributions after the LP has received the specified amounts.
Clearly stated dollar thresholds
Use cumulative LP distributions as the hurdle measure. IRR and equity multiple hurdles are available in the separate related templates below.
Allocation detail and partner returns
Check the effective shares and the underlying tier calculations.
LP and GP cash flow allocations
Review how the available cash flow is divided between the partners throughout the analysis.
Effective percentage by period
See the resulting LP / GP share in each period, including periods where cash flows cross a distribution threshold.
Detail by hurdle
Review the shares and aggregate allocations for each hurdle to check the results against the configuration table.
IRR over the defined periods
Review the partner return calculations using the period frequency of the cash flows. IRR is a reporting output; cumulative LP distributions drive the waterfall.
Interpret the return consistently
Match the IRR to the cash flow period.
An IRR requires both a negative and a positive cash flow. A GP with no capital contribution may have no meaningful conventional IRR; review the allocated cash flows in that case.
Monthly or annual cash flows
Keep the time interval consistent across all periods. A periodic IRR is interpreted using that interval.
Effective annual equivalent
For a monthly IRR, calculate the compounded annual equivalent using: (1 + monthly IRR)12 − 1
How to use the model
Move from distribution terms to a clear allocation schedule.
-
Choose the period schedule
Set up the analysis across up to 60 consistent periods and enter the contribution and distribution cash flows.
-
Configure the distribution tiers
Enter the cumulative LP hurdle amounts and LP / GP splits for each tier.
-
Review threshold-crossing periods
Check periods where distributions move through more than one tier and review the effective percentage shares.
-
Check the complete results
Review partner cash flows, hurdle-level allocations, and return outputs against the agreed distribution structure.
Also available in these bundles
Explore more joint venture structures.
This template is included in the Joint Venture bundle and the complete Super Smart collection.
Joint Venture Waterfall Bundle
Explore templates for cumulative distributions, preferred returns, IRR hurdles, equity multiple hurdles, and GP catch-up structures.
View the Joint Venture bundleSuper Smart Bundle
Explore the complete public SmartHelping financial model collection across business models and industries.
View the Super Smart BundleQuestions before you start
A few useful details.
What triggers the next distribution tier?
The total cash distributed to the LP must reach the cumulative dollar threshold defined for that tier.
How many tiers and periods are supported?
The model supports up to six distribution tiers and up to 60 periods. Use a consistent monthly or annual period schedule.
What happens if one period crosses a hurdle?
The model divides the period’s cash between the applicable tiers, using the relevant split for each portion. It also shows the resulting effective share for the period.
Can I use fewer than six tiers?
Yes. Repeat the final “thereafter” split in the subsequent tiers, following the setup demonstrated in the walkthrough.
Can the GP contribute no capital?
Yes. The distribution splits can reflect a structure with no GP capital contribution. A conventional GP IRR may not be meaningful without an initial negative cash flow.
Can the first hurdle represent the LP getting its investment back?
Yes. Set the initial cumulative distribution threshold equal to the LP investment amount and configure the cash flow split that applies before that threshold is reached.
How is the model delivered?
The model costs $75 as a one-time purchase and is available for immediate Excel download after purchase.
Model the agreed distribution terms
Make each LP threshold and GP split visible.
Cumulative Distribution Joint Venture Model — $75, one-time purchase.
