Home Depot Inc. (NYSE:HD)

The valuation ratios exhibit varied trends over the observed period. Generally, ratios decreased from 2021 to 2023, followed by increases in 2024, and then a leveling or further decrease in the projected years of 2025 and 2026. These fluctuations suggest shifting investor sentiment and potentially changing market perceptions of the company’s future earnings and asset value.

Price to Earnings (P/E) Ratio

The Price to Earnings ratio decreased from 24.51 in 2021 to 17.09 in 2023, indicating a declining valuation relative to earnings. A subsequent increase to 24.80 in 2024 suggests renewed investor confidence or a rise in earnings expectations. Projections for 2025 and 2026 show a slight decrease to 23.58 and 23.28 respectively, potentially signaling a stabilization of valuation relative to earnings.

Price to Operating Profit (P/OP) Ratio

A consistent downward trend was observed in the Price to Operating Profit ratio from 2021 to 2023, falling from 17.25 to 12.16. This indicates that the market was valuing the company at a lower multiple of its operating profits. The ratio increased to 17.32 in 2024, followed by a slight decrease to 16.22 in 2025 and 15.78 in 2026, suggesting a potential plateauing of valuation relative to operating profitability.

Price to Sales (P/S) Ratio

The Price to Sales ratio followed a similar pattern to the other multiples, decreasing from 2.39 in 2021 to 1.86 in 2023. An increase to 2.46 in 2024 was then observed, followed by a decrease to 2.19 in 2025 and 2.00 in 2026. This suggests fluctuations in the market’s willingness to pay for each dollar of revenue generated.

Price to Book Value (P/BV) Ratio

The Price to Book Value ratio experienced the most significant fluctuations. It began at 95.58 in 2021, with no value reported for 2022, then increased dramatically to 187.12 in 2023 and further to 359.76 in 2024. This substantial increase suggests a significant shift in how the market values the company’s net assets. The ratio then decreased considerably to 52.57 in 2025 and 25.72 in 2026, indicating a potential correction or a change in investor perception regarding the company’s asset value. The absence of a value for 2022 warrants further investigation.

Overall, the observed trends suggest a period of valuation adjustment followed by stabilization, with the Price to Book Value ratio exhibiting the most volatility. The projected values for 2025 and 2026 indicate a potential moderation in valuation multiples across the board.

The price to earnings (P/E) ratio exhibited fluctuations over the observed period. Initially, the P/E ratio decreased from 24.51 in January 2021 to 19.94 in January 2022, indicating a potential increase in investor confidence relative to earnings, or a decrease in perceived risk. This downward trend continued to January 2023, reaching a low of 17.09. Subsequently, the ratio increased to 24.80 in January 2024, before moderating to 23.58 in February 2025 and 23.28 in February 2026.

Share Price Trend

The share price demonstrated an initial increase from US$292.75 in January 2021 to US$317.05 in January 2022. A subsequent decline was observed, reaching US$287.97 in January 2023. The share price then experienced a significant increase to US$378.99 in January 2024, followed by a slight decrease to US$351.15 in February 2025 and a further decrease to US$330.93 in February 2026.

Earnings Per Share (EPS) Trend

Earnings per share increased from US$11.95 in January 2021 to US$15.90 in January 2022, and further to US$16.85 in January 2023. A decrease in EPS was then observed, falling to US$15.28 in January 2024, US$14.89 in February 2025, and US$14.21 in February 2026. This suggests a potential slowing of earnings growth.

P/E Ratio and EPS Relationship

The initial decrease in the P/E ratio alongside increasing EPS from 2021 to 2023 suggests that while earnings were growing, investor valuation expectations did not increase proportionally. The subsequent increase in the P/E ratio in January 2024, despite a decrease in EPS, indicates that investors were willing to pay a higher premium for each dollar of earnings. The stabilization of the P/E ratio in February 2025 and February 2026, coupled with continued declining EPS, suggests a potential leveling off of investor sentiment.

Overall, the observed trends indicate a dynamic relationship between share price, earnings, and investor valuation. The P/E ratio’s fluctuations suggest shifts in market sentiment and expectations regarding future earnings potential.

The Price to Operating Profit (P/OP) ratio exhibited fluctuating behavior over the observed period. Initially, a decrease is noted, followed by an increase, and then a stabilization towards the end of the period. The share price and operating profit per share both influenced this ratio’s movement.

Overall Trend

The P/OP ratio began at 17.25 in January 2021, decreased to a low of 12.16 in January 2023, then increased to 17.32 in January 2024. Subsequently, the ratio moderated, ending at 15.78 in February 2026. This suggests periods of investor optimism and pessimism regarding the company’s operating profitability relative to its market price.

Share Price Influence

