Shopify Analysis - Post - Google Sheets

	A	B	C	D	E	F	G	I	J	K	L	M	N	O
1	% of revenue in fees							Fees
2	Txns p.m. /AOV	$20.00	$30.00	$50.00	$80.00	$120.00	$180.00	Txns p.m. /AOV	$20.00	$30.00	$50.00	$80.00	$120.00	$180.00
3	100	19.7%	14.7%	10.7%	8.5%	7.3%	6.5%	100	393	441	537	681	873	1,161
4	120	18.6%	14.0%	10.3%	8.2%	7.1%	6.3%	120	446	503	619	791	1,022	1,367
5	140	17.8%	13.5%	10.0%	8.1%	7.0%	6.2%	140	499	566	700	902	1,171	1,574
6	160	17.2%	13.1%	9.8%	7.9%	6.9%	6.2%	160	551	628	782	1,012	1,319	1,780
7	180	16.8%	12.8%	9.6%	7.8%	6.8%	6.1%	180	604	691	863	1,123	1,468	1,987
8	200	16.4%	12.6%	9.5%	7.7%	6.7%	6.1%	200	657	753	945	1,233	1,617	2,193
9	220	16.1%	12.4%	9.3%	7.6%	6.7%	6.1%	220	710	815	1,027	1,343	1,766	2,399
10	240	15.9%	12.2%	9.2%	7.6%	6.6%	6.0%	240	763	878	1,108	1,454	1,915	2,606
11	260	15.7%	12.1%	9.2%	7.5%	6.6%	6.0%	260	815	940	1,190	1,564	2,063	2,812
12	280	15.5%	11.9%	9.1%	7.5%	6.6%	6.0%	280	868	1,003	1,271	1,675	2,212	3,019
13	300	15.4%	11.8%	9.0%	7.4%	6.6%	6.0%	300	921	1,065	1,353	1,785	2,361	3,225
14	320	15.2%	11.7%	9.0%	7.4%	6.5%	6.0%	320	974	1,127	1,435	1,895	2,510	3,431
15	340	15.1%	11.7%	8.9%	7.4%	6.5%	5.9%	340	1,027	1,190	1,516	2,006	2,659	3,638
16	360	15.0%	11.6%	8.9%	7.3%	6.5%	5.9%	360	1,079	1,252	1,598	2,116	2,807	3,844
17	380	14.9%	11.5%	8.8%	7.3%	6.5%	5.9%	380	1,132	1,315	1,679	2,227	2,956	4,051
18	400	14.8%	11.5%	8.8%	7.3%	6.5%	5.9%	400	1,185	1,377	1,761	2,337	3,105	4,257
19	420	14.7%	11.4%	8.8%	7.3%	6.5%	5.9%	420	1,238	1,439	1,843	2,447	3,254	4,463
20
21
22	Shopify Monthly Costs
23	Basic Plan	$29	$29
24	Basic Apps	$100	$100
25
26	Per Txn Costs (Payfort)
27	Shopify Fee	2%
28	PG Fee	2.80%
29	PG Processing Fee	$1.68
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