Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Economic Value Added (EVA)

Microsoft Excel

EVA is registered trademark of Stern Stewart.

Economic value added or economic profit is the difference between revenues and costs,where costs include not only expenses, but also cost of capital.


Economic Profit

Walmart Inc., economic profit calculation

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
Net operating profit after taxes (NOPAT)1 18,517 13,880 15,307 18,130 18,200 9,089
Cost of capital2 8.12% 7.97% 7.95% 7.80% 7.62% 7.74%
Invested capital3 155,389 149,558 156,225 164,411 167,329 158,768
 
Economic profit4 5,904 1,960 2,889 5,298 5,456 (3,195)

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 NOPAT. See details »

2 Cost of capital. See details »

3 Invested capital. See details »

4 2024 Calculation
Economic profit = NOPAT – Cost of capital × Invested capital
= 18,5178.12% × 155,389 = 5,904

Item Description The company
Economic profit Economic profit is a measure of corporate performance computed by taking the spread between the return on invested capital and the cost of capital, and multiplying by the invested capital. Walmart Inc. economic profit decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

Net Operating Profit after Taxes (NOPAT)

Walmart Inc., NOPAT calculation

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
Consolidated net income attributable to Walmart 15,511 11,680 13,673 13,510 14,881 6,670
Deferred income tax expense (benefit)1 (171) 430 (759) 1,998 329 (470)
Increase (decrease) in equity equivalents2 (171) 430 (759) 1,998 329 (470)
Interest expense, debt and finance lease 2,683 2,128 1,994 2,315 2,599 2,346
Interest expense, operating lease liability3 924 858 855 877 970 884
Adjusted interest expense, debt and finance lease 3,607 2,986 2,849 3,192 3,569 3,230
Tax benefit of interest expense, debt and finance lease4 (757) (627) (598) (670) (750) (678)
Adjusted interest expense, debt and finance lease, after taxes5 2,849 2,359 2,251 2,522 2,820 2,552
Interest income (546) (254) (158) (121) (189) (217)
Investment income, before taxes (546) (254) (158) (121) (189) (217)
Tax expense (benefit) of investment income6 115 53 33 25 40 46
Investment income, after taxes7 (431) (201) (125) (96) (149) (171)
Net income (loss) attributable to noncontrolling interest 759 (388) 267 196 320 509
Net operating profit after taxes (NOPAT) 18,517 13,880 15,307 18,130 18,200 9,089

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 Elimination of deferred tax expense. See details »

2 Addition of increase (decrease) in equity equivalents to consolidated net income attributable to Walmart.

3 2024 Calculation
Interest expense on capitalized operating leases = Operating lease liability × Discount rate
= 14,430 × 6.40% = 924

4 2024 Calculation
Tax benefit of interest expense, debt and finance lease = Adjusted interest expense, debt and finance lease × Statutory income tax rate
= 3,607 × 21.00% = 757

5 Addition of after taxes interest expense to consolidated net income attributable to Walmart.

6 2024 Calculation
Tax expense (benefit) of investment income = Investment income, before tax × Statutory income tax rate
= 546 × 21.00% = 115

7 Elimination of after taxes investment income.

Item Description The company
NOPAT Net operating profit after taxes is income from operations, but after removement of taxes calculated on cash basis that are relevant to operating income. Walmart Inc. NOPAT decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

Cash Operating Taxes

Walmart Inc., cash operating taxes calculation

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
Provision for income taxes 5,578 5,724 4,756 6,858 4,915 4,281
Less: Deferred income tax expense (benefit) (171) 430 (759) 1,998 329 (470)
Add: Tax savings from interest expense, debt and finance lease 757 627 598 670 750 678
Less: Tax imposed on investment income 115 53 33 25 40 46
Cash operating taxes 6,392 5,868 6,080 5,505 5,296 5,384

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
Cash operating taxes Cash operating taxes are estimated by adjusting income tax expense for changes in deferred taxes and tax benefit from the interest deduction. Walmart Inc. cash operating taxes decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

