Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Profitability Ratios
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Walmart Inc., profitability ratios (quarterly data)

Microsoft Excel
Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018
Return on Sales
Gross profit margin 23.73% 23.64% 23.55% 23.43% 23.46% 23.68% 23.90% 24.23% 24.44% 24.41% 24.51% 24.55% 24.30% 24.24% 24.11% 23.94% 24.10% 24.23% 24.32% 24.43% 24.50%
Operating profit margin 4.20% 4.00% 3.49% 3.46% 3.37% 3.49% 4.10% 4.27% 4.57% 4.50% 4.54% 4.34% 4.06% 4.11% 3.96% 3.93% 3.96% 4.12% 4.20% 4.25% 4.30%
Net profit margin 2.41% 2.57% 2.24% 1.83% 1.93% 1.51% 2.38% 2.28% 2.41% 1.41% 1.79% 2.19% 2.43% 3.62% 3.33% 2.83% 2.86% 2.79% 2.50% 1.64% 1.31%
Return on Investment
Return on equity (ROE) 18.50% 20.50% 17.65% 15.61% 15.23% 12.41% 17.88% 16.90% 16.42% 9.75% 12.48% 15.64% 16.69% 24.24% 23.76% 22.02% 19.93% 20.14% 18.27% 12.28% 9.20%
Return on assets (ROA) 6.15% 6.29% 5.50% 4.61% 4.80% 3.62% 5.61% 5.28% 5.58% 3.28% 4.21% 5.18% 5.35% 7.87% 7.54% 6.45% 6.29% 6.02% 5.47% 3.57% 3.04%

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

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Walmart Inc. gross profit margin ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Walmart Inc. operating profit margin ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Walmart Inc. net profit margin ratio improved from Q2 2024 to Q3 2024 but then slightly deteriorated from Q3 2024 to Q4 2024.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Walmart Inc. ROE improved from Q2 2024 to Q3 2024 but then slightly deteriorated from Q3 2024 to Q4 2024 not reaching Q2 2024 level.
ROA A profitability ratio calculated as net income divided by total assets. Walmart Inc. ROA improved from Q2 2024 to Q3 2024 but then slightly deteriorated from Q3 2024 to Q4 2024.

Gross Profit Margin

Walmart Inc., gross profit margin calculation (quarterly data)

Microsoft Excel
Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018
Selected Financial Data (US$ in millions)
Gross profit 40,089 38,256 38,430 35,720 37,320 35,856 35,543 33,441 36,003 34,184 34,688 33,887 35,724 33,413 34,135 31,646 32,860 31,081 31,465 29,915 32,836 30,781 31,488 29,923
Net sales 171,914 159,439 160,280 151,004 162,743 151,469 151,381 140,288 151,525 139,207 139,871 137,159 150,985 133,752 136,824 133,672 140,608 126,981 129,388 122,949 137,743 123,897 127,059 121,630
Profitability Ratio
Gross profit margin1 23.73% 23.64% 23.55% 23.43% 23.46% 23.68% 23.90% 24.23% 24.44% 24.41% 24.51% 24.55% 24.30% 24.24% 24.11% 23.94% 24.10% 24.23% 24.32% 24.43% 24.50%
Benchmarks
Gross Profit Margin, Competitors2
Costco Wholesale Corp. 10.69% 10.67% 10.57% 10.44% 10.41% 10.39% 10.48% 10.71% 10.94% 11.02% 11.13% 11.23% 11.30% 11.32% 11.20% 11.15% 11.02% 11.09% 11.02% 10.98% 11.00% 10.92%
Target Corp. 26.53% 25.67% 25.02% 23.72% 23.57% 24.41% 25.21% 27.33% 28.34% 28.73% 29.33% 29.44% 28.38% 28.32% 28.03% 27.78% 28.87% 28.70% 28.46% 28.37% 28.39%

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

1 Q4 2024 Calculation
Gross profit margin = 100 × (Gross profitQ4 2024 + Gross profitQ3 2024 + Gross profitQ2 2024 + Gross profitQ1 2024) ÷ (Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024)
= 100 × (40,089 + 38,256 + 38,430 + 35,720) ÷ (171,914 + 159,439 + 160,280 + 151,004) = 23.73%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Walmart Inc. gross profit margin ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Operating Profit Margin

Walmart Inc., operating profit margin calculation (quarterly data)

