Definitive Analysis
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$403.03 - $1,360.61$659.74
Multi-Stage$270.27 - $294.84$282.33
Blended Fair Value$471.03
Current Price$378.35
Upside24.50%
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$403.03$659.74$1,360.61
Upside / Downside6.52%74.37%259.62%

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.949,714.169,805.37
Year 2 PV (M)10,110.8910,303.4810,497.88
Year 3 PV (M)10,563.5310,866.7711,175.76
Year 4 PV (M)10,982.4511,404.8011,839.22
Year 5 PV (M)11,369.2011,918.3412,488.49
PV of Terminal Value (M)215,995.73226,428.40237,260.36
Equity Value (M)268,644.74280,635.95293,067.08
Shares Outstanding (M)994.00994.00994.00
Fair Value$270.27$282.33$294.84
Upside / Downside-28.57%-25.38%-22.07%

High-Yield Dividend Screener

« Prev Page 43 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
9541.SRAcademy Of Learning Company3.74%$0.4378.32%
BBCA.JKPT Bank Central Asia Tbk3.74%$300.0564.91%
BKGI.BKBangkok Genomics Innovation Public Company Limited3.74%$0.0588.71%
DACDanaos Corporation3.74%$3.5614.02%
JKON.JKPT Jaya Konstruksi Manggala Pratama Tbk3.74%$3.2545.42%
MDKI.JKPT Emdeki Utama Tbk3.74%$8.0062.54%
NORCO.OLNorconsult ASA3.74%$1.6672.73%
SLCE3.SASLC Agrícola S.A.3.74%$0.5541.84%
3948.HKInner Mongolia Yitai Coal Co., Ltd.3.73%$0.6524.32%
IDPR.JKPT Indonesia Pondasi Raya Tbk3.73%$10.0075.77%
KIMBERA.MXKimberly-Clark de México, S. A. B. de C. V.3.73%$1.4357.51%
PGMN3.SAEmpreendimentos Pague Menos S.A.3.73%$0.2374.59%
QIBK.QAQatar Islamic Bank (Q.P.S.C.)3.73%$0.8944.73%
002367.SZCanny Elevator Co., Ltd.3.72%$0.3060.41%
600300.SSV V Food & Beverage Co.,Ltd3.72%$0.1351.92%
603899.SSShanghai M&G Stationery Inc.3.72%$1.0169.72%
RHC.AXRamsay Health Care Limited3.72%$1.2932.49%
000999.SZChina Resources Sanjiu Medical & Pharmaceutical Co., Ltd.3.71%$1.0663.26%
214180.KQHecto Innovation Co., Ltd.3.71%$602.8723.75%
603948.SSZhejiang Jianye Chemical Co., Ltd.3.71%$1.0175.31%
6089.TWill Group, Inc.3.71%$44.4274.52%
QNNS.QAQatar Navigation Q.P.S.C.3.71%$0.4038.98%
016610.KSDB Securities Co., Ltd.3.70%$404.3430.24%
2471.TS-Pool, Inc.3.70%$10.1043.62%
3430.TWOChitec Technology Co., Ltd.3.70%$2.5075.20%
4560.TWStrong H Machinery Technology (Cayman) Incorporation3.70%$1.2042.07%
5347.KLTenaga Nasional Berhad3.70%$0.5162.35%
LOOMIS.STLoomis AB (publ)3.70%$14.1053.46%
MIDW-A.STMidway Holding AB (publ)3.70%$0.9165.00%
PNDORA.COPandora A/S3.70%$25.7237.06%
SPVI.BKS P V I Public Company Limited3.70%$0.0837.67%
3401.TTeijin Limited3.69%$49.9735.81%
BZU.MIBuzzi Unicem S.p.A.3.69%$1.9018.48%
CWP.AXCedar Woods Properties Limited3.69%$0.3115.67%
CX.STCombinedX AB (publ)3.69%$1.3755.29%
REH.AXReece Limited3.69%$0.4943.22%
000783.SZChangjiang Securities Company Limited3.68%$0.3043.98%
014820.KSDongwon Systems Corporation3.68%$916.7745.73%
2245.HKLygend Resources & Technology Co., Ltd.3.68%$0.9136.29%
5DD.SIMicro-Mechanics (Holdings) Ltd.3.68%$0.0666.85%
600598.SSHeilongjiang Agriculture Company Limited3.68%$0.5589.21%
601156.SSEastern Air Logistics Co., Ltd.3.68%$0.6841.00%
NICL.JKPT PAM Mineral Tbk3.68%$51.0099.38%
PNBN.JKP.T. Bank Pan Indonesia Tbk3.68%$42.0037.86%
3617.TWCyber Power Systems, Inc.3.67%$7.6445.54%
5296.KLMr D.I.Y. Group (M) Berhad3.67%$0.0687.61%
600535.SSTasly Pharmaceutical Group Co., Ltd3.67%$0.5575.36%
8424.TFuyo General Lease Co., Ltd.3.67%$157.5152.44%
9937.TWNational Petroleum Co., Ltd.3.67%$2.1088.32%
KEMIRA.HEKemira Oyj3.67%$0.7249.87%