Qad inc (QADB)
CashFlow / TTM
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

-15,949

-11,423

-8,566

5,797

10,428

320

-2,823

-5,097

-9,065

-19,052

-17,358

-15,229

-15,450

3,855

4,908

5,571

8,912

0

14,217

13,571

12,946

0

0

7,573

6,386

4,051

3,827

0

6,639

0

0

11,608

10,784

0

0

0

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

6,412

6,162

5,888

5,648

5,517

5,471

5,500

5,612

5,772

5,917

6,014

6,092

6,046

5,991

5,901

5,807

5,785

5,799

5,805

5,794

5,759

5,896

5,894

6,015

6,069

5,807

5,644

5,347

4,989

4,725

4,639

4,499

4,721

0

0

0

Amortization of costs capitalized to obtain and fulfill contracts

4,455

4,370

4,286

4,245

4,176

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts and sales adjustments

485

1,482

1,381

1,415

1,752

1,272

1,332

1,178

1,021

755

424

301

237

308

342

512

774

0

1,082

1,006

854

0

0

1,032

1,054

1,130

1,004

0

737

0

0

1,051

1,160

0

0

0

Amortization of right-of-use assets

5,964

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

164

72

373

420

0

462

0

0

80

33

0

0

0

Net change in valuation allowance

-

-

-

-2,617

-

-

-

-2,004

-1,695

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other deferred income taxes

-6,497

-3,855

-3,009

-5,693

-4,677

1,570

-611

271

-2,171

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of a derivative instrument

-368

-601

-454

-259

-51

472

532

481

377

557

694

529

485

-181

-611

-324

-48

-392

-419

-586

-877

-236

-181

875

634

910

1,181

-671

-384

0

0

0

-

-

-

-

Stock compensation expense

11,354

10,900

10,144

10,320

10,122

9,871

10,034

9,262

8,924

8,473

7,982

7,483

7,323

7,343

7,404

7,742

7,440

0

6,145

5,423

4,993

0

0

4,612

4,680

4,716

4,635

0

4,608

0

0

4,434

4,507

0

0

0

Other, net

-59

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

249

308

0

0

0

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

924

-4,904

-10,640

-4,975

1,515

-2,276

13,639

10,269

12,562

11,550

-3,557

2,321

4,141

-1,781

67

-5,411

-10,804

0

-1,571

4,735

11,236

0

0

9,298

1,247

4,772

6,737

0

6,767

0

0

-36,996

428

0

0

0

Costs capitalized to obtain and fulfill contracts

5,792

5,109

4,596

4,292

4,130

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease liabilities

6,077

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

-

-

-

951

-

-

-

5,067

-

-3,625

-3,967

-3,045

90

6,420

6,426

4,610

2,768

0

-569

460

431

0

0

-200

197

789

1,367

0

1,668

0

0

1,383

-613

0

0

0

Accounts payable

151

-4,914

-2,799

-288

-4,369

299

1,921

641

2,821

2,763

1,584

518

646

-426

-485

-136

-1,441

0

-71

1,426

2,568

0

0

-261

-1,260

-146

401

0

2,142

0

0

-565

-229

0

0

0

Deferred revenue

6,074

2,586

6,007

4,625

3,031

-137

3,305

3,604

7,001

7,149

2,273

7,102

7,245

5,169

3,494

1,002

-2,675

1,269

-858

1,828

4,912

-1,849

4,253

3,617

4,753

7,302

8,813

7,207

5,669

-2,166

-3,912

-3,726

-1,681

0

0

0

Other liabilities

1,070

-621

-2,295

773

-1,747

2,831

6,957

4,336

8,478

4,004

1,926

4,158

2,482

2,142

717

-135

-2,261

0

608

1,557

3,576

0

0

2,250

4,264

636

2,857

0

-472

0

0

3,231

1,574

0

0

0

Net cash provided by operating activities

16,997

11,591

24,039

29,417

19,007

22,691

11,926

6,321

10,418

16,053

24,298

25,205

18,680

