Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

The Home Depot, Inc.

Intrinsic Value Analysis (Discounted Cash Flow)Industry: Home ImprovementSector: Consumer Cyclical

Fair Value Summary

Current Price$357.02
5Y Range247.24 – 404.39
5Y Selected325.82
(-) Safety Margin36.71%
5Y Buy Price$206.21
Upside (to Buy Price)-42.24%
10Y Range281.79 – 445.00
10Y Selected363.40
(-) Safety Margin36.71%
10Y Buy Price$229.99
Upside (to Buy Price)-35.58%

Company Predictability & Safety

MetricValue
Revenue R2 (5Y)0.6717
Revenue R2 (10Y)0.9365
Net Income R2 (5Y)0.0625
Net Income R2 (10Y)0.8384
EBITDA R2 (5Y)0.3088
EBITDA R2 (10Y)0.8868
FCF R2 (5Y)0.0582
FCF R2 (10Y)0.7399
Safety Score0.6329

DA 10-Year Projection

Metric2026202720282029203020312032203320342035
% Growth8.26%7.78%7.31%6.84%6.36%5.89%5.42%4.95%4.47%4.00%
Revenue172,681.88186,120.37199,724.74213,379.26226,958.48240,328.86253,350.68265,880.28277,772.51288,883.41
EBITDA29,955.3332,286.5234,646.4837,015.1539,370.7541,690.1343,949.0446,122.5648,185.5250,112.94
D&A-3,536.73-3,811.96-4,090.60-4,370.26-4,648.38-4,922.22-5,188.92-5,445.54-5,689.11-5,916.67
EBIT26,418.6028,474.5530,555.8932,644.8934,722.3836,767.9138,760.1240,677.0242,496.4144,196.27
Pro forma Taxes-7,069.78-7,619.96-8,176.94-8,735.97-9,291.92-9,839.31-10,372.44-10,885.41-11,372.29-11,827.19
NOPAT19,348.8220,854.5922,378.9523,908.9225,430.4626,928.6028,387.6829,791.6131,124.1232,369.09
Capital Expenditures-3,439.06-3,706.69-3,977.63-4,249.57-4,520.01-4,786.29-5,045.62-5,295.16-5,532.00-5,753.28
NWC Investment-594.92-607.15-614.64-616.91-613.51-604.07-588.32-566.08-537.29-501.99
(+) D&A3,536.733,811.964,090.604,370.264,648.384,922.225,188.925,445.545,689.115,916.67
Free Cash Flow18,851.5720,352.7221,877.2723,412.7024,945.3226,460.4627,942.6529,375.9130,743.9432,030.49
Diluted Shares Outstanding994,000,000.00994,000,000.00994,000,000.00994,000,000.00994,000,000.00994,000,000.00994,000,000.00994,000,000.00994,000,000.00994,000,000.00

Discounting Periods

MetricJan-26Jan-27Jan-28Jan-29Jan-30Jan-31Jan-32Jan-33Jan-34Jan-35
Period Start11/2/252/1/262/1/272/1/282/1/292/1/302/1/312/1/322/1/332/1/34
Period End1/31/261/31/271/31/281/31/291/31/301/31/311/31/321/31/331/31/341/31/35
Mid-Point12/17/258/2/268/2/278/1/288/2/298/2/308/2/318/1/328/2/338/2/34
Time (t)0.100.541.542.543.554.555.556.557.558.55
Valuation Date1/16/26

Base Case Projected Flows

WACC: 9.10%Terminal Growth: 2.47%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.950.870.800.730.670.620.570.520.47
PV UFCF18,688.1319,417.8619,131.7818,767.0918,312.1617,804.5517,233.9316,607.0015,930.9915,213.53
Raw: 385,550.53
270,971.31
Raw: 495,057.63
225,119.86

Base Case Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value365,288.32402,226.89
(-) Net Debt59,083.0059,083.00
Equity Value306,205.32343,143.89
(/) Shares Out994.00994.00
Fair Value$308.05$345.22
(-) Safety Margin36.71%36.71%
Buy Price$194.97$218.49
Current Price$357.02$357.02
Upside (to Buy Price)-45.39%-38.80%

Conservative Projected Flows

WACC: 10.10%Terminal Growth: 1.97%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.950.860.780.710.650.590.530.480.44
PV UFCF18,671.0919,322.4218,864.8318,337.1517,728.5117,080.5116,382.9415,643.5714,870.4714,071.79
Raw: 312,879.36
211,919.16
Raw: 401,745.82
168,208.34

