Tiered-Pricing-Template.xlsx

	A	B	C	D	E
1
2
3
4
5
6
7
8	Fill these informations of your product
9	1	Product Cost (Cost to make 1 unit)
10	2	Price
11	3	Ad Spend (CPA) - Cost to acquire 1 customer
12	4	Shipping Cost
13
14
15	Calculation Table
16	1	Metric	Baseline (1 Unit)	Tier 1	Tier 2
17	2	The Offer	Single Item	Buy [X] Get [Y]% Off	Buy [Z] Get [F]% Off
18	3	Quantity Sold
19	4	Discount Amount	0.00%	0.00%	0.00%
20	5	A. Total Revenue	$0.00	$0.00	$0.00
21	6	B. Total Product Cost	$0.00	$0.00	$0.00
22	7	C. Shipping Cost
23	8	D. CPA
24	9	Total Costs (B + C + D)	$0.00	$0.00	$0.00
25	10	E. Net Profit	$0.00	$0.00	$0.00
26	11	F. ROAS	#DIV/0!	#DIV/0!	#DIV/0!
27	12	G. Profit Margin	#DIV/0!	#DIV/0!	#DIV/0!
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