Investor-First JV Waterfall with IRR or MOIC Floor

All Industries, Financial Model, General Excel Financial Models

10-year Financial Projections, 5-year Financial Projections, Accounting, Calculator, Cash Flow Analysis, Cash Flow Projections, Cash-on-Cash Multiple, CFO, DCF Model, Discount Rate, Excel, Financial Analysis, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial modelling, Financial Planning, Financial Projections, Free Cash Flows, Interest Accrual, Investing Cash Flows, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), Joint Venture, Know-How, NPV (Net Present Value), Private Equity, Private Equity Waterfall Distribution Models, Return on Invested Capital (ROIC), Scenario Analysis, Sensitivity Analysis, Venture Capital

Video Overview:

What it is

A plug-and-play joint venture waterfall template built from real-world operating agreement patterns, designed to drop into any model that already has annual cash flows. The entire waterfall runs on one tab, with all formulas visible, editable, unhidden, and unlocked, so it’s easy to audit, customize, and defend.

Why it belongs in a template library

Most waterfall templates cover the basics (pref, return of capital, promote). This one adds a highly practical, negotiation-friendly concept that shows up in deals—but rarely shows up cleanly in template models:

A “whichever comes first” Tier 3 that splits cash flow at a set LP/GP percentage until the LP hits either an IRR target or a MOIC target, whichever is achieved first—then a final split adjustment (often more favorable to the GP).

That one feature makes this template especially useful for modern JV structuring where investors want clarity around the minimum return they achieve before the promote meaningfully steps up.

Waterfall structure supported (Hurdles / Tiers)

1. Preferred Return
2. Equity Repayment (Return of Capital)
3. IRR or MOIC Target (whichever comes first) — key differentiator
4. Thereafter / Final Promote Split

How hurdles are determined:
Each hurdle is assessed based on the amount due to the LP / investor (not just total deal-level cash), which makes it easier to match how many operating agreements define hurdle satisfaction.

How distributions are split:
At each tier, the template can be configured with a different LP/GP split percentage, allowing you to reflect true tiered economics rather than forcing a simplistic “pref then promote” setup.

Core template features (what users actually get)

• Up to 10 years + initial investment year (supports an initial contribution period plus operating years)
• All logic on a single tab
• No hidden / locked formulas (built to be transparent and audit-friendly)
• Easy integration into existing workbooks
  • Copy/paste the tab
  • Reference the initial investment and annual distributable/distributed cash flows
• Configurable initial contribution rates for LP and GP
• Five sensitivity tables (data tables) to sensitize IRR and MOIC inputs
  (built specifically to stress-test the Tier 3 “whichever comes first” behavior)

Who benefits and how

LP / Investors (Limited Partners)

What they get out of it:

• Clear “minimum return protection” before a major promote shift
  Tier 3 can function like a guardrail: the investor can see (and negotiate) the minimum IRR/MOIC they want to hit before the GP’s share meaningfully increases.
• Better alignment and fewer surprises
  The model explicitly shows when the investor’s hurdle is considered achieved and how splits change after.
• Negotiation clarity
  Instead of debating waterfall mechanics abstractly, the LP can point to exact thresholds and splits with a clean, transparent schedule.
• Faster underwriting & IC-ready outputs
  Because it plugs into annual cash flows, investors can quickly compare sponsor proposals across deals using consistent logic.

GP / Operators / Sponsors

What they get out of it:

• A professional, repeatable JV structuring tool
  You can model common operating agreement economics without rebuilding a waterfall every time.
• A cleaner fundraising story
  Tier 3 helps explain: “We split X/Y until you hit IRR or MOIC, then the promote steps up.” That’s easy to communicate and defend.
• More confident promote modeling
  The “whichever comes first” tier removes ambiguity around when the promote changes—critical for setting expectations internally and with capital partners.
• Faster scenario iteration
  With sensitivity tables built-in, sponsors can quickly test how changes to IRR/MOIC targets affect realized splits and timing.

Analysts / Modelers (Acquisitions, Development, FP&A)

What they get out of it:

• Drop-in workflow
  If your base model already produces annual distributable cash flow, you can integrate the waterfall with minimal wiring.
• Auditability = fewer errors
  Single-tab, unlocked formulas makes it easier to trace issues and reduces “black box” risk.
• Template consistency across deals
  Standardizing the waterfall logic means faster turnarounds, easier peer review, and fewer one-off versions floating around.

Asset Management / Portfolio Management

What they get out of it:

• Hurdle tracking you can update with actuals
  As distributions occur, you can update cash flows and see where you are relative to pref, capital return, and the IRR/MOIC trigger.
• Better distribution forecasting
  Understanding when Tier 3 flips (and when the final promote split starts) improves distribution planning and investor communications.
• Comparable reporting across JV structures
  Because the template is consistent and transparent, it’s easier to compare deal economics portfolio-wide.

The “Tier 3 as a variable target” advantage

A particularly strong use of this template is to make Tier 3’s IRR/MOIC target a negotiable variable, which lets the investor set a clear “before we give up a major share” threshold.

This is valuable when:

• the investor wants downside/return clarity,
• timing of cash flows is uncertain,
• or the sponsor wants a structure that rewards performance but doesn’t trigger a promote shift too early.

Best-fit use cases

• Real estate JVs with annual distribution schedules
• Private equity / infrastructure style cash flow models that aggregate annually
• Deals where the LP’s return is defined by either IRR or equity multiple
• Negotiations where parties want a clean, transparent promote step-up mechanism

Integration summary (how it fits into existing models)

You typically only need:

• Initial investment year contributions
• Annual distributable/distributed cash flows
• LP/GP contribution rates
• Tier splits and hurdle parameters (pref %, IRR target, MOIC target, etc.)

Then the template handles:

• tier-by-tier allocation logic,
• hurdle satisfaction checks tied to LP “amount due,”
• and the step-up to the final promote split after the IRR/MOIC trigger.