Splunk inc. (SPLK)
CashFlow / Yearly
Jan'20Jan'19Jan'18Jan'17Jan'16Jan'15Jan'14Jan'13Jan'12Jan'11
Cash flows from operating activities
Net Income (Loss) Available to Common Stockholders, Basic

-336,668

-275,577

-190,218

-347,460

-278,772

-217,116

-79,008

-36,681

-10,992

-3,806

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

67,661

52,430

40,941

32,113

19,491

12,494

6,692

4,674

2,120

958

Amortization of deferred commissions

104,353

77,867

46,653

34,079

-

-

-

-

-

-

Amortization of investment premiums, net (accretion of discounts)

9,553

4,743

-259

-840

-1,332

-775

0

0

-

-

Amortization of Debt Issuance Costs and Discounts

80,156

28,019

0

0

-

-

-

-

-

-

Stock-based compensation

545,424

441,930

358,463

378,041

292,257

214,179

69,368

19,480

3,760

1,585

Disposal of property and equipment

-1,974

0

0

-

-

-

-

-

-

-

Deferred income taxes

-6,120

-4,064

-4,822

-326

-11,140

-327

-1,374

-281

0

-

Excess tax benefit from employee stock plans

-

-

-

682

874

847

351

462

0

-

Non-cash facility exit adjustment

0

0

-5,200

8,625

0

0

-

-

-

-

Accelerated depreciation of property and equipment

-

-

-

2,739

0

0

-

-

-

-

Impairment of long-lived asset

-

-

-

-

-

-

2,128

0

0

-

Change in fair value of preferred stock warrants

-

-

-

-

-

-

-

14,087

2,034

366

Changes in operating assets and liabilities, net of acquisitions
Accounts receivable

679,891

220,940

150,953

48,650

53,252

45,065

19,400

29,453

20,347

7,558

Prepaid expenses and other assets

78,582

-6,970

45,611

25,726

-4,675

11,284

6

2,377

3,511

891

Deferred commissions

149,426

130,485

76,756

49,492

-

-

-

-

-

-

Accounts payable

-5,441

9,240

3,409

2,720

965

1,766

171

187

55

535

Accrued compensation

58,898

81,213

44,484

4,194

30,026

21,344

15,753

11,981

8,697

5,126

Accrued expenses and other liabilities

-187

30,751

9,967

36,552

5,496

16,297

2,454

3,446

2,448

1,074

Deferred revenue

119,766

203,843

232,279

174,267

145,418

111,764

77,421

62,047

30,358

10,990

Net cash provided by operating activities

-287,636

296,454

262,904

201,834

155,622

103,980

73,848

46,648

14,622

8,379

Cash flows from investing activities
Purchase of investments

1,086,317

1,109,852

645,762

683,787

480,610

820,710

0

0

-

-

Maturities of investments

1,080,812

754,138

687,485

605,175

522,645

192,000

0

0

-

-

Acquisitions, net of cash acquired

594,870

394,910

59,350

0

142,693

2,500

29,738

0

0

-

Change in restricted cash

-

-

-

-

-

-

-

-514

-128

-161

Purchases of property and equipment

101,119

23,160

20,503

45,349

51,332

13,950

9,308

9,077

8,180

1,471

Capitalized software development costs

2,589

0

0

-

-

-

-

-

-

-

Other investment activities

3,898

5,494

375

3,500

1,500

0

0

-

-

-

Net cash used in investing activities

-707,981

-779,278

-38,505

-127,461

-153,490

-645,160

-39,046

-8,563

-8,052

-1,310

Cash flows from financing activities
Proceeds from term debt

-

-

-

-

-

-

-

-

3,000

-

Proceeds from initial public offering, net of offering costs

-

-

-

-

-

-

-

225,225

0

-

Proceeds from exercise of warrant

-

-

-

-

-

-

-

631

50

-

Proceeds from early exercise of employee stock options

-

-

-

-

-

-

-

-

1,139

108

Proceeds from exercise of stock options

3,543

1,953

4,175

7,751

15,269

16,792

23,731

6,896

1,987

930

Proceeds from employee stock purchase plan

60,383

46,342

34,044

27,412

19,342

14,494

11,434

5,310

0

-

Proceeds from the issuance of convertible senior notes, net of issuance costs

0

2,110,000

0

0

-

-

-

-

-

-

Purchase of capped calls

0

274,275

0

0

-

-

-

-

-

-

Proceeds from follow-on offering, net of offering costs

-

-

-

-

-

-

539,339

0

0

-

Taxes paid related to net share settlement of equity awards

164,160

63,369

137,830

113,707

0

0

18,156

0

0

-

Payments of financing obligation under sale leaseback

-

-

-

-

-

-

-

-

173

175

Repayment of financing lease obligation

-

-

-

-

-

-

-

2,289

711

-

Repayment of financing lease obligation

0

2,522

1,808

0

0

523

0

0

-

-

Excess tax benefits from employee stock plans

-

-

-

682

874

847

351

462

0

-

Effect of exchange rate changes on cash and cash equivalents

-1,661

-383

1,621

294

-391

-568

13

20

0

-

Net increase (decrease) in cash and cash equivalents

-1,097,512

1,330,218

124,601

-3,195

37,226

-510,138

591,514

274,340

11,862

7,932

Net cash used in financing activities

-100,234

1,813,425

-101,419

-77,862

35,485

31,610

556,699

236,235

5,292

863

Supplemental disclosures
Cash paid for income taxes

17,413

6,639

6,480

3,021

1,408

1,080

490

118

0

-

Cash paid for interest

15,761

8,183

8,150

4,132

0

-

-

40

111

16

Non-cash investing and financing activities
Increase (decrease) in accrued purchases of property and equipment

1,329

666

132

-1,121

-775

1,057

1,265

467

584

143

Equity consideration for acquisitions

364,275

0

0

-

-

-

-

-

-

-

Conversion of preferred stock to common stock

-

-

-

-

-

-

-

40,913

0

-

Vesting of early exercised options

784

0

0

-

-

112

112

845

128

32

Conversion of warrant liability to Series A convertible preferred stock upon exercise of warrant

-

-

-

-

-

-

-

-

914

-

Increase in capitalized construction costs related to build-to-suit lease

-

-

-

10,065

42,825

29,360

0

0

-

-