Pc connection inc (CNXN)
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'12Dec'11Sep'11Jun'11Mar'11
Cash Flows provided by Operating Activities:
Net income

84,280

82,111

81,445

71,461

66,019

64,592

64,015

63,366

58,725

54,857

47,131

47,607

46,480

48,111

48,727

48,135

47,306

46,827

45,158

44,334

44,134

42,681

40,578

38,990

36,715

35,682

34,710

34,022

33,694

33,071

31,629

31,114

29,768

28,787

0

0

0

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

12,752

13,314

13,885

14,411

14,472

14,063

13,556

12,858

12,284

11,839

11,594

11,360

10,892

10,453

9,868

9,394

9,185

8,961

8,691

8,599

8,207

8,092

8,076

7,615

7,539

7,089

7,055

7,051

6,964

6,895

6,427

6,243

6,165

5,951

0

0

0

Provision for doubtful accounts

2,602

25

433

640

1,519

1,680

1,970

1,739

1,530

1,658

501

328

1,008

360

969

1,024

261

1,097

1,660

1,736

1,988

1,383

1,177

879

1,004

1,078

835

1,435

1,664

1,561

2,456

2,339

2,453

2,768

0

0

0

Stock-based compensation expense

2,218

1,863

1,602

1,448

1,142

1,080

918

821

765

741

1,370

1,303

943

1,049

513

662

1,045

994

947

906

1,008

929

907

1,143

969

958

871

576

595

1,494

1,502

1,602

1,666

824

0

0

0

Deferred income taxes

-

-

-

-

-

1,488

-3,641

-3,641

-3,515

-3,906

3,505

3,643

3,510

3,506

2,761

2,618

2,619

2,652

1,218

1,216

1,215

1,212

4,754

4,745

4,753

4,578

-975

-1,325

-1,331

674

2,171

3,393

3,904

2,581

0

0

0

Loss on disposal of fixed assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5

-9

-2

-16

-82

-83

-88

-84

-16

0

0

0

Fair value adjustment to contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Excess tax benefit from exercise of equity awards

-

-

-

-

-

-

-

-

-

-

-

-

-

513

465

489

525

552

525

617

581

556

535

66

78

260

0

0

0

-

-

-

-

-

-

-

-

Income tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

505

368

362

213

0

0

0

-

-

-

-

Changes in assets and liabilities:
Accounts receivable

53,970

101,953

80,399

39,448

29,023

-14,872

3,677

22,836

14,953

39,457

25,264

38,634

68,892

33,835

5,423

33,995

3,716

64,215

58,908

39,308

25,986

11,359

24,124

40,073

25,575

16,819

-18,482

3,834

-4,457

-26,317

2,848

15,034

27,068

56,682

0

0

0

Inventories

-680

5,471

20,795

68,455

52,083

23,311

9,428

92

-3,522

16,218

4,742

5,732

2,468

-12,401

-747

13,763

26,075

11,863

20,032

1,388

-145

11,776

6,168

20,052

11,826

9,504

10,895

2,214

-2,935

-7,800

-7,492

-511

-5,170

2,850

0

0

0

Prepaid expenses, income tax receivables and other current assets

8,098

1,476

-1,845

-102

444

1,045

-906

-2,777

392

2,097

3,971

2,630

-1,670

1,274

-142

-265

-744

285

-4,010

1,970

3,445

-1,829

4,950

288

-282

3,005

-1,254

-2,106

-3,141

-2,272

1,598

487

1,800

673

0

0

0

Other non-current assets

-47

-264

-2,439

-4,631

-4,402

-2,403

37

2,185

6,167

4,265

4,125

4,372

171

321

20

260

507

328

422

120

-19

4

20

-3

-11

6

-3

-7

-17

62

144

110

183

219

0

0

0

Accounts payable

17,340

34,960

31,916

57,740

50,364

5,722

-392

13,040

-20,537

15,807

4,748

-4,539

43,170

-3,012

-15,252

14,550

-2,408

41,324

51,286

9,041

6,780

202

-15,838

28,421

15,029

-1,371

-3,178

-13,398

-17,177

-4,613

-10,001

2,957

661

14,497

0

0

0

Accrued expenses and other liabilities

2,011

9,767

12,054

4,882

10,215

5,244

7,947

4,725

-147

337

-8,546

-1,119

-211

-3,431

2,728

3,205

5,143

6,206

-1,277

8,580

-660

