Condensed Consolidated Statements of Cash Flows - USD ($)
$ in Millions |
9 Months Ended |
Aug. 31, 2016 |
Aug. 31, 2015 |
| Operating activities: |
|
|
| Net income (loss) attributable to IHS Markit Ltd. |
$ 63.5
|
$ 149.6
|
| Reconciliation of net income to net cash provided by operating activities: |
|
|
| Depreciation and amortization |
216.5
|
174.8
|
| Stock-based compensation expense |
144.9
|
101.2
|
| Gain on sale of business |
(41.5)
|
0.0
|
| Impairment of assets |
0.0
|
1.2
|
| Excess tax benefit from stock-based compensation |
(1.8)
|
(5.9)
|
| Net periodic pension and postretirement expense |
1.2
|
1.5
|
| Undistributed earnings of affiliates, net |
1.2
|
0.0
|
| Pension and postretirement contributions |
(2.2)
|
(3.0)
|
| Deferred income taxes |
6.1
|
(21.3)
|
| Change in assets and liabilities: |
|
|
| Accounts receivable, net |
65.8
|
101.3
|
| Other current assets |
39.9
|
(20.4)
|
| Accounts payable |
(40.6)
|
2.0
|
| Accrued expenses |
7.1
|
(32.1)
|
| Income tax |
(5.8)
|
45.8
|
| Deferred revenue |
10.7
|
(1.3)
|
| Other liabilities |
10.1
|
3.2
|
| Net cash provided by operating activities |
475.1
|
496.6
|
| Investing activities: |
|
|
| Capital expenditures on property and equipment |
(99.3)
|
(97.7)
|
| Acquisitions of businesses, net of cash acquired |
(1,014.4)
|
(369.9)
|
| Proceeds from sale of business |
190.2
|
0.0
|
| Change in other assets |
0.3
|
3.3
|
| Settlements of forward contracts |
5.6
|
0.8
|
| Net cash used in investing activities |
(917.6)
|
(463.5)
|
| Financing activities: |
|
|
| Proceeds from borrowings |
3,423.0
|
465.0
|
| Repayment of borrowings |
(2,876.8)
|
(222.3)
|
| Payment of debt issuance costs |
(22.8)
|
0.0
|
| Excess tax benefit from stock-based compensation |
1.8
|
5.9
|
| Proceeds from the exercise of employee stock options |
69.1
|
0.0
|
| Repurchases of common stock |
(264.6)
|
(148.6)
|
| Net cash provided by financing activities |
329.7
|
100.0
|
| Foreign exchange impact on cash balance |
20.4
|
(22.7)
|
| Net increase (decrease) in cash and cash equivalents |
(92.4)
|
110.4
|
| Cash and cash equivalents at the beginning of the period |
291.6
|
153.2
|
| Cash and cash equivalents at the end of the period |
$ 200.7
|
$ 263.6
|