Qualys, inc. (QLYS)
CashFlow / Quarterly
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

18,694

20,664

19,174

16,232

13,266

14,400

23,469

10,293

9,142

2,856

8,452

7,202

21,930

5,907

4,996

3,538

4,783

5,424

4,123

3,316

3,002

25,913

3,105

1,657

-431

-38

1,309

873

-603

1,116

1,667

-277

-285

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

7,747

7,715

7,677

7,874

7,935

7,680

6,975

7,206

7,043

5,582

5,271

4,963

4,820

4,630

4,536

3,994

3,834

3,936

3,838

3,404

3,182

3,071

3,044

2,977

2,805

2,562

2,557

2,374

2,119

1,944

1,851

1,796

1,750

Accounts Receivable, Credit Loss Expense (Reversal)

0

91

70

-19

105

-

-

-

-

304

57

286

10

47

46

26

80

222

296

158

175

124

193

139

14

96

143

24

44

36

114

57

11

Bad debt expense

-148

-6

-379

183

0

22

-40

16

-7

-158

-1

0

-2

-16

0

-39

0

4

-5

0

-4

-323

0

-1

0

0

-3

-7

-2

-7

3

-2

-4

Stock-based compensation

9,997

-

-

-

8,445

-

-

-

8,891

8,439

7,743

6,447

4,332

5,027

5,103

5,322

4,697

4,816

4,421

4,382

3,875

3,449

2,494

2,480

2,126

1,698

1,621

1,238

949

869

1,027

880

676

Non-cash interest expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

6

9

9

Amortization of accretion of discounts on marketable securities

64

195

2,462

-1,640

580

550

755

-133

-36

-169

-305

-424

-426

-383

-227

-182

-208

-165

-105

-156

-168

-138

-102

-189

-136

-94

-73

-66

-49

-7

0

0

0

Deferred income taxes

1,784

-201

4,249

1,404

1,643

1,503

-4,705

541

140

14,913

3,266

1,662

-22,559

-1,371

1,016

1,001

-1,086

1,459

2,041

1,702

1,362

-22,552

-28

-11

-8

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

488

0

-8,368

3,868

1,119

618

3,095

172

124

100

91

128

77

37

17

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-5,190

16,811

-26,910

20,517

-7,962

17,267

-17,676

26,414

-14,538

18,283

52

5,006

-5,375

5,161

1,570

-2,002

169

4,671

3,620

-4,022

5,914

2,840

2,409

6,313

-6,680

3,655

2,237

3,920

-5,469

1,130

5,223

2,820

-5,159

Prepaid expenses and other assets

1,629

-473

13,348

-10,068

3,205

-763

9,806

-6,414

2,341

-352

-662

2,048

-981

911

1,113

656

-573

-1,132

1,609

-136

670

2,279

405

1,042

-270

-381

200

-75

-354

11

-1,420

885

388

Accounts payable

-262

260

-147

185

-1,374

3,333

513

-29

-302

252

-500

-461

255

-343

-875

-2,028

2,026

313

1,013

-1,010

-3,609

2,364

163

-283

88

839

-1,416

721

-244

319

-1,605

256

807

Accrued liabilities

253

-560

1,396

-453

332

-4,377

-435

1,661

4,577

738

638

-354

463

2,933

1,877

2,064

2,822

604

889

156

1,690

1,386

794

-11

-547

986

-1,719

344

826

557

-2,014

1,219

-734

Deferred revenues

10,577

12,647

3,016

2,542

9,855

12,374

7,927

2,094

2,330

12,114

6,769

2,935

8,012

7,050

6,616

2,178

2,059

10,766

4,701

-871

6,782

7,910

2,667

316

3,924

6,549

2,187

1,455

1,090

7,268

3,337

410

2,668

Other non-current liabilities

0

-160

7

190

-37

1,303

-778

46

-1,072

6,153

713

467

10

267

503

279

406

47

39

73

70

-318

25

26

66

535

59

-446

4

246

69

-252

-49

Net cash provided by operating activities

52,435

33,658

45,674

36,928

44,347

26,644

31,593

