Posts Tagged ‘cap table’

Model Cap Tables With VCHub

A few days ago I answered a question on AsktheVC about modeling cap tables. After a quick email conversation with Jeff Boardman (founder of LearnVC), I realize I had left his product off the list.

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:

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.

Spreadsheets To Model Cap Tables

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.

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.