Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Return on Capital (ROC)

Microsoft Excel

Return on capital (ROC) is after tax rate of return on net business assets. ROIC is unaffected by changes in interest rates or company debt and equity structure. It measures business productivity performance.


Return on Invested Capital (ROIC)

Procter & Gamble Co., ROIC calculation

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 14,689 14,588 14,283 12,785 3,768 8,451
Invested capital2 96,550 93,924 95,095 101,100 89,875 92,231
Performance Ratio
ROIC3 15.21% 15.53% 15.02% 12.65% 4.19% 9.16%

Based on: 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), 10-K (reporting date: 2018-06-30).

1 NOPAT. See details »

2 Invested capital. See details »

3 2023 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × 14,689 ÷ 96,550 = 15.21%

Performance ratio Description The company
ROIC A measure of the periodic, after tax, cash-on-cash yield earned in the business. Procter & Gamble Co. ROIC improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Decomposition of ROIC

Procter & Gamble Co., decomposition of ROIC

Microsoft Excel
ROIC = OPM1 × TO2 × 1 – CTR3
Jun 30, 2023 15.21% = 23.00% × 0.85 × 77.90%
Jun 30, 2022 15.53% = 22.79% × 0.85 × 79.81%
Jun 30, 2021 15.02% = 23.52% × 0.80 × 79.77%
Jun 30, 2020 12.65% = 22.81% × 0.70 × 78.99%
Jun 30, 2019 4.19% = 9.38% × 0.75 × 59.33%
Jun 30, 2018 9.16% = 20.71% × 0.72 × 61.07%

Based on: 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), 10-K (reporting date: 2018-06-30).

1 Operating profit margin (OPM). See calculations »

2 Turnover of capital (TO). See calculations »

3 Effective cash tax rate (CTR). See calculations »

The primary reason for the decrease in return on invested capital (ROIC) over 2023 year is the increase in effective cash tax rate (CTR).


Operating Profit Margin (OPM)

Procter & Gamble Co., OPM calculation

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 14,689 14,588 14,283 12,785 3,768 8,451
Add: Cash operating taxes2 4,168 3,691 3,623 3,400 2,583 5,387
Net operating profit before taxes (NOPBT) 18,858 18,279 17,906 16,184 6,350 13,838
 
Net sales 82,006 80,187 76,118 70,950 67,684 66,832
Profitability Ratio
OPM3 23.00% 22.79% 23.52% 22.81% 9.38% 20.71%

Based on: 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), 10-K (reporting date: 2018-06-30).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2023 Calculation
OPM = 100 × NOPBT ÷ Net sales
= 100 × 18,858 ÷ 82,006 = 23.00%

Profitability ratio Description The company
OPM The operating profit margin (OPM) is the ratio of pretax economic earnings, or NOPBT, to sales. Procter & Gamble Co. OPM deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Turnover of Capital (TO)

Procter & Gamble Co., TO calculation

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net sales 82,006 80,187 76,118 70,950 67,684 66,832
Invested capital1 96,550 93,924 95,095 101,100 89,875 92,231
Efficiency Ratio
TO2 0.85 0.85 0.80 0.70 0.75 0.72

Based on: 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), 10-K (reporting date: 2018-06-30).

1 Invested capital. See details »

2 2023 Calculation
TO = Net sales ÷ Invested capital
= 82,006 ÷ 96,550 = 0.85

Efficiency ratio Description The company
TO The turnover of capital (TO) is the ratio of sales to invested capital. Capital turnover is a function of the efficiency of working capital management and of net fixed assets. Procter & Gamble Co. TO improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Effective Cash Tax Rate (CTR)

Procter & Gamble Co., CTR calculation

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 14,689 14,588 14,283 12,785 3,768 8,451
Add: Cash operating taxes2 4,168 3,691 3,623 3,400 2,583 5,387
Net operating profit before taxes (NOPBT) 18,858 18,279 17,906 16,184 6,350 13,838
Tax Rate
CTR3 22.10% 20.19% 20.23% 21.01% 40.67% 38.93%

Based on: 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), 10-K (reporting date: 2018-06-30).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2023 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × 4,168 ÷ 18,858 = 22.10%

Tax rate Description The company
CTR Effective cash tax rate on operating income. Procter & Gamble Co. CTR decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.