Linde Financial Model
Chemicals Company Financials Example (Free Excel Download)
Linde plc is the world's largest industrial gas and engineering company, producing atmospheric and process gases for a variety of end markets including chemicals, manufacturing, healthcare, and electronics.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool for Linde plc, allowing an analyst to forecast earnings and cash flow based on volume recovery, pricing power, energy cost pass-through dynamics, and the execution of its $10.4 billion project backlog.
Linde plc is the world's largest industrial gas and engineering company, producing atmospheric and process gases for a variety of end markets including chemicals, manufacturing, healthcare, and electronics. The company operates a highly resilient, localised business model characterised by high barriers to entry, long-term contracts, and significant pricing power.
Business segments include:
- Americas (approximately 43% of revenue)
- EMEA (approximately 25% of revenue)
- APAC (approximately 20% of revenue)
- Linde Engineering (approximately 12% of revenue)
The business model is asset-heavy but highly contracted. The on-site supply business relies on 15 to 20-year take-or-pay contracts with energy cost pass-through provisions, ensuring stable returns on capital. The merchant and packaged gas businesses are more exposed to local economic volumes but benefit from high route density and pricing power. Linde operates in a consolidated global oligopoly alongside Air Liquide and Air Products. A major recent event was the company's 2023 delisting from the Frankfurt Stock Exchange to simplify its corporate structure and list solely on the Nasdaq.
The downloadable Linde 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 & AssumptionsLinde financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $30.79B | $33.36B | $32.85B | $33.01B | $33.99B |
| Cost of sales, exclusive of depreciation and amortization | $17.54B | $19.45B | $17.49B | $17.14B | $17.39B |
| Operating income | $4.98B | $5.37B | $8.02B | $8.63B | $8.92B |
| Net income | $3.83B | $4.15B | $6.20B | $6.57B | $6.90B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Linde
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: (Prior Year Revenue x (1 + Volume Growth + Price Attainment)) + Cost Pass-Through + FX Impact
- Historical growth rate: 1% to 5% underlying growth
- Key growth levers and headwinds: Industrial production trends in the US and Latin America, electronics manufacturing demand, and clean energy project ramp-ups.
- Pricing dynamics: Highly contractual with inflation-linked escalators.
- Revenue recognition notes: Over time as gas is delivered.
- Seasonality: Relatively stable, though Q1 can be slightly weaker due to winter weather impacting construction and manufacturing.
EMEA
- Segment name: EMEA
- Revenue driver formula: (Prior Year Revenue x (1 + Volume Growth + Price Attainment)) + Cost Pass-Through + FX Impact
- Historical growth rate: Flat to 3% underlying growth
- Key growth levers and headwinds: European macroeconomic weakness and manufacturing slowdowns act as headwinds, offset by strong pricing power.
- Pricing dynamics: Spot pricing in merchant markets and contractual escalators in on-site supply.
- Revenue recognition notes: Over time as gas is delivered.
- Seasonality: Q3 often sees a slight dip due to European summer holidays reducing industrial production.
APAC
- Segment name: APAC
- Revenue driver formula: (Prior Year Revenue x (1 + Volume Growth + Price Attainment)) + Cost Pass-Through + FX Impact
- Historical growth rate: 3% to 6% underlying growth
- Key growth levers and headwinds: Electronics end-market demand (semiconductors) and heavy industrial growth in China and India.
- Pricing dynamics: Competitive but disciplined, with strong local network density.
- Revenue recognition notes: Over time as gas is delivered.
- Seasonality: Q1 is typically impacted by the Lunar New Year slowdown in Asia.
Linde Engineering
- Segment name: Linde Engineering
- Revenue driver formula: Beginning Backlog + Order Intake - Revenue Recognised
- Historical growth rate: Highly cyclical, historically -5% to +10% depending on project timing
- Key growth levers and headwinds: Global capital expenditure cycles, particularly in petrochemicals, hydrogen, and carbon capture.
- Pricing dynamics: Fixed-price or cost-plus contracts bid competitively.
- Revenue recognition notes: Percentage-of-completion method based on costs incurred relative to total estimated costs.
- Seasonality: Lumpy and dependent on project milestones rather than seasonal weather.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Energy costs (electricity and natural gas used to run air separation units), distribution and freight costs, and raw materials.
- Gross margin range: 37% to 40% over the last 5 years.
- Key input costs and commodity exposures: Electricity and natural gas. Crucially, energy costs for on-site customers are passed through directly to revenue, meaning higher energy prices inflate both revenue and COGS equally, compressing gross margin percentages but leaving gross profit dollars unchanged.
- How COGS scales with revenue: Step-function for new plant start-ups, but highly variable with energy prices.
Operating Expenses
- R&D: Approximately 0.5% of revenue, focused on decarbonisation and application technologies.
- SG&A: Approximately 12.5% to 13.0% of revenue. This includes selling, marketing, and administrative expenses. It is largely headcount-driven and scales with inflation.
- Depreciation & Amortisation: Heavy, typically 10% to 12% of revenue, reflecting the capital-intensive nature of building air separation units and the amortisation of intangibles from the Praxair merger.
- Stock-Based Compensation: Approximately 0.5% to 1.0% of revenue.
- Restructuring / one-time charges: Infrequent, though occasional cost-optimisation programmes occur during macroeconomic downturns.
Margin Profile
- Gross margin: 37% to 40%.
- EBITDA margin: 35% to 38%.
- Operating margin: 26% to 29.5% (Adjusted operating margin reached 29.5% in 2024).
- Net margin: 18% to 20%.
- Margin trend: Expanding. Linde has consistently expanded operating margins through pricing power that exceeds cost inflation and rigorous productivity initiatives.
Balance Sheet Structure
- Total assets: Approximately $80 billion.
- Key asset categories: Property, plant and equipment (PP&E) and goodwill.
- Goodwill & intangibles: Approximately 45% to 50% of total assets, stemming primarily from the 2018 merger of equals between Linde AG and Praxair.
- Working capital profile:
- Days Sales Outstanding (DSO): 55 to 65 days.
- Days Inventory Outstanding (DIO): 30 to 40 days (inventory is relatively low as gas is produced and consumed quickly).
- Days Payable Outstanding (DPO): 70 to 80 days.
- Net working capital as % of revenue: Slightly negative to neutral.
- Working capital funding: The company generally operates with efficient working capital, using strong supplier terms to fund operations.
- PP&E: Represents air separation units, hydrogen plants, cylinders, and distribution equipment. Useful lives range from 15 to 40 years for major plants.
- Right-of-use assets / operating leases: Material but manageable, representing approximately 2% to 3% of total assets.
Capital Expenditure & Investment
- Capex as % of revenue: 10% to 14% (13.6% in 2024, or $4.5 billion).
- Maintenance capex vs. growth capex: Approximately 30% maintenance and 70% growth.
- Major capex programmes: Execution of the $10.4 billion project backlog, heavily weighted towards clean energy (low-carbon hydrogen, carbon capture) and electronics.
- Capitalised software / development costs: Immaterial compared to hard asset capex.
- M&A pattern: Bolt-on acquirer. Linde regularly acquires small regional independent distributors to increase local route density.
- Typical acquisition multiple paid: 8x to 12x EBITDA for small private distributors.
Debt & Capital Structure
- Total debt: Approximately $17 billion to $18 billion.
- Debt/EBITDA ratio: 1.3x to 1.5x.
- Credit rating: A2 (Moody's) / A (S&P).
- Key debt instruments: Unsecured commercial paper, eurobonds, and US dollar notes.
- Maturity profile: Well-laddered with average maturities exceeding 5 years.
- Interest rate profile: Predominantly fixed rate through bond issuances, with a weighted average cost of debt around 3.0% to 3.5%.
- Covenants: Standard investment-grade covenants, no restrictive financial maintenance covenants.
- Share repurchase programme: Highly active. The company routinely repurchases $4 billion to $5 billion of stock annually.
- Dividend policy: Progressive dividend policy. Payout ratio is typically 35% to 40% of net income, with a yield around 1.2% to 1.5%.
Cash Flow Characteristics
- Operating cash flow conversion: OCF is typically 1.3x to 1.4x Net Income ($9.4 billion OCF in 2024).
- Free cash flow margin: 14% to 16% of revenue.
- Major non-cash items: Depreciation and amortisation (over $4 billion annually) and deferred taxes.
- Working capital cash flow impact: Generally a minor source of cash due to efficient payables management.
- Capex intensity: High absolute capex, but highly predictable and backed by long-term customer contracts.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are typically lower than the GAAP effective tax rate due to accelerated depreciation on large capital projects.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic variables, segment growth, pricing, margins, and capital allocation.
- Revenue Build: Detailed build for Americas, EMEA, APAC, and Engineering, splitting out volume, price, FX, and cost pass-through.
- Income Statement: Consolidated P&L mirroring the 10-K, from Sales down to Net Income - Linde plc Shareholders.
- Balance Sheet: Assets, Liabilities, and Equity, highlighting PP&E, Goodwill, and Debt.
- Cash Flow Statement: Operating, Investing, and Financing cash flows, calculating Free Cash Flow.
- Debt & Interest Schedule: Tranches of debt, interest expense calculations, and debt paydown/issuance logic.
- PP&E & Capex Schedule: Base capex, project backlog capex, and depreciation waterfall.
- Working Capital Schedule: Receivables, inventory, and payables driven by DSO, DIO, and DPO.
- Shareholders Equity & Returns: Share count tracking, buyback modelling, and dividend payouts.
- Valuation (DCF): WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- Americas Revenue = Prior Year Americas Revenue x (1 + Americas Volume Growth + Americas Price Growth) + Americas Cost Pass-Through + Americas FX Impact
- EMEA Revenue = Prior Year EMEA Revenue x (1 + EMEA Volume Growth + EMEA Price Growth) + EMEA Cost Pass-Through + EMEA FX Impact
- APAC Revenue = Prior Year APAC Revenue x (1 + APAC Volume Growth + APAC Price Growth) + APAC Cost Pass-Through + APAC FX Impact
- Engineering Revenue = Prior Year Engineering Revenue x (1 + Engineering Growth Rate)
- Consolidated Sales = Americas Revenue + EMEA Revenue + APAC Revenue + Engineering Revenue
- Cost of Sales = (Consolidated Sales x Base COGS Margin) + Total Cost Pass-Through
- SG&A Expense = Consolidated Sales x SG&A Margin (historically ~13.0%)
- Depreciation Expense = Beginning PP&E x Blended Depreciation Rate
- Operating Profit = Consolidated Sales - Cost of Sales - SG&A Expense - Depreciation & Amortisation - R&D
- Interest Expense = Average Total Debt x Weighted Average Interest Rate
- Effective Tax Rate = Income Tax Expense / Income Before Income Taxes
- Share Repurchases = Total Capital Return Target - Total Dividend Payments
- Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchases / Average Share Price)
Cross-Sheet Dependencies
- The Revenue Build feeds the top line of the Income Statement.
- The PP&E & Capex Schedule calculates depreciation, which feeds both the Income Statement (operating profit) and the Cash Flow Statement (non-cash add-back).
- The Working Capital Schedule calculates changes in NWC, which feeds the Cash Flow Statement.
- The Cash Flow Statement determines cash available for debt reduction or share buybacks, feeding the Debt & Interest Schedule and Shareholders Equity & Returns.
- Circularity risk exists between the Debt & Interest Schedule and the Income Statement (interest expense lowers net income, which lowers cash flow, which increases debt, which increases interest expense). A circuit breaker toggle must be included.
Sign Convention
- Revenue and income items are positive.
- Expenses (COGS, SG&A, Interest, Taxes) are modelled as positive numbers and subtracted in subtotals.
- Assets are positive. Liabilities and Equity are positive.
- Cash Flow: Inflows are positive, outflows (capex, dividends, buybacks, debt repayment) are negative.
Things Most Likely to Go Wrong
- Cost Pass-Through Mechanics: Analysts often model margin percentages as fixed. In reality, when energy prices spike, Linde passes the cost to customers. Revenue goes up, COGS goes up by the exact same dollar amount, and operating profit dollars remain flat, which mathematically compresses the operating margin percentage.
- FX Translation: Linde reports in USD but generates over 60% of its revenue in other currencies (Euro, Pound, Yuan, Real). The model must separate underlying growth from FX impacts.
- Purchase Accounting Amortisation: The Praxair merger created massive intangible assets. GAAP operating profit includes heavy amortisation. The model must track "Adjusted Operating Profit" which excludes these non-cash charges to reflect true business performance.
- Engineering Segment Volatility: Engineering revenue does not grow linearly. It depends on project milestones. Straight-lining this segment will cause inaccurate quarterly forecasts.
- Backlog Conversion: The $10.4 billion backlog takes years to convert to revenue. Modelling it as immediate revenue will drastically overstate near-term growth.
- Share Count Reduction: Linde aggressively buys back stock. Failing to dynamically reduce the share count will severely understate EPS growth.
- Capital Expenditure Timing: Growth capex is tied to the backlog. If backlog execution is delayed, capex must be pushed to the right, which impacts free cash flow.
- Return on Capital (ROC) Calculation: Linde management focuses heavily on ROC. The model must calculate ROC exactly as management does (After-tax adjusted operating profit / (Equity + Debt)) to validate against their 25.9% reported figure.
Validation Checks
- "Adjusted Operating Margin should be in the 28% to 30% range; flag if it drops below 27%."
- "Capex as % of revenue should run between 10% and 14% based on historical backlog execution."
- "OCF/Net Income conversion should be >1.2x (company has consistently strong cash conversion)."
- "Debt/EBITDA should remain below 2.0x to maintain the A/A2 credit rating."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Return on Capital (ROC) should remain above 20% (reported 25.9% in 2024)."
- "Effective tax rate should be 23% to 24%."
- "Dividend payout ratio should remain within 35% to 45% of net income."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Americas Underlying Growth | 2.0 | % | Reflects stable volumes and consistent pricing power (FY24 actuals). |
| EMEA Underlying Growth | 1.0 | % | Reflects weak European macro offset by pricing (FY24 actuals). |
| APAC Underlying Growth | 1.0 | % | Reflects project start-ups offsetting regional softness (FY24 actuals). |
| Engineering Revenue Growth | -5.0 | % | Reflects lumpy project timing and FY24 decline. |
| Cost of Sales % (Base) | 61.4 | % | FY24 actual reported cost of sales margin. |
| SG&A / R&D % | 13.0 | % | FY24 actual reported SG&A and R&D margin. |
| Adjusted Operating Margin | 29.5 | % | FY24 actual adjusted operating margin. |
| Capex as % of Sales | 13.6 | % | FY24 actual ($4.5B capex on $33.0B sales). |
| Effective Tax Rate | 23.4 | % | FY24 actual reported effective tax rate. |
| Dividend Growth Rate | 9.0 | % | Historical average annual dividend increase. |
| Annual Share Repurchases | 4,500 | $ Millions | Estimated based on recent capital return run-rates. |
| Cost of Debt | 3.5 | % | Estimated weighted average interest rate on long-term debt. |
| WACC | 7.5 | % | Standard discount rate for a stable, large-cap industrial. |
| Terminal Growth Rate | 2.5 | % | Long-term global GDP and inflation proxy. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Linde plc 10-K, 10-Q, 8-K) and the Linde Investor Relations website.
- Key Peers: Air Liquide (AI.PA), Air Products and Chemicals (APD).
- Industry Data: Chemical Activity Barometer (CAB), global industrial production indices, and semiconductor manufacturing build-out data.
- Consensus Estimates: Bloomberg or FactSet for near-term EPS and revenue consensus.
Sources
Do more with the Linde model
Frequently asked
What does Linde plc do and what are its main business segments?+
Linde plc is the world's largest industrial gas and engineering company, producing atmospheric and process gases for a variety of end markets including chemicals, manufacturing, healthcare, and electronics. Its business segments include Americas, EMEA, APAC, and Linde Engineering, reflecting its global operational reach.
What drives Linde plc's revenue and business stability?+
Linde's revenue is driven by its highly resilient, localized business model, characterized by long-term take-or-pay contracts with energy cost pass-through provisions. This structure, combined with volume recovery, pricing power, and the execution of its $10.4 billion project backlog, ensures stable returns and top-line performance.
What is Linde plc's capital expenditure strategy and how does it impact its financial model?+
Linde's capital expenditure, typically 10% to 14% of revenue, is primarily allocated to growth initiatives, particularly in clean energy and electronics. This significant investment, including its $10.4 billion project backlog, is a crucial assumption in financial models, reflecting future expansion and cash flow generation.
What are key considerations for valuing Linde plc using a DCF model?+
Key considerations for a DCF model include forecasting earnings and cash flow based on volume recovery, pricing power, and energy cost pass-through dynamics. Analysts should also account for the execution of its substantial project backlog and its asset-heavy, highly contracted business model when determining valuation inputs.
Can I download an Excel financial model for Linde plc and what is its forecast horizon?+
Yes, an Excel financial model for Linde plc is available for download, serving as a comprehensive equity valuation and scenario planning tool. This model provides forecasts for earnings and cash flow with a horizon extending from FY2026 to FY2030.
How does Linde plc manage its working capital and what is its net working capital profile?+
Linde plc manages its working capital efficiently, often using strong supplier terms to fund operations. Its net working capital as a percentage of revenue typically ranges from slightly negative to neutral, indicating effective management of its current assets and liabilities.
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 Chemicals Company Financial Models
Browse another company in the same sector.
Albemarle
Albemarle Corporation is a global specialty chemicals company and one of the world's largest producers of lithium and bromine.
Air Products
Air Products and Chemicals, Inc.
CF Industries
CF Industries Holdings, Inc.
Corteva
Corteva is a global pure-play agriculture company that provides farmers with a comprehensive portfolio of seed, crop protection, and digital solutions built on advanced genetics, biologicals, and synthetic chemistry.
DuPont
DuPont is a global advanced materials and engineered solutions company that provides highly specified products to regulated and performance-critical industries, including medical packaging, water filtration, and engineered materials for aerospace and construction.
Dow
Dow is a global materials science company that produces plastics, chemicals, and agricultural products for packaging, infrastructure, mobility, and consumer applications, operating integrated manufacturing sites that convert hydrocarbon feedstocks into value-added chemical products.
Ecolab
Ecolab is a global leader in water, hygiene, and infection prevention solutions and services, providing proprietary chemicals and dispensing equipment to industrial, hospitality, healthcare, and life sciences customers via a direct field sales and service force.
International Flavors & Fragrances
International Flavors & Fragrances (IFF) is a global leader in the creation of value-added ingredients for the food, beverage, health, biosciences, and scent markets.
Explore more Manufacturing financial model templates.
