Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

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

Home Depot Inc., MVA calculation

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Fair value of debt1 41,763 41,822 43,668 44,055 36,241 30,736
Operating lease liability 8,132 7,171 6,183 6,184 5,894 4,750
Market value of common equity 375,585 292,277 327,624 315,312 195,345 209,808
Market (fair) value of Home Depot 425,480 341,270 377,475 365,551 237,480 245,293
Less: Invested capital2 55,884 55,111 48,299 49,973 36,678 34,178
MVA 369,596 286,159 329,176 315,578 200,802 211,116

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 Fair value of debt. See details »

2 Invested capital. See details »

Item Description The company
MVA Home Depot Inc. market (fair) value less invested capital. Home Depot Inc. MVA decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

MVA Spread Ratio

Home Depot Inc., MVA spread ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Selected Financial Data (US$ in millions)
Market value added (MVA)1 369,596 286,159 329,176 315,578 200,802 211,116
Invested capital2 55,884 55,111 48,299 49,973 36,678 34,178
Performance Ratio
MVA spread ratio3 661.36% 519.24% 681.54% 631.50% 547.47% 617.70%
Benchmarks
MVA Spread Ratio, Competitors4
Amazon.com Inc. 487.84% 342.01% 728.57% 1,053.43% 730.44%
Lowe’s Cos. Inc. 603.38% 500.68% 587.76% 457.91% 186.58% 334.01%
TJX Cos. Inc. 480.00% 393.67% 333.18% 327.36% 261.07% 334.48%

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 MVA. See details »

2 Invested capital. See details »

3 2024 Calculation
MVA spread ratio = 100 × MVA ÷ Invested capital
= 100 × 369,596 ÷ 55,884 = 661.36%

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. Home Depot Inc. MVA spread ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.

MVA Margin

Home Depot Inc., MVA margin calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Selected Financial Data (US$ in millions)
Market value added (MVA)1 369,596 286,159 329,176 315,578 200,802 211,116
 
Net sales 152,669 157,403 151,157 132,110 110,225 108,203
Add: Increase (decrease) in deferred revenue (302) (532) 773 707 334 (23)
Adjusted net sales 152,367 156,871 151,930 132,817 110,559 108,180
Performance Ratio
MVA margin2 242.57% 182.42% 216.66% 237.60% 181.62% 195.15%
Benchmarks
MVA Margin, Competitors3
Amazon.com Inc. 274.96% 178.50% 312.93% 408.23% 330.23%
Lowe’s Cos. Inc. 181.37% 127.78% 159.89% 145.00% 69.10% 115.18%
TJX Cos. Inc. 186.85% 160.74% 135.17% 227.93% 116.99% 149.26%

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 MVA. See details »

2 2024 Calculation
MVA margin = 100 × MVA ÷ Adjusted net sales
= 100 × 369,596 ÷ 152,367 = 242.57%

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. Home Depot Inc. MVA margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.