Hortonworks, inc. (HDP)
CashFlow / Quarterly
Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14
CASH FLOWS FROM OPERATING ACTIVITIES:
Net loss

-31,574

-41,197

-42,055

-48,228

-45,368

-56,076

-54,835

-57,053

-64,686

-64,197

-65,752

-50,234

-45,293

-43,000

-40,590

-90,633

-39,502

-26,957

-20,273

Adjustments to reconcile net loss to net cash used in operating activities:
Depreciation

2,119

2,134

2,135

2,262

2,289

2,177

2,058

2,007

1,949

1,810

1,478

1,438

1,141

1,026

894

485

289

205

225

Amortization of deferred costs

9,176

8,347

7,076

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of premiums from investments

-

-

30

-

-

-

115

135

203

234

284

193

214

260

282

346

272

236

67

Amortization of intangible assets

221

219

217

222

221

219

217

221

222

219

219

222

171

0

0

-

-

-

-

Stock-based compensation expense

-

-

-

-

-

-

-

-

-

-

-

-

11,379

7,146

5,194

-

1,899

1,445

2,148

Loss on early exit of lease

-

-

-

0

0

0

-349

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of promissory note and related interest receivable

-

-

-

-

-

-

-

1,966

0

0

717

-

-

-

-

-

-

-

-

Contra-revenue adjustment related to share purchase agreement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

2,040

Loss on disposal of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-30

-47

-16

-25

Effects of exchange rate changes on monetary assets and liabilities denominated in foreign currencies

364

1,033

-619

-486

-382

-772

-162

440

-102

216

-219

-

-

-

-

-

-

-

-

Provision for losses on accounts receivable

0

182

7

-

-

-

-

105

-34

66

377

-

-

-

-

-

-

-

-

Other

-128

-40

-216

-111

-73

-73

-76

-32

25

25

25

-

-

-

-5

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-11,304

19,045

-40,327

31,188

3,654

6,522

-14,479

5,217

16,508

-3,288

11,147

8,370

4,279

7,373

1,607

11,594

2,181

5,618

795

Contract assets

-

-

161

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

-621

-3,746

5,160

1,681

1,247

-2,446

4,812

-586

-431

-2,480

3,468

-783

302

-895

2,895

608

-1,033

2,042

1,099

Deferred costs

7,139

8,776

6,532

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

1,867

38

-147

-1,283

1,668

-352

1,002

407

-140

107

90

-146

75

261

390

-

-

-

-

Other non-current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5

Accounts payable

573

-182

-384

583

-2,825

1,365

110

-2,335

-2,661

6,680

89

1,570

-1,780

2,305

-447

-201

-513

2,002

-382

Accrued expenses and other current liabilities

-191

1,748

-2,760

3,110

-2,540

-2,307

586

2,877

916

-1,794

335

629

-233

2,320

3,438

-

-

-

-

Accrued liabilities and other long-term liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,331

Accrued compensation and benefits

-3,547

5,384

-7,778

4,713

-1,395

2,826

-2,166

2,729

-139

2,737

303

1,272

-877

1,942

464

4,745

-753

2,133

-234

Deferred revenue

713

15,915

-4,175

44,201

11,995

15,855

12,513

29,830

24,898

13,079

11,686

15,233

11,473

11,891

5,784

15,203

8,737

7,492

3,563

Other contract liabilities

5,804

-2,736

-273

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other long-term liabilities

-16

-100

-153

-191

-347

-226

-228

129

-167

-240

-335

1,243

-1,361

328

1,139

-

-

-

-

Net cash provided by (used in) operating activities

-

-

7,955

-

-

-

-9,003

-1,545

-31,139

-14,088

-35,668

-18,779

-29,812

-22,016

-28,729

-33,085

-24,729

-17,661

-12,389

CASH FLOWS FROM INVESTING ACTIVITIES:
Purchases of investments

19,790

20,390

18,899

-

-

-

-

0

0

6,765

73,754

11,643

18,613

30,318

42,057

-

-

-

-

Proceeds from sales of investments

-

-

-

-

-

-

-

5,840

0

5,995

1,321

-

-

-

-

-

-

-

-

Proceeds from maturities of investments

8,635

6,680

4,000

5,300

8,265

6,000

13,300

15,928

32,341

18,780

22,199

41,493

40,871

8,285

27,861

10,500

2,600

7,600

2,920

Purchases of property and equipment

931

636

1,029

822

2,198

985

1,218

1,716

3,790

4,916

2,359

1,466

3,736

2,374

5,263

4,392

687

818

379

Issuance of promissory note receivable

-

-

-

-

-

-

-

-

-

-

-

0

0

0

2,500

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-31

-

-

-

-

Net cash (used in) provided by investing activities

-

-

-15,928

-

-

-

12,082

20,052

28,540

13,094

-52,593

28,384

18,702

-28,128

-21,928

3,911

-20,564

-58,686

2,541

CASH FLOWS FROM FINANCING ACTIVITIES:
Proceeds from issuance of common stock

9,619

1,034

9,657

4,479

9,397

1,245

4,343

645

2,969

1,240

4,612

1,665

6,266

2,173

313

956

1,087

441

96

Proceeds from exercise of warrants

0

0

4,062

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Tax withholding shares

97

212

4,649

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment of contingent consideration related to an acquisition

-

-

-

-

-

-

-

0

0

0

1,625

-

-

-

-

-

-

-

-

Payments of capital lease liability

-

-

86

-

-

-

90

69

39

39

25

-

-

-

-

-

-

-

-

Payment of fees for line of credit

106

276

26

0

27

26

26

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of preferred stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

49,865

-60

99,742

Proceeds from follow-on public offering, net of issuance costs

-

-

-

-

-

-

-

920

0

-615

87,848

-

-

-

-

-

-

-

-

Net cash provided by financing activities

-

-

8,958

-

-

-

4,227

-444

678

489

90,810

1,495

5,431

2,173

313

115,525

48,954

125

99,838

Effect of exchange rate changes on cash, cash equivalents and restricted cash

-

-

175

-

-

-

298

-561

-65

-190

214

-

-

-

-

-

-

-

-

Net increase in cash, cash equivalents and restricted cash

-

-

1,160

-

-

-

7,604

17,502

-1,986

-695

2,763

10,658

-5,679

-47,971

-50,344

86,351

3,661

-76,222

89,990

SUPPLEMENTAL DISCLOSURES OF NON-CASH INVESTING AND FINANCING INFORMATION:
Purchases of property and equipment included in accounts payable and accrued expenses and other current liabilities

-

-

-

-

-

-

-

-

-

-1,344

3,260

-

-

249

1,350

-

-

-

-