Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Price to Book Value (P/BV) 
since 2005

Microsoft Excel

Calculation

Home Depot Inc., P/BV, long-term trends, calculation

Microsoft Excel

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), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03), 10-K (reporting date: 2018-01-28), 10-K (reporting date: 2017-01-29), 10-K (reporting date: 2016-01-31), 10-K (reporting date: 2015-02-01), 10-K (reporting date: 2014-02-02), 10-K (reporting date: 2013-02-03), 10-K (reporting date: 2012-01-29), 10-K (reporting date: 2011-01-30), 10-K (reporting date: 2010-01-31), 10-K (reporting date: 2009-02-01), 10-K (reporting date: 2008-02-03), 10-K (reporting date: 2007-01-28), 10-K (reporting date: 2006-01-29), 10-K (reporting date: 2005-01-30).

1 US$

2 Data adjusted for splits and stock dividends.

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


The price-to-book value (P/BV) ratio exhibits significant fluctuations over the observed period. Initially, the ratio demonstrates relative stability, followed by a period of substantial increase and then volatility, particularly in the later years.

Initial Period (2005-2009)
From 2005 to 2009, the P/BV ratio remained within a relatively narrow range, fluctuating between 2.36 and 3.38. This suggests a consistent market valuation of the company’s equity relative to its book value during this timeframe. A slight downward trend is observable between 2005 and 2009, potentially indicating a cautious market sentiment.
Increasing Valuation (2010-2014)
The period from 2010 to 2014 witnessed a marked increase in the P/BV ratio. Starting at 2.85 in 2010, the ratio climbed steadily to reach 8.68 in 2014. This indicates a growing investor confidence and a higher premium placed on the company’s net assets. The decline in book value per share during this period, while the P/BV ratio increased, suggests that share price growth outpaced the growth of equity.
Significant Volatility (2015-2024)
From 2015 onwards, the P/BV ratio experienced considerable volatility. It rose dramatically to 15.76 in 2015, peaking at 139.52 in 2018, before experiencing negative book values per share in 2019 and 2020. This period is characterized by extreme swings, potentially reflecting significant changes in market perception, profitability, or asset valuation. The negative book values in 2019 and 2020 are particularly noteworthy, indicating substantial accumulated losses or aggressive share repurchases relative to equity. A subsequent recovery in book value is observed in 2021, followed by another decline and then a rebound in 2023 and 2024. The P/BV ratio in 2024 is 25.72, lower than the peak but still elevated compared to the earlier years.
Future Projections (2025-2026)
The projected values for 2025 and 2026 suggest a continued, though moderated, valuation. The P/BV ratio is projected to be 52.57 in 2025 and 25.72 in 2026. This indicates a potential stabilization of the market’s assessment of the company’s value, although the significant decrease from 2025 to 2026 warrants further investigation.

Overall, the P/BV ratio demonstrates a complex pattern, shifting from relative stability to substantial growth and then significant volatility. The later years are marked by extreme fluctuations and, at times, negative book values, requiring careful consideration when evaluating the company’s financial health and market valuation.

AI Ask an analyst for more


Comparison to Competitors

Home Depot Inc., P/BV, long-term trends, comparison to competitors

Microsoft Excel

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), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03), 10-K (reporting date: 2018-01-28), 10-K (reporting date: 2017-01-29), 10-K (reporting date: 2016-01-31), 10-K (reporting date: 2015-02-01), 10-K (reporting date: 2014-02-02), 10-K (reporting date: 2013-02-03), 10-K (reporting date: 2012-01-29), 10-K (reporting date: 2011-01-30), 10-K (reporting date: 2010-01-31), 10-K (reporting date: 2009-02-01), 10-K (reporting date: 2008-02-03), 10-K (reporting date: 2007-01-28), 10-K (reporting date: 2006-01-29), 10-K (reporting date: 2005-01-30).


Comparison to Sector (Consumer Discretionary Distribution & Retail)

Home Depot Inc., P/BV, long-term trends, comparison to sector (consumer discretionary distribution & retail)

Microsoft Excel

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), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03), 10-K (reporting date: 2018-01-28), 10-K (reporting date: 2017-01-29), 10-K (reporting date: 2016-01-31), 10-K (reporting date: 2015-02-01), 10-K (reporting date: 2014-02-02), 10-K (reporting date: 2013-02-03), 10-K (reporting date: 2012-01-29), 10-K (reporting date: 2011-01-30), 10-K (reporting date: 2010-01-31), 10-K (reporting date: 2009-02-01), 10-K (reporting date: 2008-02-03), 10-K (reporting date: 2007-01-28), 10-K (reporting date: 2006-01-29), 10-K (reporting date: 2005-01-30).


Comparison to Industry (Consumer Discretionary)

Home Depot Inc., P/BV, long-term trends, comparison to industry (consumer discretionary)

Microsoft Excel

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), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03), 10-K (reporting date: 2018-01-28), 10-K (reporting date: 2017-01-29), 10-K (reporting date: 2016-01-31), 10-K (reporting date: 2015-02-01), 10-K (reporting date: 2014-02-02), 10-K (reporting date: 2013-02-03), 10-K (reporting date: 2012-01-29), 10-K (reporting date: 2011-01-30), 10-K (reporting date: 2010-01-31), 10-K (reporting date: 2009-02-01), 10-K (reporting date: 2008-02-03), 10-K (reporting date: 2007-01-28), 10-K (reporting date: 2006-01-29), 10-K (reporting date: 2005-01-30).