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.
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).
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
Measure
Value
Commitment / capital invested
150,000,000 / 130,500,000
Management fees over the life
21,470,000 (14.31% of the commitment)
Gross proceeds, and gross multiple on invested
348,975,000 (2.67x)
Carried interest, whole of fund
39,795,000
Net TVPI to the limited partner
2.06x
IRR before fee and carried
21.72%
Gross IRR, after fee, before carried
18.34%
Net IRR to the limited partner
15.77%
Trough of the J-curve
-129.9 million in year 6 (86.57% of the commitment)
Carried interest across five conventions
25,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
Open Inputs and overwrite the blue cells: commitment, fee rate, full-rate years, carried interest and fund life.
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.
Enter the investment schedule on Flows (column B) and check on the Checks sheet that it still adds up to the capital invested.
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.
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.
How many companies should a VC fund invest in?Portfolio size does not change a venture fund's expected multiple. It changes the shape around it, and that shape can be computed exactly.
Other free templates
LBO modelSources and uses to sponsor IRR, twelve sheets, every figure checked.
Real estate property modelRent roll, cash flow, debt and returns for one asset, empty and ready to fill.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
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.