Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Analysis of Income Taxes

Microsoft Excel

Income Tax Expense (Benefit)

Procter & Gamble Co., income tax expense (benefit), continuing operations

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
U.S. federal 1,955 2,303 1,916 1,663 1,266 1,064
International 1,708 1,412 1,333 1,534 1,769 1,259
U.S. state and local 368 353 355 324 292 191
Current tax expense 4,031 4,068 3,604 3,521 3,327 2,514
U.S. federal (133) (224) (320) (65) 39 (296)
International and other (111) (229) (82) (193) (635) (115)
Deferred tax benefit (244) (453) (402) (258) (596) (411)
Tax expense 3,787 3,615 3,202 3,263 2,731 2,103

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

Item Description The company
Current tax expense Amount of current income tax expense (benefit) pertaining to taxable income (loss) from continuing operations. Procter & Gamble Co. current tax expense increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Deferred tax benefit Amount of deferred income tax expense (benefit) pertaining to income (loss) from continuing operations. Procter & Gamble Co. deferred tax benefit decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.
Tax expense Amount of current income tax expense (benefit) and deferred income tax expense (benefit) pertaining to continuing operations. Procter & Gamble Co. tax expense increased from 2022 to 2023 and from 2023 to 2024.

Effective Income Tax Rate (EITR)

Procter & Gamble Co., effective income tax rate (EITR) reconciliation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
U.S. federal statutory income tax rate 21.00% 21.00% 21.00% 21.00% 21.00% 21.00%
Country mix impacts of foreign operations 0.10% -0.50% -0.30% -0.50% -0.10% -0.50%
State income taxes, net of federal benefit 1.80% 1.60% 1.50% 1.30% 1.40% 2.60%
Excess tax benefits from the exercise of stock options -1.50% -1.00% -2.00% -1.60% -1.60% -3.80%
Tax benefit from simplification of legal entity structure 0.00% 0.00% 0.00% 0.00% -1.40% 0.00%
Foreign derived intangible income deduction (FDII) -1.10% -0.80% -1.10% -1.00% -1.00% -2.20%
Changes in uncertain tax positions 0.10% 0.10% -0.40% -0.10% 0.10% -0.30%
Goodwill impairment 0.00% 0.00% 0.00% 0.00% 0.00% 22.80%
Other -0.20% -0.70% -0.90% -0.60% -1.20% -4.90%
Effective income tax rate 20.20% 19.70% 17.80% 18.50% 17.20% 34.70%

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

Item Description The company
Effective income tax rate Percentage of current income tax expense (benefit) and deferred income tax expense (benefit) pertaining to continuing operations. Procter & Gamble Co. effective income tax rate increased from 2022 to 2023 and from 2023 to 2024.

Components of Deferred Tax Assets and Liabilities

Procter & Gamble Co., components of deferred tax assets and liabilities

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Capitalized research & development 1,140 930 646 358
Loss and other carryforwards 892 1,014 914 1,030 875 1,007
Pension and other retiree benefits 592 737 740 1,476 1,602 1,591
Accrued marketing and promotion 460 421 420 424 353 334
Stock-based compensation 433 412 386 386 398 421
Fixed assets 206 223 209 223 218 232
Lease liabilities 199 197 185 196 190
Unrealized loss on financial and foreign exchange transactions 107 282 138 109 64 73
Advance payments 82
Inventory 41 31 27 41
Accrued interest and taxes 22 22 20 15
Other 843 874 717 878 829 931
Deferred tax assets, gross 4,872 5,090 4,500 5,133 4,576 4,645
Valuation allowances (290) (403) (409) (569) (486) (442)
Deferred tax assets, net 4,582 4,687 4,091 4,564 4,090 4,203
Goodwill and other intangible assets (5,459) (5,811) (5,783) (5,761) (5,775) (6,506)
Fixed assets (1,573) (1,556) (1,542) (1,512) (1,485) (1,413)
Other retiree benefits (1,319) (1,101) (1,031) (645) (265)
Unrealized gain on financial and foreign exchange transactions (263) (198) (439) (111) (169) (147)
Lease right-of-use assets (196) (191) (179) (191) (185)
Foreign withholding tax on earnings to be repatriated (104) (96) (70) (108) (118) (239)
Other (441) (381) (244) (175) (101) (351)
Deferred tax liabilities (9,355) (9,334) (9,288) (8,503) (8,098) (8,656)
Deferred tax assets (liabilities), net (4,773) (4,647) (5,197) (3,939) (4,008) (4,453)

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

Item Description The company
Deferred tax assets, gross Amount before allocation of valuation allowances of deferred tax asset attributable to deductible temporary differences and carryforwards. Procter & Gamble Co. deferred tax assets, gross increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Deferred tax assets, net Amount after allocation of valuation allowances of deferred tax asset attributable to deductible temporary differences and carryforwards. Procter & Gamble Co. deferred tax assets, net increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Deferred tax assets (liabilities), net Amount, after allocation of valuation allowances and deferred tax liability, of deferred tax asset attributable to deductible differences and carryforwards, without jurisdictional netting. Procter & Gamble Co. deferred tax assets (liabilities), net increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.

