Splunk inc. (SPLK)
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'14Jan'14Oct'13Jul'13Apr'13Jan'13Oct'12Jul'12Apr'12Jan'12Oct'11Jul'11Apr'11
Cash flows from operating activities
Net Income (Loss) Available to Common Stockholders, Basic

-336,668

-311,814

-309,880

-312,507

-275,577

-244,536

-218,499

-193,593

-190,218

-289,861

-353,684

-361,688

-347,460

-360,307

-339,790

-308,482

-278,772

-256,477

-232,054

-237,547

-217,116

-192,719

-160,718

-113,629

-79,008

-52,539

-41,463

-32,345

-36,681

-31,795

-29,881

-29,216

-10,992

0

0

0

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

67,661

60,563

55,404

54,429

52,430

48,848

45,192

43,254

40,941

39,238

37,394

34,755

32,113

28,938

26,350

22,486

19,491

16,993

14,732

13,309

12,494

11,160

9,350

7,918

6,692

5,817

5,405

5,168

4,674

4,048

3,424

2,703

2,120

0

0

0

Amortization of deferred commissions

104,353

97,353

98,872

92,111

77,867

69,436

58,877

52,124

46,653

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of investment premiums, net (accretion of discounts)

9,553

10,860

9,851

7,426

4,743

1,966

620

134

-259

-593

-735

-799

-840

-903

-1,057

-1,229

-1,332

-1,372

-1,361

-1,136

-775

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of Debt Issuance Costs and Discounts

80,156

79,005

67,114

47,024

28,019

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

545,424

513,513

488,342

470,372

441,930

399,275

375,705

363,029

358,463

359,327

380,230

376,726

378,041

373,622

342,772

317,518

292,257

267,076

241,148

237,049

214,179

184,229

150,325

102,772

69,368

44,381

34,734

26,643

19,480

12,716

9,072

5,922

3,760

0

0

0

Deferred income taxes

-6,120

-4,093

-4,005

-4,283

-4,064

-7,072

-5,563

-4,482

-4,822

1,731

-158

-933

-326

-21,936

-21,747

-10,953

-11,140

10,296

10,465

-293

-327

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

Excess tax benefit from employee stock plans

-

-

-

-

-

-

-

-

-

-

-

-

682

430

1,249

1,100

874

734

631

834

847

920

951

719

351

1,001

730

573

462

0

0

0

-

-

-

-

Change in fair value of preferred stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

14,087

14,606

15,045

15,648

2,034

0

0

0

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

679,891

487,548

316,552

232,158

220,940

25,222

26,297

21,433

150,953

82,684

67,347

65,652

48,650

46,832

31,568

17,266

53,252

43,107

29,856

29,228

45,065

28,555

29,092

14,197

19,400

13,817

7,065

14,436

29,453

18,651

11,455

7,926

20,347

0

0

0

Prepaid expenses and other assets

78,582

120,283

81,442

-12,369

-6,970

99,894

59,665

61,853

45,611

26,099

30,432

24,664

25,726

19,083

10,970

3,117

-4,675

-6,387

308

12,135

11,284

1,225

-4,963

-728

6

1,919

4,682

2,599

2,377

2,561

2,063

2,125

3,511

0

0

0

Deferred commissions

149,426

134,230

140,339

139,221

130,485

113,008

95,794

81,196

76,756

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

-5,441

1,340

11,566

13,243

9,240

5,261

4,436

1,617

3,409

6,109

4,418

3,335

2,720

2,111

1,330

662

965

1,105

1,275

1,782

1,766

949

709

-361

171

722

-260

99

187

76

-1,408

166

55

0

0

0

Accrued compensation

58,898

31,815

46,831

62,871

81,213

65,435

38,915

11,037

44,484

32,358

28,915

26,933

4,194

5,147

7,739

14,654

30,026

29,080

19,310

16,746

21,344

17,826

15,324

8,928

15,753

4,940

3,183

9,506

11,981

15,521

10,652

6,484

8,697

0

0

0

Accrued expenses and other liabilities

-187

39,219

41,887

41,975

30,751

17,891

8,119

3,532

9,967

6,134

31,080

31,538

36,552

42,327

26,160

1,965

5,496

-215

-127

12,476

16,297

9,907

6,414

4,424

2,454

8,600

8,658

5,642

3,446

508

1,342

3,169

2,448

0

0

0

Deferred revenue

119,766

144,525

144,672

155,759

203,843

187,718

187,272

192,002

232,279

197,651

188,900

189,138

174,267

150,267

146,109

145,474

145,418

119,611

114,255

111,291

111,764

87,944

79,172

76,487

77,421

67,179

59,967

58,195

62,047

37,396

37,384

34,264

30,358

0

0

0

Net cash provided by operating activities

-287,636

-101,437

92,501

254,996

296,454

315,157

308,369

298,033

262,904

219,357

212,342

207,503

201,834

176,319

167,407

162,696

155,622

130,141

117,986

113,684

103,980

86,881

75,993

72,908

73,848

64,210

57,346

54,931

46,648

31,864

32,112

29,089

14,622