19,363

16,920

21,078

24,057

29,097

27,655

25,121

23,963

17,596

16,556

15,045

24,140

16,891

17,715

23,225

16,039

19,119

19,514

21,024

21,448

0

0

0

Cash flows from investing activities:
Purchase of property and equipment

5,671

5,366

6,043

4,283

4,340

4,358

4,153

4,161

3,720

3,688

3,156

2,845

3,267

2,733

3,237

3,142

3,208

0

4,757

5,147

4,577

0

0

4,219

4,779

4,503

4,042

0

3,071

0

0

3,685

3,781

0

0

0

Capitalized software costs

1,243

1,252

1,065

1,152

1,067

988

1,075

1,055

1,019

846

564

277

146

192

176

137

153

0

227

283

311

0

0

368

366

335

441

0

492

0

0

377

285

0

0

0

Other, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

0

-11

-26

0

0

0

Net cash used in investing activities

-5,712

-6,614

-10,509

-9,286

-9,258

-7,931

-5,608

-5,146

-4,669

-4,527

-3,713

-3,115

-3,406

-2,912

-3,400

-3,266

-3,348

-4,138

-4,975

-5,421

-4,879

-4,381

-3,591

-4,558

-5,112

-7,943

-7,559

-11,772

-11,381

-8,922

-9,013

-4,158

-4,147

0

0

0

Cash flows from financing activities:
Repayments of debt

530

507

487

473

468

462

457

433

445

441

423

457

434

427

435

410

406

0

398

393

388

0

0

375

372

377

388

0

312

0

0

292

308

0

0

0

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

164

72

373

420

0

462

0

0

80

33

0

0

0

Payment of contingent liability associated with acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

750

750

750

750

471

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

Proceeds from issuance of common stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,365

0

45,411

45,411

37,046

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Dividends paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,304

9,522

9,354

8,075

8,076

3,741

3,605

3,027

2,409

0

0

0

Tax payments related to stock awards

6,128

3,611

3,664

4,901

8,744

8,815

9,148

7,261

3,353

3,596

3,276

1,880

2,079

1,768

1,880

2,439

2,461

2,622

2,475

2,371

2,557

2,746

2,944

1,730

1,286

965

988

980

1,185

1,194

1,152

1,035

722

0

0

0

Repurchase of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

686

2,191

4,317

0

7,530

0

0

6,110

4,319

0

0

0

Net cash used in financing activities

-12,275

-9,679

-9,660

-10,853

-14,691

-14,728

-15,028

-13,061

-9,165

-9,389

-9,033

-7,638

-7,814

-7,478

-8,661

-8,235

-487

36,597

37,888

37,453

29,178

-8,040

-8,071

-6,769

-7,576

-12,682

-14,627

-15,344

-16,641

-14,826

-13,077

-10,384

-7,725

0

0

0

Effect of exchange rates on cash and equivalents

-1,706

437

-1,630

-2,677

-2,668

-1,979

-964

2,927

5,357

2,201

2,942

-982

-109

95

-236

-563

-3,017

0

-5,822

-4,514

-3,720

0

0

726

-477

-169

23

0

65

0

0

-1,540

75

0

0

0

Net (decrease) increase in cash and equivalents

-2,696

-4,265

2,240

6,601

-7,610

-1,947

-9,674

-8,959

1,941

4,338

14,494

13,470

7,351

9,068

4,623

9,014

17,205

0

54,746

52,639

44,542

0

0

4,444

10,975

-3,903

-4,448

0

-11,918

0

0

4,942

9,651

0

0

0

Supplemental disclosure of cash flow information:
Interest

610

614

597

603

608

651

653

656

651

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income taxes, net of refunds

3,679

3,891

4,211

3,467

3,475

3,654

3,563

4,104

3,961

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Obligations associated with dividend declaration

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

0

-

-

0

0

-

-

-

0

1,087

0

0

0

-

-

-

-

Dividends paid in stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

145

267

433

0

622

0

0

1,045

1,513

0

0

0