Venture Valuation Tool

What you'll do with it

Analyze venture investments before you make them. Model potential rounds (equity, convertible notes, pre-money and post-money SAFEs), dilution, graduation rates, exit valuations, and likelihood of exit at multiple exit prices.

Built for VCs, angels, and syndicates who want to stress-test a deal before committing capital.

What's in the model

• Investment scenarios. Model check size, valuation, instrument type, and conversion mechanics.
• Dilution modeling. Follow-on rounds, new investors, option pool expansions.
• Return analysis. Exit proceeds at multiple valuations, net of preferences and participation.
• Portfolio construction. Graduation rates across stages, reserve allocation.

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 it into Claude or ChatGPT before you make a change.
2. Prompt guide. Ready-made prompts for deal analysis and portfolio construction.
3. Hemrock Skill. A drop-in Claude Agent Skill that loads this model's sheet map, prompts, and checks into any Claude Project. Free, with no connector to set up.
4. MCP server. On ChatGPT, Cursor, or another tool? The MCP server feeds the same context to any AI that speaks MCP.
5. Verify before you trust. The sanity-check prompts catch wrong references and confused metrics.

When to use something else

• Need full fund-level cash flows, management fees, and LP distributions? Use the Venture Capital Model.
• Need high-level fund economics without deal-level detail? Use the Fund Economics Tool.
• Need a company-level cap table, not investor-level returns? Use the Cap Table & Exit Waterfall.

Common questions

Why use this when AI can run deal returns for me?
AI will model a deal and return an exit multiple. Whether it handled the SAFE conversion, the dilution from later rounds, and the liquidation preference correctly is the part that decides whether the number means anything. This is a structure where those mechanics are already right, so you analyze inside it instead of trusting a black box.

Will it handle my deal structure?
Equity rounds, convertible notes, pre-money and post-money SAFEs, follow-ons, and option pool expansions are all prebuilt. Every cell is open, so an unusual instrument is an edit, not a wall.

Excel or Google Sheets?
Both. All formulas open.

Documentation

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