Trimble inc. (TRMB)
CashFlow / TTM
Apr'20Jan'20Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Jan'16Sep'15Jun'15Mar'15Jan'15Sep'14Jun'14Mar'14Jan'14Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11Dec'10Sep'10Jun'10Mar'10
Cash flow from operating activities:
Net income

514,000

514,500

321,900

317,500

287,000

283,300

160,700

144,200

127,400

118,500

192,000

174,000

162,300

132,200

118,400

116,200

106,400

120,700

152,700

127,500

179,800

213,900

217,695

260,515

237,368

218,200

191,184

190,364

188,576

189,716

185,700

159,096

160,109

148,909

156,094

161,740

114,333

103,613

0

0

0

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

39,000

39,400

39,100

38,700

37,300

35,600

34,400

34,100

34,200

34,600

35,500

35,900

36,800

37,000

37,600

37,600

37,100

36,700

36,000

35,400

34,300

33,100

31,170

29,446

28,007

26,700

26,411

25,245

24,322

23,691

22,736

22,634

21,468

20,509

19,571

18,637

18,350

18,198

0

0

0

Amortization expense

163,900

167,800

175,300

184,300

183,400

179,600

172,600

162,800

156,000

148,800

142,700

140,000

143,800

150,800

157,400

160,800

162,000

162,400

162,900

161,600

158,600

158,500

159,887

162,105

164,068

162,800

157,105

146,927

136,242

125,707

118,470

111,136

98,634

85,902

72,221

62,547

59,887

57,639

0

0

0

Provision for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

3,000

2,700

3,100

1,500

1,900

2,600

4,100

4,300

3,800

3,596

2,539

2,335

1,900

1,806

805

1,508

2,030

2,387

2,759

2,141

1,913

252

364

1,641

2,320

0

0

0

Deferred income taxes

-216,500

-220,200

-15,800

-25,900

-35,700

-47,600

0

0

0

-

-

-

-

400

2,600

2,200

2,100

900

-1,000

-800

-1,500

-1,700

-2,680

-2,968

-4,691

-15,000

-15,535

-15,482

-13,324

-1,369

-15,484

-21,785

-24,766

-26,305

-21,266

-14,596

-16,414

-14,918

0

0

0

Stock-based compensation

69,400

75,000

75,900

76,100

75,800

76,900

72,900

70,200

68,500

64,800

57,600

54,800

52,600

52,600

52,800

52,300

51,300

50,100

48,600

46,800

45,800

43,400

42,442

40,347

37,782

36,500

35,190

33,969

33,689

32,660

31,046

30,468

29,442

28,451

27,993

26,427

24,282

23,125

0

0

0

Income from equity method investments, net of dividends

8,600

7,800

7,400

8,100

2,800

-1,900

1,700

3,900

8,800

11,400

13,600

17,900

17,400

17,600

17,700

17,200

17,800

17,900

15,000

13,100

11,900

12,400

16,292

17,986

19,943

20,700

20,927

22,886

22,792

24,727

24,056

22,423

18,778

15,349

13,771

23,597

17,032

11,795

0

0

0

Gain on an equity sale

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15,100

15,100

15,100

15,100

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Divestitures gain, net

-

-

-

-

-

-

-

-

-

-

-

-

-

3,500

-2,000

1,000

1,200

3,900

8,900

7,000

4,600

-2,900

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit for stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,400

1,500

4,600

14,100

18,797

19,384

18,916

13,500

17,475

17,707

22,549

25,345

19,737

19,066

13,985

14,762

19,366

19,177

17,514

9,639

0

0

0

Provision for excess and obsolete inventories

-

-

-

-

-

-

-

-

-

-

-

-

-

15,800

19,200

19,100

15,600

12,300

6,400

5,100

4,500

4,800

5,149

4,331

3,716

3,200

1,413

1,810

3,707

6,234

7,867

8,672

9,032

8,410

8,094

6,310

5,339

4,752

0

0

0

Other, net

-18,600

-5,500

-11,200

-12,800

-34,200

-21,300

-26,200

-23,200

-4,100

-5,500

6,900

9,200

7,100

-3,300

-4,900

-3,000

300

-10,000

-14,300

-20,900

-18,000

-4,700

2,038

6,406

3,104

700

464

2,864

3,140

4,221

3,350

1,475

-2,007

-2,407

2,325

2,736

3,770

1,433

0

0

0

(Increase) decrease in assets:
Accounts receivable, net

34,300

96,000

18,400

52,700

35,400

51,000

24,600

18,800

38,100

42,700

22,800

10,500

18,700

-1,200

21,900

19,200

-15,100

-300

-14,100

-33,000

-22,100

10,900

-11,666

22,629

4,044

4,100

13,358

9,870

39,919

24,388

28,253

39,813

37,675

31,874

33,463

22,628

16,454

7,376

0

0

0

Other receivables

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,400

700

-3,300

-1,400

