A | B | C | D | E | |
---|---|---|---|---|---|
1 | ๐ | INPUT CELL | ๐ | ||
2 | Company headcount | 200 | |||
3 | Average tenure | 40 | Months | ||
4 | Monthly payroll overheads | 18% | 401k/Pension etc | ||
5 | Monthly payroll overheads | $900 | |||
6 | HR Budget | $85,825 | Monthly | ||
7 | Cost per hire | $4,000 | Once off | ||
8 | Average salary | $5,000 | Monthly | ||
9 | MRR | $1,620,000 | Monthly Recurring Revenue | ||
10 | MRR / Head | $8,100 | Monthly revenue per head | ||
11 | OUTPUT | ||||
12 | ELTV | $324,000 | Lifetime Value | ||
13 | E(C)AC | $257,165 | Aquisition (and retention) Cost | ||
14 | Payback | 126% | |||
15 | |||||
16 | Like this template? | Check out my Medium | |||
17 | Sign up for my 6-week Maven Course | Built for People | |||
18 | Read my book! | People Ops as a Product |