Back to Finance & Funding
Finance & Funding TemplateAdvanced

Cap Table & Dilution Modeller

A spreadsheet that shows you exactly how dilution stacks across five rounds, including option pool refreshes.

EE
Published 3w agoUpdated 12h ago 1,420
Open file

Founders get diluted not by one round but by the cumulative effect of pre-money assumptions, option-pool refreshes, and SAFE conversion math. This sheet makes that math legible.

Inputs

  • Starting cap (you + co-founders).
  • Per-round: amount raised, pre-money, option pool target.
  • SAFE notes already issued (with caps).

Outputs

  • Post-money cap table after each round.
  • Founder ownership at each step.
  • Effective dilution from option pool refreshes.

Two lessons every founder learns the hard way

Option pool shuffle

Investors usually require a post-investment option pool of N%. That pool comes out of the pre-money, not the post — meaning it dilutes founders, not new investors. A 10% pool refresh on a 20% round costs founders ~12.5% effective ownership.

SAFE stacking

Three uncapped SAFEs at $5M, $8M, and $12M look fine on a spreadsheet. They convert messy. Always model the conversion before signing the next one.

Weekly digest

Get new resources like this, weekly.

One email a week: new hubs, new tools, and the editorial pieces worth reading. One click to unsubscribe.

Discussion

0 comments

Sign in to join the discussion.

Be the first to comment. The Bible community reads every thread.

Keep reading

More from Finance & Funding