ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Black Friday/Cyber Monday - EBITDA Scenario Calculator
3
4
5
6
7
8
9
INPUTS
10
COGS (% of gross revenue)20%
11
Cost of Delivery (% of gross revenue 15%
12
Monthly Opex$200,000.00
13
Baseline Spend $1,000,000
14
Spend Increments$100,000
15
Baseline MER3.50
16
Returning Revenue (% of new revenue)20%
17
Discounts (% of gross revenue)15%
18
Other Marketing ( %of gross revenue)5%
19
20
Ad Spend MERTotal MERGross RevenueNet Revenue Other Marketing
Total Marketing
Cost of Goods Sold Cost of Delivery COGS + Delivery Contribution Profit
Contribution Margin
Opex EBITDAEBITDA Margin
21
100,000.00 5.754.62 575,000 488,750 24,438 124,438 115,000 86,250 201,250 163,063 28% 200,000 (36,938)-6%
22
200,000.00 5.504.46 1,100,000 935,000 46,750 246,750 220,000 165,000 385,000 303,250 28% 200,000 103,250 9%
23
300,000.00 5.254.29 1,575,000 1,338,750 66,938 366,938 315,000 236,250 551,250 420,563 27% 200,000 220,563 14%
24
400,000.00 5.004.12 2,000,000 1,700,000 85,000 485,000 400,000 300,000 700,000 515,000 26% 200,000 315,000 16%
25
500,000.00 4.753.95 2,375,000 2,018,750 100,938 600,938 475,000 356,250 831,250 586,563 25% 200,000 386,563 16%
26
600,000.00 4.503.78 2,700,000 2,295,000 114,750 714,750 540,000 405,000 945,000 635,250 24% 200,000 435,250 16%
27
700,000.00 4.253.60 2,975,000 2,528,750 126,438 826,438 595,000 446,250 1,041,250 661,063 22% 200,000 461,063 15%
28
800,000.00 4.003.42 3,200,000 2,720,000 136,000 936,000 640,000 480,000 1,120,000 664,000 21% 200,000 464,000 15%
29
900,000.00 3.753.23 3,375,000 2,868,750 143,438 1,043,438 675,000 506,250 1,181,250 644,063 19% 200,000 444,063 13%
30
1,000,000.00 3.503.05 3,500,000 2,975,000 148,750 1,148,750 700,000 525,000 1,225,000 601,250 17% 200,000 401,250 11%
31
1,100,000.00 3.252.86 3,575,000 3,038,750 151,938 1,251,938 715,000 536,250 1,251,250 535,563 15% 200,000 335,563 9%
32
1,200,000.00 3.002.66 3,600,000 3,060,000 153,000 1,353,000 720,000 540,000 1,260,000 447,000 12% 200,000 247,000 7%
33
1,300,000.00 2.752.46 3,575,000 3,038,750 151,938 1,451,938 715,000 536,250 1,251,250 335,563 9% 200,000 135,563 4%
34
1,400,000.00 2.502.26 3,500,000 2,975,000 148,750 1,548,750 700,000 525,000 1,225,000 201,250 6% 200,000 1,250 0%
35
1,500,000.00 2.252.05 3,375,000 2,868,750 143,438 1,643,438 675,000 506,250 1,181,250 44,063 1% 200,000 (155,938)-5%
36
1,600,000.00 2.001.84 3,200,000 2,720,000 136,000 1,736,000 640,000 480,000 1,120,000 (136,000)-4% 200,000 (336,000)-11%
37
1,700,000.00 1.751.63 2,975,000 2,528,750 126,438 1,826,438 595,000 446,250 1,041,250 (338,938)-11% 200,000 (538,938)-18%
38
1,800,000.00 1.501.41 2,700,000 2,295,000 114,750 1,914,750 540,000 405,000 945,000 (564,750)-21% 200,000 (764,750)-28%
39
1,900,000.00 1.251.19 2,375,000 2,018,750 100,938 2,000,938 475,000 356,250 831,250 (813,438)-34% 200,000 (1,013,438)-43%
40
2,000,000.00 1.000.96 2,000,000 1,700,000 85,000 2,085,000 400,000 300,000 700,000 (1,085,000)-54% 200,000 (1,285,000)-64%
41
2,100,000.00 0.750.73 1,575,000 1,338,750 66,938 2,166,938 315,000 236,250 551,250 (1,379,438)-88% 200,000 (1,579,438)-100%
42
2,200,000.00 0.500.49 1,100,000 935,000 46,750 2,246,750 220,000 165,000 385,000 (1,696,750)-154% 200,000 (1,896,750)-172%
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