Stock Analysis on Net
Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

Procter & Gamble Co., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Net fixed asset turnover 3.82 3.79 3.85 3.74 3.75 3.79 3.91 3.78 3.73 3.67 3.61 3.51 3.55 3.45 3.47 3.43 3.44 3.28 3.29 3.18 3.20 3.21 3.25 3.24 — — —
Total asset turnover 0.70 0.70 0.68 0.68 0.68 0.68 0.69 0.68 0.66 0.65 0.64 0.64 0.64 0.62 0.60 0.59 0.59 0.62 0.60 0.59 0.55 0.54 0.56 0.56 — — —
Equity turnover 1.68 1.73 1.75 1.75 1.79 1.81 1.83 1.72 1.75 1.76 1.67 1.64 1.61 1.54 1.50 1.53 1.54 1.53 1.48 1.43 1.22 1.24 1.28 1.28 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Procter & Gamble Co. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Procter & Gamble Co. total asset turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Procter & Gamble Co. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Net Fixed Asset Turnover

Procter & Gamble Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Selected Financial Data (US$ in millions)
Net sales 20,195 21,441 21,871 20,553 20,068 20,773 20,612 19,515 19,381 20,953 20,338 18,946 18,109 19,745 19,318 17,698 17,214 18,240 17,798 17,094 16,462 17,438 16,690 16,503 16,281 17,395 16,653
Property, plant and equipment, net 22,027 22,132 21,636 21,909 21,564 21,167 20,593 21,195 21,323 21,357 21,392 21,686 21,103 21,416 20,876 20,692 20,459 21,250 20,901 21,271 20,993 20,822 20,590 20,600 20,925 20,420 20,108
Long-term Activity Ratio
Net fixed asset turnover1 3.82 3.79 3.85 3.74 3.75 3.79 3.91 3.78 3.73 3.67 3.61 3.51 3.55 3.45 3.47 3.43 3.44 3.28 3.29 3.18 3.20 3.21 3.25 3.24 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

1 Q3 2024 Calculation
Net fixed asset turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Property, plant and equipment, net
= (20,195 + 21,441 + 21,871 + 20,553) ÷ 22,027 = 3.82

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Procter & Gamble Co. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024.

Total Asset Turnover

Procter & Gamble Co., total asset turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Selected Financial Data (US$ in millions)
Net sales 20,195 21,441 21,871 20,553 20,068 20,773 20,612 19,515 19,381 20,953 20,338 18,946 18,109 19,745 19,318 17,698 17,214 18,240 17,798 17,094 16,462 17,438 16,690 16,503 16,281 17,395 16,653
Total assets 119,598 120,709 122,531 120,829 119,851 117,715 116,282 117,208 120,217 121,416 119,669 119,307 116,778 120,112 119,899 120,700 118,560 111,723 114,058 115,095 121,673 123,687 118,440 118,310 124,369 126,644 122,851
Long-term Activity Ratio
Total asset turnover1 0.70 0.70 0.68 0.68 0.68 0.68 0.69 0.68 0.66 0.65 0.64 0.64 0.64 0.62 0.60 0.59 0.59 0.62 0.60 0.59 0.55 0.54 0.56 0.56 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

1 Q3 2024 Calculation
Total asset turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Total assets
= (20,195 + 21,441 + 21,871 + 20,553) ÷ 119,598 = 0.70

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Procter & Gamble Co. total asset turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Equity Turnover

Procter & Gamble Co., equity turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Selected Financial Data (US$ in millions)
Net sales 20,195 21,441 21,871 20,553 20,068 20,773 20,612 19,515 19,381 20,953 20,338 18,946 18,109 19,745 19,318 17,698 17,214 18,240 17,798 17,094 16,462 17,438 16,690 16,503 16,281 17,395 16,653
Shareholders’ equity attributable to Procter & Gamble 50,058 48,535 47,693 46,777 45,140 44,455 44,075 46,589 45,478 44,618 46,111 46,378 46,596 48,181 48,182 46,521 45,540 45,538 46,578 47,194 55,072 53,990 52,236 52,293 54,315 54,112 54,818
Long-term Activity Ratio
Equity turnover1 1.68 1.73 1.75 1.75 1.79 1.81 1.83 1.72 1.75 1.76 1.67 1.64 1.61 1.54 1.50 1.53 1.54 1.53 1.48 1.43 1.22 1.24 1.28 1.28 — — —

Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

1 Q3 2024 Calculation
Equity turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Shareholders’ equity attributable to Procter & Gamble
= (20,195 + 21,441 + 21,871 + 20,553) ÷ 50,058 = 1.68

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Procter & Gamble Co. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.