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, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Beauty 21.18% 21.44% 22.27% 20.49% 20.45% 18.70%
Grooming 22.76% 22.62% 22.16% 21.90% 24.67% 21.86%
Health Care 18.93% 18.53% 18.59% 18.30% 18.48% 16.33%
Fabric & Home Care 17.02% 15.92% 17.77% 17.50% 15.93% 12.63%
Baby, Feminine & Family Care 17.53% 16.55% 19.25% 18.87% 15.35% 12.45%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Beauty Beauty segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Grooming Grooming segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.
Health Care Health Care segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Fabric & Home Care Fabric & Home Care segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Baby, Feminine & Family Care Baby, Feminine & Family Care segment profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Profit Margin: Beauty

Procter & Gamble Co.; Beauty; segment profit margin 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 earnings (loss) 3,178 3,160 3,210 2,737 2,637 2,320
Net sales 15,008 14,740 14,417 13,359 12,897 12,406
Segment Profitability Ratio
Segment profit margin1 21.18% 21.44% 22.27% 20.49% 20.45% 18.70%

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 2023 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 3,178 ÷ 15,008 = 21.18%

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

Segment Profit Margin: Grooming

Procter & Gamble Co.; Grooming; segment profit margin 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 earnings (loss) 1,461 1,490 1,427 1,329 1,529 1,432
Net sales 6,419 6,587 6,440 6,069 6,199 6,551
Segment Profitability Ratio
Segment profit margin1 22.76% 22.62% 22.16% 21.90% 24.67% 21.86%

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 2023 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 1,461 ÷ 6,419 = 22.76%

Segment profitability ratio Reportable segment The company
Segment profit margin Grooming Grooming segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Health Care

Procter & Gamble Co.; Health Care; segment profit margin 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 earnings (loss) 2,125 2,006 1,851 1,652 1,519 1,283
Net sales 11,226 10,824 9,956 9,028 8,218 7,857
Segment Profitability Ratio
Segment profit margin1 18.93% 18.53% 18.59% 18.30% 18.48% 16.33%

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 2023 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 2,125 ÷ 11,226 = 18.93%

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

Segment Profit Margin: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment profit margin 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 earnings (loss) 4,828 4,386 4,622 4,154 3,518 2,708
Net sales 28,371 27,556 26,014 23,735 22,080 21,441
Segment Profitability Ratio
Segment profit margin1 17.02% 15.92% 17.77% 17.50% 15.93% 12.63%

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 2023 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 4,828 ÷ 28,371 = 17.02%

Segment profitability ratio Reportable segment The company
Segment profit margin Fabric & Home Care Fabric & Home Care segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Profit Margin: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment profit margin 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 earnings (loss) 3,545 3,266 3,629 3,465 2,734 2,251
Net sales 20,217 19,736 18,850 18,364 17,806 18,080
Segment Profitability Ratio
Segment profit margin1 17.53% 16.55% 19.25% 18.87% 15.35% 12.45%

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 2023 Calculation
Segment profit margin = 100 × Net earnings (loss) ÷ Net sales
= 100 × 3,545 ÷ 20,217 = 17.53%

Segment profitability ratio Reportable segment The company
Segment profit margin Baby, Feminine & Family Care Baby, Feminine & Family Care segment profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Return on Assets (Segment ROA)

Procter & Gamble Co., ROA by reportable segment

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Beauty 51.29% 52.19% 57.45% 49.48% 49.18% 49.27%
Grooming 7.09% 7.27% 6.90% 6.45% 7.32% 6.33%
Health Care 25.06% 25.43% 23.21% 21.38% 19.71% 24.42%
Fabric & Home Care 55.69% 51.20% 55.46% 53.63% 46.17% 37.12%
Baby, Feminine & Family Care 41.62% 38.68% 41.88% 40.16% 29.49% 23.25%

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

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

Segment ROA: Beauty

Procter & Gamble Co.; Beauty; segment ROA 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 earnings (loss) 3,178 3,160 3,210 2,737 2,637 2,320
Total assets 6,196 6,055 5,587 5,531 5,362 4,709
Segment Profitability Ratio
Segment ROA1 51.29% 52.19% 57.45% 49.48% 49.18% 49.27%

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 2023 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 3,178 ÷ 6,196 = 51.29%

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

