Sortia ← All templates
Finance

After this round, what do you actually walk away with?

The cap table is deterministic — the exit is not. This template runs the exit value as a range through a 1× liquidation waterfall, so you see the distribution of your real take-home, not a single optimistic headline.

Get this in Google Sheets →

The model

A simple 1× non-participating preferred waterfall. At a small exit the investor takes its preference; at a big exit it converts to its ownership share. Exit value is the uncertainty.

Founder shares8,000,000
Investor shares (round)2,000,000
Founder ownership80%
Investment (1× pref)$2,000,000
Exit value$10M – $50M – $200M (uncertain)
Founder payout→ simulated

What Sortia tells you

Founder take-home across the exit range:

P5$23.6M
Median$64.5M
P95$129.8M
Mean$69M
P5 · $23.6Mmedian · $64.5MP95 · $129.8M

Your payout spans $23.6M to $129.8M depending almost entirely on where the exit lands. Seeing the full distribution — instead of a single "if we exit at $50M" line — is what lets you weigh this round against the odds honestly.

Try it in your own sheet

  1. Open Sortia in Google Sheets and choose Start from a template.
  2. Pick Funding Round Dilution & Exit Waterfall — the model loads with the inputs filled in.
  3. Change the assumptions to fit your situation and press Run.
Get Sortia for Google Sheets →