Qualys, inc. (QLYS)
CashFlow / Yearly
Dec'19Dec'18Dec'17Dec'16Dec'15Dec'14Dec'13Dec'12Dec'11Dec'10
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

69,336

57,304

40,440

19,224

15,865

30,244

1,541

2,221

1,954

847

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

31,201

28,904

20,636

16,994

14,360

11,897

9,612

7,341

5,373

4,569

Accounts Receivable, Credit Loss Expense (Reversal)

247

86

657

199

851

470

307

218

193

117

Bad debt expense

-202

-9

-161

-55

-5

-324

-12

-10

-1

-13

Stock-based compensation

34,892

30,090

26,961

20,149

17,494

10,549

5,506

3,452

2,147

1,870

Non-cash interest expense

-

-

-

-

-

-

-

24

36

12

Amortization of accretion of discounts on marketable securities

1,597

1,136

-1,324

-1,000

-594

-565

-282

-7

0

0

Deferred income taxes

7,095

-2,521

-2,718

-440

6,564

-22,599

-66

27

-

-

Excess tax benefits from stock-based compensation

-

-

-

8,700

487

259

150

0

-

-

Impairment of intangible assets

-

-

-

-

255

0

0

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

2,456

11,467

17,966

4,898

10,183

4,882

4,343

4,014

6,651

1,166

Prepaid expenses and other assets

6,012

4,970

53

2,107

1,011

3,456

-610

-136

3,564

112

Restricted cash

-

-

-

-

0

0

-

-

-

-

Accounts payable

-1,076

3,515

-454

-1,220

-3,293

2,332

-100

-223

1,248

-82

Accrued liabilities

715

1,426

1,485

9,696

3,339

1,622

437

-972

2,752

-182

Deferred revenues

28,060

24,725

29,830

17,903

21,378

14,817

11,281

13,683

11,885

4,415

Income taxes payable

-

-

-

-

-

-

-

-

-

-488

Other non-current liabilities

0

-501

7,343

1,455

229

-201

152

14

1,816

83

Net cash provided by operating activities

160,607

125,464

107,646

69,310

65,960

41,423

25,081

21,924

17,190

9,896

Cash flows from investing activities:
Purchases of marketable securities

331,131

339,862

299,891

222,953

146,707

157,660

145,263

83,547

0

-

Sales and maturities of marketable securities

328,350

285,224

231,996

149,708

105,509

157,339

138,124

0

0

-

Purchases of investments

-

-

-

-

-

-

-

-

-

0

Purchases of property and equipment

27,573

22,775

37,818

23,245

20,051

13,914

13,650

11,200

7,499

1,510

Business combinations

4,050

13,633

12,482

0

0

-

-

-

-

-

Payments to Acquire Investments

625

-

-

-

-

-

-

-

-

-

Capitalized software development costs

-

-

0

0

99

98

0

0

-

-

Release of restricted cash

-

-

-

-

-

-

-114

0

0

-

Purchases of intangible assets

-

-

-

-

-

-

-

49

0

0

Net cash provided by investing activities

-35,029

-93,546

-118,195

-96,490

-61,348

-14,333

-20,675

-94,796

-7,499

-4,261

Cash flows from financing activities:
Proceeds from initial public offering, net of offering costs

-

-

-

-

-

-

-

84,534

0

0

Proceeds from exercise of stock options

24,831

24,053

31,327

15,157

10,095

7,639

4,073

1,685

948

522

Payments for taxes related to net share settlement of equity awards

15,743

14,879

20,924

438

0

0

-

-

128

0

Proceeds from early exercise of stock options

-

-

-

-

-

-

40

384

390

80

Excess tax benefits from stock-based compensation

-

-

-

8,700

487

259

150

0

0

-

Principal payments under finance lease obligations

1,709

1,617

0

0

-

805

1,186

2,401

1,476

1,149

Repurchase of common stock

86,424

85,040

0

0

-

-

-

-

-

-

Non-contingent payment related to acquisition

-

-

-

-

-

-

-

1,000

0

2,751

Non-contingent payment related to acquisition

-

-

-

-

-

-

-

-

-

0

Net cash used in financing activities

-79,045

-77,483

10,403

23,419

10,582

7,093

3,077

83,202

-10

-547

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

-

-

-

-

-

-48

1

7

-143

-27

Net increase in cash, cash equivalents and restricted cash

46,533

-45,565

-146

-3,761

15,194

34,135

7,484

10,337

9,538

5,061

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

107

168

3

-

6

9

43

162

128

163

Cash paid for income taxes, net of refunds

3,031

2,693

1,584

-

995

347

390

299

108

303

Business acquisitions recorded in Intangible Assets and Accrued liabilities

1,650

4,676

1,000

-

0

-

-

-

-

-

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

235

4,190

2,765

-

0

1,399

487

0

-

-

Purchase of property and equipment under capital lease

-

-

-

-

-

-

-

-

3,100

2,467

Stock-based compensation

-

-

-

-

19

47

262

155

52

32

Conversion of convertible preferred stock to common stock

-

-

-

-

-

-

-

63,873

0

0

Issuance of common stock for acquisition of business

-

-

-

-

-

-

-

-

-

77

Issuance of common stock for acquisition of license

-

-

-

-

-

-

-

51

0

0