unit economics calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
SMB SaaS - Unit Economics Calaculator
5
Last Updated:
5/13/18 12:37
6
7
Variables
8
CustomersOct'16Nov'16Dec'16Jan'17Feb'17Mar'17Apr'17May'17Jun'17Jul'17Aug'17Sep'17
9
1
Average Revenue Per User (ARPU per Month)
$10.00Low - No of Customers at Month End704934241712864321
10
2Starting Number of Customers100Med - No of Customers at Month End000000000000
11
3Monthly Customer Growth Rate50%High - No of Customers at Month End000000000000
12
4Churn per Month80%
13
5LTV/CAC ratioLow - No paying annual upfront000000000000
14
6% of customers paying annual upfrontMed - No paying annual upfront000000000000
15
7Number of Months Paid UpfrontHigh - No paying annual upfront000000000000
16
Calculated
17
Lifetime value (LTV)Low - Net monthly payers704934241712864321
18
Customer Acquisition Cost (CAC)Med - Net monthly payers000000000000
19
High - Net monthly payers000000000000
20
Note:
21
Play with the number in rows 1-7 to seeMoneyJanFebMarAprMayJunJulAugSepOctNovDecTotal
22
the effect of different variables on the Tiles
23
performance of SMB SaaS. Take care ofMRR$700.00$490.00$343.00$240.10$168.07$117.65$82.35$57.65$40.35$28.25$19.77$13.84$2,301.04
24
perverse effects and don't take any of Cash Inflows$700.00$490.00$343.00$240.10$168.07$117.65$82.35$57.65$40.35$28.25$19.77$13.84$2,301.04
25
the figures too seriously. This is veryCAC Outflows$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
26
rough.Free cash fow (FCF)$700.00$490.00$343.00$240.10$168.07$117.65$82.35$57.65$40.35$28.25$19.77$13.84$2,301.04
27
Paints
28
Find a detailed artcile on the mechanicsMRR$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
29
of SaaS SMB unit economics at:Cash Inflows$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
30
https://www.sunstonecommunication.com/blog
CAC Outflows$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
31
Free cash fow (FCF)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
32
Laminates
33
MRR$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
34
Cash Inflows$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
35
CAC Outflows$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
36
Free cash fow (FCF)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
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...
 
 
 
Data and Assumptions
 
 
Main menu