Qualys, inc. (QLYS)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'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'13Dec'12Sep'12Jun'12Mar'12
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

74,764

69,336

63,072

67,367

61,428

57,304

45,760

30,743

27,652

40,440

43,491

40,035

36,371

19,224

18,741

17,868

17,646

15,865

36,354

35,336

33,677

30,244

4,293

2,497

1,713

1,541

2,695

3,053

1,903

2,221

0

0

0

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

31,013

31,201

31,166

30,464

29,796

28,904

26,806

25,102

22,859

20,636

19,684

18,949

17,980

16,994

16,300

15,602

15,012

14,360

13,495

12,701

12,274

11,897

11,388

10,901

10,298

9,612

8,994

8,288

7,710

7,341

0

0

0

Accounts Receivable, Credit Loss Expense (Reversal)

142

247

0

0

0

-

-

-

-

657

400

389

129

199

374

624

756

851

753

650

631

470

442

392

277

307

247

218

251

218

0

0

0

Bad debt expense

-350

-202

-174

165

-2

-9

-189

-150

-166

-161

-19

-18

-57

-55

-35

-40

-1

-5

-332

-327

-328

-324

-1

-4

-10

-12

-19

-13

-8

-10

0

0

0

Stock-based compensation

0

-

-

-

0

-

-

-

31,520

26,961

23,549

20,909

19,784

20,149

19,938

19,256

18,316

17,494

16,127

14,200

12,298

10,549

8,798

7,925

6,683

5,506

4,677

4,083

3,725

3,452

0

0

0

Non-cash interest expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15

24

0

0

0

Amortization of accretion of discounts on marketable securities

1,081

1,597

1,952

245

1,752

1,136

417

-643

-934

-1,324

-1,538

-1,460

-1,218

-1,000

-782

-660

-634

-594

-567

-564

-597

-565

-521

-492

-369

-282

-195

-122

-56

-7

0

0

0

Deferred income taxes

7,236

7,095

8,799

-155

-1,018

-2,521

10,889

18,860

19,981

-2,718

-19,002

-21,252

-21,913

-440

2,390

3,415

4,116

6,564

-17,447

-19,516

-21,229

-22,599

0

0

0

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-4,012

-3,381

-2,763

8,700

5,004

4,009

3,491

487

443

396

333

259

0

0

0

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

5,228

2,456

2,912

12,146

18,043

11,467

12,483

30,211

8,803

17,966

4,844

6,362

-646

4,898

4,408

6,458

4,438

10,183

8,352

7,141

17,476

4,882

5,697

5,525

3,132

4,343

1,818

4,804

3,704

4,014

0

0

0

Prepaid expenses and other assets

4,436

6,012

5,722

2,180

5,834

4,970

5,381

-5,087

3,375

53

1,316

3,091

1,699

2,107

64

560

-232

1,011

4,422

3,218

4,396

3,456

796

591

-526

-610

-218

-1,838

-878

-136

0

0

0

Accounts payable

36

-1,076

1,997

2,657

2,443

3,515

434

-579

-1,011

-454

-1,049

-1,424

-2,991

-1,220

-564

1,324

2,342

-3,293

-1,242

-2,092

-1,365

2,332

807

-772

232

-100

-620

-809

-1,274

-223

0

0

0

Accrued liabilities

636

715

-3,102

-4,933

-2,819

1,426

6,541

7,614

5,599

1,485

3,680

4,919

7,337

9,696

7,367

6,379

4,471

3,339

4,121

4,026

3,859

1,622

1,222

-1,291

-936

437

8

-287

588

-972

0

0

0

Deferred revenues

28,782

28,060

27,787

32,698

32,250

24,725

24,465

23,307

24,148

29,830

24,766

24,613

23,856

17,903

21,619

19,704

16,655

21,378

18,522

16,488

17,675

14,817

13,456

12,976

14,115

11,281

12,000

13,150

12,105

13,683

0

0

0

Other non-current liabilities

37

0

1,463

678

534

-501

4,349

5,840

6,261

7,343

1,457

1,247

1,059

1,455

1,235

771

565

229

-136

-150

-197

-201

652

686

214

152

-137

-127

67

14

0

0

0

Net cash provided by operating activities

168,695

160,607

153,593

139,512

126,822

125,464

