Shopify Profit/Breakeven Calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1	Shopify Store Break-Even Metrics Calculator
2	Fees & Overhead			COGS & Price Input		Break Even Points						Metrics Input					Output
3	Shopify Transaction Fees+Per Charge (2.9%)+($0.30)	Shopify Platform + Apps ($29.00 USD)	Hosting + Domain ($5.95 + $1.33 USD)	COGS + S	Sales Price at 3x	Basic Break-Even CPP	Basic Break-Even ROAS	Break-Even CPATC	Break-Even Cost Per IC	True Break-Even CPP	True Break-Even ROAS	Current CPP	Target CPP	CPM	CPC	CTR	Kill or Duplicate
4	$0.65	$14.00	$5.00	$12.00	$39.00	$27.00	1.44	$3.38	$4.41	$7.35	5.30	$6.00	$7.35	<$15	<$1	>2%	Duplicate
5
6																		Shopify Holds, Orders, & Facebook Ad Spend Budgeting Calculator
7			Shopify Store FB Target & Breakeven Metrics															INPUTS (Adjustable)			OUTPUTS				Actual Campaign Costs		PROFIT	PROFIT MARGIN	IMPORTED FROM "SHOPIFY PLATFORM" CALCULATOR
8			Shopify:	Target*	Breakeven					Actual COGS (COGs + Ship + Fees + Overhead)								Suggested Adspend Increase	Hold % *	Target CPP* - You can also input the CPP of the campaign you're scaling to receive outputs based on current proven CPP	Total Estimated Revenue Based on Suggested Adspend Increase	# Of Projected Product Orders Resulting From Increase	Total Estimated Amount of Revenue Shopify Will Put On Hold	Total COGs + Shipping + Fees Resulting From Increase In Adspend + Overhead	Actual Cost Of Campaign With NO Holds (Adspend + Projected Total COGS)	Actual Cost Of Campaign With Holds (Adspend + Projected Total COGS + Holds)	Actual Profit Collected 90 Days After Hold or If There Is No Hold*	Revenued / Profit = Profit Margin	My Selling Price For Product On Shopify*	Cost Of Goods + Shipping*
9			CPP	-$4.35	$7.35					$31.65								$1,000.00	25.00%	$8.20	$4,756.10	122	$1,189.02	$3,859.51	$4,859.51	$6,048.54	-$103.41	-2.17%	$39.00	$31.65
10			CPATC*	-1.30	$3.38														* Default at 25% for estimation or use actual hold rate if there is one on your account. Holds are typically between 10%-30% of total revenue and are held for 90 days.	* Creates Projections From A Goal CPP - Best For Estimating when you have no current CPP data or you aim to decrease your current CPP and you want to know what the effect of that decrease in CPP is going to have on your budget & available funds, and whether you can handle such an increase in sales volume based on your current available funds.	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE * If $ amount is positive it is a profit, if it is negative then it is a loss.	DON'T TOUCH FORMULA ABOVE	DON'T TOUCH FORMULA ABOVE * Updates based on G5 in "Shopify Platform" table	DON'T TOUCH FORMULA ABOVE * Updates COGs + Shipping based on F5 in "Shopify Platform" table
11			ROAS	-8.97	5.30
12			*CPATC calculated with assumed 30% conversion between ATC and PUR	*Target is 30% for desired profit margin
13
14
15
16
17
18
19
20
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