Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Income Taxes

Microsoft Excel

Income Tax Expense (Benefit)

Walmart Inc., income tax expense (benefit), continuing operations

US$ in millions

Microsoft Excel
12 months ended: Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
U.S. federal 3,215 2,030 3,313 2,991 2,794 2,763
U.S. state and local 762 610 649 742 587 493
International 1,772 2,654 1,553 1,127 1,205 1,495
Current tax provision 5,749 5,294 5,515 4,860 4,586 4,751
U.S. federal (438) 608 (671) 2,316 663 (361)
U.S. state and local 141 119 41 23 35 (16)
International 126 (297) (129) (341) (369) (93)
Deferred tax expense (benefit) (171) 430 (759) 1,998 329 (470)
Provision for income taxes 5,578 5,724 4,756 6,858 4,915 4,281

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).

Item Description The company
Current tax provision Amount of current income tax expense (benefit) pertaining to taxable income (loss) from continuing operations. Walmart Inc. current tax provision decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.
Deferred tax expense (benefit) Amount of deferred income tax expense (benefit) pertaining to income (loss) from continuing operations. Walmart Inc. deferred tax expense (benefit) increased from 2022 to 2023 but then slightly decreased from 2023 to 2024 not reaching 2022 level.
Provision for income taxes Amount of current income tax expense (benefit) and deferred income tax expense (benefit) pertaining to continuing operations. Walmart Inc. provision for income taxes increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.

Effective Income Tax Rate (EITR)

Walmart Inc., effective income tax rate (EITR) reconciliation

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
U.S. statutory tax rate 21.00% 21.00% 21.00% 21.00% 21.00% 21.00%
U.S. state income taxes, net of federal income tax benefit 3.00% 3.10% 2.80% 2.90% 2.20% 3.00%
Income taxed outside the U.S. 0.10% 1.10% -1.50% -0.10% -1.00% -3.40%
Separation, disposal and wind-down of certain business operations 0.00% 6.30% 0.50% 7.10% 0.00% 6.70%
Valuation allowance 1.20% 1.70% 4.40% 2.30% 2.30% 6.30%
Net impact of repatriated international earnings -0.40% -0.40% -0.30% -0.40% 0.40% 0.80%
Federal tax credits -1.50% -1.30% -1.10% -0.90% -0.80% -1.30%
Enacted change in tax laws 0.00% 0.00% 0.00% 0.00% -1.90% 0.00%
Change in unrecognized tax benefits 0.60% 0.30% 0.20% 0.80% 2.50% 0.60%
Other, net 1.50% 1.80% -0.60% 0.60% -0.30% 0.80%
Effective income tax rate, before impact of the Tax Act 25.50% 33.60% 25.40% 33.30% 24.40% 34.50%
One-time transition tax 0.00% 0.00% 0.00% 0.00% 0.00% 3.60%
Deferred tax effects 0.00% 0.00% 0.00% 0.00% 0.00% -0.70%
Impact of the Tax Act 0.00% 0.00% 0.00% 0.00% 0.00% 2.90%
Effective income tax rate 25.50% 33.60% 25.40% 33.30% 24.40% 37.40%

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).

Item Description The company
Effective income tax rate, before impact of the Tax Act Percentage of current income tax expense (benefit) and deferred income tax expense (benefit) pertaining to continuing operations. Walmart Inc. effective income tax rate, before impact of the Tax Act increased from 2022 to 2023 but then slightly decreased from 2023 to 2024 not reaching 2022 level.

Components of Deferred Tax Assets and Liabilities

Walmart Inc., components of deferred tax assets and liabilities

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Loss and tax credit carryforwards 7,136 7,690 9,456 9,179 9,056 2,964
Accrued liabilities 3,066 3,312 2,752 2,582 2,483 2,135
Share-based compensation 238 237 231 224 250 245
Lease obligations 4,831 4,653 4,320 4,450 4,098
Other 1,124 839 893 589 1,020 1,131
Deferred tax assets 16,395 16,731 17,652 17,024 16,907 6,475
Valuation allowances (7,485) (7,815) (9,542) (8,782) (8,588) (2,448)
Deferred tax assets, net of valuation allowances 8,910 8,916 8,110 8,242 8,319 4,027
Property and equipment (4,813) (4,352) (4,414) (4,802) (4,621) (4,175)
Acquired intangibles (898) (932) (1,065) (1,071) (1,152) (2,099)
Inventory (3,035) (3,032) (1,588) (1,235) (1,414) (1,354)
Lease right of use assets (4,941) (4,727) (4,355) (4,390) (3,998)
Mark-to-market investments (322) (1,390) (1,825) (2,678) (724) (335)
Other (486) (249) (307) (675) (700) (564)
Deferred tax liabilities (14,495) (14,682) (13,554) (14,851) (12,609) (8,527)
Net deferred tax assets (liabilities) (5,585) (5,766) (5,444) (6,609) (4,290) (4,500)

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).

