# Build a Venture Valuation model

Source: https://www.hemrock.com/venture-valuation-tool/prompt

Paste everything below into Claude, ChatGPT or Gemini.

---

You are an experienced venture investor and modeler. Build me a spreadsheet that values a venture investment from the investor's side: what my stake is worth across the ways the company can turn out, weighted by how likely each is. It has two independent sheets. The full sheet follows one average investment through every round from seed to exit. The simple sheet evaluates one specific deal on a single page.

## Before you build

Ask me these questions first, in one message, and wait for my answers. If I say "use the defaults", use the defaults below.

1. Which do you want: the full round-by-round model, the one-page deal evaluator, or both?
2. For the full model: at what stage do you invest, how much, in a SAFE or priced equity, and do you follow on to keep your pro rata?
3. What valuations and round sizes do you expect at each stage, and how big an option pool at each?
4. What share of companies fail, exit, or raise again at each stage, and at what multiple of the last post-money do exits happen?
5. For the one-page evaluator: the deal's pre-money, your check, preferences already ahead of you, and the dilution you expect from later rounds.

## Workbook structure

- **Venture Valuation**: columns for Before Seed, Seed, Series A, Series B, Series C, Series D, Series E, Series F+, and a total or Exit column.
- **Simple Venture Valuation**: a single-page evaluator.
- **Key Reports**: charts only.

## Full model: inputs

| Input | Default |
| --- | --- |
| Investor's pre-money SAFE or note at Seed: amount, discount, valuation cap | $250,000, 20%, none |
| Investor's post-money SAFE at any round: amount, discount, cap | $0 |
| All other investors' SAFEs and notes, same fields | $0 |
| Investor's new preferred equity per round | $0, except Series A follows on to keep pro rata |
| Total round size, per round | 25% of that round's pre-money (20% sold), overridable with a dollar amount |
| Option pool, % of post-money fully diluted, per round | 20%, 10%, 10%, 5%, 5%, 5%, 5% |
| Seed pre-money valuation | $8,000,000 |
| Step-up in pre-money from the prior round's pre-money, per round | 3×, 3×, 3×, 2×, 1.75×, 1.5× |
| Common shares before seed | 10,000,000 |
| % of companies that fail after each round | 0%, 45%, 35%, 20%, 10%, 5%, 0%, 0% |
| % of companies that exit after each round | 0%, 5%, 10%, 25%, 40%, 45%, 50%, 100% |
| Exit value as a multiple of the last post-money, per round | 1.5, 1.5, 1.5, 0.85, 0.75, 1.15, 1.25 |

## Full model: calculations

Per round:
- Convertibles converting: pre-money SAFEs and notes convert at the lowest of the round price, cap ÷ pre-money capitalization, and round price × (1 − discount). Post-money SAFEs convert to an ownership of amount ÷ cap. Assume investor-friendly conversion and say so in the notes column.
- Other investors' new money = total round size − the investor's new money.
- Post-money = pre-money + total round size. % sold = round size ÷ post-money.
- Price per share = (pre-money − post-money × option pool %) ÷ fully diluted shares before the round plus converting shares. This puts the new pool in the pre-money, and it's closed form, so don't use a circular reference or iterative calculation.
- New option shares = post-money fully diluted shares × pool % less the pool already available.
- Shares issued to the investor and to everyone else, blended price including convertibles, and ownership % for the investor, other preferred and all preferred.
- A running pro forma cap table: common, investor preferred, other preferred, options available, new options, fully diluted total.
- Pro rata follow-on: the investor's new money at a round = their ownership after the prior round × that round's size.

Graduation:
- % that graduate = 1 − % fail − % exit.
- Probability of reaching each round = the product of the graduation rates before it.
- Probability of failing and of exiting after each round = probability of reaching it × that round's rate. These two rows each sum across rounds, and together they sum to 100%.