Invested Capital

Walmart Inc., invested capital calculation (financing approach)

US$ in millions

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Short-term borrowings 878 372 410 224 575 5,225
Long-term debt due within one year 3,447 4,191 2,803 3,115 5,362 1,876
Finance lease obligations due within one year 725 567 511 491 511 729
Long-term debt, excluding due within one year 36,132 34,649 34,864 41,194 43,714 43,520
Long-term finance lease obligations, excluding due within one year 5,709 4,843 4,243 3,847 4,307 6,683
Operating lease liability1 14,430 14,301 14,492 14,375 17,964 8,533
Total reported debt & leases 61,321 58,923 57,323 63,246 72,433 66,566
Total Walmart shareholders’ equity 83,861 76,693 83,253 80,925 74,669 72,496
Net deferred tax (assets) liabilities2 5,585 5,766 5,444 6,609 4,290 4,500
Equity equivalents3 5,585 5,766 5,444 6,609 4,290 4,500
Accumulated other comprehensive (income) loss, net of tax4 11,302 11,680 8,766 11,766 12,805 11,542
Redeemable noncontrolling interest 222 237
Noncontrolling interest 6,488 7,061 8,638 6,606 6,883 7,138
Adjusted total Walmart shareholders’ equity 107,458 101,437 106,101 105,906 98,647 95,676
Construction in process5 (13,390) (10,802) (7,199) (4,741) (3,751) (3,474)
Invested capital 155,389 149,558 156,225 164,411 167,329 158,768

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 Addition of capitalized operating leases.

2 Elimination of deferred taxes from assets and liabilities. See details »

3 Addition of equity equivalents to total Walmart shareholders’ equity.

4 Removal of accumulated other comprehensive income.

5 Subtraction of construction in process.

Item Description The company
Invested capital Capital is an approximation of the economic book value of all cash invested in going-concern business activities. Walmart Inc. invested capital decreased from 2022 to 2023 but then increased from 2023 to 2024 not reaching 2022 level.

Cost of Capital

Walmart Inc., cost of capital calculations

Capital (fair value)1 Weights Cost of capital
Equity2 488,962 488,962 ÷ 549,135 = 0.89 0.89 × 8.65% = 7.70%
Debt and finance lease obligations3 45,743 45,743 ÷ 549,135 = 0.08 0.08 × 4.28% × (1 – 21.00%) = 0.28%
Operating lease liability4 14,430 14,430 ÷ 549,135 = 0.03 0.03 × 6.40% × (1 – 21.00%) = 0.13%
Total: 549,135 1.00 8.12%

Based on: 10-K (reporting date: 2024-01-31).

1 US$ in millions

2 Equity. See details »

3 Debt and finance lease obligations. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 375,801 375,801 ÷ 434,053 = 0.87 0.87 × 8.65% = 7.49%
Debt and finance lease obligations3 43,951 43,951 ÷ 434,053 = 0.10 0.10 × 4.06% × (1 – 21.00%) = 0.32%
Operating lease liability4 14,301 14,301 ÷ 434,053 = 0.03 0.03 × 6.00% × (1 – 21.00%) = 0.16%
Total: 434,053 1.00 7.97%

Based on: 10-K (reporting date: 2023-01-31).

1 US$ in millions

2 Equity. See details »

3 Debt and finance lease obligations. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 400,219 400,219 ÷ 462,256 = 0.87 0.87 × 8.65% = 7.49%
Debt and finance lease obligations3 47,545 47,545 ÷ 462,256 = 0.10 0.10 × 3.86% × (1 – 21.00%) = 0.31%
Operating lease liability4 14,492 14,492 ÷ 462,256 = 0.03 0.03 × 5.90% × (1 – 21.00%) = 0.15%
Total: 462,256 1.00 7.95%

Based on: 10-K (reporting date: 2022-01-31).

1 US$ in millions

2 Equity. See details »

