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) $407.18
No. shares of common stock outstanding 994,927,985
US$ in millions
Common equity (market value)1 405,115
Total equity 405,115
Add: Short-term debt (per books) 316
Add: Current installments of long-term debt (per books) 4,582
Add: Long-term debt, excluding current installments (per books) 48,485
Total equity and debt 458,498
Less: Cash and cash equivalents 1,659
Enterprise value (EV) 456,839

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

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 407.18 × 994,927,985


Historical Enterprise Value (EV)

Home Depot Inc., EV calculation

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

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

1 Data adjusted for splits and stock dividends.

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

3 2025 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 351.15 × 994,032,168


Equity Trends
The common equity (market value) demonstrated a general upward trajectory from 195,345 million USD in early 2020 to a peak at 375,585 million USD by early 2024. This represents a substantial increase over the five-year period, indicating a growing market valuation of equity. However, in the most recent year ending February 2025, there was a decline to 349,054 million USD, suggesting some volatility or a correction after the peak.
Total Equity and Debt Movements
Total equity and debt followed a similar pattern to equity values but with larger absolute figures, beginning at 226,828 million USD in early 2020 and increasing to a high of 419,696 million USD by early 2024. This was followed by a moderate decrease to 402,437 million USD by February 2025. This trend indicates the company expanded its combined financing through equity and debt markedly before experiencing a slight consolidation or reduction.
Enterprise Value Dynamics
The enterprise value (EV) closely mirrors the trend in total equity and debt, rising from 224,695 million USD at the start of the period to a peak of 415,936 million USD in early 2024. It then receded to 400,778 million USD in the most recent year. This pattern implies that the overall valuation, inclusive of market capitalization and net debt, expanded significantly over the years before a slight downturn.
Summary of Insights
Across the observed timeframe, there is an evident growth in market capitalization and corporate valuation, indicating strong investor confidence and possible business expansion or improved financial performance until the early 2024 mark. The subsequent decline in the latest year may reflect market adjustments, changes in investor sentiment, or shifts in capital structure. Overall, the data shows a positive growth pattern with minor recent volatility.