Logo
ACADEMY
EVENTS
Search
UPGRADE
SIGN IN
COMPANY BUILDING
INVESTING
PODCAST
MORE
MORE

About Us

Partner with us

Syndicate

The State of Fund Modelling in VC (Preliminary Findings)

circle

Dec 4, 2025

Early insights from respondents across GPs, emerging managers and LPs

by David Cruz e Silva

If you’ve been following along, you’ll know we’ve been quietly collecting data on one of the most under-discussed but absolutely mission-critical parts of venture capital: fund modelling.

And after processing the first wave of responses, I can confidently say two things:

  1. VCs are building funds on shockingly shaky modelling foundations.

  2. LPs assume our models are far better than they actually are.

Table of Contents

1 Why This Matters
2 What This Preliminary Report Is / Isn’t
3 Top Findings (So Far)
4 Who Responded
5 (Paid) Tooling: The Excel Monopoly
6 (Paid) The Real Challenges (In Their Words)
7 (Paid) The Most Difficult Areas
8 (Paid) What VCs Think Is Critical
9 (Paid) Early Patterns
10 (Paid) Insight #1 — The Tooling Maturity Gap
11 (Paid) Insight #2 — The Modelling Literacy Gap
12 (Paid) Insight #3 — The Expectation vs Reality Gap
13 (Paid) Deep Dive: Reserves
14 (Paid) Scenario Analysis
15 (Paid) Assumption Documentation
16 (Paid) Tools & Infrastructure
17 (Paid) Portfolio Construction
18 (Paid) LP Communication & Reporting

Why This Matters

Everyone talks about strategy.

Everyone talks about sourcing.

Almost nobody talks about the actual model behind the fund — the thing that determines reserves, DPI timelines, pacing, diversification, exit pressure, and LP conviction.

And when nobody talks about it, silent assumptions creep in.

Silent assumptions become blind spots.

Blind spots become fundraising friction… and sometimes, fundraising failure.

That’s why we ran this study.

What This (preliminary) Report Is (and Isn’t)

This is not a polished, final whitepaper. It is the first directional snapshot of how European GPs, emerging managers, and LPs actually build and use fund models - and where the cracks are.

Top Findings (So Far)

Here are three datapoints that made me sit up:

1- 96% of respondents still rely on Excel/Google Sheets as their primary modelling tool

(And 73% use nothing but spreadsheets.)

Despite the rise of tools, this industry runs on duct tape and VLOOKUPs.

2- 69% cite scenario & sensitivity analysis as their hardest modelling area

This is the #1 thing LPs scrutinise.

The mismatch creates friction in fundraising and slows diligence.

3- Emerging GPs, established GPs, and LPs all struggle with completely different problems

50% struggle with assumptions & inputs. Fees, reserves, pacing, loss curves — the foundation of every model — are misunderstood more often than we’d like to admit.

Emerging GPs worry about basics.

Established GPs worry about complexity.

LPs worry about clarity.

They’re looking at the same model and seeing three entirely different things.

This is creating what I call the fund modelling literacy gap — and it’s widening, not shrinking.

❝

Critical Finding: Emerging GPs, established GPs, and LPs struggle with completely different modelling problems.

We are not speaking the same language.

Who Responded

One thing I’m proud of:

The split between GPs and emerging managers is almost perfectly even - 38% vs 35%.

This gives us a unique lens:

We can compare experienced modelling practice vs first-time fund building in a way most datasets simply can’t.

LPs represent 15% — small but mighty.

Their responses validate (or explode) assumptions that GPs often hold about allocator expectations. This gives us the rare ability to compare what GPs think LPs expect vs what LPs actually expect, and how those diverge from emerging managers building v1 models from scratch.

❝

Quick preview: the gap is bigger than anyone realises.

This is where today’s public section ends

The full preliminary report is available to EUVC Academy members.

The Excel Monopoly: Why We’re Stuck Here

Despite dozens of tools on the market, fund modelling remains overwhelmingly spreadsheet-driven.

According to our survey, Excel/Sheets dominates usage - with proprietary models, off-the-shelf templates and consultants barely appearing as secondary support.

Why this matters:

  • LPs increasingly expect structured models

  • Excel offers flexibility but almost zero guardrails

  • Model fragility increases exponentially with complexity

  • Assumptions get buried, undocumented, or inconsistent

The tooling maturity gap is real - and visible in every downstream insight.

The Real Challenges (In Their Words)

The qualitative responses reveal a consistent theme:

❝

Modelling isn’t hard because it’s math - it’s hard because it’s dynamic.

