Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Analysis of Goodwill and Intangible Assets

Microsoft Excel

Goodwill and Intangible Asset Disclosure

Procter & Gamble Co., balance sheet: goodwill and intangible assets

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Goodwill 40,303 40,659 39,700 40,924 39,901 40,273
Brands 4,318 4,352 4,299 3,908 3,820 3,836
Patents and technology 2,794 2,775 2,769 2,781 2,776 2,776
Customer relationships 1,834 1,847 1,797 1,789 1,752 1,787
Other 72 73 147 150 143 145
Intangible assets with determinable lives, gross carrying amount 9,018 9,047 9,012 8,628 8,491 8,544
Accumulated amortization (6,558) (6,256) (6,273) (6,100) (5,730) (5,376)
Intangible assets with determinable lives, net 2,460 2,791 2,739 2,528 2,761 3,168
Brands 19,587 20,992 20,940 21,114 21,031 21,047
Intangible assets with indefinite lives 19,587 20,992 20,940 21,114 21,031 21,047
Identifiable intangible assets 22,047 23,783 23,679 23,642 23,792 24,215
Goodwill and intangible assets 62,350 64,442 63,379 64,566 63,693 64,488

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
Goodwill Amount after accumulated impairment loss of an asset representing future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognized. Procter & Gamble Co. goodwill increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Identifiable intangible assets Sum of the carrying amounts of all intangible assets, excluding goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Procter & Gamble Co. identifiable intangible assets increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.
Goodwill and intangible assets Sum of the carrying amounts of all intangible assets, including goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Procter & Gamble Co. goodwill and intangible assets increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.

Adjustments to Financial Statements: Removal of Goodwill

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: Goodwill 40,303 40,659 39,700 40,924 39,901 40,273
Total assets (adjusted) 82,067 80,170 77,508 78,383 80,799 74,822
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: Goodwill 40,303 40,659 39,700 40,924 39,901 40,273
Shareholders’ equity attributable to Procter & Gamble (adjusted) 9,984 6,118 6,889 5,454 6,620 6,921
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: Goodwill impairment charges 6,783
Net earnings attributable to Procter & Gamble (P&G) (adjusted) 14,879 14,653 14,742 14,306 13,027 10,680

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 Goodwill (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.70% 17.87% 18.38% 18.79% 18.36% 15.78%
Total Asset Turnover
Reported total asset turnover 0.69 0.68 0.68 0.64 0.59 0.59
Adjusted total asset turnover 1.02 1.02 1.03 0.97 0.88 0.90
Financial Leverage
Reported financial leverage 2.43 2.58 2.52 2.57 2.59 2.44
Adjusted financial leverage 8.22 13.10 11.25 14.37 12.21 10.81
Return on Equity (ROE)
Reported ROE 29.59% 31.33% 31.64% 30.85% 28.00% 8.26%
Adjusted ROE 149.03% 239.51% 213.99% 262.30% 196.78% 154.31%
Return on Assets (ROA)
Reported ROA 12.16% 12.13% 12.58% 11.99% 10.79% 3.39%
Adjusted ROA 18.13% 18.28% 19.02% 18.25% 16.12% 14.27%

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 revenue. Procter & Gamble Co. adjusted net profit margin ratio deteriorated from 2022 to 2023 and 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 slightly improved from 2023 to 2024.
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 improved from 2022 to 2023 but then deteriorated significantly 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 and 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 Goodwill
Selected Financial Data (US$ in millions)
Adjusted net earnings attributable to Procter & Gamble (P&G) 14,879 14,653 14,742 14,306 13,027 10,680
Net sales 84,039 82,006 80,187 76,118 70,950 67,684
Profitability Ratio
Adjusted net profit margin2 17.70% 17.87% 18.38% 18.79% 18.36% 15.78%

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,879 ÷ 84,039 = 17.70%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Procter & Gamble Co. adjusted net profit margin ratio deteriorated from 2022 to 2023 and 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 Goodwill
Selected Financial Data (US$ in millions)
Net sales 84,039 82,006 80,187 76,118 70,950 67,684
Adjusted total assets 82,067 80,170 77,508 78,383 80,799 74,822
Activity Ratio
Adjusted total asset turnover2 1.02 1.02 1.03 0.97 0.88 0.90

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 ÷ 82,067 = 1.02

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 slightly improved from 2023 to 2024.

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 Goodwill
Selected Financial Data (US$ in millions)
Adjusted total assets 82,067 80,170 77,508 78,383 80,799 74,822
Adjusted shareholders’ equity attributable to Procter & Gamble 9,984 6,118 6,889 5,454 6,620 6,921
Solvency Ratio
Adjusted financial leverage2 8.22 13.10 11.25 14.37 12.21 10.81

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
= 82,067 ÷ 9,984 = 8.22

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 Goodwill
Selected Financial Data (US$ in millions)
Adjusted net earnings attributable to Procter & Gamble (P&G) 14,879 14,653 14,742 14,306 13,027 10,680
Adjusted shareholders’ equity attributable to Procter & Gamble 9,984 6,118 6,889 5,454 6,620 6,921
Profitability Ratio
Adjusted ROE2 149.03% 239.51% 213.99% 262.30% 196.78% 154.31%

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,879 ÷ 9,984 = 149.03%

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 improved from 2022 to 2023 but then deteriorated significantly 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 Goodwill
Selected Financial Data (US$ in millions)
Adjusted net earnings attributable to Procter & Gamble (P&G) 14,879 14,653 14,742 14,306 13,027 10,680
Adjusted total assets 82,067 80,170 77,508 78,383 80,799 74,822
Profitability Ratio
Adjusted ROA2 18.13% 18.28% 19.02% 18.25% 16.12% 14.27%

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,879 ÷ 82,067 = 18.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 and from 2023 to 2024.