Goal-oriented Funnel ROI Calculator (Public)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVW
1
2
Goal-oriented Funnel ROI Calculator Copy this sheet or download it under File -> Copy/Download As
3
4
Worst CaseMedium CaseGood CaseBest Case
How To Use This Calculator:
5
Revenue Goal$25,000.00$25,000.00$25,000.00$25,000.00Revenue GoalType in how much you expect or want to earn
6
Costs$2,000.00$2,000.00$2,000.00$2,000.00CostsType in your salary, product costs,...
7
CLV$1,200.00$1,200.00$1,200.00$1,200.00CLVType in the revenue you expect from each single customer
8
# Customers Needed21212121# Customer NeededHow many customer you need to reach your revenue goal
9
Funnel Conversion Rate
0.80%1.00%2.00%2.50%Conversion RateType in the percentage of how many leads turn into paying customers
10
# Leads Needed262521001050840# Leads NeededHow many leads you need to get the required number of customers needed. This number depends on your conversion rate
11
Cost per Click$2.00$2.00$2.00$2.00Cost per ClickType in how much money you spend to send someone to your opt-in page
12
Opt-in Conversion Rate
23%25%30%40%Opt-in Conversion RateType in the percentage of how many people opt-in and become a lead
13
Lead CPA$8.70$8.00$6.67$5.00Estimated Lead CPAType in how much you pay for acquiring a lead
14
Max Lead CPA$9.52$11.90$23.81$29.76Max Lead CPAHow much you can spend to acquire a lead and still break-even
15
Ad Costs$22,826.09$16,800.00$7,000.00$4,200.00Ad Costs
How much you need to spend on advertising based on your estimated lead CPA
16
Profit / Loss$173.91$6,200.00$16,000.00$18,800.00Profit / LossYour bottom-line after all costs
17
Case Difference3465%158%18%Case DifferenceCompares the Profit / Loss from case to case
18
RevOAS1.11.53.66.0RevOASHow much revenue you generate per 1$ ad spend
19
ROAS0.00.42.34.5ROASHow much return you generate per 1$ ad spend
20
Customer CPA$1,086.96$800.00$333.33$200.00Customer CPAHow much you pay for acquiring a customer
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...
 
 
 
Fixed Revenue Goal
Contact
 
 
Main menu