Item Description The company
Deferred tax assets Amount before allocation of valuation allowances of deferred tax asset attributable to deductible temporary differences and carryforwards. Walmart Inc. deferred tax assets decreased from 2022 to 2023 and from 2023 to 2024.
Deferred tax assets, net of valuation allowances Amount after allocation of valuation allowances of deferred tax asset attributable to deductible temporary differences and carryforwards. Walmart Inc. deferred tax assets, net of valuation allowances increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.
Net deferred tax assets (liabilities) Amount, after allocation of valuation allowances and deferred tax liability, of deferred tax asset attributable to deductible differences and carryforwards, without jurisdictional netting. Walmart Inc. net deferred tax assets (liabilities) decreased from 2022 to 2023 but then increased from 2023 to 2024 not reaching 2022 level.

Deferred Tax Assets and Liabilities, Classification

Walmart Inc., deferred tax assets and liabilities, classification

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Deferred tax assets (included in Other long-term assets) 1,663 1,503 1,473 1,836 1,914 1,796
Deferred tax liabilities (included in Deferred income taxes and other) 7,248 7,269 6,917 8,445 6,204 6,296

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).

Item Description The company
Deferred tax assets (included in Other long-term assets) Amount, after allocation of valuation allowances and deferred tax liability, of deferred tax asset attributable to deductible differences and carryforwards, with jurisdictional netting and classified as noncurrent. Walmart Inc. deferred tax assets (included in Other long-term assets) increased from 2022 to 2023 and from 2023 to 2024.
Deferred tax liabilities (included in Deferred income taxes and other) Amount, after deferred tax asset, of deferred tax liability attributable to taxable differences, with jurisdictional netting and classified as noncurrent. Walmart Inc. deferred tax liabilities (included in Deferred income taxes and other) increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.

Adjustments to Financial Statements: Removal of Deferred Taxes

Walmart Inc., adjustments to financial statements

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Adjustment to Total Assets
Total assets (as reported) 252,399 243,197 244,860 252,496 236,495 219,295
Less: Noncurrent deferred tax assets, net 1,663 1,503 1,473 1,836 1,914 1,796
Total assets (adjusted) 250,736 241,694 243,387 250,660 234,581 217,499
Adjustment to Total Liabilities
Total liabilities (as reported) 161,828 159,206 152,969 164,965 154,943 139,661
Less: Noncurrent deferred tax liabilities, net 7,248 7,269 6,917 8,445 6,204 6,296
Total liabilities (adjusted) 154,580 151,937 146,052 156,520 148,739 133,365
Adjustment to Total Walmart Shareholders’ Equity
Total Walmart shareholders’ equity (as reported) 83,861 76,693 83,253 80,925 74,669 72,496
Less: Net deferred tax assets (liabilities) (5,585) (5,766) (5,444) (6,609) (4,290) (4,500)
Total Walmart shareholders’ equity (adjusted) 89,446 82,459 88,697 87,534 78,959 76,996
Adjustment to Consolidated Net Income Attributable To Walmart
Consolidated net income attributable to Walmart (as reported) 15,511 11,680 13,673 13,510 14,881 6,670
Add: Deferred income tax expense (benefit) (171) 430 (759) 1,998 329 (470)
Consolidated net income attributable to Walmart (adjusted) 15,340 12,110 12,914 15,508 15,210 6,200

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).


Walmart Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios: Removal of Deferred Taxes (Summary)

Walmart Inc., adjusted financial ratios

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Net Profit Margin
Reported net profit margin 2.41% 1.93% 2.41% 2.43% 2.86% 1.31%
Adjusted net profit margin 2.39% 2.00% 2.27% 2.79% 2.93% 1.21%
Total Asset Turnover
Reported total asset turnover 2.55 2.49 2.32 2.20 2.20 2.33
Adjusted total asset turnover 2.56 2.51 2.33 2.22 2.22 2.35
Financial Leverage
Reported financial leverage 3.01 3.17 2.94 3.12 3.17 3.02
Adjusted financial leverage 2.80 2.93 2.74 2.86 2.97 2.82
Return on Equity (ROE)
Reported ROE 18.50% 15.23% 16.42% 16.69% 19.93% 9.20%
Adjusted ROE 17.15% 14.69% 14.56% 17.72% 19.26% 8.05%
Return on Assets (ROA)
Reported ROA 6.15% 4.80% 5.58% 5.35% 6.29% 3.04%
Adjusted ROA 6.12% 5.01% 5.31% 6.19% 6.48% 2.85%

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).

