Capitalization Table - Series A Only
READ NOTES TO THE RIGHT BEFORE EDITING THIS SHEET
|Notes: This Capitalization Table is structured for a company that raises a single round of financing. If you are interested in editing and enhancing this Google Sheet, please select "Make a Copy" under the "File" menu.|
Instructions: By default, this spreadsheet includes 2 founders, 4 groups of employee/advisor/directors and 2 outside investors. If you have more entities in each of these categories, you should insert new rows in the appropriate location. For example, if you have 3 founders, select Row 18 and insert a new row beneath "Founder #2". You can then add in your third founder. Cells that are filled in with Yellow are the only cells into which you should enter data for your specific company. Any cell that does not have a Yellow background should not be edited. The data in these cells is computed by a formula.
Shareholders are the individuals, entities or groups of people who own equity in the company. If you choose to, you should replace the default entries with the names of the shareholders in the company.
Common Shares are typically held by founders and employees of the company. Occasionally, early investors will purchase common shares. Go ahead and enter the correct number of Common shares for each shareholder. Make sure you only include the common shares held by the shareholder in this column. Remember, it's not unusual for a founder to own common shares along with options and preferred shares in the company.
Options are a form of compensation given to employees, directors and advisors. Most options vest over a 3 to 4 year time period. This Cap Table assumes that once options are granted they are part of the Fully Diluted Share count. The spreadsheet is not set up to track vesting of options over time. For simplicity sake, this Cap Table combines groups of individuals (e.g. management employees, board of directors) into single rows on the spreadsheet. For a more complete Cap Table, you should separate these groups and have a separate row in the table for each member of the groups. Enter the correct number of options issued to each group and make sure you include the number of unissued options that remain in the current Option Pool.
Series A Preferred Shares are issued as part of an equity investment in the company. The majority of these share are issued to outside investors such as angels and VCs. However, it is not unusual for insiders such as a founder or a board member to also purchase shares in these equity rounds. For the preferred share holdings, do not enter the number of shares. You should enter the amount invested by each individual or entity in the Series A round. Then, enter the Series A Price / Share that is located in row 10. The number of shares issued in the Series A round will be automatically calculated for you. There are two other items you should add for the Series A Preferred stock. First, enter the Liquidation Preference in row 11, and second, indicate whether the Series A is Participating Preferred ("Yes") or Non-Participating Preferred ("No") in row 12. The preference and participation are used in the calcuation of payments to investors upon a liquidation event for the company and will be used in the Waterfall Table under the Waterfall Analysis Sheet.
|Valuations, Investments and Share Price|
|Total Invested in Round||$1,250,000|
|Price / Share||$1.25|
|Shareholders||Common Shares||Options||Series A Preferred Shares||Series A Investment||Total Share Ownership||Percentage of Fully Diluted Shares|
|Shares and Options owned by the Founders of the Company|
|Shares and Options owned by Employees, Advisors & Directors|
|Board of Directors||30,000||120,000||$150,000||150,000||4.2%|
|Remaining Option Pool||200,000||0||200,000||5.6%|
|Shares Acquired by Investors|
Share Count by Security Type
|Fully Diluted Shares||3,540,000|
|Option Pool Shares||340,000|
|If you like this Cap Table Guide, please share the following link: http://bit.ly/Series_A_Cap_Table_and_Waterfall|