Xylem Financial Model

• Water Infrastructure
• Revenue driver formula: "Equipment Orders x Backlog Conversion Rate + Aftermarket Parts Sales"
• Historical growth rate: 5-8% organic CAGR.
• Key growth levers and headwinds: Driven by municipal infrastructure spending, government stimulus, and climate resilience projects. Headwinds include project delays and municipal budget constraints.
• Pricing dynamics: Contractual bidding for large projects, spot pricing for aftermarket parts. Strong pricing power due to mission-critical nature.
• Revenue recognition notes: Percentage-of-completion for large custom projects; point-in-time for standard pumps.
• Seasonality: Q4 is typically the strongest quarter due to municipal budget flush.

• Applied Water
• Revenue driver formula: "Volume of Units Sold x Average Selling Price"
• Historical growth rate: 1-3% organic CAGR (more mature, cyclical segment).
• Key growth levers and headwinds: Tied to residential and commercial construction, HVAC demand, and agricultural irrigation. Highly sensitive to interest rates and construction cycles.
• Pricing dynamics: Highly competitive, standard catalogue pricing with distributor discounts.
• Revenue recognition notes: Recognised at a point in time upon shipment to distributors.
• Seasonality: Stronger in Q2 and Q3 aligning with Northern Hemisphere construction and agricultural seasons.

• Measurement & Control Solutions (MCS)
• Revenue driver formula: "Smart Meters Deployed x Unit Price + Software Subscriptions x ARPU"
• Historical growth rate: 8-12% organic CAGR.
• Key growth levers and headwinds: Driven by utility digital transformation, non-revenue water reduction mandates, and smart grid investments.
• Pricing dynamics: Long-term utility contracts with recurring software-as-a-service (SaaS) fees.
• Revenue recognition notes: Hardware recognised upon delivery; software and analytics recognised rateably over the subscription period. Deferred revenue is a key metric.
• Seasonality: Relatively smooth, though large utility deployments can cause lumpy quarter-to-quarter revenue.

• Water Solutions and Services (WSS)
• Revenue driver formula: "Active Service Contracts x Average Contract Value + Outsourced Treatment Volumes x Rate"
• Historical growth rate: 10-12% CAGR (pro-forma post-Evoqua).
• Key growth levers and headwinds: Driven by industrial outsourcing of water treatment, emerging contaminant regulations (such as PFAS), and water scarcity.
• Pricing dynamics: Highly recurring, multi-year service agreements with inflation escalators.
• Revenue recognition notes: Recognised over time as services are rendered.
• Seasonality: Consistent throughout the year due to the recurring nature of service contracts.

• Total assets: Approximately $16 billion to $18 billion.
• Key asset categories: Goodwill and intangible assets dominate the balance sheet.
• Goodwill & intangibles: Represent over 60% of total assets, a direct result of the $7.5 billion Evoqua acquisition and historical roll-up strategy.
• Working capital profile:
• Days Sales Outstanding (DSO): 60 to 70 days.
• Days Inventory Outstanding (DIO): 70 to 85 days (inventory levels remain elevated to buffer supply chain shocks).
• Days Payable Outstanding (DPO): 55 to 65 days.
• Net working capital as % of revenue: 15% to 20%.
• Is working capital positive or negative? Positive. The company consumes cash for working capital as it grows.
• PP&E: Approximately 10% of total assets. Consists of manufacturing facilities, service branches, and a mobile water treatment fleet.
• Right-of-use assets / operating leases: Material, representing leased service branches and office spaces globally.

• Capex as % of revenue: 3.5% to 4.5%.
• Maintenance capex vs. growth capex: Approximately 40% maintenance, 60% growth (including expansion of the mobile water treatment fleet and digital infrastructure).
• Major capex programmes: Expanding the outsourced water service fleet and investing in automated manufacturing.
• Capitalised software / development costs: Material for the MCS segment (Xylem Vue digital suite).
• M&A pattern: Transformational acquirer (Evoqua) combined with frequent bolt-on acquisitions (e.g., Idrica for digital analytics).
• Typical acquisition multiple: 15x to 20x EV/EBITDA for high-quality water assets.

