Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Trane Technologies plc logo

Trane Technologies plc

Sector: Industrials   

Industry: Industrials

296.49
 
USD
  
1.40
  
(0.47%)
Optionable: Yes  Market Cap: 67,007 M  90-day average vol: 1,008,001

Previous close: 295.09  Open: 296.54  Bid: 278.56  Ask: 325.0
52 week range    
162.04   
   306.98
Peers   
MMIO / 
MCCK / 
PCRFY / 
Last updated: Thursday 25th April 2024
63
MarketXLS Rank
50
Value
76
Technical
63
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

TT Balance Sheet

Annual
Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""368 M483 M361 M1,107 M351 M650 M776 M350 M1,048 M802 M
Accounts payable1,163 M1,290 M1,334 M1,556 M1,705 M1,381 M1,520 M1,787 M2,092 M2,025 M
Accrued expenses3,041 M3,183 M3,230 M3,721 M3,965 M3,388 M3,563 M3,857 M4,098 M4,660 M
Accumulated depreciation & depletion-1,374 M-1,527 M-1,857 M-2,113 M-2,104 M-1,603 M-1,755 M-1,817 M-1,912 M-2,049 M
Additional paid in capital159 M97 M347 M461 M
Cash and equivalents1,937 M1,705 M1,715 M1,549 M903 M1,279 M3,290 M2,159 M1,221 M1,095 M
CashCashEquivalentsAndShortTermInvestments1,937 M1,705 M1,715 M1,549 M903 M1,279 M3,290 M2,159 M1,221 M1,095 M
CommercialPaper100 M143 M
Common par283 M266 M272 M274 M266 M263 M263 M260 M253 M252 M
Common stock equity7,069 M5,987 M6,644 M7,140 M7,023 M7,268 M6,408 M6,256 M6,089 M6,995 M
CommonStock283 M266 M272 M274 M266 M263 M263 M260 M253 M252 M
Cost in excess5,541 M5,390 M5,658 M5,936 M5,960 M5,126 M5,343 M5,505 M5,504 M6,095 M
CurrentAccruedExpenses1,878 M1,893 M1,896 M2,165 M2,260 M2,007 M2,043 M2,070 M2,006 M2,635 M
CurrentCapitalLeaseObligation112 M115 M153 M194 M197 M172 M
CurrentDeferredAssets360 M300 M
CurrentDeferredTaxesAssets360 M300 M1,414 M922 M981 M981 M934 M882 M754 M746 M
CurrentDeferredTaxesLiabilities2,152 M596 M616 M501 M331 M412 M421 M-1,320 M-1,281 M-1,259 M
CurrentProvisions14 M17 M
DefinedPensionBenefit3,195 M3,569 M3,418 M3,627 M3,365 M3,735 M3,115 M3,311 M2,343 M2,372 M
EmployeeBenefits1,288 M1,438 M1,357 M1,285 M1,193 M1,048 M1,025 M811 M667 M597 M
Finished goods760 M823 M846 M941 M1,029 M805 M761 M983 M1,280 M1,332 M
Float term debt3,154 M3,742 M3,709 M2,957 M3,741 M4,923 M4,497 M4,492 M3,788 M3,978 M
GoodwillAndOtherIntangibleAssets9,463 M9,174 M9,444 M9,679 M9,594 M8,449 M8,629 M8,810 M8,768 M9,535 M
Gross fixed assets (Plant Property & Equipment)2,842 M3,004 M3,368 M3,664 M3,835 M2,956 M3,105 M3,216 M3,449 M3,821 M
IncomeTaxPayable61 M
Intangibles3,922 M3,784 M3,785 M3,743 M3,635 M3,324 M3,286 M3,306 M3,264 M3,440 M
InterestPayable279 M225 M222 M216 M221 M243 M249 M-234 M-223 M-234 M
Inventories1,166 M1,359 M1,386 M1,555 M1,678 M1,279 M1,189 M1,531 M1,994 M2,152 M
InventoriesAdjustmentsAllowances-85 M-112 M-120 M-120 M-66 M-86 M-79 M-94 M-143 M
Invested capital11,487 M10,237 M10,353 M10,105 M11,886 M12,198 M11,212 M15,239 M13,665 M14,951 M
LongTermCapitalLeaseObligation634 M448 M495 M509 M616 M
LongTermDebtAndCapitalLeaseObligation3,154 M3,742 M3,709 M2,957 M3,741 M4,923 M4,497 M4,492 M3,788 M3,978 M
LongTermProvisions1,336 M1,174 M885 M758 M538 M572 M579 M582 M
Minority interest62 M58 M75 M67 M42 M45 M19 M17 M17 M22 M
Net fixed assets (net PP&E)1,468 M1,477 M1,511 M1,551 M1,731 M1,352 M1,350 M1,399 M1,536 M1,772 M
NetUnrealizedGainLossInvestments398 M398 M398 M
Non-current deferred income taxes49 M20 M8 M11 M11 M19 M3 M582 M680 M704 M
NonCurrentDeferredLiabilities582 M680 M704 M
NonCurrentDeferredRevenue0.00.00.00.0
NonCurrentDeferredTaxesAssets1,853 M1,695 M1,598 M1,266 M1,313 M1,290 M1,255 M1,140 M954 M910 M
NonCurrentPensionAndOtherPostretirementBenefitPlans1,288 M1,438 M1,357 M1,285 M1,193 M1,048 M1,025 M811 M667 M597 M
Number of employees39000.039000.039000.039000.039000.039000.039000.039000.039000.039000.0
Other current assets182 M225 M256 M537 M472 M345 M224 M352 M385 M666 M
Other equity adjustments-167 M-714 M-1,290 M-779 M-964 M-1,007 M-631 M
Other fixed assets1,352 M1,350 M1,399 M1,536 M1,772 M
Other non-current assets1,010 M940 M864 M824 M858 M5,604 M1,272 M1,380 M1,399 M1,215 M
Other non-current liabilities1,341 M1,233 M1,138 M1,139 M1,062 M1,398 M1,291 M1,150 M1,154 M1,043 M
Other receivable2,072 M2,119 M2,223 M2,477 M2,679 M2,185 M2,202 M2,429 M2,780 M2,957 M
OtherCurrentBorrowings368 M483 M361 M1,107 M351 M650 M776 M350 M1,048 M802 M
OtherCurrentLiabilities3,965 M3,845 M3,379 M3,181 M2,794 M824 M30 M545 M541 M592 M
OtherInventories1,239 M1,429 M1,448 M1,624 M1,761 M1,312 M1,230 M1,531 M1,994 M2,152 M
OtherPayable3,041 M234 M3,230 M3,721 M3,965 M205 M183 M269 M292 M863 M
Payables1,163 M1,290 M1,334 M1,556 M1,705 M1,381 M1,520 M1,787 M2,092 M2,025 M
Raw materials378 M488 M449 M503 M551 M334 M305 M405 M510 M605 M
RecievablesAdjustmentsAllowances-35 M-34 M-26 M-27 M-33 M-32 M-40 M-40 M-44 M-45 M
Retained earnings6,795 M6,541 M8,019 M8,903 M9,440 M9,731 M8,495 M7,716 M7,555 M8,463 M
SecuritySoldNotYetRepurchased1,213 M1,375 M250 M1,017 M900 M750 M250 M-1,100 M-1,200 M-669 M
Short term debt368 M483 M361 M1,107 M351 M650 M776 M350 M1,048 M802 M
Total assets17,658 M17,299 M17,397 M18,173 M17,915 M20,492 M18,157 M18,060 M18,082 M19,392 M
Total current assets5,717 M5,708 M5,579 M6,119 M5,732 M5,087 M6,906 M6,471 M6,379 M6,870 M
Total current liabilities3,409 M3,666 M3,590 M4,828 M4,316 M4,038 M4,339 M4,752 M5,687 M6,054 M
Total equity7,069 M5,987 M6,644 M7,140 M7,023 M7,268 M6,408 M6,256 M6,089 M6,995 M
Total liabilities10,527 M11,253 M10,679 M10,966 M10,850 M13,180 M11,730 M11,787 M11,976 M12,375 M
Total non-current assets11,941 M11,591 M11,818 M12,054 M12,183 M15,406 M11,251 M11,589 M11,702 M12,522 M
Total non-current liabilities7,118 M7,587 M7,089 M6,138 M6,534 M9,142 M7,391 M7,034 M6,290 M6,321 M
TotalEquityGrossMinority7,131 M6,045 M6,718 M7,207 M7,065 M7,312 M6,427 M6,273 M6,105 M7,017 M
TotalEquityGrossMinorityInterest7,131 M6,045 M6,718 M7,207 M7,065 M7,312 M6,427 M6,273 M6,105 M7,017 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest17,658 M17,299 M17,397 M18,173 M17,915 M20,492 M18,157 M18,060 M18,082 M19,392 M
TotalNonCurrentLiabilitiesNetMinorityInteres7,118 M7,587 M7,089 M6,138 M6,534 M9,142 M7,391 M7,034 M6,290 M6,321 M
TotalTaxPayable61 M
Treasury stock-800000.0-202 M-703 M-1,719 M-1,719 M-1,719 M-1,719 M-1,719 M-1,719 M-1,719 M
Work in progress101 M118 M154 M181 M182 M174 M164 M216 M334 M385 M
Working capital2,308 M2,042 M1,989 M1,291 M1,416 M1,048 M2,567 M1,719 M692 M816 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