Ecommerce revenue Estimating

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1
2		Total %	Value	Jan	Feb	Mar	Apr	May	Jun	Lug	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Lug	Aug	Sep	Oct	Nov	Dec
3	Sessions (Visits)			100000	110000	121000	133100	146410	161051	177156	194872	214359	235795	259374	285312
4	Conversion Rate			1.00%	1.10%	1.21%	1.33%	1.46%	1.61%	1.77%	1.95%	2.14%	2.36%	2.59%	2.85%
5	Average Price			100	100	100	100	100	70	60	100	100	100	80	70
6	Avg. Units Per Transaction			2.0	1.7	1.7	1.7	1.7	2.5	2.9	1.7	1.7	1.7	2.0	2.5
7	Average Order Value			200	170	170	170	170	175	174	170	170	170	160	175
8	Gross Revenue			200,000	205,700	248,897	301,165	364,410	453,905	546,087	645,575	781,145	945,186	1,076,400	1,424,548
9	Returns	30%		60000	61710	74669	90350	109323	136171	163826	193672	234344	283556	322920	427364
10	Net revenue		5,035,113	140000	143990	174228	210816	255087	317733	382261	451902	546802	661630	753480	997184
11
12
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