# Dow (DOW) Financial Model Free Excel 3-statement financial model and company analysis for Dow. - Canonical: https://finamodel.com/companies/dow - Industry: Chemicals - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/DOW.xlsx ## Model Purpose This model provides a full three-statement forecast and discounted cash flow valuation to help an equity analyst determine the intrinsic value of Dow Inc. across various macroeconomic and commodity cycle scenarios. ## Company Overview Dow Inc. is a global materials science company that produces plastics, chemicals, and agricultural products for packaging, infrastructure, mobility, and consumer applications. The company operates massive, integrated manufacturing sites globally to convert hydrocarbon feedstocks into value-added chemical products. Business segments based on 2024 and 2025 reporting include: * Packaging & Specialty Plastics (approximately 51% of revenue) * Industrial Intermediates & Infrastructure (approximately 28% of revenue) * Performance Materials & Coatings (approximately 20% of revenue) * Corporate (approximately 1% of revenue) Key geographies include the U.S. & Canada (38%), Europe, Middle East, Africa and India (32%), Asia Pacific (18%), and Latin America (11%). The business model is highly asset-heavy and cyclical, relying on large-scale chemical crackers and polymerisation plants. Dow holds top-tier market share in polyethylene, polyurethanes, and silicones, competing with giants like BASF, LyondellBasell, and ExxonMobil Chemical. Recent major events include the 2024 divestiture of its flexible packaging laminating adhesives business to Arkema, the idling of a European cracker in 2025, a 50% dividend reduction in mid-2025, and a $690 million impairment charge in 2025 for Polyurethanes & Construction assets. ## Revenue Deep Dive ### Packaging & Specialty Plastics (P&SP) * **Segment name**: Packaging & Specialty Plastics * **Revenue driver formula**: Polyethylene Volume x Polyethylene Price + Olefins Volume x Olefins Price * **Historical growth rate**: Highly cyclical, ranging from -10% to +20% depending on global polymer pricing. * **Key growth levers and headwinds**: Driven by consumer packaging demand and global GDP. Headwinds include overcapacity in global polyethylene (especially from China) and lower downstream polymer prices. * **Pricing dynamics**: Spot and contract pricing heavily linked to crude oil and natural gas feedstock costs. * **Revenue recognition notes**: Recognised at the point in time when control transfers to the customer (typically upon shipment). * **Seasonality**: Generally stronger in the second and third quarters due to construction and agricultural film demand. ### Industrial Intermediates & Infrastructure (II&I) * **Segment name**: Industrial Intermediates & Infrastructure * **Revenue driver formula**: Polyurethanes Volume x Price + Construction Chemicals Volume x Price * **Historical growth rate**: -5% to +15% range, tracking industrial production and housing starts. * **Key growth levers and headwinds**: Tied to global construction, automotive manufacturing, and appliance production. Headwinds include high interest rates depressing housing starts. * **Pricing dynamics**: Competitive pricing influenced by global supply and demand balances for propylene oxide and polyurethanes. * **Revenue recognition notes**: Standard point-in-time recognition upon delivery. * **Seasonality**: Weaker in the first and fourth quarters due to winter weather slowing global construction activity. ### Performance Materials & Coatings (PM&C) * **Segment name**: Performance Materials & Coatings * **Revenue driver formula**: Siloxanes Volume x Price + Coatings Volume x Price * **Historical growth rate**: -5% to +10% range. * **Key growth levers and headwinds**: Driven by architectural coatings, personal care, and electronics. Headwinds include upstream siloxane oversupply. * **Pricing dynamics**: More specialised than the other segments, allowing for slightly better pricing power, though basic siloxanes remain commoditised. * **Revenue recognition notes**: Standard point-in-time recognition. * **Seasonality**: Strongest in the second and third quarters aligned with the Northern Hemisphere painting and construction season. ## Cost Structure ### Variable Costs / COGS * COGS consists primarily of raw material feedstocks (natural gas, natural gas liquids, crude oil derivatives) and energy costs (electricity, steam). * Gross margin range: 10% to 22% over the last 5 years, highly dependent on the spread between polymer prices and hydrocarbon feedstock costs. * Key input costs: Ethane, propane, butane, and naphtha. * COGS scales directly with volume but exhibits significant operating leverage due to the high fixed costs of running chemical crackers continuously. ### Operating Expenses * **R&D**: Typically 1.5% to 2.0% of revenue, expensed as incurred, covering catalyst development, polymer science, and sustainability initiatives. * **SG&A**: Typically 3.5% to 4.5% of revenue, driven by corporate headcount, IT, and global sales networks. * **Depreciation & Amortisation**: Significant, typically 6% to 8% of revenue, reflecting the massive tangible asset base of chemical plants. * **Stock-Based Compensation**: Relatively small for a traditional industrial company, typically under 0.5% of revenue. * **Restructuring / one-time charges**: Frequent during cyclical downturns. Dow recorded a $690 million impairment in 2025 and is executing a $1 billion cost-saving programme. ### Margin Profile * Gross margin: 10% to 22%. * Operating EBIT margin: 1% (trough in 2025) to 15% (peak). * Net margin: -6% (2025 loss) to 10%. * Margin trend: Currently compressing due to a cyclical trough, weak European demand, and new global capacity additions. ## Balance Sheet Structure * Total assets: Approximately $55 billion to $60 billion. * Key asset categories: Property, Plant and Equipment (PP&E) is the largest category, representing the global manufacturing footprint. * Goodwill & intangibles: Approximately 15% to 20% of total assets, stemming from historical acquisitions and the DowDuPont spin-off. * Working capital profile: * Days Sales Outstanding (DSO): 40 to 45 days. * Days Inventory Outstanding (DIO): 55 to 65 days. * Days Payable Outstanding (DPO): 50 to 60 days. * Net working capital as % of revenue: Typically 8% to 12%. * Working capital is positive and acts as a significant use of cash during periods of rising commodity prices. * PP&E: Consists of crackers, polymerisation units, and land. Useful lives range from 15 to 40 years for major processing equipment. * Right-of-use assets: Material, typically $2 billion to $3 billion, related to railcars, storage tanks, and real estate. ## Capital Expenditure & Investment * Capex as % of revenue: Typically 5% to 7%. * Maintenance capex vs. growth capex: Approximately 60% maintenance and turnaround, 40% growth and sustainability. * Major capex programmes: The Path2Zero project in Alberta, Canada (delayed in 2025 to preserve cash) and new polyethylene capacity on the U.S. Gulf Coast. * Capitalised software: Minimal relative to total capex. * M&A pattern: Primarily organic growth with occasional bolt-on acquisitions or joint venture formations. Divestitures of non-core assets are common (e.g., flexible packaging adhesives in 2024). ## Debt & Capital Structure * Total debt: Approximately $14 billion to $16 billion. * Debt/EBITDA ratio: Highly variable due to EBITDA cyclicality. Target is generally 2.0x to 2.5x across the cycle, but spikes during troughs. * Credit rating: BBB (Fitch downgraded from BBB+ in July 2025). * Key debt instruments: Senior unsecured notes and a syndicated revolving credit facility. * Maturity profile: Well-laddered with average maturities exceeding 10 years. * Interest rate profile: Predominantly fixed-rate bonds. * Share repurchase programme: Active during upcycles ($0.5 billion in 2024) but paused or reduced during downturns. * Dividend policy: Dow reduced its dividend by 50% in mid-2025 to preserve cash during the cyclical trough. ## Cash Flow Characteristics * Operating cash flow conversion: Highly variable. OCF was $1.1 billion in 2025 and $2.9 billion in 2024. * Free cash flow margin: Ranges from negative during heavy investment/trough periods to 8% during peaks. * Major non-cash items: D&A is the largest add-back. Equity earnings from joint ventures (Kuwait, Thailand, Saudi Arabia) must be deducted, while dividends received from these JVs are added back. * Working capital cash flow impact: Significant swings. Rising oil prices inflate inventory and receivables, consuming cash. * Capex intensity: High. Dow reduced 2025 capex by $1 billion to a target of $2.5 billion to protect the balance sheet. * Cash tax rate: Generally tracks the statutory rate but can be volatile during years with massive impairment charges. ## Sheet Structure 1. **Assumptions**: Macro drivers, segment volume and price growth rates, margin targets, working capital days, capex, and tax rates. 2. **Income Statement**: Revenue built by the three main segments plus Corporate, COGS, SG&A, R&D, Equity Earnings, Interest, and Taxes. 3. **Revenue Build**: Detailed volume and price assumptions for P&SP, II&I, and PM&C. 4. **Balance Sheet**: Cash, Receivables, Inventory, PP&E, Intangibles, Payables, Debt, and Equity. 5. **Cash Flow Statement**: Net Income, D&A, Working Capital changes, Capex, Dividends, and Debt issuance/repayment. 6. **Working Capital Schedule**: DSO, DIO, DPO calculations driving the balance sheet lines. 7. **Debt & Interest Schedule**: Tranches of debt, interest expense calculation, and debt paydown logic. 8. **PP&E & Depreciation Schedule**: Capex additions, retirements, and depreciation waterfall. 9. **DCF Valuation**: Unlevered free cash flow calculation, WACC, terminal value, and implied share price. ## Key Financial Relationships 1. P&SP Revenue = Prior Year P&SP Revenue x (1 + P&SP Volume Growth) x (1 + P&SP Price Growth) 2. II&I Revenue = Prior Year II&I Revenue x (1 + II&I Volume Growth) x (1 + II&I Price Growth) 3. PM&C Revenue = Prior Year PM&C Revenue x (1 + PM&C Volume Growth) x (1 + PM&C Price Growth) 4. Total Net Sales = P&SP Revenue + II&I Revenue + PM&C Revenue + Corporate Revenue 5. COGS = Total Net Sales x (1 - Gross Margin %) 6. R&D Expense = Total Net Sales x R&D % 7. SG&A Expense = Total Net Sales x SG&A % 8. Operating EBIT = Total Net Sales - COGS - R&D Expense - SG&A Expense + Equity Earnings from JVs 9. Accounts Receivable = (Total Net Sales / 365) x DSO 10. Inventory = (COGS / 365) x DIO 11. Accounts Payable = (COGS / 365) x DPO 12. Depreciation Expense = Beginning PP&E x Blended Depreciation Rate 13. Interest Expense = Average Debt Balance x Weighted Average Interest Rate 14. Free Cash Flow = Cash from Operations - Capital Expenditures ## Cross-Sheet Dependencies * The **Revenue Build** sheet feeds the top line of the **Income Statement**. * The **Income Statement** generates Net Income, which flows to the top of the **Cash Flow Statement** and into Retained Earnings on the **Balance Sheet**. * The **Working Capital Schedule** uses Revenue and COGS from the **Income Statement** to calculate balance sheet accounts, and the year-over-year changes flow to the **Cash Flow Statement**. * The **PP&E & Depreciation Schedule** feeds D&A to the **Income Statement** and **Cash Flow Statement**, and ending PP&E to the **Balance Sheet**. * The **Debt & Interest Schedule** uses cash shortfalls/surpluses from the **Cash Flow Statement** to determine revolver borrowing, which feeds ending debt on the **Balance Sheet** and interest expense on the **Income Statement**. This creates a circular reference that must be managed with a circuit breaker switch. ## Sign Convention * Revenue and Assets are positive. * Expenses (COGS, SG&A, R&D, Interest, Taxes) are entered as positive numbers in their schedules but subtracted in profitability totals. * On the Cash Flow Statement, cash inflows are positive, and cash outflows (e.g., Capex, Dividends, Debt Repayment) are negative. * Working capital changes on the Cash Flow Statement: an increase in an asset is negative, an increase in a liability is positive. ## Things Most Likely to Go Wrong * **Equity Earnings Disconnect**: Dow has massive joint ventures (e.g., Sadara in Saudi Arabia, Equate in Kuwait). The model must correctly account for Equity Earnings in Operating EBIT, but remember these are non-cash until dividends are received. * **Cyclical Margin Extrapolation**: Assuming peak margins (15%+) will persist forever will massively overvalue the company. The model must reflect mid-cycle average margins in the terminal year. * **Working Capital Cash Drain**: In a recovery scenario where prices spike, inventory and receivables will consume billions in cash. Failing to model DSO/DIO accurately will overstate free cash flow during a recovery. * **Restructuring Add-backs**: Dow frequently reports "Operating EBIT" that excludes restructuring and impairments (like the $690M in 2025). The model must bridge GAAP Net Income to Operating EBIT clearly. * **Dividend Assumptions**: The model must reflect the 50% dividend cut implemented in 2025; using historical 2023/2024 dividend per share figures will drain too much cash. * **Capex Timing**: The $1 billion reduction in 2025 capex is a delay, not a permanent saving. The model must show capex ramping back up in 2026/2027 to fund the delayed Alberta project. * **Feedstock Spread Complexity**: Revenue and COGS often move together because product pricing is tied to feedstock costs. A revenue increase driven by price (not volume) usually means COGS is also rising. * **Constant Currency**: Foreign exchange swings can impact revenue by 2-4% annually. The model should ideally forecast on a constant currency basis. ## Validation Checks * "Total Assets must equal Total Liabilities plus Equity in every period." * "Operating EBIT margin should cycle between 1% (trough) and 15% (peak); flag if it exceeds 15%." * "Capex as a % of revenue should remain between 5% and 8%; flag if it drops below 5% for multiple years." * "DSO should remain between 40 and 50 days based on historical chemical industry standards." * "Free Cash Flow must cover the newly rebased dividend; flag if the payout ratio exceeds 100% of FCF." * "Debt/EBITDA will spike in 2025 due to trough EBITDA, but should normalise below 3.0x by 2027." * "Effective tax rate should remain between 22% and 26% excluding one-time impairment impacts." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | P&SP Volume Growth | 2.0 | % | Modest recovery following 2025 volume declines. | | P&SP Price Growth | 3.0 | % | Rebound from trough downstream polymer pricing. | | II&I Volume Growth | 1.5 | % | Slow recovery in global construction and housing starts. | | II&I Price Growth | 2.0 | % | Normalisation of polyurethane pricing. | | PM&C Volume Growth | 2.0 | % | Steady demand in consumer solutions and coatings. | | PM&C Price Growth | 1.5 | % | Stabilisation of upstream siloxane prices. | | Gross Margin | 14.0 | % | Mid-cycle assumption, recovering from 2025 trough. | | SG&A as % of Revenue | 4.0 | % | Historical average, supported by $1B cost-saving programme. | | R&D as % of Revenue | 1.8 | % | Historical average required to maintain innovation pipeline. | | DSO | 42 | Days | Historical average for Dow's receivables collection. | | DIO | 60 | Days | Historical average for chemical inventory processing. | | DPO | 55 | Days | Historical average for feedstock payables. | | Capex as % of Revenue | 6.5 | % | Rebound from 2025 cuts to fund the delayed Alberta project. | | Effective Tax Rate | 24.0 | % | Standard global blended rate for the company. | | Weighted Average Interest Rate | 4.5 | % | Based on current fixed-rate bond portfolio. | | Dividend per Share | 1.40 | $ | Reflects the 50% cut implemented in mid-2025 (down from $2.80). | | WACC | 8.5 | % | Standard discount rate for a cyclical, BBB-rated chemical company. | | Terminal Growth Rate | 2.0 | % | Aligned with long-term global GDP growth. | ## Data Sources & Benchmarks * **Filings**: SEC EDGAR for Dow Inc. (Ticker: DOW) 10-K and 10-Q filings. Investor relations website (investors.dow.com) for earnings presentations and the "Transform to Outperform" strategic updates. * **Peers**: LyondellBasell (LYB), Westlake Corporation (WLK), Eastman Chemical (EMN), and Huntsman (HUN). * **Industry Data**: ICIS and S&P Global Platts for real-time polyethylene, polyurethane, and siloxane pricing and margin curves. * **Consensus Estimates**: Bloomberg or FactSet for forward-looking volume and margin consensus. ## Sources * Dow Inc. Q4 2025 Earnings Release and Financial Highlights * Dow Inc. 2025 Annual Report on Form 10-K * Dow Inc. 2024 Annual Report on Form 10-K * Dow Inc. Q3 2025 Earnings Release * SEC Filings and Investor Relations Disclosures --- ## Frequently asked questions ### What kind of products does Dow Inc. produce? Dow Inc. is a global materials science company that produces plastics, chemicals, and agricultural products. These products are used in various applications such as packaging, infrastructure, mobility, and consumer goods. ### How does Dow Inc. generate its revenue across different segments? Dow Inc. generates revenue primarily through its Packaging & Specialty Plastics (approximately 51%), Industrial Intermediates & Infrastructure (approximately 28%), and Performance Materials & Coatings (approximately 20%) segments. The company's business model is highly asset-heavy and cyclical, relying on large-scale chemical production. ### What is Dow Inc.'s typical capital expenditure as a percentage of revenue? Dow Inc. typically invests 5% to 7% of its revenue in capital expenditures. Approximately 60% of this capex is for maintenance and turnarounds, while 40% is allocated to growth and sustainability initiatives. ### What are some key financial assumptions used in the Dow Inc. financial model? The financial model for Dow Inc. assumes a revenue growth rate of approximately 0.96% and COGS as a percentage of revenue around 85.25%. Other key assumptions include SGA at 3.42% and D&A at 6.03% of revenue. ### What is the purpose of the financial model for Dow Inc.? The financial model provides a full three-statement forecast and discounted cash flow (DCF) valuation for Dow Inc. Its purpose is to help an equity analyst determine the intrinsic value of the company across various macroeconomic and commodity cycle scenarios. ### Is an Excel financial model available for Dow Inc. and what is its forecast horizon? Yes, a downloadable Excel financial model is available for Dow Inc. This model provides a forecast horizon covering fiscal years 2026 through 2030. [Interactive forecast calculator](https://finamodel.com/companies/dow/forecast)