Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Common-Size Income Statement
Quarterly Data

Walmart Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: Jul 31, 2024 Apr 30, 2024 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
Net sales 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -75.59 -75.92 -76.68 -76.01 -76.02 -76.34 -77.07 -76.33 -76.52 -76.16 -76.24 -75.44 -75.20 -75.29 -76.34 -75.02 -75.05 -76.33 -76.63 -75.52 -75.68 -75.67 -76.16 -75.16 -75.22 -75.40
Gross profit 24.41% 24.08% 23.32% 23.99% 23.98% 23.66% 22.93% 23.67% 23.48% 23.84% 23.76% 24.56% 24.80% 24.71% 23.66% 24.98% 24.95% 23.67% 23.37% 24.48% 24.32% 24.33% 23.84% 24.84% 24.78% 24.60%
Membership and other income 0.93 0.98 0.86 0.86 0.84 0.86 0.80 0.89 0.98 0.91 0.89 0.95 0.84 0.84 0.72 0.71 0.67 0.71 0.76 0.80 0.76 0.79 0.76 0.80 0.76 0.87
Operating, selling, general and administrative expenses -20.61 -20.78 -19.96 -20.96 -20.26 -20.38 -20.32 -22.78 -19.93 -20.96 -20.76 -21.34 -20.38 -20.51 -20.75 -21.38 -21.19 -20.48 -20.34 -21.56 -20.77 -21.10 -20.20 -21.62 -21.02 -21.24
Operating income 4.73% 4.28% 4.22% 3.89% 4.56% 4.13% 3.42% 1.78% 4.53% 3.79% 3.89% 4.16% 5.26% 5.04% 3.63% 4.32% 4.43% 3.91% 3.78% 3.72% 4.31% 4.02% 4.40% 4.02% 4.53% 4.24%
Interest expense, debt and finance lease -0.40 -0.45 -0.40 -0.43 -0.40 -0.44 -0.37 -0.39 -0.32 -0.32 -0.28 -0.35 -0.37 -0.41 -0.35 -0.40 -0.48 -0.44 -0.46 -0.50 -0.50 -0.55 -0.49 -0.48 -0.44 -0.44
Interest income 0.07 0.07 0.08 0.09 0.09 0.07 0.06 0.06 0.02 0.03 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.03 0.03 0.03 0.04 0.04 0.05 0.05 0.04 0.04
Interest, net -0.34% -0.38% -0.32% -0.34% -0.31% -0.37% -0.31% -0.33% -0.30% -0.30% -0.25% -0.32% -0.34% -0.39% -0.33% -0.39% -0.46% -0.41% -0.43% -0.46% -0.45% -0.51% -0.44% -0.43% -0.40% -0.40%
Loss on extinguishment of debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other gains and (losses) -0.69 0.50 0.47 -2.98 2.44 -1.98 2.36 -2.39 0.16 -1.42 -0.48 0.87 -0.68 -1.84 -3.70 1.39 2.35 0.54 0.68 0.19 -0.07 0.68 0.15 -1.51 -3.82 -1.52
Income (loss) before income taxes 3.70% 4.40% 4.37% 0.57% 6.69% 1.78% 5.47% -0.94% 4.39% 2.07% 3.16% 2.98% 4.23% 2.80% -0.39% 5.32% 6.32% 4.04% 4.03% 3.44% 3.80% 4.19% 4.11% 2.08% 0.31% 2.32%
Provision for income taxes -0.90 -1.08 -1.07 -0.17 -1.67 -0.52 -1.90 -0.22 -0.99 -0.57 -0.76 -0.73 -1.11 -0.75 -0.94 -1.43 -1.61 -0.99 -0.98 -0.83 -0.95 -1.02 -1.34 -0.61 -0.89 -0.45
Consolidated net income (loss) 2.81% 3.32% 3.30% 0.40% 5.02% 1.26% 3.57% -1.17% 3.40% 1.50% 2.40% 2.25% 3.12% 2.05% -1.33% 3.89% 4.71% 3.05% 3.05% 2.62% 2.84% 3.18% 2.77% 1.47% -0.57% 1.87%
Consolidated net (income) loss attributable to noncontrolling interest -0.13 -0.13 -0.11 -0.12 -0.10 -0.15 0.29 -0.02 0.00 -0.03 -0.05 -0.02 -0.06 -0.06 -0.05 -0.05 0.03 -0.06 -0.11 -0.03 -0.05 -0.05 -0.09 -0.09 -0.11 -0.12
Consolidated net income (loss) attributable to Walmart 2.68% 3.19% 3.20% 0.28% 4.92% 1.11% 3.86% -1.19% 3.40% 1.46% 2.35% 2.23% 3.06% 1.99% -1.38% 3.84% 4.73% 2.98% 2.95% 2.59% 2.79% 3.12% 2.68% 1.38% -0.68% 1.75%

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 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).

Income statement item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Walmart Inc. operating income as a percentage of net sales increased from Q4 2024 to Q1 2025 and from Q1 2025 to Q2 2025.
Income (loss) before income taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. Walmart Inc. income (loss) before income taxes as a percentage of net sales increased from Q4 2024 to Q1 2025 but then decreased significantly from Q1 2025 to Q2 2025.
Consolidated net income (loss) attributable to Walmart The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Walmart Inc. consolidated net income (loss) attributable to Walmart as a percentage of net sales decreased from Q4 2024 to Q1 2025 and from Q1 2025 to Q2 2025.