Financial ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by total revenue. Walmart Inc. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Walmart Inc. adjusted total asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Walmart Inc. adjusted financial leverage ratio increased from 2022 to 2023 but then slightly decreased from 2023 to 2024 not reaching 2022 level.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted shareholders’ equity. Walmart Inc. adjusted ROE improved from 2022 to 2023 and from 2023 to 2024.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Walmart Inc. adjusted ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Walmart Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Profitability Ratio
Net profit margin1 2.41% 1.93% 2.41% 2.43% 2.86% 1.31%
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted consolidated net income attributable to Walmart 15,340 12,110 12,914 15,508 15,210 6,200
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Profitability Ratio
Adjusted net profit margin2 2.39% 2.00% 2.27% 2.79% 2.93% 1.21%

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).

2024 Calculations

1 Net profit margin = 100 × Consolidated net income attributable to Walmart ÷ Net sales
= 100 × 15,511 ÷ 642,637 = 2.41%

2 Adjusted net profit margin = 100 × Adjusted consolidated net income attributable to Walmart ÷ Net sales
= 100 × 15,340 ÷ 642,637 = 2.39%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by total revenue. Walmart Inc. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Adjusted Total Asset Turnover

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Total assets 252,399 243,197 244,860 252,496 236,495 219,295
Activity Ratio
Total asset turnover1 2.55 2.49 2.32 2.20 2.20 2.33
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Adjusted total assets 250,736 241,694 243,387 250,660 234,581 217,499
Activity Ratio
Adjusted total asset turnover2 2.56 2.51 2.33 2.22 2.22 2.35

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).

2024 Calculations

1 Total asset turnover = Net sales ÷ Total assets
= 642,637 ÷ 252,399 = 2.55

2 Adjusted total asset turnover = Net sales ÷ Adjusted total assets
= 642,637 ÷ 250,736 = 2.56

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Walmart Inc. adjusted total asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Adjusted Financial Leverage

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Total assets 252,399 243,197 244,860 252,496 236,495 219,295
Total Walmart shareholders’ equity 83,861 76,693 83,253 80,925 74,669 72,496
Solvency Ratio
Financial leverage1 3.01 3.17 2.94 3.12 3.17 3.02
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted total assets 250,736 241,694 243,387 250,660 234,581 217,499
Adjusted total Walmart shareholders’ equity 89,446 82,459 88,697 87,534 78,959 76,996
Solvency Ratio
Adjusted financial leverage2 2.80 2.93 2.74 2.86 2.97 2.82

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).

2024 Calculations

1 Financial leverage = Total assets ÷ Total Walmart shareholders’ equity
= 252,399 ÷ 83,861 = 3.01

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted total Walmart shareholders’ equity
= 250,736 ÷ 89,446 = 2.80

Solvency ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Walmart Inc. adjusted financial leverage ratio increased from 2022 to 2023 but then slightly decreased from 2023 to 2024 not reaching 2022 level.

Adjusted Return on Equity (ROE)

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Total Walmart shareholders’ equity 83,861 76,693 83,253 80,925 74,669 72,496
Profitability Ratio
ROE1 18.50% 15.23% 16.42% 16.69% 19.93% 9.20%
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted consolidated net income attributable to Walmart 15,340 12,110 12,914 15,508 15,210 6,200
Adjusted total Walmart shareholders’ equity 89,446 82,459 88,697 87,534 78,959 76,996
Profitability Ratio
Adjusted ROE2 17.15% 14.69% 14.56% 17.72% 19.26% 8.05%

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).

2024 Calculations

1 ROE = 100 × Consolidated net income attributable to Walmart ÷ Total Walmart shareholders’ equity
= 100 × 15,511 ÷ 83,861 = 18.50%

2 Adjusted ROE = 100 × Adjusted consolidated net income attributable to Walmart ÷ Adjusted total Walmart shareholders’ equity
= 100 × 15,340 ÷ 89,446 = 17.15%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted shareholders’ equity. Walmart Inc. adjusted ROE improved from 2022 to 2023 and from 2023 to 2024.

Adjusted Return on Assets (ROA)

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Total assets 252,399 243,197 244,860 252,496 236,495 219,295
Profitability Ratio
ROA1 6.15% 4.80% 5.58% 5.35% 6.29% 3.04%
Adjusted for Deferred Taxes
Selected Financial Data (US$ in millions)
Adjusted consolidated net income attributable to Walmart 15,340 12,110 12,914 15,508 15,210 6,200
Adjusted total assets 250,736 241,694 243,387 250,660 234,581 217,499
Profitability Ratio
Adjusted ROA2 6.12% 5.01% 5.31% 6.19% 6.48% 2.85%

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).

2024 Calculations

1 ROA = 100 × Consolidated net income attributable to Walmart ÷ Total assets
= 100 × 15,511 ÷ 252,399 = 6.15%

2 Adjusted ROA = 100 × Adjusted consolidated net income attributable to Walmart ÷ Adjusted total assets
= 100 × 15,340 ÷ 250,736 = 6.12%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Walmart Inc. adjusted ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.