Respondents cite:

  • exit timing uncertainty

  • reserves that break the model

  • denominators that move

  • complexity that spirals

  • scenario logic that is brittle

This is where almost every GP overestimates their model - and where almost every LP notices gaps immediately.

Most Difficult Areas (and Why LPs Feel It)

69% struggle with return scenarios & sensitivity analysis.

This is the LP litmus test.

Why?

Because scenario design reveals:

  • whether you understand power law mechanics

  • whether you’ve modelled pacing and reserves credibly

  • whether your DPI pathways make sense

  • whether your upside is defensible or fantasy

If your scenarios are bolt-ons, LPs can smell it.

What VCs Think Is Critical - and the Gap That Creates

Respondents overwhelmingly say:

  • Exit outcomes (65%)

  • Assumptions clarity (62%)

…are the most critical parts of a model.

Yet these are exactly the sections that are most underdeveloped in real fund models.

This is the expectation → execution gap.

Early Patterns: What the Data Is Quietly Screaming

This section of the preliminary report pulls a bunch of threads together into one picture - and it’s not a comfortable one.

1- Spreadsheets aren’t just dominant, they’re a monopoly

We already knew Excel/Sheets was widely used. The deeper pattern is that 73% of respondents use it as their only modelling environment, and 96% have it at the core of their stack.

This isn’t tool preference — it’s infrastructure lock-in. Everyone uses spreadsheets because everyone else does. LPs, admins, auditors, co-GPs. No one wants to be the first to move.

2- The “Scenario Gap” is the single biggest vulnerability

69% say scenarios and sensitivities are the hardest part of modelling.

That’s the thing LPs care most about and the thing most models are worst at. The result: beautiful decks sitting on top of fragile scenario logic that collapses as soon as an LP starts poking.

3- Assumptions are still a dark art

50% of respondents struggle with assumptions & inputs (fees, reserves, pacing, etc.).

These are the parameters that define the fund’s economic reality — and half the market is unsure they’re getting them right. For emerging managers, this often means copying someone else’s model and hoping the assumptions “look market”.

4- Reserves logic is a universal headache

Across the verbatims and charts, reserves show up everywhere: how much to allocate, when to allocate, how to stress-test adequacy across scenarios. Even experienced GPs admit this is where the model feels most fragile.

5- LPs want standardisation, GPs want uniqueness

Allocator responses point to a clear desire: more comparable models, clearer assumption docs, and cleaner scenario frameworks.

GPs, meanwhile, often treat their model as part of their “secret sauce”. That tension - between comparability and customisation - is at the heart of today’s LP–GP modelling friction.

Insight #1: The Tooling Maturity Gap

LPs expect:

  • clarity

  • pacing realism

  • transparent reserves logic

  • defendable scenarios

GPs deliver:

  • spreadsheets

  • complexity

  • breakage

  • undocumented logic

Emerging managers deliver:

  • templates

  • anxiety

  • untested assumptions

This is the root of so much fundraising friction.

Insight #2: The Modelling Literacy Gap

Three groups, three different problems:

  • Emerging GPs struggle with fundamentals

  • GPs struggle with scale and complexity

  • LPs struggle with transparency and comparability

Everyone is misaligned.

Everyone is frustrated.

No wonder fundraising takes so long.

Insight #3: The Expectation vs Reality Gap

This is the killer insight:

Emerging GPs think complexity = sophistication.

GPs know complexity = fragility.

LPs think complexity = opacity.

This single dynamic explains ~40% of the friction in fundraise conversations.

Reserves: The Universal Pain Point

Regardless of fund size or maturity, everyone struggles with reserves modelling.

Why?

  • denominators move

  • pacing shifts

  • pro-rata assumptions explode

  • upside & downside diverge massively

  • scenarios break reserve logic

Even large funds struggle here.

Emerging managers struggle the most.

Scenario Analysis: The LP Conviction Engine

LPs use scenarios to understand:

  • risk

  • return profile

  • pacing discipline

  • DPI timeframes

  • concentration risk

Most GP models fail here because:

  • scenarios are bolt-ons

  • assumptions don’t connect

  • timing is unrealistic

  • downside cases are weak

This is fixable — but only with better frameworks.

Assumptions Documentation: The Silent Killer

50% struggle with assumptions & inputs.

The problem isn’t the assumption itself - it’s the documentation.

LPs care far more about:

  • why you picked an assumption

  • how you defend it

  • whether it’s internally consistent

than the number itself.

Tools & Infrastructure: The Hidden Cost

19% cite tools as a primary challenge.

That number is artificially low - because most GPs don’t realise how much their toolset is holding them back.

