Box, inc. (BOX)
CashFlow / TTM
Jan'20Oct'19Jul'19Apr'19Jan'19Oct'18Jul'18Apr'18Jan'18Oct'17Jul'17Apr'17Jan'17Oct'16Jul'16Apr'16Jan'16Oct'15Jul'15Apr'15Jan'15Oct'14Jul'14Apr'14
CASH FLOWS FROM OPERATING ACTIVITIES:
Net loss

-144,348

-133,652

-132,952

-134,803

-134,612

-147,583

-150,311

-151,511

-154,960

-159,172

-154,481

-153,298

-151,787

-165,283

-182,167

-194,240

-202,948

-199,308

-189,612

-176,999

-168,227

0

0

0

Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization

59,424

53,745

49,140

47,550

46,320

45,539

44,019

41,935

40,112

37,889

36,686

37,642

40,154

42,942

44,168

43,312

40,394

38,034

35,721

32,289

29,019

0

0

0

Stock-based compensation expense

145,988

137,135

131,167

125,045

119,296

114,035

107,768

101,152

97,485

95,838

90,232

85,229

78,372

71,727

67,214

62,878

59,504

52,432

45,541

38,892

31,929

0

0

0

Amortization of deferred commissions

25,922

23,452

21,318

19,287

17,323

17,956

18,833

20,161

21,476

20,384

19,242

18,479

18,260

17,941

17,664

16,981

15,816

14,744

13,775

12,827

12,079

0

0

0

Loss on disposal of property and equipment

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Remeasurement of redeemable convertible preferred stock warrant liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-126

0

0

0

Release of deferred tax valuation allowance

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

Other

194

98

123

122

-4

31

137

144

101

65

-72

-28

-114

-628

-1,072

-1,199

-1,089

-409

-65

-119

-278

0

0

0

Changes in operating assets and liabilities
Accounts receivable, net

34,304

2,679

3,124

2,630

12,415

9,264

6,306

7,676

42,020

9,873

32,721

25,152

20,571

21,627

21,123

19,064

45,368

24,477

17,918

6,450

11,487

0

0

0

Deferred commissions

43,962

41,075

39,211

38,921

37,561

35,955

30,818

28,065

26,133

23,209

22,260

20,574

20,047

19,902

19,964

21,169

21,725

18,397

18,405

16,211

16,187

0

0

0

Operating lease right-of-use assets, net

35,449

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

7,108

3,705

4,905

4,181

4,999

3,827

1,431

5,100

2,441

2,617

3,693

-2,373

-4,687

-3,937

-3,832

-2,511

25,717

25,560

25,105

28,693

2,521

0

0

0

Accounts payable

-100

-2,300

6,145

-2,007

1,655

2,185

-1,366

193

6,900

1,307

6,252

5,823

-1,093

-3,832

-13,174

-4,022

-4,022

2,855

11,381

2,183

3,231

0

0

0

Accrued expenses and other liabilities

-5,851

6,343

3,784

10,675

-2,172

7,948

4,760

2,427

16,134

2,494

6,286

6,696

-9,035

-2,933

-2,834

-7,758

17,943

11,485

15,049

12,243

6,952

0

0

0

Operating lease liabilities

35,058

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred rent

-

-

-

-

-

-

-

-

-

3,040

2,051

1,006

2,986

13,877

31,069

33,019

32,357

20,819

2,982

2,445

1,292

0

0

0

Deferred revenue

48,808

24,406

29,317

43,496

63,932

58,049

70,492

72,448

78,939

60,408

57,835

52,131

55,571

51,451

52,655

47,983

66,356

40,467

37,755

35,251

29,985

0

0

0

Net cash provided by operating activities

44,713

61,031

58,954

62,372

55,321

46,506

53,784

45,290

35,391

26,424

5,501

10,383

-2,389

-11,074

-21,588

-38,370

-66,321

-86,775

-88,995

-93,614

-84,900

0

0

0

CASH FLOWS FROM INVESTING ACTIVITIES:
Sales of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

78,427

0

0

0

-

0

0

-

Purchases of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

112,521

0

0

0

-

0

0

-

Maturities of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

7,057

13,282

26,774

32,956

26,370

0

0

0

-

0

0

-

Purchases of property and equipment

5,452

6,416

10,608

12,382

14,808

19,635

17,391

15,078

11,822

6,117

5,006

4,764

14,956

38,736

56,842

74,014

72,939

56,759

44,271

42,621

38,681

0

0

0

Capitalized internal-use software costs

7,957

7,825

0

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of property and equipment

8

6

7

4

2

78

79

81

107

34

40

110

87

157

149

77

73

0

0

0

-

-

-

-

Acquisitions

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-13,296

