Splunk inc. (SPLK)
CashFlow / Quarterly
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

-22,728

-57,639

-100,872

-155,429

2,126

-55,705

-103,499

-118,499

33,167

-29,668

-78,593

-115,124

-66,476

-93,491

-86,597

-100,896

-79,323

-72,974

-55,289

-71,186

-57,028

-48,551

-60,782

-50,755

-32,631

-16,550

-13,693

-16,134

-6,162

-5,474

-4,575

-20,470

-1,276

-3,560

-3,910

-2,246

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

21,582

18,938

13,726

13,415

14,484

13,779

12,751

11,416

10,902

10,123

10,813

9,103

9,199

8,279

8,174

6,461

6,024

5,691

4,310

3,466

3,526

3,430

2,887

2,651

2,192

1,620

1,455

1,425

1,317

1,208

1,218

931

691

584

497

348

Amortization of deferred commissions

29,275

21,196

23,850

30,032

22,275

22,715

17,089

15,788

13,844

12,156

10,336

10,317

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of investment premiums, net (accretion of discounts)

1,584

2,324

2,786

2,859

2,891

1,315

361

176

114

-31

-125

-217

-220

-173

-189

-258

-283

-327

-361

-361

-323

-316

-136

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of Debt Issuance Costs and Discounts

20,679

20,382

20,090

19,005

19,528

8,491

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

166,496

132,852

123,013

123,063

134,585

107,681

105,043

94,621

91,930

84,111

92,367

90,055

92,794

105,014

88,863

91,370

88,375

74,164

63,609

66,109

63,194

48,236

59,510

43,239

33,244

14,332

11,957

9,835

8,257

4,685

3,866

2,672

1,493

1,041

716

510

Deferred income taxes

-6,518

214

164

20

-4,491

302

-114

239

-7,499

1,811

967

-101

-946

-78

192

506

-22,556

111

10,986

319

-1,120

280

228

285

-

-

32

88

-

-

-

-

-

-

-

-

Excess tax benefit from employee stock plans

-

-

-

-

-

-

-

-

-

-

-

-

131

-476

335

692

-121

343

186

466

-261

240

389

479

-188

271

157

111

462

0

0

0

-

-

-

-

Change in fair value of preferred stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

14,087

519

439

603

473

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

514,156

226,485

123,608

-184,358

321,813

55,489

39,214

-195,576

126,095

56,564

34,350

-66,056

57,826

41,227

32,655

-83,058

56,008

25,963

18,353

-47,072

45,863

12,712

17,725

-31,235

29,353

13,249

2,830

-26,032

23,770

6,497

10,201

-11,015

12,968

-699

6,672

1,406

Prepaid expenses and other assets

-111,455

79,688

92,449

17,900

-69,754

40,847

-1,362

23,299

37,110

618

826

7,057

17,598

4,951

-4,942

8,119

10,955

-3,162

-12,795

327

9,243

3,533

-968

-524

-816

-2,655

3,267

210

1,097

108

1,184

-12

1,281

-390

1,246

1,374

Deferred commissions

64,965

31,247

29,762

23,452

49,769

37,356

28,644

14,716

32,292

20,142

14,046

10,276

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

-4,312

-6,445

2,391

2,925

2,469

3,781

4,068

-1,078

-1,510

2,956

1,249

714

1,190

1,265

166

99

581

484

-502

402

721

654

5

386

-96

414

-1,065

918

455

-568

-706

1,006

344

-2,052

868

895

Accrued compensation

71,719

33,394

16,562

-62,777

44,636

48,410

32,602

-44,435

28,858

21,890

4,724

-10,988

16,732

18,447

2,742

-33,727

17,685

21,039

9,657

-18,355

16,739

11,269

7,093

-13,757

13,221

8,767

697

-6,932

2,408

7,010

7,020

-4,457

5,948

2,141

2,852

-2,244

Accrued expenses and other liabilities

-19,153

1,571

20,511

-3,116

20,253

4,239

20,599

-14,340

7,393

-5,533

16,012

-7,905

3,560

19,413

16,470

-2,891

9,335

3,246

-7,725

640

3,624

3,334

4,878

4,461

-2,766

-159

2,888

2,491

3,380

-101

-128

295

442

733

1,699

-426

Deferred revenue

150,609

40,846

527

-72,216

175,368

40,993

11,614

-24,132

159,243

40,547

16,344

16,145

124,615

31,796

16,582

1,274

100,615

27,638

15,947

1,218

74,808

22,282

12,983

1,691

50,988

13,510

10,298

2,625

40,746

6,298

8,526

6,477

16,095

6,286

5,406

2,571

Net cash provided by operating activities

-58,831

-134,863

-128,971

35,029

127,368

59,075

33,524

76,487

146,071

52,287

23,188

41,358

102,524

45,272

18,349

35,689

77,009

36,360

13,638

28,615

51,528

24,205

9,336

18,911

34,429

13,317

6,251

19,851

24,791

6,453

3,836

11,568

10,007

6,701

813

-2,899

