Xpo logistics, inc. (XPO)

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
Operating activities
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest

413,000

440,000

424,000

403,000

417,000

444,000

559,900

515,900

414,100

360,000

185,700

136,000

129,200

85,000

-10,500

-67,300

-196,200

-191,600

-138,600

-114,700

-50,000

-63,600

-64,268

-58,694

-62,256

-48,500

-47,212

-44,335

-32,150

-20,300

-12,482

-9,143

-3,052

759

0

0

0

Adjustments to reconcile net income to net cash from operating activities
Provisions for allowance for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,845

5,173

4,569

2,600

2,110

1,443

1,078

900

887

302

256

219

0

0

0

Depreciation, Depletion and Amortization, Nonproduction

742,000

739,000

734,000

728,000

725,000

716,000

696,900

684,200

671,600

658,000

646,700

641,200

638,300

643,000

658,400

598,600

493,200

364,900

226,400

151,700

120,800

98,300

72,857

53,951

30,546

20,800

12,981

5,308

3,937

2,700

1,758

1,342

1,241

1,240

0

0

0

Stock compensation expense

72,000

67,000

33,000

35,000

40,000

49,000

92,900

90,500

85,700

79,000

70,900

68,000

58,400

55,000

42,400

31,500

37,500

27,900

21,600

20,600

7,600

7,500

6,926

6,353

5,803

4,700

4,289

4,281

4,464

4,400

4,368

3,362

2,174

1,180

0

0

0

Accretion of debt

20,000

21,000

20,000

16,000

16,000

15,000

15,500

17,300

18,400

19,000

19,200

18,700

17,700

17,000

0

0

0

-

-

-

-

7,300

5,763

5,784

5,962

6,000

0

0

0

-

-

-

-

-

-

-

-

Deferred tax benefit

49,000

46,000

57,000

49,000

33,000

45,000

-140,900

-139,000

-146,500

-158,000

-21,800

-34,700

-2,800

-21,000

-52,300

-59,800

-98,800

-91,900

-43,200

-52,300

-41,300

-30,000

-32,518

-29,967

-27,335

-22,700

-22,906

-9,670

-8,178

-8,300

-5,391

510

-736

-327

0

0

0

Gain (Loss) on Extinguishment of Debt

0

-5,000

-5,000

-22,000

-22,000

-27,000

-49,400

-37,000

-37,000

-36,000

-30,400

-79,000

-79,000

-70,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unrealized (gain) loss on foreign currency option and forward contracts

-3,000

-9,000

2,000

-1,000

22,000

20,000

13,900

3,400

-41,100

-49,000

-12,700

-3,000

30,300

40,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gains on sales of property and equipment

116,000

110,000

78,000

46,000

29,000

8,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on conversion of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other

-13,000

-21,000

-18,000

-73,000

-49,000

-8,000

-12,900

21,500

8,400

-26,000

-19,400

-12,700

-16,500

-8,000

-9,200

12,800

1,600

-9,400

-17,800

-34,300

-20,200

-11,200

-4,901

-2,430

-2,511

-2,400

0

0

0

-

-

-

-

-

-

-

-

Changes in assets and liabilities:
Accounts receivable

-223,000

67,000

-59,000

123,000

159,000

13,000

382,200

386,500

404,800

320,000

274,800

272,000

200,100

154,000

68,900

-24,000

11,900

-7,800

72,700

97,300

36,900

143,900

82,404

70,166

83,629

37,000

33,818

32,438

21,592

13,800

4,414

3,606

740

-1,627

0

0

0

Income tax receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

3,662

3,232

3,214

100

-438

-944

-677

-1,600

-1,106

-660

-1,844

239

0

0

0

Other assets

33,000

47,000

-38,000

-31,000

-11,000

49,000

145,600

158,200

129,400

92,000

-40,100

-29,000

-26,200

-13,000

140,300

90,300

95,700

35,300

-40,400

-15,000

-3,700

-9,200

-673

6,325

2,838

3,000

1,137

-1,020

-2,518

-800

0

0

0

-

-

-

-

