Insight enterprises, inc. (NSIT)
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 from operating activities:
Net earnings

154,041

159,407

163,498

168,520

170,001

163,677

130,804

121,062

109,838

90,683

97,615

96,838

91,650

84,690

82,166

81,356

71,788

75,851

76,758

73,335

75,085

75,684

76,608

74,231

73,495

71,021

71,381

75,710

84,447

92,763

106,650

104,462

104,560

100,235

0

0

0

Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization of property and equipment

54,739

46,209

36,946

36,728

40,892

37,458

39,187

40,582

41,202

42,599

26,138

26,259

27,381

27,493

19,008

21,611

24,049

26,649

27,021

27,463

28,759

29,243

40,855

41,455

41,116

41,544

41,879

41,550

41,449

41,177

40,741

40,511

39,703

39,139

0

0

0

Amortization of intangible assets

-

-

-

-

-

-

0

0

16,200

-

13,968

12,571

11,622

10,637

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for losses on accounts receivable

6,802

5,079

4,899

5,786

5,843

4,776

4,388

4,356

4,670

5,245

4,480

3,422

2,765

2,452

4,023

6,054

6,286

6,761

5,313

4,027

3,959

4,409

3,813

4,551

4,937

4,696

5,487

4,525

4,770

4,195

3,706

4,172

4,011

4,267

0

0

0

Write-downs of inventories

-

-

-

-

-

-

0

0

3,013

-

2,628

2,847

2,359

2,934

3,460

3,688

4,138

3,997

3,436

3,258

3,183

2,630

2,627

2,062

2,953

3,719

3,969

3,556

3,271

3,089

2,751

4,433

5,413

6,830

0

0

0

Write-off of property and equipment

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

741

799

1,042

562

606

0

0

0

-

-

-

-

-

-

-

-

Write-off of computer software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Non-cash stock-based compensation

16,305

16,011

16,486

16,105

16,286

15,355

13,456

13,124

12,598

12,826

12,884

12,524

11,671

11,058

10,545

9,578

9,398

8,922

8,574

8,693

8,315

7,750

7,380

6,519

6,098

6,430

6,992

7,694

8,497

8,548

8,807

8,545

8,165

7,919

0

0

0

Gain on bargain purchase

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,022

0

0

0

-

-

-

-

Excess tax benefit from employee gains on stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

674

688

661

568

584

575

444

909

787

784

790

1,966

2,182

2,207

2,136

1,809

0

0

0

Deferred income taxes

6,362

7,418

8,663

8,286

8,694

9,126

22,312

21,184

20,691

19,139

6,884

8,830

9,945

10,517

6,135

6,742

5,142

5,174

5,810

4,310

3,466

3,794

-784

28

2,500

3,445

7,741

7,639

7,520

8,978

2,782

5,118

5,492

4,552

0

0

0

Other adjustments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in assets and liabilities:
Decrease in accounts receivable

307,014

118,971

200,873

114,409

21,069

46,883

94,302

264,494

205,898

208,065

193,971

221,709

251,478

168,966

82,698

57,625

21,237

47,206

140,446

214,427

51,388

107,969

54,996

-24,904

-22,054

-111,545

42,263

-26,442

7,627

141,182

40,633

127,510

84,329

78,883

0

0

0

Increase in inventories

-3,270

-11,944

-4,215

5,106

-2,432

-46,534

-83,513

-58,511

-12,655

14,046

64,191

76,384

61,635

50,712

55,413

-10,558

2,469

9,214

14,594

49,394

24,790

35,714

25,749

19,174

39,335

7,391

11,480

-2,648

-31,854

-27,477

-12,539

2,329

-19,924

8,247

0

0

0

Decrease (increase) in other assets

-34,810

129,745

118,812

98,007

69,376

-12,424

-34,577

-84,934

23,215

-3,342

27,148

102,493

40,879

50,181

46,350

27,735

23,517

26,714

-2,401

7,236

8,739

3,578

18,269

16,192

19,073

29,915

16,845

22,323

