Case File
efta-efta01199952DOJ Data Set 9OtherArtspace
Date
Unknown
Source
DOJ Data Set 9
Reference
efta-efta01199952
Pages
7
Persons
0
Integrity
No Hash Available
Extracted Text (OCR)
Text extracted via OCR from the original document. May contain errors from the scanning process.
Artspace
2014-17 Income Statement & Cash Flow
Key Assumptions
Revenue - Income Statement
- Revenue in the out years is based on the number of monthly visits to the site, average conversion rate & average revenue per order
- Increase in average monthly visits driven by increased marketing, staffing and inventory on site
- Modest yearly increases in average order size and conversion rate
Expenses - Income Statement
- Base (2014) Headcount 14, Additional (8) FTE in 2015 and (2) in 2016 drive salary increases
- 2015 additional headcount includes Product/Developers (4) and Editorial (2) to build back the technology and editorial teams
- Model assumes the following GM%: Q4 2014 (22%), 2015 (22%), 2016 (23%) and 2017 (23%)
- Model includes Monthly Rent of $20k
Cash Flow - Inflows
- The majority of transactions are paid by credit card online
- Cash Receipts assumes 90% of revenue received in month ordered with 10% the following month
Cash Flow - Outflows
- COGS paid 2 months after the expense is occurred
- Salaries paid in month the expense occurred
- All other expenses paid the month following expense incurred.
Prepared by 1. Murphy 1/7/2015
EFTA01199952
Artspace
Quarterly Income Statement (2014 - 2017)
04 2014
Total Revenue
658200
COGS
513.917
Gross Profit
144,283
Gross Margin %
21.9%
Operating Expenses
G&A
136,323
Marketing
16,629
Merchandising
22,340
Editorial
2,100
Tech/Product
30,852
Salaries/Benefits
353,305
Capitalized Tech Salads
(64,125)
Total Operating Expenses
497,424
EWE%
(353,141)
Headcount
Total Revenue
COGS
Gross Profit
Gross Margin %
Operating Expenses
G&A
Marketing
Merchandising
Editorial
Tech/Product
Salaries/Benefits
Capitalized Tech Salaries
Total Operating Expenses
EBIIOA
01 2015
Q22015
Q32015
Q42015
FY 2015
$
571049 $
646,608
$
530,771 $
986,699 $
2,735,927
$
446,042
$
504,354
$
414,001 $
769,625
$
2,134,023
$
125.807
$
142,254
$
116,770 $
217.074 $
601,904
22.0%
[repeated 5 times]
$
121,750 $
161,750 $
103,750 $
113,750 $
501,000
$
60000 $
60,000 $
60,000 $
90000 $
270,000
$
6.000 $
6,000 $
[repeated 3 times]
20,000
$
7,500 $
[repeated 4 times]
30,000
$
42,870 $
02,870 $
42,882 $
42,870 $
171,492
$
602.998 $
673,683 $
932,233 $
682,233 $
2,891,147
$
(122,097) $
(173,850) $
[repeated 3 times]
(643,647)
$
719,021 $
777,953 $
978,515 $
768,503 $
3,203.992
$
(593.214) $
(635,699) $
(861,745) $
(551,429) $ (2,642,088)
41 2016
Q22016
Q32016
Q42016
FY 2016
$
1,018,015 $
992,845 $
849,234 $
1,923,687 $ 4,783,781
$
783,872 $
764,491 $
653,910 $
1,481,239 $ 3,683,511
$
234,143 $
228,354 $
195,324 $
442,448 $ 1,100,270
23.0%
[repeated 5 times]
$
104,063 $
114,063 $
104,063 $
110,063 $
436,250
$
61,800 $
61,800 $
61,803 $
92,700 $
278,100
$
6,000 $
[repeated 3 times]
6.000 $
24,000
$
7.300 $
7,500 $
[repeated 3 times]
30,000
$
45,018 $
45,018 $
45,030 $
52,018 $
187,084
$
709.322 $
724,722 $
732,322 $
736,851 $ 2,903,418
$
180,804 $
(180.804) $
(180,800) $
(180.804) $
(723.216)
$
753,099 $
778,299 $
775,911 $
828,328 $ 3,135,636
S
(518.955) $
(549.944) $
(580,587) $
(385,880) $ (2,035,367)
• Note 2017 revenue in Ow acquisition financial model included SLIM revenue associated with Plus:Ion books sold to Anspace customerswall a 75% margin,
this model Includes similar total revenue in 2017 but wnh /inspect mammal 23%
Prepared by J. Murphy 1/7/2015
412017
Q2 2017
03 2017
Q42017
Total 2017
$
1,752,959 5
1,972,780 $
1,987,354 $
3,263,032 $
8,976,129
$
1,309,778 $
1,519,000 5
1,530,262 $
2,512,535 $
6,911,619
$
003,180 $
453,740 5
457,091 $
750,497 $
2,064,510
23.0%
[repeated 4 times]
23D%
$
104,719 5
114,719 5
104,719 $
110,719 $
438,875
$
63,654 5
63,654 5
63,654 $
95,481 $
286,443
$
6,000 5
6,000 5
6,000 $
6,000 5
24,000
$
7,800 $
7,800 5
7,800 $
7,800 5
31,200
$
07,195 $
47,195 $
47,207 $
07,195 $
188,790
$
775,865 $
[repeated 4 times]
3,103,461
$
(188,036) 5
1.88 36 $
(188,036) $
(188,036) 5
(752,145)
$
817,196 $
827,196 $
817,208 $
859,023 $
3,320,624
$
(414,016) $
(373,056) $
(360,117) $
(108,526) $
(1,256,115)
EFTA01199953
Artspace
Cash Flow (2014 - 2017)
Cash Inflows
Q4 2014
FY 2015
FY 2016
FY 2017
14 - 17
Receipts
837,701
2,715,770
4,756,066
8,928,915
17,238,451
Credit/Overdraft Facility
650,000
2,550,000
2,325,000
1,350,000
6,875,000
1,487,701
5,265,770
7,081,066
10,278,915
24,113,451
Cash Outflows
COGS
(292,817)
(1,935,705)
(3,218,939)
(6,229,441)
(11,676,902)
G&A
(136,193)
(496,417)
(436,146)
(438,656)
(1,507,412)
Marketing
(15,458)
(244,402)
(277,200)
(285,516)
(822,576)
Merchandising
(24,440)
(25,500)
(24,000)
(24,000)
(97,940)
Editorial
(2,100)
(27,500)
(30,000)
(31,100)
(90,700)
Technology/Product
(31,469)
(167,202)
(186,368)
(188,065)
(573,104)
Salaries
(510,612)
(2,891,147)
(2,903,418)
(3,103,461)
(9,408,637)
(1,013,089)
(5,787,872)
(7,076,071)
(10,300,239)
(24,177,271)
Net Inflow/(Outflow)
474,612
(522,102)
4,994
(21,324)
(63,820)
• Acquisition Cash Flow Model Credit/Overdraft Facility ($6.1M) did not include $0.7M in Rent
Prepared by J. Murphy 1/7/2015
EFTA01199954
Artspace
Monthly Cash Flow (2014 • 2015)
Cask Intlows
400 14
14.-14
ON-I4
Nov-14
Dec-14
49,405
CroditiOarcfrah Facility
0
Git114441048)
COGS
GSA
PAsekelong
Merchancliti%
(dilate let hocdort/Preduct
Salaries
Net InFlow/lOutflow)
•9934w+Ns
In Balance
Orentog Bounce
Net inF8m/(0611148)
Ending Balance
145,98
137.289
188.615
2)9235
222,508
0
200.000
0
450.000
0
127.016) (117,324) 1148.477
11.317)
140.523)
(48234)
143.089
1520)
12.711)
(1AP)
111.140
15.600)
(7,000)
111.840
(2.100)
0
110.617)
(10290)
110.562
11,324
108274
119,727)
125.304
3.422
21.098
193.874
(63,877)
99.568
293,442
193.874
(65477)
293.442
227,565
122,094
227,565
322,096
549,661
04 2014
837.701
654000
1292217)
1136.193)
115.458)
124,440)
11.100)
131.469)
010,612) lan.I5
Feb.15
114ac.I5
Apr.15
May.13
NmIS
181.13
4.84.15
Sep.1$
Oct-15
Nov-I5
FY 2015
157,538
204.788
210,478
209,729
262.154
174871
153278
151.202
218951
260,177
297.470
409,533
2.715,770
0
150.000
200000
2251200
100,000
300000
400.000
550.000
300000
100.000
150,000
MOO
2.554000
157 538
354 788
4
78
434 729
362.154
474871
553278
702.202
518,951
360.177
447.470
484,533
5,265,770
(192,574) 1172.866) 1117,466) (164431
1164.144) (163,527) (209,031
1131296) (118,717) 1118,717) 1176867) (205,868
(1.935,705)
(45.0001
122.083)
14686))
(53.583
156083)
(56.083)
(49.583
132.033)
(32083)
139.583)
132083)
(324183
1496417)
(4,4021
110.000)
11080))
(20.000
120.000)
(10.00D)
(20.000
120.000)
(20000)
120.0001
134000)
(30,000
1144A02)
(3.5001
12.000)
PICO)
(2,000
12.000)
(LOCO)
(2.000
12.000)
(2=1
12.000)
12,000)
(2,000
115.500)
0
12.500)
11,500)
(2.500
12.500)
(1.500)
(2.500
12.500)
(2.500)
12.5001
11.500)
(2.500
127.5002
(10.0001
114.290)
114290)
(14.290
114.2901
(14,290)
(14.2%
114.290)
(14.301)
114.2901
114290)
(14.290
1167,202)
(176242) 003.019) 023,136) (223,136
1223.136) (227,411) (227.411
1477.411) (227,433)
1227.411) 1227,411)
(227,411
(2)591347)
(412.3200
036.759) 1425 476) WON
1482,154) (185411i (524,825
1610.080) 14178141 1424.502) 1484.851).. (514.152
(5787072)
(174710)
(81.971)
114.997)
(45,21
1119.999)
16.940)
29,061
22.121
101,937
(64.125)
117.944)
(28619
1322402)
589,661
278881
191.910
177,913
132.702
11.701
5,763
34.826
56,947
158,884
94,559
57,178
(214,7413)
181.9711
(14,997)
(45,2111 1119.999)
(4940)
29063
22.121
101,937
164.325)
137382)
(29,6191
274,881
192.910
177.913
132,702
12.702
5,763
34226
56.947
158084
94,559
57.178
27,558
PreOated by 3. Murphy 1/7/201.
EFTA01199955
Arts pace
Monthly Cash Flow (2016)
Cash Inflows
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
FY 2016
Receipts
334,919
344,527
346,120
344,888
374,438
281,090
246,206
243,523
350,322
565,593
631,913
692,527
4,756,066
Credit/Overdraft Facility
250,000
300,000
200,000
250,000
200,000
300,000
375,000
300,000
125,000
0
0
25,000
2,325,000
584,919
644,527
546,120
594,888
574,438
581,090
621,206
543,523
475,322
565,593
631,913
717,527
7,081,066
Cash Outflows
COGS
(234,933)
(328,825)
(250,474)
(266,931)
(266,466)
(265,464)
(290,857)
(208,171)
(187,512)
(187,512)
(278,885)
(452,909) (3,218,939)
G&A
(49,583)
(32,188)
(32,188)
(39,688)
(32,188)
(32,188)
(49,688)
(32,188)
(32,188)
(39,688)
(32,188)
(32,188)
(436,146)
Marketing
(30,000)
(20,600)
[repeated 9 times]
(30,900)
(30,900)
(277,200)
Merchandising
(2,000)
[repeated 12 times]
(24,000)
Editorial
(2,500)
[repeated 12 times]
(30,000)
Technology/Product
(14,290)
(15,006)
[repeated 7 times]
(15,018)
(15,006)
(22,006)
(15,006)
(186,368)
Salaries
(236,507)
(236,507)
(216,507)
(236,507)
(244,107)
[repeated 7 times]
(248,636) (2,903,418)
(569,814)
(637,626)
(559,275)
(583,232)
(582,867)
(581,864)
(624,758)
(524,572)
(503,926)
(511,413)
(612,586)
(784,139) (7,076,071)
Net Inflow/(Outflow)
15,106
6,901
(13,155)
11,656
(8,429)
(775)
(3,552)
18,951
(28,604)
54,180
19,327
(66,612)
4,994
Bank Balance
Opening Balance
27,558
42,664
49,565
36,410
48,066
39,637
38,862
35,310
54,261
25,658
79,838
99,165
Net Inflow/(Outflow)
15,106
6,901
(13,155)
11,656
(8,429)
(775)
(3,552)
18,951
(28,604)
54,180
19,327
(66,612)
Ending Balance
42,664
49,565
36,410
48,066
39,637
38,862
35,310
54,261
25,658
79,838
99,165
32,553
Prepared by 3. Murphy 1/7/2015
EFTA01199956
Artspace
Monthly Cash Flow (2017)
Cash Inflows
Jan-17
Feb-17
Mar-17
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Noy-17
Dec-17
FY 2017
Receipts
527,313
587,073
643,558
695,147
760,577
531,425
523,108
525,096
895,956 1,031,150
1,049,675
1,158,837
8,928,915
Credit/Overdraft Facility
325,000
300,000
100,000
[repeated 3 times]
350,000
475,000
275,000
(300,000)
(200,000)
(150,000)
(25.000)
1,350,000
852,313
887,073
743,558
795,147
860,577
881,425
998,108
800,096
595,956
831,150
899,675
1,133,837
10,278,915
Cash Outflows
COGS
(490,313)
(538,016)
(391,366)
(458,788)
(499,623)
(539,223)
(590,802)
(389,019)
(404,324)
(404,324)
(721,615)
(802,027) (6,229,441)
G&A
(49,688)
(32,406)
(32,406)
(39,906)
(32,406)
(32,406)
(49,906)
(32,406)
(32,406)
(39,906)
(32,406)
(32,406)
(438,656)
Marketing
(30,900)
(21,218)
[repeated 9 times]
(31,827)
(31,827)
(285,516)
Merchandising
(2,000)
[repeated 12 times]
(24,000)
Editorial
(2,500)
(2,600)
[repeated 11 times]
(31,100)
Technology/Product
(15,006)
(15,732)
[repeated 7 times]
(15,744)
(15,732)
[repeated 3 times]
(188,065)
Salaries
(258,622)
[repeated 11 times]
(258,622) (3,103,461)
(849,029)
(870,594)
(723.944)
(798,866)
(832,201)
(871,800)
(940,880)
(721,596)
(736,913)
(744,401) (1,064,801)
(1,145,213) (10,300,239)
Net Inflow/(Outflow)
3,285
16,479
19,615
(3,719)
28,376
9,625
57,228
78,499
(140,958)
86,749
(165,127)
(11,376)
(21,324)
Bank Balance
Opening Balance
32,553
35,838
52,317
71,931
68,212
96,588
106,213
163,441
241,941
100,983
187,732
22,605
Net Inflow/(Outflow)
3,285
16,479
19,615
(3.719)
28,376
9,625
57,228
78,499
(140,958)
86,749
(165,127)
(11,376)
Ending Balance
35,838
52,317
71,931
68,212
96,588
106,213
163,441
241,941
100,983
187,732
22,605
11,229
Prepared by ). Murphy 1/7/2015
EFTA01199957
ArtSpace
Revenue Drivers (2015 - 2017)
Visitor Metrics
Average Monthly Unique Visitors to Site
Growth in site visitors
Visits Per Unique
Total Visits
Average Site Monthly Conversion Rate
Average Monthly Orders
Average $ Order Size (Art Only)
Revenue
Art
Total Gross Revenue
Other Revenue
Total Revenue Framing
Total Revenue Shipping
Total Revenue (Art & Other)
Refunds
Total Gross Revenues
2015
2016
2017
150,688
187,907
229,852
19.3%
24.7%
22.3%
1.5
[repeated 3 times]
2,712,376
3,382,326
4,137,333
0.07%
0.09%
0.14%
162
277
503
1,392
1,400
1,417
2,594,857
4,489,284
8,423,544
99,376
224,464
421,177
155,691
269,357
505,413
255,067
493,821
926,590
2,849,924
4,983,105
9,350,134
(113,997)
(199,324)
(374,005)
2,735,927
4,783,781
8,976,129
Prepared by J. Murphy 1/7/2015
EFTA01199958
Technical Artifacts (19)
View in Artifacts BrowserEmail addresses, URLs, phone numbers, and other technical indicators extracted from this document.
Phone
(227.411
1477Phone
(5787072Phone
1292217)
1136Phone
1347)
(412.3200Phone
14178141Phone
1424.502) 1484Phone
14441048Phone
2251200Phone
290
1167Phone
324) 1148Phone
411) 1227Phone
431
1164Phone
433)
1227Phone
574) 1172Phone
717) 1118Phone
759) 1425Phone
825
1610Phone
866) 1117Forum Discussions
This document was digitized, indexed, and cross-referenced with 1,400+ persons in the Epstein files. 100% free, ad-free, and independent.
Annotations powered by Hypothesis. Select any text on this page to annotate or highlight it.