Prepaid expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Other long-term assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

409

310

200

300

0

0

0

-

-

-

0

Accounts payable

-132,000

-120,000

-114,000

-2,000

33,000

35,000

87,400

107,600

141,200

140,000

201,300

68,800

36,300

2,000

-142,100

-106,900

-131,200

-51,300

-45,700

-6,700

-5,400

53,900

46,625

47,013

57,317

5,200

12,311

8,200

5,665

10,900

-1,702

-1,638

1,668

-191

0

0

0

Accrued expenses and other liabilities

-187,000

-213,000

-162,000

-145,000

-87,000

-123,000

-14,800

78,200

43,500

1,000

-192,900

-169,400

-137,800

-56,000

94,700

51,800

57,400

43,500

25,600

27,900

1,000

28,800

14,886

3,061

18,059

4,200

-441

-77

-7,141

-1,200

5,933

3,638

3,356

1,331

0

0

0

Net cash provided by (used in) operating activities

1,067,000

791,000

1,008,000

1,018,000

1,025,000

1,102,000

801,500

807,100

750,500

785,000

736,900

580,300

630,600

622,000

456,000

381,600

50,400

90,800

31,400

-17,800

34,700

-21,300

-18,055

-43,927

-46,975

-66,300

-68,926

-63,236

-49,549

-24,300

-13,615

-7,092

1,852

6,611

0

0

0

Investing activities
Payment for purchases of property and equipment

622,000

601,000

551,000

519,000

527,000

551,000

527,100

510,000

523,600

504,000

554,400

521,000

490,700

483,000

453,100

431,100

352,300

249,000

137,400

76,700

52,100

44,600

26,665

17,536

14,419

11,600

9,549

8,295

7,245

7,000

4,298

3,063

1,504

754

0

0

0

Proceeds from sale of property and equipment

259,000

252,000

243,000

166,000

180,000

143,000

150,400

137,800

107,500

118,000

70,700

75,600

72,000

69,000

79,500

71,600

77,800

60,300

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from Collection of Retained Interest in Securitized Receivables

115,000

186,000

186,000

137,000

71,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of businesses, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,887,000

1,610,100

2,223,700

681,200

814,000

920,234

640,140

633,240

458,800

0

0

0

-

-

-

-

-

-

-

-

Other

-8,000

-2,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-175

-100

0

0

0

-

-

-

-

-

-

-

-

Net cash used in investing activities

-240,000

-161,000

-101,000

-218,000

-268,000

-400,000

-389,700

-362,200

-416,100

-386,000

63,700

102,300

137,300

142,000

-2,642,200

-2,630,300

-4,113,000

-4,085,400

-1,718,600

-2,283,000

-733,200

-858,300

-946,524

-657,401

-647,484

-470,300

-411,879

-80,867

-80,430

-64,200

-10,855

-6,763

-1,491

-741

0

0

0

Financing activities
Proceeds from borrowings related to securitization program

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of debt

3,000

1,754,000

1,929,000

1,938,000

1,920,000

1,074,000

1,191,500

1,189,500

1,200,500

819,000

523,700

1,901,500

1,901,500

1,378,000

2,932,900

1,596,600

3,737,100

4,151,800

2,596,700

3,055,200

914,700

500,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of debt

-

-

-

-

-

1,225,000

1,829,100

1,687,600

1,687,600

1,387,000

1,337,700

2,400,400

2,400,400

1,889,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Credit line, net activity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Proceeds from borrowings on ABL facility

1,480,000

1,935,000

2,120,000

2,030,000

2,040,000

1,355,000

1,425,000

1,355,000

1,205,000

995,000

595,000

420,000

340,000

360,000

260,000

260,000

200,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of borrowings on ABL facility

880,000

1,935,000

2,120,000

2,030,000

2,200,000

1,455,000

1,425,000

1,355,000

1,145,000

925,000

595,000

520,000

340,000

330,000

260,000

160,000

100,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of debt and finance leases

358,000

867,000

884,000

625,000

616,000

119,000

110,100

104,700

113,800

106,000

105,500

121,300

138,400

151,000

