Ecommerce financial model demo fml
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
Dashboard
CURRENCY, DENOMINATOR & TAXDEBT ASSUMPTIONSWORKING CAPITAL ASSUMPTIONS
2
Model name
Model Currency
$Loan NameAmount, $LaunchTerm, MInterest, %Type
Production time
2
Safety Stock, %
30%
3
Go to Table of Contents
Denomination
1,000Debt_1 250,000 Jan-1936M5.0%Usual
Pmnt upfront, M
2
4
Go to FINMODELSLAB.COMCorporate Tax20%Debt_2
Pmnt Share, %
30%
5
Launch dateJan-19Debt_3
Cash Receipt Days
21
6
7
Core InputsRevenue Breakdown ($'000) - 3 Years to December 2021Profitability ($'000) - 3 Years to December 2021
8
9
SALES VOLUME, units
10
Market/product
Launch 2019 2020 2021
11
Amazon USJan-19 1,000 1,200 1,560 2019
12
Amazon UKMay-19 1,750 2,100 2,730 2019
13
Amazon DEJun-19 1,350 1,620 2,106 2019
14
0
15
0
16
17
AVERAGE SALES PRICE, $
18
2019 2020 2021
19
Amazon US
129.00129.00129.00
20
Amazon UK
139.00139.00139.00
21
Amazon DE
149.00149.00149.00
22
159.00159.00159.00
23
179.00179.00179.00
24
25
AVERAGE PPC, %
26
2019 2020 2021
27
Pay Per Click as % of Revenue
27%25%20%
28
29
Core Financials ($'000)Cash Flow ($'000) - 3 Years to December 2021Cumulative Cash flow ($'000) - 3 Years to December 2021
30
31
Fiscal Year
2019 2020 2021
32
33
Revenue
Revenue 327 688 895
34
COGS
(53)(111)(144)
35
GROSS MARGIN
274 577 751
36
GROSS MARGIN %
84%84%84%
37
Salaries & Taxes
- - -
38
Variable Expenses
(167)(337)(394)
39
Fixed Expenses
(48)(17)(17)
40
41
Net Operating Expenses
(214)(354)(410)
42
43
EBITDA
EBITDA 60 224 340
44
EBITDA %
EBITDA %18%32%38%
45
46
Depreciation & Amortization
(15.0)(15.8)(9.0)
47
EBIT
45 208 331
48
Net Interest Expense
(10)(7)(3)
49
Net Profit Before Tax
35 201 329
50
Tax Expense
(7)(40)(66)
51
Net Profit After Tax
28 161 263
52
Net Profit After Tax %
9%23%29%
53
54
Operating Cash Flows
16 202 301
55
56
Cash
159 233 451
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
Dashboard Source Data
90
92
Displayed Periods Description
3 Years to December 2021
94
123
95
Fiscal Year
2019 2020 2021 mcolsheet
date row
prefixsuffixvalue row
96
97
Year End Date
31-Dec-1931-Dec-2031-Dec-21
98
99
Income Statement Source Data
100
101
Revenue 326,641 688,080 894,504 DIS5Total21
102
COGS(52,572)(110,592)(143,770)DIS5Total30
Loading...