Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Procter & Gamble Co., profit margin by reportable segment

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 19.47% 21.18% 21.44% 22.27% 20.49% 20.45%
Grooming 22.20% 22.76% 22.62% 22.16% 21.90% 24.67%
Health Care 19.15% 18.93% 18.53% 18.59% 18.30% 18.48%
Fabric & Home Care 19.28% 17.02% 15.92% 17.77% 17.50% 15.93%
Baby, Feminine & Family Care 19.83% 17.53% 16.55% 19.25% 18.87% 15.35%

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).

Segment profitability ratio Reportable segment The company
Segment profit margin Beauty Beauty segment profit margin ratio deteriorated from 2022 to 2023 and from 2023 to 2024.
Grooming Grooming segment profit margin ratio improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.
Health Care Health Care segment profit margin ratio improved from 2022 to 2023 and from 2023 to 2024.
Fabric & Home Care Fabric & Home Care segment profit margin ratio improved from 2022 to 2023 and from 2023 to 2024.
Baby, Feminine & Family Care Baby, Feminine & Family Care segment profit margin ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Profit Margin: Beauty

Procter & Gamble Co.; Beauty; segment profit margin calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 2,963 3,178 3,160 3,210 2,737 2,637
Net sales 15,220 15,008 14,740 14,417 13,359 12,897
Segment Profitability Ratio
Segment profit margin1 19.47% 21.18% 21.44% 22.27% 20.49% 20.45%

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).

1 2024 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 2,963 ÷ 15,220 = 19.47%

Segment profitability ratio Reportable segment The company
Segment profit margin Beauty Beauty segment profit margin ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Segment Profit Margin: Grooming

Procter & Gamble Co.; Grooming; segment profit margin calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 1,477 1,461 1,490 1,427 1,329 1,529
Net sales 6,654 6,419 6,587 6,440 6,069 6,199
Segment Profitability Ratio
Segment profit margin1 22.20% 22.76% 22.62% 22.16% 21.90% 24.67%

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).

1 2024 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 1,477 ÷ 6,654 = 22.20%

Segment profitability ratio Reportable segment The company
Segment profit margin Grooming Grooming segment profit margin ratio improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.

Segment Profit Margin: Health Care

Procter & Gamble Co.; Health Care; segment profit margin calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 2,258 2,125 2,006 1,851 1,652 1,519
Net sales 11,793 11,226 10,824 9,956 9,028 8,218
Segment Profitability Ratio
Segment profit margin1 19.15% 18.93% 18.53% 18.59% 18.30% 18.48%

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).

1 2024 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 2,258 ÷ 11,793 = 19.15%

Segment profitability ratio Reportable segment The company
Segment profit margin Health Care Health Care segment profit margin ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Profit Margin: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment profit margin calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 5,687 4,828 4,386 4,622 4,154 3,518
Net sales 29,495 28,371 27,556 26,014 23,735 22,080
Segment Profitability Ratio
Segment profit margin1 19.28% 17.02% 15.92% 17.77% 17.50% 15.93%

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).

1 2024 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 5,687 ÷ 29,495 = 19.28%

Segment profitability ratio Reportable segment The company
Segment profit margin Fabric & Home Care Fabric & Home Care segment profit margin ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Profit Margin: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment profit margin calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 4,020 3,545 3,266 3,629 3,465 2,734
Net sales 20,277 20,217 19,736 18,850 18,364 17,806
Segment Profitability Ratio
Segment profit margin1 19.83% 17.53% 16.55% 19.25% 18.87% 15.35%

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).

1 2024 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 4,020 ÷ 20,277 = 19.83%

Segment profitability ratio Reportable segment The company
Segment profit margin Baby, Feminine & Family Care Baby, Feminine & Family Care segment profit margin ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Return on Assets (Segment ROA)

