Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Walmart Inc., profit margin by reportable segment

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 5.01% 4.90% 5.49% 5.17% 5.10% 5.24%
Walmart International 4.28% 2.94% 3.72% 3.02% 2.81% 4.04%
Sam’s Club 2.54% 2.33% 3.07% 2.98% 2.79% 2.63%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Walmart U.S. Walmart U.S. segment profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.
Walmart International Walmart International segment profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Sam’s Club Sam’s Club segment profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Segment Profit Margin: Walmart U.S.

Walmart Inc.; Walmart U.S.; segment profit margin calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Operating income (loss) 22,154 20,620 21,587 19,116 17,380 17,386
Net sales 441,817 420,553 393,247 369,963 341,004 331,666
Segment Profitability Ratio
Segment profit margin1 5.01% 4.90% 5.49% 5.17% 5.10% 5.24%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment profit margin = 100 × Operating income (loss) ÷ Net sales
= 100 × 22,154 ÷ 441,817 = 5.01%

Segment profitability ratio Reportable segment The company
Segment profit margin Walmart U.S. Walmart U.S. segment profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Segment Profit Margin: Walmart International

Walmart Inc.; Walmart International; segment profit margin calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Operating income (loss) 4,909 2,965 3,758 3,660 3,370 4,883
Net sales 114,641 100,983 100,959 121,360 120,130 120,824
Segment Profitability Ratio
Segment profit margin1 4.28% 2.94% 3.72% 3.02% 2.81% 4.04%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment profit margin = 100 × Operating income (loss) ÷ Net sales
= 100 × 4,909 ÷ 114,641 = 4.28%

Segment profitability ratio Reportable segment The company
Segment profit margin Walmart International Walmart International segment profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Profit Margin: Sam’s Club

Walmart Inc.; Sam’s Club; segment profit margin calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Operating income (loss) 2,192 1,964 2,259 1,906 1,642 1,520
Net sales 86,179 84,345 73,556 63,910 58,792 57,839
Segment Profitability Ratio
Segment profit margin1 2.54% 2.33% 3.07% 2.98% 2.79% 2.63%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment profit margin = 100 × Operating income (loss) ÷ Net sales
= 100 × 2,192 ÷ 86,179 = 2.54%

Segment profitability ratio Reportable segment The company
Segment profit margin Sam’s Club Sam’s Club segment profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Segment Return on Assets (Segment ROA)

Walmart Inc., ROA by reportable segment

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 16.08% 15.78% 17.26% 16.84% 15.75% 16.54%
Walmart International 5.70% 3.42% 4.11% 3.34% 3.18% 5.03%
Sam’s Club 13.98% 12.68% 15.39% 14.21% 12.17% 11.79%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

Segment profitability ratio Reportable segment The company
Segment ROA Walmart U.S. Walmart U.S. segment ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.
Walmart International Walmart International segment ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Sam’s Club Sam’s Club segment ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Segment ROA: Walmart U.S.

Walmart Inc.; Walmart U.S.; segment ROA calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Operating income (loss) 22,154 20,620 21,587 19,116 17,380 17,386
Total assets 137,782 130,659 125,044 113,490 110,353 105,114
Segment Profitability Ratio
Segment ROA1 16.08% 15.78% 17.26% 16.84% 15.75% 16.54%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment ROA = 100 × Operating income (loss) ÷ Total assets
= 100 × 22,154 ÷ 137,782 = 16.08%

Segment profitability ratio Reportable segment The company
Segment ROA Walmart U.S. Walmart U.S. segment ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Segment ROA: Walmart International

Walmart Inc.; Walmart International; segment ROA calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Operating income (loss) 4,909 2,965 3,758 3,660 3,370 4,883
Total assets 86,136 86,766 91,403 109,445 105,811 97,066
Segment Profitability Ratio
Segment ROA1 5.70% 3.42% 4.11% 3.34% 3.18% 5.03%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment ROA = 100 × Operating income (loss) ÷ Total assets
= 100 × 4,909 ÷ 86,136 = 5.70%

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

Segment ROA: Sam’s Club

Walmart Inc.; Sam’s Club; segment ROA calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Operating income (loss) 2,192 1,964 2,259 1,906 1,642 1,520
Total assets 15,682 15,490 14,678 13,415 13,494 12,893
Segment Profitability Ratio
Segment ROA1 13.98% 12.68% 15.39% 14.21% 12.17% 11.79%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment ROA = 100 × Operating income (loss) ÷ Total assets
= 100 × 2,192 ÷ 15,682 = 13.98%

Segment profitability ratio Reportable segment The company
Segment ROA Sam’s Club Sam’s Club segment ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Segment Asset Turnover

Walmart Inc., asset turnover by reportable segment

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 3.21 3.22 3.14 3.26 3.09 3.16
Walmart International 1.33 1.16 1.10 1.11 1.14 1.24
Sam’s Club 5.50 5.45 5.01 4.76 4.36 4.49

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

Segment activity ratio Reportable segment The company
Segment asset turnover Walmart U.S. Walmart U.S. segment asset turnover ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
Walmart International Walmart International segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Sam’s Club Sam’s Club segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Asset Turnover: Walmart U.S.

