Cap Table Template
A capitalization table, or “cap table” for short, is a list of a company’s securities (common stock, preferred stock, convertible notes, SAFEs, options, warrants, etc.) and who owns those securities. Keeping this information organized and up-to-date is critical to making quick, well-informed decisions regarding fundraising, employee options, and acquisition offers.
This template will:
1. Help you build and interpret cap tables at different stages of funding
2. Illustrate how ownership changes with valuation in new investment rounds
3. Demonstrate how different funding methods like convertible notes and SAFEs impact a capital structure
4. Make diligence processes with investors more efficient
Our latest version includes several major updates – including more detailed instructions and support for:
Variations of pre- and post-money convertible notes and SAFEs
Investors holding multiple convertible securities with different timing or terms
Multiple options grants to the same individual
Shadow securities
Note: To handle circular references, this workbook requires Iterative Calculations to be enabled in Excel.
Navigate to File > Options > Formulas. Under Calculation Options, make sure the Iterative Calculations checkbox is selected.
If you have suggestions for improving the template, please contact us.
These materials and the information provided herein are (i) for informational and discussion purposes only and are not intended to be, and shall not be regarded or construed as, a recommendation for a transaction or investment or financial, tax, legal, or other advice of any kind, and (ii) subject to various disclaimers and limitations that are set forth in our Terms of Use. By accessing these materials and the information provided herein, you agree to our Terms of Use, including, without limitation, all of the disclaimers and limitations set forth therein.
Last updated: 03-30-2022