Johnson Controls Financial Model
Building Products Company Financials Example (Free Excel Download)
Johnson Controls is a global leader in smart, healthy, and sustainable building technologies, providing HVAC, fire detection, security systems, and building automation controls.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and cash flow generation of Johnson Controls International plc (JCI) to determine if the company's transition to a pure-play commercial building solutions provider, following the $8.1 billion divestiture of its Residential and Light Commercial HVAC business, justifies a premium valuation multiple.
Johnson Controls is a global leader in smart, healthy, and sustainable building technologies, providing HVAC, fire detection, security systems, and building automation controls. The company operates a hybrid business model, combining the asset-heavy manufacturing of building products with an asset-light, high-margin services business that provides installation, maintenance, and digital optimisation (via its OpenBlue platform).
Historically, the company reported under four segments: Building Solutions North America (approx. 40% of revenue), Building Solutions EMEA/LA (approx. 15%), Building Solutions Asia Pacific (approx. 10%), and Global Products (approx. 35%). Following a strategic pivot, the company has simplified its portfolio to focus exclusively on commercial buildings. The most significant recent event was the August 2025 completion of the sale of its Residential and Light Commercial (R&LC) HVAC business to the Bosch Group for $8.1 billion, yielding approximately $5.0 billion in net cash proceeds which are being deployed into an accelerated share repurchase programme.
The downloadable Johnson Controls 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 & AssumptionsJohnson Controls financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $23.67B | $20.64B | $22.33B | $22.95B | $23.60B |
| Gross profit | $8.06B | $7.09B | $7.80B | $8.08B | $8.59B |
| Selling, general and administrative expenses | -$5.26B | -$5.95B | -$6.18B | $5.66B | $5.76B |
| Net income | $1.64B | $1.53B | $1.85B | $1.71B | $3.29B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Johnson Controls
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Building Solutions North America
- Segment name: Building Solutions North America
- Revenue driver formula: (Equipment Sales Volume x Average Selling Price) + (Installed Base x Service Attachment Rate x Annual Contract Value)
- Historical growth rate: 8-12% CAGR (boosted by strong Applied HVAC and data centre demand)
- Key growth levers and headwinds: Driven by decarbonisation mandates, data centre cooling requirements, and energy-efficiency retrofits. Headwinds include commercial real estate market softness.
- Pricing dynamics: Contractual for services; project-based bidding for installations.
- Revenue recognition notes: Over time using the percentage-of-completion method for large installation projects; over time for service contracts.
- Seasonality: Stronger in the fiscal third and fourth quarters (spring/summer in the Northern Hemisphere) due to peak construction and HVAC replacement demand.
Building Solutions EMEA/LA (Europe, Middle East, Africa, and Latin America)
- Segment name: Building Solutions EMEA/LA
- Revenue driver formula: Regional Project Volume + Recurring Service Revenue
- Historical growth rate: 5-7% CAGR
- Key growth levers and headwinds: European energy transition and heat pump adoption drive growth. Macroeconomic sluggishness in Europe acts as a headwind.
- Pricing dynamics: Highly competitive, influenced by local regulations and government subsidies for green buildings.
- Revenue recognition notes: Percentage-of-completion for installations.
- Seasonality: Similar to North America, with a slight dip in the fiscal fourth quarter (August) due to European holiday schedules.
Building Solutions Asia Pacific
- Segment name: Building Solutions Asia Pacific
- Revenue driver formula: Regional Project Volume + Recurring Service Revenue
- Historical growth rate: Flat to low single-digit decline
- Key growth levers and headwinds: Historically driven by Chinese commercial construction. Recent severe headwinds due to weakness in the Chinese systems business and broader macroeconomic slowdown in the region.
- Pricing dynamics: Spot pricing for equipment; highly price-sensitive market.
- Revenue recognition notes: Standard percentage-of-completion.
- Seasonality: Weaker fiscal second quarter due to the Lunar New Year.
Global Products (Continuing Operations)
- Segment name: Global Products
- Revenue driver formula: Third-Party Distributor Volume x Wholesale Price
- Historical growth rate: 4-8% CAGR (excluding the divested R&LC business)
- Key growth levers and headwinds: Demand for commercial applied HVAC, fire detection, and security equipment.
- Pricing dynamics: Spot and short-term contractual pricing with distributors.
- Revenue recognition notes: Point in time upon shipment or delivery to distributors.
- Seasonality: Tied to commercial construction cycles; generally peaks in fiscal Q3 and Q4.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Equipment manufacturing costs (raw materials like copper, steel, aluminium), direct factory labour, field labour for installation projects, and service technician wages.
- Gross margin range: 33.0% to 36.5% (trending upwards to 36.5% in late 2025 due to mix shift towards services).
- Key input costs and commodity exposures: Highly exposed to copper, steel, and aluminium prices, as well as freight costs.
- How COGS scales with revenue: Products COGS scales linearly with volume; Services COGS has high operating leverage once technician route density is optimised.
Operating Expenses
- R&D: Approximately 1.5% to 2.0% of revenue, heavily focused on the OpenBlue digital platform and energy-efficient chiller technologies.
- SG&A: Approximately 23% to 25% of revenue. Includes branch network overhead, sales commissions, and corporate functions.
- Depreciation & Amortisation: Approximately 3.5% of revenue, heavily weighted towards amortisation of Tyco-related intangibles.
- Restructuring / one-time charges: Frequent. The company announced a multi-year restructuring plan in late 2024 to address stranded costs from the Bosch divestiture, targeting $500 million in annual savings.
Margin Profile
- Gross margin: 33.0% - 36.5%.
- EBITA margin: 14.5% - 16.0% consolidated. Segment EBITA margins range from 14% in APAC to 19%+ in North America.
- Margin trend: Expanding. The divestiture of lower-margin residential products and growth in high-margin services (OpenBlue) is driving structural margin improvement.
Balance Sheet Structure
- Total assets: Approximately $40 billion to $42 billion.
- Key asset categories: High concentration of goodwill and intangible assets stemming from the 2016 Tyco merger.
- Goodwill & intangibles as % of total assets: Approximately 45% to 50%.
- Working capital profile:
- Days Sales Outstanding (DSO): 60 to 70 days (project billing cycles can extend this).
- Days Inventory Outstanding (DIO): 50 to 60 days.
- Days Payable Outstanding (DPO): 70 to 80 days.
- Net working capital as % of revenue: Low single digits (positive). The company ties up capital in unbilled receivables for large projects.
- PP&E: Approximately $3.5 billion. Asset-light relative to revenue due to the large service component.
- Right-of-use assets / operating leases: Material, representing branch offices and a large fleet of service vehicles.
Capital Expenditure & Investment
- Capex as % of revenue: 2.0% to 2.5% (approximately $500 million to $600 million annually).
- Maintenance capex vs. growth capex: 60% maintenance (factory upkeep, vehicle fleet) and 40% growth (digital infrastructure, new product tooling).
- Major capex programmes underway or planned: Investments in OpenBlue digital capabilities and advanced data centre cooling manufacturing capacity.
- Capitalised software / development costs: Material, related to the OpenBlue platform.
- M&A pattern: Historically a transformational acquirer (Tyco), but recently focused on major divestitures (ADT Mexico, R&LC HVAC) to become a pure-play commercial building company.
Debt & Capital Structure
- Total debt: Approximately $8.6 billion at the end of fiscal 2025.
- Debt/EBITDA ratio: 2.0x to 2.5x (comfortably investment grade).
- Credit rating: Baa1 (Moody's) / BBB+ (S&P).
- Key debt instruments: Senior unsecured notes (bonds) and a revolving credit facility.
- Maturity profile: Well-laddered bond maturities over the next 10 to 30 years.
- Interest rate profile: Predominantly fixed-rate bonds.
- Share repurchase programme: Highly active. The company launched a $5.0 billion accelerated share repurchase (ASR) programme in August 2025 using the Bosch transaction proceeds.
- Dividend policy: Approximately $976 million paid in FY25. Yield is typically 1.5% to 2.0% with steady annual growth.
Cash Flow Characteristics
- Operating cash flow conversion: Strong. OCF was approximately $2.55 billion in FY25.
- Free cash flow margin: 8% to 10% of revenue.
- Major non-cash items that bridge net income to OCF: Depreciation, amortisation of Tyco intangibles, and restructuring impairments.
- Working capital cash flow impact: Often a use of cash during periods of high growth due to unbilled project receivables.
- Capex intensity: Low (asset-light service model).
- Cash tax rate vs. GAAP effective tax rate: The effective tax rate is structurally low (12% to 17%) because the company is domiciled in Cork, Ireland.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic inputs, segment growth, margins, tax rates, and capital allocation.
- Scenarios: Base, Bull, and Bear cases toggling organic growth, restructuring savings realisation, and Chinese market recovery.
- Income Statement: Consolidated P&L from Revenue down to EPS. Must clearly separate Continuing Operations from Discontinued Operations (R&LC HVAC).
- Balance Sheet: Standard assets, liabilities, and equity. Must include specific lines for Goodwill, Intangibles, and Unbilled Receivables.
- Cash Flow Statement: Indirect method starting from Net Income from Continuing Operations.
- Segment Build: Revenue and Adjusted EBITA broken down by Building Solutions North America, Building Solutions EMEA/LA, Building Solutions Asia Pacific, and Global Products.
- Working Capital & Capex: Schedules for DSO, DIO, DPO, and PP&E roll-forward.
- Debt & Interest: Debt schedule detailing senior notes, interest expense calculation, and debt paydown/issuance.
- Equity & Shares: Roll-forward of share count, capturing the massive $5.0 billion ASR impact in FY25/FY26, and dividend payments.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value.
Key Financial Relationships
- `Segment Revenue = Prior Year Segment Revenue * (1 + Organic Growth Rate + FX Impact + M&A Impact)`
- `Total Revenue = Sum of Segment Revenues (excluding Discontinued Operations)`
- `Segment Adjusted EBITA = Segment Revenue * Segment EBITA Margin`
- `Consolidated Adjusted EBITA = Sum of Segment Adjusted EBITAs - Unallocated Corporate Expenses`
- `Restructuring Savings = Prior Year Stranded Costs * Restructuring Realisation %`
- `Interest Expense = Average Debt Balance * Weighted Average Interest Rate`
- `Tax Expense = Pre-Tax Income * Effective Tax Rate (modelled at 12-17% due to Irish domicile)`
- `Net Income from Continuing Operations = Pre-Tax Income - Tax Expense`
- `Share Repurchases = Free Cash Flow - Dividends Paid + Asset Sale Proceeds (e.g., $5B from Bosch)`
- `Ending Share Count = Beginning Share Count - (Share Repurchases / Average Share Price)`
- `EPS = Net Income from Continuing Operations / Average Diluted Shares Outstanding`
- `Unlevered Free Cash Flow = EBIT * (1 - Tax Rate) + D&A - Capex - Change in Net Working Capital`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth rates and margins in the Segment Build.
- The Segment Build aggregates to the top line of the Income Statement.
- Income Statement Net Income feeds the top of the Cash Flow Statement and Retained Earnings on the Balance Sheet.
- The Working Capital & Capex sheet calculates changes in NWC and capital expenditures, which feed the Cash Flow Statement and DCF Valuation.
- The Equity & Shares sheet calculates the reduced share count from the $5B ASR, which feeds back into the Income Statement for EPS calculations.
- Circularity risk: Interest expense on the Income Statement depends on the debt balance on the Balance Sheet, which depends on the cash sweep from the Cash Flow Statement. A circuit breaker toggle must be included.
Sign Convention
- Revenues, Assets, and Equity: Positive.
- Expenses and Liabilities: Positive on their supporting schedules, but subtracted in aggregation formulas (e.g., Gross Profit = Revenue - COGS).
- Cash Flow: Inflows are positive (e.g., net income, depreciation, increase in payables). Outflows are negative (e.g., capex, dividends, share repurchases, increase in receivables).
Things Most Likely to Go Wrong
- Discontinued Operations: Failing to strip out the $8.1 billion R&LC HVAC business from historical Global Products revenue and margins will severely distort the baseline for forecasting continuing operations.
- Share Count Reduction: The $5.0 billion ASR is massive relative to the company's market cap. Failing to model the drastic reduction in share count will result in understated EPS forecasts.
- Tax Rate Error: Applying a standard US 21% corporate tax rate instead of JCI's actual 12-17% Irish domiciled rate will severely understate net income and cash flow.
- Stranded Costs: When a company sells a large division, corporate overhead previously allocated to that division remains. The model must account for these stranded costs and the subsequent $500 million restructuring plan to remove them.
- Amortisation Add-Back: JCI reports "Adjusted EPS" which adds back the heavy amortisation of Tyco intangibles. The model must calculate both GAAP and Adjusted EPS to match consensus estimates.
- Working Capital Seasonality: Unbilled receivables spike in Q3/Q4. Annual models might miss this, but quarterly models must capture the cash flow drag in the first half of the fiscal year.
- Foreign Exchange: JCI generates over 50% of its revenue outside the US. A strong USD will mechanically depress reported revenue in EMEA and APAC.
- Service vs Product Mix: Services carry much higher margins. If the model does not shift the consolidated margin upward as the service mix grows, it will under-forecast profitability.
Validation Checks
- "Consolidated Gross Margin should be in the 33.0% to 37.0% range; flag if outside this band."
- "Effective tax rate must be between 12.0% and 17.0% based on Irish domicile."
- "Capex as a % of revenue should run between 2.0% and 2.5%."
- "Free Cash Flow conversion (Adjusted FCF / Adjusted Net Income) should be approximately 90% to 100%."
- "Debt/EBITDA should remain below 2.5x to maintain the BBB+/Baa1 credit rating."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "The share count must drop significantly in FY26 to reflect the $5.0 billion accelerated share repurchase."
- "Building Solutions APAC revenue growth should be flagged if modelled above 3% in the near term, given ongoing weakness in the Chinese market."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| North America Organic Growth | 6.0 | % | Driven by strong data centre and applied HVAC demand. |
| EMEA/LA Organic Growth | 4.0 | % | Steady growth supported by European decarbonisation mandates. |
| APAC Organic Growth | -2.0 | % | Continued weakness in the Chinese commercial real estate market. |
| Global Products Organic Growth | 5.0 | % | Baseline growth excluding the divested R&LC business. |
| Consolidated Gross Margin | 36.5 | % | Reflects Q4 2025 actuals and mix shift towards services. |
| SG&A as % of Revenue | 23.5 | % | Historical average, adjusting for restructuring savings. |
| Effective Tax Rate | 15.0 | % | Midpoint of management guidance (12-17%) due to Irish domicile. |
| Capex as % of Revenue | 2.3 | % | Historical average for asset-light service model. |
| FY26 Share Repurchases | 5,000 | $ Millions | Executing the announced ASR from Bosch sale proceeds. |
| Annual Dividend per Share | 1.50 | $ | Based on recent quarterly payouts and steady growth policy. |
| Cost of Debt (Pre-Tax) | 4.0 | % | Weighted average interest rate on existing senior notes. |
| WACC | 9.1 | % | Based on current beta, risk-free rate, and capital structure. |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term global GDP and inflation expectations. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (JCI 10-K, 10-Q, 8-K filings), Johnson Controls Investor Relations website.
- Key Peers: Carrier Global (CARR), Trane Technologies (TT), Lennox International (LII), Honeywell (HON).
- Industry Data: Dodge Construction Network (for commercial starts), ABI (Architecture Billings Index) as a leading indicator for North American project pipelines.
- Consensus Estimates: FactSet or Bloomberg for forward EPS and revenue estimates to validate model outputs.
Sources
- Johnson Controls Q4 2025 Earnings Release and Presentation (November 2025).
- Johnson Controls Q1 2026 Earnings Release (February 2026).
- Johnson Controls 8-K / Press Releases regarding the $8.1B sale of the Residential and Light Commercial HVAC business to Bosch (July 2024 - August 2025).
- Johnson Controls FY2024 and FY2025 10-K filings.
Do more with the Johnson Controls model
Frequently asked
What is Johnson Controls' core business focus after its recent divestiture?+
Johnson Controls is now a global leader in smart, healthy, and sustainable commercial building technologies, providing HVAC, fire detection, security systems, and building automation controls. This strategic pivot followed the $8.1 billion divestiture of its Residential and Light Commercial HVAC business, making it a pure-play commercial building solutions provider.
How does Johnson Controls generate revenue with its hybrid business model?+
Johnson Controls operates a hybrid business model, combining the asset-heavy manufacturing of building products with an asset-light, high-margin services business. The services segment provides installation, maintenance, and digital optimization via its OpenBlue platform, complementing its product sales.
What is Johnson Controls' typical capital expenditure as a percentage of revenue?+
Johnson Controls typically allocates 2.0% to 2.5% of its revenue to capital expenditure, which translates to approximately $500 million to $600 million annually. This spending is primarily split between 60% for maintenance, such as factory upkeep and vehicle fleet, and 40% for growth initiatives like digital infrastructure and new product tooling.
What is the primary purpose of a financial model for Johnson Controls (JCI)?+
A financial model for Johnson Controls evaluates the company's equity valuation and cash flow generation. Its main purpose is to determine if the company's transition to a pure-play commercial building solutions provider justifies a premium valuation multiple.
Can I download an Excel financial model for Johnson Controls (JCI)?+
Yes, a downloadable Excel financial model is available for Johnson Controls (JCI). This model provides a forecast horizon from FY2026 to FY2030, allowing for detailed analysis of the company's future financial performance.
How did Johnson Controls' recent divestiture impact its financial strategy?+
The $8.1 billion divestiture of its Residential and Light Commercial HVAC business generated approximately $5.0 billion in net cash proceeds. These funds are being deployed into an accelerated share repurchase program, reflecting a strategic focus on shareholder returns and a pure-play commercial building model.
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.
Allegion
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.
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.
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.
