ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
3
4
5
6
Background And InputsNotes
7
Annual Quota Per Rep$600,000inputs in blue
8
Sales Rep Turnover40.0%
not factoring training costs of new hires
9
Average Tenure Length (years)2.5
feel free to copy and use in your own way!
10
Average Rep Quota Attainment (Year 1)40.0%
If you get value out of this make sure to add a rating of your sales org on repvue.com
11
Average Rep Quota Attainment (Year 2+)85.0%
12
Lifetime ARR Contribution Per Rep$1,005,000
13
LTV (Average Total Customer Relationship Tenure, in Years)
7
14
Revenue Contribution Per Rep$7,035,000
15
16
Open Seat Impact
17
Lost ARR Per Day, Per Rep (at 100%)$658
18
Lost Revenue Per Day a Rep is not Hired$4,603
19
Lost ARR Per Month, Per Rep$20,000
20
Lost Revenue Per Month a Rep is not Hired$140,000
21
22
Attrition Impact
23
Hiring Time for New Reps (Months)3
24
Existing Rep Annual Productivity (ARR, from Above Inputs)
$510,000
25
New Rep Productivity Expectation (ARR, from Above Inputs)
$180,000
26
ARR Impact of One Rep Attrition$330,000
27
Revenue Impact of One Rep Attrition (Productivity Only)$2,310,000
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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