IDEX Financial Model
Industrial Equipment Company Financials Example (Free Excel Download)
IDEX Corporation is a global applied solutions provider that designs and manufactures highly engineered, mission-critical components for niche markets.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and M&A scenario planning tool to help analysts determine the intrinsic value of IDEX Corporation and forecast its capacity for future bolt-on acquisitions.
IDEX Corporation is a global applied solutions provider that designs and manufactures highly engineered, mission-critical components for niche markets. The company operates a highly decentralised business model, managing over 50 wholly owned subsidiaries through its proprietary 80/20 operational framework to drive margin expansion and portfolio optimisation.
Business segments include:
- Health & Science Technologies (HST): Approximately 43% of revenue.
- Fluid & Metering Technologies (FMT): Approximately 35% of revenue.
- Fire & Safety/Diversified Products (FSDP): Approximately 22% of revenue.
The company generates revenue evenly split between domestic (51%) and international (49%) markets. IDEX employs an asset-light manufacturing model and holds a strong competitive position in highly specialised, fragmented markets. Recent major events include the acquisition of Mott Corporation and Micro-LAM, which expanded its capabilities in the semiconductor and data centre cooling markets.
The downloadable IDEX 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 & AssumptionsIDEX financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $2.76B | $3.18B | $3.27B | $3.27B | $3.46B |
| Gross profit | $1.22B | $1.43B | $1.45B | $1.45B | $1.54B |
| Operating income | $637.0M | $751.4M | $732.5M | $677.2M | $699.3M |
| Net income | $449.4M | $586.9M | $596.1M | $505.0M | $483.2M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for IDEX
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Health & Science Technologies (HST)
- Segment name: Health & Science Technologies
- Revenue driver formula: End-Market Volume (Semiconductor, Life Sciences, Data Centres) x Average Selling Price
- Historical growth rate: 5% to 9% CAGR
- Key growth levers and headwinds: Driven by secular trends in AI data centre power solutions, semiconductor consumables, and space and defense. Headwinds include cyclical inventory destocking in life sciences.
- Pricing dynamics: High pricing power due to the proprietary, mission-critical nature of the components.
- Revenue recognition notes: Primarily recognised at a point in time upon shipment.
- Seasonality: Generally stable, with slight upticks in Q4 due to year-end capital budget deployments by customers.
Fluid & Metering Technologies (FMT)
- Segment name: Fluid & Metering Technologies
- Revenue driver formula: Industrial Production Volume x Equipment Price
- Historical growth rate: 2% to 7% CAGR
- Key growth levers and headwinds: Growth is tied to municipal water infrastructure upgrades and energy markets. Headwinds include broader industrial macroeconomic slowdowns.
- Pricing dynamics: Strong contractual pricing tied to inflation indices in municipal contracts.
- Revenue recognition notes: Point in time recognition for standard pumps and valves; over time for large custom engineering projects.
- Seasonality: Stronger in Q2 and Q3 aligning with the Northern Hemisphere construction and infrastructure season.
Fire & Safety/Diversified Products (FSDP)
- Segment name: Fire & Safety/Diversified Products
- Revenue driver formula: Municipal Fire Budgets x Equipment Replacement Cycle
- Historical growth rate: Flat to 5% CAGR
- Key growth levers and headwinds: Driven by municipal tax receipts and infrastructure spending. Dispensing equipment volumes can be volatile based on retail paint store expansions.
- Pricing dynamics: Competitive but stable, heavily reliant on long-standing municipal relationships.
- Revenue recognition notes: Point in time upon delivery.
- Seasonality: Relatively flat, though municipal budget cycles can drive Q1 and Q3 order spikes.
Cost Structure
Variable Costs / COGS
- COGS includes raw materials (metals, resins), direct manufacturing labour, and factory overhead.
- Gross margin range: 43% to 45% over the last 5 years.
- Key input costs include specialty metals and electronic components.
- COGS scales linearly with volume, though the 80/20 operational framework frequently drives step-function improvements in gross margin by eliminating low-margin product lines.
Operating Expenses
- R&D: Typically 3% to 4% of revenue, expensed as incurred, covering new product engineering.
- SG&A: Represents the largest operating expense, heavily driven by headcount and variable compensation.
- Depreciation & Amortisation: High as a percentage of revenue due to the amortisation of acquired intangible assets from serial M&A.
- Stock-Based Compensation: Runs at approximately 1% to 1.5% of revenue.
- Restructuring / one-time charges: Frequent but small, typically related to facility consolidations under the 80/20 framework.
Margin Profile
- Gross margin: 43% to 45%.
- Adjusted EBITDA margin: 26% to 28%.
- Operating margin: 21% to 23%.
- Net margin: 14% to 16%.
- Segment Adjusted EBITDA margins: HST (31%), FMT (33%), FSDP (29%). Unallocated corporate costs reduce the consolidated margin.
Balance Sheet Structure
- Total assets are approximately $5.5 billion.
- Key asset categories include Goodwill and Intangible Assets, which make up over 60% of total assets due to the company's highly acquisitive history.
- Working capital profile:
- Days Sales Outstanding (DSO): 45 to 50 days.
- Days Inventory Outstanding (DIO): 60 to 70 days.
- Days Payable Outstanding (DPO): 40 to 45 days.
- Net working capital as a percentage of revenue is typically 12% to 15%.
- Working capital is positive and requires investment as the company grows organically.
- PP&E is relatively small (asset-light model), consisting of specialised machining and assembly facilities.
- Right-of-use assets are immaterial relative to the broader balance sheet.
Capital Expenditure & Investment
- Capex as a percentage of revenue runs between 1.5% and 2.5%.
- Maintenance capex accounts for roughly 60% of total capex, with the remainder dedicated to growth and facility automation.
- Capitalised software costs are minimal.
- M&A pattern: IDEX is a serial bolt-on acquirer, frequently purchasing founder-owned businesses in niche markets.
- Typical acquisition multiples range from 12x to 15x EBITDA pre-synergies.
Debt & Capital Structure
- Total debt is approximately $1.2 billion to $1.5 billion.
- Gross leverage ratio (Debt/EBITDA) is maintained below 2.0x, with a track record of rapid deleveraging post-acquisition.
- Key debt instruments include a revolving credit facility and senior notes.
- The interest rate profile is a mix of fixed senior notes and floating rate commercial paper.
- The share repurchase programme is highly active, with $248 million utilised in 2025 and a $1 billion authorisation in place.
- Dividend policy targets a payout ratio of 30% to 35% of adjusted net income.
Cash Flow Characteristics
- Operating cash flow conversion is exceptionally strong, typically 130% to 140% of GAAP net income.
- Free cash flow margin is consistently 17% to 19% of revenue.
- Major non-cash items bridging net income to OCF include high amortisation of acquired intangibles and depreciation.
- Working capital is a moderate use of cash during periods of high organic growth.
- Capex intensity is very low, driving the high free cash flow conversion (over 100% of adjusted net income).
- The cash tax rate closely mirrors the GAAP effective tax rate of approximately 24%.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic inputs, segment growth, margins, and capital allocation.
- Scenarios: Toggle for Base, Bull, and Bear cases driving the Assumptions sheet.
- Revenue Build: Segment-level build for HST, FMT, and FSDP, splitting growth into organic, acquisitive, and FX impacts.
- Income Statement: Consolidated view mirroring the 10-K, including unallocated corporate expenses.
- Balance Sheet: Standard asset and liability line items, highlighting Goodwill and Intangibles.
- Cash Flow Statement: Indirect method starting from Net Income, detailing working capital changes and M&A cash outflows.
- Debt Schedule: Tranche-by-tranche build of senior notes and revolving credit facility, calculating interest expense.
- Working Capital: Schedules for Accounts Receivable, Inventory, and Accounts Payable based on days outstanding.
- Depreciation & Amortisation: Waterfall schedules for existing PP&E, acquired intangibles, and new capex.
- DCF Valuation: Unlevered free cash flow calculation, WACC build, and terminal value derivation.
Key Financial Relationships
- HST Revenue = Prior Year HST Revenue * (1 + HST Organic Growth + HST Acquisitive Growth + FX Impact)
- FMT Revenue = Prior Year FMT Revenue * (1 + FMT Organic Growth + FMT Acquisitive Growth + FX Impact)
- FSDP Revenue = Prior Year FSDP Revenue * (1 + FSDP Organic Growth + FSDP Acquisitive Growth + FX Impact)
- Total Net Sales = HST Revenue + FMT Revenue + FSDP Revenue
- Segment Adjusted EBITDA = Segment Revenue * Segment Adjusted EBITDA Margin
- Consolidated Adjusted EBITDA = Sum of Segment Adjusted EBITDA - Unallocated Corporate Costs
- Amortisation Expense = Historical Intangibles Amortisation + (New M&A Spend * % Allocated to Intangibles / Useful Life)
- Interest Expense = Average Debt Balance * Weighted Average Interest Rate
- Share Count = Prior Year Share Count - (Share Repurchase Spend / Average Share Price) + Stock Based Compensation Dilution
- Free Cash Flow = Operating Cash Flow - Capital Expenditures
- Dividends Paid = Adjusted Net Income * Target Payout Ratio
Cross-Sheet Dependencies
- The Revenue Build feeds the top line of the Income Statement.
- Segment margins from the Assumptions sheet drive the EBITDA calculations on the Income Statement.
- Net Income from the Income Statement is the starting point for the Cash Flow Statement and feeds Retained Earnings on the Balance Sheet.
- The Working Capital sheet calculates changes in operating assets and liabilities, which feed the Cash Flow Statement.
- The Debt Schedule calculates interest expense for the Income Statement and ending debt balances for the Balance Sheet. This creates a circular reference if interest expense reduces cash, which in turn increases the revolver draw to fund operations.
- The Depreciation & Amortisation sheet feeds operating expenses on the Income Statement and reduces asset balances on the Balance Sheet.
Sign Convention
- Revenues and expenses on the Income Statement are entered as positive numbers; margins and profits are calculated via subtraction.
- On the Balance Sheet, all Assets, Liabilities, and Equity balances are positive.
- On the Cash Flow Statement, cash inflows are positive and cash outflows (including Capex, Dividends, and Share Repurchases) are negative.
- In the Debt Schedule, debt paydowns are negative and new borrowings are positive.
Things Most Likely to Go Wrong
- Failing to separate unallocated corporate costs from segment-level EBITDA will result in overstated consolidated margins.
- Amortisation of acquired intangibles is a massive non-cash charge for IDEX; failing to add this back will severely understate true cash flow generation.
- Foreign currency translation can swing reported revenue by 2% to 4% year-over-year; the model must separate organic growth from FX impacts.
- The company frequently acquires businesses mid-year; the model must account for stub-period revenue and pro-forma adjustments.
- Assuming linear margin expansion ignores the reality of volume deleverage; if organic volumes decline, margins will compress despite 80/20 productivity gains.
- Overestimating capital expenditures; IDEX is asset-light and capex rarely exceeds 2.5% of sales.
- Ignoring the share repurchase programme will result in an understated EPS forecast, as the company consistently buys back stock.
- Miscalculating the tax rate by using the statutory rate instead of the historical effective rate of 24%.
Validation Checks
- Consolidated Adjusted EBITDA margin should remain between 26% and 28%.
- Free Cash Flow conversion (FCF / Adjusted Net Income) must exceed 100%.
- Gross leverage (Total Debt / Adjusted EBITDA) should not exceed 2.0x unless a major acquisition is modelled in that period.
- Total Assets must exactly equal Total Liabilities plus Shareholders' Equity in every forecast period.
- Capex as a percentage of revenue should flag if it exceeds 3%.
- The effective tax rate should remain stable at approximately 24%.
- Dividend payout ratio should calculate to exactly 30% to 35% of adjusted net income.
- Unallocated corporate costs should run at approximately 1.5% to 2.0% of total consolidated revenue.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| HST Organic Growth | 5.0 | % | Driven by strong data centre and semiconductor demand |
| FMT Organic Growth | 1.5 | % | Stable municipal water demand offset by industrial softness |
| FSDP Organic Growth | -1.0 | % | Near-term volume headwinds in dispensing and fire equipment |
| HST Adjusted EBITDA Margin | 31.0 | % | Historical average and management guidance |
| FMT Adjusted EBITDA Margin | 33.0 | % | Historical average and management guidance |
| FSDP Adjusted EBITDA Margin | 29.0 | % | Historical average and management guidance |
| Unallocated Corporate Costs | 1.8 | % of Sales | Historical run-rate |
| Effective Tax Rate | 24.0 | % | Management guidance for 2026 |
| Capex % of Revenue | 2.0 | % | Asset-light manufacturing model |
| Share Repurchases | 250.0 | $ Millions | Ongoing quarterly target of ~$75M minus slight conservatism |
| Dividend Payout Ratio | 32.0 | % | Midpoint of historical target range |
| Cost of Debt | 4.5 | % | Weighted average interest rate on current debt |
| WACC | 8.5 | % | Standard discount rate for diversified industrials |
| Terminal Growth Rate | 2.5 | % | Long-term GDP plus slight premium for niche market positioning |
Data Sources & Benchmarks
- SEC EDGAR: IDEX Corporation 10-K and 10-Q filings.
- IDEX Investor Relations: Q4 2025 Earnings Release and Investor Presentation.
- Key peers for benchmarking: Danaher (DHR), Roper Technologies (ROP), Illinois Tool Works (ITW), and Nordson (NDSN).
- Industry data sources: Semiconductor Industry Association (SIA) billings report, Dodge Construction Network for municipal starts.
- Consensus estimates: FactSet or Bloomberg for forward-looking EPS and revenue consensus.
Sources
Do more with the IDEX model
Frequently asked
What does IDEX Corporation do and what are its main business segments?+
IDEX Corporation is a global applied solutions provider that designs and manufactures highly engineered, mission-critical components for niche markets. Its main business segments are Health & Science Technologies (HST), Fluid & Metering Technologies (FMT), and Fire & Safety/Diversified Products (FSDP).
How does IDEX Corporation generate its revenue?+
IDEX generates revenue by providing highly engineered components and solutions across various niche markets, with an even split between domestic and international sales. The company manages over 50 subsidiaries through its 80/20 operational framework to drive margin expansion and portfolio optimization.
What are the key revenue growth assumptions in the IDEX financial model?+
The financial model for IDEX Corporation forecasts revenue growth at approximately 7.03% annually over the FY2026–FY2030 horizon. This growth reflects the company's strong competitive position in specialized, fragmented markets and its strategy of serial bolt-on acquisitions.
What is IDEX Corporation's capital expenditure strategy?+
IDEX Corporation maintains an asset-light manufacturing model, with capital expenditure typically ranging between 1.5% and 2.5% of revenue. Approximately 60% of this capex is for maintenance, with the remainder dedicated to growth and facility automation.
What are the typical acquisition multiples for IDEX Corporation's bolt-on acquisitions?+
IDEX Corporation is a serial bolt-on acquirer, frequently purchasing founder-owned businesses in niche markets. Typical acquisition multiples for these transactions range from 12x to 15x EBITDA pre-synergies.
Can I download an Excel financial model for IDEX Corporation?+
Yes, a comprehensive Excel financial model for IDEX Corporation is available for download. This model provides tools for equity valuation and M&A scenario planning, forecasting financials from FY2026 through 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 Industrial Equipment Company Financial Models
Browse another company in the same sector.
Ametek
Ametek is a global manufacturer of highly engineered electronic instruments and electromechanical devices, serving niche industrial markets through organic innovation and disciplined acquisitions.
Caterpillar
Caterpillar is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives.
Cummins
Cummins designs, manufactures, distributes, and services a broad portfolio of power solutions, from diesel and natural gas engines to electric and hybrid powertrains, for commercial vehicle and industrial markets.
Deere & Company
Deere & Company is a global leader in the manufacturing of agricultural, construction, and forestry equipment, operating under the iconic John Deere brand.
Dover
Dover Corporation is a diversified global manufacturer delivering innovative equipment, consumable supplies, aftermarket parts, and software solutions.
Emerson Electric
Emerson Electric is a global technology and software company providing advanced automation solutions for process, hybrid, and discrete manufacturing industries, helping customers optimise operations, reduce emissions, and improve safety through proprietary hardware and software.
Fastenal
Fastenal Company is a leading North American wholesale distributor of industrial and construction supplies, operating through a dense network of branches and customer-specific Onsite locations.
Fortive
Fortive is a diversified industrial technology conglomerate that provides essential technologies for connected workflow solutions across industrial and healthcare applications.
Explore more Manufacturing financial model templates.