The share price demonstrated an initial increase from US$292.75 in January 2021 to US$317.05 in January 2022. A subsequent decline to US$287.97 in January 2023 was observed, followed by a substantial increase to US$378.99 in January 2024. The share price then decreased to US$330.93 by February 2026. These fluctuations directly impacted the P/OP ratio, particularly in conjunction with changes in operating profit per share.

Operating Profit per Share Influence

Operating profit per share increased from US$16.97 in January 2021 to US$22.30 in January 2022, and further to US$23.68 in January 2023. A decrease to US$21.89 in January 2024 was then recorded, followed by a slight decline to US$20.97 in February 2026. The increase in operating profit per share between 2021 and 2023 contributed to the initial decrease in the P/OP ratio, while the subsequent decrease in operating profit per share in 2024 and beyond contributed to the ratio’s stabilization and slight increase.

Recent Period (2024-2026)

From January 2024 to February 2026, the P/OP ratio experienced a relatively stable period, fluctuating between 16.22 and 15.78. This suggests a balance between investor valuation and the company’s operating performance during this timeframe. The share price decreased while operating profit per share also decreased, resulting in a relatively consistent P/OP ratio.

In summary, the P/OP ratio’s movements reflect the interplay between market sentiment, as indicated by the share price, and the company’s underlying operating profitability. The observed trends suggest periods of both increasing and decreasing investor confidence in the company’s ability to generate profits from its operations.

The price to sales ratio exhibited fluctuations over the observed period. Initially, the ratio decreased from 2021 to 2023, followed by an increase in 2024, and then a subsequent decline projected through 2026.

Overall Trend

The price to sales ratio began at 2.39 in 2021, decreased to a low of 1.86 in 2023, increased to 2.46 in 2024, and is projected to decrease to 2.00 by 2026. This indicates a period of contraction followed by expansion, and then a renewed contraction.

2021-2023 Performance

From 2021 to 2023, the price to sales ratio experienced a consistent decline. This decrease suggests that the market valuation relative to sales decreased during this period, potentially due to factors such as changing investor sentiment, increased competition, or concerns about future sales growth. The decline from 2.39 to 1.86 represents a reduction of approximately 22.2%.

2024 Reversal

In 2024, the price to sales ratio increased significantly to 2.46. This reversal of the prior trend could be attributed to positive company performance, improved market conditions, or a reassessment of the company’s growth prospects. The increase from 1.86 to 2.46 represents an increase of approximately 32.3%.

Projected 2025-2026 Performance

The projections for 2025 and 2026 indicate a further decrease in the price to sales ratio, reaching 2.19 and 2.00 respectively. This suggests a potential moderation of the market’s positive sentiment observed in 2024, or expectations of slower sales growth in the future. The projected decrease from 2.46 to 2.00 represents a reduction of approximately 18.7%.

Relationship to Sales per Share

Sales per share generally increased throughout the period, from US$122.66 in 2021 to a projected US$165.34 in 2026. The fluctuations in the price to sales ratio, despite increasing sales per share, suggest that share price movements were not solely driven by sales performance. Other factors, such as broader market conditions or company-specific news, likely played a significant role.

The price to book value ratio exhibits considerable fluctuation over the observed period. Initially high, the ratio experienced a dramatic shift, followed by a period of stabilization and then a decline.

Initial Valuation (2021-2022)

In January 2021, the price to book value ratio stood at 95.58. A value for January 2022 is absent, indicating a potential reporting gap or significant change that prevented calculation. This absence makes trend analysis between these two periods impossible.

Significant Increase (2023)

By January 2023, the ratio had risen substantially to 187.12. This increase suggests a significant premium placed on the company’s stock price relative to its book value. This could be attributed to investor expectations of future growth, improved profitability, or market sentiment.

Peak and Subsequent Decline (2024-2026)

The ratio peaked in January 2024 at 359.76, representing the highest valuation observed during the period. Following this peak, a marked decline is evident. The ratio decreased to 52.57 in February 2025 and further to 25.72 in February 2026. This downward trend suggests a correction in valuation, potentially driven by changes in market conditions, company performance, or investor perception.

Book Value Per Share Trend

The book value per share demonstrates a volatile pattern. A negative value in January 2022 (-1.64) is unusual and warrants further investigation into the underlying accounting factors. Subsequent increases are observed, reaching 6.68 in February 2025 and 12.86 in February 2026. This increasing book value, coupled with the declining price to book value ratio, reinforces the notion of a valuation correction.

The observed fluctuations in the price to book value ratio, alongside the changes in book value per share, indicate a dynamic valuation landscape. The substantial decline from the 2024 peak suggests a potential shift in investor sentiment or a reassessment of the company’s intrinsic value.