ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Fast Forward - Accelerating B2B Sales for Startups
2
3
0. Things to do first
4
1 Have a look at the underlying chapter for contextfastforwardbook.com
5
2 Make a copy to edit this Google sheet
6
3 Fill in your own assumptions/data in the amber cells
7
4 Check results below
8
Go sell!
9
Matthias Hilpert
10
11
1 Prospect2 Lead3 Qualified Lead4 Opportunity5 Customer6 Customer upsell
12
InputIdeal customer profiles
Segmentation criteria
Name, Job title, Email, Phone number, LinkedIn profileInterestBudget, decision makerProposalContract signed
13
ActivityCompany lists, Deskresearch, EventsOutbound Email, Call, LinkedIn message
Inbound Webform, Calls, Emails, Business cards
Emails, CallsDemo & PresentationPilot/Trial & NegotiationUpsell negotiation
14
OutputName, Job title, Email, Phone number, LinkedIn profileInterestBudget, decision makerDecision process & timing, ProposalContract signedUpsell signed
15
Entry pointsfor Outbound listsfor Inbound requestsfor RFPs & Tenders
16
17
1. Activity for one won customerminutes / activityTotal
18
Research to understand prospect1011
19
Emails/LinkedIn messages to contacts within prospect13
20
Tried calls to contacts132
21
Calls to introduce & schedule 1022
22
Video calls to present company & solution60222
23
On-site Meetings to present solution24011
24
Total minutes required103622120360360908
25
26
2. Funnel to reach one customerTotal
27
Input contacts20016016521
28
Conversion rate80.00%10.00%30.00%40.00%50.00%100.00%
29
Progressing Leads/Opportunities160165211
30
Parked contacts1441131
31
Total minutes required20005760352576691.2345.6
32
FTEs (Full Time Equivalents) required 0.0
33
34
3. Cost calculationTotal
35
SDR/AE on target earnings per annum (basic + commission) $ 50,000.00
36
$ 868 $ 2,500 $ 153 $ 250 $ 300 $ 150 $ 4,221
37
21%59%4%6%7%4%100.00%
38
cost / min $ 0.43
39
cost / hour $ 26.04
40
cost / day $ 208.33
41
42
4. Payback calculation
43
CAC (Customer Acquisition Cost) - direct sales only $ 4,221
44
Committed contract time in months12
minimum 12, ideally 24 or 26 months
45
Desired payback time in months4
minimum 3/4 of committed contract time, ideally 1/4
46
Minimum required ARR (Annual Recurring Revenue) $ 12,662.50
47
CLV (Customer Lifetime Value) $ 12,662.50
48
CLV / CAC3
49
50
5. Results
51
Total cost to acquire one customer $ 4,221
marketing, overhead, tools etc. should be added
52
Total time to acquire one customer in h15
15h represents a 10-100K ARPA product that is familiar to the buyer organisation, has a budget allocated and there is no formal RFP process
53
Total FTEs to acquire one customer per month0.0
54
Minimum required ARR $ 12,662.50
55
CLV customer lifetime value $ 12,662.50
56
CLV / CAC3minimum above 3
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