Fund Economics Tool

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.

What you get

The Fund Economics Tool is one product on two surfaces, sold as a single pay-what-you-want purchase. Whatever you pay (or don't), you get access to:

• The spreadsheet template. Downloadable file, every cell open, runs offline in Excel or Google Sheets, integrates with anything that reads .xlsx.
• The hosted version. A live, in-browser model. Auto-save, multiple saved models, public and private share links, Monte Carlo simulation, return-the-Fund analysis, strategy and reserves allocations. See the demo.

The math is identical across both, although the user experience in the in-browser model provides the strategy and reserves allocation in a more flexible manner (you have to build it into the spreadsheet model, straightforward to do) and is prebuilt for Monte Carlo simulation (easy to add in the spreadsheet model with a simulation modeling add-in).

How to use

1. Sign in at hemrock.com using the email you paid with.
2. Open the Fund Economics Tool from your dashboard and either (a) download an Excel model, (b) copy the Google Sheets to your Google Drive, or (c) create a new web model.
3. Using your spreadsheet software and leveraging the documentation and AI tools (Skill package, MCP server, AI prompt guide), use and edit the model as you wish. If you are using the web model, edit your inputs across the tabs and create scenarios or multiple versions of the model as you wish. Use the Ask AI feature to ask questions about the model and make edits for you directly in the web.
4. Switch between models, share read-only private or public links with LPs, or invite collaborators to use and edit the model with you.

Both the spreadsheet and web models are available as a single pay-what-you-want purchase. Collaborative multi-user editing is an optional add-on, priced at $49 for a one year license for the model owner to share the model with co-GPs, analysts, LPs, or fractional CFOs to access and edit a model alongside you. Building, saving, and read-only sharing are all part of the base Fund Economics Tool; the add-on is only needed for the team feature.

How the hosted-only features work, in depth: Share links, Collaboration, Saved models. The Outputs deep dives: Reserves and follow-ons, Scenarios and simulation, Return-the-fund.

Build it into your own product

The hosted version's engine is also published as a source-available npm package: @tdavidson/fund-economics-tool or on GitHub to allow you to build the core engine into your own tools. Install it, call computeFund(inputs) from a Node script, a serverless function, or your own React app. Build your own user interface, or use the optional UI prebuilt at @tdavidson/fund-economics-tool/ui. The Monte Carlo feature is an additional option, prebuilt at @tdavidson/fund-economics-tool/mc.

Free for a single fund management company applying it to your own funds, SPVs, and team. Service providers (fund administrators, outsourced CFOs running across clients) and any SaaS, white-label, or embedded distribution need a commercial license. See The fund economics engine for the install walkthrough and license summary.

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

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

Documentation

• How to model a venture capital fund
• Portfolio construction
• Bring your own model