-8,500

-8,900

-5,100

-4,300

2,300

6,447

-158

4,427

-2,300

-7,026

-63

2,201

5,017

-8,674

-17,515

-26,576

-30,141

-15,798

-859

-234

-2,518

0

0

0

Inventories

34,900

21,300

14,300

15,800

30,100

45,000

48,000

57,100

56,600

37,300

20,000

-10,800

-18,500

-24,000

-29,200

-20,100

-6,600

2,900

11,000

22,300

24,800

31,800

41,245

17,975

4,582

11,400

1,107

23,721

34,548

8,402

23,445

13,445

15,494

30,139

24,344

41,902

44,825

45,549

0

0

0

Other current and non-current assets

-21,700

-11,000

3,100

10,800

10,400

17,600

3,000

11,200

12,000

15,600

6,800

3,100

1,000

1,200

9,200

7,100

4,500

7,600

3,700

7,400

12,900

7,100

1,935

7,635

3,133

11,800

27,866

11,206

10,840

7,945

-670

-137

2,380

-10,519

-8,896

-2,732

-9,287

-2,257

0

0

0

Increase (decrease) in liabilities:
Accounts payable

-1,700

14,500

2,400

-7,800

-9,700

-2,000

7,200

13,400

33,300

25,700

35,900

26,400

2,500

10,900

3,200

-6,100

-5,700

-6,400

-7,300

-1,600

-6,500

-7,200

-133

3,636

781

-15,800

-4,310

2,901

15,699

25,985

1,479

-8,938

-16,482

-4,310

-180

5,038

2,635

13,577

0

0

0

Accrued compensation and benefits

-2,000

-46,400

-19,900

-3,300

3,200

18,600

12,500

13,300

7,200

34,000

21,100

12,500

-700

600

2,500

2,900

1,400

-100

-5,600

-5,900

-3,000

500

-2,462

16,866

4,637

4,100

-1,224

-1,547

-2,253

7,889

10,765

10,192

10,815

2,469

-1,773

2,333

946

15,928

0

0

0

Deferred revenue

86,700

148,200

55,900

70,100

83,800

76,300

45,400

35,900

35,600

19,300

21,000

26,800

25,300

26,100

22,300

32,400

32,800

28,100

42,600

46,400

48,200

45,900

24,409

22,406

24,536

29,400

51,061

40,437

38,955

16,560

23,527

42,304

49,563

18,775

4,479

6,735

-7,864

-1,177

0

0

0

Accrued warranty expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,100

-1,100

-1,300

-1,200

-2,000

-1,000

600

1,200

3,100

3,053

1,954

661

700

1,318

140

-353

-1,520

-2,249

-1,083

-44

644

0

0

0

-

-

-

-

Other current and non-current liabilities

-22,200

800

-38,100

-30,700

-29,200

-43,600

80,800

71,100

84,700

101,600

26,200

37,800

5,000

-6,200

-7,600

-23,000

-8,700

-3,700

-61,200

-30,400

-20,400

-4,900

47,354

17,237

31,561

20,400

12,223

27,528

26,908

20,419

27,219

9,386

2,595

5,583

-1,301

2,315

-20,795

-22,616

0

0

0

Net cash provided by operating activities

593,100

585,000

564,700

544,400

551,400

486,700

491,900

444,100

408,600

429,700

449,200

471,400

403,200

413,600

367,600

348,600

364,200

357,000

373,000

396,500

430,900

407,100

446,692

457,157

460,612

414,600

375,214

357,649

310,430

340,700

323,702

286,007

281,360

241,629

198,819

139,437

96,454

124,030

0

0

0

Cash flow from investing activities:
Acquisitions of businesses, net of cash acquired

0

-

-

-

-

1,763,500

1,742,600

688,200

720,400

280,200

295,500

143,700

101,500

38,800

76,900

117,200

135,200

156,300

238,700

341,900

333,800

307,900

229,299

104,947

204,608

258,800

573,031

569,391

691,914

728,114

356,978

1,005,964

822,150

759,737

803,905

194,263

153,827

136,419

0

0

0

Proceeds from Previous Acquisition

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions of property and equipment

71,200

69,000

69,100

70,100

63,900

67,600

70,400

64,100

56,200

43,700

32,700

29,400

26,800

26,000

27,900

29,600

38,200

43,900

48,000

45,400

44,300

47,300

48,254

59,869

69,573

70,900

77,591

72,194

61,354

54,071

41,402

35,264

26,886

23,278

21,973

21,425

21,870

23,133

0

0

0

Purchases of equity method investments

-

-

-

-

-

-

-

-

-

-

-

-

-

1,500

3,400

4,200

4,600

5,500

3,600

11,100

12,200

10,900

0

0

0

-

-

-

-

-

-

-

0

-

-

-

-

8,192

0

0

0

Purchases of short-term investments

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from maturities of short-term investments

-

-

-

-

-