Segment ROA: Grooming

Procter & Gamble Co.; Grooming; segment ROA 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 earnings (loss) 1,461 1,490 1,427 1,329 1,529 1,432
Total assets 20,601 20,482 20,668 20,589 20,882 22,609
Segment Profitability Ratio
Segment ROA1 7.09% 7.27% 6.90% 6.45% 7.32% 6.33%

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 2023 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 1,461 ÷ 20,601 = 7.09%

Segment profitability ratio Reportable segment The company
Segment ROA Grooming Grooming segment ROA improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment ROA: Health Care

Procter & Gamble Co.; Health Care; segment ROA 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 earnings (loss) 2,125 2,006 1,851 1,652 1,519 1,283
Total assets 8,480 7,888 7,976 7,726 7,708 5,254
Segment Profitability Ratio
Segment ROA1 25.06% 25.43% 23.21% 21.38% 19.71% 24.42%

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 2023 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 2,125 ÷ 8,480 = 25.06%

Segment profitability ratio Reportable segment The company
Segment ROA Health Care Health Care segment ROA improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment ROA: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment ROA 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 earnings (loss) 4,828 4,386 4,622 4,154 3,518 2,708
Total assets 8,669 8,567 8,334 7,745 7,620 7,295
Segment Profitability Ratio
Segment ROA1 55.69% 51.20% 55.46% 53.63% 46.17% 37.12%

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 2023 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 4,828 ÷ 8,669 = 55.69%

Segment profitability ratio Reportable segment The company
Segment ROA Fabric & Home Care Fabric & Home Care segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment ROA: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment ROA 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 earnings (loss) 3,545 3,266 3,629 3,465 2,734 2,251
Total assets 8,517 8,443 8,666 8,628 9,271 9,682
Segment Profitability Ratio
Segment ROA1 41.62% 38.68% 41.88% 40.16% 29.49% 23.25%

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 2023 Calculation
Segment ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × 3,545 ÷ 8,517 = 41.62%

Segment profitability ratio Reportable segment The company
Segment ROA Baby, Feminine & Family Care Baby, Feminine & Family Care segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Asset Turnover

Procter & Gamble Co., asset turnover by reportable segment

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Beauty 2.42 2.43 2.58 2.42 2.41 2.63
Grooming 0.31 0.32 0.31 0.29 0.30 0.29
Health Care 1.32 1.37 1.25 1.17 1.07 1.50
Fabric & Home Care 3.27 3.22 3.12 3.06 2.90 2.94
Baby, Feminine & Family Care 2.37 2.34 2.18 2.13 1.92 1.87

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

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

Segment Asset Turnover: Beauty

Procter & Gamble Co.; Beauty; segment asset turnover 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 15,008 14,740 14,417 13,359 12,897 12,406
Total assets 6,196 6,055 5,587 5,531 5,362 4,709
Segment Activity Ratio
Segment asset turnover1 2.42 2.43 2.58 2.42 2.41 2.63

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 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 15,008 ÷ 6,196 = 2.42

Segment activity ratio Reportable segment The company
Segment asset turnover Beauty Beauty segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Grooming

Procter & Gamble Co.; Grooming; segment asset turnover 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 6,419 6,587 6,440 6,069 6,199 6,551
Total assets 20,601 20,482 20,668 20,589 20,882 22,609
Segment Activity Ratio
Segment asset turnover1 0.31 0.32 0.31 0.29 0.30 0.29

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 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 6,419 ÷ 20,601 = 0.31

Segment activity ratio Reportable segment The company
Segment asset turnover Grooming Grooming segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment Asset Turnover: Health Care

Procter & Gamble Co.; Health Care; segment asset turnover 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 11,226 10,824 9,956 9,028 8,218 7,857
Total assets 8,480 7,888 7,976 7,726 7,708 5,254
Segment Activity Ratio
Segment asset turnover1 1.32 1.37 1.25 1.17 1.07 1.50

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 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 11,226 ÷ 8,480 = 1.32

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

Segment Asset Turnover: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment asset turnover 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 28,371 27,556 26,014 23,735 22,080 21,441
Total assets 8,669 8,567 8,334 7,745 7,620 7,295
Segment Activity Ratio
Segment asset turnover1 3.27 3.22 3.12 3.06 2.90 2.94

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 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 28,371 ÷ 8,669 = 3.27

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

