# Air Products (APD) Financial Model Free Excel 3-statement financial model and company analysis for Air Products. - Canonical: https://finamodel.com/companies/air-products - Industry: Chemicals - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/APD.xlsx ## Model Purpose This model provides a comprehensive equity valuation and capital allocation analysis for Air Products, enabling an analyst to evaluate whether the company's highly predictable core industrial gas cash flows can successfully fund its massive, capital-intensive clean energy transition megaprojects without jeopardising its dividend track record or 'A' credit rating. ## Company Overview Air Products and Chemicals, Inc. is a global leader in the industrial gases sector, supplying atmospheric and process gases, as well as related equipment, to dozens of industries including refining, chemicals, metals, and electronics. The company is also the world's largest supplier of hydrogen and is currently executing several multi-billion-dollar clean hydrogen megaprojects to support the global energy transition. Business segments include: * Americas (approx. 43% of revenue) * Asia (approx. 28% of revenue) * Europe (approx. 24% of revenue) * Middle East and India (ME&I) (minimal consolidated revenue; primarily equity affiliate income) * Corporate and other (approx. 5% of revenue, declining due to recent divestitures) The business model is highly asset-heavy but generates extremely stable cash flows due to long-term take-or-pay contracts with energy cost pass-through provisions. The company operates as an oligopoly alongside key competitors Linde and Air Liquide. Recently, Air Products sold its LNG equipment business to Honeywell in September 2024 for $1.8 billion and recorded a massive $3.7 billion pre-tax charge in fiscal 2025 to rationalise its energy transition project portfolio. ## Revenue Deep Dive ### Americas * **Segment name:** Americas * **Revenue driver formula:** Prior Year Revenue x (1 + Volume Growth + Pricing Growth + Energy Cost Pass-Through + FX Impact) * **Historical growth rate:** 2-5% underlying growth (highly volatile reported growth due to energy pass-throughs) * **Key growth levers and headwinds:** Industrial production indices, refinery utilisation rates, and new on-site plant start-ups. * **Pricing dynamics:** Contractual with inflation escalators. Power and natural gas costs are contractually passed through to on-site customers. * **Revenue recognition notes:** On-site revenue is recognised over time as gas is delivered; take-or-pay fixed fees are recognised straight-line. * **Seasonality:** Mild seasonality; slightly weaker in winter months due to lower construction and industrial activity. ### Asia * **Segment name:** Asia * **Revenue driver formula:** Prior Year Revenue x (1 + Volume Growth + Pricing Growth + Energy Cost Pass-Through + FX Impact) * **Historical growth rate:** 5-8% CAGR * **Key growth levers and headwinds:** Electronics manufacturing demand, coal gasification projects in China, and currency fluctuations. * **Pricing dynamics:** Similar to Americas, but with higher exposure to merchant (spot/short-term) pricing dynamics in developing markets. * **Revenue recognition notes:** Standard delivery-based recognition. * **Seasonality:** Impacted by the Lunar New Year in Q2 (January/February). ### Europe * **Segment name:** Europe * **Revenue driver formula:** Prior Year Revenue x (1 + Volume Growth + Pricing Growth + Energy Cost Pass-Through + FX Impact) * **Historical growth rate:** 1-3% CAGR * **Key growth levers and headwinds:** Heavy industry decarbonisation, sluggish broader macroeconomic growth in the Eurozone. * **Pricing dynamics:** High energy cost pass-through volatility given European natural gas and power market fluctuations. * **Revenue recognition notes:** Standard delivery-based recognition. * **Seasonality:** Summer holiday slowdowns in Q4 (July/August). ### Middle East and India * **Segment name:** Middle East and India * **Revenue driver formula:** Primarily driven by Equity Affiliates' Income rather than consolidated sales. * **Historical growth rate:** Step-function growth based on project completions. * **Key growth levers and headwinds:** The Jazan Integrated Gasification and Power Company joint venture in Saudi Arabia. * **Pricing dynamics:** Long-term fixed-return joint venture structures. * **Revenue recognition notes:** Accounted for under the equity method; does not hit the consolidated revenue line but appears below operating income. * **Seasonality:** None material. ### Corporate and other * **Segment name:** Corporate and other * **Revenue driver formula:** Equipment Sales Volume x Average Project Value * **Historical growth rate:** Highly lumpy; structurally lower post-2024. * **Key growth levers and headwinds:** Sale of the LNG business in September 2024 removes a significant portion of historical revenue from this segment. * **Pricing dynamics:** Percentage-of-completion contract pricing. * **Revenue recognition notes:** Over time using the cost-to-cost method for large equipment manufacturing. * **Seasonality:** Tied to project delivery milestones rather than calendar seasons. ## Cost Structure ### Variable Costs / COGS * **Line-by-line breakdown:** Power, natural gas, and fuel are the primary variable costs. Distribution costs (freight and delivery for the merchant business) are also included. * **Gross margin range:** 30-35% (highly distorted by energy pass-throughs; when energy prices spike, revenue and COGS rise equally, compressing the margin percentage despite flat gross profit dollars). * **Key input costs and commodity exposures:** Electricity and natural gas. * **How COGS scales with revenue:** Linear for merchant volumes; completely 1:1 for energy pass-through revenues. ### Operating Expenses * **R&D:** Less than 1% of revenue; focused on application technologies and process efficiencies. * **SG&A:** Typically 8-10% of revenue; largely headcount-driven and highly leveraged against volume growth. * **Depreciation & Amortisation:** Massive component (approx. 10-12% of revenue) due to the capital-intensive nature of building air separation units and hydrogen plants. * **Stock-Based Compensation:** Less than 1% of revenue; not a major driver compared to tech firms. * **Restructuring / one-time charges:** Frequent and occasionally massive. The company recorded a $3.7 billion pre-tax charge in FY2025 related to rationalising its energy transition portfolio. ### Margin Profile * **Gross margin:** 30-35% * **EBITDA margin:** 40-42% (Adjusted EBITDA margin reached 41.7% in FY2024 and remains structurally above 40%). * **Operating margin:** 28-30% (Adjusted). * **Margin trend:** Expanding slightly due to pricing power and divestiture of lower-margin equipment businesses, though heavily masked by energy pass-through volatility. ## Balance Sheet Structure * **Total assets:** Approximately $30-35 billion. * **Key asset categories:** Plant and equipment, net (PP&E) makes up over 60% of total assets. Equity method investments (like the Jazan JV) are also highly material. * **Goodwill & intangibles:** Less than 10% of total assets; the company grows primarily through organic megaprojects rather than serial acquisitions. * **Working capital profile:** * **Days Sales Outstanding (DSO):** 50-60 days. * **Days Inventory Outstanding (DIO):** 30-40 days (inventory is mostly equipment and spare parts, as gas cannot be easily stored in massive quantities). * **Days Payable Outstanding (DPO):** 60-70 days. * **Net working capital as % of revenue:** Low single digits. * **Is working capital positive or negative?** Slightly positive, but not a major consumer of cash during growth. * **PP&E:** Consists of air separation units, hydrogen steam methane reformers, and pipeline networks. Useful lives range from 15 to 40 years. * **Right-of-use assets / operating leases:** Material but manageable, typically around $500-$700 million. ## Capital Expenditure & Investment * **Capex as % of revenue:** 30-40% (Extraordinarily high due to the current megaproject cycle). * **Maintenance capex vs. growth capex:** Maintenance is roughly $500-$700 million; the remaining $3.5-$4.5 billion is pure growth capex. * **Major capex programmes underway or planned:** NEOM green hydrogen project, Louisiana blue hydrogen project, and Alberta net-zero hydrogen project. * **Capitalised software / development costs:** Immaterial. * **M&A pattern:** Organic grower. Recent history is defined by divestitures (LNG business) rather than acquisitions. * **Typical acquisition multiple paid:** N/A. ## Debt & Capital Structure * **Total debt:** Approximately $10-12 billion. * **Debt/EBITDA ratio:** 2.2x to 3.1x (rising recently due to heavy capex funding needs). * **Credit rating:** 'A' rating from S&P (management is highly committed to maintaining this). * **Key debt instruments:** Senior unsecured notes (bonds) in USD and EUR, supported by a syndicated revolving credit facility. * **Maturity profile:** Well-laddered with average maturities exceeding 5-7 years. * **Interest rate profile:** Predominantly fixed-rate bonds; weighted average cost of debt is approximately 3.5-4.5%. * **Covenants:** Standard interest coverage and leverage maximums; currently operating with massive headroom. * **Share repurchase programme:** Inactive. Cash is entirely directed toward megaprojects and dividends. * **Dividend policy:** Dividend aristocrat with 43+ consecutive years of increases. Current annual payout is $7.16 per share (approx. 55-60% payout ratio on adjusted earnings). ## Cash Flow Characteristics * **Operating cash flow conversion:** OCF / Net Income is typically 1.2x to 1.5x due to massive depreciation add-backs. * **Free cash flow margin:** Heavily negative in the current cycle. FCF / Revenue is often -10% to -20% because $4B+ in capex vastly exceeds $3B in operating cash flow. * **Major non-cash items:** Depreciation, equity affiliate income (deducted from net income, replaced by actual dividends received from Jazan), and periodic massive impairment charges. * **Working capital cash flow impact:** Minimal impact year-over-year. * **Capex intensity:** The defining feature of the company's current financial profile. The company relies on debt issuance to bridge the gap between OCF and (Capex + Dividends). * **Cash tax rate vs. GAAP effective tax rate:** Cash taxes are generally lower than GAAP taxes due to accelerated depreciation on massive capital investments. ## Sheet Structure 1. **Assumptions:** Hardcoded inputs for macroeconomic drivers, segment volume/price growth, energy pass-through estimates, margin targets, and capex guidance. 2. **Income Statement:** Consolidated P&L from Revenue down to Net Income, matching the 10-K line items exactly (Sales, Cost of Sales, Selling and Administrative, Research and Development, Equity Affiliates' Income). 3. **Revenue & Margin Build:** Detailed build for Americas, Asia, Europe, ME&I, and Corporate. Calculates volume, price, and pass-through impacts to bridge year-over-year revenue and segment operating income. 4. **Megaproject & Capex Schedule:** Specific tracker for maintenance capex plus discrete spending curves for NEOM, Louisiana, and Alberta projects. Feeds the PP&E schedule. 5. **Balance Sheet:** Standard assets, liabilities, and equity. Must explicitly break out Equity Method Investments. 6. **Cash Flow Statement:** Indirect method starting from Net Income. Must clearly show the massive capex outflows and debt issuance required to fund the dividend. 7. **Debt & Interest Schedule:** Tranches of senior notes, commercial paper, and revolving credit facility. Calculates interest expense based on average balances. 8. **Depreciation & PP&E:** Waterfall schedule for existing asset base and new megaproject capitalisations. 9. **Valuation (DCF):** Unlevered free cash flow build, WACC calculation, and terminal value based on long-term growth. 10. **Outputs & Dashboard:** Key charts showing Adjusted EBITDA margin trends, FCF deficits, and Debt/EBITDA leverage ratios. ## Key Financial Relationships 1. `Americas Revenue = Prior Year Americas Revenue * (1 + Americas Volume Growth + Americas Price Growth + Americas Energy Pass-Through + Americas FX)` 2. `Asia Revenue = Prior Year Asia Revenue * (1 + Asia Volume Growth + Asia Price Growth + Asia Energy Pass-Through + Asia FX)` 3. `Europe Revenue = Prior Year Europe Revenue * (1 + Europe Volume Growth + Europe Price Growth + Europe Energy Pass-Through + Europe FX)` 4. `Corporate Segment Revenue = Prior Year Corporate Revenue * (1 + Corporate Growth Rate)` *(Note: Must apply a massive negative growth rate in FY25 to account for the LNG divestiture).* 5. `Consolidated Sales = Americas Revenue + Asia Revenue + Europe Revenue + ME&I Revenue + Corporate Revenue` 6. `Segment Operating Income = Segment Revenue * Segment Operating Margin` 7. `Adjusted EBITDA = Consolidated Operating Income + Depreciation & Amortisation + Equity Affiliates' Income` 8. `Adjusted EBITDA Margin = Adjusted EBITDA / Consolidated Sales` 9. `Total Capital Expenditures = Maintenance Capex + Megaproject Growth Capex` 10. `Free Cash Flow = Cash Provided by Operating Activities - Total Capital Expenditures` 11. `Debt Funding Requirement = IF((Free Cash Flow - Dividends Paid) < 0, ABS(Free Cash Flow - Dividends Paid), 0)` 12. `Interest Expense = Average Total Debt * Weighted Average Interest Rate` ## Cross-Sheet Dependencies * The **Revenue & Margin Build** feeds the top line of the **Income Statement**. * The **Megaproject & Capex Schedule** feeds Additions to PP&E on the **Depreciation & PP&E** sheet, which in turn feeds D&A on the **Income Statement** and **Cash Flow Statement**. * The **Income Statement** generates Net Income, which is the starting point for the **Cash Flow Statement**. * The **Cash Flow Statement** calculates the cash shortfall (OCF minus Capex minus Dividends), which dictates the required borrowing on the **Debt & Interest Schedule**. * The **Debt & Interest Schedule** calculates Interest Expense, which creates a circular reference by feeding back into the **Income Statement** (reducing Net Income and OCF, thereby increasing the borrowing requirement). ## Sign Convention * **Income Statement:** Revenues are positive. Expenses (COGS, SG&A, Interest) are positive numbers subtracted in subtotal formulas. * **Balance Sheet:** All assets, liabilities, and equity balances are positive. * **Cash Flow Statement:** Cash inflows are positive. Cash outflows (Capex, Dividends, Debt Repayment) are negative. * **Margin/Growth Rates:** Positive for growth/expansion, negative for contraction. ## Things Most Likely to Go Wrong * **Energy Pass-Through Distortion:** Analysts often mistake revenue growth driven by energy pass-throughs for fundamental growth. The model must isolate volume/price from pass-throughs, as pass-throughs generate zero incremental gross profit dollars and mathematically compress margin percentages. * **LNG Divestiture Stub Period:** The Corporate segment revenue will drop precipitously in FY2025 because the LNG business was sold in September 2024. Applying historical growth rates to the Corporate segment will wildly overstate future revenue. * **Equity Affiliate Income Placement:** Jazan JV income is reported below operating income but is a core part of the company's cash flow and is included in management's Adjusted EBITDA metric. The model must explicitly add this back to calculate true EBITDA. * **Asset Impairment Noise:** The $3.7 billion pre-tax charge in FY2025 will destroy GAAP earnings. The model must use Adjusted Operating Income and Adjusted EPS to evaluate ongoing business performance. * **Free Cash Flow Alarmism:** The model will show deeply negative Free Cash Flow for the next 3-4 years. This is by design (funding megaprojects). Do not attempt to "fix" the model to force positive FCF; the debt schedule must absorb the deficit. * **Maintenance vs. Growth Capex:** Failing to separate these will ruin the terminal value calculation in the DCF. Terminal year capex must step down to approximate maintenance levels plus normalised growth, not the $4B+ megaproject run-rate. * **Dividend Burden:** The company pays out over $1.6 billion annually in dividends. This must be modelled as a hard cash outflow before calculating discretionary cash available for debt paydown. * **Currency Translation:** With over 50% of revenue outside the US, a strong USD will artificially depress reported growth. The model should allow for constant-currency volume and price assumptions. ## Validation Checks * "Adjusted EBITDA margin must remain in the 40-43% range; flag if it drops below 40% or exceeds 45%." * "Total Capital Expenditures must equal approximately $4.0 billion in FY2026 based on management guidance." * "Debt/EBITDA ratio should remain below 3.5x to maintain the 'A' credit rating; flag if leverage breaches this threshold." * "Free Cash Flow (OCF - Capex) should be negative in the near term; flag if the model generates positive FCF before FY2028." * "Dividend payout ratio (Dividends / Adjusted Net Income) should be between 55-65%." * "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." * "Corporate segment revenue must decline by at least 30% in FY2025 to reflect the LNG divestiture." * "Effective tax rate should be in the 18-20% range." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Americas Volume Growth | 2.0 | % | Long-term industrial production growth trend | | Americas Price Growth | 1.5 | % | Contractual inflation escalators | | Asia Volume Growth | 5.0 | % | Higher structural growth in developing markets | | Europe Volume Growth | 1.0 | % | Sluggish Eurozone macroeconomic environment | | Corporate Segment Growth (FY25) | -40.0 | % | Reflects the September 2024 sale of the LNG business | | Consolidated Adjusted EBITDA Margin | 41.5 | % | In line with FY24 (41.7%) and Q1 FY25 (40.6%) actuals | | SG&A as % of Revenue | 8.5 | % | Historical average, highly stable | | FY2026 Capital Expenditures | 4,000 | $ Millions | Explicit management guidance for FY2026 | | Maintenance Capex | 600 | $ Millions | Historical run-rate for existing asset base | | Effective Tax Rate | 19.0 | % | Historical average adjusted tax rate | | Annual Dividend per Share | 7.16 | $ | Based on Q1 FY25 declared quarterly dividend of $1.79 | | Weighted Average Cost of Debt | 4.0 | % | Blended rate of existing senior notes and commercial paper | | WACC | 7.5 | % | Standard cost of capital for a stable, 'A' rated industrial | | Terminal Growth Rate | 2.5 | % | Aligns with long-term global GDP and inflation | ## Data Sources & Benchmarks * **Filings:** SEC EDGAR (10-K, 10-Q, 8-K) and the Air Products Investor Relations website (earnings presentations, megaproject updates). * **Key Peers:** Linde plc (LIN), Air Liquide S.A. (AI.PA). * **Industry Data:** Chemical Activity Barometer (CAB), global industrial production indices, and hydrogen market forecasts from the IEA or BloombergNEF. * **Consensus Estimates:** FactSet or Bloomberg for forward EPS and EBITDA margin validation. ## Sources * Air Products Investor Relations: Fiscal 2024 and Fiscal 2025 Earnings Releases (airproducts.com) * Air Products SEC Filings: FY2024 Form 10-K * S&P Global Ratings: Air Products and Chemicals Inc. 'A' Ratings Affirmation (spglobal.com) * PR Newswire: Air Products Reports Fiscal 2025 Full-Year and Fourth Quarter Results (prnewswire.com) --- ## Frequently asked questions ### What does Air Products (APD) do? Air Products and Chemicals, Inc. is a global leader in industrial gases, supplying atmospheric and process gases to various industries including refining, chemicals, and electronics. The company is also the world's largest supplier of hydrogen and is heavily involved in multi-billion-dollar clean hydrogen megaprojects to support the global energy transition. ### How does Air Products generate revenue? Air Products generates revenue through its highly asset-heavy business model, which relies on long-term take-or-pay contracts with energy cost pass-through provisions. This structure contributes to extremely stable cash flows across its Americas, Asia, and Europe segments. ### Why is Air Products' capital expenditure (Capex) so high? Air Products' capital expenditure is extraordinarily high, around 30-40% of revenue, primarily due to its current megaproject cycle. This includes significant investments in growth projects such as the NEOM green hydrogen project and other blue hydrogen initiatives. ### What is the purpose of the Air Products financial model? The Air Products financial model provides a comprehensive equity valuation and capital allocation analysis. It helps analysts evaluate whether the company's predictable industrial gas cash flows can successfully fund its massive clean energy transition megaprojects without jeopardising its dividend track record or 'A' credit rating. ### Can I download an Excel financial model for Air Products (APD)? Yes, an Excel financial model for Air Products (APD) is available for download. This model provides a forecast horizon from FY2026 through FY2030, enabling detailed analysis of the company's future performance. ### What is the assumed revenue growth rate in the Air Products financial model? The financial model for Air Products assumes a revenue growth rate of approximately 9.02%. This key assumption is used to project the company's top-line expansion over the forecast horizon. [Interactive forecast calculator](https://finamodel.com/companies/air-products/forecast)