Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

The Sherwin-Williams Company (0L5V.L)

Company Dividend Discount ModelIndustry: Industrial MaterialsSector: Basic Materials

Valuation Snapshot

Stable Growth$1,723.55 - $2,030.64$1,903.00
Multi-Stage$425.44 - $466.21$445.45
Blended Fair Value$1,174.23
Current Price$346.26
Upside239.12%
DecisionBuy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2024202320222021202020192018201720162015
DPS11.44%12.89%2.872.482.462.331.941.671.281.271.240.99
YoY Growth--15.99%0.84%5.35%20.31%15.97%30.32%1.22%2.22%25.01%15.97%
Dividend Yield--0.82%0.73%1.09%0.93%0.79%1.09%0.89%0.97%1.20%1.04%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)2,571.80
(-) Cash Dividends Paid (M)773.80
(=) Cash Retained (M)1,798.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)514.36321.48192.89
Cash Retained (M)1,798.001,798.001,798.00
(-) Cash Required (M)-514.36-321.48-192.89
(=) Excess Retained (M)1,283.641,476.531,605.12
(/) Shares Outstanding (M)251.88251.88251.88
(=) Excess Retained per Share5.105.866.37
LTM Dividend per Share3.073.073.07
(+) Excess Retained per Share5.105.866.37
(=) Adjusted Dividend8.178.939.44
WACC / Discount Rate5.49%5.49%5.49%
Growth Rate5.50%6.50%7.50%
Fair Value$1,723.55$1,903.00$2,030.64
Upside / Downside397.76%449.59%486.45%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)2,571.802,738.972,917.003,106.603,308.533,523.593,629.30
Payout Ratio30.09%42.07%54.05%66.04%78.02%90.00%92.50%
Projected Dividends (M)773.801,152.291,576.722,051.452,581.243,171.233,357.10

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate5.49%5.49%5.49%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)1,082.121,092.371,102.63
Year 2 PV (M)1,390.521,417.001,443.74
Year 3 PV (M)1,699.001,747.781,797.47
Year 4 PV (M)2,007.582,084.782,164.19
Year 5 PV (M)2,316.242,428.112,544.27
PV of Terminal Value (M)98,661.22103,426.59108,374.35
Equity Value (M)107,156.67112,196.64117,426.65
Shares Outstanding (M)251.88251.88251.88
Fair Value$425.44$445.45$466.21
Upside / Downside22.87%28.64%34.64%

High-Yield Dividend Screener

« Prev Page 96 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0053.HKGuoco Group Limited1.06%$0.7324.48%
0QRA.LBufab AB (publ)1.06%$1.0533.67%
1478.HKQ Technology (Group) Company Limited1.06%$0.0916.75%
300547.SZSichuan Chuanhuan Technology Co.,Ltd.1.06%$0.4246.91%
3605.TWACES Electronics Co., Ltd.1.06%$0.6716.60%
600862.SSAVIC Aviation High-Technology Co., Ltd.1.06%$0.2533.36%
600895.SSShanghai Zhangjiang Hi-Tech Park Development Co., Ltd.1.06%$0.4766.35%
601989.SSChina Shipbuilding Industry Company Limited1.06%$0.0548.46%
603823.SSLily Group Co., Ltd.1.06%$0.1639.52%
603856.SSShandong Donghong Pipe Industry Co., Ltd.1.06%$0.1321.43%
603909.SSHolsin Engineering Consulting Group Co.,Ltd.1.06%$0.1228.69%
688015.SSTraffic Control Technology Co., Ltd.1.06%$0.2432.90%
SPLTN.STInvestment AB Spiltan1.06%$2.197.20%
002452.SZChanggao Electric Group Co., Ltd.1.05%$0.0919.43%
002632.SZDaoming Optics&Chemical Co.,Ltd1.05%$0.1339.58%
002864.SZShaanxi Panlong Pharmaceutical Group Limited By Share Ltd1.05%$0.3228.23%
006800.KSMirae Asset Securities Co. Ltd.1.05%$257.6512.18%
090430.KSAmorepacific Corporation1.05%$1,336.4358.38%
1230.HKYashili International Holdings Ltd1.05%$0.0130.51%
136490.KSSunjin Co.,Ltd.1.05%$100.043.41%
300543.SZShenzhen Longood Intelligent Electric Co.,LTD1.05%$0.1299.57%
301580.SZAidite Qinhuangdao Technology Co Ltd1.05%$0.4727.41%
484870.KSMNC Solution Co., Ltd.1.05%$1,480.2735.83%
603017.SSARTS Group Co., Ltd1.05%$0.1279.10%
603067.SSHubei Zhenhua Chemical Co.,Ltd.1.05%$0.3031.09%
603358.SSHuada Automotive Technology Corp.,Ltd1.05%$0.5359.33%
603929.SSL&K Engineering (Suzhou) Co.,Ltd.1.05%$1.0033.37%
BRIS.JKPT Bank Syariah Indonesia Tbk1.05%$22.7814.07%
EREGL.ISEregli Demir ve Çelik Fabrikalari T.A.S.1.05%$0.2633.82%
TECKTeck Resources Limited1.05%$0.5119.75%
002957.SZShenzhen Colibri Technologies Co., Ltd.1.04%$0.2242.63%
006280.KSGC Biopharma Corp.1.04%$1,649.8533.43%
0N08.LPanoro Energy ASA1.04%$0.2168.53%
3733.TSoftware Service, Inc.1.04%$140.0111.99%
4307.TNomura Research Institute, Ltd.1.04%$62.8935.46%
600100.SSTsinghua Tongfang Co.,Ltd.1.04%$0.0978.90%
600863.SSInner Mongolia MengDian HuaNeng Thermal Power Corporation Limited1.04%$0.0514.74%
603989.SSHunan Aihua Group Co., Ltd1.04%$0.1731.43%
605118.SSXiamen Leading Optics Co., Ltd.1.04%$0.3146.29%
6720.TWOMajor-Power Technology Co., Ltd.1.04%$1.2720.76%
6808.HKSun Art Retail Group Limited1.04%$0.0242.72%
SSC.BKSermsuk Public Company Limited1.04%$0.5234.17%
000779.SZGansu Engineering Consulting Group Co., Ltd.1.03%$0.0818.98%
0A0H.ILBeijer Ref AB (publ)1.03%$1.3828.57%
103590.KSIljin Electric Co.,Ltd1.03%$600.4233.30%
2614.TWEastern Media International Corporation1.03%$0.2311.71%
2GB.DE2G Energy AG1.03%$0.3715.61%
300888.SZWinner Medical Co., Ltd.1.03%$0.3925.98%
301149.SZShandong Longhua New Material Co., Ltd.1.03%$0.1134.91%
319660.KQPSK Inc.1.03%$400.0014.97%