ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Be sure to read the cell comments
2
Yellow are variable, white are equations
3
4
5
Media/Advertising Spend$1,000
6
Impressions50,000
7
Cost Per Impression$0.020
8
Click Through Rate2.50%
Obviosuly the higher the better; if media cost low, then this can be lower. A general threhsild seems to be around 2.5% as a rule of thumb.
9
Clicks1,250
10
Cost Per Click$0.80
11
Conversion Rate10%
Shoot for minumum of 10% conversion
12
Conversions/Purchase Starts125
13
Purchase Abandon/Cancel/Decline Rate20.00%
14
Total Orders100
15
Average Initial Cart/Order Total$40.00
16
Upsell/Downsell/Crossell 1 Conversion Percent/Buyers
25% 25
17
Upsell/Downsell/Crossell 1 Revenue $ 30 $ 750
18
Upsell/Downsell/Crossell 2 Conversion Percent/Buyers
25% 6
19
Upsell/Downsell/Crossell 2 Revenue $ 50 $ 313
20
Upsell/Downsell/Crossell 3 Conversion Percent/Buyers
25% 2
21
Upsell/Downsell/Crossell 3 Revenue $ 90 $ 141
22
Cost Per Order (CPO) $ 10.00
23
Total Revenue $ 5,203
24
Cance/Declines6%
Varies by product/industry
25
Revised Revenue $ 4,891
26
Average Order Value (AOV) $ 49
27
Returns20%
Varies by product/industry
28
Net Revenue$3,913
29
COGS35%$1,369
COGS will be high for startups but when you achieve some volume, want to to generally see it below 40%
30
Gross Margin65%$2,543
31
Marketing Costs$1,000
32
Operations Costs35.00%$1,369
33
Net Income Before Taxes4.44%$174
34
Contribution Margin48.87%
35
ROIMI154.29%
36
ROAS/MER5.2
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