Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Enterprise Value (EV) 

Microsoft Excel

Current Enterprise Value (EV)

Home Depot Inc., current enterprise value calculation

Microsoft Excel
Current share price (P) $330.91
No. shares of common stock outstanding 996,011,466
US$ in millions
Common equity (market value)1 329,590
Total equity 329,590
Add: Short-term debt (per books) 4,464
Add: Current installments of long-term debt (per books) 4,967
Add: Long-term debt, excluding current installments (per books) 46,341
Total equity and debt 385,362
Less: Cash and cash equivalents 1,389
Enterprise value (EV) 383,973

Based on: 10-K (reporting date: 2026-02-01).

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 330.91 × 996,011,466


Historical Enterprise Value (EV)

Home Depot Inc., EV calculation

Microsoft Excel
Feb 1, 2026 Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021
Share price1, 2 $330.93 $351.15 $378.99 $287.97 $317.05 $292.75
No. shares of common stock outstanding1 996,011,466 994,032,168 991,015,773 1,014,955,506 1,033,349,933 1,077,069,383
US$ in millions
Common equity (market value)3 329,610 349,054 375,585 292,277 327,624 315,312
Total equity 329,610 349,054 375,585 292,277 327,624 315,312
Add: Short-term debt (book value) 4,464 316 1,035
Add: Current installments of long-term debt (book value) 4,967 4,582 1,368 1,231 2,447 1,416
Add: Long-term debt, excluding current installments (book value) 46,341 48,485 42,743 41,962 36,604 35,822
Total equity and debt 385,382 402,437 419,696 335,470 367,710 352,550
Less: Cash and cash equivalents 1,389 1,659 3,760 2,757 2,343 7,895
Enterprise value (EV) 383,993 400,778 415,936 332,713 365,367 344,655

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 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).

1 Data adjusted for splits and stock dividends.

2 Closing price as at the filing date of Home Depot Inc. Annual Report.

3 2026 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 330.93 × 996,011,466


The enterprise value exhibited a fluctuating pattern over the observed period. Initially, it increased from January 31, 2021, to January 28, 2024, before declining in subsequent years. A detailed examination of the components reveals further insights into these movements.

Enterprise Value Trend
Enterprise value increased from US$344,655 million in 2021 to US$415,936 million in 2024, representing a cumulative increase of approximately 20.6%. However, this was followed by a decrease to US$400,778 million in 2025 and further to US$383,993 million in 2026. The decline from the 2024 peak suggests potential shifts in market perception or underlying financial performance.
Equity Component
Common equity and total equity values were identical across all observed periods, indicating that all equity was represented by common stock. These values mirrored the fluctuations in enterprise value, increasing from US$315,312 million in 2021 to US$375,585 million in 2024, and then decreasing to US$329,610 million by 2026. This suggests a strong correlation between equity market valuation and the overall enterprise value.
Debt and Equity Combined
Total equity and debt consistently exceeded both common equity and enterprise value throughout the period. This difference represents the net debt position. The combined value of equity and debt increased from US$352,550 million in 2021 to US$419,696 million in 2024, mirroring the enterprise value trend. The subsequent decline to US$385,382 million in 2026 indicates a reduction in the combined equity and debt, potentially through debt repayment or decreased equity issuance.

The observed pattern suggests that changes in equity market valuation significantly influence the enterprise value. While debt plays a role, the fluctuations in enterprise value closely track the movements in common equity. The recent decline in both enterprise value and combined equity and debt warrants further investigation to determine the underlying causes and potential implications for future performance.

AI Ask an analyst for more