VC Fund Model Excel Template: Build Fees, Carry, Capital Calls and LP Returns in 6 Tabs

A VC fund model Excel template projects a venture fund's full life in one workbook. It covers when LPs fund their commitments, how much the GP charges in management fees, how carried interest gets split through the distribution waterfall, and what net multiple and IRR the LPs actually end up with. The cleanest build uses six linked tabs: Inputs, Capital Calls, Fees and Expenses, Portfolio and Exits, Waterfall, and LP Returns. Each tab feeds the next, so changing one assumption moves every output.

As of November 2026. Figures below are dated to their sources.

Key facts

Fact	Value	Source	As of
Median VC management fee during investment period	2%	carta.com	2025-12-04
Median VC carried interest	20%	carta.com	2025-12-04
Median VC GP commitment	1.7%	carta.com	2025-12-04
2017 vintage median TVPI	1.89x	carta.com	2026-03-19
2021 vintage median net IRR	1.4%	carta.com	2026-03-19
2022 vintage capital deployed after 24 months	43%	carta.com	2024-06-30

This guide walks through that VC fund model Excel template one step at a time, using a worked $50M fund example and benchmarks from Carta's fund datasets and ILPA guidance. It suits an emerging manager building a first fund deck, an LP checking a GP's projections, or an analyst handed a blank spreadsheet model and a deadline.

What a VC Fund Model Excel Template Has to Answer

LPs ask four questions in every diligence meeting, and the model exists to answer them with numbers:

How much of my commitment gets invested in companies, and how much goes to fees and expenses?
When will you call my capital, and how fast?
At a given gross multiple, what is my net multiple after carry?
When do I get cash back (DPI), and how does that compare with funds of the same vintage?

Start with market terms as your base case. Carta's Fund Economics Report 2025, published December 2025 and drawn from roughly 2,000 US funds on its platform, found that 2-and-20 is still the norm, with a median management fee of 2% during the investment period and a median carry of 20% of profits. The same dataset puts the median VC GP commitment at 1.7% of fund size. Smaller funds often charge more than 2%. Carta's analysis of emerging managers found that funds under $50M frequently set initial-period fees at 2.5% or higher, because a 2% fee on a small fund doesn't cover a team.

Takeaway: before you open Excel, write your LPA term sheet in one column, covering fee rate, fee basis, step-down year, carry rate, hurdle (if any), waterfall type, GP commit, fund term. Every formula in the model points back to those cells.

Tabs 1 and 2: Inputs and the Capital Call Schedule

Tab 1: Inputs

Keep every hard-coded number on this tab and nowhere else. For the worked example, these are the inputs:

Fund size: $50M committed capital
GP commit: 1.7% ($850K), in line with the Carta median
Management fee: 2.0% of commitments in years 1 to 5, stepping down to 1.5% of net invested capital in years 6 to 10
Fund expenses: organizational costs of $300K plus $100K a year in ongoing expenses (an illustrative assumption; use your counsel's and administrator's quotes)
Carry: 20%, European (whole-of-fund) waterfall
Investment period: 5 years; fund term: 10 years plus two 1-year extensions
Reserve ratio: 50% of initial checks held back for follow-ons

Use one column per year (or per quarter, if you need LP-level cash detail) running across the top. Color inputs blue and formulas black, and name the key cells (Fund_Size, Carry_Rate) so the waterfall formulas stay readable.

Tab 2: Capital Calls and Deployment

Capital calls are a derived number. You don't type them in. Build them in this order:

Project new investments by year from your deal pacing (number of initial checks multiplied by average check size).
Layer follow-on investments onto the prior-year cohort using your reserve ratio.
Add that year's management fees and fund expenses from Tab 3.
Subtract any recycled proceeds the LPA allows you to reinvest.
The result is the capital call. Cap cumulative calls at 100% of commitments with a MIN formula, and flag any year that breaches the cap.

Be realistic about pacing. Carta's Q1 2024 fund performance report found that 2022-vintage funds had deployed only about 43% of committed capital after 24 months, against 60% for the 2020 vintage. If your model assumes 70% deployed by month 24, an experienced LP will notice. Pace matters because IRR punishes capital that sits uncalled at the LP while you search for deals less than it punishes capital called early and left idle. Most funds call capital just in time for closings for this reason.