124,687

125,931

118,210

107,646

96,385

83,791

84,597

69,310

78,996

74,871

73,072

65,960

58,229

51,779

36,343

41,423

34,752

27,405

30,128

25,081

26,446

24,771

22,355

21,924

0

0

0

Cash flows from investing activities:
Purchases of marketable securities

350,474

331,131

357,092

306,858

333,910

339,862

343,081

45,401

311,866

299,891

241,658

238,254

233,704

222,953

238,174

172,629

164,376

146,707

129,075

142,195

141,990

157,660

148,853

147,122

132,798

145,263

0

0

0

-

-

-

-

Sales and maturities of marketable securities

366,955

328,350

330,233

357,656

336,190

285,224

302,836

241,546

208,338

231,996

164,025

185,840

161,270

149,708

165,877

132,451

131,708

105,509

86,461

140,593

142,254

157,339

168,818

102,460

113,877

138,124

0

0

0

-

-

-

-

Purchases of investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Sales and maturities of investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Purchases of property and equipment

26,236

27,573

22,752

21,877

25,398

22,775

30,702

11,399

39,260

37,818

31,048

27,458

23,607

23,245

23,995

18,610

18,084

20,051

18,583

17,797

16,260

13,914

13,482

13,936

13,802

13,650

13,460

11,449

11,923

11,200

0

0

0

Business combinations

3,200

4,050

12,124

15,142

14,483

13,633

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capitalized software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

118

99

197

197

197

98

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by investing activities

-13,580

-35,029

-62,360

-51,007

-40,101

-93,546

-83,535

-163,725

-155,270

-118,195

-114,434

-79,872

-95,923

-96,490

-96,292

-58,788

-50,870

-61,348

-61,394

-19,596

-16,193

-14,333

6,483

-58,598

-32,609

-20,675

-97,107

-69,355

-90,126

-94,796

0

0

0

Cash flows from financing activities:
Proceeds from exercise of stock options

25,498

24,831

14,171

20,870

20,167

24,053

29,445

28,898

33,658

31,327

25,406

20,264

18,646

15,157

16,030

14,044

8,760

10,095

9,221

10,133

9,831

7,639

5,711

4,963

4,511

4,073

3,061

2,648

2,333

1,685

0

0

0

Payments for taxes related to net share settlement of equity awards

17,376

15,743

13,733

16,403

14,216

14,879

15,363

-3,165

10,847

20,924

17,807

15,592

14,545

438

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

8,700

5,004

4,009

3,491

487

443

396

333

259

222

204

167

150

0

0

0

-

-

-

-

Principal payments under finance lease obligations

1,320

1,709

1,687

1,575

1,289

1,617

1,203

-794

747

0

0

0

0

-

-

-

-

-

-

-

-

805

1,071

1,067

1,125

1,186

1,558

1,795

1,981

2,401

0

0

0

Repurchase of common stock

107,479

86,424

112,375

80,279

91,430

85,040

46,542

-19,356

1,481

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-100,677

-79,045

-113,624

-83,945

-86,768

-77,483

-33,663

-5,957

20,583

10,403

11,467

9,659

9,706

23,419

20,832

18,053

12,251

10,582

9,664

10,260

9,626

7,093

4,902

4,140

3,593

3,077

87,040

84,771

84,270

83,202

0

0

0

Effect of Exchange Rate on Cash and Cash Equivalents, Continuing Operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-48

30

106

79

1

-65

-27

-40

7

0

0

0

Net increase in cash, cash equivalents and restricted cash

54,438

46,533

-22,349

4,602

-47

-45,565

7,447

-43,793

-16,477

-146

-6,582

13,578

-1,620

-3,761

3,536

34,136

34,453

15,194

6,478

42,386

29,722

34,135

46,167

-26,947

1,191

7,484

16,314

40,160

16,459

10,337

0

0

0

Supplemental disclosures of cash flow information
Interest Paid, Excluding Capitalized Interest, Operating Activities

-

-

-

-

-

-

-

-

-

3

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for income taxes, net of refunds

-

-

-

-

-

-

-

-

-

1,584

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment recorded in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

2,765

0

0

4,465

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of assets under capital lease

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for income taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

19

22

23

24

47

99

153

211

262

273

245

206

155

0

0

0