Ingersoll Rand Inc. (IR)

Import this data to Google Sheets with:

=jivedata("IR","financials")

Full statements spill as a table. For one cell: =jivedata("IR","Revenue") or =jivedata("IR","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

Ingersoll Rand Inc.

IR • CIK 0001699150

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$6,876,100	$7,235,000	$7,650,900	$7,942,200
Cost of Revenue	$3,993,900	$4,065,000	$4,314,600	$4,541,300
Gross Profit	$2,882,200	$3,170,000	$3,336,300	$3,400,900
Selling, General and Administrative Expense	$1,272,700	$1,344,400	$1,439,300	$1,489,600
Amortization of Intangible Assets	$367,500	$373,000	$387,500	$414,700
Goodwill, Impairment Loss	$0	$0	$229,700	$0
Impairment of Intangible Assets (Excluding Goodwill)	—	$13,900	$43,700	$7,600
Other Operating Income (Expense), Net	$-77,700	$-138,600	$-91,500	$-53,300
Operating Income (Loss)	$1,164,300	$1,300,100	$1,144,600	$1,435,700
InterestExpenseNonoperating	—	$213,200	$253,900	$257,100
Gain (Loss) on Extinguishment of Debt	$-13,500	$-3,000	$0	$0
Other Nonoperating Income (Expense)	$37,000	$48,900	$44,600	$32,500
Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Noncontrolling Interest	$1,031,100	$1,132,800	$935,300	$1,211,100
Income Tax Expense (Benefit)	$240,000	$262,500	$219,400	$245,100
Income (Loss) from Equity Method Investments	$-6,000	$-24,000	$-127,100	$0
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$785,100	$846,300	$588,800	$966,000
Net Income (Loss) Attributable to Noncontrolling Interest	$6,400	$7,700	$7,400	$6,900
Net Income (Loss) Attributable to Parent	$778,700	$838,600	$581,400	$959,100
Weighted Average Number of Shares Outstanding, Basic	404,800,000	403,400,000	398,100,000	385,600,000
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	4,200,000	3,800,000	2,900,000	2,200,000
Weighted Average Number of Shares Outstanding, Diluted	409,000,000	407,200,000	401,000,000	387,800,000
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	1,300,000	500,000	1,100,000	1,800,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$1,595,500	$1,541,200	$1,248,800	$1,173,500
Accounts Receivable, after Allowance for Credit Loss, Current	$1,234,200	$1,335,400	$1,518,000	$1,514,800
Property, Plant, and Equipment and Finance Lease Right-of-Use Asset, after Accumulated Depreciation and Amortization	$711,400	$842,100	$930,300	$907,100
Inventory, Net	$1,001,100	$1,055,000	$1,172,900	$1,233,000
Goodwill	$6,609,700	$8,148,100	$8,484,100	$8,541,900
Other Assets, Current	$219,600	$231,900	$308,300	$367,800
Intangible Assets, Net (Excluding Goodwill)	$3,611,100	$4,372,800	$4,240,300	$4,072,300
Assets, Current	$4,050,400	$4,163,500	$4,248,000	$4,289,100
Deferred Income Tax Assets, Net	$31,500	$26,100	$38,700	$44,100
Other Assets, Noncurrent	$549,400	$457,200	$355,800	$339,600
Assets	$15,563,500	$18,009,800	$18,297,200	$18,194,100
Long-term Debt and Lease Obligation	$2,693,000	$4,754,400	$4,783,300	$4,068,700
Liability, Defined Benefit Plan, Noncurrent	$150,000	$139,300	$134,200	$127,300
Deferred Income Tax Liabilities, Net	$612,600	$757,600	$696,900	$712,500
Other Liabilities, Noncurrent	$433,900	$294,300	$462,500	$388,200
Liabilities	$5,716,800	$7,764,500	$8,143,200	$7,951,100
Debt, Current	$30,600	$3,100	$1,400	$699,800
Accounts Payable, Current	$801,200	$843,600	$996,100	$911,400
Accrued Liabilities, Current	$995,500	$972,200	$1,068,800	$1,043,200
Liabilities, Current	$1,827,300	$1,818,900	$2,066,300	$2,654,400
Common Stock, Value, Issued	$4,300	$4,300	$4,300	$4,300
Additional Paid in Capital, Common Stock	$9,550,800	$9,633,600	$9,699,900	$9,748,700
Retained Earnings (Accumulated Deficit)	$1,697,200	$2,503,500	$3,053,100	$3,486,300
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-227,600	$-468,500	$-148,300	$-213,700
Treasury Stock, Common, Value	$1,240,900	$1,493,900	$2,519,200	$2,848,300
Stockholders' Equity Attributable to Parent	$9,783,800	$10,179,000	$10,089,800	$10,177,300
Stockholders' Equity Attributable to Noncontrolling Interest	$62,900	$66,300	$64,200	$65,700
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$9,846,700	$10,245,300	$10,154,000	$10,243,000
Accounts Receivable, Allowance for Credit Loss, Current	$53,800	$57,300	$66,800	$65,000
Property, Plant, and Equipment and Finance Lease Right-of-Use Asset, Accumulated Depreciation and Amortization	$500,800	$567,500	$689,600	$743,000
Common Stock, Shares Authorized	1,000,000,000	1,000,000,000	1,000,000,000	1,000,000,000
Common Stock, Shares, Issued	428,589,061	430,745,964	431,753,302	432,922,423
Treasury Stock, Common, Shares	25,241,667	27,865,885	40,631,613	44,927,534
Assets for Plan Benefits, Defined Benefit Plan	$18,800	$18,500	$23,500	$23,500
Liability, Defined Benefit Plan, Current	$6,200	$6,400	$4,600	$4,600
Liability, Defined Benefit Plan	$144,600	$132,600	$127,900	$127,900
Operating Lease, Right-of-Use Asset	$164,400	$226,600	$236,400	$236,400
Operating Lease, Liability, Current	$41,600	$56,300	$64,800	$64,300
Operating Lease, Liability, Noncurrent	$116,900	$165,500	$168,000	$168,000
Operating Lease, Liability	$158,500	$221,800	$232,800	$232,800
Finance Lease, Right-of-Use Asset, after Accumulated Amortization	$12,300	$11,100	$9,700	$9,700
Finance Lease, Liability, Current	$1,300	$1,300	$1,300	$1,300
Finance Lease, Liability, Noncurrent	$13,600	$12,600	$11,200	$11,200
Finance Lease, Liability	$14,900	$13,900	$12,500	$12,500

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$785,100	$846,300	$588,800	$966,000
Net Cash Provided by (Used in) Operating Activities	—	—	$1,355,700	$1,349,200
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$3,100	$-50,800	$66,300	$-10,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$-17,500	$-54,300	$-292,400	$-137,100
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$1,595,500	$1,541,200	$1,248,800	$910,400
Amortization of Intangible Assets	$367,500	$373,000	$387,500	$414,700
Payments to Acquire Productive Assets	$105,400	$149,100	$135,600	$129,900
Cost, Depreciation	$91,600	$109,000	$118,300	$120,300
Payments to Acquire Businesses, Net of Cash Acquired	$963,000	$2,958,700	$525,000	$476,600
Goodwill and Intangible Asset Impairment	—	—	$273,400	$7,600
Proceeds from Sale of Property, Plant, and Equipment	$7,600	$6,100	$0	$5,000
Restructuring Costs	$2,700	$1,600	$0	$0
Payments for (Proceeds from) Other Investing Activities	$-300	$6,000	$0	$0
Share-based Payment Arrangement, Noncash Expense	$51,900	$58,800	$53,000	$55,800
Net Cash Provided by (Used in) Investing Activities	—	—	$-660,600	$-601,500
Income (Loss) from Equity Method Investments	$-6,000	$-24,000	$-127,100	$0
Foreign Currency Transaction Gain (Loss), before Tax	$-5,100	$-3,200	$-18,600	$-10,700
Inventory, LIFO Reserve, Effect on Income, Net	$12,000	$6,700	$17,800	$19,100
Gain (Loss) on Extinguishment of Debt	$-13,500	$-3,000	$0	$0
Deferred Income Tax Expense (Benefit)	$-76,900	$-33,100	$-79,400	$-79,400
Other Noncash Income (Expense)	$-8,300	$-7,700	$-9,900	$-8,200
Repayments of Long-term Debt	$1,518,000	$1,242,700	$0	$0
Proceeds from Issuance of Long-term Debt	$1,490,400	$3,296,900	$0	$0
Payments for Repurchase of Common Stock	$263,000	$260,700	$1,018,000	$846,600
Payments of Ordinary Dividends, Common Stock	$32,400	$32,300	$31,800	$31,400
Proceeds from Stock Options Exercised	$30,300	$32,200	$15,300	$23,900
Payments for Hedge, Financing Activities	$0	$0	$0	$0
Payment for Contingent Consideration Liability, Financing Activities	$17,500	$23,400	$8,000	$11,000
Payments of Debt Issuance Costs	$18,500	$32,300	$0	$0
Proceeds from (Payments for) Other Financing Activities	$-8,800	$-10,300	$-11,300	$-9,700
Net Cash Provided by (Used in) Financing Activities	$-337,500	$1,707,500	$-1,053,800	$-874,800
Income Taxes Paid, Net	$302,000	$276,700	$269,300	$284,200
Interest Paid, Excluding Capitalized Interest, Operating Activities	$100,500	$209,000	$249,000	$248,000
Increase (Decrease) in Receivables	$48,600	$45,100	$59,100	$92,100
Increase (Decrease) in Inventories	$-117,300	$-39,800	$26,100	$16,800
Increase (Decrease) in Accounts Payable	$-23,900	$13,300	$78,700	$54,600
Increase (Decrease) in Accrued Liabilities	$94,800	$-34,500	$-35,300	$-24,200
Increase (Decrease) in Other Operating Assets and Liabilities, Net	$29,000	$24,600	$117,500	$95,300
Operating Lease, Payments	$53,700	$63,800	$77,400	$77,400
Finance Lease, Interest Payment on Liability	$1,000	$900	$800	$800
Finance Lease, Principal Payments	$1,200	$1,300	$1,300	$1,300
Right-of-Use Asset Obtained in Exchange for Operating Lease Liability	$62,500	$96,200	$55,000	$55,000

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("IR","financials")

Full statements spill as a table. For one cell: =jivedata("IR","Revenue") or =jivedata("IR","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.