Qad inc (QADA)
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 (loss) income

410

125

-13,250

-3,234

4,936

2,982

1,113

1,397

-5,172

-161

-1,161

-2,571

-15,159

1,533

968

-2,792

4,146

2,586

1,631

549

6,947

5,090

985

-76

4,346

2,049

1,254

-1,263

2,011

1,825

959

1,844

3,684

3,010

3,070

1,020

Adjustments to reconcile net (loss) income to net cash provided by operating activities:
Depreciation and amortization

1,667

1,675

1,577

1,493

1,417

1,401

1,337

1,362

1,371

1,430

1,449

1,522

1,516

1,527

1,527

1,476

1,461

1,437

1,433

1,454

1,475

1,443

1,422

1,419

1,612

1,441

1,543

1,473

1,350

1,278

1,246

1,115

1,086

1,192

1,106

1,337

Amortization of costs capitalized to obtain and fulfill contracts

1,154

1,140

1,088

1,073

1,069

1,056

1,047

1,004

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts and sales adjustments

-171

529

194

-67

826

428

228

270

346

488

74

113

80

157

-49

49

151

191

121

311

319

331

45

159

337

386

150

181

413

260

100

-36

574

436

77

73

Amortization of right-of-use assets

1,504

1,495

1,509

1,456

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

927

151

-

-133

-10

143

-10

1

30

51

291

48

72

51

9

13

7

4

Net change in valuation allowance

-

-

-

-809

-

-

-

-1,416

2,487

-1,225

-1,850

-1,107

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other deferred income taxes

-6,495

-21

-18

37

-3,853

825

-2,702

1,053

2,394

-1,356

-1,820

-1,389

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of a derivative instrument

-16

-101

-160

-91

-249

46

35

117

274

106

-16

13

454

243

-181

-31

-212

-187

106

245

-556

-214

-61

-46

85

-159

995

-287

361

112

-857

0

-

-

-

-

Stock compensation expense

2,958

2,904

3,188

2,304

2,504

2,148

3,364

2,106

2,253

2,311

2,592

1,768

1,802

1,820

2,093

1,608

1,822

1,881

2,431

1,306

1,199

1,209

1,709

876

966

1,220

1,550

944

1,002

1,139

1,428

1,039

1,005

1,228

1,162

1,112

Other, net

12

-2

-5

-64

-

-

-

-3

-

-

-

-

-

-

-

-

-

-

-

-

-

-10

-20

-12

-

-1

12

-12

-

-

-

0

156

13

80

59

Changes in assets and liabilities, net of effects from acquisitions:
Accounts receivable

41,266

-1,154

-7,155

-32,033

35,438

-6,890

-1,490

-25,543

31,647

9,025

-4,860

-23,250

30,635

-6,082

1,018

-21,430

24,713

-4,234

-4,460

-26,823

34,540

-4,828

1,846

-20,322

27,756

1,762

102

-28,373

31,281

3,727

-8,597

-19,644

25,132

140

-42,624

17,780

Costs capitalized to obtain and fulfill contracts

2,303

1,331

1,231

927

1,620

818

927

765

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease liabilities

1,500

1,482

1,511

1,584

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

-

-

-

1,753

-

-

-

3,692

-

-876

-976

-171

-1,602

-1,218

-54

2,964

4,728

-1,212

-1,870

1,122

-611

790

-841

1,093

2,288

-1,523

-2,058

1,490

2,880

-945

-2,112

1,845

1,515

69

-2,046

-151

Accounts payable

4,199

-2,138

-532

-1,378

-866

-23

1,979

-5,459

3,802

1,599

699

-3,279

3,744

420

-367

-3,151

2,672

361

-18

-4,456

3,937

466

1,479

-3,314

3,580

-582

55

-4,313

4,694

-35

635

-3,152

3,603

-369

-647

-2,816

Deferred revenue

37,496

-12,715

-9,281

-9,426

34,008

-9,294

-10,663

-11,020

30,840

-5,852

-10,364

-7,623

30,988

-10,728

-5,535

-7,480

28,912

-12,403

-8,027

-11,157

32,856

-14,530

-5,341

-8,073

26,095

-8,428

-5,977

-6,937

28,644

-6,917

-7,583

-8,475

20,809

-8,663

-7,397

-6,430

Other liabilities

6,455

1,285

126

-6,796

4,764

-389

3,194

-9,316

9,342

3,737

573

-5,174