• Total debt: Approximately $2.5 billion to $3.0 billion.
• Debt/EBITDA ratio: Very low leverage, currently around 0.5x net debt to adjusted EBITDA.
• Credit rating: Investment grade (BBB/Baa2).
• Key debt instruments: Senior unsecured notes and a revolving credit facility.
• Maturity profile: Well-laddered with average maturity exceeding 5 years.
• Interest rate profile: Predominantly fixed-rate bonds with a weighted average cost of debt around 3.5% to 4.5%.
• Covenants: Standard interest coverage and leverage covenants; currently operating with massive headroom.
• Share repurchase programme: Active, typically offsetting dilution from stock-based compensation.
• Dividend policy: Consistent dividend grower, targeting a payout ratio of 30% to 35% of net income, with a yield around 1.0% to 1.5%.

• Operating cash flow conversion: Very strong, typically 110% to 120% of net income.
• Free cash flow margin: 9% to 11% of revenue.
• Major non-cash items: High depreciation and amortisation (especially purchase accounting intangibles) and stock-based compensation bridge the gap between GAAP net income and OCF.
• Working capital cash flow impact: A use of cash during periods of high organic growth, particularly due to inventory builds for large infrastructure projects.
• Capex intensity: Moderate (around 4% of revenue), allowing for strong free cash flow generation.
• Cash tax rate: 18% to 22%, generally aligning closely with the GAAP effective tax rate.

1. Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth rates, margin targets, working capital days, and tax rates.
2. Revenue & Orders: Backlog roll-forward, order intake, and revenue build for the four segments (Water Infrastructure, Applied Water, Measurement & Control Solutions, Water Solutions and Services).
3. Income Statement: Consolidated P&L from revenue down to EPS, including adjusted EBITDA and adjusted EPS reconciliations.
4. Working Capital: Schedules for Accounts Receivable, Inventory, Accounts Payable, and Deferred Revenue based on days assumptions.
5. Depreciation & Amortisation: Waterfall schedules for existing PP&E, new capex, capitalised software, and acquisition-related intangibles.
6. Debt Schedule: Tranche-by-tranche debt build, interest expense calculation, and debt paydown logic.
7. Balance Sheet: Standard assets, liabilities, and equity, balancing via the cash revolver plug.
8. Cash Flow Statement: Indirect method starting from net income, adjusting for D&A, working capital changes, and capex to arrive at Free Cash Flow.
9. DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.

1. "Water Infrastructure Revenue = Beginning WI Backlog x WI Backlog Conversion Rate + WI Book-and-Ship Orders"
2. "Applied Water Revenue = Prior Year AW Revenue x (1 + AW Volume Growth + AW Price Increase)"
3. "MCS Revenue = Hardware Sales + (Beginning Active Subscriptions x ARPU)"
4. "WSS Revenue = Prior Year WSS Revenue x (1 + Contract Renewal Rate + New Outsourcing Wins)"
5. "Total Revenue = Water Infrastructure Revenue + Applied Water Revenue + MCS Revenue + WSS Revenue"
6. "Segment Adjusted EBITDA = Segment Revenue x Segment Adjusted EBITDA Margin"
7. "Consolidated Adjusted EBITDA = Sum of Segment Adjusted EBITDAs - Corporate Unallocated Expenses"
8. "GAAP Operating Income = Consolidated Adjusted EBITDA - D&A - Restructuring & Realignment Costs - Stock-Based Compensation"
9. "Accounts Receivable = (Total Revenue / 365) x DSO"
10. "Inventory = (COGS / 365) x DIO"
11. "Accounts Payable = (COGS / 365) x DPO"
12. "Interest Expense = Average Debt Balance x Weighted Average Interest Rate"
13. "Free Cash Flow = Operating Cash Flow - Capital Expenditures - Capitalised Software"
14. "Net Debt = Total Short-Term Debt + Total Long-Term Debt - Cash and Cash Equivalents"

