UpCounting | Template | Creative Contribution Margin Calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	UpCounting
2
3	Click These Words for Instructions
4
5
6
7
8
9
10
11
12
13
14	Variable Expenses (%)
15	Cost of Goods Sold	30.0%	⬅️ Set to your cost per product as a % of the average net selling price (meaning net of discounts)
16	Shipping	5.0%	⬅️ Set to your average shipping cost as a % of net revenue
17	Transaction Fees	2.2%	⬅️ Set to your average transaction fees as a % of net revenue (include Shopify and any other payment processors)
18	Other 1	1.0%	⬅️ Add anything else that might be relevant to your brand
19	Other 2	0.0%	⬅️ Add anything else that might be relevant to your brand
20	Other 3	0.0%	⬅️ Add anything else that might be relevant to your brand
21	Total Variable Expenses	38.2%	🛑 No touchy
22
23
24	Contribution Margin per Order		AOV
25			45	55	65	75	85	95	105	115	125	135	⬅️ You can set these to whatever increment you please
26	CAC	60	-32	-26	-20	-14	-7	-1	5	11	17	23
27		56	-28	-22	-16	-10	-3	3	9	15	21	27
28		52	-24	-18	-12	-6	1	7	13	19	25	31
29		48	-20	-14	-8	-2	5	11	17	23	29	35
30		44	-16	-10	-4	2	9	15	21	27	33	39
31		40	-12	-6	0	6	13	19	25	31	37	43
32		36	-8	-2	4	10	17	23	29	35	41	47
33		32	-4	2	8	14	21	27	33	39	45	51
34		28	0	6	12	18	25	31	37	43	49	55
35		24	4	10	16	22	29	35	41	47	53	59
36		20	8	14	20	26	33	39	45	51	57	63
37		16	12	18	24	30	37	43	49	55	61	67
38		⬆️ You can set these to whatever increment you please
39
40
41
42	Fixed Expenses ($)
43	Personnel	32,000	⬅️ Rough fixed monthly cost of payroll + contractors (and any money you need to pay yourself)
44	Software	6,500	⬅️ Roughly monthly software costs (some are variable so you can include those in "Others" above or keep here for simplicity)
45	Logistics	11,000	⬅️ For rough average monthly 3PL, shipping, warehousing costs
46	Other 1	25,000	⬅️ Add anything else that might be relevant to your brand
47	Other 2	0	⬅️ Add anything else that might be relevant to your brand
48	Other 3	0	⬅️ Add anything else that might be relevant to your brand
49	Total Fixed Expenses	74,500	🛑 No touchy
50
51
52
53
54	Profit	⬅️ To switch below table from Contribution Margin to Net Profit
55
56			ROAS
57			0.50	1.00	1.50	2.00	2.50	3.00	3.50	4.00	4.50	5.00	⬅️ You can set these to whatever increment you please
58	Ad Spend	25,000	-91,775	-84,050	-76,325	-68,600	-60,875	-53,150	-45,425	-37,700	-29,975	-22,250
59		50,000	-109,050	-93,600	-78,150	-62,700	-47,250	-31,800	-16,350	-900	14,550	30,000
60		75,000	-126,325	-103,150	-79,975	-56,800	-33,625	-10,450	12,725	35,900	59,075	82,250
61		100,000	-143,600	-112,700	-81,800	-50,900	-20,000	10,900	41,800	72,700	103,600	134,500
62		125,000	-160,875	-122,250	-83,625	-45,000	-6,375	32,250	70,875	109,500	148,125	186,750
63		150,000	-178,150	-131,800	-85,450	-39,100	7,250	53,600	99,950	146,300	192,650	239,000
64		175,000	-195,425	-141,350	-87,275	-33,200	20,875	74,950	129,025	183,100	237,175	291,250
65		200,000	-212,700	-150,900	-89,100	-27,300	34,500	96,300	158,100	219,900	281,700	343,500
66		225,000	-229,975	-160,450	-90,925	-21,400	48,125	117,650	187,175	256,700	326,225	395,750
67		250,000	-247,250	-170,000	-92,750	-15,500	61,750	139,000	216,250	293,500	370,750	448,000
68		275,000	-264,525	-179,550	-94,575	-9,600	75,375	160,350	245,325	330,300	415,275	500,250
69		300,000	-281,800	-189,100	-96,400	-3,700	89,000	181,700	274,400	367,100	459,800	552,500
70		⬆️ You can set these to whatever increment you please
71
72
73
74
75
76	Creative Assumptions	Baseline	Scenario 1	Scenario 2	Scenario 3
77	Fixed Cost 1	0	8,000	5,000	1,500
78	Fixed Cost 2	0	150	150	150
79	Fixed Cost 3	0	600	600	600
80	Variable Cost 1	0.0%	1.0%	1.0%	1.0%
81	Variable Cost 2	0.0%	1.0%	1.0%	4.0%
82	Variable Cost 3	0.0%	5.0%	5.0%	5.0%
83
84	Performance Assumptions	Baseline	Scenario 1	Scenario 2	Scenario 3
85	AOV	90.00	90.00	100.00	90.00
86	CAC	30.00	30.00	30.00	30.00
87	CAC Scaling per Increment	1.25	1.25	1.25	1.00
88
89
90	Ad Spend	Baseline	Scenario 1	Scenario 2	Scenario 3
91	0	0	-8,750	-5,750	-2,250
92	50,000	38,992	26,742	39,630	32,460
93	100,000	71,138	55,388	77,404	61,563
94	150,000	97,200	77,950	108,417	85,568
95	200,000	117,829	95,079	133,393	104,926
96	250,000	133,586	107,336	152,957	120,036
97	300,000	144,960	115,210	167,650	131,250
98	350,000	152,374	119,124	177,944	138,885
99	400,000	156,200	119,450	184,250	143,224
100	450,000	156,764	116,514	186,932	144,519