2,751

3,782

-7,591

-4,268

1,231

-1,063

63

-1,523

-5,986

-1,273

1,194

-113

-309

0

0

0

Net cash provided by operating activities

63,061

36,603

45,608

48,650

67,693

86,839

72,212

70,596

31,139

19,320

22,165

6,826

35,542

33,586

45,339

31,390

33,116

30,862

31,820

31,023

32,838

35,398

7,132

13,530

24,400

19,656

47,385

24,607

33,529

69,659

36,019

33,859

20,740

-5,292

0

0

0

Cash Flows used in Investing Activities:
Purchases of equipment

23,679

25,656

26,218

25,188

22,803

21,238

19,500

17,199

15,323

11,803

11,083

10,634

11,294

11,885

11,014

12,367

12,137

12,337

12,156

9,868

8,421

7,609

8,186

6,843

7,328

7,607

7,183

8,327

8,172

9,250

9,382

9,915

11,558

10,855

0

0

0

Cash paid for acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,745

0

0

0

Proceeds from sale of equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

13

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-23,679

-25,656

-26,218

-25,188

-22,803

-21,238

-19,500

-17,199

-15,323

-11,803

-20,090

-19,641

-54,284

-54,875

-45,447

-46,800

-12,587

-12,787

-12,153

-9,865

-8,417

-7,596

-8,174

-6,831

-7,317

-7,605

-7,183

-8,321

-8,162

-9,240

-9,368

-9,907

-13,004

-16,046

0

0

0

Cash Flows used in Financing Activities:
Proceeds from short-term borrowings

-

-

-

-

-

859

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,204

0

0

0

-

-

-

-

Repayment of short-term borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

12,471

0

0

0

-

-

-

-

Repayment of capital lease obligation to affiliate

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

989

1,055

1,026

998

971

945

919

894

870

0

0

0

Purchase of treasury shares

13,406

4,478

15,354

14,492

13,672

15,375

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,813

0

0

0

-

-

-

-

Dividend payment

8,427

8,452

8,451

8,452

8,452

9,122

9,123

9,122

9,122

9,041

9,041

9,041

9,041

10,591

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of stock under Employee Stock Purchase Plan

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of stock options

-

-

-

-

-

-

-

-

-

1,750

0

0

0

-

-

-

-

437

549

719

360

356

311

209

415

1,779

1,654

2,292

2,238

872

1,093

439

287

404

0

0

0

Excess tax benefit from exercise of equity awards

-

-

-

-

-

-

-

-

-

-

-

-

-

513

465

489

525

552

525

617

581

556

535

66

78

260

0

0

0

-

-

-

-

-

-

-

-

Payment of payroll taxes on stock-based compensation through shares withheld

0

-

-

-

-

-

-

-

-

-

-

-

-

737

721

657

657

660

609

587

587

578

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-21,529

-12,590

-23,144

-22,403

-22,387

-23,888

-12,807

-12,848

-10,604

-6,707

-6,620

-6,353

-6,483

-9,719

-9,876

-9,788

-9,431

1,204

-9,234

-8,950

-9,420

-9,440

-9,705

-10,629

-10,731

-9,411

-16,549

-15,491

-16,590

-25,127

-12,883

-15,820

-16,544

-9,421

0

0

0

Increase in cash and cash equivalents

17,853

-1,643

-3,754

1,059

22,503

41,713

39,905

40,549

5,212

810

-4,545

-19,168

-25,225

-31,008

-9,984

-25,198

11,098

19,279

10,433

12,208

15,001

18,362

-10,747

-3,930

6,352

2,640

23,653

795

8,777

35,292

13,768

8,132

-8,808

-30,759

0

0

0

Non-cash Investing and Financing Activities:
Accrued capital expenditures

713

1,463

3,051

3,222

3,269

2,422

1,460

1,318

1,548

699

243

433

-178

109

-47

387

933

504

626

317

-4

205

305

527

337

335

185

60

89

253

72

320

-757

430

0

0

0

Issuance of nonvested stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,314

0

0

0

-

-

-

-

Contingent consideration recorded in accrued expenses and other liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,960

0

0

0

Supplemental Cash Flow Information:
Income taxes paid

28,538

28,460

23,783

23,598

19,916

19,945

19,768

21,531

27,701

28,927

30,080

29,787

23,648

29,740

30,964

29,529

29,191

30,371

25,487

29,786

31,974

24,219

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-