-12,436

-15,501

-15,009

-16,151

-21,358

-17,770

-14,997

-11,715

-6,083

-4,966

-3,943

-7,572

-13,541

44,846

28,033

-80,861

-82,495

-146,608

-146,202

-38,883

0

0

0

CASH FLOWS FROM FINANCING ACTIVITIES:
Acquisitions and purchases of intangible assets, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

271

371

420

0

-

0

0

-

Proceeds from borrowings, net of borrowing costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

Principal payments on borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

Proceeds from issuance of redeemable convertible preferred stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

Payment of initial public offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Payment of borrowing costs

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

Proceeds from exercise of stock options

5,965

4,358

5,739

14,163

16,326

20,099

21,956

15,444

14,538

12,898

12,284

11,296

11,086

9,470

8,816

8,465

7,015

8,313

6,325

5,235

6,016

0

0

0

Proceeds from issuances of common stock under employee stock purchase plan

23,425

23,425

23,620

23,620

21,861

21,861

20,486

20,486

17,521

17,521

15,591

15,591

15,726

15,726

19,298

19,298

10,282

0

0

0

-

0

-

-

Employee payroll taxes paid related to net share settlement of restricted stock units

43,328

41,978

44,080

45,120

43,824

45,458

45,146

38,957

34,776

30,177

23,619

21,898

17,552

15,738

13,117

10,989

10,436

8,292

6,187

0

-

0

0

-

Principal payments of finance lease liabilities

38,542

32,938

30,173

25,934

23,930

20,551

21,042

19,466

16,052

15,929

13,326

11,462

8,675

6,547

4,877

2,757

2,036

928

420

0

-

0

0

-

Acquisition related contingent consideration

-

-

0

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-53,416

-48,069

-45,830

-33,271

-29,567

-24,119

-23,816

-23,554

-19,830

-16,691

-10,074

-6,486

479

2,678

9,887

12,945

2,513

193,760

178,098

340,617

345,439

0

0

0

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

-171

22

-98

-122

-273

-87

-52

255

408

-2

74

-124

-39

42

67

95

-26

-65

-94

-80

-71

0

0

0

Net (decrease) increase in cash, cash equivalents, and restricted cash

-22,170

548

-2,475

13,970

9,330

942

12,146

6,994

4,254

3,648

-9,465

-170

-9,521

-21,895

33,212

2,703

-144,695

24,425

-57,599

100,721

221,585

0

0

0

SUPPLEMENTAL DISCLOSURE OF CASH FLOW INFORMATION:
Cash paid for interest, net of amounts capitalized

5,549

4,558

3,923

3,152

2,585

2,315

2,219

2,098

1,936

1,813

1,336

1,425

1,235

1,072

1,319

1,057

1,183

1,349

1,403

1,252

1,099

0

0

0

Cash paid for income taxes, net of tax refunds

2,835

2,825

2,359

2,183

1,600

1,594

1,518

1,575

1,259

1,186

856

666

239

211

248

492

832

832

750

491

157

0

0

0

SUPPLEMENTAL DISCLOSURE OF NONCASH INVESTING AND FINANCING ACTIVITIES:
Accrued equipment purchases

3,123

-7,423

-698

2,654

3,735

25,924

17,078

14,729

8,711

721

2,654

-1,580

-13,260

-25,334

-9,906

720

10,766

21,280

8,151

-10,221

2,110

0

0

0

Increase in long-lived assets resulting from capitalizing asset retirement costs

2,717

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of redeemable convertible preferred shares

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

Stock-based compensation capitalized in internal-use software costs

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Increase in finance lease liabilities

103,420

108,198

76,898

62,357

50,999

32,307

29,271

26,778

26,431

35,424

37,620

37,210

31,849

24,066

18,983

15,756

13,138

7,372

4,065

0

-

0

0

-

Change in unpaid tax related to capital lease

-

-

-

-

-

-

-

-

-

1,164

1,526

1,954

-

0

0

0

-

0

0

0

-

-

-

-

Change in unpaid taxes related to net share settlement of restricted stock units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

0

0

-

-

-

-

Issuance of common stock in connection with acquisitions

-

-

-

-

-

-

0

-

-

-

-

-

-

0

-

-

6,108

6,108

10,413

0

-

0

0

-

Contingent consideration accruals in connection with acquisitions

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Timing of settlement of stock options exercise

-

-

-

0

-

-

0

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

CASH, CASH EQUIVALENTS, AND RESTRICTED CASH INFORMATION:
Vesting of early exercised stock options and restricted stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

98

127

0

0

0

-

-

-

0

Change in unpaid deferred offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-2,172

-528

-496

-505

417

0

0

0