An independent two-stage DCF analysis by a frontier AI model.
Home Depot has faced significant headwinds recently, largely driven by a macroeconomic environment where high mortgage rates have effectively frozen the housing market. Existing homeowners are reluctant to move and give up low-rate mortgages, which temporarily suppresses large-scale home improvement projects. However, I view this as pent-up demand, not permanent destruction.
With an aging housing stock in the US and chronic underbuilding of new homes, the long-term tailwinds for repair and remodel (R&R) remain robust. My valuation model anticipates that as interest rates gradually normalize, the "locked-in" effect will dissipate, unleashing a wave of postponed projects. Combined with Home Depot's increasing penetration into the complex Pro market, this creates a compelling case for steady cash generation.
A 6.5% growth rate reflects Home Depot's status as a mature compounder. While the current environment is tough, the fundamental drivers—aging homes, rising home equity, and pro customer growth—remain intact. This rate assumes a moderate recovery and continued operational efficiency, despite current macroeconomic headwinds.
<div class="assumption-grid" data-astro-cid-dfeowo7v> <div class="assumption-card" data-astro-cid-dfeowo7v> <div class="card-title" data-astro-cid-dfeowo7v>FCF Growth Rate (Y1-Y5)
<div class="assumption-grid" data-astro-cid-dfeowo7v> <div class="assumption-card" data-astro-cid-dfeowo7v> <div class="card-title" data-astro-cid-dfeowo7v>FCF Growth Rate (Y1-Y5)
Intrinsic value per share under varying discount rate and terminal growth rate assumptions.
| WACC ↓ / Terminal → | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 1.5% | $365.88 | $299.36 | $253.30 | $219.53 | $193.70 |
| 2.0% | $411.62 | $329.30 | $274.41 | $235.21 | $205.81 |
| 2.5% | $470.42 | $365.88 | $299.36 | $253.30 | $219.53 |
| 3.0% | $548.83 | $411.62 | $329.30 | $274.41 | $235.21 |
| 3.5% | $658.59 | $470.42 | $365.88 | $299.36 | $253.30 |
■ Undervalued vs current price ■ Overvalued vs current price
Gemini projects that while the housing market is currently frozen due to high interest rates, pent-up remodeling demand will unlock as rates normalize. 6.5% reflects Home Depot's historical resilience and future pricing power.
An 8.0% discount rate was selected. This reflects a 4.18% 10-Year Treasury rate, a 1.04 Beta, and an equity risk premium, acknowledging Home Depot's immense scale, duopoly status, and strong dividend history.
A 2.5% terminal growth rate was used. Home Depot's long-term growth is closely tied to GDP and long-term inflation, making 2.5% a conservative but realistic perpetual growth rate for a mature retail giant.
No. This analysis is a demonstration of AI reasoning based on a specific set of inputs and rigid formulas. It is not financial advice. AI models cannot predict macroeconomic shifts, management changes, or unforeseeable economic events.
Disclaimer: The numbers presented on this page are for educational and entertainment purposes only. They are the result of a deterministic mathematical model fed with assumptions generated by an Artificial Intelligence (Gemini 3.1). This does not constitute investment advice. Always conduct your own due diligence before investing in the stock market.