← All financial models

The Procter & Gamble (PG) Financial Model

📊 Download Model

Three-statement Excel model · 20 quarters and 5 fiscal years of history · 8 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the PG model

This three-statement Excel model covers The Procter & Gamble Company (PG): its income statement, balance sheet and cash flow statement. It holds 20 quarters and 5 fiscal years of history and 8 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: Five global business units + Corporate, each = year-ago quarter x (1 + organic growth + currency and acquisitions); every margin driver set per fiscal quarter, across 5 segments.

Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet, Cash Flow Statement, Operating Segments and Pro-Forma / Non-GAAP Reconciliation.

Model thesis: Organic growth by business unit with a front-loaded margin path: FY27E core EPS $6.95 inside the guide, FY28E-FY30E EPS 2.7-5.1% below the Street

On October 19, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated September 27, 2026.

History
20 quarters and 5 fiscal years
Projections
8 quarters and 5 fiscal years
KPI
Five global business units + Corporate, each = year-ago quarter x (1 + organic growth + currency and acquisitions); every margin driver set per fiscal quarter
Segments
5
Units
Dollars in millions, except per share
Verified
Updated
File
Excel workbook (.xlsx), 182 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns FY24–FY26 are actual results and FY27E–FY29E are our estimates. Figures were recalculated in Excel on September 28, 2026. Dollars in millions, except per share.

Income statement preview for PG. Dollars in millions, except per share. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY24FY25FY26FY27EFY28EFY29E
Total Net Sales$84,039.0$84,284.0$87,032.0$88,723.9$90,655.2$92,633.4
Less: Cost of Products Sold($40,848.0)($41,164.0)($43,362.0)($44,525.0)($45,222.3)($46,038.8)
Gross Profit$43,191.0$43,120.0$43,670.0$44,198.9$45,433.0$46,594.6
Less: Selling, General and Administrative Expense(23,305.0)(22,669.0)(23,922.0)(23,695.9)(24,121.0)(24,733.1)
Less: Indefinite-Lived Intangible Asset Impairment(1,341.0)0.00.00.00.00.0
Total Operating Expenses($24,646.0)($22,669.0)($23,922.0)($23,695.9)($24,121.0)($24,733.1)
Operating Income$18,545.0$20,451.0$19,748.0$20,503.0$21,312.0$21,861.5
Less: Interest Expense(925.0)(907.0)(877.0)(1,050.1)(1,050.1)(1,051.5)
Interest Income473.0469.0430.0398.4458.6520.4
Other Non-Operating Income/(Expense), Net668.0154.01,076.0876.4895.5917.1
Rounding Residual0.00.00.00.00.00.0
Earnings Before Income Taxes$18,761.0$20,167.0$20,377.0$20,727.7$21,616.0$22,247.5
Less: Income Taxes($3,787.0)($4,102.0)($4,233.0)($4,311.4)($4,496.1)($4,627.5)
Net Earnings$14,974.0$16,065.0$16,144.0$16,416.3$17,119.9$17,620.0
Less: Net Earnings Attributable to Noncontrolling Interests(95.0)(91.0)(98.0)(98.5)(102.7)(105.7)
Net Earnings Attributable to Procter & Gamble$14,879.0$15,974.0$16,046.0$16,317.8$17,017.2$17,514.3
Less: Preferred Dividends(284.0)(291.0)(292.0)(281.1)(273.3)(268.3)
Net Earnings Available to Common Shareholders$14,595.0$15,683.0$15,754.0$16,036.7$16,743.9$17,246.0
Ratios & Assumptions
YoY Total Net Sales Growth2.5%0.3%3.3%1.9%2.2%2.2%
Gross Margin51.4%51.2%50.2%49.8%50.1%50.3%
Operating Margin22.1%24.3%22.7%23.1%23.5%23.6%
Net Margin (consolidated)17.8%19.1%18.5%18.5%18.9%19.0%
Net Margin (attributable to P&G)17.7%19.0%18.4%18.4%18.8%18.9%

The full workbook adds 20 historical and 8 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement · Operating Segments · Pro-Forma / Non-GAAP Reconciliation — every subtotal a live formula, every projection traced to a driver.

Download the full PG model (xlsx)3 free models a month with an account, then $9 a month

The Procter & Gamble research

Aardvark Labs Capital Research has published 5 reports on The Procter & Gamble (PG). The latest is the Q1 FY27 Earnings Recap, published October 26, 2026, rated Hold.

Volume Comes Back Early: A 4% Organic Quarter Trips Our Upgrade Trigger, While a Bigger Oil Bill and a 23x Multiple Cap PG at Hold

All PG research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.