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

Allegion plc

Sector: Industrials   

Industry: Security & Protection Services

103.85
 
USD
  
-0.40
  
(-0.38%)
Optionable: Yes  Market Cap: 9,291 M  90-day average vol: 764,617

Previous close: 104.25  Open: 103.66  Bid: 102.0  Ask: 105.57
52 week range    
87.33   
   128.36
Peers   
FBHS / 
ADT / 
SWK / 
NL / 
BRC / 
SPB / 
Last updated: Friday 22nd September 2023
55
MarketXLS Rank
80
Value
30
Technical
55
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

ALLE Balance Sheet

Annual
Invalid dateDec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""50 M66 M48 M35 M35 M100000.0200000.013 M13 M
Accounts payable176 M175 M180 M188 M235 M221 M220 M259 M281 M
Accounts receivable330 M322 M283 M396 M
Accrued expenses346 M372 M381 M426 M486 M507 M514 M589 M691 M
Accumulated depreciation & depletion-373 M-392 M-414 M-456 M-472 M-495 M-535 M-544 M-567 M
Additional paid in capital24 M9 M14 M
Cash and equivalents291 M200 M312 M466 M291 M359 M480 M398 M288 M
CashCashEquivalentsAndShortTermInvestments291 M200 M312 M466 M291 M359 M480 M398 M288 M
CashEquivalents312 M291 M359 M480 M398 M288 M
Common par1000000.01000000.01000000.01000000.0900000.0900000.0900000.0900000.0900000.0
Common stock equity-5 M26 M113 M402 M651 M757 M829 M759 M942 M
CommonStock1000000.01000000.01000000.01000000.0900000.0900000.0900000.0900000.0900000.0
Cost in excess484 M714 M717 M761 M883 M873 M819 M804 M1,413 M
CurrentAccruedExpenses170 M197 M199 M219 M230 M273 M276 M318 M383 M
CurrentCapitalLeaseObligation23 M19 M20 M21 M30 M30 M28 M29 M32 M
CurrentDeferredAssets33 M11 M12 M
CurrentDeferredTaxesAssets33 M11 M85 M63 M123 M178 M206 M250 M308 M
CurrentDeferredTaxesLiabilities34 M9 M16 M57 M8 M43 M58 M93 M173 M
CurrentProvisions2 M4 M13 M
Deferred revenues34 M9 M3 M
EmployeeBenefits122 M145 M135 M86 M81 M88 M79 M69 M40 M
Finished goods91 M115 M140 M143 M129 M120 M127 M194 M225 M
Float term debt1,215 M1,458 M1,416 M1,442 M1,410 M1,428 M1,429 M1,430 M2,082 M
GoodwillAndOtherIntangibleAssets610 M1,087 M1,074 M1,156 M1,430 M1,384 M1,306 M1,251 M2,022 M
Gross fixed assets (Plant Property & Equipment)580 M617 M640 M708 M749 M786 M830 M828 M309 M
IncomeTaxPayable5 M3 M18 M20 M13 M18 M12 M28 M
Intangibles125 M372 M357 M394 M547 M511 M487 M448 M609 M
InterestPayable54 M53 M64 M106 M54 M56 M51 M50 M76 M
Inventories169 M204 M221 M240 M280 M270 M283 M380 M479 M
Invested capital2,223 M1,924 M1,576 M2,041 M2,061 M2,185 M2,259 M2,189 M3,024 M
LongTermCapitalLeaseObligation1,265 M1,523 M1,464 M1,492 M1,445 M1,428 M1,430 M63 M110 M
LongTermDebtAndCapitalLeaseObligation1,215 M1,458 M1,416 M1,442 M1,410 M1,428 M1,429 M1,430 M2,082 M
LongTermProvisions57 M120 M119 M124 M116 M
Minority interest23 M4 M3 M4 M3 M3 M3 M3 M3 M
Net fixed assets (net PP&E)207 M225 M227 M252 M277 M291 M295 M284 M309 M
NetOtherUnrealizedGainLoss-2 M26 M-200000.0
NetUnrealizedGainLossForeignCurrency100000.02 M3 M400000.0
NetUnrealizedGainLossInvestments5 M6 M
Non-current deferred income taxes2 M7 M6 M7 M116 M108 M106 M101 M102 M
NonCurrentDeferredAssets72 M92 M72 M35 M85 M113 M127 M155 M228 M
NonCurrentDeferredLiabilities116 M108 M106 M101 M102 M
NonCurrentDeferredTaxesAssets72 M92 M72 M35 M85 M113 M127 M155 M228 M
NonCurrentPensionAndOtherPostretirementBenefitPlans122 M145 M135 M86 M81 M88 M79 M69 M40 M
Number of employees12300.012300.012300.012300.012300.012300.012300.012300.012300.0
Other current assets279 M17 M24 M18 M20 M29 M34 M27 M44 M
Other equity adjustments-148 M-232 M-264 M-153 M-223 M-219 M-157 M-194 M-286 M
Other non-current assets125 M125 M45 M66 M87 M177 M197 M244 M218 M
Other non-current liabilities71 M63 M33 M24 M29 M77 M101 M88 M120 M
Other receivable230 M303 M260 M297 M325 M2,854 M2,720 M2,867 M3,272 M
OtherCurrentBorrowings50 M66 M48 M35 M35 M100000.0200000.013 M13 M
OtherCurrentLiabilities104 M329 M286 M233 M226 M25 M7 M26 M20 M
OtherPayable379 M511 M381 M426 M486 M66 M47 M45 M64 M
Payables176 M175 M183 M207 M255 M234 M239 M271 M308 M
Preferred securities of subsidiary trust10 M10 M10 M10 M10 M10 M10 M
PreferredStock10 M10 M10 M10 M10 M10 M10 M
Raw materials53 M59 M57 M67 M117 M117 M114 M144 M212 M
RecievablesAdjustmentsAllowances-3 M-24 M-3 M-3 M-3 M-6 M-6 M-5 M-6 M
Retained earnings142 M232 M377 M544 M874 M975 M986 M953 M1,213 M
SecuritySoldNotYetRepurchased50 M30 M85 M60 M67 M226 M209 M413 M61 M
Short term debt50 M66 M48 M35 M35 M100000.0200000.013 M13 M
TaxesReceivable6 M12 M12 M15 M14 M26 M29 M8 M
Total assets2,016 M2,263 M2,247 M2,542 M2,810 M2,967 M3,069 M3,051 M3,991 M
Total current assets1,002 M735 M829 M1,033 M932 M1,002 M1,145 M1,118 M1,215 M
Total current liabilities533 M447 M430 M461 M521 M507 M522 M601 M704 M
Total equity-5 M26 M113 M402 M651 M757 M829 M759 M942 M
Total liabilities1,997 M2,233 M2,131 M2,137 M2,156 M2,207 M2,237 M2,289 M3,047 M
Total non-current assets1,014 M1,528 M1,418 M1,509 M1,879 M1,965 M1,924 M1,933 M2,777 M
Total non-current liabilities1,465 M1,786 M1,701 M1,676 M1,635 M1,700 M1,715 M1,687 M2,343 M
TotalEquityGrossMinority19 M30 M116 M406 M654 M760 M833 M762 M945 M
TotalEquityGrossMinorityInterest19 M30 M116 M406 M654 M760 M833 M762 M945 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,016 M2,263 M2,247 M2,542 M2,810 M2,967 M3,069 M3,051 M3,991 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,465 M1,786 M1,701 M1,676 M1,635 M1,700 M1,715 M1,687 M2,343 M
TotalTaxPayable3 M18 M20 M13 M18 M12 M28 M
Treasury stock50 M30 M85 M60 M67 M226 M
UnearnedPremiums12 M
Work in progress26 M30 M24 M30 M34 M33 M42 M42 M42 M
Working capital469 M288 M400 M572 M411 M495 M624 M516 M511 M
ltinv16 M18 M24 M25 M20 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today