Conservative Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value304,843.15339,181.63
(-) Net Debt59,083.0059,083.00
Equity Value245,760.15280,098.63
(/) Shares Out994.00994.00
Fair Value$247.24$281.79
(-) Safety Margin36.71%36.71%
Buy Price$156.48$178.34
Current Price$357.02$357.02
Upside (to Buy Price)-56.17%-50.05%

Aggressive Projected Flows

WACC: 8.10%Terminal Growth: 2.97%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.960.890.820.760.700.650.600.560.51
PV UFCF18,705.3519,514.6519,405.0119,211.2118,920.6718,566.3718,137.5917,639.4717,077.9716,459.73
Raw: 500,721.53
365,287.45
Raw: 642,940.40
317,775.86

Aggressive Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value461,044.34501,413.89
(-) Net Debt59,083.0059,083.00
Equity Value401,961.34442,330.89
(/) Shares Out994.00994.00
Fair Value$404.39$445.00
(-) Safety Margin36.71%36.71%
Buy Price$255.94$281.64
Current Price$357.02$357.02
Upside (to Buy Price)-28.31%-21.11%

Reverse DCF: Market Implied Growth

Current Price$357.02
WACC Used9.1%
IMPLIED REVENUE GROWTH125.60%
Metric2027202820292030203120322033203420352036
Implied Revenue374,919.30845,810.991,908,133.894,304,714.659,711,356.3721,908,639.7949,425,484.86111,502,976.76251,548,646.68567,489,079.50
Constant Implied Growth125.60%125.60%125.60%125.60%125.60%125.60%125.60%125.60%125.60%125.60%
Implied Free Cash Flow37.4984.58190.81430.47971.142,190.864,942.5511,150.3025,154.8656,748.91
Discount Factor0.960.870.800.730.670.620.570.520.470.44
Present Value of Implied FCF36.1573.97152.95316.01653.451,351.242,794.165,777.9011,947.8124,706.27

Rolling Historical DCF (Backtest)

Valuation based on actual realized growth.
YearValuation DateActual PriceRealized Growth (5Y)Calculated Fair ValueValuation Delta
20202020-01-31$228.106.03%$165.43-27.48%
20192019-01-31$183.5310.56%$198.938.39%
20182018-01-31$200.9013.15%$206.312.69%
20172017-01-31$137.5812.87%$155.5413.05%
20162016-01-31$126.5111.01%$133.605.60%
20152015-01-31$104.429.62%$104.04-0.37%
20142014-01-31$76.8510.63%$94.8823.46%
20132013-01-31$66.9210.89%$85.0127.04%
20122012-01-31$44.3910.94%$77.8775.42%
20112011-01-31$36.7710.81%$45.0122.42%
20102010-01-31$28.3910.25%$52.7885.90%
20092009-01-31$21.538.72%$41.4592.54%
20082008-01-31$30.644.62%$14.57-52.44%
20072007-01-31$40.741.22%$26.46-35.05%
20062006-01-31$40.550.78%$18.41-54.59%
20052005-01-31$41.261.59%$20.87-49.43%
20042004-01-31$35.475.86%$20.63-41.84%
20032003-01-31$20.909.25%$20.06-4.03%
20022002-01-31$50.0911.62%$27.72-44.67%
20012001-01-31$48.2013.00%$-9.20-119.09%
20002000-01-31$56.6312.47%$-1.81-103.20%
19991999-01-31$39.4212.43%$-5.34-113.55%
19981998-01-31$20.1714.94%$-6.36-131.52%
19971997-01-31$11.0018.31%$-1.90-117.29%
19961996-01-31$10.2220.22%$-9.73-195.17%

Monte Carlo Simulation (1,000 Iterations)

Mean Fair Value
$356.62
Median
$346.63
10th Percentile
$282.70
90th Percentile
$445.49

Fair Value Distribution

$203.47 - $229.79
2
$229.79 - $256.12
25
$256.12 - $282.44
73
$282.44 - $308.76
147
$308.76 - $335.09
183
$335.09 - $361.41
173
$361.41 - $387.74
136
$387.74 - $414.06
82
$414.06 - $440.38
71
$440.38 - $466.71
38
$466.71 - $493.03
26
$493.03 - $519.36
18
$519.36 - $545.68
11
$545.68 - $572.00
6
$572.00 - $598.33
6
$598.33 - $624.65
0
$624.65 - $650.98
0
$650.98 - $677.30
2
$677.30 - $703.62
0
$703.62 - $729.95
1