Procter & Gamble Co., ROA by reportable segment

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 48.55% 51.29% 52.19% 57.45% 49.48% 49.18%
Grooming 7.74% 7.09% 7.27% 6.90% 6.45% 7.32%
Health Care 26.83% 25.06% 25.43% 23.21% 21.38% 19.71%
Fabric & Home Care 63.85% 55.69% 51.20% 55.46% 53.63% 46.17%
Baby, Feminine & Family Care 47.31% 41.62% 38.68% 41.88% 40.16% 29.49%

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).

Segment profitability ratio Reportable segment The company
Segment ROA Beauty Beauty segment ROA deteriorated from 2022 to 2023 and from 2023 to 2024.
Grooming Grooming segment ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Health Care Health Care segment ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Fabric & Home Care Fabric & Home Care segment ROA improved from 2022 to 2023 and from 2023 to 2024.
Baby, Feminine & Family Care Baby, Feminine & Family Care segment ROA improved from 2022 to 2023 and from 2023 to 2024.

Segment ROA: Beauty

Procter & Gamble Co.; Beauty; segment ROA calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 2,963 3,178 3,160 3,210 2,737 2,637
Total assets 6,103 6,196 6,055 5,587 5,531 5,362
Segment Profitability Ratio
Segment ROA1 48.55% 51.29% 52.19% 57.45% 49.48% 49.18%

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).

1 2024 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 2,963 ÷ 6,103 = 48.55%

Segment profitability ratio Reportable segment The company
Segment ROA Beauty Beauty segment ROA deteriorated from 2022 to 2023 and from 2023 to 2024.

Segment ROA: Grooming

Procter & Gamble Co.; Grooming; segment ROA calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 1,477 1,461 1,490 1,427 1,329 1,529
Total assets 19,082 20,601 20,482 20,668 20,589 20,882
Segment Profitability Ratio
Segment ROA1 7.74% 7.09% 7.27% 6.90% 6.45% 7.32%

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).

1 2024 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 1,477 ÷ 19,082 = 7.74%

Segment profitability ratio Reportable segment The company
Segment ROA Grooming Grooming segment ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment ROA: Health Care

Procter & Gamble Co.; Health Care; segment ROA calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 2,258 2,125 2,006 1,851 1,652 1,519
Total assets 8,416 8,480 7,888 7,976 7,726 7,708
Segment Profitability Ratio
Segment ROA1 26.83% 25.06% 25.43% 23.21% 21.38% 19.71%

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).

1 2024 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 2,258 ÷ 8,416 = 26.83%

Segment profitability ratio Reportable segment The company
Segment ROA Health Care Health Care segment ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment ROA: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment ROA calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 5,687 4,828 4,386 4,622 4,154 3,518
Total assets 8,907 8,669 8,567 8,334 7,745 7,620
Segment Profitability Ratio
Segment ROA1 63.85% 55.69% 51.20% 55.46% 53.63% 46.17%

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).

1 2024 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 5,687 ÷ 8,907 = 63.85%

Segment profitability ratio Reportable segment The company
Segment ROA Fabric & Home Care Fabric & Home Care segment ROA improved from 2022 to 2023 and from 2023 to 2024.

Segment ROA: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment ROA calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net earnings (loss) 4,020 3,545 3,266 3,629 3,465 2,734
Total assets 8,497 8,517 8,443 8,666 8,628 9,271
Segment Profitability Ratio
Segment ROA1 47.31% 41.62% 38.68% 41.88% 40.16% 29.49%

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).

1 2024 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 4,020 ÷ 8,497 = 47.31%

Segment profitability ratio Reportable segment The company
Segment ROA Baby, Feminine & Family Care Baby, Feminine & Family Care segment ROA improved from 2022 to 2023 and from 2023 to 2024.

Segment Asset Turnover

Procter & Gamble Co., asset turnover by reportable segment

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 2.49 2.42 2.43 2.58 2.42 2.41
Grooming 0.35 0.31 0.32 0.31 0.29 0.30
Health Care 1.40 1.32 1.37 1.25 1.17 1.07
Fabric & Home Care 3.31 3.27 3.22 3.12 3.06 2.90
Baby, Feminine & Family Care 2.39 2.37 2.34 2.18 2.13 1.92

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).