21,316

5,816

4,799

-3,104

-6,263

-25,895

0

0

0

(Increase) decrease in other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-127

-2,209

-2,540

-9,207

3,856

7,746

8,943

12,107

0

0

0

Increase (decrease) in accounts payable

104,911

-612

191,800

28,055

44,702

29,844

3,724

49,563

-340

-237,457

29,351

225,147

157,075

193,582

47,786

-17,640

14,410

113,594

86,844

251,332

10,685

121,506

21,144

-49,821

29,359

-130,657

36,461

24,517

-34,232

56,442

16,979

111,032

-89,945

45,205

0

0

0

(Decrease) increase in deferred revenue

-

-

-

-

-

-

0

0

-20,815

-

3,407

14,369

17,071

10,633

463

4,573

-1,087

2,927

-4,864

-2,018

14,832

8,303

6,600

19,467

6,627

1,197

4,283

-11,250

-24,415

-11,196

1,115

-11,480

11,219

-17,926

0

0

0

(Decrease) increase in accrued expenses and other liabilities

9,463

119,590

110,355

78,848

80,793

16,407

-1,479

-705

10,443

-28,172

-18,702

-788

13,695

12,278

21,196

19,649

10,228

7,718

23,275

574

-7,120

-10,902

-12,917

-12,480

-16,981

735

-3,917

-18,720

7,550

-22,848

-6,859

2,192

-5,716

-735

0

0

0

Net cash provided by operating activities

99,089

127,876

214,001

124,230

263,815

292,647

263,735

143,155

-4,219

-307,066

-102,633

1,433

-9,096

96,077

31,610

80,156

113,355

181,102

87,165

102,928

65,104

110,319

57,286

92,031

125,816

76,066

103,926

144,026

104,165

67,442

135,755

130,309

11,659

115,725

0

0

0

Cash flows from investing activities:
Proceeds from sale of assets held for sale

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment

71,116

69,086

21,127

17,191

17,559

17,251

16,370

19,600

14,222

19,230

18,458

17,566

19,422

12,266

12,326

11,838

13,118

13,416

12,804

11,193

11,159

9,983

12,862

13,837

15,372

19,024

21,843

24,738

27,999

30,152

32,664

32,641

29,872

27,093

0

0

0

Acquisitions, net of cash and cash equivalents acquired

669,931

664,287

0

0

0

-

-

-

-

186,932

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,831

0

0

0

-

-

-

-

Net cash provided by (used in) investing activities

-726,829

-733,373

-685,414

-95,012

-92,780

-91,710

-90,829

-24,121

-18,778

-204,645

-203,873

-209,264

-209,200

-21,185

-65,466

-54,174

-57,339

-57,637

-10,332

-8,721

-8,687

-7,511

-12,862

-13,837

-15,372

-19,024

-21,843

-24,738

-27,999

-33,983

-50,264

-50,241

-47,472

-40,862

0

0

0

Cash flows from financing activities:
Borrowings on senior revolving credit facility

-

242,936

242,936

378,984

342,484

569,232

797,232

1,044,791

1,258,791

1,151,216

1,160,514

896,907

726,407

772,218

709,920

704,420

742,920

686,410

596,910

510,410

499,910

484,992

455,992

512,785

652,285

835,328

868,828

824,385

712,488

803,953

1,057,453

1,174,103

1,449,500

1,314,500

0

0

0

Repayments on senior revolving credit facility

-

242,936

242,936

378,984

344,484

686,732

1,013,232

1,044,791

1,256,791

1,033,716

973,014

896,907

726,407

772,218

681,420

720,920

762,420

686,410

613,910

493,910

501,410

501,492

448,992

515,785

660,285

851,828

860,828

821,385

821,988

885,953

1,210,953

1,315,103

1,381,000

1,289,500

0

0

0

Borrowings on accounts receivable securitization financing facility

-

2,364,500

3,059,500

3,580,000

3,343,500

3,357,000

3,779,000

3,855,000

4,066,889

3,961,389

3,699,389

