| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Target Customer Acquisition Cost (CAC): | Minimum | Target | January | February | March | April | May | June | |||||||
2 | Total cost to acquire all customers | $160 | $16,383 | $8,500 | $12,500 | $15,000 | $14,500 | $13,000 | $17,500 | |||||||
3 | New Customers | 1 | 40 | 75 | 100 | 125 | 115 | 112 | 130 | |||||||
4 | New Trials | 5 | 500 | 300 | 400 | 500 | 450 | 475 | 500 | |||||||
5 | Trial Conv. Rate | 20% | 8% | 25% | 25% | 25% | 26% | 24% | 26% | |||||||
6 | Cost Per Trial | $32 | $33 | $28 | $31 | $30 | $32 | $27 | $35 | |||||||
7 | Customer Acquisition Cost (CAC) | $160 | $410 | $113.33 | $125.00 | $120.00 | $126.09 | $116.07 | $134.62 | |||||||
8 | ||||||||||||||||
9 | ||||||||||||||||
10 | Target Lifetime Value (LTV): | Minimum | Target | January | February | March | April | May | June | |||||||
11 | Avg. Monthly Payment | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $99 | |||||||
12 | Gross Margin (GM%): | 98% | 95% | 98% | 98% | 98% | 98% | 98% | 98% | |||||||
13 | Churn Rate | 20.00% | 10.00% | 25% | 25% | 45% | 10% | 50.0% | 25.0% | |||||||
14 | Lifetime Value (LTV) | $485.10 | $940.50 | $388.08 | $388.08 | $215.60 | $1,021.26 | $194.04 | $388.08 | |||||||
15 | ||||||||||||||||
16 | LTV:CAC Ratio | 3.03 | 2.30 | 3.42 | 3.10 | 1.80 | 8.10 | 1.67 | 2.88 | |||||||
17 | Months to Recover CAC | 2 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
18 | ||||||||||||||||
19 | Team Cost | |||||||||||||||
20 | $6,000 | |||||||||||||||
21 | ||||||||||||||||
22 | Target Spend | Target Monthly Cost | Target Annual Cost | |||||||||||||
23 | $10,000 | $383 | $575 | |||||||||||||
24 | ||||||||||||||||
25 | ||||||||||||||||
26 | ||||||||||||||||
27 | ||||||||||||||||
28 | ||||||||||||||||
29 | ||||||||||||||||
30 | ||||||||||||||||
31 |