3 Debt and finance lease obligations. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 371,093 371,093 ÷ 444,270 = 0.84 0.84 × 8.65% = 7.23%
Debt and finance lease obligations3 58,802 58,802 ÷ 444,270 = 0.13 0.13 × 4.05% × (1 – 21.00%) = 0.42%
Operating lease liability4 14,375 14,375 ÷ 444,270 = 0.03 0.03 × 6.10% × (1 – 21.00%) = 0.16%
Total: 444,270 1.00 7.80%

Based on: 10-K (reporting date: 2021-01-31).

1 US$ in millions

2 Equity. See details »

3 Debt and finance lease obligations. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 322,795 322,795 ÷ 403,921 = 0.80 0.80 × 8.65% = 6.91%
Debt and finance lease obligations3 63,162 63,162 ÷ 403,921 = 0.16 0.16 × 4.16% × (1 – 21.00%) = 0.51%
Operating lease liability4 17,964 17,964 ÷ 403,921 = 0.04 0.04 × 5.40% × (1 – 21.00%) = 0.19%
Total: 403,921 1.00 7.62%

Based on: 10-K (reporting date: 2020-01-31).

1 US$ in millions

2 Equity. See details »

3 Debt and finance lease obligations. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 278,761 278,761 ÷ 349,501 = 0.80 0.80 × 8.65% = 6.90%
Debt and finance lease obligations3 62,207 62,207 ÷ 349,501 = 0.18 0.18 × 4.54% × (1 – 21.00%) = 0.64%
Operating lease liability4 8,533 8,533 ÷ 349,501 = 0.02 0.02 × 10.36% × (1 – 21.00%) = 0.20%
Total: 349,501 1.00 7.74%

Based on: 10-K (reporting date: 2019-01-31).

1 US$ in millions

2 Equity. See details »

3 Debt and finance lease obligations. See details »

4 Operating lease liability. See details »


Economic Spread Ratio

Walmart Inc., economic spread ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Economic profit1 5,904 1,960 2,889 5,298 5,456 (3,195)
Invested capital2 155,389 149,558 156,225 164,411 167,329 158,768
Performance Ratio
Economic spread ratio3 3.80% 1.31% 1.85% 3.22% 3.26% -2.01%
Benchmarks
Economic Spread Ratio, Competitors4
Costco Wholesale Corp. 4.95% 9.00% 7.38% 3.57% 5.47%
Target Corp. 2.31% 0.53% 13.48% 3.95% 2.48% 2.66%

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 Economic profit. See details »

2 Invested capital. See details »

3 2024 Calculation
Economic spread ratio = 100 × Economic profit ÷ Invested capital
= 100 × 5,904 ÷ 155,389 = 3.80%

4 Click competitor name to see calculations.

Performance ratio Description The company
Economic spread ratio The ratio of economic profit to invested capital, also equal to the difference between return on invested capital (ROIC) and cost of capital. Walmart Inc. economic spread ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Economic Profit Margin

Walmart Inc., economic profit margin calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Economic profit1 5,904 1,960 2,889 5,298 5,456 (3,195)
Net sales 642,637 605,881 567,762 555,233 519,926 510,329
Performance Ratio
Economic profit margin2 0.92% 0.32% 0.51% 0.95% 1.05% -0.63%
Benchmarks
Economic Profit Margin, Competitors3
Costco Wholesale Corp. 0.73% 1.28% 1.09% 0.64% 0.88%
Target Corp. 0.75% 0.15% 3.89% 1.30% 0.88% 0.93%

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 Economic profit. See details »

2 2024 Calculation
Economic profit margin = 100 × Economic profit ÷ Net sales
= 100 × 5,904 ÷ 642,637 = 0.92%

3 Click competitor name to see calculations.

Performance ratio Description The company
Economic profit margin The ratio of economic profit to sales. It is the company profit margin covering income efficiency and asset management. Economic profit margin is not biased in favor of capital-intensive business models, because any added capital is a cost to the economic profit margin. Walmart Inc. economic profit margin deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.