Aerohive networks, inc. (HIVE)
CashFlow / TTM
Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13
Cash flows from operating activities
Net Income (Loss) Attributable to Parent

-22,922

-19,672

-18,337

-16,697

-19,320

-20,305

-22,106

-26,560

-31,216

-34,811

-38,216

-36,693

-37,543

-40,957

-44,218

-43,640

-40,452

-35,894

-29,037

-30,363

-31,125

-31,836

-33,227

0

0

0

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

3,033

3,089

3,034

2,989

2,945

2,949

3,083

3,240

3,370

3,480

3,534

3,612

3,741

3,825

3,548

3,184

2,932

2,471

2,349

2,273

1,921

1,755

1,571

0

0

0

Stock-based compensation

14,366

14,797

14,883

14,800

15,933

16,793

16,675

17,898

19,349

20,359

21,702

21,765

20,535

19,445

18,371

17,316

14,933

12,508

10,252

8,089

6,243

5,147

4,287

0

0

0

Remeasurement of convertible preferred stock warrant liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,332

1,779

2,225

0

0

0

Other

-858

-988

-786

-583

-378

-235

-134

-47

24

140

278

362

306

205

378

0

0

0

-

-

-

-

-

-

-

-

Others

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

155

243

189

146

0

0

0

Changes in operating assets and liabilities:
Accounts receivable, net

-5,272

-670

-1,477

-2,376

-5,742

-2,154

-8,528

-5,286

-6,564

744

3,366

6,124

8,710

3,271

-1,871

-1,625

-2,870

1,767

7,115

5,506

4,359

812

4,859

0

0

0

Inventories

3,069

1,760

2,622

484

-3,748

1,890

866

-2,485

330

179

1,854

3,934

2,710

101

2,415

2,270

-118

5,059

1,544

3,955

6,531

-1,754

-32

0

0

0

Prepaid expenses and other current assets

234

383

3

-526

-180

-259

494

557

-4,901

-4,472

-1,398

-1,079

5,284

6,531

2,485

3,214

2,541

833

1,255

374

306

359

241

0

0

0

Operating lease right-of-use assets and other assets

-1,019

-343

105

74

58

-35

-87

10

-57

-373

-80

564

806

1,264

1,024

1,531

1,441

1,131

1,094

-336

59

53

-26

0

0

0

Accounts payable

2,182

340

4,027

5,107

-2,888

2,151

1,322

-3,477

-1,512

-4,723

-4,522

3,298

4,541

2,010

5,237

-114

-4,550

2,076

1,295

1,182

9,190

2,432

1,002

0

0

0

Accrued liabilities and other current liabilities

-1,781

-683

344

-402

66

-1,637

-701

-1,733

-8,029

-8,212

-2,643

-2,002

7,975

9,123

3,067

0

0

0

-

-

3,120

2,038

2,494

0

0

0

Operating lease liabilities, non-current and other liabilities

-355

-201

-8

13

85

144

126

118

252

412

425

415

-49

-290

-394

-2,573

172

215

165

2,320

-71

59

297

0

0

0

Deferred revenue

11,102

11,130

10,221

8,108

5,938

5,612

3,799

6,959

6,621

6,645

8,630

10,559

12,418

12,467

13,107

12,004

13,521

15,467

15,585

16,322

13,513

12,473

13,867

0

0

0

Net cash provided by operating activities

8,505

7,432

12,875

15,679

11,993

6,030

9,319

3,602

51

-12,788

-14,554

-8,227

-5,586

-5,339

-4,957

-13,479

-14,002

-9,972

-8,748

-8,297

-6,889

-5,434

-12,380

0

0

0

Cash flows from investing activities
Purchases of property and equipment

1,441

1,549

2,444

2,214

1,568

1,557

595

934

1,892

2,047

2,161

2,001

2,069

2,155

2,270

2,752

2,190

2,474

2,385

2,798

3,078

2,854

2,910

0

0

0

Capitalized software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,913

3,151

4,261

5,083

4,364

0

0

0

-

-

-

-

Maturities of short-term investments

105,483

94,502