6,200

43,700

71,500

103,900

122,100

87,000

59,200

26,800

2,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of short-term investments

-

-

-

-

-

196,800

202,400

203,900

290,600

97,700

92,100

90,600

3,900

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions of intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

3,104

2,332

2,016

2,063

0

0

0

Dividends received from equity method investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

13,178

0

0

0

-

-

-

-

-

-

-

-

Net proceeds from sales of businesses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends received from equity method investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-14,800

-14,500

-14,300

-11,500

1,900

-2,500

-3,100

-5,700

-5,700

-20,900

-21,200

-21,400

-20,700

-800

-1,000

-500

-100

-1,200

-2,300

2,000

-300

2,500

7,839

5,830

9,430

5,000

-4,722

-7,327

-8,251

-5,891

3,272

3,030

2,922

2,948

162

586

-148

-105

0

0

0

Net cash used in investing activities

-480,100

-275,300

-105,500

-1,284,600

-1,305,700

-1,649,600

-1,655,800

-645,600

-629,400

-371,200

-394,000

-242,200

-231,400

-144,400

-137,600

-117,300

-145,300

-172,400

-255,000

-378,000

-365,200

-344,000

-270,792

-143,372

-262,595

-324,800

-632,732

-619,945

-731,151

-764,286

-389,681

-1,038,573

-839,884

-773,565

-819,083

-190,127

-169,679

-156,374

0

0

0

Cash flow from financing activities:
Issuance of common stock, net of tax withholdings

16,200

29,100

16,300

31,900

40,500

40,200

53,100

45,700

59,500

73,800

90,500

92,300

91,000

67,500

50,600

38,700

31,100

29,700

31,600

32,800

38,300

56,100

63,633

63,046

65,763

47,700

59,712

55,979

46,942

59,187

42,829

42,368

44,766

45,869

52,845

57,344

63,684

44,548

0

0

0

Repurchases of common stock

189,800

179,800

219,800

99,000

80,000

93,000

226,800

317,900

324,100

285,300

128,800

51,600

121,500

119,500

102,200

249,700

234,000

234,400

267,200

170,800

110,400

97,800

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit for stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,400

1,500

4,600

14,100

18,797

19,384

18,916

13,500

17,475

17,707

22,549

25,345

739,200

738,529

733,448

734,225

19,366

19,177

17,514

9,639

0

0

0

Proceeds from debt and revolving credit lines

1,586,000

1,195,400

1,099,600

1,978,800

2,652,300

2,976,400

2,963,800

1,973,800

1,125,000

786,000

581,000

493,000

515,000

355,000

388,000

537,000

517,000

555,000

1,292,200

1,079,200

989,200

876,200

117,679

185,087

311,700

407,700

1,052,817

1,002,465

1,130,852

1,199,352

0

0

0

-

-

-

-

-

-

-

-

Payments on debt and revolving credit lines

1,503,400

1,322,900

1,356,500

1,524,600

1,881,800

1,925,100

1,653,300

1,302,400

652,300

495,400

558,300

608,400

544,400

465,300

475,400

450,100

504,200

555,200

1,177,900

1,092,700

987,300

900,100

279,714

434,020

574,119

567,300

897,301

806,244

838,608

857,477

505,809

456,871

452,867

330,689

225,973

178,235

1,116

498

0

0

0

Other, net

-7,700

-14,400

-10,400

-14,600

-16,200

-9,100

-14,200

-9,800

-12,300

-12,600

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

-98,700

-292,600

-470,800

372,500

714,800

989,400

1,122,600

389,400

195,800

66,500

-22,900

-79,300

-60,200

-162,300

-140,400

-125,000

-190,800

-204,900

-119,900

-150,000

-65,600

-51,500

-144,605

-166,503

-177,740

-98,400

232,703

269,907

361,735

426,407

67,313

631,063

521,609

464,167

548,463

29,168

6,229

-20,164

0

0

0

Effect of exchange rate changes on cash and cash equivalents

-14,200

-400

-9,200

-3,700

-18,300

-12,500

-8,300

-1,800

18,700

17,400

9,200

3,100

-5,500

-6,800

300

-3,400

900

-11,700

-14,000

-18,400

-19,600

-10,800

-7,081

2,517

1,342

-2,000

-1,768

-476

-6,608

329

2,251

-6,371

1,719

1,602

-1,000

9,673

4,265

-552

0

0

0

Net increase in cash and cash equivalents

100

16,700

-20,800

-371,400

-57,800

-186,000

-49,600

186,100

-6,300

142,400

41,500

153,000

106,100

100,100

89,900

102,900

29,000

-32,000

-15,900

-149,900

-19,500

800

24,214

149,799

21,619

-10,600

-26,583

7,135

-65,594

3,150

3,585

-127,874

-35,196

-66,167

-72,801

-11,849

-62,731

-53,060

0

0

0

Consolidated operating income

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-