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) $332.89
No. shares of common stock outstanding 991,015,773
US$ in millions
Common equity (market value)1 329,899
Total equity 329,899
Add: Short-term debt (per books)
Add: Current installments of long-term debt (per books) 1,368
Add: Long-term debt, excluding current installments (per books) 42,743
Total equity and debt 374,010
Less: Cash and cash equivalents 3,760
Enterprise value (EV) 370,250

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

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 332.89 × 991,015,773


Historical Enterprise Value (EV)

Home Depot Inc., EV calculation

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

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 Data adjusted for splits and stock dividends.

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

3 2024 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 378.99 × 991,015,773

Item Description The company
EV Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments. Home Depot Inc. EV decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.