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:
VCs are building funds on shockingly shaky modelling foundations.
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:
Model Complexity – the full-fat internal model, with all the tabs and logic.
LP Presentation – the simplified version for decks and data rooms.
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.


