Fastenal co (FAST)
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'11Dec'10Sep'10Jun'10Mar'10Dec'09Sep'09Jun'09Mar'09
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

799,400

790,900

781,000

765,100

771,700

751,900

735,500

681,000

618,700

578,600

541,000

524,800

507,400

499,400

496,543

506,137

514,994

516,400

522,848

519,668

509,825

494,150

474,988

461,024

451,519

448,636

448,123

438,093

429,390

420,536

409,291

396,770

378,576

357,929

335,619

313,814

288,869

265,356

244,731

217,326

191,697

184,357

0

0

0

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

146,800

144,600

142,600

140,100

137,100

134,100

130,600

128,300

126,100

123,600

121,300

116,400

110,100

103,500

100,100

94,705

89,988

86,100

79,169

76,250

74,276

72,145

70,034

67,991

65,899

63,770

61,518

58,716

56,196

53,459

50,825

48,462

46,047

44,113

42,697

41,647

40,882

40,688

40,305

40,061

40,007

40,020

0

0

0

Gain on sale of property and equipment

1,300

1,200

800

1,100

1,200

500

400

200

200

1,000

1,300

1,400

1,000

500

1,041

1,002

1,192

1,400

901

1,050

856

964

797

599

646

643

705

751

790

403

255

198

-343

-194

-115

-213

7

-35

-163

-204

-589

-850

0

0

0

Bad debt expense

5,400

5,500

7,900

8,500

8,800

8,100

7,100

6,900

7,300

8,200

8,200

8,700

8,700

8,600

8,632

7,894

8,017

8,800

9,819

10,865

11,567

11,480

10,763

10,506

10,172

9,421

9,573

9,271

9,442

9,726

9,866

9,750

9,279

9,217

9,245

9,546

9,301

8,658

8,113

8,090

8,466

9,409

0

0

0

Deferred income taxes

14,900

15,000

11,900

16,700

22,300

33,800

-8,200

-11,400

-18,300

-30,000

25,200

24,100

24,200

25,600

8,178

8,073

9,684

8,300

3,168

3,187

1,820

1,760

9,024

9,449

8,106

8,129

11,144

11,068

13,958

15,442

19,430

19,697

17,666

15,747

4,714

3,831

1,540

1,602

7,225

7,138

6,105

6,099

0

0

0

Share-based Payment Arrangement, Noncash Expense

5,700

5,700

5,600

5,500

5,300

5,100

5,000

4,900

5,400

5,200

5,200

5,200

4,300

4,100

4,059

4,059

5,180

5,800

7,060

7,480

7,279

7,039

5,970

5,700

5,430

5,400

5,400

5,400

5,100

4,800

4,575

4,350

4,200

4,050

3,940

3,830

3,930

4,030

4,015

3,950

3,950

3,850

0

0

0

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,925

1,880

1,995

2,094

2,030

2,182

2,383

2,787

3,874

4,139

11,103

10,149

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of intangible assets

4,100

4,100

4,100

4,100

4,100

4,100

4,000

4,000

4,000

3,800

2,900

2,000

1,200

500

505

537

468

500

527

527

527

527

526

526

527

421

438

454

471

593

593

593

593

593

462

330

198

67

67

67

67

67

0

0

0

Changes in operating assets and liabilities, net of acquisition:
Trade accounts receivable

52,300

30,400

56,300

94,700

117,400

120,300

149,500

127,700

116,100

103,700

86,300

77,900

46,100

40,500

12,580

7,648

18,935

20,600

35,475

53,550

67,837

63,418

79,376

76,384

64,620

51,593

52,192

45,730

41,293

43,291

59,824

52,548

70,476

77,678

68,599

85,918

72,523

64,622

73,877

36,668

30,271

-21,362

0

0

0

Inventories

60,300

84,400

165,300

182,600

165,600

193,300

150,000

119,200

118,900

76,300

61,100

44,900

32,400

80,900

74,177

103,285

89,749

47,800

59,934

65,534

82,854

87,622

80,394

93,664

93,503

68,685

80,157

62,418

52,598

69,231

57,679

54,032

71,435

88,783

72,086

86,443

69,208

48,964

-88,908

-91,744

-52,623

-60,425

0

0

0

Other current assets

7,300

10,400

10,800

15,700

17,200

28,900

8,700

8,100

5,400

15,600

-2,300

-13,100

-23,800

-29,100

2,216

5,796

20,440

15,800

-9,852

-4,007

-3,599

7,510

6,587

5,133

17,074

10,627

20,613

17,285

