Companies Procter & Gamble Company

Procter & Gamble Company

TickerPG · NYSE
Fiscal yearends June
Updated3 days ago · r1
LikeOpen

A three-statement model of Procter and Gamble built from its consumer segments.

Summary by Your Analyst · r1

  • Procter and Gamble sells branded household and personal-care products through retailers in five segments, the largest Fabric and Home Care. Net sales grew from 80,187 USD millions in FY2022 to 87,032 USD millions in FY2026, and the return on invested capital was 20.3% in FY2023 and 20.7% in FY2026.
  • In the year in progress the cost of products sold rises faster than sales, the commodity and tariff pressure the company guides, so operating income moves from 19,748 USD millions to 19,908 USD millions on net sales of 90,419 USD millions. Over the forecast the return on invested capital reaches 24.9%, because goodwill and the acquired trademarks, about four fifths of the invested capital, do not grow with organic sales.
  • At the 3 November 2026 snapshot the enterprise DCF gives an equity value of 211,499 USD millions and residual operating income 224,985 USD millions, against a market capitalisation of 375,620 USD millions. The market's enterprise value implies a steady-state WACC of 6.4%, against the model's cost of capital at beta 1: the discount rate, not the forecast, carries most of the gap.

Share price

—— today— 1M · — 1YMarket cap — · Net debt 21,071 · Equity 55,507 (USD millions) · — shares
Market cap · monthlyRevenueNOPATEquityNet debtFY2028E · model
USD millions050,000100,000modelRevenue FY2025: 84,284 (USD millions)NOPAT FY2025: 16,156 (USD millions)Equity FY2025: 52,012 (USD millions)Net debt FY2025: 23,000 (USD millions)Revenue FY2026: 87,032 (USD millions)NOPAT FY2026: 15,601 (USD millions)Equity FY2026: 54,081 (USD millions)Net debt FY2026: 21,948 (USD millions)Revenue FY2027: 90,419 (USD millions)NOPAT FY2027: 15,728 (USD millions)Equity FY2027: 55,507 (USD millions)Net debt FY2027: 21,071 (USD millions)Revenue FY2028E: 93,013 (USD millions)NOPAT FY2028E: 16,180 (USD millions)Equity FY2028E: 56,393 (USD millions)Net debt FY2028E: 21,122 (USD millions)FY2025FY2026FY2027FY2028E
Market figures, USD millions
ItemFY2025FY2026FY2027FY2028E
Revenue84,28487,03290,41993,013
NOPAT16,15615,60115,72816,180
Equity52,01254,08155,50756,393
Net debt23,00021,94821,07121,122

Price vs model value

market cap vs the model’s equity value · r1
Enterprise DCF eq…Enterprise DCF equity valuelow → highpoint = baseEquity value, USD bnat FY2027$171bn$267bn$211bnResidual income e…Residual income equity valuelow → highpoint = base$180bn$286bn$225bnmarket cap $376bn$100bn$200bn$300bn$400bn$500bn

DCF to market gap -43.7% (tolerance 15.0%). WACC (Valuation / WACC / WACC): the cost of equity at beta 1, the market-average required return: The DCF equity value at the snapshot, 211.5 billion dollars, is 43.7 per cent below the market capitalisation of 375.6 billion. The discount rate causes it: the market's enterprise value implies a steady-state WACC of 6.43 per cent against the model's 9.09 (cost of equity 9.41 at beta 1); P&G's own regression betas of 0.36 to 0.40 would put the cost of equity near 6.6 to 6.7 per cent. The forecast is not the cause: revenue grew 2.7 per cent a year over FY2021 to FY2026 and ROIC ran 20.3 to 22.9 per cent over FY2023 to FY2026, and the forecast stays near that record. A WACC near 6.4 per cent, i

Residual income to market gap -40.1% (tolerance 15.0%). Long-run nominal GDP growth (Valuation / Market inputs), the growth of residual operating income after FY2037, at the model's WACC: The residual-income equity value at the snapshot, 225.0 billion dollars, is 40.1 per cent below the market capitalisation of 375.6 billion. At the model's WACC of 9.09 per cent the market prices in residual operating income growing 6.88 per cent a year forever after FY2037, against the 3.8 per cent the model uses; revenue grew 2.7 per cent a year over FY2021 to FY2026 and ROIC ran 20.3 to 22.9 per cent over FY2023 to FY2026. A perpetual growth of 6.88 per cent, or a WACC near the market-implied 6.43 per cent, closes the gap.

What if

Moving a driver re-runs the model; that opens shortly. The sliders show the Official’s own values.
FY2028 Operating income · USD millions
Fabric and Home Care growthFabric and Home Care sales growth (1 + rate)
DownsideBaseUpside
103.0%
Baby, Feminine and Family Care growthBaby, Feminine and Family Care sales growth (1 + rate)
DownsideBaseUpside
102.0%
Beauty growthBeauty sales growth (1 + rate)
DownsideBaseUpside
103.5%
Health Care growthHealth Care sales growth (1 + rate)
DownsideBaseUpside
103.5%
Cost of products sold ratioCost of products sold over net sales
DownsideBaseUpside
51.4%

The model

Open the model
✓ All checks pass
Profit & loss
Net sales 93,013;Operating income 20,480.Net sales: 93,01393,013Net salesCost of products sold: 47,84647,846Cost ofproducts…Gross profit: 45,16745,167GrossprofitSelling, general and administrative expense: 24,68724,687Selling,general …Indefinite-lived intangible asset impairment charges: 0.000.00Indefini…intangib…Operating income: 20,48020,480Operatingincome
USD millionsFY2025FY2026FY2027FY2028E
Profit & loss
Net sales84,28487,03290,41993,013
Cost of products sold41,16443,36246,51247,846
Gross profit43,12043,67043,90745,167
Selling, general and administrative expense22,66923,92223,99824,687
Indefinite-lived intangible asset impairment charges0.000.000.000.00
Operating income20,45119,74819,90820,480
Net earnings attributable to noncontrolling interests91.0098.0096.9299.85
Net earnings attributable to Procter and Gamble15,97416,04615,86916,348
Read-only · Your Analyst · r1Reported FY2025–FY2027 · Forecast FY2028E · All years

No comments yet.