Cash flows from investing activities
Purchase of investments

270,632

275,962

250,298

289,425

299,588

611,633

175,756

22,875

127,858

177,207

218,224

122,473

160,004

207,255

173,741

142,787

261,415

0

58,681

160,514

129,433

387,324

53,070

250,883

-

-

0

0

-

-

-

-

-

-

-

-

Maturities of investments

274,841

264,376

243,170

298,425

229,012

177,950

173,051

174,125

173,475

175,745

175,200

163,065

158,900

156,000

157,155

133,120

123,500

152,145

87,000

160,000

129,000

48,000

15,000

0

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions, net of cash acquired

18,574

576,296

0

0

0

0

110,740

284,170

0

42,127

17,223

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment

47,595

27,090

11,534

14,900

7,983

7,319

5,562

2,296

6,572

5,418

2,908

5,605

18,130

12,969

10,541

3,709

26,836

15,272

2,809

6,415

2,750

4,054

2,908

4,238

2,043

4,035

1,967

1,263

3,357

2,246

1,597

1,877

2,084

2,186

2,825

1,085

Other investment activities

148

2,500

875

375

375

744

0

4,375

375

0

0

0

-

-

-

-

0

0

0

1,500

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-64,697

-617,472

-19,537

-6,275

-78,934

-441,746

-119,007

-139,591

38,670

-49,007

-63,155

34,987

-19,234

-64,224

-30,627

-13,376

-164,751

136,873

-117,183

-8,429

-3,183

-343,378

-43,478

-255,121

-22,823

-12,993

-1,967

-1,263

-3,357

-1,732

-1,597

-1,877

-1,956

-2,186

-2,825

-1,085

Cash flows from financing activities
Proceeds from term debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,000

2,000

Proceeds from initial public offering, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-1,287

226,512

-

-

-

-

Proceeds from early exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

404

0

500

235

Proceeds from exercise of stock options

2,919

68

196

360

258

341

241

1,113

1,701

501

486

1,487

396

1,752

3,939

1,664

2,573

1,960

5,370

5,366

3,987

3,387

3,582

5,836

4,866

6,342

5,916

6,607

4,773

298

1,279

546

364

983

383

257

Taxes paid related to net share settlement of equity awards

0

46,467

48,686

69,007

62,590

0

0

779

49,179

29,542

26,647

32,462

40,352

26,533

25,091

21,731

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of financing obligation under sale leaseback

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

31

50

31

61

Repayment of financing lease obligation

-

0

0

0

-

644

629

589

-

497

485

317

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

2,289

236

234

183

58

Excess tax benefits from employee stock plans

-

-

-

-

-

-

-

-

-

-

-

-

131

-476

335

692

-121

343

186

466

-261

240

389

479

-188

271

157

111

462

0

0

0

-

-

-

-

Effect of exchange rate changes on cash and cash equivalents

-109

199

-708

-1,043

1,395

-541

-475

-762

1,117

-238

714

28

59

-147

-384

766

-296

-45

-224

174

-448

-299

-10

189

-19

83

-58

7

5

27

-30

18

-

-

-

-

Net increase (decrease) in cash and cash equivalents

-94,817

-798,535

-163,224

-40,936

8,049

1,448,435

-62,145

-64,121

152,633

-26,496

-46,617

45,081

55,753

-44,356

-18,296

3,704

-77,150

175,491

-87,307

26,192

57,762

-315,845

-22,349

-229,706

545,558

4,781

15,862

25,313

32,615

5,046

2,201

234,478

8,602

5,214

-343

-1,611

Net cash used in financing activities

28,820

-46,399

-14,008

-68,647

-41,780

1,831,647

23,813

-255

-33,225

-29,538

-7,364

-31,292

-27,596

-25,257

-5,634

-19,375

10,888

2,303

16,462

5,832

9,865

3,627

11,803

6,315

533,971

4,374

11,636

6,718

11,176

298

-8

224,769

551

699

1,669

2,373

Supplemental disclosures
Cash paid for income taxes

784

1,380

6,933

8,316

1,009

1,595

1,896

2,139

1,532

1,065

1,620

2,263

600

695

736

990

473

229

217

489

203

292

103

482

193

51

65

181

38

80

0

0

-

-

-

-

Cash paid for interest

0

8,014

0

7,747

2,022

2,038

2,054

2,069

2,082

2,094

2,106

1,868

1,106

1,106

1,920

0

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

40

36

40

28

7

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

-10,524

12,127

-1,127

853

961

-424

-662

791

-331

437

258

-232

-2,330

193

195

821

-1,118

488

-792

647

580

-995

233

1,239

409

89

648

119

407

-596

237

419

460

-318

31

411

Vesting of early exercised options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

28

28

28

28

28

28

29

28

27

28

27

64

563

191

-

-

-

-

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

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

10,065

9,706

11,010

13,601

8,508

6,275

8,417

14,668

0

-

-

-

-

-

-

-

-

-

-

-

-

Conversion of preferred stock to common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

40,913

-

-

-

-