0

0

0

Cash flows from investing activities
Purchase of investments

1,086,317

1,115,273

1,450,944

1,376,402

1,109,852

938,122

503,696

546,164

645,762

677,908

707,956

663,473

683,787

785,198

577,943

462,883

480,610

348,628

735,952

730,341

820,710

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

Maturities of investments

1,080,812

1,034,983

948,557

878,438

754,138

698,601

696,396

698,545

687,485

672,910

653,165

635,120

605,175

569,775

565,920

495,765

522,645

528,145

424,000

352,000

192,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions, net of cash acquired

594,870

576,296

0

110,740

394,910

394,910

437,037

343,520

59,350

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment

101,119

61,507

41,736

35,764

23,160

21,749

19,848

17,194

20,503

32,061

39,612

47,245

45,349

54,055

56,358

48,626

51,332

27,246

16,028

16,127

13,950

13,243

13,224

12,283

9,308

10,622

8,833

8,463

9,077

7,804

7,744

8,972

8,180

0

0

0

Other investment activities

3,898

4,125

2,369

1,494

5,494

5,494

4,750

4,750

375

0

0

0

-

-

-

-

1,500

1,500

1,500

1,500

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-707,981

-722,218

-546,492

-645,962

-779,278

-661,674

-268,935

-213,083

-38,505

-96,409

-111,626

-79,098

-127,461

-272,978

-71,881

-158,437

-153,490

8,078

-472,173

-398,468

-645,160

-664,800

-334,415

-292,904

-39,046

-19,580

-8,319

-7,949

-8,563

-7,162

-7,616

-8,844

-8,052

0

0

0

Cash flows from financing activities
Proceeds from term debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,000

0

0

0

Proceeds from initial public offering, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

225,225

0

0

0

-

-

-

-

Proceeds from early exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,139

0

0

0

Proceeds from exercise of stock options

3,543

882

1,155

1,200

1,953

3,396

3,556

3,801

4,175

2,870

4,121

7,574

7,751

9,928

10,136

11,567

15,269

16,683

18,110

16,322

16,792

17,671

20,626

22,960

23,731

23,638

17,594

12,957

6,896

2,487

3,172

2,276

1,987

0

0

0

Taxes paid related to net share settlement of equity awards

164,160

226,750

180,283

131,597

63,369

49,958

79,500

106,147

137,830

129,003

125,994

124,438

113,707

73,355

46,822

21,731

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of financing obligation under sale leaseback

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

173

0

0

0

Repayment of financing lease obligation

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

2,289

2,525

2,759

2,942

711

0

0

0

Excess tax benefits from employee stock plans

-

-

-

-

-

-

-

-

-

-

-

-

682

430

1,249

1,100

874

734

631

834

847

920

951

719

351

1,001

730

573

462

0

0

0

-

-

-

-

Effect of exchange rate changes on cash and cash equivalents

-1,661

-157

-897

-664

-383

-661

-358

831

1,621

563

654

-444

294

-61

41

201

-391

-543

-797

-583

-568

-139

243

195

13

37

-19

9

20

0

0

0

-

-

-

-

Net increase (decrease) in cash and cash equivalents

-1,097,512

-994,646

1,252,324

1,353,403

1,330,218

1,474,802

-129

15,399

124,601

27,721

9,861

38,182

-3,195

-136,098

83,749

14,738

37,226

172,138

-319,198

-254,240

-510,138

-22,342

298,284

336,495

591,514

78,571

78,836

65,175

274,340

250,327

250,495

247,951

11,862

0

0

0

Net cash used in financing activities

-100,234

-170,834

1,707,212

1,745,033

1,813,425

1,821,980

-39,205

-70,382

-101,419

-95,790

-91,509

-89,779

-77,862

-39,378

-11,818

10,278

35,485

34,462

35,786

31,127

31,610

555,716

556,463

556,296

556,699

33,904

29,828

18,184

236,235

225,610

226,011

227,688

5,292

0

0

0

Supplemental disclosures
Cash paid for income taxes

17,413

17,638

17,853

12,816

6,639

7,162

6,632

6,356

6,480

5,548

5,178

4,294

3,021

2,894

2,428

1,909

1,408

1,138

1,201

1,087

1,080

1,070

829

791

490

335

364

299

118

0

0

0

-

-

-

-

Cash paid for interest

15,761

17,783

11,807

13,861

8,183

8,243

8,299

8,351

8,150

7,174

6,186

6,000

4,132

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

40

76

116

144

111

0

0

0

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

1,329

12,814

263

728

666

-626

235

1,155

132

-1,867

-2,111

-2,174

-1,121

91

386

-601

-775

923

-560

465

1,057

886

1,970

2,385

1,265

1,263

578

167

467

520

798

592

584

0

0

0

Vesting of early exercised options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

84

112

112

112

113

113

112

112

110

146

682

845

0

0

0

-

-

-

-

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

-

-

-

-

-

-

-

-

-

-

-

-

10,065

19,771

30,781

44,382

42,825

39,394

36,801

37,868

29,360

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Conversion of preferred stock to common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-