Deferred Tax Assets and Liabilities, Classification

Procter & Gamble Co., deferred tax assets and liabilities, classification

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Deferred tax assets (included in Other noncurrent assets) 1,743 1,831 1,612 2,214 2,191 2,446
Deferred tax liabilities 6,516 6,478 6,809 6,153 6,199 6,899

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

Item Description The company
Deferred tax assets (included in Other noncurrent assets) Amount, after allocation of valuation allowances and deferred tax liability, of deferred tax asset attributable to deductible differences and carryforwards, with jurisdictional netting and classified as noncurrent. Procter & Gamble Co. deferred tax assets (included in Other noncurrent assets) increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Deferred tax liabilities Amount, after deferred tax asset, of deferred tax liability attributable to taxable differences, with jurisdictional netting and classified as noncurrent. Procter & Gamble Co. deferred tax liabilities decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.

Adjustments to Financial Statements: Removal of Deferred Taxes

Procter & Gamble Co., adjustments to financial statements

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Adjustment to Total Assets
Total assets (as reported) 122,370 120,829 117,208 119,307 120,700 115,095
Less: Noncurrent deferred tax assets, net 1,743 1,831 1,612 2,214 2,191 2,446
Total assets (adjusted) 120,627 118,998 115,596 117,093 118,509 112,649
Adjustment to Total Liabilities
Total liabilities (as reported) 71,811 73,764 70,354 72,653 73,822 67,516
Less: Noncurrent deferred tax liabilities, net 6,516 6,478 6,809 6,153 6,199 6,899
Total liabilities (adjusted) 65,295 67,286 63,545 66,500 67,623 60,617
Adjustment to Shareholders’ Equity Attributable To Procter & Gamble
Shareholders’ equity attributable to Procter & Gamble (as reported) 50,287 46,777 46,589 46,378 46,521 47,194
Less: Net deferred tax assets (liabilities) (4,773) (4,647) (5,197) (3,939) (4,008) (4,453)
Shareholders’ equity attributable to Procter & Gamble (adjusted) 55,060 51,424 51,786 50,317 50,529 51,647
Adjustment to Net Earnings Attributable To Procter & Gamble (P&G)
Net earnings attributable to Procter & Gamble (P&G) (as reported) 14,879 14,653 14,742 14,306 13,027 3,897
Add: Deferred income tax expense (benefit) (244) (453) (402) (258) (596) (411)
Net earnings attributable to Procter & Gamble (P&G) (adjusted) 14,635 14,200 14,340 14,048 12,431 3,486

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).


Procter & Gamble Co., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios: Removal of Deferred Taxes (Summary)

Procter & Gamble Co., adjusted financial ratios

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Net Profit Margin
Reported net profit margin 17.70% 17.87% 18.38% 18.79% 18.36% 5.76%
Adjusted net profit margin 17.41% 17.32% 17.88% 18.46% 17.52% 5.15%
Total Asset Turnover
Reported total asset turnover 0.69 0.68 0.68 0.64 0.59 0.59
Adjusted total asset turnover 0.70 0.69 0.69 0.65 0.60 0.60
Financial Leverage
Reported financial leverage 2.43 2.58 2.52 2.57 2.59 2.44
Adjusted financial leverage 2.19 2.31 2.23 2.33 2.35 2.18
Return on Equity (ROE)
Reported ROE 29.59% 31.33% 31.64% 30.85% 28.00% 8.26%
Adjusted ROE 26.58% 27.61% 27.69% 27.92% 24.60% 6.75%
Return on Assets (ROA)
Reported ROA 12.16% 12.13% 12.58% 11.99% 10.79% 3.39%
Adjusted ROA 12.13% 11.93% 12.41% 12.00% 10.49% 3.09%

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

Financial ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by total revenue. Procter & Gamble Co. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Procter & Gamble Co. adjusted total asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Procter & Gamble Co. adjusted financial leverage ratio increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted shareholders’ equity. Procter & Gamble Co. adjusted ROE deteriorated from 2022 to 2023 and from 2023 to 2024.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Procter & Gamble Co. adjusted ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Procter & Gamble Co., Financial Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Selected Financial Data (US$ in millions)
Net earnings attributable to Procter & Gamble (P&G) 14,879 14,653 14,742 14,306 13,027 3,897
Net sales 84,039 82,006 80,187 76,118 70,950 67,684
Profitability Ratio
Net profit margin1 17.70% 17.87% 18.38% 18.79% 18.36% 5.76%
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted net earnings attributable to Procter & Gamble (P&G) 14,635 14,200 14,340 14,048 12,431 3,486
Net sales 84,039 82,006 80,187 76,118 70,950 67,684
Profitability Ratio
Adjusted net profit margin2 17.41% 17.32% 17.88% 18.46% 17.52% 5.15%

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

2024 Calculations

