Ihs Markit (INFO) trailing twelve month cash flow statement covering six trailing twelve month periods to November 30, 2021, as reported to the SEC.
A cash flow statement shows the cash that actually came in and went out, split between running the business, investing and financing.
| Nov'21 | Aug'21 | May'21 | Feb'21 | Nov'20 | Aug'20 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Operating activities: | |||||||||||||||||||||
Net income | |||||||||||||||||||||
1,206,000 | 619,600 | 622,200 | 534,100 | 869,400 | 920,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net income | 1,206,000 | 619,600 | 622,200 | 534,100 | 869,400 | 920,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Reconciliation of net income to net cash provided by operating activities: | |||||||||||||||||||||
Depreciation and amortization | |||||||||||||||||||||
586,500 | 596,500 | 599,000 | 597,900 | 591,600 | 584,400 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Depreciation and amortization | 586,500 | 596,500 | 599,000 | 597,900 | 591,600 | 584,400 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Stock-based compensation expense | |||||||||||||||||||||
226,900 | 224,300 | 227,600 | 248,900 | 265,700 | 266,300 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Stock-based compensation expense | 226,900 | 224,300 | 227,600 | 248,900 | 265,700 | 266,300 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Gain on sale of assets, net | |||||||||||||||||||||
534,600 | 7,000 | 6,600 | 5,100 | 377,300 | 372,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Gain on sale of assets, net | 534,600 | 7,000 | 6,600 | 5,100 | 377,300 | 372,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Impairment of assets | |||||||||||||||||||||
13,200 | 38,800 | 37,700 | 35,100 | 33,800 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Impairment of assets | 13,200 | 38,800 | 37,700 | 35,100 | 33,800 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Payment for acquisition related performance compensation | |||||||||||||||||||||
- | 151,800 | 151,800 | - | 75,900 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Payment for acquisition related performance compensation | - | 151,800 | 151,800 | - | 75,900 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Excess tax benefit from stock-based compensation | |||||||||||||||||||||
- | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Excess tax benefit from stock-based compensation | - | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net periodic pension and postretirement expense | |||||||||||||||||||||
- | 1,200 | 1,200 | 10,100 | 31,600 | 32,500 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net periodic pension and postretirement expense | - | 1,200 | 1,200 | 10,100 | 31,600 | 32,500 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Undistributed loss of equity-method investees, net | |||||||||||||||||||||
-200 | -6,300 | -3,100 | 300 | -900 | -800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Undistributed loss of equity-method investees, net | -200 | -6,300 | -3,100 | 300 | -900 | -800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Pension and postretirement contributions | |||||||||||||||||||||
- | 1,200 | 3,300 | 26,200 | 34,400 | 34,100 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Pension and postretirement contributions | - | 1,200 | 3,300 | 26,200 | 34,400 | 34,100 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Deferred income taxes | |||||||||||||||||||||
136,300 | 148,000 | 144,300 | 142,500 | 134,700 | 170,400 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Deferred income taxes | 136,300 | 148,000 | 144,300 | 142,500 | 134,700 | 170,400 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Change in assets and liabilities: | |||||||||||||||||||||
Accounts receivable, net | |||||||||||||||||||||
68,700 | 41,900 | 5,700 | 27,200 | -1,600 | 18,400 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Accounts receivable, net | 68,700 | 41,900 | 5,700 | 27,200 | -1,600 | 18,400 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Other current assets | |||||||||||||||||||||
-15,500 | -44,300 | -9,400 | 8,100 | 21,900 | 35,500 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Other current assets | -15,500 | -44,300 | -9,400 | 8,100 | 21,900 | 35,500 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Accounts payable | |||||||||||||||||||||
30,100 | 14,800 | -3,200 | -7,600 | -17,300 | -9,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Accounts payable | 30,100 | 14,800 | -3,200 | -7,600 | -17,300 | -9,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Accrued expenses | |||||||||||||||||||||
-23,100 | -54,900 | -45,700 | 14,300 | 11,400 | -54,100 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Accrued expenses | -23,100 | -54,900 | -45,700 | 14,300 | 11,400 | -54,100 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Income tax | |||||||||||||||||||||
87,300 | 13,700 | 21,500 | 10,500 | -41,200 | -71,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Income tax | 87,300 | 13,700 | 21,500 | 10,500 | -41,200 | -71,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Deferred revenue | |||||||||||||||||||||
85,200 | 84,400 | 46,500 | 17,100 | 5,700 | 6,600 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Deferred revenue | 85,200 | 84,400 | 46,500 | 17,100 | 5,700 | 6,600 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Other assets and liabilities | |||||||||||||||||||||
-2,000 | -15,400 | -1,800 | 12,800 | 29,800 | 56,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Other assets and liabilities | -2,000 | -15,400 | -1,800 | 12,800 | 29,800 | 56,800 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net cash provided by operating activities | |||||||||||||||||||||
1,486,200 | 1,375,500 | 1,357,600 | 1,263,800 | 1,138,800 | 1,026,200 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net cash provided by operating activities | 1,486,200 | 1,375,500 | 1,357,600 | 1,263,800 | 1,138,800 | 1,026,200 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Investing activities: | |||||||||||||||||||||
Capital expenditures on property and equipment | |||||||||||||||||||||
294,300 | 283,000 | 270,400 | 269,400 | 274,800 | 290,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Capital expenditures on property and equipment | 294,300 | 283,000 | 270,400 | 269,400 | 274,800 | 290,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Acquisitions of businesses, net of cash acquired | |||||||||||||||||||||
46,900 | 46,900 | 48,400 | 51,600 | 4,700 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Acquisitions of businesses, net of cash acquired | 46,900 | 46,900 | 48,400 | 51,600 | 4,700 | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Proceeds from sale of assets | |||||||||||||||||||||
48,600 | 6,600 | 10,400 | 10,400 | 476,600 | 474,300 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from sale of assets | 48,600 | 6,600 | 10,400 | 10,400 | 476,600 | 474,300 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Intangible assets acquired | |||||||||||||||||||||
- | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Intangible assets acquired | - | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Payments to acquire equity investments | |||||||||||||||||||||
307,800 | 186,400 | 158,200 | 157,800 | 9,100 | 18,900 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Payments to acquire equity investments | 307,800 | 186,400 | 158,200 | 157,800 | 9,100 | 18,900 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Change in other assets | |||||||||||||||||||||
-1,800 | -100 | 300 | 4,500 | 1,800 | 700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Change in other assets | -1,800 | -100 | 300 | 4,500 | 1,800 | 700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Settlements of forward contracts | |||||||||||||||||||||
-200 | -14,000 | -50,600 | -27,100 | -18,800 | -38,700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Settlements of forward contracts | -200 | -14,000 | -50,600 | -27,100 | -18,800 | -38,700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net cash (used in) provided by investing activities | |||||||||||||||||||||
-598,400 | -495,600 | -416,300 | -445,800 | 205,000 | 190,600 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net cash (used in) provided by investing activities | -598,400 | -495,600 | -416,300 | -445,800 | 205,000 | 190,600 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Financing activities: | |||||||||||||||||||||
Proceeds from borrowings | |||||||||||||||||||||
565,000 | 887,600 | 885,300 | 827,900 | 861,700 | 1,185,900 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from borrowings | 565,000 | 887,600 | 885,300 | 827,900 | 861,700 | 1,185,900 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Repayment of borrowings | |||||||||||||||||||||
832,000 | 970,900 | 1,302,800 | 927,600 | 1,086,700 | 1,288,700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Repayment of borrowings | 832,000 | 970,900 | 1,302,800 | 927,600 | 1,086,700 | 1,288,700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Payment of debt issuance costs | |||||||||||||||||||||
- | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Payment of debt issuance costs | - | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Payments for purchase of noncontrolling interests | |||||||||||||||||||||
- | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Payments for purchase of noncontrolling interests | - | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Proceeds from noncontrolling interests | |||||||||||||||||||||
- | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from noncontrolling interests | - | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Contingent consideration payments | |||||||||||||||||||||
1,400 | 1,400 | 1,000 | 1,000 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Contingent consideration payments | 1,400 | 1,400 | 1,000 | 1,000 | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Repurchases of common shares | |||||||||||||||||||||
- | 200,000 | 200,000 | 450,000 | 950,000 | 1,050,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Repurchases of common shares | - | 200,000 | 200,000 | 450,000 | 950,000 | 1,050,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Payments related to tax withholding for stock-based compensation | |||||||||||||||||||||
123,100 | 127,000 | 126,800 | 91,800 | 128,200 | 127,300 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Payments related to tax withholding for stock-based compensation | 123,100 | 127,000 | 126,800 | 91,800 | 128,200 | 127,300 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Proceeds from the exercise of employee stock options | |||||||||||||||||||||
12,500 | 19,300 | 54,000 | 98,700 | 229,000 | 260,900 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Proceeds from the exercise of employee stock options | 12,500 | 19,300 | 54,000 | 98,700 | 229,000 | 260,900 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Dividends paid | |||||||||||||||||||||
318,600 | 306,200 | 294,100 | 282,000 | 270,400 | 203,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Dividends paid | 318,600 | 306,200 | 294,100 | 282,000 | 270,400 | 203,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Excess tax benefit from stock-based compensation | |||||||||||||||||||||
- | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Excess tax benefit from stock-based compensation | - | - | - | - | - | - | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net cash used in financing activities | |||||||||||||||||||||
-697,600 | -698,600 | -985,400 | -825,800 | -1,344,600 | -1,223,100 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net cash used in financing activities | -697,600 | -698,600 | -985,400 | -825,800 | -1,344,600 | -1,223,100 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Foreign exchange impact on cash balance | |||||||||||||||||||||
-22,700 | -200 | 53,700 | 35,900 | 14,900 | 39,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Foreign exchange impact on cash balance | -22,700 | -200 | 53,700 | 35,900 | 14,900 | 39,000 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||
Net increase (decrease) in cash and cash equivalents | |||||||||||||||||||||
167,500 | 181,100 | 9,600 | 28,100 | 14,100 | 32,700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | ||||||
Net increase (decrease) in cash and cash equivalents | 167,500 | 181,100 | 9,600 | 28,100 | 14,100 | 32,700 | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | xxxxx | |||||