Segment activity ratio Reportable segment The company
Segment asset turnover Beauty Beauty segment asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Grooming Grooming segment asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Health Care Health Care segment asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Fabric & Home Care Fabric & Home Care segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Baby, Feminine & Family Care Baby, Feminine & Family Care segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Asset Turnover: Beauty

Procter & Gamble Co.; Beauty; segment asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net sales 15,220 15,008 14,740 14,417 13,359 12,897
Total assets 6,103 6,196 6,055 5,587 5,531 5,362
Segment Activity Ratio
Segment asset turnover1 2.49 2.42 2.43 2.58 2.42 2.41

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).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 15,220 ÷ 6,103 = 2.49

Segment activity ratio Reportable segment The company
Segment asset turnover Beauty Beauty segment asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Asset Turnover: Grooming

Procter & Gamble Co.; Grooming; segment asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net sales 6,654 6,419 6,587 6,440 6,069 6,199
Total assets 19,082 20,601 20,482 20,668 20,589 20,882
Segment Activity Ratio
Segment asset turnover1 0.35 0.31 0.32 0.31 0.29 0.30

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).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 6,654 ÷ 19,082 = 0.35

Segment activity ratio Reportable segment The company
Segment asset turnover Grooming Grooming segment asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Asset Turnover: Health Care

Procter & Gamble Co.; Health Care; segment asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net sales 11,793 11,226 10,824 9,956 9,028 8,218
Total assets 8,416 8,480 7,888 7,976 7,726 7,708
Segment Activity Ratio
Segment asset turnover1 1.40 1.32 1.37 1.25 1.17 1.07

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).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 11,793 ÷ 8,416 = 1.40

Segment activity ratio Reportable segment The company
Segment asset turnover Health Care Health Care segment asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Asset Turnover: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net sales 29,495 28,371 27,556 26,014 23,735 22,080
Total assets 8,907 8,669 8,567 8,334 7,745 7,620
Segment Activity Ratio
Segment asset turnover1 3.31 3.27 3.22 3.12 3.06 2.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).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 29,495 ÷ 8,907 = 3.31

Segment activity ratio Reportable segment The company
Segment asset turnover Fabric & Home Care Fabric & Home Care segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Asset Turnover: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Net sales 20,277 20,217 19,736 18,850 18,364 17,806
Total assets 8,497 8,517 8,443 8,666 8,628 9,271
Segment Activity Ratio
Segment asset turnover1 2.39 2.37 2.34 2.18 2.13 1.92

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).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 20,277 ÷ 8,497 = 2.39

Segment activity ratio Reportable segment The company
Segment asset turnover Baby, Feminine & Family Care Baby, Feminine & Family Care segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation

Procter & Gamble Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 0.70 0.76 0.95 1.16 1.24 2.33
Grooming 1.01 0.90 0.72 0.77 0.75 0.86
Health Care 1.38 1.32 1.09 0.98 0.97 1.23
Fabric & Home Care 1.52 1.45 1.47 1.56 1.47 1.77
Baby, Feminine & Family Care 1.19 1.24 1.13 0.96 0.91 0.95

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).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Beauty Beauty segment capital expenditures to depreciation ratio deteriorated from 2022 to 2023 and from 2023 to 2024.
Grooming Grooming segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.
Health Care Health Care segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.
Fabric & Home Care Fabric & Home Care segment capital expenditures to depreciation ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Baby, Feminine & Family Care Baby, Feminine & Family Care segment capital expenditures to depreciation ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Segment Capital Expenditures to Depreciation: Beauty

Procter & Gamble Co.; Beauty; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 280 287 331 386 397 634
Depreciation and amortization 399 376 348 333 320 272
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.70 0.76 0.95 1.16 1.24 2.33

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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 280 ÷ 399 = 0.70

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Beauty Beauty segment capital expenditures to depreciation ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation: Grooming

