Fund Economics Tool

Welcome to the new site. Problems, use store.hemrock.com

Fund Economics Tool

Simple model for forecasting overall returns of a venture fund, to help understand overall fund assumptions and returns.

4.9(21)3,760 downloads

Venture Capital Model, Overall Fund, by Foresight (Make a copy or Download) - Google Sheets - 23 September 2022
1.2×
3 min⚡️3 min 46 sec3 min 1 sec2 min 30 sec2 min1 min 46 sec1 min 30 sec1 min 12 sec
1.2×
3 min⚡️3 min 46 sec3 min 1 sec2 min 30 sec2 min1 min 46 sec1 min 30 sec1 min 12 sec
    • heart
      1
    • yes
      2
    • fire
      3
    • clap
      4
    • yay
      5
    • eyes
      6
  • More reactions
    7

    Frequently Used

    Smileys & Emotion

    People & Body

    Animals & Nature

    Food & Drink

    Activities

    Travel & Places

    Objects

    Symbols

    Flags

    Make frequently used emojis my default
Comment
C
0 Comments
Be the first to comment
HitCto reply to Taylor or leave a comment at the top of this panel.
Pay what you want

$20 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

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

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

Highlights

Get the shape of fund economics. Average check size, capital allocation, expected return multiple, and out comes Gross/Net IRR, Multiple, RVPI, DPI, TVPI. No operational-level cash flow modeling. The simplest way to think about a fund strategy before building a real model.

What you'll do with it

Sketch the shape of a fund. Set fund size, average check, follow-on allocation, and expected gross return multiple, and see what that produces in fund-level metrics. Use it to test a thesis before committing to a full forecast, or to teach someone how fund economics actually work.

It does not forecast cash flows over time, model timing of capital calls and distributions, or build financial statements. For that, move up to the Venture Capital Model.

Edit with AI

Every cell open. Documented row by row. Built to be edited.

  1. Context primer, paste into Claude or ChatGPT before any change.
  2. Prompt guide, ready-made prompts for setup and quick scenarios.
  3. Connect MCP, Claude Desktop or Claude.ai pulls model context automatically.
  4. Verify before trusting, sanity-check prompts catch wrong references and confused metrics.

When to use this vs. the full model

Fund Economics Tool Venture Capital Model
What it computes Total fund returns Quarterly cash flows + returns
Portfolio construction Average investment Graduation rates, follow-ons, proratas
Financial statements No Yes
Preferred return / GP carry No Yes
Management company budget No Yes
Best for Sketching a thesis Modeling a real fund
Price Free Paid

Background reading: How to Model a Venture Capital Fund · Portfolio construction

Documentation

Ratings

4.9(21 ratings)
5
95%
4
0%
3
5%
2
0%
1
0%

Reviews

No reviews yet. Used this product? Sign in to leave a review.