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

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
Variables
2
CustomersOct'16Nov'16Dec'16Jan'17Feb'17Mar'17Apr'17May'17Jun'17Jul'17Aug'17Sep'17
3
1Average Revenue Per User (per Month)$197.00Low - No of Customers at Month End222223333333
4
2Starting Number of Customers20Med - No of Customers at Month End444444444444
5
3Monthly Customer Growth Rate10%High - No of Customers at Month End000000000000
6
4Churn per Month5%
7
5LTV/CAC ratio5.25Low - No paying annual upfront000000000000
8
6% of customers paying annual upfront0%Med - No paying annual upfront000000000000
9
7Number of Months Paid UpfrontHigh - No paying annual upfront000000000000
10
Calculated
11
Lifetime value (LTV)$3,940.00Low - Net monthly payers222223333333
12
Customer Acquisition Cost (CAC)$750.00Med - Net monthly payers444444444444
13
High - Net monthly payers000000000000
14
Note:
15
Play with the number in rows 1-7 to seeMoneyJanFebMarAprMayJunJulAugSepOctNovDecTotal
16
the effect of different variables on the Tiles
17
performance of SMB SaaS. Take care ofMRR$394.00$413.70$434.39$456.10$478.91$502.85$528.00$554.40$582.12$611.22$641.78$673.87$6,271.35
18
perverse effects and don't take any of Cash Inflows$394.00$413.70$434.39$456.10$478.91$502.85$528.00$554.40$582.12$611.22$641.78$673.87$6,271.35
19
the figures too seriously. This is veryCAC Outflows$1,500.00$150.00$157.50$165.38$173.64$182.33$191.44$201.01$211.07$221.62$232.70$244.33$3,631.02
20
rough.Free cash fow (FCF)-$1,106.00$263.70$276.89$290.73$305.27$320.53$336.56$353.38$371.05$389.61$409.09$429.54$2,640.33
21
Paints
22
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
23
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
24
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
25
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
26
Laminates
27
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
28
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
29
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
30
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
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...
Main menu