4,868

1,659

2,805

-6,850

4,528

234

1,953

-8,976

6,469

1,162

2,902

-6,957

5,405

2,519

1,283

-4,943

1,777

4,740

-1,993

-4,996

3,679

3,146

1,402

-6,653

Net cash provided by operating activities

9,296

-6,477

-17

14,195

3,890

5,971

5,361

3,785

7,574

-4,794

-244

7,882

13,209

3,451

663

1,357

13,892

1,008

4,821

4,336

18,932

-434

2,287

3,178

12,565

-1,474

776

12,273

5,316

-650

6,286

5,087

8,396

-255

7,796

5,511

Cash flows from investing activities:
Purchase of property and equipment

1,420

544

2,671

1,036

1,115

1,221

911

1,093

1,133

1,016

919

652

1,101

484

608

1,074

567

988

513

1,140

1,240

1,864

903

570

813

966

1,870

1,130

537

505

1,344

685

1,188

624

1,188

781

Capitalized software costs

280

429

270

264

289

242

357

179

210

329

337

143

37

47

50

12

83

31

11

28

196

-8

67

56

149

69

94

54

118

175

94

105

118

50

104

13

Other, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-27

-4

-

-

-1

-1

-5

-2

-3

-16

Net cash used in investing activities

-1,698

227

-2,941

-1,300

-2,600

-3,668

-1,718

-1,272

-1,273

-1,345

-1,256

-795

-1,131

-531

-658

-1,086

-637

-1,019

-524

-1,168

-1,427

-1,856

-970

-626

-929

-1,066

-1,937

-1,180

-3,760

-682

-6,150

-789

-1,301

-773

-1,295

-778

Cash flows from financing activities:
Repayments of debt

141

136

131

122

118

116

117

117

112

111

93

129

108

93

127

106

101

101

102

102

97

97

97

97

93

92

93

94

98

103

31

80

82

54

76

96

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

927

151

-

-133

-10

143

-10

1

30

51

291

48

72

51

9

13

7

4

Payment of contingent liability associated with acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

750

0

0

0

471

-

-

0

0

-

-

-

-

-

-

-

-

Proceeds from issuance of common stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

8,365

37,046

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Dividends paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,095

1,090

2,172

947

5,313

922

893

948

978

786

315

330

Tax payments related to stock awards

2,556

76

3,261

235

39

129

4,498

4,078

110

462

2,611

170

353

142

1,215

369

42

254

1,774

391

203

107

1,670

577

392

305

456

133

71

328

448

338

80

286

331

25

Repurchase of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

686

1,505

2,126

2,108

1,791

3,750

569

0

0

Net cash used in financing activities

-4,127

-1,638

-6,153

-357

-1,531

-1,619

-7,346

-4,195

-1,568

-1,919

-5,379

-299

-1,792

-1,563

-3,984

-475

-1,456

-2,746

-3,558

7,273

35,628

-1,455

-3,993

-1,002

-1,590

-1,486

-2,691

-1,809

-6,696

-3,431

-3,408

-3,106

-4,881

-1,682

-715

-447

Effect of exchange rates on cash and equivalents

-569

-65

-111

-961

1,574

-2,132

-1,158

-952

2,263

-1,117

2,733

1,478

-893

-376

-1,191

2,351

-689

-707

-1,518

-103

-4,018

-183

-210

691

139

430

-534

-512

447

622

-1,238

234

-342

-1,073

-359

1,849

Net (decrease) increase in cash and equivalents

2,902

-7,953

-9,222

11,577

1,333

-1,448

-4,861

-2,634

6,996

-9,175

-4,146

8,266

9,393

981

-5,170

2,147

11,110

-3,464

-779

10,338

49,115

-3,928

-2,886

2,241

10,185

-3,596

-4,386

8,772

-4,693

-4,141

-4,510

1,426

1,872

-3,783

5,427

6,135

Supplemental disclosure of cash flow information:
Interest

146

170

145

149

150

153

151

154

193

155

154

149

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income taxes, net of refunds

705

606

1,577

791

917

926

833

799

1,096

835

1,374

656

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Obligations associated with dividend declaration

-

-

-

1,374

-

-

-

1,359

-

-

-

1,331

-

-

-

-

-

-

-

1,299

-

-

-1,103

1,103

-

-

-

1,083

0

-28

15

1,100

-

-

-

-

Dividends paid in stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

145

122

166

206

128

147

142

628

596