Carried Interest Waterfall Model: Visualize PE & VC Fund Distributions

Stop wrestling with complex GP/LP economics in Excel. Transparently model the return of capital, preferred returns, catch-up clauses, and carried interest splits to show your investors exactly how the pie is divided.

Try the Live Interactive Demo

Before you dive into the features, test the power of the Carried Interest Waterfall yourself. Access our live, fully functional demo, input your fund structure, and see exactly how fast you can visualize GP/LP distributions.

Try Live Demo Now

Fund Economics Are a Black Box to Most LPs—Bring Them Into the Light

Explaining private equity or venture capital fund economics to Limited Partners (LPs) is notoriously difficult. The moment you start talking about “Return of Contributed Capital,” “8% Preferred Return,” “GP Catch-Up,” and “20% Carried Interest,” eyes glaze over.

If you try to model this in Excel, you end up with a wall of numbers and nested IF statements. It is nearly impossible for an LP to look at a spreadsheet and intuitively understand at what exact dollar amount the GP starts participating, or how a change in the preferred rate impacts the LP’s yield.

It’s time to replace confusing spreadsheets with a dynamic, visual waterfall chart that makes fund economics instantly understandable.

What Makes This the Ultimate Fund Economics Tool?

Built for fund managers, IR professionals, and LPs who demand absolute clarity on payout structures.

• Standard European & American Waterfalls: Easily toggle between or model both structures. Input your specific Preferred Return rate (e.g., 8%) and Carried Interest percentage (e.g., 20%).
• Dynamic GP Catch-Up Modeling: Visually see the “catch-up” tranche in action. Watch the chart show exactly how much the GP must receive to “catch up” to their 20% share of total profits after the LP preferred return is met.
• Visual Waterfall Charting: Instead of a table of numbers, the tool generates a stunning, stacked waterfall chart. LPs can instantly see the flow of capital from Return of Capital, to Preferred Return, to GP Catch-up, to Final Split.
• LP IRR Sensitivity Analysis: Adjust the total exit value of the fund and instantly see how the LP’s Internal Rate of Return (IRR) and the GP’s total payout change dynamically.
• One-Click LP Memo Export: Need to send this to your fund administrators or LP advisory committee? Export a perfectly formatted PDF of the waterfall chart and distribution logic in one click.

How It Works

1. Set the Fund Structure: Input the total invested capital, GP commit, preferred rate, and carry percentage.
2. Define the Exit: Enter the total gross exit value or MOIC of the investment.
3. Visualize the Split: Generate the waterfall chart to instantly see the exact dollar amounts going to LP Return of Capital, LP Preferred, GP Catch-up, and residual splits.

Who Is This Tool For?

• GP Partners & Fund Managers: Model your own fund economics before finalizing your Limited Partnership Agreement (LPA) to ensure the waterfall structure aligns with your incentives.
• Investor Relations (IR) Teams: Create clear, visual presentations for LPs to explain fund performance and distribution waterfalls during annual meetings.
• Limited Partners (LPs) & Family Offices: Reverse-engineer a GP’s proposed terms to see exactly how much alpha you are giving away via the catch-up clause.
• Fund Administrators & Auditors: Quickly verify distribution calculations and waterfall logic for closed-end funds.

Enterprise-Grade Features, Zero Friction

• 🌙 Dark Mode Included: Professional look for high-stakes financial presentations.
• 💾 100% Local & Private (IndexedDB): Your confidential fund terms, carry percentages, and LP economics never leave your browser. No cloud servers, no data leaks.
• 💵 Smart Formatting: Large fund sizes and distribution amounts automatically format with abbreviations (e.g., $50M) for clean reading.
• ⚡ Instant Calculations: Change the preferred return from 8% to 10% and watch the entire catch-up tranche and GP carry update in milliseconds.

Frequently Asked Questions

What is a “GP Catch-Up” clause?

In a typical fund structure (like an 80/20 split with an 8% pref), 100% of profits go to the LP until they hit an 8% return. Then, 100% of the *next* tranche of profits goes to the GP until the GP’s total share equals 20% of all profits. This tool visually maps exactly how large that “catch-up” tranche needs to be.

Does this handle a deal-by-deal waterfall vs. a whole-fund waterfall?

This specific model is optimized for a whole-fund (aggregated) waterfall, which is the standard way LPs evaluate overall fund performance and GP incentives at the end of a fund’s life.

Can I model a management fee offset?

While the core visualization focuses on the investment capital waterfall, you can adjust the “Total Invested Capital” input lower to net out the effect of management fees that have been offset, allowing you to view the pure investment return waterfall.

Is my fund’s data secure?

Absolutely. This is a standalone HTML application. It does not send, store, or transmit your confidential LPA terms or distribution data to any external server. Your data stays entirely on your local machine.