3,642,889

3,204,500

2,802,000

2,456,000

2,078,000

2,004,000

1,897,100

1,730,100

1,439,170

1,234,170

1,050,070

946,070

833,000

887,000

875,000

768,000

660,000

744,000

581,000

0

0

0

-

-

-

-

Repayments on accounts receivable securitization financing facility

-

2,558,500

3,170,500

3,535,000

3,325,500

3,188,000

3,828,000

3,979,000

4,168,889

3,975,889

3,753,389

3,603,889

3,148,500

2,851,500

2,327,000

2,027,000

1,939,000

1,869,100

1,680,100

1,430,170

1,227,170

1,039,070

989,070

858,000

851,000

872,000

800,000

730,000

712,000

534,000

0

0

0

-

-

-

-

Borrowings under Term Loan A

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments under Term Loan A

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Borrowings under other financing agreements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,002

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Repayments under other financing agreements

-

-

-

-

-

-

0

0

3,451

-

5,176

4,634

4,096

1,309

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on finance lease obligations

-

-

-

-

-

-

0

0

1,249

-

789

600

517

445

326

213

224

223

221

219

219

217

217

263

467

671

873

1,026

1,021

1,017

1,012

1,008

1,002

997

0

0

0

Net repayments under inventory financing facilities

-7,248

-50,454

-29,899

-42,812

32,058

-15,338

13,485

99,801

53,843

141,037

64,788

24,717

48,694

48,603

-40,706

4,731

-43,222

-16,454

50,829

42,257

37,215

7,529

28,773

-8,500

-30,039

-1,581

-6,336

16,797

34,861

22,900

1,325

3,261

15,043

-41,179

0

0

0

Payment of debt issuance costs

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of common stock under employee stock plans

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,641

2,640

903

910

37

0

0

0

Excess tax benefit from employee gains on stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

674

688

661

568

584

575

444

909

787

784

790

1,966

2,182

2,207

2,136

1,809

0

0

0

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

-

-

-

-

-

-

0

0

3,676

-

4,763

4,641

4,647

2,219

2,287

2,274

2,537

2,265

2,503

2,521

2,295

2,028

2,000

1,989

1,839

3,094

2,998

2,990

3,102

3,288

3,199

3,202

3,249

2,697

0

0

0

Repurchases of common stock

0

-

-

-

-

22,069

0

0

0

-

-

-

-

50,000

50,000

54,359

66,745

91,843

112,574

106,682

62,232

50,383

37,426

37,426

77,628

57,774

0

0

0

-

-

-

-

-

-

-

-

Other payments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

568,461

577,587

507,517

-165,517

-138,436

-159,028

-293,945

-66,099

-74,243

397,121

354,875

221,270

229,412

-58,230

58,968

-22,152

-68,748

-83,328

-31,562

-41,278

-21,871

-48,530

-44,561

-73,801

-79,527

-75,711

-83,643

-101,906

-53,853

-14,575

-44,118

-57,244

32,338

-68,027

0

0

0

Foreign currency exchange effect on cash, cash equivalents and restricted cash balances

-2,715

-86

-6,587

297

-7,984

-5,061

-5,980

-1,191

12,206

16,089

12,356

6,136

-1,384

-1,937

2,449

-4,193

516

-16,683

-24,239

-27,348

-29,284

-16,571

-7,793

3,369

-2,379

-6,633

-4,083

-4,230

-2,596

4,899

622

-9,014

-4,503

-2,263

0

0

0

Decrease in cash, cash equivalents and restricted cash

-61,994

-27,996

29,517

-136,002

24,615

36,848

-127,019

51,744

-85,034

-98,501

60,725

19,575

9,732

14,725

27,561

-363

-12,216

23,454

21,032

25,581

5,262

37,707

-7,930

7,762

28,538

-25,302

-5,643

13,152

19,717

23,783

41,995

13,810

-7,978

4,573

0

0

0

ABL Facility [Member]
Borrowings on senior revolving credit facility

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments on senior revolving credit facility

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-