Microsoft Excel
Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018
Selected Financial Data (US$ in millions)
Operating income 7,254 6,202 7,316 6,240 5,561 2,695 6,854 5,318 5,887 5,792 7,354 6,909 5,487 5,778 6,059 5,224 5,322 4,718 5,583 4,945 6,067 4,986 5,750 5,154
Net sales 171,914 159,439 160,280 151,004 162,743 151,469 151,381 140,288 151,525 139,207 139,871 137,159 150,985 133,752 136,824 133,672 140,608 126,981 129,388 122,949 137,743 123,897 127,059 121,630
Profitability Ratio
Operating profit margin1 4.20% 4.00% 3.49% 3.46% 3.37% 3.49% 4.10% 4.27% 4.57% 4.50% 4.54% 4.34% 4.06% 4.11% 3.96% 3.93% 3.96% 4.12% 4.20% 4.25% 4.30%
Benchmarks
Operating Profit Margin, Competitors2
Costco Wholesale Corp. 3.48% 3.46% 3.41% 3.39% 3.45% 3.46% 3.50% 3.55% 3.61% 3.50% 3.49% 3.48% 3.36% 3.43% 3.33% 3.16% 3.17% 3.21% 3.17% 3.23% 3.24% 3.16%
Target Corp. 5.39% 4.75% 4.42% 3.56% 3.58% 4.46% 5.43% 7.50% 8.55% 8.52% 8.70% 8.71% 7.08% 6.74% 5.94% 5.05% 6.04% 5.97% 5.79% 5.58% 5.52%

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

1 Q4 2024 Calculation
Operating profit margin = 100 × (Operating incomeQ4 2024 + Operating incomeQ3 2024 + Operating incomeQ2 2024 + Operating incomeQ1 2024) ÷ (Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024)
= 100 × (7,254 + 6,202 + 7,316 + 6,240) ÷ (171,914 + 159,439 + 160,280 + 151,004) = 4.20%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Walmart Inc. operating profit margin ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Net Profit Margin

Walmart Inc., net profit margin calculation (quarterly data)

Microsoft Excel
Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018
Selected Financial Data (US$ in millions)
Consolidated net income (loss) attributable to Walmart 5,494 453 7,891 1,673 6,275 (1,798) 5,149 2,054 3,562 3,105 4,276 2,730 (2,091) 5,135 6,476 3,990 4,141 3,288 3,610 3,842 3,687 1,710 (861) 2,134
Net sales 171,914 159,439 160,280 151,004 162,743 151,469 151,381 140,288 151,525 139,207 139,871 137,159 150,985 133,752 136,824 133,672 140,608 126,981 129,388 122,949 137,743 123,897 127,059 121,630
Profitability Ratio
Net profit margin1 2.41% 2.57% 2.24% 1.83% 1.93% 1.51% 2.38% 2.28% 2.41% 1.41% 1.79% 2.19% 2.43% 3.62% 3.33% 2.83% 2.86% 2.79% 2.50% 1.64% 1.31%
Benchmarks
Net Profit Margin, Competitors2
Costco Wholesale Corp. 2.78% 2.70% 2.65% 2.60% 2.63% 2.59% 2.62% 2.65% 2.67% 2.59% 2.61% 2.58% 2.48% 2.55% 2.45% 2.36% 2.44% 2.47% 2.45% 2.46% 2.40% 2.30%
Target Corp. 3.91% 3.45% 3.17% 2.53% 2.58% 3.22% 3.97% 5.55% 6.64% 6.65% 6.37% 6.38% 4.73% 4.37% 4.21% 3.50% 4.25% 4.23% 4.15% 4.00% 3.95%

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

1 Q4 2024 Calculation
Net profit margin = 100 × (Consolidated net income (loss) attributable to WalmartQ4 2024 + Consolidated net income (loss) attributable to WalmartQ3 2024 + Consolidated net income (loss) attributable to WalmartQ2 2024 + Consolidated net income (loss) attributable to WalmartQ1 2024) ÷ (Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024)
= 100 × (5,494 + 453 + 7,891 + 1,673) ÷ (171,914 + 159,439 + 160,280 + 151,004) = 2.41%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Walmart Inc. net profit margin ratio improved from Q2 2024 to Q3 2024 but then slightly deteriorated from Q3 2024 to Q4 2024.

Return on Equity (ROE)

Walmart Inc., ROE calculation (quarterly data)

