Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Ingersoll-Rand plc (Ireland) logo

Ingersoll-Rand plc (Ireland)

Sector: Industrials   

Industry: Diversified Industrials

92.03
 
USD
  
-0.47
  
(-0.51%)
Optionable: Yes  Market Cap: 36,539 M  90-day average vol: 2,508,625

Previous close: 92.5  Open: 91.29  Bid: 92.52  Ask: 100.0
52 week range    
54.54   
   96.17
Peers   
LII / 
DOV / 
JCI / 
FLS / 
PH / 
AAON / 
Last updated: Friday 26th April 2024
64
MarketXLS Rank
50
Value
76
Technical
68
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

IR Cash Flow

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-23 M-13 M19 M159 M-134 M-226 M117 M
(Increase) Decrease in other working capital57 M-41 M-42 M-37 M-45 M2 M-29 M
(Increase) Decrease in payables40 M70 M-9 M-43 M118 M120 M-24 M
(Increase) Decrease in receivables-66 M13 M55 M52 M-62 M-195 M-49 M
Acquisitions-19 M-186 M-12 M9 M-975 M-247 M-963 M
Amortization of intangibles119 M126 M124 M335 M333 M348 M368 M
AssetImpairmentCharge2 M20 M
CapitalExpenditureReported57 M52 M43 M42 M64 M95 M105 M
Cash at beginning of period256 M393 M221 M506 M1,751 M2,110 M1,613 M
Cash at end of period393 M221 M548 M1,942 M2,110 M1,613 M1,596 M
Cash flow201 M445 M386 M820 M1,193 M865 M1,377 M
Cash from disc. investing activities-7 M1,944 M4 M
CashFlowFromContinuingInvestingActivities-61 M-235 M-54 M-31 M-1,029 M-337 M-1,060 M
CashFromDiscontinuedOperatingActivities285 M29 M10 M
ChangeInAccountPayable40 M70 M-9 M-43 M118 M120 M-24 M
ChangeInAccruedExpense-25 M-39 M-26 M116 M-220 M101 M95 M
ChangeInInterestPayable-25 M-39 M-26 M137 M
ChangeInPayablesAndAccruedExpense15 M31 M-35 M72 M-102 M222 M71 M
ChangeInWorkingCapital-17 M-10 M-4 M247 M-344 M-197 M111 M
CommonStockDividendPaid-8 M-32 M-32 M
CommonStockPayments-4 M-41 M-19 M-2 M-737 M-261 M-263 M
Current deferred income taxes-249 M4 M21 M83 M-104 M-86 M-77 M
Deferred income taxes-249 M4 M21 M83 M-104 M-86 M-77 M
Depreciation55 M55 M54 M77 M89 M85 M92 M
Depreciation unreconciled174 M180 M178 M413 M422 M433 M459 M
DepreciationAndAmortization174 M180 M178 M413 M422 M433 M459 M
EarningsLossesFromEquityInvestments11 M-700000.06 M
Effect of exchange rate changes15 M-9 M7 M40 M-14 M-70 M3 M
FinancingCashFlow-17 M-373 M-11 M329 M-1,157 M-954 M-337 M
Free cash flow152 M396 M344 M1,065 M573 M771 M1,280 M
GainLossOnSaleOfPPE800000.0-1 M800000.0
IncomeTaxPaidSupplementalData56 M103 M62 M106 M428 M182 M302 M
InterestPaidSupplementalData143 M99 M86 M99 M80 M95 M101 M
Issuance of capital stock894 M
IssuanceOfCapitalStock894 M
IssuanceOfDebt-869 M-338 M-33 M313 M-436 M-656 M-46 M
Net cash from financing activities-17 M-373 M-11 M329 M-1,157 M-954 M-337 M
Net cash from investing activities-61 M-235 M-54 M-38 M-1,029 M-337 M-1,060 M
Net cash from operating activities201 M445 M386 M1,105 M628 M865 M1,377 M
Net change in cash & cash equivalents138 M-172 M327 M1,396 M373 M-427 M-21 M
Net income from continuing operations19 M269 M159 M-57 M1,088 M593 M785 M
NetBusinessPurchaseAndSale-19 M-186 M-12 M9 M-975 M-247 M-963 M
NetCommonStockIssuance890 M-41 M-19 M-2 M-737 M-261 M-263 M
NetForeignCurrencyExchangeGainLoss9 M-2 M8 M19 M-12 M-6 M5 M
NetInvestmentPropertiesPurchaseAndSale6 M4 M300000.0
NetInvestmentPurchaseAndSale6 M4 M300000.0
NetIssuancePaymentsOfDebt-869 M-338 M-33 M313 M-436 M-656 M-46 M
NetLongTermDebtIssuance-869 M-338 M-33 M313 M-436 M-656 M-46 M
NetPPEPurchaseAndSale-48 M-49 M-42 M-40 M-55 M-95 M-98 M
Operating (gains) losses95 M-2 M11 M27 M10 M500000.027 M
Other financing charges net-5 M-1 M-2 M-5 M-24 M-26 M
Other investing changes net6 M4 M300000.0
Other non-cash items179 M3 M20 M107 M120 M122 M72 M
Payment of cash dividends8 M32 M32 M
ProceedsFromStockOptionExercised7 M43 M23 M24 M19 M30 M
Purchase of property plant & equipment-48 M-49 M-42 M-40 M-55 M-95 M-98 M
Purchase of short term investments2,011 M1,980 M1,490 M
PurchaseOfPPE-57 M-52 M-43 M-42 M-64 M-95 M-105 M
Repayment of debt-2,879 M-338 M-33 M-1,667 M-436 M-656 M-1,536 M
RepaymentOfDebt-2,879 M-338 M-33 M-1,667 M-436 M-656 M-1,536 M
Repurchase of capital stock-4 M-41 M-19 M-2 M-737 M-261 M-263 M
Revenue per share119 M126 M124 M335 M333 M348 M368 M
SaleOfBusiness9 M
SaleOfPPE9 M4 M900000.02 M10 M8 M
StockBasedCompensation175 M3 M19 M48 M87 M79 M52 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University