ABCDEFGHIJKLMNOPQRSTUVWX
1
Editable Cells
2
Account Executive IAccount Executive IIAccount Executive III
3
Step 1Fixed Salary$50,000$55,000$60,000
4
Commissions$50,000$55,000$60,000
5
On-Target Earnings$100,000$110,000$120,000
6
7
Step 2Target ARR - New Booking$650,000$700,000$800,000
8
Ratio6.5 X6.4 X6.7 X
9
10
Calculated Base Commission Rate7.69%7.86%7.50%
11
12
Step 3Breakdown
13
1/ New Booking70%70%70%
14
2/ Multi-Year15%15%15%
15
3/ New Products15%15%15%
16
17
Breakdown in $
18
1/ New Booking$35,000$38,500$42,000
19
2/ Multi-Year$7,500$8,250$9,000
20
3/ New Products$7,500$8,250$9,000
21
22
Step 4Targets
23
1/ New Booking$650,000$700,000$800,000
24
2/ Multi-Year - % total30%30%30%
25
Multi-Year Booking$195,000$210,000$240,000
26
3/ New Products - % total10%10%10%
27
New Products Booking$65,000$70,000$80,000
28
29
Rate
30
1/ New Booking5.38%5.50%5.25%
31
2/ Multi-Year3.85%3.93%3.75%
32
3/ New Products11.54%11.79%11.25%
33
34
Rate - Rounded
35
1/ New Booking6%6%6%
36
2/ Multi-Year3.50%3.50%3.50%
37
3/ New Products10.00%10.00%10.00%
38
39
Calculated
40
1/ New Booking$39,000$42,000$48,000
41
2/ Multi-Year$6,825$7,350$8,400
42
3/ New Products$6,500$7,000$8,000
43
Total$52,325$56,350$64,400
44
45
Delta vs. Target$2,325$1,350$4,400
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