# PPG Industries (PPG) Financial Model Free Excel 3-statement financial model and company analysis for PPG Industries. - Canonical: https://finamodel.com/companies/ppg-industries - Industry: Chemicals - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/PPG.xlsx ## Model Purpose This model evaluates the equity valuation and cash flow generation profile of PPG Industries, specifically assessing how recent structural cost reductions and the divestiture of its US and Canada architectural coatings business will impact future operating margins and capital allocation decisions. ## Company Overview PPG Industries is a global supplier of paints, coatings, and specialty materials for industrial, aerospace, automotive, and construction markets. The company operates a relatively asset-heavy manufacturing business model but generates strong, consistent cash flows due to its pricing power and entrenched customer relationships. The business is divided into three primary segments: Performance Coatings (approximately 60% of remaining revenue), Industrial Coatings (approximately 30% of remaining revenue), and Global Architectural Coatings (approximately 10% of remaining revenue following recent divestitures). PPG holds a top-two market position globally, competing fiercely with Sherwin-Williams, AkzoNobel, and Axalta. Recently, PPG completed a major portfolio optimisation, selling its US and Canada architectural coatings business to American Industrial Partners for $550 million in December 2024 and divesting its silicas products business, while simultaneously executing a European manufacturing consolidation programme to reduce structural costs. ## Revenue Deep Dive ### Performance Coatings - **Segment name:** Performance Coatings (includes aerospace, protective and marine, auto refinish, and traffic solutions). - **Revenue driver formula:** Prior Year Revenue x (1 + Volume Growth + Price/Mix + Foreign Currency Translation). - **Historical growth rate:** 3% to 5% organic growth. - **Key growth levers and headwinds:** Driven heavily by aerospace build rates, global travel recovery, and infrastructure spending. Auto refinish volumes depend on collision rates and miles driven. - **Pricing dynamics:** High pricing power due to the critical nature of the coatings and high cost of failure. - **Revenue recognition notes:** Recognised at the point in time when control transfers to the customer (typically upon shipment). - **Seasonality:** Traffic solutions peak in the second and third quarters due to warmer weather in the Northern Hemisphere. ### Industrial Coatings - **Segment name:** Industrial Coatings (includes automotive OEM, packaging, and general industrial). - **Revenue driver formula:** Prior Year Revenue x (1 + Volume Growth + Price/Mix + Foreign Currency Translation). - **Historical growth rate:** Flat to 2% organic growth. - **Key growth levers and headwinds:** Highly dependent on global automotive production rates and consumer packaging demand. - **Pricing dynamics:** Many contracts are index-based, meaning selling prices automatically adjust based on underlying raw material cost movements. - **Revenue recognition notes:** Point in time recognition upon delivery to OEM facilities. - **Seasonality:** Relatively stable, though automotive plant shutdowns in the third quarter can cause slight dips. ### Global Architectural Coatings - **Segment name:** Global Architectural Coatings (now excluding US and Canada). - **Revenue driver formula:** Prior Year Revenue x (1 + Volume Growth + Price/Mix + Foreign Currency Translation). - **Historical growth rate:** 2% to 4% organic growth. - **Key growth levers and headwinds:** Driven by residential repainting, commercial construction, and project-related sales in Mexico, Latin America, and Europe. - **Pricing dynamics:** Highly competitive retail and dealer pricing, sensitive to consumer discretionary spending. - **Revenue recognition notes:** Point in time at the retail register or upon delivery to dealer networks. - **Seasonality:** Strongest in the second and third quarters during peak painting season. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown:** Raw materials (titanium dioxide, epoxy resins, solvents), direct manufacturing labour, energy, and inbound freight. - **Gross margin range:** 40% to 42% (41.3% in 2025). - **Key input costs and commodity exposures:** Highly exposed to crude oil derivatives and titanium dioxide prices. - **How COGS scales with revenue:** Step-function scaling based on batch manufacturing efficiency and raw material index lags. ### Operating Expenses - **R&D:** Typically 3% of revenue, focused on sustainably advantaged products and lower-emission technologies. - **SG&A:** Typically 23% to 25% of revenue, covering global distribution networks, sales personnel, and corporate overhead. - **Depreciation & Amortisation:** Approximately 3% to 4% of revenue, reflecting the capital-intensive nature of global paint manufacturing. - **Restructuring / one-time charges:** Frequent in recent years. The company realised $75 million in structural cost savings in 2025 and expects an incremental $50 million in 2026 from European manufacturing consolidation. ### Margin Profile - **Gross margin:** 40% to 42%. - **EBITDA margin:** 18% to 20% (Segment EBITDA margin was 19% in 2025). - **Operating margin:** 13% to 15%. - **Net margin:** 9% to 11%. - **Margin trend:** Expanding slightly due to aggressive structural cost reductions and the divestiture of the lower-margin US and Canada architectural business. ## Balance Sheet Structure - **Total assets:** Approximately $22 billion. - **Key asset categories:** Property, plant and equipment (manufacturing facilities), inventory (raw materials and finished goods), and accounts receivable. - **Goodwill & intangibles as % of total assets:** Approximately 35% to 40%, reflecting a long history of bolt-on acquisitions. - **Working capital profile:** - **Days Sales Outstanding (DSO):** 61 to 65 days. - **Days Inventory Outstanding (DIO):** 75 to 82 days. - **Days Payable Outstanding (DPO):** 150 to 160 days. - **Net working capital as % of revenue:** Typically positive but tightly managed. The high DPO indicates strong negotiating power with raw material suppliers. - **PP&E:** Approximately $3.6 billion net, consisting of global blending and manufacturing facilities. - **Right-of-use assets / operating leases:** Material but manageable, primarily related to retail stores and distribution centres. ## Capital Expenditure & Investment - **Capex as % of revenue:** 2.0% to 3.0%. - **Maintenance capex vs. growth capex:** Approximately 60% maintenance and 40% growth (focused on automation and capacity expansion in aerospace and protective coatings). - **Major capex programmes underway or planned:** Investments in sustainably advantaged product manufacturing and European facility consolidation. - **Capitalised software / development costs:** Minimal relative to physical plant investments. - **M&A pattern:** Historically a serial bolt-on acquirer, but recently shifted to portfolio optimisation and divestitures to improve return on capital. ## Debt & Capital Structure - **Total debt:** Approximately $6.5 billion (Net debt of $5.1 billion at the end of 2025). - **Debt/EBITDA ratio:** Approximately 2.0x to 2.5x. - **Credit rating:** Investment grade (typically A- tier). - **Key debt instruments:** Senior unsecured notes, commercial paper, and a revolving credit facility. Includes a €600 million maturity due in early 2026. - **Interest rate profile:** Predominantly fixed-rate bonds with a weighted average cost of debt around 3.5% to 4.5%. - **Share repurchase programme:** Highly active. The company repurchased $790 million of stock in 2025. - **Dividend policy:** Consistent dividend payer with a yield around 1.5% to 2.0%. Total dividends paid in 2025 were approximately $630 million. ## Cash Flow Characteristics - **Operating cash flow conversion:** Very strong. OCF was $1.9 billion in 2025, representing over 1.1x net income. - **Free cash flow margin:** 9% to 11% of revenue. - **Major non-cash items:** Depreciation, amortisation, and restructuring impairment charges. - **Working capital cash flow impact:** Often a use of cash during periods of high raw material inflation, but neutralises over the cycle. - **Capex intensity:** Low relative to cash generation, allowing for significant shareholder returns. - **Cash tax rate vs. GAAP effective tax rate:** Closely aligned, typically in the 21% to 23% range. ## Sheet Structure 1. **Assumptions:** Hardcoded inputs for macroeconomic drivers, segment growth rates, margin profiles, and capital allocation targets. 2. **Revenue & Segment Build:** Detailed build for Performance Coatings, Industrial Coatings, and Global Architectural Coatings, explicitly excluding the divested US and Canada business from the 2026 forecast onwards. 3. **Income Statement:** Consolidated view from Net Sales down to Net Income and EPS, including restructuring lines. 4. **Balance Sheet:** Standard presentation mirroring the 10-K, balancing Total Assets with Total Liabilities and Shareholders' Equity. 5. **Cash Flow Statement:** Indirect method starting from Net Income, adjusting for D&A, working capital changes, capex, debt issuance, dividends, and share repurchases. 6. **Working Capital Schedule:** Calculation of AR, Inventory, and AP based on DSO, DIO, and DPO assumptions. 7. **Debt & Interest Schedule:** Tranches of existing notes, commercial paper, and the revolving credit facility, calculating interest expense based on average balances. 8. **PP&E & Intangibles Schedule:** Roll-forward of gross PP&E, accumulated depreciation, goodwill, and amortisation. 9. **DCF Valuation:** Unlevered free cash flow calculation, WACC derivation, terminal value calculation, and implied share price. ## Key Financial Relationships 1. Segment Revenue = Prior Year Segment Revenue * (1 + Volume Growth % + Price/Mix % + FX Impact %) 2. Consolidated Net Sales = Performance Coatings Revenue + Industrial Coatings Revenue + Global Architectural Coatings Revenue 3. Segment EBITDA = Segment Revenue * Segment EBITDA Margin % 4. Consolidated COGS = Consolidated Net Sales * (1 - Gross Margin %) 5. Accounts Receivable = (Consolidated Net Sales / 365) * DSO 6. Inventory = (Consolidated COGS / 365) * DIO 7. Accounts Payable = (Consolidated COGS / 365) * DPO 8. Depreciation Expense = Beginning Net PP&E * Depreciation Rate % 9. Interest Expense = Average Total Debt * Weighted Average Interest Rate % 10. Share Count = Prior Year Share Count - (Share Repurchase Amount / Average Share Price) 11. Dividends Paid = Share Count * Dividend Per Share 12. Unlevered Free Cash Flow = EBIT * (1 - Effective Tax Rate) + D&A - Capital Expenditures - Change in Net Working Capital ## Cross-Sheet Dependencies The **Assumptions** sheet drives the **Revenue & Segment Build** and the **Working Capital Schedule**. The **Revenue & Segment Build** 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** calculates the period-over-period changes that feed the operating section of the **Cash Flow Statement**. The **Debt & Interest Schedule** creates a circular reference: debt balances determine interest expense on the **Income Statement**, which impacts Net Income and cash generation on the **Cash Flow Statement**, which in turn dictates the need for revolver borrowing or debt paydown on the **Debt & Interest Schedule**. ## Sign Convention - Revenue, assets, and equity balances are entered as positive numbers. - Expenses (COGS, SG&A, Interest) are entered as positive numbers and subtracted in formulas. - Liability balances (Debt, Accounts Payable) are entered as positive numbers. - On the Cash Flow Statement, cash inflows are positive and cash outflows (capex, dividends, share repurchases) are negative. ## Things Most Likely to Go Wrong - Failing to adjust the historical 2024 and 2025 base year revenue to exclude the $2 billion US and Canada architectural coatings business will result in vastly overstated future revenue projections. - Index-based pricing in the Industrial Coatings segment can cause revenue to decline even when volumes are growing if raw material costs fall; the model must separate volume and price/mix drivers. - Foreign currency translation is a major swing factor for PPG; the model should ideally include a constant-currency toggle for organic growth analysis. - The European manufacturing consolidation will trigger upfront cash restructuring costs that depress near-term cash flow but improve long-term gross margins. - DPO is unusually high (over 150 days); normalising this to industry averages by mistake will cause a massive artificial cash outflow in the working capital schedule. - Share repurchases are a core part of the EPS growth algorithm; failing to model the declining share count will understate future EPS. - The silicas products business divestiture also removes historical revenue and earnings; the base year must be pro-forma adjusted for this as well. - Environmental and asbestos-related legacy liabilities exist on the balance sheet; assuming these remain static rather than modelling the annual cash payout will overstate free cash flow. ## Validation Checks - Gross margin must remain between 40.0% and 42.5%; flag if it falls outside this band. - Segment EBITDA margin should consolidate to approximately 18% to 20%. - Operating Cash Flow must exceed Net Income (OCF / Net Income > 1.1x). - Total Assets must equal Total Liabilities plus Shareholders' Equity in all forecast periods. - Capex as a percentage of revenue should not exceed 3.5% without a specific growth initiative flag. - Debt to EBITDA should remain below 3.0x to maintain the company's investment-grade rating profile. - The effective tax rate should remain between 21% and 23%. - The calculated Days Payable Outstanding (DPO) must remain above 140 days based on historical supplier terms. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Performance Coatings Volume Growth | 2.0 | % | Reflects strong aerospace demand offsetting softer auto refinish | | Industrial Coatings Volume Growth | 1.0 | % | Conservative estimate based on flat global auto OEM production | | Global Architectural Volume Growth | 2.0 | % | Reflects growth in Mexico and Latin America, offset by weak Europe | | Price/Mix Growth (Consolidated) | 1.0 | % | Normalised pricing power following peak inflation years | | Gross Margin | 41.3 | % | Actual reported figure for full-year 2025 | | SG&A as % of Revenue | 23.5 | % | Historical average adjusted for recent cost-saving initiatives | | Performance Coatings EBITDA Margin | 18.5 | % | Based on recent segment reporting | | Industrial Coatings EBITDA Margin | 12.5 | % | Based on recent segment reporting | | Global Architectural EBITDA Margin | 14.5 | % | Based on recent segment reporting (ex-US/Canada) | | Days Sales Outstanding (DSO) | 65 | Days | Based on 2025 actuals | | Days Inventory Outstanding (DIO) | 80 | Days | Based on 2025 actuals | | Days Payable Outstanding (DPO) | 155 | Days | Based on 2025 actuals | | Capex as % of Revenue | 2.5 | % | Management guidance for maintenance and targeted growth | | Effective Tax Rate | 22.0 | % | Historical average cash tax rate | | Annual Share Repurchases | 790 | $ Millions | Matches 2025 actual capital return execution | | Dividend Per Share Growth | 4.0 | % | Consistent with historical dividend aristocrat policy | | Cost of Debt | 4.5 | % | Weighted average interest rate on existing debt stack | | WACC | 8.5 | % | Standard discount rate for specialty chemicals sector | | Terminal Growth Rate | 2.0 | % | Aligned with long-term global GDP growth | ## Data Sources & Benchmarks - **Filings:** SEC EDGAR (PPG 10-K, 10-Q, 8-K), PPG Investor Relations website for quarterly earnings presentations and pro-forma divestiture reconciliations. - **Peers:** Sherwin-Williams (SHW), AkzoNobel (AKZA), Axalta Coating Systems (AXTA), RPM International (RPM). - **Industry Data:** Global automotive build rates (IHS Markit), commercial aerospace delivery schedules (Boeing/Airbus), and regional construction starts. - **Consensus Estimates:** FactSet or Bloomberg for forward EPS and revenue estimates to validate model outputs. ## Sources - PPG Industries Q4 and Full-Year 2025 Earnings Release (January 2026) - PPG Industries 2025 Annual Report and Form 10-K - PPG Press Release: Completion of Architectural Coatings US and Canada Sale (December 2024) - Macrotrends: PPG Industries Historical Revenue and EBITDA Data - Finbox and GuruFocus: PPG Industries Working Capital Metrics (DSO, DIO, DPO) - AlphaQuery: PPG Industries Gross Margin Data --- ## Frequently asked questions ### What does PPG Industries do and what are its main business segments? PPG Industries is a global supplier of paints, coatings, and specialty materials for various markets. Its primary business segments include Performance Coatings, Industrial Coatings, and Global Architectural Coatings. ### How does PPG Industries generate revenue, and what are its key market positions? PPG Industries generates revenue by supplying paints, coatings, and specialty materials to industrial, aerospace, automotive, and construction markets. The company holds a top-two market position globally, leveraging its pricing power and entrenched customer relationships. ### What is the assumed revenue growth rate in the PPG Industries financial model? The financial model for PPG Industries assumes a revenue growth rate of approximately 1.76%. This assumption is a key input for forecasting the company's future financial performance and cash flow generation. ### What is the expected capital expenditure as a percentage of revenue for PPG Industries? The financial model projects capital expenditure to be approximately 2.68% of revenue for PPG Industries. This includes investments aimed at sustainably advantaged product manufacturing and the ongoing European facility consolidation program. ### How do recent strategic actions impact PPG Industries' future operating margins and capital allocation? Recent structural cost reductions and the divestiture of its US and Canada architectural coatings business are expected to significantly impact PPG Industries' future operating margins and capital allocation decisions. The financial model specifically assesses these changes to evaluate the company's equity valuation and cash flow generation profile. ### Can I download an Excel financial model for PPG Industries, and what is its forecast horizon? Yes, an Excel financial model for PPG Industries is available for download. This model provides a comprehensive forecast horizon spanning from fiscal year 2026 through fiscal year 2030. [Interactive forecast calculator](https://finamodel.com/companies/ppg-industries/forecast)