Hortonworks, inc. (HDP)
CashFlow / TTM
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

-163,054

-176,848

-191,727

-204,507

-213,332

-232,650

-240,771

-251,688

-244,869

-225,476

-204,279

-179,117

-219,516

-213,725

-197,682

-177,365

0

0

0

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

8,650

8,820

8,863

8,786

8,531

8,191

7,824

7,244

6,675

5,867

5,083

4,499

3,546

2,694

1,873

1,204

0

0

0

Amortization of deferred costs

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of premiums from investments

-

-

223

-

-

-

687

856

914

925

951

949

1,102

1,160

1,136

921

0

0

0

Amortization of intangible assets

879

879

879

879

878

879

879

881

882

831

612

393

0

0

0

-

-

-

-

Stock-based compensation expense

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Loss on early exit of lease

-

-

-

-349

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of promissory note and related interest receivable

-

-

-

-

-

-

-

2,683

0

0

0

-

-

-

-

-

-

-

-

Contra-revenue adjustment related to share purchase agreement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,040

0

0

0

Loss on disposal of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-118

0

0

0

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

292

-454

-2,259

-1,802

-876

-596

392

335

0

0

0

-

-

-

-

-

-

-

-

Provision for losses on accounts receivable

0

0

0

-

-

-

-

514

0

0

0

-

-

-

-

-

-

-

-

Other

-495

-440

-473

-333

-254

-156

-58

43

0

0

0

-

-

-

0

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-1,398

13,560

1,037

26,885

914

13,768

3,958

29,584

32,737

20,508

31,169

21,629

24,853

22,755

21,000

20,188

0

0

0

Contract assets

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

2,474

4,342

5,642

5,294

3,027

1,349

1,315

-29

-226

507

2,092

1,519

2,910

1,575

4,512

2,716

0

0

0

Deferred costs

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

475

276

-114

1,035

2,725

917

1,376

464

-89

126

280

580

0

0

0

-

-

-

-

Other non-current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Accounts payable

590

-2,808

-1,261

-767

-3,685

-3,521

1,794

1,773

5,678

6,559

2,184

1,648

-123

1,144

841

906

0

0

0

Accrued expenses and other current liabilities

1,907

-442

-4,497

-1,151

-1,384

2,072

2,585

2,334

86

-1,063

3,051

6,154

0

0

0

-

-

-

-

Accrued liabilities and other long-term liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Accrued compensation and benefits

-1,228

924

-1,634

3,978

1,994

3,250

3,161

5,630

4,173

3,435

2,640

2,801

6,274

6,398

6,589

5,891

0

0

0

Deferred revenue

56,654

67,936

67,876

84,564

70,193

83,096

80,320

79,493

64,896

51,471

50,283

44,381

44,351

41,615

37,216

34,995

0

0

0

Other contract liabilities

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other long-term liabilities

-460

-791

-917

-992

-672

-492

-506

-613

501

-693

-125

1,349

0

0

0

-

-

-

-

Net cash provided by (used in) operating activities

-

-

-12,792

-

-

-

-55,775

-82,440

-99,674

-98,347

-106,275

-99,336

-113,642

-108,559

-104,204

-87,864

0

0

0

CASH FLOWS FROM INVESTING ACTIVITIES:
Purchases of investments

0

0

0

-

-

-

-

80,519

92,162

110,775

134,328

102,631

0

0

0

-

-

-

-

Proceeds from sales of investments

-

-

-

-

-

-

-

13,156

0

0

0

-

-

-

-

-

-

-

-

Proceeds from maturities of investments

24,615

24,245

23,565

32,865

43,493

67,569

80,349

89,248

114,813

123,343

112,848

118,510

87,517

49,246

48,561

23,620

0

0

0

Purchases of property and equipment

3,418

4,685

5,034

5,223

6,117

7,709

11,640

12,781

12,531

12,477

9,935

12,839

15,765

12,716

11,160

6,276

0

0

0

Issuance of promissory note receivable

-

-

-

-

-

-

-

-

-

-

-

2,500

0

0

0

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-31

0

0

0

-

-

-

-

Net cash (used in) provided by investing activities

-

-

-7,000

-

-

-

73,768

9,093

17,425

7,587

-33,635

-2,970

-27,443

-66,709

-97,267

-72,798

0

0

0

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

24,789

24,567

24,778

19,464

15,630

9,202

9,197

9,466

10,486

13,783

14,716

10,417

9,708

4,529

2,797

2,580

0

0

0

Proceeds from exercise of warrants

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Tax withholding shares

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment of contingent consideration related to an acquisition

-

-

-

-

-

-

-

1,625

0

0

0

-

-

-

-

-

-

-

-

Payments of capital lease liability

-

-

392

-

-

-

237

172

0

0

0

-

-

-

-

-

-

-

-

Payment of fees for line of credit

408

329

79

79

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of preferred stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

149,547

0

0

0

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

-

-

-

-

-

-

-

88,153

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by financing activities

-

-

21,230

-

-

-

4,950

91,533

93,472

98,225

99,909

9,412

123,442

166,965

164,917

264,442

0

0

0

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

-

-

1,525

-

-

-

-518

-602

0

0

0

-

-

-

-

-

-

-

-

Net increase in cash, cash equivalents and restricted cash

-

-

2,963

-

-

-

22,425

17,584

10,740

7,047

-40,229

-93,336

-17,643

-8,303

-36,554

103,780

0

0

0

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

-

-

-

-

-

-

-

-

-

0

0

-

-

0

0

-

-

-

-