Formatting matters as well. ILPA released an updated Capital Call and Distribution Template on September 11, 2025, which replaced its 2011 standard and adds more detailed transaction reporting. If you map each call in Tab 2 to the same categories (investments, management fees, fund expenses), your model output drops straight into the notices LPs now expect to receive.

Takeaway: add a check row at the bottom of Tab 2 that sums investments plus fees plus expenses minus recycling and compares it with total calls. If the check isn't zero, stop and fix it before you build anything downstream.

Tab 3: Management Fees, Expenses and Investable Capital

This tab tells LPs what share of their money actually reaches startups. Run the worked example:

Years 1 to 5: 2.0% times $50M equals $1.0M a year, or $5.0M in total
Years 6 to 10: 1.5% times roughly $40M of net invested capital equals about $0.6M a year, or $3.0M in total
Lifetime fees: about $8.0M, or 16% of commitments
Expenses: $300K organizational plus $1.0M ongoing over 10 years, $1.3M in total
Investable capital before recycling: $50M minus $8.0M minus $1.3M, which is $40.7M

That 16% drag is the figure LPs care about most. Two levers close the gap. The first is the fee step-down: switching the basis from commitments to net invested capital after the investment period cuts fees as the portfolio gets exited or written off. The second is recycling, which lets the GP reinvest early proceeds up to a cap (often written as a percentage of commitments) so investable capital moves back toward 100%. Model recycling as its own input with an on/off toggle. A fund that recycles $8M of early exit proceeds invests close to the full $50M, and its gross-to-net spread narrows noticeably.

Build the fee formula with an IF on the year index: IF(Year<=Inv_Period, Fee_Rate_1 * Fund_Size, Fee_Rate_2 * Net_Invested_Capital). Net invested capital equals cumulative cost basis minus cost basis of exited and written-off companies, so this tab pulls from Tab 4. Watch for a circular reference here and break it by using prior-year-end balances.

Takeaway: show "investable capital as a percentage of commitments" in the model's output and on your one-page fund summary. LPs will calculate it anyway, and you look better having done it first.

Tab 4 and Tab 5: Portfolio Exits and the Carry Waterfall

Tab 4: Portfolio and Exits

Choose between two approaches. A company-by-company build lists each planned investment with entry valuation, ownership, dilution per round, exit year and exit value. A cohort build applies an outcome distribution (for example, 50% of companies return 0x, 30% return 1x to 3x, 15% return 3x to 10x, and 5% return more than 10x) to each year's cohort of initial checks. For a pre-launch fund, the cohort approach is easier to defend because nobody knows the actual companies yet. Whichever you choose, the output this tab sends onward is the same: gross proceeds by year and remaining unrealized value (NAV) by year.

For the worked example, assume $42M invested in total (after modest recycling) at a 3.0x gross multiple, giving $126M of gross proceeds, with most exits landing in years 7 to 10.

Tab 5: The Distribution Waterfall

Most US VC funds and ILPA's model terms use a European, or whole-of-fund, waterfall. Torys' 2020 summary of ILPA Principles 3.0 and the ILPA Model LPA notes that ILPA prefers the whole-of-fund model, in which the GP receives no carry until LPs have got back all contributed capital (plus any preferred return, typically 8% where one exists). Build the waterfall as four cumulative tiers:

Return of capital: 100% of distributions go to LPs until cumulative distributions equal cumulative contributions, fees and expenses included.
Preferred return: if the LPA has a hurdle, 100% goes to LPs until they have received the pref on contributed capital. Many VC LPAs have no hurdle, so give this tier a toggle.
GP catch-up: if there is a hurdle with catch-up, the GP receives 100% (or 80%, depending on the terms) until it has 20% of total profits.
Carried interest split: every further dollar is split 80/20 between LPs and the GP.

The worked example, with no hurdle, runs like this. $126M in gross proceeds less $50M of contributed capital leaves $76M of profit. Carry at 20% is $15.2M, and LPs receive $50M plus $60.8M, or $110.8M in total. A 3.0x gross fund becomes roughly 2.2x net to LPs (for simplicity, this ignores the GP commit, which is usually carry-free).