Spreadsheet fragility compounds over time.

And LPs feel the pain.

Portfolio Construction: The Underestimated Driver

Portfolio construction assumptions are the silent driver of fund returns.

Few model them well.

This is an area where we can materially raise literacy across Europe.

LP Communication & Reporting: The Missing Layer

Only 12% of respondents picked LP communication and reporting as a top challenge. On the surface, that sounds reassuring. In reality, it’s probably the most under-reported problem in the entire study (so far).

Most GPs instinctively prioritise: “Does this model work for us?”

LPs are asking a different question: “Does this model make it obvious how this fund really behaves?”

Our preliminary report, illustrates this as a three-step funnel:

  1. Model Complexity – the full-fat internal model, with all the tabs and logic.

  2. LP Presentation – the simplified version for decks and data rooms.

  3. LP Understanding – the point where the allocator actually gets it and feels conviction.

Most GPs live in step 1.

Some manage step 2.

Very few consistently get to step 3.

The translation challenge is real:

  • Taking a dense, multi-tab Excel file

  • Distilling it into clear visuals of assumptions, scenarios, pacing, and reserves

  • Keeping it fully consistent with the working model

  • And doing this across multiple LPs, vintages, and strategies

LPs repeatedly say they value:

  • simple, visual representation of key assumptions

  • transparent scenario frameworks

  • straightforward sensitivities (“show me what happens if exits slip by 12–18 months”)

  • tight alignment between the model and the pitch narrative

In other words: the best models are bilingual — they speak GP and they speak LP.

Right now, most are fluent in neither.

Emerging Patterns: The Meta-Insights

A few big trends:

  • Spreadsheet lock-in

  • Complexity paradox

  • Literacy stratification

  • Scenario gap

  • Standardisation demand

  • Reserve complexity

These are systemic issues - not individual GP flaws.

The Path Forward: Closing the Fund Modelling Gap (Together)

After analysing this first wave of data, one thing is clear: Venture’s fund modelling gap isn’t a technical problem - it’s a literacy, tooling and communication problem. And unless we close it now, the gap between LP expectations and GP execution will only widen.

Here’s what the preliminary findings point to:

1- We need better, shared standards.

Exit outcomes (65%) and assumptions clarity (62%) top the list of “critical model components,” yet they’re also among the most inconsistently modelled across respondents.

We need common frameworks - not just prettier spreadsheets.

2- We need to raise modelling literacy across the ecosystem.

69% struggle with scenario design.

50% struggle with assumptions.

Reserves appear as a pain point across every respondent category.

This isn’t about “junior modellers.” It’s systemic.

3- We need tools and education that map to LP expectations.

LPs consistently ask for clarity, pacing realism, defensible sensitivities and transparent assumptions.

Most models today… don’t deliver that.

Not because GPs don’t know how - but because no one has ever taught this properly.

4- We need more data: and we’re still early.

First respondents gave us a strong early signal, but the deeper insights (benchmarks, strategy-specific patterns, vintage effects, reserve ratios, pacing profiles) require a larger dataset.

How EUVC Academy Fits In

This project is a perfect example of why we’re building the EUVC Academy.

There’s no consistent place for European GPs and emerging managers to learn:

  • how to build institutional-grade fund models

  • how to structure assumptions

  • how to design scenarios LPs actually trust

  • how to communicate reserve logic clearly

  • how to translate a model into a narrative

So we’re fixing that.

Comments

Avatar

or to participate

LISTEN ON


Spotify

Apple Podcasts

RECOMMENDED


Seed Data Room

Early-stage fundraising

Talent in European Tech: Turning Interest into Integration

Europe's opportunity to attract top global tech talent

One Tab Wisdom: Your ultimate GTM Cheat Sheet

Why every early stage SaaS founder needs a sales process

On The Pulse: AI Engineer Hiring

AI is no longer a ‘specialism’, it’s an essential skill

Scaling Verticals with Deep Expertise

Misconception: off-the-shelf AI instantly creates high-value products


EVENTS


EUVC Summit & Awards
Wed, Apr 22, 2026
9:00 AM - 9:00 PM WEST


Fund Returner Workshop
Wed, Apr 8, 2026
2:00 PM - 4:00 PM WEST


Montblanc Retreat
Thursday, May 7 – Sunday, May 10, 2026


Corporate Venturing Retreat
Monday, May 11 – Thursday, May 14, 2026


All Events

ACADEMY



Learning for the next generation of tech investors.




The home of European tech


I consent to receive newsletters via email. Sign up Terms of service.

Already a subscriber? Sign in

FOLLOW

© 2025 EUVC

Publisher Terms