The Home Depot, Inc.
(HD : NYQ)
Sector: Consumer Cyclical | Industry: Home Improvement Retail
$315.11
+5.23 (+1.69%)
MARKET CAP
$314.38B
FCF YIELD
3.42%
CURRENT PRICE
$315.11
P/E RATIO
22.05x
MODEL INPUTS
Intrinsic Fair Value
$124.94
per share
5-YEAR FREE CASH FLOW PROJECTIONS
| Year | Projected FCF | Discount Factor (WACC) | Present Value (PV) |
|---|---|---|---|
| Base (0) | $10.76B | - | - |
| Year 1 | $11.26B | at 4.6% growth | $10.33B |
| Year 2 | $11.78B | at 4.6% growth | $9.91B |
| Year 3 | $12.32B | at 4.6% growth | $9.51B |
| Year 4 | $12.88B | at 4.6% growth | $9.13B |
| Year 5 | $13.48B | at 4.6% growth | $8.76B |
VALUATION ARITHMETIC
| Valuation Step | Value |
|---|---|
| PV of Projected FCFs (Sum Y1-Y5) | $47.64B |
| Terminal Value (Perpetuity at 2.5%) | $212.51B |
| PV of Terminal Value | $138.12B |
| Enterprise Value (EV) | $185.76B |
| Less: Total Debt | -$63.19B |
| Add: Total Cash & Equivalents | +$2.08B |
| Equity Value | $124.65B |
| Divided by: Shares Outstanding | 997,689,626.00 |
| Intrinsic Value (Fair Value per Share) | $124.94 |
FINANCIAL RATIOS & STATS
| Financial Metric | Value |
|---|---|
| Trailing P/E | 22.05x |
| Forward P/E | 19.66x |
| Price-to-Book (P/B) | 18.93x |
| Price-to-Sales (P/S) | 1.86x |
| Net Profit Margin (Net Income / Revenue) | 8.41% |
| Operating Profit Margin (EBIT / Revenue) | 12.86% |
| Return on Equity (ROE) | 104.30% |
| Return on Assets (ROA) | 12.14% |
| Dividend Rate | $9.32 |
| Dividend Yield | 2.96% |
| Ex-Dividend Date | 2026-09-03 |
| Next Earnings Date | 2026-11-17 |