Procter & Gamble Financial Model
Consumer Goods Company Financials Example (Free Excel Download)
Procter & Gamble is a global consumer packaged goods (CPG) corporation that provides branded consumer packaged goods to consumers across the world, focusing on daily-use products where performance drives brand choice.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive 3-statement forecast and DCF valuation for The Procter & Gamble Company (PG), enabling an equity research analyst to evaluate the impact of pricing power, volume recovery, commodity/tariff headwinds, and productivity savings on core EPS and free cash flow generation.
- What the company does: Procter & Gamble is a global consumer packaged goods (CPG) corporation that provides branded consumer packaged goods to consumers across the world, focusing on daily-use products where performance drives brand choice.
- Business segments:
- Fabric & Home Care (~36% of net sales)
- Baby, Feminine & Family Care (~24% of net sales)
- Beauty (~18% of net sales)
- Health Care (~14% of net sales)
- Grooming (~8% of net sales)
- Key geographies: North America (~50% of sales), Europe (~21%), Greater China (~9%), Latin America (~6%), Asia Pacific/Middle East/Africa (remainder).
- Business model type: Asset-heavy manufacturing combined with highly intangible brand equity and massive marketing scale.
- Competitive position: Global market leader in multiple categories (e.g., blades and razors, baby diapers, laundry detergent). Key competitors include Unilever, Kimberly-Clark, Colgate-Palmolive, and L'Oréal.
- Recent major events: Substantial liquidation of operations in Argentina and Nigeria driving restructuring charges in FY2024/FY2025; a $1.3 billion non-cash impairment charge on the Gillette intangible asset in FY2024; separation of the Beauty segment into distinct Skin Care and Personal Care operating segments effective July 1, 2024.
The downloadable Procter & Gamble 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 & AssumptionsProcter & Gamble financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
|---|---|---|---|---|---|
| Revenue | $80.19B | $82.01B | $84.04B | $84.28B | $87.03B |
| Gross profit | $38.03B | $39.25B | $43.19B | $43.12B | $43.67B |
| Operating income | $17.81B | $18.13B | $18.55B | $20.45B | $19.75B |
| Net income | $14.74B | $14.65B | $14.88B | $15.97B | $16.05B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Procter & Gamble
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
For EACH revenue segment (Fabric & Home Care; Baby, Feminine & Family Care; Beauty; Health Care; Grooming):
- Segment name: As reported in the 10-K (e.g., "Fabric & Home Care").
- Revenue driver formula: `Prior Year Segment Sales x (1 + Volume Growth + Price/Mix Impact + FX Impact + M&A Impact)`.
- Historical growth rate: 2-5% organic sales growth historically, heavily reliant on pricing in recent years with flat to slightly negative volume.
- Key growth levers and headwinds: Premiumisation (trading up to higher-margin products like Tide PODS), demographic shifts (lower birth rates impacting Baby Care), and macroeconomic volatility in Greater China. Headwinds include strong US Dollar (FX translation) and private label competition.
- Pricing dynamics: Highly competitive but PG exercises significant pricing power due to brand superiority. Pricing is often taken to offset commodity and foreign exchange impacts.
- Revenue recognition notes: Recognised at a point in time when control transfers to the customer (typically upon shipment or delivery). Trade promotions, slotting fees, and coupons are recorded as a reduction of sales.
- Seasonality: Relatively stable throughout the year, though Health Care (Vicks) sees a slight uptick during the winter cold and flu season.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Raw materials (resins, chemicals, pulp), packaging materials, manufacturing labour, factory overhead, and inbound/outbound freight.
- Gross margin range: 47.0% - 51.5% (FY25 reported gross margin ~50-51%).
- Key input costs and commodity exposures: Wood pulp (tissue/towel/diapers), petroleum-derived materials (resins for packaging, surfactants for detergents).
- How COGS scales with revenue: Generally linear with volume, but gross margin fluctuates based on the lag between commodity cost inflation and retail price increases.
Operating Expenses
- R&D: ~2.5% of net sales. Expensed as incurred. Covers product innovation and packaging sustainability.
- SG&A: ~25-27% of net sales. Heavily weighted towards marketing and advertising (historically ~10-11% of total sales), plus overhead, selling, and administrative costs.
- Depreciation & Amortisation: ~3-4% of net sales, split across COGS (manufacturing equipment) and SG&A.
- Stock-Based Compensation: ~0.5% of net sales; relatively small compared to tech, but material for core EPS adjustments.
- Restructuring / one-time charges: Frequent. PG regularly executes productivity and restructuring programmes (e.g., market exits in Argentina/Nigeria), typically running $300M - $800M annually.
Margin Profile
- Gross margin: 48% - 51% (expanding recently due to pricing and productivity savings).
- EBITDA margin: 26% - 28%.
- Operating margin: 21% - 24.5% (FY25 operating margin was 24.3%).
- Net margin: 17% - 19%.
- Margin trend: Expanding. PG is targeting $1.5 billion in pre-tax savings per year via supply chain optimisation and data analytics (Gross Productivity Savings).
Balance Sheet Structure
- Total assets: ~$120 billion.
- Key asset categories: Goodwill and Tradenames (massive portion due to historical acquisitions like Gillette), Property, Plant & Equipment, Accounts Receivable, and Inventory.
- Goodwill & intangibles: ~55-60% of total assets. Highly sensitive to impairment testing (e.g., Gillette write-down).
- Working capital profile:
- Days Sales Outstanding (DSO): ~25-30 days.
- Days Inventory Outstanding (DIO): ~55-65 days.
- Days Payable Outstanding (DPO): ~100-115 days.
- Net working capital as % of revenue: Negative (-5% to -10%).
- Is working capital positive or negative?: Negative. PG uses its massive scale to stretch supplier payables, meaning growth generates cash from working capital.
- PP&E: ~$21-23 billion. Useful lives: Buildings (3-40 years), Machinery/Equipment (3-20 years).
- Right-of-use assets / operating leases: ~$1.5 billion. Material but not a dominant part of the capital structure.
Capital Expenditure & Investment
- Capex as % of revenue: 4.0% - 5.0% (Management guidance for FY26 is 4-5%).
- Maintenance capex vs. growth capex: ~60% maintenance / 40% growth (capacity expansion, supply chain resilience).
- Major capex programmes underway or planned: Supply chain 3.0 initiatives, automation, and sustainability upgrades (reducing virgin plastic).
- Capitalised software / development costs: Minimal relative to physical PP&E.
- M&A pattern: Bolt-on acquirer (e.g., Ouai, Tula, Farmacy Beauty) and occasional divestitures (e.g., exiting Glad joint venture).
- Typical acquisition multiple paid: 3-5x EV/Sales for premium beauty brands.
Debt & Capital Structure
- Total debt: ~$34-36 billion (including current portion). Net debt is typically ~$25-28 billion.
- Debt/EBITDA ratio: ~1.3x - 1.6x (highly conservative).
- Credit rating: Aa3 (Moody's) / AA- (S&P).
- Key debt instruments: Commercial paper (for working capital), long-term notes, and bonds.
- Maturity profile: Well-laddered. Average maturity is typically 5-7 years.
- Interest rate profile: Predominantly fixed via interest rate swaps, weighted average cost of debt ~3.0% - 3.5%.
- Covenants: Standard investment-grade covenants; no material financial maintenance covenants that restrict operations.
- Share repurchase programme: Highly active. ~$5.0 - $6.5 billion annually.
- Dividend policy: ~60% payout ratio. PG has increased its dividend for 69 consecutive years. Target is ~$10 billion in annual dividend payments.
Cash Flow Characteristics
- Operating cash flow conversion: >1.0x (OCF / Net Income). FY25 OCF was $17.8 billion on $16.1 billion of net earnings.
- Free cash flow margin: ~15% - 18% (FCF / Revenue).
- Major non-cash items: Depreciation & amortisation, stock-based compensation, deferred income taxes, and periodic intangible impairments.
- Working capital cash flow impact: Source of cash during growth periods due to negative NWC.
- Capex intensity: Low-to-moderate (4-5% of sales).
- Cash tax rate vs. GAAP effective tax rate: Cash taxes generally track the effective tax rate closely (20-21%), adjusted for deferred tax liabilities on intangibles.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic factors, segment growth (Volume, Price/Mix, FX), margin targets, and capital allocation.
- Revenue Build: Segment-level forecast (Fabric & Home Care, Baby/Feminine/Family, Beauty, Health Care, Grooming) bridging Volume + Price/Mix + FX to Reported Sales.
- Income Statement: Consolidated view down to Net Earnings Attributable to Procter & Gamble. Includes Core EPS reconciliation.
- Working Capital: Schedules for Accounts Receivable, Inventory, Accounts Payable, and Accrued Expenses.
- PP&E & Intangibles: Capex, depreciation waterfall, and goodwill/tradename tracking (flagging impairment risks).
- Debt Schedule: Commercial paper, long-term debt tranches, interest expense calculation, and debt paydown/issuance.
- Shareholders' Equity: Retained earnings, accumulated other comprehensive income (AOCI - crucial for FX translation), dividends, and share repurchases.
- Balance Sheet: Standard GAAP presentation.
- Cash Flow Statement: Indirect method, bridging Net Earnings to OCF, CFI, and CFF.
- Valuation (DCF): Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.
- Outputs & Checks: Dashboard of key metrics (Organic Growth, Core EPS, FCF Productivity) and balance checks.
Key Financial Relationships
- `Segment Organic Sales Growth = Segment Volume Growth + Segment Price/Mix Impact`
- `Segment Reported Net Sales = Prior Year Segment Net Sales * (1 + Segment Organic Sales Growth + Segment FX Impact + Segment M&A Impact)`
- `Consolidated Net Sales = Sum of Segment Reported Net Sales + Corporate Sales`
- `Gross Profit = Consolidated Net Sales - Cost of Products Sold (COGS)`
- `SG&A Expense = Marketing Expense + Overhead/Administrative Expense`
- `Operating Income = Gross Profit - SG&A Expense - Restructuring/Impairment Charges`
- `Core EPS = (Net Earnings Attributable to PG + Restructuring Charges + Impairment Charges) / Diluted Shares Outstanding`
- `Accounts Receivable = (Consolidated Net Sales / 365) * DSO`
- `Inventory = (COGS / 365) * DIO`
- `Accounts Payable = (COGS / 365) * DPO`
- `Adjusted Free Cash Flow = Operating Cash Flow - Capital Expenditures`
- `Adjusted FCF Productivity = Adjusted Free Cash Flow / Net Earnings`
- `Dividends Paid = Prior Year Dividends Per Share * (1 + Dividend Growth Rate) * Basic Shares Outstanding`
- `Ending Diluted Shares = Beginning Diluted Shares - (Share Repurchases / Average Share Price) + SBC Issuances`
Cross-Sheet Dependencies
- Revenue Build feeds the top line of the Income Statement and drives DSO/DIO/DPO calculations on the Working Capital sheet.
- Working Capital changes feed the Operating Cash Flow section of the Cash Flow Statement.
- PP&E & Intangibles feeds Depreciation & Amortisation to the Income Statement and Cash Flow Statement, and ending balances to the Balance Sheet.
- Debt Schedule calculates Interest Expense, which feeds the Income Statement. The ending debt balances feed the Balance Sheet, and issuances/repayments feed the Cash Flow Statement.
- Cash Flow Statement generates the ending Cash balance, which serves as the final plug to balance the Balance Sheet.
- Circularity Risk: Interest expense depends on average debt balances, which depend on the cash flow sweep, which depends on net income (and thus interest expense). A circuit breaker (toggle) must be included in the Assumptions sheet.
Sign Convention
- Income Statement: Revenues are positive. Expenses (COGS, SG&A, Interest, Taxes) are entered as positive numbers and subtracted in subtotals.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive.
- Cash Flow Statement: Net Income is positive. Non-cash add-backs (D&A) are positive. Increases in assets (use of cash) are negative. Increases in liabilities (source of cash) are positive. Capex is negative. Dividends and share repurchases are negative. Debt issuance is positive; repayment is negative.
Things Most Likely to Go Wrong
- FX Translation Impact: Foreign currency translation can swing reported revenue by 3-5% YoY. The model must explicitly separate Organic Sales Growth from FX Impact.
- Core vs. GAAP EPS: PG management is evaluated on *Core EPS*. Failing to add back restructuring charges (e.g., Argentina/Nigeria exits) and intangible impairments (Gillette) will result in a flawed valuation.
- Negative Working Capital: PG operates with negative net working capital. If the model incorrectly assumes positive NWC, growth will incorrectly consume cash rather than generate it.
- Tariff and Commodity Headwinds: PG explicitly guides for these (e.g., $400M tariff headwind, $100M commodity headwind in FY26). These must be modeled as direct hits to Gross Margin.
- Gillette Impairment: The $1.3B non-cash impairment in FY24 distorts historical operating margins. Historicals must be adjusted to reflect the underlying run-rate.
- Share Count Reduction: PG buys back ~$5B in stock annually. The model must dynamically reduce the share count to accurately forecast EPS growth.
- Dividend Aristocrat Status: PG has raised its dividend for 69 years. The model must never forecast a dividend cut; the payout ratio should float to accommodate a steadily rising DPS.
- Corporate Allocations: Segment-level net sales do not perfectly equal consolidated net sales due to ~1% Corporate segment eliminations. The model must include a Corporate line item.
Validation Checks
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period (Tolerance: <$1M)."
- "Adjusted FCF Productivity should be between 85% and 100% based on management guidance; flag if outside this band."
- "Gross margin should be in the 48.0% - 51.5% range; flag if outside this band."
- "Capex as % of revenue must run between 4.0% and 5.0%."
- "Core Effective Tax Rate should be 20.0% - 21.0%."
- "Dividend per share must be strictly greater than the prior year's dividend per share."
- "Debt/EBITDA should remain below 2.0x to maintain the Aa3/AA- credit rating."
- "Organic sales growth should not exceed 5% without flagging (mature CPG industry constraint)."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Fabric & Home Care Organic Growth | 3.0 | % | Historical average and continued premiumisation (Tide PODS). |
| Baby, Feminine & Family Care Organic Growth | 1.0 | % | Slower growth due to demographic headwinds (lower birth rates). |
| Beauty Organic Growth | 2.0 | % | Recovery in Skin Care offset by competitive pressures. |
| Health Care Organic Growth | 4.0 | % | Strong pricing power and aging population tailwinds. |
| Grooming Organic Growth | 1.0 | % | Mature market, heavy competition, volume pressure. |
| FX Impact on Net Sales | -1.0 | % | Persistent strong USD headwind based on FY25/FY26 guidance. |
| Gross Margin | 50.5 | % | FY25 actuals, reflecting pricing offsetting commodity costs. |
| SG&A as % of Net Sales | 26.0 | % | Historical average, balancing productivity savings with marketing spend. |
| Core Effective Tax Rate | 20.5 | % | Midpoint of management's FY26 guidance (20-21%). |
| Days Sales Outstanding (DSO) | 28 | Days | Calculated from FY25 Accounts Receivable and Net Sales. |
| Days Inventory Outstanding (DIO) | 60 | Days | Calculated from FY25 Inventory and COGS. |
| Days Payable Outstanding (DPO) | 110 | Days | Calculated from FY25 Accounts Payable and COGS (reflects scale advantage). |
| Capex as % of Net Sales | 4.5 | % | Midpoint of management's FY26 guidance (4-5%). |
| Annual Share Repurchases | 5,000 | $ Millions | Management FY26 guidance. |
| Annual Dividend Growth Rate | 4.0 | % | Historical average to maintain 69-year growth streak. |
| Weighted Average Interest Rate | 3.5 | % | Based on current debt portfolio and interest rate swaps. |
| WACC | 7.5 | % | Low beta (~0.4), low cost of debt, mature staple profile. |
| Terminal Growth Rate | 2.0 | % | Aligned with long-term global GDP and inflation targets. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (PG 10-K, 10-Q, 8-K), PG Investor Relations website (pginvestor.com) for earnings presentations and non-GAAP reconciliations.
- Key Peers: Unilever (UL), Kimberly-Clark (KMB), Colgate-Palmolive (CL), L'Oréal (OR.PA).
- Industry Data: Nielsen / IRI scanner data for US market share and volume trends in tracked channels.
- Consensus Estimates: FactSet or Bloomberg for consensus Core EPS and Organic Sales Growth estimates.
- Proprietary Data: Euromonitor for global beauty and personal care market sizing; pulp and resin commodity futures for COGS forecasting.
Sources
Do more with the Procter & Gamble model
Frequently asked
What does Procter & Gamble (PG) do?+
Procter & Gamble is a global consumer packaged goods corporation that provides branded daily-use products to consumers worldwide. The company focuses on categories where product performance drives brand choice, such as Fabric & Home Care, Baby, Feminine & Family Care, Beauty, Health Care, and Grooming.
How does Procter & Gamble generate its revenue?+
Procter & Gamble generates revenue across its five main business segments, with Fabric & Home Care being the largest contributor. Revenue growth is primarily driven by factors like volume growth, price/mix impact, and M&A activities, though it can be influenced by foreign exchange rates.
What is Procter & Gamble's typical capital expenditure as a percentage of revenue?+
Procter & Gamble's capital expenditure (Capex) as a percentage of revenue typically falls within the range of 4.0% to 5.0%, aligning with management guidance. This spending is approximately 60% for maintenance and 40% for growth initiatives, including supply chain improvements and automation.
What are the key assumptions used in the Procter & Gamble financial model forecast?+
The Procter & Gamble financial model forecast incorporates several key assumptions, including a revenue growth rate of approximately 4.9% and COGS as a percentage of revenue around 50.9%. Other significant assumptions include an SGA as a percentage of revenue of about 27.0% and a tax rate of roughly 21.7%.
Can I download an Excel financial model for Procter & Gamble (PG)?+
Yes, a comprehensive 3-statement forecast and DCF valuation model for Procter & Gamble (PG) is available for download. This model is designed to help equity research analysts evaluate the impact of various factors, such as pricing power and productivity savings, on core EPS and free cash flow generation.
What is Procter & Gamble's net working capital profile?+
Procter & Gamble exhibits a negative net working capital as a percentage of revenue, typically ranging from -5% to -10%. This indicates that the company leverages its substantial scale to extend supplier payment terms, allowing growth to generate cash from working capital.
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 Consumer Goods Company Financial Models
Browse another company in the same sector.
Church & Dwight
Church & Dwight Co., Inc.
Colgate-Palmolive
Colgate-Palmolive is a leading global consumer products company focused on the production, distribution, and provision of household, health care, personal care, and veterinary products.
Clorox
The Clorox Company is a leading multinational manufacturer and marketer of consumer and professional products.
Deckers Brands
Deckers Brands is a global footwear, apparel, and accessories designer and distributor, best known for its powerhouse brands UGG and HOKA.
Estée Lauder Companies
The Estée Lauder Companies Inc.
Kimberly-Clark
Kimberly-Clark is a global consumer packaged goods company that manufactures and markets personal care and consumer tissue products under iconic brands such as Huggies, Kleenex, Kotex, and Scott.
Kenvue
Kenvue is the world's largest pure-play consumer health company by revenue, manufacturing and marketing a portfolio of iconic, science-backed brands including Tylenol, Neutrogena, Listerine, and Band-Aid.
Lululemon Athletica
Lululemon Athletica is a premium athletic apparel, footwear, and accessories company that designs and retails products for yoga, running, training, and other sweaty pursuits.
Explore more Consumer financial model templates.