9,586

7,528

15,747

15,693

12,515

19,294

27,284

23,065

18,475

24,577

-23,544

-29,369

-1,802

-17,747

0

0

0

Accounts payable

28,200

-800

29,200

31,700

35,800

46,100

38,900

30,900

19,300

36,300

26,900

-19,900

-32,100

-17,200

-15,670

23,737

24,775

20,600

19,245

23,829

34,382

12,501

7,448

19,735

22,370

13,234

20,249

8,510

-786

4,240

-1,957

-1,877

7,594

13,305

13,234

11,685

2,741

6,984

9,868

16,472

11,064

-14,172

0

0

0

Accrued expenses

-5,300

10,700

13,700

21,600

33,100

46,800

28,900

24,000

36,200

37,600

9,900

3,900

-15,700

-28,600

-5,889

-5,795

10,359

11,100

12,488

15,612

20,214

25,263

29,696

27,335

22,478

22,424

29,268

20,011

12,995

14,193

14,611

18,851

20,618

15,550

13,343

14,640

17,750

30,393

23,008

14,253

1,181

-17,526

0

0

0

Income taxes

-2,200

-7,700

1,800

-6,000

-400

-15,500

-8,800

-9,900

-23,400

19,400

-4,800

4,000

10,000

15,500

21,725

14,736

-1,895

-26,600

-9,095

-2,338

20,921

34,405

8,217

435

-2,036

-14,714

-2,087

1,239

15,764

704

-6,550

-2,746

-1,501

-3,222

15,149

11,905

26,716

16,956

3,138

6,989

-5,090

-12,156

0

0

0

Other

-3,100

-1,100

-3,700

-2,400

-3,000

-2,700

-1,100

0

200

900

500

-1,600

-1,400

-1,300

-5,290

-5,020

-4,990

-4,900

-11,589

-544

-5,331

-1,730

13,693

-445

7,065

6,266

3,616

2,713

2,812

-3,201

-5,182

5,633

2,596

3,232

2,173

-5,881

-7,304

-3,882

-11,785

-7,196

-6,100

-5,738

0

0

0

Net cash provided by operating activities

878,900

842,700

768,300

695,600

719,400

674,200

625,500

603,500

534,500

585,200

588,900

559,700

563,800

519,900

535,215

542,646

536,695

550,300

568,435

537,617

536,199

499,392

433,789

425,184

399,174

416,120

422,469

419,726

424,348

396,292

363,404

357,643

326,393

268,489

268,376

222,238

235,744

240,488

219,179

258,045

291,564

306,070

0

0

0

Cash flows from investing activities:
Purchases of property and equipment

240,800

246,400

263,500

238,800

199,200

176,300

134,300

123,100

130,200

119,900

110,200

158,200

181,000

189,500

197,738

155,880

140,978

155,200

165,389

179,934

200,832

189,474

204,528

211,539

183,591

206,540

195,642

179,987

165,707

138,406

115,887

114,699

127,049

120,043

123,433

97,710

86,665

73,597

55,053

52,111

41,643

52,538

0

0

0

Proceeds from sale of property and equipment

7,100

6,600

6,200

6,200

8,400

9,500

9,500

9,600

8,000

7,400

8,100

8,100

7,700

6,500

7,804

8,788

9,137

9,900

8,361

7,211

6,428

5,819

4,853

4,806

4,777

4,990

7,713

6,103

4,806

4,524

1,770

3,244

3,918

3,554

4,081

3,854

4,395

4,459

3,863

3,417

3,575

4,863

0

0

0

Cash paid for acquisition

0

-

-

-

0

-

-

-

-

58,700

58,700

58,700

57,900

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net decrease in marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-451

-441

16

36

97

-26,787

-26,729

-26,777

-26,811

1,025

923

-3,562

-4,054

-3,604

-3,418

1,106

581

22,961

27,940

27,934

28,941

0

0

0

Other

0

-100

-3,200

3,300

3,200

3,400

11,500

10,000

10,100

8,100

7,900

3,100

3,100

5,100

11,918

11,980

11,877

11,800

61

-47

47

2

89

251

120

145

90

9

79

133

211

-3

65

-212

10,210

10,218

10,065

10,329

-99

124

208

101

0

0

0

Net cash used in investing activities

-358,700

-239,700

-254,100

-239,600

-197,700

-173,900

-140,000

-123,500

-133,100

-179,300

-168,700

-211,900

-234,300

-188,100

-225,352

-182,572

-167,218

-180,600

-162,664

-177,798

-199,573

-188,781

