Cap Table Simulator

Yan-David Erlich
Mar 27, 2018 · 2 min read

Almost exactly two years ago, I wrote a post about helping friends navigate the eternal “what will this financing do to my ownership?” question. Two years later, it’s still fundraising season (yes, it’s still always fundraising season), and while the original spreadsheet was good, it’s time for something better.

An interactive simulator!

Image for post
Image for post
The cap table simulator in action

What does it do?

  • Add Common Stock or Option Grants
  • Add Convertible Notes or SAFEs
  • Add Equity rounds

You can layer as many rounds as you’d like, with one or multiple investors per round.

The simulator will take care of:

  • Automagically calculating everyone’s ownership stakes at every round
  • Understanding if your notes convert uncapped, at cap, or discount
  • If a down round is triggered (startups are hard & this happens sometimes), what the broad-based weighted-average anti-dilution protection looks like for all previous equity & noteholders

A note on sharing & privacy

That said, sometimes you want to compare notes with colleagues, advisors, board members, etc. If so, you can enable the sharing toggle, at which point your data has to be sent to a server (so it can then be shared).

Image for post
Image for post
Activating sharing

That said, when you’re done sharing, just flip the toggle off. Not only will all the data be deleted from the server, but it will also clear out the shared versions on everyone else’s machines.

Image for post
Image for post
Deactivating sharing & deleting the data from the server

Caveats

  1. This is software & software has bugs. Especially software written by someone who hasn’t been a full-time engineer for over a decade. If you find bugs, DM me on Twitter and I’ll do my best to squash them.

Enjoy!

Yanda’s Blog

Yan-David Erlich’s blog

Yan-David Erlich

Written by

Early stage investor. 4-time Founder/CEO: @ChoiceVendor @parsableHQ. Crypto, AI, Marketplaces. ♥️ gritty founders, deep convos, and pandas.

Yanda’s Blog

Yan-David Erlich’s blog

Yan-David Erlich

Written by

Early stage investor. 4-time Founder/CEO: @ChoiceVendor @parsableHQ. Crypto, AI, Marketplaces. ♥️ gritty founders, deep convos, and pandas.

Yanda’s Blog

Yan-David Erlich’s blog

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store