Sales and Marketing Investment Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
AssumptionsValueNotes
2
Payback Period, months18Slide 25, PacCrest Survey
3
B/S&M Spend Ratio1.5
4
Sales Share65%Slide 24, PacCrest Survey
5
Revenue/Bookings Ratio0.3Revenue Estimate Sheet
6
7
8
Year 1Year 2Year 3Year 4Year 5Notes
9
Total Bookings, $M1391836
10
Share from Existing Customers9%14%16%22%27%Slide 26
11
New Customer Bookings, $M0.92.67.614.026.3
12
S&M Spend, $M1.43.911.321.139.4
13
14
Sales Spend0.92.57.413.725.6
15
Marketing Spend0.51.44.07.413.8
16
17
Revenue0.41.95.614.328.5
18
Sales Spend % of Revenue250%134%131%96%90%
19
Marketing Spend % of Revenue
134%72%71%52%48%
20
S&M % of Revenue384%206%202%148%138%
21
22
23
24
25
26
27
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
Loading...
 
 
 
Summary
Revenue Estimate