Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Analysis Mode

Ticker

Industry

Sector

The Home Depot, Inc. (HD)

Company Dividend Discount ModelIndustry: Home ImprovementSector: Consumer Cyclical

Valuation Snapshot

Stable Growth$402.72 - $1,357.61$658.98
Multi-Stage$270.15 - $294.70$282.20
Blended Fair Value$470.59
Current Price$378.35
Upside24.38%
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.57%8.57%8.57%
Growth Rate5.50%6.50%7.50%
Fair Value$402.72$658.98$1,357.61
Upside / Downside6.44%74.17%258.82%

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.57%8.57%8.57%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)9,622.739,713.949,805.15
Year 2 PV (M)10,110.4510,303.0310,497.42
Year 3 PV (M)10,562.8410,866.0611,175.03
Year 4 PV (M)10,981.4911,403.8111,838.19
Year 5 PV (M)11,367.9711,917.0412,487.13
PV of Terminal Value (M)215,880.52226,307.63237,133.81
Equity Value (M)268,526.00280,511.51292,936.74
Shares Outstanding (M)994.00994.00994.00
Fair Value$270.15$282.20$294.70
Upside / Downside-28.60%-25.41%-22.11%

High-Yield Dividend Screener

« Prev Page 59 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
QFBQ.QALesha Bank L.L.C2.69%$0.0532.62%
002442.SZLongxing Chemical Stock Co., Ltd.2.68%$0.1799.79%
016800.KSFursys Inc.2.68%$1,200.1730.47%
265520.KQAdvanced Process Systems Corporation2.68%$538.1030.22%
300896.SZImeik Technology Development Co.,Ltd.2.68%$3.8078.17%
3123.TSaibo Co., Ltd.2.68%$16.1426.87%
9057.TEnshu Truck Co.,Ltd.2.68%$96.0831.06%
CHC.AXCharter Hall Group2.68%$0.6553.83%
IFT.AXInfratil Limited2.68%$0.2647.86%
KRZ.IRKerry Group plc2.68%$2.0427.68%
MGH.AXMAAS Group Holdings Limited2.68%$0.1537.02%
NOANorth American Construction Group Ltd.2.68%$0.3932.95%
U06.SISingapore Land Group Limited2.68%$0.0924.45%
000089.SZShenzhen Airport Co., Ltd.2.67%$0.1965.57%
000830.SZLuxi Chemical Group Co., Ltd.2.67%$0.4457.18%
005820.KSWonlim Corporation2.67%$399.8822.01%
007980.KSTP Inc.2.67%$51.627.46%
049800.KSWoojin Plaimm Co., Ltd.2.67%$50.6726.03%
300009.SZAnhui Anke Biotechnology (Group) Co., Ltd.2.67%$0.2662.51%
6220.TWOYFC-Boneagle Electric Co., Ltd.2.67%$0.6989.25%
002753.SZShanxi Yongdong Chemistry Industry Co., Ltd.2.66%$0.1990.03%
011200.KSHMM Co.,Ltd2.66%$537.6722.84%
014830.KSUNID Company Ltd.2.66%$1,782.2616.95%
023450.KSDongnam Chemical Co., Ltd.2.66%$914.8545.96%
210540.KSDY Power Corporation2.66%$350.1314.53%
600729.SSChongqing Department Store Co.,Ltd.2.66%$0.6921.76%
7282.TToyoda Gosei Co., Ltd.2.66%$104.8829.11%
7989.TTachikawa Corporation2.66%$52.4433.02%
9699.TNishio Rent All Co., Ltd.2.66%$125.9628.89%
069730.KSDSR Wire Corp2.65%$99.936.22%
118990.KQMotrex Co., Ltd2.65%$249.2535.67%
OLGERD.ICÖlgerðin Egill Skallagrímsson hf.2.65%$0.4862.79%
084010.KSDaehan Steel Co., Ltd.2.64%$516.5429.55%
0DH7.LAF Gruppen ASA2.64%$4.9752.35%
1504.TWTECO Electric & Machinery Co., Ltd.2.64%$2.2387.91%
2587.TSuntory Beverage & Food Limited2.64%$125.0045.12%
6922.TWONeousys Technology Inc.2.64%$4.5461.30%
SHR.BKS Hotels and Resorts Public Company Limited2.64%$0.0533.96%
002871.SZQingdao Weflo Valve Co., Ltd.2.63%$0.4779.89%
600918.SSZhongtai Securities Co., Ltd.2.63%$0.1768.20%
8572.TAcom Co., Ltd.2.63%$13.0038.71%
LIAB.STLindab International AB (publ)2.63%$5.4076.19%
MYOR.JKPT Mayora Indah Tbk2.63%$57.3845.12%
002443.SZZhejiang Kingland Pipeline and Technologies Co.,Ltd.2.62%$0.2164.11%
039490.KSKiwoom Securities Co., Ltd.2.62%$7,904.3320.30%
155660.KSDSR Corp2.62%$100.1511.70%
4263.SRSAL Saudi Logistics Services Co2.62%$4.2355.27%
AFK.OLArendals Fossekompani ASA2.62%$3.525.05%
INSTAL.STInstalco AB (publ)2.62%$0.6865.47%
000048.SZShenzhen Kingkey Smart Agriculture Times Co.,Ltd2.61%$0.4658.98%