Waterfall, for an exit after each round:
- Exit value = multiple × that round's post-money (overridable with a dollar amount).
- Total liquidation preferences = the sum of preferred money raised to that point.
- Assume 1× non-participating preferred, most recent round most senior, common and options pari passu. Each class takes its preference or converts to common, whichever pays more; resolve the decisions in seniority order without circular references.
- Proceeds to each class, proceeds per share, and a check that proceeds sum to the exit value.

Investor returns:
- Proceeds to the investor if the company exits after each round, and the investor's total invested to that point.
- Gross multiple if the exit happens after each round.
- Expected proceeds = the sum of proceeds × probability of exiting after each round. Expected value per dollar invested is the headline.
- A grid of expected value by entry round: if I invest first at round X and hold to exit, what's the expected multiple?

## Simple Venture Valuation

Inputs: liquidation preferences already ahead of this round ($1,000,000); the investor's check and date ($500,000, four years ago); other investors' money in the round ($0); pre-money ($6,000,000); the investor's follow-on money and date ($0, eighteen months ago); other investors' later money ($3,000,000); additional ownership the investor buys later (0%); dilution from later rounds by others (30%); dilution from later option pools (20%).

Calculations:
- Post-money and the investor's ownership after the round.
- Ownership after all later rounds = additional ownership bought + (1 − dilution from others) × ownership after the round × (1 − dilution from pools). Note that this is a deliberate shortcut instead of modeling each later round.
- Five exit values in columns, built at the preference breakpoints (later money only, plus this round, plus earlier preferences), then 3× and 9× the third, each overridable.
- Per exit value: the investor's proceeds from preferences on their follow-on and on this round (when the exit is below the preference stack), from distributions to common (exit less all preferences, times ownership), the total, and the gross multiple.
- A probability for each exit value (the last one = 1 − the others), expected proceeds, expected gross multiple, and expected gross IRR with XIRR on the investment dates and an exit date input.

## Key Reports

Charts: the probability of failing or exiting after each round; the investor's ownership by round; gross multiple by exit round; expected value by entry round.

## Model checks

TRUE or FALSE: fail plus exit probabilities sum to 100%; fully diluted ownership sums to 100% after every round; waterfall proceeds equal the exit value at every round; the simple sheet's probabilities sum to 100%.

## How the workbook should look and behave

These are my house rules for spreadsheets. Follow all of them.

- Use Arial 12 everywhere, including the workbook's default style. Never Calibri.
- Inputs are blue text (#0000FF) on a light grey fill (#F2F2F2), so they read like form fields. Calculations are black text with no fill. Never use grey text anywhere.
- Every sheet leaves column A blank and narrow. The model starts in column B.
- Column B holds row labels. Column C is a narrow Notes column, about half the width of the label column, holding a short note on what the row is or where it comes from. Let notes clip rather than wrap. Values, or the first period of a timeline, start after the notes column.
- No cell comments. Notes go in the notes column.
- Turn gridlines off on every sheet. Freeze panes on the header rows only, never on columns.
- No borders at all, not even header underlines or subtotal rules. Blank rows and bold text carry the structure.
- Every calculated number is a live formula that traces back to an input. Never type a number into a calculation cell, and never mix typed values and formulas in the same row.
- Keep the number of sheets low. Sheets that share a timeline use the same columns, so a given column is the same month on every sheet.
- Format currency with thousands separators and no decimals, percentages with one decimal place, and dates as "mmm yyyy".
- Name rows in plain words a founder or investor would use, with units in the label where it helps ("Churn per contract cycle, %").

## When you're done

- Recalculate and confirm there are no errors (#REF!, #DIV/0!, #VALUE!, #N/A) and no circular references unless I asked for one.
- Show me the results of the model checks and the headline outputs.
- List every assumption you made that I didn't give you, and the three inputs I should change first.
- If you can't produce an .xlsx file, give me each sheet as a table with the exact label, input value or formula in every cell, so I can rebuild it in Excel or Google Sheets without guessing.