24,238

42,989

25,867

32,837

16,517

32,425

14,606

20,243

17,323

17,138

24,292

16,118

15,524

10,026

16,561

9,668

88

15,106

9,890

2,321

2,811

10,059

11,255

646

395

9,628

Cash flows from investing activities:
Purchases of marketable securities

85,567

71,845

444,115

-251,053

66,224

97,806

393,881

-224,001

72,176

101,025

96,201

42,464

60,201

42,792

92,797

37,914

49,450

58,013

27,252

29,661

31,781

40,381

40,372

29,456

47,451

31,574

38,641

15,132

59,916

-

-

-

-

Sales and maturities of marketable securities

129,651

64,476

70,604

102,224

91,046

66,359

98,027

80,758

40,080

83,971

36,737

47,550

63,738

16,000

58,552

22,980

52,176

32,169

25,126

22,237

25,977

13,121

79,258

23,898

41,062

24,600

12,900

35,315

65,309

-

-

-

-

Purchases of investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Sales and maturities of investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Purchases of property and equipment

7,271

8,100

33,611

-22,746

8,608

3,279

32,736

-19,225

5,985

11,206

13,433

8,636

4,543

4,436

9,843

4,785

4,181

5,186

4,458

4,259

6,148

3,718

3,672

2,722

3,802

3,286

4,126

2,588

3,650

3,096

2,115

3,062

2,927

Business combinations

0

2,200

3,700

-2,700

850

10,274

6,718

-3,359

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capitalized software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

118

0

0

0

99

98

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by investing activities

36,813

-17,669

-9,813

-22,911

15,364

-45,000

1,540

-12,005

-38,081

-34,989

-78,650

-3,550

-1,006

-31,228

-44,088

-19,601

-1,573

-31,030

-6,584

-11,683

-12,051

-31,076

35,214

-8,280

-10,191

-10,260

-29,867

17,709

1,743

-86,692

-2,115

-3,062

-2,927

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

4,714

13,817

2,023

4,944

4,047

3,157

8,722

4,241

7,933

8,549

8,175

9,001

5,602

2,628

3,033

7,383

2,113

3,501

1,047

2,099

3,448

2,627

1,959

1,797

1,256

699

1,211

1,345

818

-313

798

1,030

170

Payments for taxes related to net share settlement of equity awards

5,000

4,879

18,275

-10,778

3,367

2,869

20,945

-12,965

4,030

3,353

2,417

1,047

14,107

236

202

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

3,868

1,119

618

3,095

172

124

100

91

128

77

37

17

91

59

0

0

-

-

-

-

Principal payments under finance lease obligations

30

436

2,109

-1,255

419

414

1,997

-1,541

747

0

0

0

0

-

-

-

-

-

-

-

-

0

269

269

267

266

265

327

328

638

502

513

748

Repurchase of common stock

28,926

12,547

97,994

-31,988

7,871

38,498

65,898

-20,837

1,481

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-29,242

-4,045

-51,627

-15,763

-7,610

-38,624

-21,948

-18,586

1,675

5,196

5,758

7,954

-8,505

6,260

3,950

8,001

5,208

3,673

1,171

2,199

3,539

2,755

1,767

1,565

1,006

564

1,005

1,018

490

84,527

-1,264

517

-578

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-21

-36

3

6

57

40

-24

-72

-9

78

-37

-25

Net increase in cash, cash equivalents and restricted cash

60,006

11,944

-15,766

-1,746

52,101

-56,938

11,185

-6,395

6,583

-3,926

-40,055

20,921

22,914

-10,362

-19,895

5,723

20,773

-3,065

10,705

6,040

1,514

-11,781

46,613

-6,624

5,927

251

-26,501

21,514

12,220

9,081

-2,655

-2,187

6,098

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

-

-

-

-

-

-

-

-

-

501

543

160

380

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

-

-

-

-

-

-

-

-

-

1,394

178

-1,834

3,027

-

-4,773

7,379

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of assets under capital lease

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for income taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

154

130

501

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3

5

5

6

6

6

6

29

58

60

64

80

69

32

25

29