Stock Analysis on Net
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, 2025 Apr 30, 2025 Jan 31, 2025 Oct 31, 2024 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
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.55 -75.80 -76.15 -75.80 -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
Gross profit 24.45% 24.20% 23.85% 24.20% 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%
Membership and other income 0.94 0.99 0.96 0.94 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
Operating, selling, general and administrative expenses -21.25 -20.84 -20.42 -21.15 -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
Operating income 4.15% 4.35% 4.39% 3.99% 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%
Interest expense, debt and finance lease -0.44 -0.39 -0.40 -0.37 -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
Interest income 0.05 0.06 0.06 0.08 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
Interest, net -0.38% -0.33% -0.34% -0.28% -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%
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 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
Other gains and (losses) 1.54 -0.36 -0.16 -0.08 -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
Income (loss) before income taxes 5.30% 3.66% 3.89% 3.63% 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%
Provision for income taxes -1.23 -0.83 -0.86 -0.82 -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
Consolidated net income (loss) 4.07% 2.83% 3.03% 2.81% 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%
Consolidated net (income) loss attributable to noncontrolling interest -0.07 -0.09 -0.10 -0.08 -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
Consolidated net income (loss) attributable to Walmart 4.00% 2.74% 2.94% 2.72% 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%

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

Cost of Sales
The cost of sales as a percentage of net sales generally fluctuates around -75% to -77% throughout the periods. There is a slight upward trend in the cost of sales percentage during some quarters, peaking near -77.07% in January 2023, after which it tends to slightly moderate but remains within the clustered range of approximately -75.5% to -76.8%.
Gross Profit
Gross profit margins exhibit a complementary pattern to cost of sales, ranging mostly between 22.9% and 24.9%. There is a notable dip in gross profit percentage in early 2023, reaching a low of approximately 22.93%, followed by a subtle recovery towards 24.4% in more recent periods. Overall, gross profit margins remain fairly stable with minor fluctuations.
Membership and Other Income
This income source shows a modest but consistent increase over time, generally fluctuating between 0.7% and 1.0%. It peaks near 0.99% by April 2025, indicating a strengthening contribution to overall net sales from membership and similar income streams.
Operating, Selling, General and Administrative Expenses
Operating expenses expressed as a percentage of net sales remain relatively stable, mostly ranging between -19.9% and -22.8%. There is a notable spike to -22.78% in October 2022, followed by a return to lower levels around -20.4% to -21.3%. The data indicates effective cost control with occasional spikes.
Operating Income
Operating income margins fluctuate between approximately 1.78% and 5.26%. There is a significant drop to 1.78% in October 2022, corresponding with peak operating expenses, but it recovers in subsequent quarters. The highest operating income margin occurs in July 2021 at 5.26%, suggesting periods of improved operational efficiency or revenue gains.
Interest Expense and Net Interest
Interest expense percentages vary moderately between -0.44% and -0.28%, reflecting a relatively stable cost of debt over time. Net interest remains consistently negative but improves slightly in some quarters, reaching approximately -0.25% in January 2022. Interest income shows a minor upward trend, reaching up to 0.09%, which partially offsets interest expenses.
Other Gains and Losses
Other gains and losses demonstrate considerable volatility, oscillating between positive contributions as high as 2.44% and negative impacts nearing -3.7%. This high variability reflects occasional one-time gains or write-downs affecting pre-tax income significantly in several quarters.
Income Before Income Taxes
Pre-tax income margins vary widely, with a range from a negative -0.39% in January 2021 to highs around 6.69% in July 2023. This variation aligns with swings in operating income and other gains/losses, showing periods of profitability and brief intervals of reduced profitability or slight losses.
Provision for Income Taxes
The provision for income taxes generally ranges between -0.22% and -1.90% of net sales, with occasional lower values coinciding with reduced pre-tax income. The periods of lower tax rates correspond with quarters where income before taxes was depressed, indicating a tax expense somewhat proportional to earnings.
Consolidated Net Income
Net income as a percentage of net sales reflects the overarching profitability trend, fluctuating between -1.38% and 5.02%. The lowest point occurs around January 2021, coinciding with negative income before taxes, while the highest occurs near July 2023. Generally, net income follows the trend of operating income and other income adjustments, confirming recurring profitability with occasional setbacks.
Net Income Attributable to Walmart
The net income attributable to Walmart mirrors consolidated net income trends, ranging from -1.38% to 4.92%. This consistency indicates that the majority of net income effects are attributable directly to the parent company, with only minor fluctuations due to noncontrolling interests which remain minimal.