Model each tier with cumulative MIN and MAX formulas rather than year-by-year logic. Calculate cumulative LP entitlement at each tier, then take the difference between years to get annual flows. This approach handles years where a large exit pushes distributions through several tiers at once. Add a clawback test as well. If cumulative GP carry at fund end is more than 20% of cumulative profits, the excess is owed back. The Torys summary reports that ILPA wants clawbacks paid gross of tax within two years and supports escrowing at least 30% of carry where interim carry is paid.

Takeaway: stress-test the waterfall at 1.0x, 1.5x, 3.0x and 5.0x gross. At 1.0x, the carry cell should read zero. If it doesn't, your return-of-capital tier is excluding fees.

Tab 6: LP Returns and How to Benchmark Them

The final tab turns cash flows into the five metrics LPs report to their own committees:

DPI (distributions to paid-in): cumulative LP distributions divided by cumulative contributions
RVPI (residual value to paid-in): LP share of NAV divided by contributions
TVPI: DPI plus RVPI
Net IRR: XIRR on dated LP cash flows (calls negative, distributions positive, final NAV as a terminal inflow)
Gross-to-net spread: gross MOIC minus net TVPI, which shows how much fees and carry cost the LPs

Use XIRR with actual or assumed call dates, not IRR on annual buckets. Annual bucketing overstates or understates returns by a few hundred basis points depending on timing within the year. Show DPI, TVPI and IRR as a time series by year, because LPs want to see the J-curve, with negative IRR in years 1 to 4 while fees get called and marks stay at cost, then the turn as exits arrive.

Benchmark the output against real vintages. Carta's Q4 2025 VC Fund Performance report, published in March 2026 and covering 2,906 funds, shows the 2017 vintage at a median TVPI of 1.89x, a top-quartile TVPI of 2.53x and a top-decile TVPI of 4.08x. The worked example's 2.2x net therefore sits between median and top quartile, which is a defensible base case. Pitching 4x net as your base case puts you in the top decile of a mature vintage. Liquidity is slower for younger funds. The same Carta report puts median net IRR at 1.4% for the 2021 vintage and 0.7% for 2022, and notes that only a little over half of 2020-vintage funds had produced any DPI by the end of 2025.

Takeaway: put a benchmark block on Tab 6 that shows your projected net TVPI next to the Carta median and top-quartile figures for the most comparable vintage. It frames the conversation before an LP raises the comparison.

Common Build Errors and a Pre-Send Checklist

The same mistakes turn up in most first-draft fund models:

Calculating carry on gross proceeds instead of profit after return of all contributed capital, fees included
Charging step-down fees on commitments when the LPA says net invested capital
Letting cumulative capital calls exceed 100% of commitments because recycling wasn't netted
Charging the GP commit carry or fees when the LPA exempts it
Using IRR() on annual totals when the cash flows are dated

Before the model goes to an LP, run these checks in order:

Total LP distributions plus GP carry equals total gross proceeds, to the dollar.
Total calls equal investments plus fees plus expenses minus recycling.
Carry is zero at a 1.0x gross multiple.
Net TVPI is below gross MOIC in every scenario.
Changing the fee rate on Tab 1 changes net IRR on Tab 6 without any manual edits.

Takeaway: build these five checks into a "Checks" row that turns red when any of them fails, and pin it to the top of Tab 6.

Why Start from a Ready-Made VC Fund Model Excel Template

Building this workbook from scratch takes an experienced analyst several days, and most of that time goes on the waterfall tiers, the fee-basis switch and the circular reference between fees and net invested capital. Those are also the parts where a single wrong cell reference quietly moves net IRR by two points in front of an LP. A tested template gives you the six-tab architecture, pre-built cumulative waterfall formulas with hurdle and catch-up toggles, XIRR-based LP returns, and the check rows already in place. Your work then shifts to the part that matters for fundraising, which is defending your pacing, your reserve strategy and your exit assumptions against the Carta benchmarks.

If you're raising a fund in the next two quarters, start with the inputs tab. Enter your actual LPA terms, run the 1.0x and 3.0x stress tests, and compare your net TVPI with the vintage medians. Once those numbers hold up, the rest of the deck is easier to write.