Financing schedules · in 1 model

Fund cash flows: commitments, capital calls and NAV

Commitments, calls, paid-in capital, proceeds, NAV.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: fund cash flows: commitments, capital calls and nav.Updated 11 November 2026

Part of m&a and private equity models, with the models, labs and guides around it.

What it does

The base of a fund model. Investors commit capital and the fund calls it only as cash is needed: for each investment, for the management fee and for the fund’s own expenses. Capital called to date is paid-in capital, and what is left is uncalled commitments. Each investment enters at cost and leaves as proceeds in its exit year; between the two it is carried at a value the manager marks, and the sum of those values is the fund’s net asset value. Proceeds are distributed as they arrive unless the fund agreement lets them be recycled into new investments.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Private equity fund model: cash flows, J-curve and waterfall
  • Assumptions, rows 11–13: LP commitments, GP commitment, Investment period
  • Assumptions, row 27: Share of the straight-line gain carried in NAV
  • Portfolio, rows 6–10: Entry year, Cost, Holding period, Gross multiple of cost…
  • Portfolio, rows 13–24: Exit year, Years held, Gross multiple, Realisation proceeds…
  • Investments, rows 6–16: Investment 1, Investment 2, Investment 3, Investment 4…
  • Investments, rows 19–29: Investment 1, Investment 2, Investment 3, Investment 4…
  • Investments, rows 32–42: Investment 1, Investment 2, Investment 3, Investment 4…
  • Investments, rows 45–58: Investment 1, Investment 2, Investment 3, Investment 4…
  • Fund Cash Flows, rows 6–7: Total commitments, LP share of commitments
  • Fund Cash Flows, rows 20–28: Called for investments, Called for the management fee, Called for fund expenses, Capital called…
  • Fund Cash Flows, rows 31–33: Cash to distribute, Net asset value before carry, Check: capital called beyond commitments

What a reviewer looks for

  • The whole commitment treated as paid in on the first day, which overstates capital at work and understates the IRR.
  • Fees and expenses left out of the calls, so paid-in capital equals invested capital.
  • Unrealised investments marked to their exit value from the start, which removes the J-curve.

Learn it, then build it

Vocabulary: LP / GP, Dry Powder, Vintage Year.

Other financing schedules