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

125.78
 
USD
  
-0.60
  
(-0.47%)
Optionable: Yes  Market Cap: 11,065 M  90-day average vol: 713,382

Previous close: 126.38  Open: 127.61  Bid: 107.25  Ask: 129.0
52 week range    
95.94   
   136.91
Peers   
FBHS / 
ADT / 
SWK / 
NL / 
BRC / 
SPB / 
Last updated: Thursday 18th April 2024
52
MarketXLS Rank
65
Value
38
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
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""50 M66 M48 M35 M35 M100000.0200000.013 M13 M413 M
Accounts payable176 M175 M180 M188 M235 M221 M220 M259 M281 M259 M
Accounts receivable330 M322 M283 M396 M413 M
Accrued expenses346 M372 M381 M426 M486 M409 M428 M471 M556 M532 M
Accumulated depreciation & depletion-373 M-392 M-414 M-456 M-472 M-495 M-535 M-544 M-567 M-603 M
Additional paid in capital24 M9 M14 M
Cash and equivalents291 M200 M312 M466 M291 M355 M480 M398 M288 M468 M
CashCashEquivalentsAndShortTermInvestments291 M200 M312 M466 M291 M355 M480 M398 M288 M468 M
CashEquivalents312 M291 M359 M480 M
Common par1000000.01000000.01000000.01000000.0900000.0900000.0900000.0900000.0900000.0900000.0
Common stock equity-5 M26 M113 M402 M651 M757 M829 M759 M942 M1,318 M
CommonStock1000000.01000000.01000000.01000000.0900000.0900000.0900000.0900000.0900000.0900000.0
Cost in excess484 M714 M717 M761 M883 M873 M819 M804 M1,413 M1,443 M
CurrentAccruedExpenses170 M197 M199 M219 M230 M175 M189 M200 M248 M258 M
CurrentCapitalLeaseObligation23 M19 M20 M21 M30 M30 M28 M29 M32 M34 M
CurrentDeferredAssets33 M11 M12 M
CurrentDeferredTaxesAssets33 M11 M85 M63 M123 M178 M206 M250 M308 M386 M
CurrentDeferredTaxesLiabilities34 M9 M16 M57 M8 M-135 M-147 M-158 M173 M241 M
CurrentProvisions2 M4 M13 M6 M6 M4 M4 M4 M
Deferred revenues34 M9 M3 M
EmployeeBenefits122 M145 M135 M86 M81 M88 M79 M69 M40 M44 M
Finished goods91 M115 M140 M143 M129 M120 M127 M194 M225 M179 M
Float term debt1,215 M1,458 M1,416 M1,442 M1,410 M1,428 M1,429 M1,430 M2,082 M1,602 M
GoodwillAndOtherIntangibleAssets610 M1,087 M1,074 M1,156 M1,430 M1,384 M1,306 M1,251 M2,022 M2,016 M
Gross fixed assets (Plant Property & Equipment)580 M617 M640 M708 M749 M786 M830 M828 M876 M961 M
IncomeTaxPayable5 M3 M18 M20 M13 M18 M12 M28 M15 M
Intangibles125 M372 M357 M394 M547 M511 M487 M448 M609 M573 M
InterestPayable54 M53 M64 M106 M54 M56 M51 M50 M76 M93 M
Inventories169 M204 M221 M240 M280 M270 M283 M380 M479 M439 M
Invested capital2,223 M1,924 M1,576 M2,041 M2,061 M3,613 M3,688 M3,618 M5,106 M4,523 M
LongTermCapitalLeaseObligation1,265 M1,523 M1,464 M1,492 M1,445 M1,428 M66 M63 M70 M198 M
LongTermDebtAndCapitalLeaseObligation1,215 M1,458 M1,416 M1,442 M1,410 M1,428 M1,429 M1,430 M2,082 M1,602 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 M358 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 M94 M
NonCurrentDeferredAssets72 M92 M72 M35 M85 M113 M127 M155 M228 M293 M
NonCurrentDeferredLiabilities116 M108 M106 M101 M102 M94 M
NonCurrentDeferredTaxesAssets72 M92 M72 M35 M85 M113 M127 M155 M228 M293 M
NonCurrentPensionAndOtherPostretirementBenefitPlans122 M145 M135 M86 M81 M88 M79 M69 M40 M44 M
Number of employees12300.012300.012300.012300.012300.012300.012300.012300.012300.012300.0
Other current assets279 M17 M24 M18 M20 M29 M34 M27 M44 M33 M
Other equity adjustments-148 M-232 M-264 M-153 M-223 M-219 M-157 M
Other fixed assets291 M295 M284 M309 M358 M
Other non-current assets125 M125 M45 M66 M87 M177 M197 M244 M218 M284 M
Other non-current liabilities71 M63 M33 M24 M29 M77 M101 M88 M120 M173 M
Other receivable230 M303 M260 M297 M325 M2,854 M2,720 M2,867 M3,272 M3,651 M
OtherCurrentBorrowings50 M66 M48 M35 M35 M100000.0200000.013 M13 M413 M
OtherCurrentLiabilities104 M329 M286 M233 M226 M98 M93 M118 M135 M135 M
OtherInventories270 M283 M380 M479 M439 M
OtherPayable379 M511 M381 M426 M486 M66 M47 M45 M64 M84 M
Payables176 M175 M183 M207 M255 M234 M239 M271 M308 M274 M
Preferred securities of subsidiary trust10 M10 M10 M10 M10 M
PreferredStock10 M10 M10 M10 M10 M
Raw materials53 M59 M57 M67 M117 M117 M114 M144 M212 M218 M
RecievablesAdjustmentsAllowances-3 M-24 M-3 M-3 M-3 M-6 M-6 M-5 M-6 M-14 M
Restricted cash3 M
Retained earnings142 M232 M377 M544 M874 M757 M829 M758 M927 M1,317 M
SecuritySoldNotYetRepurchased50 M30 M85 M60 M67 M226 M-209 M-413 M-61 M-60 M
Short term debt50 M66 M48 M35 M35 M100000.0200000.013 M13 M413 M
TaxesReceivable6 M12 M12 M15 M14 M26 M29 M8 M9 M
Total assets2,016 M2,263 M2,247 M2,542 M2,810 M2,967 M3,069 M3,051 M3,991 M4,312 M
Total current assets1,002 M735 M829 M1,033 M932 M1,002 M1,145 M1,118 M1,215 M1,361 M
Total current liabilities533 M447 M430 M461 M521 M507 M522 M601 M704 M1,080 M
Total equity-5 M26 M113 M402 M651 M757 M829 M759 M942 M1,318 M
Total liabilities1,997 M2,233 M2,131 M2,137 M2,156 M2,207 M2,237 M2,289 M3,047 M2,993 M
Total non-current assets1,014 M1,528 M1,418 M1,509 M1,879 M1,965 M1,924 M1,933 M2,777 M2,951 M
Total non-current liabilities1,465 M1,786 M1,701 M1,676 M1,635 M1,700 M1,715 M1,687 M2,343 M1,914 M
TotalEquityGrossMinority19 M30 M116 M406 M654 M760 M833 M762 M945 M1,318 M
TotalEquityGrossMinorityInterest19 M30 M116 M406 M654 M760 M833 M762 M945 M1,318 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,016 M2,263 M2,247 M2,542 M2,810 M2,967 M3,069 M3,051 M3,991 M4,312 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,465 M1,786 M1,701 M1,676 M1,635 M1,700 M1,715 M1,687 M2,343 M1,914 M
TotalTaxPayable3 M18 M20 M13 M18 M12 M28 M15 M
Treasury stock50 M30 M85 M60 M67 M226 M
UnearnedPremiums-8 M-12 M-10 M
Work in progress26 M30 M24 M30 M34 M33 M42 M42 M42 M42 M
Working capital469 M288 M400 M572 M411 M495 M624 M516 M511 M281 M
ltinv16 M18 M24 M25 M20 M18 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