PPG Industries logo
PPG Industries Financial Model

Chemicals Company Financials Example (Free Excel Download)

PPG Industries is a global supplier of paints, coatings, and specialty materials for industrial, aerospace, automotive, and construction markets.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

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.

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.

The downloadable PPG Industries 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 & AssumptionsPPG Industries financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$16.80B$15.61B$16.24B$15.85B$15.88B
Gross profit$6.52B$5.64B$6.56B$6.59B$6.56B
Cost of sales, exclusive of depreciation and amortization$10.29B$11.10B$10.74B$9.25B$9.32B
Net income$1.44B$1.03B$1.27B$1.12B$1.58B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
1.8%
COGS % of revenue
59.6%
R&D % of revenue
2.9%
SG&A % of revenue
22.2%
D&A % of revenue
3.4%
Effective tax rate
22.9%
See 8 more
Capex % of revenue
2.7%
Net working capital % of revenue
9.5%
Other assets % of revenue
94.6%
Other liabilities % of revenue
41.0%
Annual debt paydown
5.0%
Interest rate on debt
2.1%
Dividend payout ratio
44.9%
Buybacks % of net income
13.2%

How to build a detailed financial model for PPG Industries

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

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)

AssumptionDefault ValueUnitRationale
Performance Coatings Volume Growth2.0%Reflects strong aerospace demand offsetting softer auto refinish
Industrial Coatings Volume Growth1.0%Conservative estimate based on flat global auto OEM production
Global Architectural Volume Growth2.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 Margin41.3%Actual reported figure for full-year 2025
SG&A as % of Revenue23.5%Historical average adjusted for recent cost-saving initiatives
Performance Coatings EBITDA Margin18.5%Based on recent segment reporting
Industrial Coatings EBITDA Margin12.5%Based on recent segment reporting
Global Architectural EBITDA Margin14.5%Based on recent segment reporting (ex-US/Canada)
Days Sales Outstanding (DSO)65DaysBased on 2025 actuals
Days Inventory Outstanding (DIO)80DaysBased on 2025 actuals
Days Payable Outstanding (DPO)155DaysBased on 2025 actuals
Capex as % of Revenue2.5%Management guidance for maintenance and targeted growth
Effective Tax Rate22.0%Historical average cash tax rate
Annual Share Repurchases790$ MillionsMatches 2025 actual capital return execution
Dividend Per Share Growth4.0%Consistent with historical dividend aristocrat policy
Cost of Debt4.5%Weighted average interest rate on existing debt stack
WACC8.5%Standard discount rate for specialty chemicals sector
Terminal Growth Rate2.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

Frequently asked

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.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

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.

ALB.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Albemarle logo

Albemarle

Albemarle Corporation is a global specialty chemicals company and one of the world's largest producers of lithium and bromine.

APD.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Air Products logo

Air Products

Air Products and Chemicals, Inc.

CF.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
CF Industries logo

CF Industries

CF Industries Holdings, Inc.

CTVA.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Corteva logo

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.

DD.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
DuPont logo

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.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Dow logo

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.

ECL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Ecolab logo

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.

IFF.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
International Flavors & Fragrances logo

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.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview