Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

The Home Depot, Inc. (HD)

Company Dividend Discount ModelIndustry: Home ImprovementSector: Consumer Cyclical

Valuation Snapshot

Stable Growth$402.49 - $1,355.39$658.43
Multi-Stage$270.06 - $294.61$282.11
Blended Fair Value$470.27
Current Price$378.35
Upside24.29%
DecisionDon't Buy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2025202420232022202120202019201820172016
DPS8.43%13.44%8.988.437.847.036.495.994.734.243.423.05
YoY Growth--6.51%7.63%11.51%8.28%8.27%26.66%11.68%23.74%12.31%19.80%
Dividend Yield--2.48%2.50%2.63%2.29%1.97%2.70%2.37%2.29%2.22%2.24%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)14,582.00
(-) Cash Dividends Paid (M)9,098.00
(=) Cash Retained (M)5,484.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)2,916.401,822.751,093.65
Cash Retained (M)5,484.005,484.005,484.00
(-) Cash Required (M)-2,916.40-1,822.75-1,093.65
(=) Excess Retained (M)2,567.603,661.254,390.35
(/) Shares Outstanding (M)994.00994.00994.00
(=) Excess Retained per Share2.583.684.42
LTM Dividend per Share9.159.159.15
(+) Excess Retained per Share2.583.684.42
(=) Adjusted Dividend11.7412.8413.57
WACC / Discount Rate8.58%8.58%8.58%
Growth Rate5.50%6.50%7.50%
Fair Value$402.49$658.43$1,355.39
Upside / Downside6.38%74.03%258.24%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)14,582.0015,529.8316,539.2717,614.3218,759.2519,978.6020,577.96
Payout Ratio62.39%67.91%73.44%78.96%84.48%90.00%92.50%
Projected Dividends (M)9,098.0010,546.8712,145.6413,907.7015,847.5217,980.7419,034.61

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate8.58%8.58%8.58%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)9,622.589,713.799,805.00
Year 2 PV (M)10,110.1310,302.6910,497.08
Year 3 PV (M)10,562.3210,865.5311,174.48
Year 4 PV (M)10,980.7811,403.0711,837.42
Year 5 PV (M)11,367.0511,916.0812,486.12
PV of Terminal Value (M)215,795.03226,218.01237,039.90
Equity Value (M)268,437.88280,419.17292,840.01
Shares Outstanding (M)994.00994.00994.00
Fair Value$270.06$282.11$294.61
Upside / Downside-28.62%-25.44%-22.13%

High-Yield Dividend Screener

« Prev Page 76 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
DR.TOMedical Facilities Corporation1.80%$0.287.21%
PINE3.SABanco Pine S.A.1.80%$0.2316.47%
SVED-B.STSvedbergs i Dalstorp AB (publ)1.80%$1.2532.77%
002296.SZHeNan Splendor Science & Technology Co., Ltd.1.79%$0.2025.74%
002349.SZJinghua Pharmaceutical Group Co., Ltd.1.79%$0.1347.07%
002841.SZGuangzhou Shiyuan Electronic Technology Company Limited1.79%$0.7153.65%
007690.KSKukdo Chemical Co., Ltd.1.79%$569.7119.70%
010690.KSHWASHIN CO.,Ltd1.79%$145.8913.31%
049770.KSDongwon F&B Co., Ltd.1.79%$800.0312.97%
1836.HKStella International Holdings Limited1.79%$0.2778.00%
5ML.SIOld Chang Kee Ltd.1.79%$0.0221.40%
603456.SSZhejiang Jiuzhou Pharmaceutical Co., Ltd1.79%$0.3239.16%
6245.THIRANO TECSEED Co.,Ltd.1.79%$29.9248.19%
9999.HKNetEase, Inc.1.79%$4.1136.47%
EFK.WAKorporacja Gospodarcza Efekt S.A.1.79%$0.103.27%
IFSH.JKPT Ifishdeco Tbk1.79%$14.6252.99%
WGSH.JKPT Wira Global Solusi Tbk1.79%$5.0059.74%
001060.KSJW Pharmaceutical Corporation1.78%$458.4617.63%
001332.SZWuxi Chemical Equipment Co., Ltd.1.78%$1.0044.53%
002312.SZSichuan Development Lomon Co., Ltd.1.78%$0.1967.49%
002900.KSTYM Corporation1.78%$112.2711.09%
003018.SZJinFu Technology Co., Ltd.1.78%$0.3168.11%
003023.SZChengdu Rainbow Appliance (Group) Shares Co., Ltd.1.78%$0.4051.85%
004490.KSSebang Global Battery Co., Ltd.1.78%$1,112.7311.15%
0KFH.LRevenio Group Oyj1.78%$0.4058.60%
1357.HKMeitu, Inc.1.78%$0.1344.58%
300610.SZYangzhou Chenhua New Material Co., Ltd.1.78%$0.2163.13%
3543.TKOMEDA Holdings Co., Ltd.1.78%$54.0341.58%
5450.TWONam Liong Global Corporation1.78%$0.2545.91%
600458.SSZhuzhou Times New Material Technology Co., Ltd.1.78%$0.2437.98%
603037.SSShanghai Carthane Co.,Ltd.1.78%$0.2678.70%
603876.SSJiangsu Dingsheng New Material Joint-Stock Co.,Ltd1.78%$0.2764.69%
603916.SSSobute New Materials Co., Ltd1.78%$0.1762.46%
6167.TFuji Die Co.,Ltd.1.78%$15.9369.67%
6981.TMurata Manufacturing Co., Ltd.1.78%$57.8845.13%
FLEXD.LSFlexdeal Simfe S.A.1.78%$0.0938.33%
MIKA.JKPT Mitra Keluarga Karyasehat Tbk1.78%$43.0046.34%
SARKY.ISSarkuysan Elektrolitik Bakir Sanayi ve Ticaret A.S.1.78%$0.3353.78%
002249.SZZhongshan Broad-Ocean Motor Co., Ltd.1.77%$0.1944.29%
012330.KSHyundai Mobis Co.,Ltd1.77%$6,540.9013.98%
111770.KSYoungone Corporation1.77%$1,406.1316.14%
2754.TTokatsu Holdings Co.,Ltd.1.77%$14.3118.28%
600236.SSGuangxi Guiguan Electric PowerCo.,Ltd.1.77%$0.1442.95%
603605.SSProya Cosmetics Co.,Ltd.1.77%$1.2130.20%
603759.SSHaitian Water Group Co.,Ltd1.77%$0.1932.54%
688076.SSSinopep-Allsino Bio Pharmaceutical Co.,Ltd.1.77%$0.6742.24%
8015.TToyota Tsusho Corporation1.77%$93.3828.94%
9722.TFujita Kanko Inc.1.77%$46.655.91%
9962.TMISUMI Group Inc.1.77%$43.3636.74%
ADORFO.BOAdor Fontech Limited1.77%$2.5238.55%