Allegion Financial Model
Building Products Company Financials Example (Free Excel Download)
Allegion plc is a global provider of security products and access solutions, manufacturing mechanical locks, electronic security devices, and automatic doors for residential and commercial applications.
professionals from Deloitte
Used by professionals from
About this model
This model projects Allegion's future cash flows and earnings to determine its intrinsic equity value and assess its capacity for continued dividend growth and bolt-on acquisitions.
- Allegion plc is a global provider of security products and access solutions, manufacturing mechanical locks, electronic security devices, and automatic doors for residential and commercial applications.
- Business segments: Allegion Americas (approximately 75% of total revenue) and Allegion International (approximately 25% of total revenue).
- Key geographies: The vast majority of revenue is generated in North America, with the remainder spread across Europe, Asia, and Oceania.
- Business model type: Asset-light manufacturing and assembly, with a growing recurring revenue component from software and electronic access control systems.
- Competitive position: A market leader in the Americas commercial and residential hardware space, competing primarily with ASSA ABLOY, dormakaba, and Fortune Brands Innovations.
- Recent major events: In July 2022, Allegion acquired Stanley Access Technologies for $900 million in cash, significantly expanding its presence in the automatic entrance solutions market and boosting Americas segment revenue.
The downloadable Allegion financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsAllegion financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $2.87B | $3.27B | $3.65B | $3.77B | $4.07B |
| Gross profit | $1.20B | $1.32B | $1.58B | $1.67B | $1.84B |
| Operating income | $530.2M | $586.4M | $708.4M | $780.7M | $859.5M |
| Net income | $483.3M | $458.3M | $540.6M | $597.5M | $643.8M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Allegion
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Allegion Americas
- Segment name: Allegion Americas
- Revenue driver formula: (Non-Residential Volume x Price) + (Residential Volume x Price) + Acquisition Contribution
- Historical growth rate: 4% to 7% CAGR over the last 3 years, heavily influenced by the Access Technologies acquisition and strong price realisation.
- Key growth levers and headwinds: Growth is driven by institutional construction (schools, hospitals), retrofitting mechanical locks to electronic access control, and automatic door installations. Headwinds include US residential housing market slowdowns and commercial real estate weakness.
- Pricing dynamics: Strong pricing power due to brand loyalty (Schlage, Von Duprin) and life-safety compliance requirements, allowing the company to offset raw material inflation.
- Revenue recognition notes: Primarily recognised at a point in time upon shipment. Software and service revenues (a smaller but growing portion) are recognised over the contract term.
- Seasonality: The second and third quarters are typically the strongest due to the North American construction season and the summer institutional repair and remodel cycle.
Allegion International
- Segment name: Allegion International
- Revenue driver formula: Regional Volume x Price x Foreign Exchange Translation
- Historical growth rate: Flat to low single-digit growth, frequently impacted by currency headwinds and softer European macroeconomic conditions.
- Key growth levers and headwinds: Driven by European commercial construction and electronic lock adoption. Headwinds include weak macroeconomic conditions in Europe and Asia, and adverse foreign currency translation (strong US Dollar).
- Pricing dynamics: Competitive pricing environment, though premium brands (CISA, Interflex) command pricing power in specific regional niches.
- Revenue recognition notes: Standard point-in-time recognition for hardware; deferred revenue applies to Interflex workforce management software contracts.
- Seasonality: Relatively balanced, though the fourth quarter often sees a slight uptick in project completions.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Raw materials (steel, brass, zinc, electronic components), direct manufacturing labour, inbound freight, and factory overhead.
- Gross margin range: 41% to 44% over the last 5 years.
- Key input costs and commodity exposures: Highly exposed to steel and non-ferrous metal prices, as well as electronic component availability.
- How COGS scales with revenue: Generally linear with volume, though the company achieves operating leverage through manufacturing footprint optimisation and automation.
Operating Expenses
- R&D: Typically 1.5% to 2.0% of revenue, focused on electro-mechanical product development and software integration.
- SG&A: Typically 20% to 22% of revenue, encompassing sales commissions, marketing, distribution, and corporate administrative costs.
- Depreciation & Amortisation: Approximately 2.5% to 3.5% of revenue, with a significant portion related to the amortisation of acquired intangible assets from historical M&A.
- Stock-Based Compensation: Approximately 0.5% to 1.0% of revenue.
- Restructuring / one-time charges: Frequent but small-scale restructuring charges related to footprint consolidation and integration of acquired businesses.
Margin Profile
- Gross margin: 41% to 44%.
- EBITDA margin: 22% to 25%.
- Operating margin: 19% to 21% on a reported basis; 22% to 24% on an adjusted basis (excluding amortisation and restructuring).
- Net margin: 14% to 16%.
- Margin trend: Expanding over the last two years due to strong price realisation exceeding inflation and favourable volume leverage in the Americas segment.
Balance Sheet Structure
- Total assets: Approximately $4.5 billion to $5.0 billion.
- Key asset categories: Goodwill and intangible assets dominate the asset base due to the company's spin-off history and subsequent acquisitions.
- Goodwill & intangibles as % of total assets: Approximately 55% to 65%.
- Working capital profile:
- Days Sales Outstanding (DSO): 45 to 55 days.
- Days Inventory Outstanding (DIO): 60 to 75 days.
- Days Payable Outstanding (DPO): 50 to 65 days.
- Net working capital as % of revenue: 8% to 12%.
- Is working capital positive or negative? Positive. The company requires moderate working capital to fund inventory for its distribution channels.
- PP&E: Approximately 10% to 15% of total assets, reflecting the asset-light assembly nature of the business.
- Right-of-use assets / operating leases: Material but manageable, representing leased distribution centres and office spaces.
Capital Expenditure & Investment
- Capex as % of revenue: 1.5% to 2.5% historically.
- Maintenance capex vs. growth capex: Approximately 60% maintenance (tooling, equipment replacement) and 40% growth (new product lines, automation).
- Major capex programmes underway or planned: Investments in automated manufacturing lines and electronic product testing facilities.
- Capitalised software / development costs if material: Minimal relative to overall capex, mostly internal-use ERP system upgrades.
- M&A pattern: Serial bolt-on acquirer with occasional transformational deals (like Stanley Access Technologies).
- Typical acquisition multiple paid: 12x to 16x EBITDA pre-synergies.
Debt & Capital Structure
- Total debt: Approximately $2.0 billion to $2.2 billion.
- Debt/EBITDA ratio: 2.0x to 2.5x (target range is typically 1.5x to 2.5x).
- Credit rating: Investment grade (typically BBB or equivalent).
- Key debt instruments: Senior unsecured notes and a $750 million revolving credit facility.
- Maturity profile: Well-laddered with recent issuances extending maturities out to 2034.
- Interest rate profile: Predominantly fixed-rate senior notes, resulting in a weighted average cost of debt around 4.0% to 5.0%.
- Covenants: Standard leverage and interest coverage ratios on the revolving credit facility.
- Share repurchase programme: Active, typically repurchasing $50 million to $250 million annually depending on M&A cash needs.
- Dividend policy: Consistent dividend payer with a payout ratio of 25% to 30%, growing the dividend per share annually.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong, typically 100% to 120% of net income.
- Free cash flow margin: 12% to 15% of revenue.
- Major non-cash items that bridge net income to OCF: Depreciation, amortisation of acquired intangibles, and stock-based compensation.
- Working capital cash flow impact: Generally a use of cash during periods of high growth or supply chain disruption (inventory build), but normalises over the cycle.
- Capex intensity: Low, allowing for high free cash flow generation.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes generally track the GAAP effective tax rate closely. The company benefits from its Irish domicile, resulting in a lower effective tax rate (16% to 17.5%) compared to US-domiciled peers.
Sheet Structure
- Assumptions: Hardcoded drivers for revenue growth, margins, working capital days, capex, and capital structure.
- Scenarios: Toggle for Base, Bull, and Bear cases driving the Assumptions sheet.
- Income Statement: Historical and projected P&L down to Net Earnings and EPS.
- Revenue & Margin Build: Detailed build for Allegion Americas and Allegion International, forecasting volume, price, and segment operating income.
- Balance Sheet: Historical and projected assets, liabilities, and equity.
- Cash Flow Statement: Indirect method starting from Net Earnings, detailing OCF, CFI, and CFF.
- Working Capital Schedule: Projection of receivables, inventory, and payables based on DSO, DIO, and DPO.
- Depreciation & Amortisation Schedule: Waterfall of existing and new PP&E and intangible assets.
- Debt Schedule: Tranche-by-tranche debt balances, interest expense calculations, and mandatory repayments.
- Shareholders Equity: Retained earnings roll-forward, share repurchases, and dividend payments.
- DCF Valuation: Unlevered free cash flow projection, WACC calculation, and terminal value.
- Outputs & Charts: Summary dashboard of key metrics (Adjusted EPS, FCF, Leverage).
Key Financial Relationships
- `Allegion Americas Revenue = Prior Year Americas Revenue x (1 + Americas Organic Growth Rate + Americas M&A Impact)`
- `Allegion International Revenue = Prior Year International Revenue x (1 + International Organic Growth Rate + FX Impact)`
- `Total Net Revenues = Allegion Americas Revenue + Allegion International Revenue`
- `Cost of Goods Sold = Total Net Revenues x (1 - Gross Margin %)`
- `Segment Operating Income = Segment Revenue x Segment Adjusted Operating Margin %`
- `Total Adjusted Operating Income = Americas Operating Income + International Operating Income - Unallocated Corporate Costs`
- `Accounts Receivable = (Total Net Revenues / 365) x DSO`
- `Inventory = (Cost of Goods Sold / 365) x DIO`
- `Accounts Payable = (Cost of Goods Sold / 365) x DPO`
- `Free Cash Flow = Net Cash from Operating Activities - Capital Expenditures`
- `Interest Expense = Average Total Debt x Weighted Average Interest Rate`
- `Effective Tax Rate = Provision for Income Taxes / Earnings Before Income Taxes`
- `Dividends Paid = Prior Period Share Count x Annual Dividend Per Share`
- `Ending Share Count = Beginning Share Count - (Share Repurchase Amount / Average Share Price)`
Cross-Sheet Dependencies
- The Revenue & Margin Build feeds the top line and operating expenses of the Income Statement.
- The Income Statement generates Net Earnings, which is the starting point for the Cash Flow Statement and feeds Retained Earnings on the Shareholders Equity sheet.
- The Working Capital Schedule uses Revenue and COGS from the Income Statement to calculate balances, which feed the Balance Sheet and the change in working capital on the Cash Flow Statement.
- The Debt Schedule calculates interest expense for the Income Statement and ending debt balances for the Balance Sheet.
- The Cash Flow Statement determines the ending cash balance, which serves as the plug on the Balance Sheet to ensure Total Assets equal Total Liabilities and Equity.
- Circularity risk exists between the Debt Schedule (interest expense), Income Statement (net income), Cash Flow Statement (cash available for debt paydown), and back to the Debt Schedule. This must be managed with a circularity breaker toggle.
Sign Convention
- Income Statement: Revenues are positive. Expenses (COGS, SG&A, Interest, Taxes) are negative.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive.
- Cash Flow Statement: Cash inflows are positive. Cash outflows (capex, dividends, debt repayments, share repurchases) are negative.
- Working Capital: An increase in an asset (e.g., Accounts Receivable) is a negative adjustment to cash flow. An increase in a liability (e.g., Accounts Payable) is a positive adjustment to cash flow.
Things Most Likely to Go Wrong
- FX Translation Impact: Allegion International revenues are highly sensitive to EUR/USD and GBP/USD fluctuations. Failing to separate organic growth from FX impacts will distort run-rate revenue projections.
- Adjusted vs. GAAP Margins: The company reports significant amortisation of acquired intangibles. Using GAAP operating margins for valuation without adding back non-cash amortisation will severely undervalue the business.
- Tax Rate Volatility: Allegion is domiciled in Ireland. Applying a standard US 21% statutory tax rate is incorrect. The model must use the guided 16.5% to 17.5% rate, which accounts for the global minimum tax implementation.
- M&A Contribution: Historical growth includes the $900M Stanley Access Technologies acquisition. Extrapolating historical total growth rates instead of organic growth rates will result in massive over-projections.
- Circularity in Share Repurchases: Share repurchases depend on free cash flow, which depends on interest expense, which depends on debt levels, which depends on cash flow. Use a fixed dollar assumption for buybacks to avoid model crashes.
- Segment Margin Discrepancy: Americas segment margins are structurally much higher (27%+) than International margins (15%+). A mix shift towards International will compress consolidated margins. The model must forecast margins at the segment level.
- Working Capital Seasonality: Using Q4 working capital balances to project intra-year cash needs will underestimate the cash required during the Q2/Q3 peak building season.
- Restructuring Add-backs: The company frequently adjusts out restructuring costs. If these are truly recurring, excluding them from free cash flow projections will overstate cash generation.
Validation Checks
- Balance Sheet Check: Total Assets must exactly equal Total Liabilities plus Shareholders Equity in every projected period.
- Gross Margin Band: Consolidated gross margin should remain between 41.0% and 44.0%. Flag if it breaches this historical band.
- Adjusted Operating Margin: Consolidated adjusted operating margin should be in the 22.0% to 24.0% range.
- Cash Conversion: Operating Cash Flow divided by Net Income should consistently be greater than 1.0x.
- Leverage Ratio: Net Debt to EBITDA should remain below 3.0x. Flag if the model projects a breach, as this would violate management's stated capital allocation policy.
- Capex Ratio: Capital expenditures should not exceed 3.0% of total net revenues.
- Tax Rate Check: The effective tax rate should remain between 16.0% and 18.0%.
- Dividend Payout: Dividends paid divided by Net Income should remain between 25% and 35%.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Americas Organic Revenue Growth | 3.0 | % | Aligns with management guidance for low-to-mid single-digit organic growth. |
| International Organic Revenue Growth | 1.5 | % | Reflects softer European macroeconomic conditions and historical trends. |
| Americas Adjusted Operating Margin | 27.5 | % | Based on recent historical performance and positive price/productivity net of inflation. |
| International Adjusted Operating Margin | 15.5 | % | Based on recent historical performance and lower volume leverage. |
| Unallocated Corporate Costs | 2.5 | % of Rev | Historical average for corporate overhead not allocated to segments. |
| Gross Margin | 43.0 | % | Midpoint of historical 41-44% range, supported by strong pricing power. |
| Days Sales Outstanding (DSO) | 50 | Days | Historical average based on standard trade credit terms. |
| Days Inventory Outstanding (DIO) | 65 | Days | Historical average required to support distribution channels. |
| Days Payable Outstanding (DPO) | 55 | Days | Historical average based on supplier payment terms. |
| Capex as % of Revenue | 2.0 | % | Consistent with management guidance and historical asset-light requirements. |
| Effective Tax Rate | 17.0 | % | Aligns with 2024 guidance inclusive of global minimum tax impacts. |
| Weighted Average Interest Rate | 4.5 | % | Blended rate of existing senior notes and revolving credit facility. |
| Annual Share Repurchases | 150 | $ Millions | Conservative estimate based on historical capital allocation priorities. |
| Annual Dividend Per Share | 1.92 | $ | Based on recent quarterly declarations of $0.48 per share. |
| WACC | 8.5 | % | Standard discount rate for a stable, investment-grade industrial company. |
| Terminal Growth Rate | 2.5 | % | Long-term GDP growth proxy for the building products sector. |
Data Sources & Benchmarks
- Filings: SEC EDGAR database for Allegion plc (ALLE) 10-K and 10-Q filings. Irish Statutory Accounts available via the company's investor relations website.
- Investor Relations: investor.allegion.com for earnings presentations, transcript records, and the 2025 Investor & Analyst Day materials.
- Key Peers for Benchmarking: ASSA ABLOY (Stockholm: ASSA-B), Fortune Brands Innovations (NYSE: FBIN), dormakaba (SIX: DOKA), and Carrier Global (NYSE: CARR) for the fire and security segment.
- Industry Data Sources: Dodge Construction Network for North American commercial construction starts; US Census Bureau for residential housing starts and repair/remodel indices.
- Consensus Estimates: FactSet or Bloomberg for consensus revenue, EPS, and margin estimates to validate base case assumptions.
Sources
- Allegion plc 2023 Annual Report on Form 10-K (SEC EDGAR)
- Allegion plc 2024 Q4 and Full-Year Earnings Release and Presentation (investor.allegion.com)
- Allegion plc 2024 Q3 Earnings Release (SEC EDGAR)
- Press releases regarding the acquisition of Stanley Access Technologies (allegion.com)
- Allegion Investor Relations website and event announcements (investor.allegion.com)
Do more with the Allegion model
Frequently asked
What does Allegion plc do?+
Allegion plc is a global provider of security products and access solutions, manufacturing mechanical locks, electronic security devices, and automatic doors. It serves both residential and commercial applications, with a significant presence in North America.
What are the primary revenue drivers for Allegion?+
Allegion's revenue is primarily driven by its Allegion Americas segment, which accounts for approximately 75% of total revenue, largely from North America. Growth is also supported by its asset-light manufacturing model and a growing recurring revenue component from software and electronic access control systems.
What is the assumed annual revenue growth rate in the Allegion financial model?+
The Allegion financial model assumes an annual revenue growth rate of approximately 6.35%. This projection helps forecast future cash flows and earnings for the company.
What is the purpose of the Allegion financial model?+
The Allegion financial model projects future cash flows and earnings to determine the company's intrinsic equity value. It also assesses Allegion's capacity for continued dividend growth and bolt-on acquisitions.
Where can I find a downloadable financial model for Allegion (ALLE)?+
A downloadable Excel financial model for Allegion (ALLE) is available, projecting the company's financials from FY2026 through FY2030. This model is designed to help users analyze Allegion's future performance and valuation.
How do acquisitions impact Allegion's balance sheet and growth strategy?+
Acquisitions significantly impact Allegion's balance sheet, with goodwill and intangible assets dominating its asset base, representing 55% to 65% of total assets. The company is a serial bolt-on acquirer, using M&A to expand its market presence, as seen with the Stanley Access Technologies acquisition in 2022.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Building Products Company Financial Models
Browse another company in the same sector.
A. O. Smith
A.
Builders FirstSource
Builders FirstSource is the largest US supplier of building products, prefabricated components, and value-added services to the professional market for new residential construction and repair and remodelling.
Carrier Global
Carrier Global Corporation is a premier global provider of intelligent climate and energy solutions, encompassing heating, ventilation, air conditioning (HVAC), and transport refrigeration.
Johnson Controls
Johnson Controls is a global leader in smart, healthy, and sustainable building technologies, providing HVAC, fire detection, security systems, and building automation controls.
Lennox International
Lennox International is a leading global provider of climate control solutions, designing and manufacturing heating, ventilation, air conditioning, and refrigeration (HVACR) equipment.
Masco
Masco Corporation is a global leader in the design, manufacture, and distribution of branded home improvement and building products.
Otis Worldwide
Otis Worldwide is the world's largest manufacturer, installer, and maintainer of elevators, escalators, and moving walkways, moving over 2.5 billion people daily.
Trane Technologies
Trane Technologies plc is a global climate innovator that designs, manufactures, and services commercial and residential heating, ventilation, and air conditioning (HVAC) systems, as well as transport refrigeration solutions.
Explore more Manufacturing financial model templates.
