Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

$24.99

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.

Paying users area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

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
Invested capital2
Performance Ratio
ROIC3

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 × ÷ =

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 = × ×
Jun 30, 2022 = × ×
Jun 30, 2021 = × ×
Jun 30, 2020 = × ×
Jun 30, 2019 = × ×
Jun 30, 2018 = × ×

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
Add: Cash operating taxes2
Net operating profit before taxes (NOPBT)
 
Net sales
Profitability Ratio
OPM3

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 × ÷ =

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
Invested capital1
Efficiency Ratio
TO2

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
= ÷ =

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
Add: Cash operating taxes2
Net operating profit before taxes (NOPBT)
Tax Rate
CTR3

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 × ÷ =

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.