Microsoft Excel
Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018
Selected Financial Data (US$ in millions)
Consolidated net income (loss) attributable to Walmart 5,494 453 7,891 1,673 6,275 (1,798) 5,149 2,054 3,562 3,105 4,276 2,730 (2,091) 5,135 6,476 3,990 4,141 3,288 3,610 3,842 3,687 1,710 (861) 2,134
Total Walmart shareholders’ equity 83,861 79,456 79,556 72,405 76,693 72,253 77,569 76,896 83,253 82,274 80,529 78,335 80,925 81,431 75,310 68,240 74,669 71,649 70,327 68,205 72,496 71,996 71,185 75,552
Profitability Ratio
ROE1 18.50% 20.50% 17.65% 15.61% 15.23% 12.41% 17.88% 16.90% 16.42% 9.75% 12.48% 15.64% 16.69% 24.24% 23.76% 22.02% 19.93% 20.14% 18.27% 12.28% 9.20%
Benchmarks
ROE, Competitors2
Costco Wholesale Corp. 32.73% 24.92% 25.11% 25.46% 26.55% 27.40% 28.31% 28.28% 28.39% 27.97% 28.51% 28.67% 27.75% 29.10% 21.89% 22.08% 22.74% 23.55% 24.00% 24.89% 24.89% 24.77%
Target Corp. 30.81% 29.02% 28.13% 23.45% 24.75% 31.29% 39.88% 54.37% 54.15% 49.13% 42.45% 41.32% 30.25% 28.70% 28.00% 24.80% 27.73% 28.11% 26.64% 27.11% 26.00%

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

1 Q4 2024 Calculation
ROE = 100 × (Consolidated net income (loss) attributable to WalmartQ4 2024 + Consolidated net income (loss) attributable to WalmartQ3 2024 + Consolidated net income (loss) attributable to WalmartQ2 2024 + Consolidated net income (loss) attributable to WalmartQ1 2024) ÷ Total Walmart shareholders’ equity
= 100 × (5,494 + 453 + 7,891 + 1,673) ÷ 83,861 = 18.50%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Walmart Inc. ROE improved from Q2 2024 to Q3 2024 but then slightly deteriorated from Q3 2024 to Q4 2024 not reaching Q2 2024 level.

Return on Assets (ROA)

Walmart Inc., ROA calculation (quarterly data)

Microsoft Excel
Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018
Selected Financial Data (US$ in millions)
Consolidated net income (loss) attributable to Walmart 5,494 453 7,891 1,673 6,275 (1,798) 5,149 2,054 3,562 3,105 4,276 2,730 (2,091) 5,135 6,476 3,990 4,141 3,288 3,610 3,842 3,687 1,710 (861) 2,134
Total assets 252,399 259,174 255,121 245,053 243,197 247,656 247,199 246,142 244,860 244,851 238,552 236,581 252,496 250,863 237,382 232,892 236,495 239,830 234,861 234,544 219,295 226,583 206,062 204,927
Profitability Ratio
ROA1 6.15% 6.29% 5.50% 4.61% 4.80% 3.62% 5.61% 5.28% 5.58% 3.28% 4.21% 5.18% 5.35% 7.87% 7.54% 6.45% 6.29% 6.02% 5.47% 3.57% 3.04%
Benchmarks
ROA, Competitors2
Costco Wholesale Corp. 10.24% 8.84% 9.12% 8.99% 9.05% 8.91% 9.11% 8.84% 8.74% 8.05% 8.45% 8.25% 7.91% 7.18% 7.20% 7.17% 7.74% 7.26% 8.06% 8.24% 8.06% 7.44%
Target Corp. 7.48% 6.46% 6.34% 5.22% 5.21% 6.20% 8.05% 11.52% 12.91% 12.46% 12.28% 12.25% 8.52% 7.54% 7.34% 6.18% 7.67% 7.42% 7.59% 7.42% 7.11%

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

1 Q4 2024 Calculation
ROA = 100 × (Consolidated net income (loss) attributable to WalmartQ4 2024 + Consolidated net income (loss) attributable to WalmartQ3 2024 + Consolidated net income (loss) attributable to WalmartQ2 2024 + Consolidated net income (loss) attributable to WalmartQ1 2024) ÷ Total assets
= 100 × (5,494 + 453 + 7,891 + 1,673) ÷ 252,399 = 6.15%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Walmart Inc. ROA improved from Q2 2024 to Q3 2024 but then slightly deteriorated from Q3 2024 to Q4 2024.