Tag: cap table
Jeff has done a nice job building a site that both models a cap table and provides a lot of information to empower entrepreneurs both with educational resources and software tools. In addition to modeling a cap table and ownership of the company, Jeff’s software helps answer questions like “if I sell for $100M, how much money does everyone receive.”
In addition, he’s created a variety of interactive examples that help you understand things like:
- Anti Dilution – Broad-based Weighted Average
- Anti Dilution – Narrow-based Weighted Average
- Anti Dilution – Full Ratchet
The LearnVC site has a bunch of other interactive examples for some of the basics of venture financing including:
To see their product in action, check out their videos.
Question: One thing that I think would be incredibly helpful would be to have a spreadsheet showing how a cap sheet evolves under a set of financing rounds with the important variables parameterized so we can play with them.
Having spent the past 15 years trying to come up with the definitive spreadsheet model for all cases, we’ve given up. It’s really hard to create the general case and actually using it is very difficult. So we don’t have a generic one to offer.
However, there are plenty of resources for cap tables on the web. Here are some examples. Use at your own risk – we can’t guarantee the mathematical integrity of any of these.
- Venture Hacks: How To Make A Cap Table
- Mark Suster: Venture Capital Valuation Spreadsheet
- AskVenture.com: Sample Cap Table
- StartupNetwork: Capitalization Table
- ModelSheet: Capitalization Table
There are many others on the web – just search around for “cap table” or “capitalization table”. I expect your favorite lawyer has one also – if he doesn’t, or won’t share it with you, I encourage you to find a new favorite lawyer.