Ihs markit ltd. (INFO)
CashFlow / TTM
Feb'20Nov'19Aug'19May'19Feb'19Nov'18Aug'18May'18Feb'18Nov'17Aug'17May'17Feb'17Nov'16Aug'16May'16Feb'16
Operating activities:
Net income

874,400

499,400

377,900

442,200

407,500

539,200

563,500

607,100

591,700

417,000

400,500

221,700

172,900

152,100

0

0

0

Reconciliation of net income to net cash provided by operating activities:
Depreciation and amortization

576,100

573,100

576,500

565,900

552,900

541,200

523,800

510,500

502,300

492,500

483,600

454,500

396,000

335,700

0

0

0

Stock-based compensation expense

246,700

223,800

236,900

235,400

239,500

241,700

230,800

241,700

248,600

261,900

264,500

281,500

250,800

206,200

0

0

0

Gain on sale of assets

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments for acquisition-related performance compensation

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

5,600

0

0

0

Net periodic pension and postretirement expense

24,000

2,800

1,700

-5,600

-5,500

-5,600

-3,600

6,600

6,700

6,900

12,700

10,000

10,100

10,000

0

0

0

Undistributed earnings of affiliates, net

-600

-400

0

0

0

-

-

-

-

-5,200

2,400

-3,500

-4,300

-2,900

0

0

0

Pension and postretirement contributions

9,700

2,000

1,500

2,200

2,600

2,600

5,900

5,700

5,600

5,700

5,500

5,300

5,400

5,700

0

0

0

Deferred income taxes

11,100

49,600

-101,400

70,900

47,200

211,700

204,800

261,800

296,800

100,100

97,900

41,400

-2,600

-6,700

0

0

0

Change in assets and liabilities:
Accounts receivable, net

2,000

67,900

57,200

-8,300

56,900

11,800

11,300

64,800

121,400

27,500

62,600

31,900

-16,100

8,500

0

0

0

Other current assets

69,400

79,900

40,800

39,500

33,000

2,200

6,300

9,900

14,400

34,600

70,000

300

2,300

-12,300

0

0

0

Accounts payable

5,400

30,900

31,300

31,900

37,600

32,500

-15,800

-16,700

-8,500

-20,000

10,600

-6,400

-8,600

-12,500

0

0

0

Accrued expenses

-23,700

39,700

103,100

63,000

71,100

82,500

15,400

14,500

-41,100

-42,800

-40,100

-44,900

-18,900

35,600

0

0

0

Income tax

45,400

88,700

96,100

37,400

-2,500

23,500

2,400

14,400

36,500

-14,700

-22,000

-80,500

-60,300

-44,700

0

0

0

Deferred revenue

27,700

38,800

32,200

24,200

64,200

26,600

3,500

1,700

-7,400

4,700

9,300

-1,400

21,100

-14,600

0

0

0

Other liabilities

61,900

68,400

39,100

27,100

50,300

37,000

73,900

53,600

19,300

18,700

4,900

5,700

5,900

9,900

0

0

0

Net cash provided by operating activities

1,182,800

1,251,300

1,383,100

1,316,600

1,274,600

1,289,500

1,174,900

1,095,800

913,700

961,500

881,800

761,100

737,200

638,300

0

0

0

Investing activities:
Capital expenditures on property and equipment

292,900

278,100

254,100

237,900

230,700

222,700

236,900

244,400

243,700

260,200

240,100

225,400

194,800

147,600

0

0

0

Intangible assets acquired

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

Payments to acquire cost- and equity-method investments

0

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

Acquisitions of businesses, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

1,014,400

0

0

0

Proceeds from sale of assets

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Change in other assets

16,500

18,300

8,100

5,700

8,200

6,200

4,000

7,100

2,000

-500

7,700

9,100

4,000

4,500

0

0

0

Settlements of forward contracts

1,000

2,100

28,200

7,200

8,700

7,000

-1,000

-3,500

-14,900

-14,500

6,200

-5,900

10,000

7,200

0

0

0

Net cash provided by (used in) investing activities

184,300

-271,500

-254,400

-2,150,800

-2,125,800

-2,112,100

-2,522,400

-657,900

-635,000

-646,300

-253,300

-128,900

81,100

-982,800

0

0

0

Financing activities:
Proceeds from borrowings

2,618,500

2,631,700

2,002,000

4,528,600

4,179,000

4,617,000

5,329,900

2,832,100

2,544,500

3,194,500

3,059,500

4,708,000

4,352,000

4,018,000

0

0

0

Repayment of borrowings

3,005,100

3,188,900

3,014,000

3,725,600

2,858,500

3,122,600

3,246,700

2,355,900

1,980,700

2,381,200

2,344,100

4,280,000

4,228,300

3,364,800

0

0

0

Payment of debt issuance costs

-

-

-

-

-

30,800

30,900

19,500

11,900

14,400

14,400

16,900

16,900

22,800

0

0

0

Payments for purchase of noncontrolling interests

-

-

-

-

-

10,100

64,700

64,700

64,700

57,000

0

0

0

-

-

-

-

Proceeds from noncontrolling interests

0

12,500

12,500

12,500

12,500

0

0

0

0

-

-

-

-

-

-

-

-

Contingent consideration payments

0

2,200

2,200

45,200

45,200

43,000

0

0

0

-

-

-

-

-

-

-

-

Dividends paid

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the exercise of employee stock options

282,900

177,700

201,700

175,700

198,800

230,000

196,800

256,000

291,200

331,600

375,400

334,800

244,600

147,300

0

0

0

Payments related to tax withholding for stock-based compensation

123,600

75,600

75,300

78,600

80,400

95,000

93,300

98,700

99,500

89,900

0

0

0

-

-

-

-

Repurchases of common shares

1,000,000

500,000

200,000

0

500,000

672,500

672,500

984,600

965,400

1,317,800

1,623,200

1,469,700

990,600

570,000

0

0

0

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

5,600

0

0

0

Net cash used in financing activities

-1,308,200

-958,000

-1,089,900

839,900

880,000

873,000

1,373,000

-430,400

-281,600

-329,300

-653,500

-824,400

-736,400

177,500

0

0

0

Foreign exchange impact on cash balance

-48,200

-30,300

-69,100

-55,200

-51,600

-64,200

-24,900

-11,000

4,100

9,000

-21,900

9,200

11,700

12,800

0

0

0

Net increase in cash and cash equivalents

10,700

-8,500

-30,300

-49,500

-22,800

-13,800

600

-3,500

1,200

-5,100

-46,900

-183,000

93,600

-154,200

0

0

0