The Assumptions sheet dictates the growth and margin profiles on the Revenue & Orders and Income Statement sheets. The Revenue & Orders sheet feeds the top line of the Income Statement and drives the activity levels in the Working Capital sheet. The Income Statement generates net income, which is the starting point for the Cash Flow Statement. The Working Capital and Depreciation & Amortisation sheets feed non-cash adjustments and cash flow impacts into the Cash Flow Statement. The Cash Flow Statement determines the ending cash balance and any required borrowing, which feeds the Debt Schedule. The Debt Schedule calculates interest expense, looping back to the Income Statement. Finally, all ending balances from the Working Capital, Depreciation & Amortisation, Debt Schedule, and Cash Flow Statement flow into the Balance Sheet to ensure Assets equal Liabilities plus Equity.

• Revenue and income items are positive.
• Expenses (COGS, SG&A, R&D, Interest, Taxes) are entered as positive numbers and subtracted in subtotals.
• Assets are positive.
• Liabilities and Equity are positive.
• On the Cash Flow Statement, cash inflows are positive and cash outflows (including Capex and Dividends) are negative.
• Working capital increases (assets) are negative on the Cash Flow Statement; working capital increases (liabilities) are positive.

• "The Evoqua acquisition fundamentally changed segment reporting in 2023; historical data prior to Q3 2023 must be adjusted on a pro-forma basis to be comparable."
• "Purchase accounting intangible amortisation is massive post-Evoqua; failing to add this back will severely understate adjusted EPS and operating cash flow."
• "Restructuring and realignment costs are treated as 'one-time' by management but occur every year; the model must account for these cash outflows even if excluded from adjusted EBITDA."
• "The WSS segment has a completely different margin and capital intensity profile (mobile fleet capex) compared to the legacy equipment segments."
• "Deferred revenue is critical for the MCS segment; ignoring the deferred revenue build will misalign cash flow and GAAP revenue."
• "Corporate unallocated expenses are material; summing segment operating income without deducting corporate overhead will overstate consolidated margins."
• "Foreign exchange translation impacts revenue by 2-4% annually; the model should forecast on a constant-currency basis and apply an FX overlay."
• "The share count increased significantly in 2023 due to the all-stock Evoqua deal; ensure the historical per-share metrics use the correct weighted average shares outstanding."

• "Consolidated Adjusted EBITDA margin should be in the 21.0% to 22.5% range; flag if outside this band."
• "Free Cash Flow conversion (FCF / Net Income) should exceed 100%; flag if it drops below 1.0x."
• "Net Debt to Adjusted EBITDA should remain below 2.0x; the company currently operates near 0.5x."
• "Capex as a percentage of revenue should run between 3.5% and 4.5%."
• "The Balance Sheet must balance perfectly in every forecasted period (Total Assets = Total Liabilities + Equity)."
• "Effective tax rate should remain between 18% and 22%."
• "Dividend payout ratio should not exceed 40% of net income based on stated capital allocation policies."
• "Gross margin should not exceed 42% without a flagged justification regarding extreme pricing power or mix shift."

• Where to find this company's filings: SEC EDGAR (Xylem Inc. CIK 0001524472), Xylem Investor Relations page.
• Key peers for benchmarking: Pentair (PNR), Watts Water Technologies (WTS), Veralto (VLTO), Badger Meter (BMI).
• Industry data sources: American Water Works Association (AWWA) reports, US EPA infrastructure spending data.
• Consensus estimates source: FactSet or Bloomberg for forward-looking EPS and revenue estimates.

• Xylem Inc. Q4 2024 Earnings Release and Presentation (xylem.com)
• Xylem Inc. 2024 Annual Report on Form 10-K
• Xylem Inc. 2024 Investor Day Presentation
• Xylem Inc. Q3 2025 Earnings Release
• Evoqua Water Technologies Acquisition Press Releases (January and May 2023)