Free Excel templates

A free venture capital fund model in Excel, with a complete worked fund

Management fees with a step-down, carried interest year by year and under five conventions, the J-curve and the gross, net and pre-fee IRRs: five linked sheets, one fictional fund, no macros.

The file models one venture fund from commitment to wind-up. Kelvinside Ventures Fund III raises 150,000,000, charges a 2% fee with a step-down after five years and 20% carried interest with no hurdle, and invests 130,500,000 in twenty-eight companies that return 348,975,000. The fund earns a gross IRR of 18.34%; the limited partner earns a net IRR of 15.77% and 2.06x its commitment. Fees cost 21,470,000 and the carried interest 39,795,000, and every one of those numbers is a formula you can move.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Venture_Capital_Fund_Model.xlsx (31 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This file is one worked case from Venture Capital. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.

Get the book on Amazon →

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

Five sheets, in the order the calculation runs. Inputs are blue type on a pale yellow fill; everything else is a formula.

Read me
What the workbook does, the conventions it uses for fees, carried interest and rates, and the first experiment to run: the preferred return.
Inputs
The fund terms (commitment, fee rate, full-rate years, carried interest, life) and the twenty-eight lines: initial cheque, reserve, the multiple on each and the exit year.
Fund
The management fee year by year on the commitment and then on the cost of positions still held, the four multiples of the same fund, the carried interest, the limited partner's net gain and its invariant, recycling, and the manager's take on four bases.
Flows
The annual flows: investments, fees, calls, distributions, carried interest by year and the limited partner's own column; the J-curve and its shape; the three rates; the same carry collected at three dates; carry under five conventions, including an 8% hurdle with and without catch-up; and the manager's share of the gain at other outcomes.
Checks
Every figure the book prints set against what the workbook computes, to the precision printed, with a PASS or FAIL on each of the 86 lines.

What the worked fund returns

MeasureValue
Commitment / capital invested150,000,000 / 130,500,000
Management fees over the life21,470,000 (14.31% of the commitment)
Gross proceeds, and gross multiple on invested348,975,000 (2.67x)
Carried interest, whole of fund39,795,000
Net TVPI to the limited partner2.06x
IRR before fee and carried21.72%
Gross IRR, after fee, before carried18.34%
Net IRR to the limited partner15.77%
Trough of the J-curve-129.9 million in year 6 (86.57% of the commitment)
Carried interest across five conventions25,349,223 to 52,195,000

Read the three rates together. The fee takes 3.39 points off the rate and the carried interest 2.5622, so the limited partner keeps 15.77% of a fund that earned 21.72% before costs. The same carry, taken in year one instead of as it fell, would cut the net IRR to 11.51%: timing matters as much as the headline 20%. And the carry clause itself is worth 26,845,777 between the cheapest and the dearest of five conventions, which is more than the whole fee.

How to use it on your own case

  1. Open Inputs and overwrite the blue cells: commitment, fee rate, full-rate years, carried interest and fund life.
  2. Replace the twenty-eight lines with your own portfolio: cheque, reserve, the multiple on each and the exit year. A line with no reserve takes 0.
  3. Enter the investment schedule on Flows (column B) and check on the Checks sheet that it still adds up to the capital invested.
  4. Read the three rates and the J-curve on Flows, then the five carry conventions. Change the preferred return on row 92 to see which clause moves the carry.
  5. Keep the Checks sheet: once you change inputs it stops matching the book, which is expected. Use its structure for your own tie-outs.

Questions people ask about it

Is this venture capital fund model really free?

Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Does it use macros, and how are the rates computed?

No macros and no circular reference. Every flow sits at the end of its year and the rates use IRR on annual flows. Fees are called and sit inside the capital called; carried interest is whole-of-fund on the commitment and is deducted from the year's distributions.

Why is the gross IRR not gross of the fee?

Because the fee is already inside the capital called. The 18.34% gross IRR is after the fee and before the carried interest. The workbook adds the rate before both, 21.72%, so the fee drag (3.39 points) and the carried drag (2.56 points) can be read separately.

Can I use it for a real fund?

You can reuse the structure. Kelvinside Ventures Fund III, its twenty-eight companies and every figure in the file are fictional, and nothing here is investment advice.

The rest of the files

This template is one of the companion files for Venture Capital: the full set adds The Four Multiples (the twenty-eight lines and the like-for-like ladder), The Power Law (concentration, the median and the fund without its best lines) and The Reserve (initial cheques against follow-ons). Free, like this one.

Open the companion files →

Worked questions from the same book

Short articles that each answer one question with the arithmetic shown, on the same ground as this model.

Other free templates

This template comes from Venture Capital. The book is on Amazon.

If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.