ABDEGHIJKLMNOPQRSTUVWXYZ
1
Hi! This spreadsheet can be used a couple of different ways. If you run a product based business and are considering a launch, just change the cells in Orange to your actual numbers. The hidden columns show the calculations for cells. If you know your LTV and CAC, enter them here to find out how you can change the other to increase your cashflow. Again, change the orange cells
2
3
4
ValueJuneJulyAugustSeptemberTotalsCan I Reorder?
5
Initial investment $ 6,000 Sales ramp 10%20%30%40%100%CAC ChangesLTV Changes
6
Total Pieces500New Customers50100150200500CACLTVCACLTV
7
COGS per piece $ 12 Inventory on hand4503502000LTV/CAC 3:1 $ 333 $ 1,000 LTV/CAC 3:1 $ 36 $ 108
8
Retail price $ 32 Fulfillment $ 300 $ 600 $ 900 $ 1,200 LTV/CAC 5:1 $ 200 $ 1,000 LTV/CAC 5:1 $ 36 $ 180
9
Fulfillment per item $ 6 Shipping $ 450 $ 900 $ 1,350 $ 1,800 LTV/CAC 50:1 $ 20 $ 1,000 LTV/CAC 50:1 $ 36 $ 1,800
10
Shipping per item $ 9 CAC Cost 3:1 $ 1,067 $ 2,133 $ 3,200 $ 4,267 $ 10,667
11
Profit per item $ 5 CAC Cost 5:1 $ 640 $ 1,280 $ 1,920 $ 2,560 $ 6,400
12
AOV $ 32 CAC Cost 50:1 $ 64 $ 128 $ 192 $ 256 $ 640 LTV $ 1,000
13
Frequency2CAC $ 36
14
Life Time Value64
15
Breakeven Units188Monthly Revenue $ 1,600 $ 3,200 $ 4,800 $ 6,400 $ -
16
Sold out Revenue$16,000
17
Customer acquisition Cost (CAC)Cashflow 3:1 $ (216.67) $ (650.00) $ (1,300.00) $ (2,166.67) $ (2,166.67) NO
18
LTV/CAC 3:1 $ 21.33 Cashflow 5:1 $ 210.00 $ 630.00 $ 1,260.00 $ 2,100.00 $ 2,100.00 NO
19
LTV/CAC 5:1 $ 12.80 Cashflow 50:1 $ 786.00 $ 2,358.00 $ 4,716.00 $ 7,860.00 $ 7,860.00 YES
20
LTV/CAC 50:1 $ 1.28
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