-199,323

-207,000

-178,970

-201,792

-161,232

-147,164

-134,203

-107,204

-115,353

-112,375

-119,634

-112,223

-125,958

-100,656

-93,441

-80,048

-79,084

-81,790

-71,242

-81,749

0

0

0

Cash flows from financing activities:
Proceeds from debt obligations

1,025,000

910,000

1,085,000

1,090,000

1,010,000

980,000

850,000

880,000

955,000

1,015,000

995,000

1,065,000

1,010,000

950,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments against debt obligations

1,040,000

1,065,000

1,030,000

1,015,000

945,000

895,000

895,000

890,000

905,000

980,000

990,000

1,045,000

1,010,000

920,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Borrowings under credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

700,000

610,000

380,000

260,000

100,000

30,000

20,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments against credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

595,000

540,000

380,000

260,000

100,000

30,000

20,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of stock options

47,800

58,500

45,100

47,900

27,700

13,400

17,300

11,800

10,400

9,500

7,800

10,200

11,700

29,300

34,811

34,589

37,520

19,100

9,950

9,465

8,136

7,697

7,303

7,331

8,126

9,306

14,898

16,561

14,180

29,644

25,018

23,787

27,224

8,939

0

0

0

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,925

1,880

1,995

2,094

2,030

2,182

2,383

2,787

3,874

4,139

3,406

10,149

9,139

9,086

8,680

983

0

0

0

-

-

-

-

-

-

-

-

Purchases of common stock

52,000

0

0

0

0

-

-

-

-

-

-

-

-

59,500

78,910

101,975

270,535

292,900

299,735

294,520

125,960

52,942

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of dividends

519,200

498,600

486,700

475,300

458,500

441,900

419,500

396,700

382,900

369,100

363,800

358,500

352,700

346,600

341,017

335,564

330,754

327,100

320,018

312,964

305,234

296,581

296,783

296,809

281,987

237,456

373,715

355,777

346,771

367,306

198,137

180,223

168,223

191,741

212,335

235,889

197,557

182,814

120,893

113,929

113,929

106,943

0

0

0

Net cash used in financing activities

-538,400

-595,100

-449,200

-415,000

-468,800

-446,500

-487,600

-461,200

-405,100

-407,200

-433,600

-385,000

-341,000

-346,800

-271,872

-319,224

-334,220

-340,900

-397,878

-336,139

-296,063

-249,732

-209,147

-235,223

-289,405

-234,443

-364,023

-335,077

-329,185

-327,513

-163,980

-147,350

-132,319

-181,819

-203,828

-230,536

-197,557

-182,814

-161,997

-155,033

-155,033

-148,047

0

0

0

Effect of exchange rate changes on cash and cash equivalents

-6,500

-200

-3,500

-1,500

-4,600

-3,500

-1,600

1,600

6,500

5,500

-200

-3,100

-4,800

-1,300

-2,670

-6,520

-5,351

-14,200

-12,447

-8,454

-8,794

-4,889

-1,180

126

-1,018

-990

-627

-548

-598

360

484

-1,411

-410

-464

-107

1,971

1,280

1,215

723

1,503

3,666

2,686

0

0

0

Net (decrease) increase in cash and cash equivalents

-24,700

7,700

61,500

39,500

48,300

50,300

-3,700

20,400

2,800

4,200

-13,600

-40,300

-16,300

-16,300

35,321

34,330

29,906

14,600

-4,554

15,226

31,769

55,990

24,139

-16,913

-70,219

-21,105

-103,413

-63,063

-39,638

-38,065

84,555

96,507

74,030

-26,017

-61,517

-106,983

-53,974

-21,159

-21,179

22,725

68,955

78,960

0

0

0

Supplemental information:
Cash paid for interest

12,100

13,900

15,000

14,500

13,900

12,600

11,500

11,100

9,900

8,700

7,900

6,800

6,300

6,200

5,404

4,845

4,142

3,100

2,420

1,750

1,203

915

643

396

149

113

61

37

34

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash paid for income taxes

241,200

242,700

239,900

240,800

217,400

215,300

238,300

263,800

315,900

304,100

290,900

274,500

258,300

248,300

259,727

275,009

298,508

327,000

330,534

321,057

280,022

257,514

253,660

249,247

257,897

270,615

276,599

275,263

253,031

268,357

244,422

229,841

221,342

205,614

186,775

177,289

151,657

146,726

141,770

121,671

115,625

118,035

0

0

0

Leased assets obtained in exchange for new operating lease liabilities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-