4.106 Creating Cap Tables

In this class, I show you how to create a capitalization table from scratch through a Series B financing using Excel and showing you all the formulas. How do you set up an initial capitalization at formation of the company with founders? How do you compute share price, purchased shares, and ownership from pre-money valuation and invested capital? How does one compute the option pool? How do convertible notes become equity? What are some examples of recapitalizations and cram downs and other issues that frequently come up in financings?

Founders Wanted.

Join the best startup learning community now as a founding member. Learn More:


Sign me up for a
Free class and Newsletter!

X