Venture Capital Model, Quarterly Forecast
Welcome to the new site. If you have any issues purchasing or accessing models, use store.hemrock.com.Welcome to the new site. Problems, use store.hemrock.com
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
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)
5
99%
4
1%
3
0%
2
0%
1
0%
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.”
Seth Hallen· Managing Partner, Hallstone Ventures
“The Manual Portfolio Fund offers a unique granularity that sets it apart. Highly recommended!”
Michael Morvan· Investor, Roch Ventures
“Great product that made a huge project much much much easier. Quick response to questions and clarifications. Excellent!”
Lawson Carmichael· Venture Partner, Resilient Ventures, LLC
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