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
Sep 30, 2024 Jun 30, 2024 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
Net fixed asset turnover 3.73 3.79 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
Total asset turnover 0.66 0.69 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
Equity turnover 1.62 1.67 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

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

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 Q3 2024 to Q4 2024 and from Q4 2024 to Q1 2025.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Procter & Gamble Co. total asset turnover ratio deteriorated from Q3 2024 to Q4 2024 and from Q4 2024 to Q1 2025.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Procter & Gamble Co. equity turnover ratio deteriorated from Q3 2024 to Q4 2024 and from Q4 2024 to Q1 2025.

Net Fixed Asset Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data (US$ in millions)
Net sales 21,737 20,532 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
Property, plant and equipment, net 22,506 22,152 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
Long-term Activity Ratio
Net fixed asset turnover1 3.73 3.79 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

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

1 Q1 2025 Calculation
Net fixed asset turnover = (Net salesQ1 2025 + Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024) ÷ Property, plant and equipment, net
= (21,737 + 20,532 + 20,195 + 21,441) ÷ 22,506 = 3.73

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 Q3 2024 to Q4 2024 and from Q4 2024 to Q1 2025.

Total Asset Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data (US$ in millions)
Net sales 21,737 20,532 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
Total assets 126,482 122,370 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
Long-term Activity Ratio
Total asset turnover1 0.66 0.69 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

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

1 Q1 2025 Calculation
Total asset turnover = (Net salesQ1 2025 + Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024) ÷ Total assets
= (21,737 + 20,532 + 20,195 + 21,441) ÷ 126,482 = 0.66

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 deteriorated from Q3 2024 to Q4 2024 and from Q4 2024 to Q1 2025.

Equity Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data (US$ in millions)
Net sales 21,737 20,532 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
Shareholders’ equity attributable to Procter & Gamble 51,840 50,287 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
Long-term Activity Ratio
Equity turnover1 1.62 1.67 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

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

1 Q1 2025 Calculation
Equity turnover = (Net salesQ1 2025 + Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024) ÷ Shareholders’ equity attributable to Procter & Gamble
= (21,737 + 20,532 + 20,195 + 21,441) ÷ 51,840 = 1.62

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 Q3 2024 to Q4 2024 and from Q4 2024 to Q1 2025.