PEAR VC: Startup Equity Calculator for Early Hires

	B	C	D	E	F	H	I
1	Startup Equity Calculator for Early Hires (by Pear VC)
2
3	This calculator is most effective when paired with the following post: https://pear.vc/how-to-structure-startup-equity-for-early-hires/
4	How to use this sheet
5	1. Make a copy of the spreadsheet 2. Enter your inputs in the cells in blue in column C. 3. Enter your Hiring Plan (Columns E & F) starting at Row 30. Based on your inputs, the sheet calculates an equity grant that is appropriate for each incremental hire. These are noted in purple.
6	Note: We have pre-populated commonly used values. Feel free to adjust based on your personal preferences.
7
8	Step 1: Size your options pool
9	Options Pool Sizing	%	Definition
10	Size of Options Pool at Round Close	10.00%	The percentage (%) ownership that has been set aside for employees.
11	Buffer	25.00%	The buffer you want to create in your options pool
12	Equity Pool Minus Buffer	7.50%
13
14	Step 2: Define your baseline equity grant		(Baseline Equity Grant: The amount of equity you would give to a hire if they were a mid-level technical hire.)
15	Baseline Calculation	%	Definition
16	Discount Per Hire (%)	20.00%	The % by which, each equity grant will decrease for each subsequent hire
17	Min Baseline Equity	0.20%	The lowest grant you're comfortable issuing a mid-level technical hire (our baseline)
18
19	Step 3: Adjust your multipliers
20	Role & Level Multipliers	Multipliers	Definition
21	Technical Role	100%	-
22	Non-Technical Role	50%	The % of equity a non-technical hire receives relative to a technical hire
23
24	Senior Level	200%	The % of equity a senior hire receives relative to a mid-level hire
25	Mid Level	100%	-
26	Junior Level	20%	The % of equity a junior level hire receives relative to a mid-level hire
27
28	Step 4: Input your Hiring Plan
29	- Using the dropdown, populate your hiring plan by filling in Column E ("Role Type") and Column F ("Seniority")					For Reference Only
30	Hire # (in order of hiring)	Baseline Equity Grant	Equity Grant	Role Type	Role Seniority	Total Numbers of Hires	3
31	1	0.75%	1.50%	Technical	Senior Level	Number Technical Hires	2
32	2	0.60%	1.20%	Technical	Senior Level	Senior	2
33	3	0.48%	0.24%	Non-Technical	Mid Level	Mid	0
34	4	0.38%	0.00%	N/A	N/A	Junior	0
35	5	0.31%	0.00%	N/A	N/A	Number Non-Technical Hires	1
36	6	0.25%	0.00%	N/A	N/A	Senior	0
37	7	0.20%	0.00%	N/A	N/A	Mid	1
38	8	0.16%	0.00%	N/A	N/A	Junior	0
39	9	0.13%	0.00%	N/A	N/A
40	10	0.10%	0.00%	N/A	N/A
41	11	0.08%	0.00%	N/A	N/A
42	12	0.06%	0.00%	N/A	N/A
43	13	0.05%	0.00%	N/A	N/A
44	14	0.04%	0.00%	N/A	N/A
45	15	0.03%	0.00%	N/A	N/A
46	16	0.03%	0.00%	N/A	N/A
47	17	0.02%	0.00%	N/A	N/A
48	18	0.02%	0.00%	N/A	N/A
49	19	0.01%	0.00%	N/A	N/A
50	20	0.01%	0.00%	N/A	N/A
51	Total Equity Allocated to Employees		2.94%
52	Total Equity Remaining		4.56%
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