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
EntrepreneurBible Editorial
Published 3w ago 1,422
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.

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