Trane Technologies Financial Model
Building Products Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool for an analyst covering Trane Technologies, focusing specifically on forecasting backlog conversion, commercial HVAC cycle dynamics, and operating margin expansion to determine the intrinsic value of the shares.
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. The company operates primarily through its industry-leading Trane and Thermo King brands, focusing on energy efficiency and greenhouse gas emission reductions.
Business segments:
- Americas (approximately 78% of revenue): Commercial HVAC, residential HVAC, and transport refrigeration in North and South America.
- EMEA (approximately 13% of revenue): Commercial HVAC and transport refrigeration in Europe, Middle East, and Africa.
- Asia Pacific (approximately 9% of revenue): Commercial HVAC and transport refrigeration in the APAC region.
The business model is a hybrid of equipment sales and high-margin, recurring aftermarket services. It is relatively asset-light, relying on assembly rather than heavy primary manufacturing. Trane holds a top-tier competitive position in applied commercial HVAC systems and a duopoly position (alongside Carrier) in transport refrigeration. Following the 2020 spin-off of its industrial segment (Ingersoll Rand), the company has operated as a pure-play climate control business, driving growth through organic innovation and bolt-on acquisitions.
The downloadable Trane Technologies 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 & AssumptionsTrane Technologies financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $14.14B | $15.99B | $17.68B | $19.84B | $21.32B |
| Selling and administrative expenses | -$2.45B | -$2.55B | -$2.96B | -$3.58B | -$3.74B |
| Operating income | $2.02B | $2.42B | $2.89B | $3.50B | $3.97B |
| Net income | $1.42B | $1.76B | $2.02B | $2.57B | $2.92B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Trane Technologies
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Americas
- Segment name: Americas
- Revenue driver formula: (Beginning Backlog + Bookings - Cancellations) x Conversion Rate + Service Revenue
- Historical growth rate: 8-12% CAGR over the last 3 years (driven by strong commercial HVAC demand).
- Key growth levers and headwinds: Levers include secular trends in building decarbonisation, indoor air quality upgrades, and data centre cooling demand. Headwinds include cyclical downturns in residential HVAC and North American trailer build rates for transport refrigeration.
- Pricing dynamics: Highly disciplined contractual and spot pricing; the company has consistently demonstrated positive price realisation that exceeds raw material inflation.
- Revenue recognition notes: Equipment revenue is recognised at a point in time (upon delivery or installation), while service and maintenance contract revenue is recognised over time as services are rendered.
- Seasonality: Q2 and Q3 are typically the strongest quarters due to summer cooling demand and the North American construction season.
EMEA
- Segment name: EMEA
- Revenue driver formula: Equipment Volume x Average Selling Price + Service Revenue
- Historical growth rate: 3-6% CAGR.
- Key growth levers and headwinds: Levers include European regulatory mandates for heat pump adoption and phase-outs of high global warming potential (GWP) refrigerants. Headwinds include broader European macroeconomic weakness.
- Pricing dynamics: Competitive but supported by stringent environmental regulations that drive premium pricing for high-efficiency units.
- Revenue recognition notes: Similar to Americas; deferred revenue is tracked for long-term service agreements.
- Seasonality: Moderate seasonality, peaking in Q2 and Q3.
Asia Pacific
- Segment name: Asia Pacific
- Revenue driver formula: Equipment Volume x Average Selling Price + Service Revenue
- Historical growth rate: 4-7% CAGR.
- Key growth levers and headwinds: Growth is heavily dependent on commercial real estate development and infrastructure spending in China and Southeast Asia. Headwinds include the Chinese property market slowdown.
- Pricing dynamics: Highly competitive, particularly in the light commercial and residential sectors against local Asian manufacturers.
- Revenue recognition notes: Standard point-in-time for equipment and over-time for services.
- Seasonality: Q2 and Q4 are historically stronger, aligning with regional construction cycles.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Direct materials (copper, steel, aluminium, refrigerants, electronic components), direct factory labour, inbound and outbound freight, and manufacturing overhead.
- Gross margin range: 32.0% to 36.2% over the last 5 years (reached 36.2% in 2025).
- Key input costs and commodity exposures: Highly exposed to copper, aluminium, and steel prices, though the company actively hedges and uses pricing power to offset inflation.
- How COGS scales with revenue: Scales linearly with equipment volumes, but gross margin percentage expands as the mix shifts toward higher-margin aftermarket services and software controls.
Operating Expenses
- R&D: Typically 1.5% to 2.0% of revenue, expensed as incurred. It covers next-generation low-GWP refrigerants, electrification technologies, and digital controls.
- SG&A: Typically 15.0% to 16.5% of revenue. This includes a large direct sales force for commercial HVAC, marketing, and corporate overhead. It is largely headcount-driven.
- Depreciation & Amortisation: Approximately 2.0% to 2.5% of revenue, split roughly evenly between tangible asset depreciation and amortisation of acquired intangibles.
- Stock-Based Compensation: Approximately 0.5% to 0.8% of revenue.
- Restructuring / one-time charges: Frequent but small (typically $30m to $80m annually) related to footprint optimisation and efficiency programmes.
Margin Profile
- Gross margin: 32% to 36.2% (expanding trend).
- EBITDA margin: 15% to 20.1% (reached 20.1% in 2025).
- Operating margin: 14% to 18.6% (GAAP).
- Margin trend: Expanding consistently due to strong price realisation, operating leverage, and a mix shift toward services and applied systems.
Balance Sheet Structure
- Total assets: Approximately $18 billion to $20 billion.
- Key asset categories: Accounts receivable, inventory, goodwill, and intangible assets.
- Goodwill & intangibles as % of total assets: Approximately 45% to 50%, reflecting the legacy Ingersoll Rand merger and subsequent bolt-on acquisitions.
- Working capital profile:
- Days Sales Outstanding (DSO): 55 to 65 days.
- Days Inventory Outstanding (DIO): 60 to 70 days.
- Days Payable Outstanding (DPO): 75 to 85 days.
- Net working capital as % of revenue: Typically negative (-2% to -5%).
- Is working capital positive or negative?: Negative. The company funds growth from working capital due to strong supplier payment terms and significant deferred revenue from service contracts.
- PP&E: Approximately 10% to 12% of total assets. Consists of assembly plants, distribution centres, and tooling. Useful lives range from 3 to 15 years for machinery and up to 40 years for buildings.
- Right-of-use assets / operating leases: Material, representing approximately $400m to $500m, primarily for distribution centres and sales offices.
Capital Expenditure & Investment
- Capex as % of revenue: 1.5% to 2.0% (historically very stable).
- Maintenance capex vs. growth capex: Approximately 60% maintenance (tooling, facility upkeep) and 40% growth (automation, new product lines, digital infrastructure).
- Major capex programmes underway or planned: Investments in automated manufacturing for heat pumps and electrification products.
- Capitalised software / development costs: Minimal; most R&D is expensed.
- M&A pattern: Serial bolt-on acquirer. Focuses on regional service companies, digital control software, and niche technology add-ons.
- Typical acquisition multiple paid: 10x to 14x EBITDA for service and technology bolt-ons.
Debt & Capital Structure
- Total debt: Approximately $4.5 billion to $5.0 billion.
- Debt/EBITDA ratio: Current leverage is approximately 1.0x to 1.2x. Target is 1.5x to 2.0x.
- Credit rating: Investment grade (Baa2/BBB).
- Key debt instruments: Senior unsecured notes with staggered maturities.
- Maturity profile: Well-laddered, with average maturity exceeding 8 years.
- Interest rate profile: Predominantly fixed-rate bonds; weighted average cost of debt is approximately 4.0% to 4.5%.
- Covenants: Standard investment-grade covenants (interest coverage and maximum leverage ratios); the company operates with massive headroom.
- Share repurchase programme: Highly active. Repurchased $1.5 billion in 2025 and has $4.8 billion remaining under the 2024 authorisation.
- Dividend policy: Progressive dividend policy. Payout ratio is typically 25% to 30% of net earnings. Increased dividend by 12% in early 2026.
Cash Flow Characteristics
- Operating cash flow conversion: Consistently strong, typically 100% to 110% of Net Income.
- Free cash flow margin: 10% to 13% of revenue. FCF conversion was 98% of adjusted net earnings in 2025.
- Major non-cash items: Depreciation, amortisation of intangibles, and stock-based compensation.
- Working capital cash flow impact: Generally a source of cash during growth periods due to the negative working capital dynamic (deferred revenue and payables grow faster than receivables and inventory).
- Capex intensity: Very low (1.5% to 2.0% of revenue), driving the high free cash flow conversion.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes generally track closely to the GAAP effective tax rate of 18% to 20%, though timing of deductions can cause minor variations.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth rates, margin targets, working capital days, tax rates, and capital allocation policies.
- Scenarios: Scenario manager (Base, Bull, Bear) toggling key drivers like Americas commercial HVAC bookings and price realisation.
- Bookings & Backlog: Roll-forward of bookings, cancellations, and revenue conversion to calculate ending backlog (crucial for this company).
- Revenue & Margins: Detailed build of revenue by segment (Americas, EMEA, APAC) and calculation of segment-level Adjusted EBITDA.
- Income Statement: Consolidated P&L from Revenue down to Net Income and EPS, including adjustments for non-GAAP metrics.
- Balance Sheet: Standard asset, liability, and equity line items, driven by working capital schedules and capital structure.
- Cash Flow Statement: Indirect method starting from Net Income, adjusting for non-cash items, working capital changes, capex, and financing activities.
- Working Capital: Schedules for Accounts Receivable, Inventory, Accounts Payable, and Deferred Revenue based on DSO, DIO, DPO, and deferred revenue days.
- Debt & Interest: Debt maturity schedule, interest expense calculation, and debt paydown/drawdown logic.
- PP&E & Intangibles: Capex, depreciation waterfall, and amortisation schedule for intangible assets.
- Shareholders Equity: Roll-forward of share count, share repurchases, dividends, and retained earnings.
- DCF Valuation: Unlevered free cash flow calculation, WACC build, terminal value, and implied share price.
- Outputs & Charts: Summary dashboard of key metrics (Adjusted EBITDA margin, FCF conversion, EPS growth) for presentation.
Key Financial Relationships
- `Ending Backlog = Beginning Backlog + Bookings - Recognised Revenue`
- `Americas Revenue = Americas Bookings x Americas Conversion Rate + Americas Service Revenue`
- `Consolidated Net Revenues = Americas Revenue + EMEA Revenue + Asia Pacific Revenue`
- `Gross Profit = Consolidated Net Revenues - Cost of Goods Sold`
- `Segment Adjusted EBITDA = Segment Revenue x Segment Adjusted EBITDA Margin`
- `Consolidated Adjusted EBITDA = Sum of Segment Adjusted EBITDA - Unallocated Corporate Expenses`
- `Accounts Receivable = (Consolidated Net Revenues / 365) x DSO`
- `Inventory = (Cost of Goods Sold / 365) x DIO`
- `Accounts Payable = (Cost of Goods Sold / 365) x DPO`
- `Deferred Revenue = (Consolidated Net Revenues / 365) x Deferred Revenue Days`
- `Free Cash Flow = Cash from Operations - Capital Expenditures`
- `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`
- `Basic Shares Outstanding = Prior Period Shares - (Share Repurchases / Average Share Price)`
- `Adjusted EPS = Adjusted Net Earnings / Diluted Shares Outstanding`
Cross-Sheet Dependencies
- The Bookings & Backlog sheet is the primary engine; it feeds directly into the Revenue & Margins sheet.
- Revenue & Margins feeds the top line of the Income Statement and drives the activity levels in the Working Capital sheet.
- The Working Capital sheet calculates changes in NWC, which feeds the Cash Flow Statement.
- The Cash Flow Statement determines cash available for capital allocation, feeding the Debt & Interest sheet (if debt paydown is required) and the Shareholders Equity sheet (for share repurchases).
- The Debt & Interest sheet calculates interest expense, which loops back to the Income Statement. To prevent circularity, interest expense should be calculated on the beginning debt balance.
- The DCF Valuation pulls operating profit and taxes from the Income Statement, D&A from PP&E & Intangibles, and capex/NWC changes from the Cash Flow Statement.
Sign Convention
- Revenues, assets, and cash inflows are represented as positive numbers.
- Expenses, capital expenditures, liabilities, and cash outflows are represented as negative numbers in the Cash Flow Statement and Income Statement formulas.
- In the Balance Sheet, liabilities and equity are positive numbers (Assets = Liabilities + Equity).
- Margins and growth rates are positive percentages unless representing a contraction or decline.
Things Most Likely to Go Wrong
- Backlog vs. Revenue Disconnect: Trane has a massive backlog ($7.8 billion at year-end 2025). Failing to model the delayed conversion of this backlog into revenue will cause the model to miss near-term revenue visibility.
- Ignoring Negative Working Capital: Trane operates with negative net working capital. If the model assumes standard positive working capital, it will incorrectly penalise free cash flow during periods of high growth.
- Corporate Unallocated Expenses: Segment-level Adjusted EBITDA does not sum to consolidated Adjusted EBITDA. The model must include a specific line for unallocated corporate expenses (typically $300m to $400m annually).
- GAAP vs. Non-GAAP EPS: The company heavily promotes Adjusted Continuing EPS ($13.06 in 2025). The model must clearly bridge GAAP Net Income to Adjusted Net Earnings by adding back restructuring and acquisition costs.
- Service vs. Equipment Mix: Service revenues carry significantly higher margins. If the model does not account for the mix shift toward services, it will under-forecast gross margin expansion.
- Share Repurchase Impact: Trane aggressively buys back stock ($1.5 billion in 2025). Failing to reduce the share count dynamically will result in understated EPS forecasts.
- FX Translation: Approximately 22% of revenue is generated outside the Americas. The model should ideally have a toggle for constant currency growth versus reported growth to isolate operational performance.
- Seasonality Smoothing: Using a straight quarterly allocation (25% per quarter) will fail validation against historicals. Q2 and Q3 must carry higher weightings for revenue and cash flow.
Validation Checks
- "Adjusted EBITDA margin should be in the 19.0% to 21.0% range based on recent performance; flag if outside this band."
- "Free Cash Flow conversion (FCF / Adjusted Net Earnings) should be between 95% and 105%."
- "Net Working Capital as a percentage of revenue should remain negative; flag if it turns positive."
- "Capex as a percentage of revenue must remain between 1.5% and 2.0%."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Debt/EBITDA should remain below 2.0x per rating agency guidance."
- "Effective tax rate should be 18.0% to 20.0%."
- "Dividend payout ratio should remain between 25% and 30% of net earnings."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Americas Revenue Growth | 7.0 | % | Midpoint of management guidance and historical applied HVAC strength. |
| EMEA Revenue Growth | 4.0 | % | Historical average, balancing heat pump mandates with macro weakness. |
| APAC Revenue Growth | 5.0 | % | Historical average, assuming stable commercial replacement demand. |
| Consolidated Gross Margin | 36.2 | % | Actual reported gross margin for full-year 2025. |
| SG&A as % of Revenue | 15.5 | % | In line with historical averages and required business reinvestment. |
| R&D as % of Revenue | 1.6 | % | Based on 2025 actuals ($347.6m on $21.3B revenue). |
| Adjusted EBITDA Margin | 20.1 | % | Actual reported Adjusted EBITDA margin for full-year 2025. |
| DSO (Days Sales Outstanding) | 60 | Days | Calculated from historical accounts receivable balances. |
| DIO (Days Inventory Outstanding) | 65 | Days | Calculated from historical inventory and COGS. |
| DPO (Days Payable Outstanding) | 80 | Days | Calculated from historical accounts payable, reflecting strong supplier terms. |
| Capex as % of Revenue | 1.5 | % | Historical average for this asset-light assembly business. |
| Effective Tax Rate | 19.0 | % | Historical average GAAP effective tax rate. |
| Average Interest Rate on Debt | 4.5 | % | Estimated weighted average cost of existing fixed-rate notes. |
| Annual Share Repurchases | 1,500 | $ Millions | Matches the actual 2025 repurchase execution. |
| Dividend Payout Ratio | 28.0 | % | Aligns with historical progressive dividend policy. |
| WACC | 8.5 | % | Standard discount rate for a large-cap, investment-grade industrial. |
| Terminal Growth Rate | 2.5 | % | Long-term GDP growth plus structural decarbonisation tailwinds. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Trane Technologies Investor Relations website (earnings presentations and press releases).
- Key Peers: Carrier Global (CARR), Johnson Controls (JCI), Lennox International (LII), and Daikin Industries.
- Industry Data: Dodge Construction Network (for commercial starts), AHRI (Air-Conditioning, Heating, and Refrigeration Institute) for North American shipment data, and ACT Research for transport refrigeration trailer build rates.
- Consensus Estimates: FactSet or Bloomberg for forward-looking EPS and revenue consensus.
Sources
- Trane Technologies 2025 Form 10-K Summary (TradingView): https://www.tradingview.com/news/reuters.com,2026-02-05:newsml_nBw6qK9qxa:0-trane-technologies-plc-sec-10-k-report/
- Trane Technologies Q4 and Full-Year 2024 Earnings Release: https://investors.tranetechnologies.com/news-and-events/news/news-details/2025/Trane-Technologies-Reports-Strong-Fourth-Quarter-and-Full-Year-2024-Results-Robust-Bookings-and-Backlog-Provide-Strong-Visibility-Entering-2025/default.aspx
- Trane Technologies Q4 and Full-Year 2025 Earnings Release: https://investors.tranetechnologies.com/news-and-events/news/news-details/2026/Trane-Technologies-Reports-Strong-Fourth-Quarter-and-Full-Year-2025-Results-Robust-Bookings-and-Backlog-Provide-Strong-Visibility-Entering-2026/default.aspx
Do more with the Trane Technologies model
Frequently asked
What does Trane Technologies do?+
Trane Technologies 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. The company operates primarily through its industry-leading Trane and Thermo King brands, focusing on energy efficiency and greenhouse gas emission reductions.
How does Trane Technologies generate its revenue?+
Trane Technologies generates revenue through a hybrid business model combining equipment sales with high-margin, recurring aftermarket services. Their primary business segments include Americas, EMEA, and Asia Pacific, with the Americas contributing approximately 78% of total revenue.
What is Trane Technologies' typical capital expenditure as a percentage of revenue?+
Trane Technologies historically maintains a very stable capital expenditure, typically ranging from 1.5% to 2.0% of revenue. Approximately 60% of this capex is for maintenance, while 40% supports growth initiatives like automation and new product lines.
What is Trane Technologies' working capital profile?+
Trane Technologies typically exhibits negative net working capital, ranging from -2% to -5% of revenue. This profile allows the company to fund growth from working capital due to strong supplier payment terms and significant deferred revenue from service contracts.
What are the key focus areas for an analyst using the Trane Technologies financial model?+
The financial model for Trane Technologies focuses on forecasting backlog conversion, commercial HVAC cycle dynamics, and operating margin expansion. These elements are critical for determining the intrinsic value of the company's shares and for scenario planning.
Can I download an Excel financial model for Trane Technologies?+
Yes, an Excel financial model for Trane Technologies is available for download. This model provides a comprehensive equity valuation and scenario planning tool, with a forecast horizon spanning from FY2026 to FY2030.
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.
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.
Explore more Manufacturing financial model templates.
