Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Market Value Added (MVA)

Microsoft Excel

Market value added (MVA) is the difference between a firm fair value and its invested capital. MVA is a measure of the value a company has created in excess of the resources already committed to the enterprise.


MVA

Walmart Inc., MVA calculation

US$ in millions

Microsoft Excel
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
Fair value of debt and finance lease obligations1 47,545 58,802 63,162 62,207 51,470 52,269
Operating lease liability 14,492 14,375 17,964 8,533 10,267 11,626
Market value of common equity 400,219 371,121 322,795 278,732 262,523 218,619
Noncontrolling interest 8,638 6,606 6,883 7,138 2,953 2,737
Less: Available-for-sale securities 3,547 2,046
Market (fair) value of Walmart 470,894 450,904 410,804 356,611 323,666 283,206
Less: Invested capital2 156,225 164,411 167,329 158,768 142,543 148,752
MVA 314,669 286,493 243,475 197,842 181,123 134,453

Based on: 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), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31).

1 Fair value of debt. See details »

2 Invested capital. See details »

Item Description The company
MVA Walmart Inc. market (fair) value less invested capital. Walmart Inc. MVA increased from 2020 to 2021 and from 2021 to 2022.

MVA Spread Ratio

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

Microsoft Excel
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
Selected Financial Data (US$ in millions)
Market value added (MVA)1 314,669 286,493 243,475 197,842 181,123 134,453
Invested capital2 156,225 164,411 167,329 158,768 142,543 148,752
Performance Ratio
MVA spread ratio3 201.42% 174.25% 145.51% 124.61% 127.07% 90.39%
Benchmarks
MVA Spread Ratio, Competitors4
Costco Wholesale Corp. 601.38% 635.70% 488.89% 481.92% 398.25% 306.85%

Based on: 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), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31).

1 MVA. See details »

2 Invested capital. See details »

3 2022 Calculation
MVA spread ratio = 100 × MVA ÷ Invested capital
= 100 × 314,669 ÷ 156,225 = 201.42%

4 Click competitor name to see calculations.

Performance ratio Description The company
MVA spread ratio The ratio of MVA to invested capital. It measures the efficiency with which investors’ capital investment has translated into a franchise value and into an aggregate net present value premium. Walmart Inc. MVA spread ratio improved from 2020 to 2021 and from 2021 to 2022.

MVA Margin

Walmart Inc., MVA margin calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
Selected Financial Data (US$ in millions)
Market value added (MVA)1 314,669 286,493 243,475 197,842 181,123 134,453
Net sales 567,762 555,233 519,926 510,329 495,761 481,317
Performance Ratio
MVA margin2 55.42% 51.60% 46.83% 38.77% 36.53% 27.93%
Benchmarks
MVA Margin, Competitors3
Costco Wholesale Corp. 85.51% 94.36% 86.99% 77.31% 59.72% 45.97%

Based on: 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), 10-K (reporting date: 2018-01-31), 10-K (reporting date: 2017-01-31).

1 MVA. See details »

2 2022 Calculation
MVA margin = 100 × MVA ÷ Net sales
= 100 × 314,669 ÷ 567,762 = 55.42%

3 Click competitor name to see calculations.

Performance ratio Description The company
MVA margin The ratio of MVA to sales. It measures how efficiently and prodigiously sales translate into franchise value. Walmart Inc. MVA margin ratio improved from 2020 to 2021 and from 2021 to 2022.