86,652

91,101

80,201

78,900

60,150

54,761

57,961

50,761

50,761

28,098

13,898

6,698

2,498

0

0

0

-

-

-

-

-

-

-

-

Purchases of short-term investments

109,241

98,260

94,227

103,740

86,860

89,160

75,282

68,525

64,014

52,127

46,824

63,711

53,815

51,629

49,223

0

0

0

-

-

-

-

-

-

-

-

Investment in privately held company

-

-

-

-

-

-

-

-

-

-

1,500

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by investing activities

-5,199

-5,307

-10,019

-14,853

-8,227

-11,817

-15,727

-14,698

-7,945

-3,413

276

-39,114

-43,486

-48,710

-50,908

-5,903

-6,451

-7,557

-6,749

-5,924

-5,094

-3,924

-2,910

0

0

0

Cash flows from financing activities
Payment of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,007

0

0

0

-

-

-

-

Payment for deferred offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Proceeds from exercise of convertible preferred stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

907

907

1,599

1,599

692

0

0

0

Proceeds from exercise of vested stock options

-

-

-

-

-

-

-

-

-

-

-

1,169

1,011

1,290

1,524

1,685

1,472

1,085

1,721

1,348

1,714

1,778

1,169

0

0

0

Proceeds from early exercise of stock options, net of repurchases

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

813

0

0

0

Proceeds from employee stock option exercises and employee stock purchase plan

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for shares withheld for tax withholdings on vesting of restricted stock units

1,310

1,759

2,596

2,008

2,412

1,944

1,190

1,250

1,032

1,136

1,121

1,793

2,331

2,924

3,158

2,622

1,683

861

316

0

0

0

-

-

-

-

Payments for Repurchase of Common Stock

-

-

-

-

-

-

-

-

-

-

2,139

2,139

1,451

785

0

0

0

0

-

-

-

-

-

-

-

-

Payment on finance lease (capital lease prior to adoption of ASC 842)

191

191

188

197

193

185

182

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,000

10,000

10,000

10,000

0

0

0

0

-

-

-

-

Repayments of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,000

10,000

10,000

10,000

0

0

0

0

-

-

-

-

Repayments of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Net cash provided by (used in) financing activities

-1,900

-3,229

-4,056

-2,302

-3,412

-1,636

-689

1,145

3,176

3,720

2,883

3,052

3,044

2,777

3,562

1,334

1,905

76,886

78,518

86,571

87,871

21,758

20,728

0

0

0

Net increase in cash and cash equivalents

1,406

-1,104

-1,200

-1,476

354

-7,423

-7,097

-9,951

-4,718

-12,481

-11,395

-44,289

-46,028

-51,272

-52,303

-18,048

-18,548

59,357

63,021

72,350

75,888

12,400

5,438

0

0

0

Supplemental disclosure of cash flow information
Income taxes paid

240

189

158

167

232

297

360

426

450

516

666

660

554

525

519

459

561

528

420

350

586

436

406

0

0

0

Interest paid

757

806

765

709

664

618

576

544

502

471

484

503

529

515

984

1,288

1,505

1,764

1,428

1,188

966

712

540

0

0

0

Supplemental disclosure of noncash investing and financing activities
Cashless exercise of warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Unpaid property and equipment purchases

-294

102

222

367

686

240

66

-1,262

-1,782

130

205

1,453

1,679

-124

60

-33

469

211

312

0

0

0

-

-

-

-

Unpaid capitalized software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

94

262

369

595

439

0

0

0

-

-

-

-

Property and equipment purchased but not paid for

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Reclassification of the convertible preferred stock warrant liability to additional paid-in capital on the exercise of the convertible preferred stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,202

3,172

4,927

4,957

1,755

0

0

0

Vesting of early exercised stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

45

63

63

69

435

766

766

846

481

0

0

0

Offering costs for common stock not yet paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,142

5,650

2,090

0

0

0

Stock-based compensation in capitalized software development

-

-

-

-

-

-

-

-

-

-

-

-

-

-

257

461

597

645

445

0

0

0

-

-

-

-