| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | Hard coded data | |||||||||
3 | I) Cap table | |||||||||
4 | ||||||||||
5 | Post-money valuation (Seed) | £ 10,000,000 | ||||||||
6 | ||||||||||
7 | # Shares | % ownership | ||||||||
8 | Founders | 15,000 | 68% | |||||||
9 | ESOP | 2,300 | 10% | |||||||
10 | Investors | 4,700 | 21% | |||||||
11 | Total | 22,000 | 100% | |||||||
12 | ||||||||||
13 | II) Compensation framework | Sources | ||||||||
14 | ||||||||||
15 | Step 1 | Company valuation | ||||||||
16 | £ 10,000,000 | |||||||||
17 | ||||||||||
18 | Step 2 | Define salary multiple | ||||||||
19 | ||||||||||
20 | Range | Lowest | Highest | Source: Balderton | ||||||
21 | Senior team (C-Level - people who report to the CEO) | 👉 | 0.7X | 2X | ||||||
22 | Director or Junior VP | 0.5X | 1.0X | |||||||
23 | Key hires (Designers, Data Scientists, Sales people - hard to hire and hard to retain) | 0.3X | 0.7X | |||||||
24 | Other | 0.0X | 0.2X | |||||||
25 | ||||||||||
26 | Step 3 | Determine market comp salary (Note: this is NOT what you are going to pay the new CMO) | ||||||||
27 | Annual salary CMO | £ 102,000 | Benchmark: CMO salaries in London | |||||||
28 | Discretionary Discount | 0% | ||||||||
29 | Salary | £ 102,000 | ||||||||
30 | ||||||||||
31 | ||||||||||
32 | Step 4 | Determine the pound value that you are going to give in equity (multiple of annual salary) | ||||||||
33 | ||||||||||
34 | Option 1 (0.7X) | £ 71,400 | ||||||||
35 | 👉 | Option 2 (1X) | £ 102,000 | |||||||
36 | Option 3 (2X) | £ 204,000 | ||||||||
37 | ||||||||||
38 | Step 5 | # of outstanding shares | 22,000 | |||||||
39 | ||||||||||
40 | Step 6 | Price per share value | £ 455 | |||||||
41 | ||||||||||
42 | Step 7 | # of shares that should be given to your new CMO | 224 | |||||||
43 | % ownership for a new CMO | 1.02% | ||||||||
44 |