1 Net profit margin = 100 × Net earnings attributable to Procter & Gamble (P&G) ÷ Net sales
= 100 × 14,879 ÷ 84,039 = 17.70%

2 Adjusted net profit margin = 100 × Adjusted net earnings attributable to Procter & Gamble (P&G) ÷ Net sales
= 100 × 14,635 ÷ 84,039 = 17.41%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by total revenue. Procter & Gamble Co. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Adjusted Total Asset Turnover

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Selected Financial Data (US$ in millions)
Net sales 84,039 82,006 80,187 76,118 70,950 67,684
Total assets 122,370 120,829 117,208 119,307 120,700 115,095
Activity Ratio
Total asset turnover1 0.69 0.68 0.68 0.64 0.59 0.59
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Net sales 84,039 82,006 80,187 76,118 70,950 67,684
Adjusted total assets 120,627 118,998 115,596 117,093 118,509 112,649
Activity Ratio
Adjusted total asset turnover2 0.70 0.69 0.69 0.65 0.60 0.60

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

2024 Calculations

1 Total asset turnover = Net sales ÷ Total assets
= 84,039 ÷ 122,370 = 0.69

2 Adjusted total asset turnover = Net sales ÷ Adjusted total assets
= 84,039 ÷ 120,627 = 0.70

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Procter & Gamble Co. adjusted total asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Adjusted Financial Leverage

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Selected Financial Data (US$ in millions)
Total assets 122,370 120,829 117,208 119,307 120,700 115,095
Shareholders’ equity attributable to Procter & Gamble 50,287 46,777 46,589 46,378 46,521 47,194
Solvency Ratio
Financial leverage1 2.43 2.58 2.52 2.57 2.59 2.44
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted total assets 120,627 118,998 115,596 117,093 118,509 112,649
Adjusted shareholders’ equity attributable to Procter & Gamble 55,060 51,424 51,786 50,317 50,529 51,647
Solvency Ratio
Adjusted financial leverage2 2.19 2.31 2.23 2.33 2.35 2.18

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

2024 Calculations

1 Financial leverage = Total assets ÷ Shareholders’ equity attributable to Procter & Gamble
= 122,370 ÷ 50,287 = 2.43

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted shareholders’ equity attributable to Procter & Gamble
= 120,627 ÷ 55,060 = 2.19

Solvency ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Procter & Gamble Co. adjusted financial leverage ratio increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.

Adjusted Return on Equity (ROE)

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Selected Financial Data (US$ in millions)
Net earnings attributable to Procter & Gamble (P&G) 14,879 14,653 14,742 14,306 13,027 3,897
Shareholders’ equity attributable to Procter & Gamble 50,287 46,777 46,589 46,378 46,521 47,194
Profitability Ratio
ROE1 29.59% 31.33% 31.64% 30.85% 28.00% 8.26%
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted net earnings attributable to Procter & Gamble (P&G) 14,635 14,200 14,340 14,048 12,431 3,486
Adjusted shareholders’ equity attributable to Procter & Gamble 55,060 51,424 51,786 50,317 50,529 51,647
Profitability Ratio
Adjusted ROE2 26.58% 27.61% 27.69% 27.92% 24.60% 6.75%

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

2024 Calculations

1 ROE = 100 × Net earnings attributable to Procter & Gamble (P&G) ÷ Shareholders’ equity attributable to Procter & Gamble
= 100 × 14,879 ÷ 50,287 = 29.59%

2 Adjusted ROE = 100 × Adjusted net earnings attributable to Procter & Gamble (P&G) ÷ Adjusted shareholders’ equity attributable to Procter & Gamble
= 100 × 14,635 ÷ 55,060 = 26.58%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted shareholders’ equity. Procter & Gamble Co. adjusted ROE deteriorated from 2022 to 2023 and from 2023 to 2024.

Adjusted Return on Assets (ROA)

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Selected Financial Data (US$ in millions)
Net earnings attributable to Procter & Gamble (P&G) 14,879 14,653 14,742 14,306 13,027 3,897
Total assets 122,370 120,829 117,208 119,307 120,700 115,095
Profitability Ratio
ROA1 12.16% 12.13% 12.58% 11.99% 10.79% 3.39%
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted net earnings attributable to Procter & Gamble (P&G) 14,635 14,200 14,340 14,048 12,431 3,486
Adjusted total assets 120,627 118,998 115,596 117,093 118,509 112,649
Profitability Ratio
Adjusted ROA2 12.13% 11.93% 12.41% 12.00% 10.49% 3.09%

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).

2024 Calculations

1 ROA = 100 × Net earnings attributable to Procter & Gamble (P&G) ÷ Total assets
= 100 × 14,879 ÷ 122,370 = 12.16%

2 Adjusted ROA = 100 × Adjusted net earnings attributable to Procter & Gamble (P&G) ÷ Adjusted total assets
= 100 × 14,635 ÷ 120,627 = 12.13%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Procter & Gamble Co. adjusted ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.