Venture Capital Model, Quarterly Forecast

Simplified model for forecasting a venture fund, to help understand overall fund assumptions and how portfolio construction impacts returns.

5.0(213)17,696 downloads

“Taylor Davidson’s VC model was a game changer for me. It sharpened my thinking immediately, and the time I spent with him was incredibly helpful. Taylor combines deep expertise with a practical, friendly approach, especially for a new fund manager.”

Seth Hallen· Managing Partner, Hallstone Ventures

Pay what you want

$25 suggested, but "0" is ok. All donations appreciated.

$USD

Instant Access

Download to Excel or Copy to Google Sheets

Easy to customize with your AI

Free email support

Inside the model · 15 sheets · 8 sections

License and Terms apply on all purchases, services, and courses.

Get help buying. Call, text, WhatsApp 1-646-770-0052.

What you'll do with it

Forecast a venture fund quarter by quarter. Capital calls, investments, exits, distributions, management fees, and fund expenses on a quarterly timeline with up to three scenarios side by side.

Built for GPs and emerging managers who need granular pacing, not just overall economics.

What's in the model

Quarterly cash flows — capital calls, investments, and distributions on a per-quarter basis.
Portfolio construction — check sizes, reserves, follow-ons, graduation rates.
Three scenarios — model pessimistic, base, and optimistic return assumptions simultaneously.
Performance metrics — Gross and Net IRR, TVPI, DPI, RVPI per scenario.
Management fees and expenses — quarterly fee calculations with recycling logic.

Edit with AI

Every cell open. Inputs in blue, formulas in black, rows documented. Built so you and your AI can edit without breaking it.

Context primer — paste into Claude or ChatGPT before any change.
Prompt guide — ready-made prompts for fund setup, portfolio construction, and scenario analysis.
Connect MCP — Claude Desktop or Claude.ai pulls model context automatically.
Verify before trusting. AI gets fund waterfall logic subtly wrong. Use the sanity-check prompts.

When to use something else

Need the full annual model with fund-level financial statements, detailed waterfall, and LP classes? Use the Venture Capital Model.
Need high-level fund economics without quarterly pacing? Use the Fund Economics Tool.
Just analyzing individual deals, not the fund? Use the Venture Valuation Tool.

Documentation

Ratings

5.0(213 ratings)

99%

Reviews

“Taylor Davidson's VC model was a game changer for me. It sharpened my thinking immediately, and the time I spent with him was incredibly helpful. Taylor combines deep expertise with a practical, friendly approach, especially for a new fund manager.”