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

484,000

202,300

39,200

148,900

109,000

80,800

103,500

114,200

240,700

105,100

147,100

98,800

66,000

88,600

-31,700

50,000

45,200

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

145,300

142,100

144,700

144,000

142,300

145,500

134,100

131,000

130,600

128,100

120,800

122,800

120,800

119,200

91,700

64,300

60,500

Stock-based compensation expense

82,600

56,500

54,000

53,600

59,700

69,600

52,500

57,700

61,900

58,700

63,400

64,600

75,200

61,300

80,400

33,900

30,600

Gain on sale of assets

372,300

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments for acquisition-related performance compensation

-75,900

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

3,800

1,700

100

0

Net periodic pension and postretirement expense

21,500

2,100

200

200

300

1,000

-7,100

300

200

3,000

3,100

400

400

8,800

400

500

300

Undistributed earnings of affiliates, net

-200

-200

0

-200

0

-

-

-

-

-9,300

4,700

800

-1,400

-1,700

-1,200

0

0

Pension and postretirement contributions

8,200

900

200

400

500

400

900

800

500

3,700

700

700

600

3,500

500

800

900

Deferred income taxes

-15,100

159,500

-153,300

20,000

23,400

8,500

19,000

-3,700

187,900

1,600

76,000

31,300

-8,800

-600

19,500

-12,700

-12,900

Change in assets and liabilities:
Accounts receivable, net

89,800

50,400

-10,100

-128,100

155,700

39,700

-75,600

-62,900

110,600

39,200

-22,100

-6,300

16,700

74,300

-52,800

-54,300

41,300

Other current assets

41,000

27,200

-1,300

2,500

51,500

-11,900

-2,600

-4,000

20,700

-7,800

1,000

500

40,900

27,600

-68,700

2,500

26,300

Accounts payable

-21,500

45,400

-3,400

-15,100

4,000

45,800

-2,800

-9,400

-1,100

-2,500

-3,700

-1,200

-12,600

28,100

-20,700

-3,400

-16,500

Accrued expenses

-142,000

29,500

68,500

20,300

-78,600

92,900

28,400

28,400

-67,200

25,800

27,500

-27,200

-68,900

28,500

22,700

-1,200

-14,400

Income tax

-40,000

-17,900

74,600

28,700

3,300

-10,500

15,900

-11,200

29,300

-31,600

27,900

10,900

-21,900

-38,900

-30,600

31,100

-6,300

Deferred revenue

151,800

-200

-49,600

-74,300

162,900

-6,800

-57,600

-34,300

125,300

-29,900

-59,400

-43,400

137,400

-25,300

-70,100

-20,900

101,700

Other liabilities

9,700

6,000

33,200

13,000

16,200

-23,300

21,200

36,200

2,900

13,600

900

1,900

2,300

-200

1,700

2,100

6,300

Net cash provided by operating activities

119,500

225,700

412,900

424,700

188,000

357,500

346,400

382,700

202,900

242,900

267,300

200,600

250,700

163,200

146,600

176,700

151,800

Investing activities:
Capital expenditures on property and equipment

78,000

78,200

70,000

66,700

63,200

54,200

53,800

59,500

55,200

68,400

61,300

58,800

71,700

48,300

46,600

28,200

24,500

Intangible assets acquired

-

-

-

-

-

-

-

-

3,100

-

-

-

0

-

-

-

-

Payments to acquire cost- and equity-method investments

3,600

-

-

-

5,100

-

-

-

0

-

-

-

-

-

-

-

-

Acquisitions of businesses, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-99,000

0

1,113,400

Proceeds from sale of assets

466,200

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Change in other assets

100

9,000

1,900

5,500

1,900

-1,200

-500

8,000

-100

-3,400

2,600

2,900

-2,600

4,800

4,000

-2,200

-2,100

Settlements of forward contracts

-2,500

-26,000

25,900

3,600

-1,400

100

4,900

5,100

-3,100

-7,900

2,400

-6,300

-2,700

12,800

-9,700

9,600

-5,500

Net cash provided by (used in) investing activities

387,000

-65,000

-34,400

-103,300

-68,800

-47,900

-1,930,800

-78,300

-55,100

-458,200

-66,300

-55,400

-66,400

-65,200

58,100

154,600

-1,130,300

Financing activities:
Proceeds from borrowings

293,800

646,800

645,700

1,032,200

307,000

17,100

3,172,300

682,600

745,000

730,000

674,500

395,000

1,395,000

595,000

2,323,000

39,000

1,061,000

Repayment of borrowings

209,100

575,900

850,100

1,370,000

392,900

401,000

1,561,700

502,900

657,000

525,100

670,900

127,700

1,057,500

488,000

2,606,800

76,000

194,000

Payment of debt issuance costs

-

-

-

-

-

-100

16,300

7,600

7,000

0

4,900

0

9,500

0

7,400

0

15,400

Payments for purchase of noncontrolling interests

-

-

-

-

-

2,400

0

0

7,700

57,000

0

0

0

-

-

-

-

Proceeds from noncontrolling interests

0

0

0

0

12,500

0

0

0

0

-

-

-

-

-

-

-

-

Contingent consideration payments

0

0

0

0

2,200

0

43,000

0

0

-

-

-

-

-

-

-

-

Dividends paid

67,700

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the exercise of employee stock options

130,900

43,600

76,500

31,900

25,700

67,600

50,500

55,000

56,900

34,400

109,700

90,200

97,300

78,200

69,100

0

0

Payments related to tax withholding for stock-based compensation

110,000

9,700

3,200

700

62,000

9,400

6,500

2,500

76,600

7,700

11,900

3,300

67,000

-

-

-

-

Repurchases of common shares

500,000

300,000

200,000

0

0

0

0

500,000

172,500

0

312,100

480,800

524,900

305,400

158,600

1,700

104,300

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

3,800

1,700

100

0

Net cash used in financing activities

-462,100

-196,100

-334,500

-315,500

-111,900

-328,000

1,595,300

-275,400

-118,900

172,000

-208,100

-126,600

-166,600

-152,200

-379,000

-38,600

747,300

Foreign exchange impact on cash balance

-12,000

22,800

-29,400

-29,600

5,900

-16,000

-15,500

-26,000

-6,700

23,300

-1,600

-10,900

-1,800

-7,600

29,500

-8,400

-700

Net increase in cash and cash equivalents

32,400

-12,600

14,600

-23,700

13,200

-34,400

-4,600

3,000

22,200

-20,000

-8,700

7,700

15,900

-61,800

-144,800

284,300

-231,900