Private equity fund model: cash flows, J-curve and waterfall
Capital calls, fees, NAV, the J-curve, carry and clawback. Build a buyout fund over its life: commitments called for ten investments, a management fee that steps down from committed capital to invested cost, and fund expenses; NAV marked on a stated path; a whole-fund waterfall with a compounding preferred return, a GP catch-up and an 80/20 split; then the LPs’ net cash flows, the J-curve in TVPI, DPI, RVPI and IRR by year, the bridge from gross to net, and the clawback a deal-by-deal waterfall would leave.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: private equity fund model: cash flows, j-curve and waterfall.Updated 11 November 2026
Who builds it, and for whatThe model a fund’s finance team keeps to plan capital calls and distributions and to work out what the carry is worth, and the one an investor in funds builds to test a manager’s track record: a pension plan, an endowment, a fund of funds or a secondaries buyer pricing a stake. It answers what the limited partners keep of the gross return once fees, expenses and carried interest are taken, when their cash comes back, and how much of the carry already paid could have to be returned. Placement agents and fund formation lawyers read the same waterfall when the terms are negotiated.
Every sheet below, in your browser, with its outputs and checks
Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | |||||||||||||||
| 2 | $m unless stated. Every cash flow falls at a year end. All figures are illustrative. | |||||||||||||||
| 4 | Year | Unit | FY1 | FY2 | FY3 | FY4 | FY5 | FY6 | FY7 | FY8 | FY9 | FY10 | FY11 | FY12 | Notes | |
| 5 | Year of the fund | # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | FY1 is the year of the first close. Drives entries, exits and the fee basis. | |
| 7 | Scenario | |||||||||||||||
| 8 | Scenario | # | 1 | 1 = base, 2 = weak vintage, 3 = slow-exit market. Selects a case on the Scenarios sheet. | ||||||||||||
| 10 | Commitments | |||||||||||||||
| 11 | LP commitments | $m | 980.0 | Capital the limited partners have agreed to pay in when called. | ||||||||||||
| 12 | GP commitment | $m | 20.0 | The general partner’s own money, invested and charged on the LPs’ terms here. | ||||||||||||
| 13 | Investment period | years | 5 | New investments are made in FY1 to FY5; the fee basis steps down after it. | ||||||||||||
| 15 | Management fee and fund expenses | |||||||||||||||
| 16 | Management fee, investment period | % | 2.0% | A year, on committed capital, whether or not it has been called. | ||||||||||||
| 17 | Management fee, after the investment period | % | 1.5% | A year, on the cost of investments still held at the start of the year. | ||||||||||||
| 18 | Organisational costs, FY1 | $m | 4.0 | Legal and fundraising costs borne by the fund at its first close. | ||||||||||||
| 19 | Fund expenses a year | $m | 2.0 | Audit, administration, legal and broken-deal costs, while the fund invests or holds an investment. | ||||||||||||
| 21 | Distribution waterfall | |||||||||||||||
| 22 | Preferred return, compounding | % | 8.0% | A year, on contributed capital not yet returned and on preferred return not yet paid. | ||||||||||||
| 23 | GP catch-up | % | 100.0% | The GP’s share of distributions after the preferred return, until it holds its carry share of all profit. At or below the carry rate there is no catch-up. | ||||||||||||
| 24 | Carried interest rate | % | 20.0% | The GP’s share of the fund’s profit once the investors have their capital and preferred return. | ||||||||||||
| 26 | Net asset value | |||||||||||||||
| 27 | Share of the straight-line gain carried in NAV | % | 50.0% | An investment is held at cost in its first year, then marked towards its exit value in equal steps, at this share: valuations lag exits. | ||||||||||||
Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.
Download
Private equity fund model: cash flows, J-curve and waterfall: the workbook
An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
- L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
- L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
- The worked model
- 12 sheets and 2,833 live formulas, all 5 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
- The starter
- The same inputs and layout with the fund distribution waterfall: European and American carry left blank for you to build, each blank cell marked. The worked model is its answer.
What the base case says
- Net IRR to LPs
- 12.6%
- Net TVPI (x)
- 1.63
- Gross IRR
- 18.9%
- Gross multiple of invested capital (x)
- 2.13
- Carried interest, life of the fund
- $149.4m
- Management fees, life of the fund
- $130.0m
- Lowest net TVPI (x)
- 0.83
- Years with net TVPI below 1.0x
- 2
- DPI, FY7 (x)
- 0.82
- Deepest LP net cash flow to date
- $-717.4m
- Clawback at the end of the fund, whole fund
- $0.0m
- Clawback at the end of the fund, deal by deal
- $48.0m
- Clawback exposure, peak, deal by deal
- $48.0m
Read from the workbook as served, every input at its default. Periods: FY1, FY2, FY3, FY4, FY5, FY6, FY7, FY8, FY9, FY10, FY11, FY12. The figures are invented and move with whatever you type in.
What this model is
A twelve-year model (FY1 to FY12) of an invented buyout fund with $1,000 million of commitments: the fund and its investors, not a deal and not the management company.
Ten investments are each an entry year, a cost, a holding period and a gross multiple. The fund calls capital for them, for a management fee charged on commitments in the five-year investment period and on the cost of unrealised investments after it, and for its own expenses; it distributes each realisation in the year it is received.
Distributions run through a whole-fund (European) waterfall: contributed capital first, then an 8% compounding preferred return, a full GP catch-up and an 80/20 split. Carry accrued at NAV is deducted from the investors’ net asset value, and the clawback is tested every year.
The Performance sheet shows paid-in capital, DPI, RVPI, TVPI and the IRR to date in each year, gross and net, so the J-curve can be read off a row, and bridges the gross multiple and gross IRR to the LPs’ net figures. A memo runs the same fund deal by deal to show how much earlier the carry is paid and the clawback that leaves.
Three scenarios (base, a weak vintage and a slow-exit market) and two board-style sensitivity tables: net IRR by holding period and gross multiple, and carried interest by preferred return and carry rate.
Seats: Private equity, Venture capital, Investment banking.
Careers that do this work: investment banking, private equity, growth equity, corp dev / m&a, venture capital.
How the schedules connect
Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.
Fund cash flows: commitments, capital calls and NAV
Commitments, calls, paid-in capital, proceeds, NAV
Assumptions, rows 11–13 · Assumptions, row 27 · Portfolio, rows 6–10 · Portfolio, rows 13–24 · Investments, rows 6–16 · Investments, rows 19–29 · Investments, rows 32–42 · Investments, rows 45–58 · Fund Cash Flows, rows 6–7 · Fund Cash Flows, rows 20–28 · Fund Cash Flows, rows 31–33
Fund management fee: committed capital, then invested cost
The fee basis and rate before and after the step-down
Assumptions, rows 16–19 · Fund Cash Flows, rows 10–14 · Fund Cash Flows, row 17
Fund distribution waterfall: European and American carry
Capital, preferred return, catch-up, split, clawback
Assumptions, rows 22–24 · Waterfall, rows 10–12 · Waterfall, rows 15–19 · Waterfall, rows 22–27 · Waterfall, rows 30–32 · Waterfall, rows 35–39
Fund performance: TVPI, DPI, RVPI, IRR and the J-curve
Net and gross multiples and IRR by year, gross to net
Performance, rows 6–9 · Performance, rows 12–19 · Performance, rows 22–26 · Performance, rows 29–41 · Performance, rows 44–48 · Performance, rows 51–58
Sensitivity tables
Two assumptions at once, without a data table
Sensitivity, rows 5–8 · Sensitivity, rows 11–16 · Sensitivity, rows 20–25 · Sensitivity, row 28
What you should be able to explain
- Why a fund’s early returns are negative: fees are charged on commitments from the first day, while investments are held near cost until they are sold. That is the J-curve.
- What separates TVPI, DPI and RVPI, and why an investor trusts cash returned more than a net asset value the manager marks.
- How the four tiers of a whole-fund waterfall work, and why the catch-up, not the split, is where the GP earns most of its carry.
- Why the preferred return changes when carry is paid but not how much, once the fund has cleared it, and how a slow exit market can leave the GP short.
- Where the gap between gross and net returns comes from: capital called for fees that buys no investment, fund expenses, and carry.
- Why a deal-by-deal waterfall pays the GP earlier, how far ahead of its true entitlement it runs, and what a clawback has to recover.
What a reviewer looks for
- The management fee charged on invested capital from the start, or on commitments to the end: the basis steps down after the investment period.
- A preferred return that does not compound, or that accrues on commitments rather than on capital contributed and not yet returned.
- No catch-up, so the GP ends with 20% of the profit above the hurdle and not 20% of all profit.
- Net returns measured on capital invested and not on capital paid in, which hides the fees.
- An IRR to date that leaves out NAV, or a TVPI that counts NAV before the carry accrued on it.
- Carry tested deal by deal with no clawback, so losses and fund costs are never set against the winners.
Conventions this workbook uses
Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.
- Annual periods, FY1 the year of the first close. Every cash flow falls at a year end: an investment is bought at the end of its entry year and sold in one realisation a whole number of years later, and no later than FY12, when the fund is wound up.
- The fund holds no cash and borrows nothing. It calls capital for investments, the management fee and fund expenses as they fall due, pro rata from the LPs and the GP commitment, and distributes realisation proceeds in the year received. Proceeds are not recycled into new investments.
- The management fee is charged on total commitments during the investment period and on the cost of investments held at the start of the year after it, at a lower rate. The GP commitment pays the fee and bears carry on the LPs’ terms.
- An unrealised investment is carried at cost in its entry year and then marked towards its exit value in equal annual steps, at the stated share of that straight line. NAV is the sum of those carrying values; the investors’ NAV is after carry accrued on a liquidation at NAV.
- The waterfall is whole-fund: return of all capital contributed to date; then a preferred return that compounds annually on unreturned capital and unpaid preferred return, a contribution earning it from the following year; then the catch-up, in which the GP takes its catch-up share until it holds the carry rate of all profit distributed; then the split.
- The clawback test runs the waterfall on distributions to date plus NAV, against all capital contributed and all preferred return accrued, and compares the carry that would be due with the carry paid. Carry paid above it at the end is a clawback the GP repays in FY12. The deal-by-deal memo takes carry on each realisation against that investment’s own cost and preferred return, ignores losses elsewhere and fund costs, and settles the difference with the last realisation.
- Multiples are on paid-in capital: DPI is distributions, RVPI is net asset value and TVPI is their sum. IRRs are on annual cash flows; the IRR to date treats NAV as an inflow in the year measured.
- A scenario changes the portfolio only: a factor on every gross multiple, whole years added to every holding period and, in the weak vintage, two flagged investments written off. The fund’s terms are the same in all three.
What this model does not cover
Where its answer stops, so you know what to add before relying on it.
- The portfolio companies. Each investment is an entry year, a cost, a holding period and a multiple; the LBO model builds one of them from its operations and debt.
- The management company. Fees and carry are costs to this fund; the asset manager model is the firm that earns them across every fund it runs.
- Recycling. Proceeds are distributed when received and never reinvested, though many fund agreements let early proceeds be recalled.
- A subscription credit line, which delays capital calls and raises the IRR without changing the multiple, and any other borrowing by the fund.
- Fee offsets for transaction and monitoring fees, a GP commitment that pays no fee or carry, and tax on carry or on a clawback.
- Partial realisations, dividends and recapitalisations. Each investment is one cheque in and one out, at a year end.
- A real fund. Fund-level returns published by public pension plans are the natural source for a case; this model uses invented figures.
Build it yourself
The starter workbook
The four tiers of the Waterfall sheet have been cleared: the return of contributed capital and the unreturned balance, the preferred return accrued, paid and carried forward, the GP catch-up, the split, carried interest paid and distributions to investors. Rebuild them from the cash to distribute, the capital called and the three waterfall inputs on the Assumptions sheet, then switch to the slow-exit market and watch the preferred return grow against the carry.
Blanks: Fund distribution waterfall: European and American carry. Download it beside the worked model.
The path around this model
Understand it, drill it, read the build, then apply it to a real company.
Understand · Primer
LBO Mechanics & Returns
Intermediate · a curated reel with a quiz
Build · Lab · ~3 min
IRR by Eye
Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.
Build · Lab · ~8 min
Paper LBO Trainer
Solve MOIC and IRR in your head from a deal you have never seen, in under ten minutes.
Read · Guide · 10 min
Private Equity vs Venture Capital: What Each One Is Actually Buying
Read · Guide · 15 min
How to Build an LBO Model: The Build Order That Survives a Modelling Test
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Apply · Skill
IC Memo Builder
Draft a first-pass investment committee memo that anticipates the committee’s questions.
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
Vocabulary: J-Curve, TVPI, DPI and RVPI, Clawback, Carried Interest (Carry), Preferred Return (Hurdle Rate), GP Catch-Up, LP / GP, Vintage Year, Dry Powder, IRR, MoIC.
Questions about this model
What does the fund return, gross and net?
Over its life the fund calls $954.0 million of its $1,000 million of commitments: $800.0 million for ten investments, $130.0 million of management fees and $24.0 million of expenses. The portfolio returns $1,701.0 million, a gross multiple of 2.13x and a gross IRR of 18.9%. After fees, expenses and carry the LPs earn a net TVPI of 1.63x and a net IRR of 12.6%. In multiple terms the gap is 0.30x to the management fee, 0.05x to expenses and 0.16x to carried interest.
Where is the J-curve in the model?
On the Performance sheet, year by year. Fees and costs are called from the first day and nothing has yet been marked up, so net TVPI is 0.83x at the end of FY1 and 0.92x a year later, and the net IRR to date is -17.9% in FY2. Both recover as investments are marked towards their exit values, but cash lags value: the LPs are $717.4 million out of pocket at the deepest point, and DPI passes 1.0x in FY8, at 1.32x.
How does the whole-fund waterfall pay the carry?
Every distribution first returns contributed capital, then pays an 8% compounding preferred return, and only then reaches the GP. Nothing does until the last capital and the accrued preferred return are cleared and the catch-up begins: $8.6 million in FY8, and the rest over the next two years. Once the GP has caught up it holds 20% of all profit, so on a profit of $747.0 million the fund pays carry of $149.4 million. That includes $3.0 million on the GP’s own $20 million commitment, which the GP pays itself, so the LPs bear $146.4 million. Carry paid is tested to the end: had fees called after it never been returned, the GP would repay the excess as a clawback.
What changes under a deal-by-deal waterfall?
The timing, and then the total. Deal by deal, carry is taken on each realisation against that investment’s own cost and preferred return, so the first exit pays $22.4 million in FY5, three years before the whole-fund waterfall pays anything, and by FY8 the GP is $145.0 million ahead. Because the winners pay carry and the losers and the fund’s costs are never set against them, the GP ends with more than 20% of the fund’s profit and owes a clawback of $48.0 million. Repaying it gives the LPs the same total, later: their net IRR falls from 12.6% to 11.7%.
What do the two scenarios show?
The slow-exit market holds every investment two years longer at the same multiples: the gross IRR falls to 12.5% and the net IRR to 8.1%, fees rise to $154.0 million, and the whole $143.8 million of carry waits for FY12. In the weak vintage two more investments are written off and the gross multiple falls to 1.14x. The LPs end with a net TVPI of 0.94x and the fund earns no carry, yet a deal-by-deal waterfall still pays $65.3 million on the winners, all of it owed back.
Related models
M&A and private equity · Core
Leveraged buyout model
Sources and uses, a cash sweep, sponsor returns
Financial institutions · Core
Asset manager AUM and fee economics model
AUM roll-forward, flows, fee rates, margin, P/E and DCF
M&A and private equity · Advanced
ICG management buyout model
The 2026 Irish Continental Group MBO: preferred, debt, rollover, returns
Real estate · Core
Property acquisition model
Rent roll, NOI, cap rate, three-constraint loan, waterfall
Questions about this model
Discussions open here soon.