Capitalization Table - Series A Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
[Company Name]
Capitalization Table - Series A Only
2
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.
3
4
Valuations, Investments and Share Price
5
6
Series A
7
Pre-Money Valuation$3,175,000
8
Total Invested in Round$1,250,000
9
Post-Money Valuation$4,425,000
10
Price / Share$1.25
11
Liquidation Preference1
12
Participating PreferredYes
13
14
15
ShareholdersCommon SharesOptionsSeries A Preferred SharesSeries A InvestmentTotal Share OwnershipPercentage of Fully Diluted Shares
16
Shares and Options owned by the Founders of the Company
17
18
Founder One1,000,00040,000$50,0001,040,00029.4%
19
Founder Two900,0000900,00025.4%
20
21
Shares and Options owned by Employees, Advisors & Directors
22
23
Management100,00075,0000175,0004.9%
24
Other Employees25,000025,0000.7%
25
Board of Directors30,000120,000$150,000150,0004.2%
26
Advisors 10,000010,0000.3%
27
Remaining Option Pool200,0000200,0005.6%
28
29
Shares Acquired by Investors
30
31
Investor One200,000600,000$750,000800,00022.6%
32
Investor Two240,000$300,000240,0006.8%
33
34
Share Totals
35
36
Share Count by Security Type
2,200,000340,0001,000,000
37
38
Percent Ownership62%10%28%100.0%
39
40
Fully Diluted Shares3,540,000
41
Option Pool Shares340,000
42
Outstanding Shares3,340,000
43
44
45
46
If you like this Cap Table Guide, please share the following link: http://bit.ly/Series_A_Cap_Table_and_Waterfall
47
48
www.seraf-investor.com
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...