274,600

546,400

1,257,400

1,215,600

0

0

0

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Payment for debt issuance costs

4,000

28,000

32,000

31,000

28,000

10,000

10,200

14,100

14,100

17,000

13,900

34,900

34,900

26,000

59,900

35,000

38,400

42,900

7,900

18,300

14,900

10,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payment of acquisition earn-out

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Excess tax benefit from stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

Proceeds from common stock offerings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,131,300

0

0

0

-

-

-

-

137,000

0

0

0

-

-

-

-

Repurchase of common stock

234,000

1,347,000

1,883,000

1,883,000

1,763,000

536,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of borrowings on revolving credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payment for cash held as collateral in lending arrangement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Receipt of cash held as collateral in lending arrangement

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Change in bank overdrafts

0

-

0

0

0

-

0

0

32,600

-

-30,400

-2,700

-14,900

-17,000

-1,800

-3,900

6,000

-12,300

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of options, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Payment for tax withholdings for restricted shares

28,000

14,000

15,000

12,000

15,000

53,000

50,800

48,800

46,600

17,000

16,900

25,200

21,400

11,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for equity issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

33,900

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Dividends paid

-

-

-

-

-

8,000

7,700

7,300

7,300

7,000

5,800

5,200

5,000

5,000

3,100

2,800

2,800

2,800

2,900

2,900

2,900

2,900

3,615

3,014

2,957

3,000

535

1,186

1,193

1,200

0

0

0

-

-

-

-

Other

7,000

9,000

10,000

9,000

8,000

8,000

-3,000

-6,100

-8,300

-9,000

-2,300

8,900

10,300

10,000

9,400

-3,100

-4,700

-1,700

-3,200

-2,400

-3,500

-6,900

-6,941

-4,820

-4,673

-4,100

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

-62,000

-759,000

-898,000

-654,000

-775,000

-620,000

-463,500

-386,500

-293,600

-366,000

-701,200

-779,300

-703,200

-681,000

1,259,400

1,455,000

3,308,200

3,644,900

2,297,600

3,364,600

1,588,900

1,502,200

1,577,313

634,666

632,070

305,700

251,575

131,560

131,679

266,800

249,500

203,920

204,085

67,576

0

0

0

Effect of exchange rates on cash, cash equivalents and restricted cash

-17,000

2,000

-14,000

-12,000

-25,000

-17,000

-3,400

3,300

22,000

16,000

4,200

1,000

-5,700

-4,000

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net increase (decrease) in cash, cash equivalents and restricted cash

748,000

-127,000

-5,000

134,000

-43,000

65,000

-55,100

61,700

62,800

49,000

103,600

-95,700

59,000

79,000

-925,000

-798,000

-755,300

-354,300

605,200

1,064,200

890,400

622,600

612,734

-66,662

-62,389

-230,900

-229,230

-12,543

1,700

178,300

225,030

190,065

204,446

73,446

0

0

0

Supplemental disclosure of cash flow information:
Leased assets obtained in exchange for new operating lease liabilities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Leased assets obtained in exchange for new finance lease liabilities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

309,000

282,000

263,000

233,000

239,000

233,000

269,500

266,400

268,500

274,000

280,400

317,200

338,900

363,000

333,800

297,700

200,900

168,200

97,200

63,200

54,600

19,000

21,089

13,763

13,372

12,400

6,582

3,322

3,316

0

-27

50

94

110

0

0

0

Cash paid for income taxes

120,000

121,000

113,000

101,000

75,000

70,000

65,100

64,600

63,100

79,000

59,200

55,500

55,100

41,000

55,700

53,500

33,200

14,500

3,900

-9,500

-10,100

2,300

-1,807

-1,006

-2,032

200

863

947

848

200

276

293

392

233

0

0

0

Non-cash investing and financing activities:
Property plant and equipment acquired through an increase in accounts payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Property and equipment acquired through capital lease

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Equity portion of acquisition purchase price

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

138,254

115,511

116,627

10,400

0

0

0

-

-

-

-

-

-

-

-

Equity issued upon conversion of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-