Walmart Inc.; Walmart U.S.; segment asset turnover calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Net sales 441,817 420,553 393,247 369,963 341,004 331,666
Total assets 137,782 130,659 125,044 113,490 110,353 105,114
Segment Activity Ratio
Segment asset turnover1 3.21 3.22 3.14 3.26 3.09 3.16

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 441,817 ÷ 137,782 = 3.21

Segment activity ratio Reportable segment The company
Segment asset turnover Walmart U.S. Walmart U.S. segment asset turnover ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Segment Asset Turnover: Walmart International

Walmart Inc.; Walmart International; segment asset turnover calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Net sales 114,641 100,983 100,959 121,360 120,130 120,824
Total assets 86,136 86,766 91,403 109,445 105,811 97,066
Segment Activity Ratio
Segment asset turnover1 1.33 1.16 1.10 1.11 1.14 1.24

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 114,641 ÷ 86,136 = 1.33

Segment activity ratio Reportable segment The company
Segment asset turnover Walmart International Walmart International segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Asset Turnover: Sam’s Club

Walmart Inc.; Sam’s Club; segment asset turnover calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Net sales 86,179 84,345 73,556 63,910 58,792 57,839
Total assets 15,682 15,490 14,678 13,415 13,494 12,893
Segment Activity Ratio
Segment asset turnover1 5.50 5.45 5.01 4.76 4.36 4.49

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 86,179 ÷ 15,682 = 5.50

Segment activity ratio Reportable segment The company
Segment asset turnover Sam’s Club Sam’s Club segment asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation

Walmart Inc., capital expenditures to depreciation by reportable segment

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 1.81 1.62 1.25 0.93 0.99 0.97
Walmart International 1.35 1.34 1.27 0.93 1.04 1.03
Sam’s Club 1.62 1.19 1.03 0.81 0.87 0.70

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Walmart U.S. Walmart U.S. segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.
Walmart International Walmart International segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.
Sam’s Club Sam’s Club segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation: Walmart U.S.

Walmart Inc.; Walmart U.S.; segment capital expenditures to depreciation calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 13,877 11,425 8,475 6,131 6,315 6,034
Depreciation and amortization 7,671 7,054 6,773 6,561 6,408 6,201
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.81 1.62 1.25 0.93 0.99 0.97

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 13,877 ÷ 7,671 = 1.81

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

Segment Capital Expenditures to Depreciation: Walmart International

Walmart Inc.; Walmart International; segment capital expenditures to depreciation calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 2,911 2,625 2,497 2,436 2,801 2,661
Depreciation and amortization 2,159 1,964 1,963 2,633 2,682 2,590
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.35 1.34 1.27 0.93 1.04 1.03

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 2,911 ÷ 2,159 = 1.35

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

Segment Capital Expenditures to Depreciation: Sam’s Club

Walmart Inc.; Sam’s Club; segment capital expenditures to depreciation calculation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 1,041 727 622 488 525 450
Depreciation and amortization 642 609 601 599 605 639
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.62 1.19 1.03 0.81 0.87 0.70

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization
= 1,041 ÷ 642 = 1.62

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Sam’s Club Sam’s Club segment capital expenditures to depreciation ratio improved from 2022 to 2023 and from 2023 to 2024.

Net sales

Walmart Inc., net sales by reportable segment

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 441,817 420,553 393,247 369,963 341,004 331,666
Walmart International 114,641 100,983 100,959 121,360 120,130 120,824
Sam’s Club 86,179 84,345 73,556 63,910 58,792 57,839
Consolidated 642,637 605,881 567,762 555,233 519,926 510,329

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).


Operating income (loss)

Walmart Inc., operating income (loss) by reportable segment

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 22,154 20,620 21,587 19,116 17,380 17,386
Walmart International 4,909 2,965 3,758 3,660 3,370 4,883
Sam’s Club 2,192 1,964 2,259 1,906 1,642 1,520
Corporate and support (2,243) (5,121) (1,662) (2,134) (1,824) (1,832)
Consolidated 27,012 20,428 25,942 22,548 20,568 21,957

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).


Total assets

Walmart Inc., total assets by reportable segment

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 137,782 130,659 125,044 113,490 110,353 105,114
Walmart International 86,136 86,766 91,403 109,445 105,811 97,066
Sam’s Club 15,682 15,490 14,678 13,415 13,494 12,893
Corporate and support 12,799 10,282 13,735 16,146 6,837 4,222
Consolidated 252,399 243,197 244,860 252,496 236,495 219,295

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).


Depreciation and amortization

Walmart Inc., depreciation and amortization by reportable segment

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 7,671 7,054 6,773 6,561 6,408 6,201
Walmart International 2,159 1,964 1,963 2,633 2,682 2,590
Sam’s Club 642 609 601 599 605 639
Corporate and support 1,381 1,318 1,321 1,359 1,292 1,248
Consolidated 11,853 10,945 10,658 11,152 10,987 10,678

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).


Capital expenditures

Walmart Inc., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Walmart U.S. 13,877 11,425 8,475 6,131 6,315 6,034
Walmart International 2,911 2,625 2,497 2,436 2,801 2,661
Sam’s Club 1,041 727 622 488 525 450
Corporate and support 2,777 2,080 1,512 1,209 1,064 1,199
Consolidated 20,606 16,857 13,106 10,264 10,705 10,344

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31).