Venture Capital Model, Quarterly Forecast

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.

1. Context primer — paste into Claude or ChatGPT before any change.
2. Prompt guide — ready-made prompts for fund setup, portfolio construction, and scenario analysis.
3. Connect MCP — Claude Desktop or Claude.ai pulls model context automatically.
4. 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

• Portfolio construction · Fund waterfall · VC metrics
• How Hemrock models are built
• Support