Segment Asset Turnover: Baby, Feminine & Family Care

Procter & Gamble Co.; Baby, Feminine & Family Care; segment asset turnover 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 20,217 19,736 18,850 18,364 17,806 18,080
Total assets 8,517 8,443 8,666 8,628 9,271 9,682
Segment Activity Ratio
Segment asset turnover1 2.37 2.34 2.18 2.13 1.92 1.87

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 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 20,217 ÷ 8,517 = 2.37

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

Segment Capital Expenditures to Depreciation

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

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Beauty 0.76 0.95 1.16 1.24 2.33 3.25
Grooming 0.90 0.72 0.77 0.75 0.86 0.81
Health Care 1.32 1.09 0.98 0.97 1.23 1.43
Fabric & Home Care 1.45 1.47 1.56 1.47 1.77 1.91
Baby, Feminine & Family Care 1.24 1.13 0.96 0.91 0.95 1.13

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

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

Segment Capital Expenditures to Depreciation: Beauty

Procter & Gamble Co.; Beauty; segment capital expenditures to depreciation 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)
Capital expenditures 287 331 386 397 634 766
Depreciation and amortization 376 348 333 320 272 236
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.76 0.95 1.16 1.24 2.33 3.25

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 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 287 ÷ 376 = 0.76

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

Segment Capital Expenditures to Depreciation: Grooming

Procter & Gamble Co.; Grooming; segment capital expenditures to depreciation 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)
Capital expenditures 300 260 291 305 367 364
Depreciation and amortization 335 361 378 406 429 447
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.90 0.72 0.77 0.75 0.86 0.81

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 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 300 ÷ 335 = 0.90

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Grooming Grooming segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Capital Expenditures to Depreciation: Health Care

Procter & Gamble Co.; Health Care; segment capital expenditures to depreciation 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)
Capital expenditures 466 410 364 338 363 330
Depreciation and amortization 352 376 372 350 294 230
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.32 1.09 0.98 0.97 1.23 1.43

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 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 466 ÷ 352 = 1.32

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

Segment Capital Expenditures to Depreciation: Fabric & Home Care

Procter & Gamble Co.; Fabric & Home Care; segment capital expenditures to depreciation 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)
Capital expenditures 979 988 1,006 887 984 1,020
Depreciation and amortization 675 672 646 605 557 534
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.45 1.47 1.56 1.47 1.77 1.91

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 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 979 ÷ 675 = 1.45

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 2021 to 2022 and from 2022 to 2023.

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, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Capital expenditures 994 932 814 764 819 1,016
Depreciation and amortization 804 826 846 839 861 899
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.24 1.13 0.96 0.91 0.95 1.13

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 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 994 ÷ 804 = 1.24

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 2021 to 2022 and from 2022 to 2023.

Net sales

Procter & Gamble Co., net sales by reportable segment

US$ in millions

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

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


Net earnings (loss)

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

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Beauty 3,178 3,160 3,210 2,737 2,637 2,320
Grooming 1,461 1,490 1,427 1,329 1,529 1,432
Health Care 2,125 2,006 1,851 1,652 1,519 1,283
Fabric & Home Care 4,828 4,386 4,622 4,154 3,518 2,708
Baby, Feminine & Family Care 3,545 3,266 3,629 3,465 2,734 2,251
Corporate (399) 485 (387) (234) (7,971) (133)
Total 14,738 14,793 14,352 13,103 3,966 9,861

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


Depreciation and amortization

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

US$ in millions

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

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


Total assets

Procter & Gamble Co., total assets by reportable segment

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Beauty 6,196 6,055 5,587 5,531 5,362 4,709
Grooming 20,601 20,482 20,668 20,589 20,882 22,609
Health Care 8,480 7,888 7,976 7,726 7,708 5,254
Fabric & Home Care 8,669 8,567 8,334 7,745 7,620 7,295
Baby, Feminine & Family Care 8,517 8,443 8,666 8,628 9,271 9,682
Corporate 68,366 65,773 68,076 70,481 64,252 68,761
Total 120,829 117,208 119,307 120,700 115,095 118,310

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


Capital expenditures

Procter & Gamble Co., capital expenditures by reportable segment

US$ in millions

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

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