1
Latest non-trivial update: 2021-03-09
2
Unit Economics Template (locked)
3
4
This template is created with an e-commerce business in mind, but can be adapted to other business models.
5
6
7
See "CLTV" and "Cohorts" sheets for assumptions and calculation of Customer Lifetime Value, approximated as Customer 1-Year Value and Customer 5-Year Value.
8
See "CAC..." sheets for assumptions and calculation of Customer Acquisition Cost and how different channels build up to this value.
9
10
Explanations
11
Blue numbers are input fields - edit them!
12
Green numbers are read from other sheets.
13
Black numbers are calculated - don't touch!
14
Green cells are exported to other sheets
15
16
OVERVIEW
17
C1YV€ 8.01
Profit made during first 12 months since customer joined, excluding CAC.
18
CLTV€ 20.54
Profit made during first 5 years since customer joined, excluding CAC and assuming that things don't change during that time.
19
20
CAC_paid€ 3.46Average cost per bought customer.
21
CAC_organic€ 0.60
Average cost per customer who found the service organically.
22
CAC_total€ 2.87Average cost per new customer in total
23
24
C1YV / CAC2.79
The ratio between C1YV and CAC shows how solid your model is in an early business when it's hard to see more than 12 months ahead.
25
C1YV / CAC_paid2.31
If this number is >1, the customers you acquire through paid channels generate more profit for you during the first year than they cost to acquire.
26
27
CLTV / CAC7.15
The ratio between CLTV and CAC shows how solid your user acquisition model is long-term, given that you have accurate data. >3 is good.
28
CLTV / CAC_paid5.93
29
30
CAC break-even0.2
Months until the value of a customer is as high as the cost for acquiring an additional one. A must-know to understand cash flow.
31
CAC_paid break-even1.8
Months until the value of a customer is as high as the cost for acquiring an additional one through paid channels.
32
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
101
102
103
104
105
106
107
108