Why Most VCs Misunderstand Their Own Fund Economics
The perfect model for VCs, LPs and founders to understand fees, carry, and alignment.
Why a Fund Waterfall Model Makes VCs Great
Most people think they understand how a venture capital fund works because they’ve read the summary on a one-page term sheet. But one-pagers look very orderly when it comes to fund economics.
A bit of money for management here, a slice of the profits there. But there is a big difference between reading the rules of a game and actually playing it.
In the real world, money has a way of hiding in fees or getting stuck behind obstacles while the years tick by. By the time many realize the numbers aren’t behaving the way they expected, they are already years into a journey with no easy way to fix it.
This applies to everyone involved. Founders receiving term sheets from VCs, VCs receiving term sheets from LPs.
To really get it, you need more than just a list of definitions. You need to see how the dollars actually move from one person to another as time goes on. Not just to make the best out of your capital, but to have real alignment. Without alignment, an investment almost never leads to good outcomes.
And that’s exactly why we’ve put together a simple, clear waterfall model that does exactly that. It takes those dry legal promises and turns them into a visual map, helping you see exactly who gets paid and when. And you get to see that long before you write or receive the first check.
Table of Contents
1. What’s in The Model
2. Download the Fund Waterfall Model in Excel
3. Who Should Use This Model
4. How it Works in Practice
5. Frequently Asked Questions
1. What’s in The Model
While most fund conversations compress everything into a couple of numbers, this VC waterfall model does the opposite. You are not looking at a still photo anymore. Instead, you get to watch the whole story play out.
This model takes the fund apart, treats every rule as a real event, and lets them interact over months and years. This is the only way to truly see what investors get, what the managers earn, and exactly when those payments actually happen. Let’s look at each tab in detail.
A. Inputs: turning fund terms into parameters
A fund agreement reads like a set of promises. But a good model has to turn those promises into rules.
The basics
The first block is the fund itself. The model starts with fund size, fund term, and investment period, expressed in both years and quarters. That can sound like bookkeeping until you remember that a fund does not live in annual slices.
Fees accrue quarterly. Preferred return accrues based on time outstanding. Distributions arrive in bursts. If you model only in years, you hide the timing effects that actually drive outcomes.
Skin in the game (GP Commitment)
The model also includes the General Partner’s (GP) commitment, which is the money the managers put into the fund themselves. It is included both as a percentage (signals intent) and as a dollar amount (determines exposure). A 2% commitment on a small fund and a 2% commitment on a large fund do not feel the same when capital calls bunch up or exits slip.
Running the Business (Fees)
Running a fund costs money. The model requires different fee rates during the investment period and the post-investment period, reflecting how most funds step down. It forces an explicit fee base, such as committed capital, so the math stays consistent. These fees run on a quarterly schedule. This timing is important because it determines how much cash leaves the fund before the profit-sharing rules even start to apply.
The Profit Plan (The Waterfall)
The third block is the waterfall itself, which is the set of rules for who gets paid and when. The model uses a European waterfall at the whole-fund level, not a deal-by-deal approach.
It tracks the “preferred return” and shows the annual rate alongside its quarterly version. Many people underestimate how quickly this hurdle builds up when it takes longer than planned to sell a company. The model makes this growth visible so you can see the reality of the situation.
Then there’s catch-up, which stays clear and direct. After LPs get their capital and preferred return, the “catch-up” rule allows the GP to receive 100% of the next available profits until they have reached their agreed-upon share (e.g., 20% of total profits). This might look as a bonus, but it’s actually a rebalancing mechanism to make sure the GP eventually gets their full slice of the gains after the LPs have been paid their priority returns.
Reusing Capital (Recycling)
Finally, the model includes a way to turn recycling on or off. Recycling is when a fund takes the proceeds from a quick exit and reinvests them into new companies instead of giving them back to LPs immediately. While this can improve the total result, it also keeps money out longer and increases the cost of the preferred return hurdle. The model makes that trade-off easy to see.
B. Fund cash flows: why timing drives everything
Instead of assuming everything happens smoothly, this model asks you to put in the actual timing of the money. You enter exactly when the cash leaves the investors and exactly when it comes back. We don’t use averages or “smoothed” curves here because, in the real world, cash is rarely that neat.
Discipline is vital in this case because the preferred return (the “hurdle” or minimum profit investors expect) is tied to the clock. If a fund returns money early, that hurdle stays small. If the money stays out for ten years, the hurdle grows.
Two funds can end up with the same final profit, but the person receiving the check will have a completely different experience depending on whether that money arrived in year four or year ten.
This is what many simplified fund models lack. They assume timing will sort itself out. They treat a ten-year fund life as if it behaves like a single end-of-fund liquidation event.
But LPs do not experience funds that way. They experience them through capital calls that arrive earlier than expected, distributions that arrive later than hoped, and a hurdle that keeps accruing quietly while everyone debates whether DPI “looks fine.”
C. Management fees and expenses: the real drag
Running a fund has a real cost, and this model makes sure you don’t ignore it. It calculates fees every 3 months, showing exactly how much cash is leaving the fund to keep the lights on.
These costs come out of the pot before anyone, the investors or the managers, gets a share of the profits. Seeing these costs add up over time helps you understand why the “gross” results (the raw profit) and the “net” results (what you actually get to keep) can look so different. It’s the difference between what a company is worth on paper and how much cash actually hits your bank account.
Also worth noting is that audit, legal, administration, and other fund-level costs reduce distributable cash in the same way fees do. They are applied before the waterfall runs.
That sequencing is the point. Fees and expenses reduce the cash available to return capital and clear the hurdle. When they compound over time, small assumptions turn into meaningful differences in LP net outcomes.
This is one reason why two funds with the same gross performance can deliver very different results to LPs, even with identical carry terms.
D. The waterfall: how a fund really distributes cash
This is the core engine, and it is where most misunderstandings live.
The model runs a European whole-fund waterfall. It applies at the fund level instead of deal by deal. That means it looks at all cash that has come in and all cash that has gone out, nets fees and expenses, and then distributes what remains according to a defined sequence.
Here’s how the sequence should work:
First, investors get back every dollar they put in.
Second, they get their preferred return (that extra profit promised for their risk).
Third, the managers “catch up” so their share of the profits matches the agreed percentage.
Finally, any leftover cash is split between everyone at the final agreed-upon ratio.
This is why when carry is earned is much more important than how much carry is promised. A term sheet can state a carry rate. Only cash flow timing determines whether that carry ever shows up, and whether it arrives early enough to matter to the GP’s business.
The model shows you that in this setup, the managers often wait a long time to see their share. This makes the timing of every exit incredibly important for the people running the fund.
E. LP–GP summary: seeing the outcome clearly
At the end of the day, you want to know the final result without any fluff. Has the VC fund actually performed?
This summary gives the answer to both GPs and LPs, because it compares the big-picture results with the actual cash people received.
The actual cash people received is the distribution split. It shows total distributions to LPs and total distributions to the GP, reflecting how carried interest actually resolves. Simple and effective.
The return summary calculates the metrics that truly matter to LPs. The two most important metrics here are:
The Multiple of Invested Capital (MOIC) - basically, for every $1 put in, how many came back?
The Internal Rate of Return (IRR) - which shows how “expensive” the time was.
This is the ultimate check to see if the fund actually did what it promised. It lets you trace every result back to its source, so you can see if a good outcome was driven by great investments, or if the fees and timing ate away at the win.
3. Download the Fund Waterfall Model in Excel
The model is waiting below. But when you subscribe today, you get this plus the complete VC Corner archive, including the full financial models library:
The SaaS financial model. The Excel template that has helped startups raise millions and extend runway.
The VC return analysis model. Links P&L, dilution, and exit multiples so you can price rounds and see fund-level impact in minutes.
The exit scenario model. Run the IPO, acquisition, and secondary math yourself before walking into any room.
The startup cash runway model. The model every founder wishes they had before the bank balance hit zero.
The venture capital method for startup valuation. How investors actually price your company and how to use that in your favor.
The M&A deal structuring toolkit. Pressure-test every transaction before the handshake.
Plus 160+ premium articles covering investor lists, pitch deck breakdowns, founder playbooks, and deal analysis. Every week, 2 new ones drop.
Start your free 7-day trial →
For the next 48 hours: 50% off forever on annual plans. First come, first served.
Keep reading with a 7-day free trial
Subscribe to The VC Corner to keep reading this post and get 7 days of free access to the full post archives.