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

89.57
 
USD
  
-1.31
  
(-1.44%)
Optionable: Yes  Market Cap: 36,664 M  90-day average vol: 2,524,084

Previous close: 90.88  Open: 91.48  Bid: 84.0  Ask: 97.0
52 week range    
53.24   
   96.17
Peers   
LII / 
DOV / 
JCI / 
FLS / 
PH / 
AAON / 
Last updated: Thursday 18th April 2024
47
MarketXLS Rank
50
Value
23
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 Balance Sheet

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""21 M8 M8 M40 M39 M37 M31 M
Accounts payable270 M340 M323 M536 M671 M779 M801 M
Accounts receivable536 M525 M459 M862 M949 M1,122 M1,234 M
Accrued expenses541 M589 M567 M1,245 M1,412 M1,638 M1,797 M
Accumulated depreciation & depletion-204 M-250 M-298 M-412 M-422 M-433 M-501 M
Additional paid in capital2,275 M2,283 M2,302 M9,310 M9,409 M9,477 M9,551 M
Building & improvements137 M141 M155 M278 M300 M298 M337 M
Cash and equivalents393 M221 M506 M1,751 M2,110 M1,613 M1,596 M
CashCashEquivalentsAndShortTermInvestments393 M221 M506 M1,751 M2,110 M1,613 M1,596 M
CashEquivalents393 M221 M506 M3 M3 M
Common par2 M2 M2 M4 M4 M4 M4 M
Common stock equity1,477 M1,676 M1,870 M9,120 M9,002 M9,196 M9,784 M
CommonStock2 M2 M2 M4 M4 M4 M4 M
Construction in progress34 M32 M29 M40 M59 M81 M
Cost in excess1,228 M1,290 M1,288 M5,583 M5,982 M6,064 M6,610 M
CurrentAccruedExpenses271 M249 M244 M709 M741 M859 M996 M
CurrentCapitalLeaseObligation23 M26 M18 M47 M35 M40 M42 M
CurrentDeferredRevenue43 M52 M165 M242 M306 M331 M
CurrentDeferredTaxesLiabilities322 M-342 M-319 M-908 M-888 M-790 M-769 M
DeferredFinancingCosts-3 M-8 M-41 M-29 M-22 M-23 M
DefinedPensionBenefit302 M270 M310 M680 M682 M460 M444 M
DividendsPayable-8 M-32 M-32 M
EmployeeBenefits100 M95 M100 M273 M195 M147 M150 M
Finished goods61 M83 M71 M195 M283 M339 M338 M
Float term debt2,019 M1,664 M1,604 M3,859 M3,402 M2,716 M2,693 M
GoodwillAndOtherIntangibleAssets2,659 M2,658 M2,543 M9,380 M9,894 M9,643 M10,221 M
Gross fixed assets (Plant Property & Equipment)567 M607 M625 M1,022 M1,071 M1,057 M1,212 M
IncomeTaxPayable35 M24 M23 M116 M42 M63 M78 M
Intangibles1,431 M1,368 M1,255 M3,797 M3,913 M3,579 M3,611 M
InterestPayable141 M100 M89 M111 M88 M103 M157 M
Inventories495 M524 M503 M717 M854 M1,025 M1,001 M
Invested capital6,375 M5,004 M5,078 M16,838 M15,805 M14,628 M15,170 M
Land & improvements35 M35 M34 M54 M60 M65 M68 M
Leases17 M16 M15 M14 M12 M
LongTermCapitalLeaseObligation58 M138 M96 M120 M182 M
LongTermDebtAndCapitalLeaseObligation2,019 M1,664 M1,604 M3,859 M3,402 M2,716 M2,693 M
LongTermProvisions4 M2 M4 M10 M7 M10 M9 M
Machinery furniture & equipment262 M276 M364 M485 M548 M557 M656 M
Minority interest70 M70 M61 M63 M
Net fixed assets (net PP&E)363 M357 M327 M609 M649 M624 M711 M
NetOtherUnrealizedGainLoss-800000.0-1 M800000.0
Non-current deferred income taxes238 M266 M251 M702 M709 M611 M613 M
NonCurrentDeferredAssets1000000.01 M3 M16 M28 M22 M32 M
NonCurrentDeferredLiabilities238 M266 M251 M702 M709 M611 M613 M
NonCurrentDeferredRevenue1 M1 M1000000.0
NonCurrentDeferredTaxesAssets1000000.01 M3 M16 M28 M22 M32 M
NonCurrentPensionAndOtherPostretirementBenefitPlans100 M95 M100 M273 M195 M147 M150 M
Number of employees17000.017000.017000.017000.017000.017000.017000.0
Other current assets40 M61 M77 M533 M203 M207 M220 M
Other equity adjustments-200 M-247 M-256 M14 M-42 M
Other fixed assets17 M357 M327 M609 M649 M624 M711 M
Other non-current assets135 M140 M212 M2,192 M469 M509 M549 M
Other non-current liabilities226 M190 M229 M344 M310 M361 M434 M
Other receivable2,375 M2,690 M2,452 M3,973 M5,152 M5,916 M6,876 M
OtherCurrentBorrowings39 M37 M31 M
OtherCurrentLiabilities7 M63 M61 M213 M17 M223 M262 M
OtherInventories481 M524 M503 M717 M854 M1,025 M1,001 M
OtherPayable19 M186 M12 M-15 M975 M247 M
Payables270 M340 M323 M536 M671 M779 M801 M
Raw materials363 M369 M371 M451 M507 M625 M591 M
RecievablesAdjustmentsAllowances-19 M-17 M-18 M-51 M-42 M-47 M-54 M
Restricted cash221 M506 M1,751 M3 M1 M1 M
Retained earnings-578 M-556 M-397 M-161 M337 M699 M1,470 M
SecuritySoldNotYetRepurchased4 M-41 M-19 M-2 M737 M261 M
Short term debt21 M8 M8 M40 M39 M37 M31 M
Total assets4,621 M4,487 M4,628 M16,059 M15,155 M14,766 M15,564 M
Total current assets1,464 M1,331 M1,544 M3,862 M4,115 M3,967 M4,050 M
Total current liabilities562 M596 M575 M1,499 M1,468 M1,674 M1,827 M
Total equity1,477 M1,676 M1,870 M9,120 M9,002 M9,196 M9,784 M
Total liabilities3,144 M2,811 M2,759 M6,869 M6,083 M5,509 M5,717 M
Total non-current assets3,158 M3,156 M3,085 M12,197 M11,040 M10,799 M11,513 M
Total non-current liabilities2,583 M2,215 M2,184 M5,371 M4,616 M3,835 M3,890 M
TotalEquityGrossMinority1,477 M1,676 M1,870 M9,190 M9,071 M9,257 M9,847 M
TotalEquityGrossMinorityInterest1,477 M1,676 M1,870 M9,190 M9,071 M9,257 M9,847 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest4,621 M4,487 M4,628 M16,059 M15,155 M14,766 M15,564 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,583 M2,215 M2,184 M5,371 M4,616 M3,835 M3,890 M
Treasury stock-23 M-53 M-37 M-33 M-748 M-984 M-1,241 M
Work in progress58 M58 M48 M62 M89 M122 M145 M
Working capital902 M735 M969 M2,364 M2,647 M2,293 M2,223 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