Procter & Gamble Co.; Grooming; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 337 300 260 291 305 367
Depreciation and amortization 335 335 361 378 406 429
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.01 0.90 0.72 0.77 0.75 0.86

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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 337 ÷ 335 = 1.01

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Grooming Grooming segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation: Health Care

Procter & Gamble Co.; Health Care; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 524 466 410 364 338 363
Depreciation and amortization 381 352 376 372 350 294
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.38 1.32 1.09 0.98 0.97 1.23

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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 524 ÷ 381 = 1.38

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Health Care Health Care segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 1,076 979 988 1,006 887 984
Depreciation and amortization 710 675 672 646 605 557
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.52 1.45 1.47 1.56 1.47 1.77

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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 1,076 ÷ 710 = 1.52

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Fabric & Home Care Fabric & Home Care segment capital expenditures to depreciation ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Capital Expenditures to Depreciation: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment capital expenditures to depreciation calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 979 994 932 814 764 819
Depreciation and amortization 824 804 826 846 839 861
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.19 1.24 1.13 0.96 0.91 0.95

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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 979 ÷ 824 = 1.19

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Baby, Feminine & Family Care Baby, Feminine & Family Care segment capital expenditures to depreciation ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Net sales

Procter & Gamble Co., net sales by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 15,220 15,008 14,740 14,417 13,359 12,897
Grooming 6,654 6,419 6,587 6,440 6,069 6,199
Health Care 11,793 11,226 10,824 9,956 9,028 8,218
Fabric & Home Care 29,495 28,371 27,556 26,014 23,735 22,080
Baby, Feminine & Family Care 20,277 20,217 19,736 18,850 18,364 17,806
Corporate 600 765 744 441 395 484
Total 84,039 82,006 80,187 76,118 70,950 67,684

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).


Net earnings (loss)

Procter & Gamble Co., net earnings (loss) by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 2,963 3,178 3,160 3,210 2,737 2,637
Grooming 1,477 1,461 1,490 1,427 1,329 1,529
Health Care 2,258 2,125 2,006 1,851 1,652 1,519
Fabric & Home Care 5,687 4,828 4,386 4,622 4,154 3,518
Baby, Feminine & Family Care 4,020 3,545 3,266 3,629 3,465 2,734
Corporate (1,431) (399) 485 (387) (234) (7,971)
Total 14,974 14,738 14,793 14,352 13,103 3,966

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).


Depreciation and amortization

Procter & Gamble Co., depreciation and amortization by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 399 376 348 333 320 272
Grooming 335 335 361 378 406 429
Health Care 381 352 376 372 350 294
Fabric & Home Care 710 675 672 646 605 557
Baby, Feminine & Family Care 824 804 826 846 839 861
Corporate 247 172 224 160 493 411
Total 2,896 2,714 2,807 2,735 3,013 2,824

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).


Total assets

Procter & Gamble Co., total assets by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 6,103 6,196 6,055 5,587 5,531 5,362
Grooming 19,082 20,601 20,482 20,668 20,589 20,882
Health Care 8,416 8,480 7,888 7,976 7,726 7,708
Fabric & Home Care 8,907 8,669 8,567 8,334 7,745 7,620
Baby, Feminine & Family Care 8,497 8,517 8,443 8,666 8,628 9,271
Corporate 71,365 68,366 65,773 68,076 70,481 64,252
Total 122,370 120,829 117,208 119,307 120,700 115,095

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).


Capital expenditures

Procter & Gamble Co., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Beauty 280 287 331 386 397 634
Grooming 337 300 260 291 305 367
Health Care 524 466 410 364 338 363
Fabric & Home Care 1,076 979 988 1,006 887 984
Baby, Feminine & Family Care 979 994 932 814 764 819
Corporate 126 36 235 (74) 382 180
Total 3,322 3,062 3,156 2,787 3,073 3,347

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).