Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Financial Reporting Quality: Aggregate Accruals 

Microsoft Excel

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

Walmart Inc., balance sheet computation of aggregate accruals

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Operating Assets
Total assets 252,399 243,197 244,860 252,496 236,495 219,295
Less: Cash and cash equivalents 9,867 8,625 14,760 17,741 9,465 7,722
Operating assets 242,532 234,572 230,100 234,755 227,030 211,573
Operating Liabilities
Total liabilities 161,828 159,206 152,969 164,965 154,943 139,661
Less: Short-term borrowings 878 372 410 224 575 5,225
Less: Long-term debt due within one year 3,447 4,191 2,803 3,115 5,362 1,876
Less: Finance lease obligations due within one year 725 567 511 491 511 729
Less: Long-term debt, excluding due within one year 36,132 34,649 34,864 41,194 43,714 43,520
Less: Long-term finance lease obligations, excluding due within one year 5,709 4,843 4,243 3,847 4,307 6,683
Operating liabilities 114,937 114,584 110,138 116,094 100,474 81,628
 
Net operating assets1 127,595 119,988 119,962 118,661 126,556 129,945
Balance-sheet-based aggregate accruals2 7,607 26 1,301 (7,895) (3,389)
Financial Ratio
Balance-sheet-based accruals ratio3 6.15% 0.02% 1.09% -6.44% -2.64%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Costco Wholesale Corp. 11.49% -0.39% 20.71% 5.32% 2.31%
Target Corp. 2.06% 19.69% 10.33% -10.90% -1.25%
Balance-Sheet-Based Accruals Ratio, Sector
Consumer Staples Distribution & Retail 0.00% 2.78% 4.30% -5.94% -2.05%
Balance-Sheet-Based Accruals Ratio, Industry
Consumer Staples 0.00% 3.35% 6.31% -1.72% -0.98%

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
Net operating assets = Operating assets – Operating liabilities
= 242,532114,937 = 127,595

2 2024 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2024 – Net operating assets2023
= 127,595119,988 = 7,607

3 2024 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 7,607 ÷ [(127,595 + 119,988) ÷ 2] = 6.15%

4 Click competitor name to see calculations.

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Walmart Inc. deteriorated earnings quality from 2023 to 2024.

Cash-Flow-Statement-Based Accruals Ratio

Walmart Inc., cash flow statement computation of aggregate accruals

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Less: Net cash provided by operating activities 35,726 28,841 24,181 36,074 25,255 27,753
Less: Net cash used in investing activities (21,287) (17,722) (6,015) (10,071) (9,128) (24,036)
Cash-flow-statement-based aggregate accruals 1,072 561 (4,493) (12,493) (1,246) 2,953
Financial Ratio
Cash-flow-statement-based accruals ratio1 0.87% 0.47% -3.77% -10.19% -0.97%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
Costco Wholesale Corp. 2.33% 1.10% 14.69% -2.96% -7.15%
Target Corp. 1.09% 18.64% 7.52% -18.12% -4.18%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Consumer Staples Distribution & Retail 0.00% 3.13% -0.42% -10.54% -1.90%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Consumer Staples 0.00% 3.12% 3.27% -7.15% -1.99%

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
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 1,072 ÷ [(127,595 + 119,988) ÷ 2] = 0.87%

2 Click competitor name to see calculations.

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Walmart Inc. deteriorated earnings quality from 2023 to 2024.