| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Across the past 3 months, what is your: | Editable Cell | Calculated Cell | ||||
2 | |||||||
3 | Average Order Value (AOV) | $87.00 | Total 90D Revenue / Total Orders | ||||
4 | Cost Of Goods (COGs) per above AOV | $32.00 | Total COGs (90D) / Total Sales (90D) | ||||
5 | Shipping & Handling (To Customer) Costs per AOV | $6.00 | Total S&H (90D) + Processing Fees (90D) + Refunds / Total Sales (90D) | ||||
6 | Landed Costs per AOV | $38.00 | |||||
7 | |||||||
8 | Calculated Gross Profit $ (per AOV) | $49.00 | CLICK File > Make a Copy | ||||
9 | Calculated Gross Margin % (per AOV) | 56% | |||||
10 | |||||||
11 | Calculated Gross Breakeven CPA | $49.00 | |||||
12 | Initial Calculated Gross Breakeven ROAS | 1.78 | |||||
13 | |||||||
14 | 3-month LTV | $174.00 | Total Sales (90D) / Total Unique Customers (90D) | ||||
15 | 3-month NC ROAS | 1.90 | Total New Customer Sales (90D) / Total Adspend | ||||
16 | 3-month monthly ad spend average | $240,000.00 | Total 90D Adspend / 3 | ||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | SCENARIO MODELING | ||||||
21 | Scenario 1 Current DATA | Scenario 2 | Scenario 3 | Scenario 4 | Scenario 5 | Scenario 6 Day One B/E | |
22 | NC ROAS | 1.90 | 1.90 | 3.50 | 1.75 | 1.00 | 1.78 |
23 | Ad Spend Assumption | $240,000 | $240,000 | $20,000 | $300,000 | $15,000 | $500,000 |
24 | Gross Margin % | 56% | 56% | 56% | 56% | 56% | 56% |
25 | Revenue | $456,000 | $456,000 | $70,000 | $525,000 | $15,000 | $887,755.10 |
26 | Total COGS + S&H | $199,172.41 | $199,172.41 | $30,574.71 | $229,310.34 | $6,551.72 | $387,755.10 |
27 | (Day One) Profit $ | $16,828 | $16,828 | $19,425 | -$4,310 | -$6,552 | $0.00 |
28 | (Day One) Profit % | 4% | 4% | 28% | -1% | -44% | 0% |
29 | AOV | $87 | $87 | $87 | $87 | $87 | $87 |
30 | NCPA | $45.79 | $45.79 | $24.86 | $49.71 | $87.00 | $49.00 |
31 | Customers Acquired | 5,241 | 5,241 | 805 | 6,034 | 172 | 10,204 |
32 | |||||||
33 | 3-month Customer Value | $174.00 | $174.00 | $174.00 | $174.00 | $174.00 | $174.00 |
34 | 3-month Customer Value Revenue | $912,000.00 | $912,000.00 | $140,000.00 | $1,050,000.00 | $30,000.00 | $1,775,510.20 |
35 | 3-month Customer Value Profit | $273,655.17 | $273,655.17 | $58,850.57 | $291,379.31 | $1,896.55 | $500,000.00 |
36 | |||||||
37 | |||||||
38 | Compound Profits modeled off scenario #1 | Total Profit MoM | Day One Profit | Retention | |||
39 | Month 1 | $16,827.59 | $16,828 | $0.00 | ** no rentention profits yet | ||
40 | Month 2 | $145,241.38 | $16,828 | $128,413.79 | ** retention profits from month 1 | ||
41 | Month 3 | $273,655.17 | $16,828 | $256,827.59 | ** retention profits from months 1 & 2 | ||
42 | Month 4 | $273,655.17 | $16,828 | $256,827.59 | |||
43 | Month 5 | $273,655.17 | $16,828 | $256,827.59 | |||
44 | Month 6 | $273,655.17 | $16,828 | $256,827.59 | |||