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 108 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
000657.SZChina Tungsten And Hightech Materals Co.,Ltd0.68%$0.1927.39%
009150.KSSamsung Electro-Mechanics Co., Ltd.0.68%$1,822.8819.91%
300248.SZNewcapec Electronics Co., Ltd.0.68%$0.0942.34%
300304.SZJiangsu Yunyi Electric Co.,Ltd.0.68%$0.0816.20%
300727.SZNingbo Runhe High-Tech Materials Co., Ltd.0.68%$0.2435.64%
300829.SZHenan Jindan Lactic Acid Technology Co., Ltd0.68%$0.1137.09%
3037.TWUnimicron Technology Corp.0.68%$1.5071.82%
600965.SSFortune Ng Fung Food (Hebei) Co.,Ltd0.68%$0.0443.15%
603535.SSGuangzhou Jiacheng International Logistics Co.,Ltd.0.68%$0.0719.97%
603819.SSChangzhou Shenli Electrical Machine Incorporated Company0.68%$0.0867.83%
6174.TWOAker Technology Co., Ltd0.68%$0.1419.31%
688685.SSJiangsu Maixinlin Aviation Science and Technology Corp.0.68%$0.3883.55%
7741.THOYA Corporation0.68%$160.7926.30%
AJA-B.STByggmästare Anders J Ahlström Holding AB (publ)0.68%$0.4354.16%
EWG2.SGEUWAX Gold II0.68%$0.8376.69%
MRB.WAMirbud S.A.0.68%$0.1010.28%
WGN.AXWagners Holding Company Limited0.68%$0.0214.21%
000045.SZShenzhen Textile (Holdings) Co., Ltd.0.67%$0.0859.47%
000524.SZGuangzhou Lingnan Group Holdings Company Limited0.67%$0.0866.62%
002886.SZShenzhen WOTE Advanced Materials Co., Ltd0.67%$0.1591.87%
002912.SZShenzhen Sinovatio Technology Co., Ltd.0.67%$0.2035.64%
006660.KSSamsung Climate Control Co., Ltd.0.67%$96.596.25%
036570.KSNcsoft Corporation0.67%$1,460.118.29%
060250.KQNHN KCP Corp.0.67%$102.418.42%
1913.HKPrada S.p.A.0.67%$0.3047.97%
2343.HKPacific Basin Shipping Limited0.67%$0.0248.96%
300789.SZChengdu Tangyuan Electric Co.,Ltd.0.67%$0.1538.39%
300920.SZZhejiang Runyang New Material Technology Co., Ltd.0.67%$0.3188.17%
600150.SSChina CSSC Holdings Limited0.67%$0.2220.83%
603183.SSSuzhou Institute of Building Science Group Co.,Ltd0.67%$0.0335.25%
603308.SSAnhui Yingliu Electromechanical Co., Ltd.0.67%$0.2853.99%
603686.SSFULONGMA Group Co.,Ltd.0.67%$0.2057.71%
6525.TKokusai Electric Corporation0.67%$36.6425.58%
9247.TTRE Holdings Corporation0.67%$10.723.17%
GCARSOA1.MXGrupo Carso, S.A.B. de C.V.0.67%$0.7815.21%
GIBCGI Inc.0.67%$0.618.14%
HPS-A.TOHammond Power Solutions Inc.0.67%$1.1016.45%
ZYRX.JKPT Zyrexindo Mandiri Buana Tbk0.67%$1.129.50%
095340.KQISC Co., Ltd.0.66%$793.0735.89%
128940.KSHanmi Pharm. Co., Ltd.0.66%$2,913.6031.17%
600738.SSLanzhou Lishang Guochao Industrial Group Co.,Ltd0.66%$0.0331.33%
600988.SSChifeng Jilong Gold Mining Co.,Ltd.0.66%$0.2114.26%
603331.SSZhejiang Baida Precision Manufacturing Corp.0.66%$0.0926.78%
603992.SSXiamen Solex High-tech Industries Co., Ltd.0.66%$0.2740.24%
6702.TFujitsu Limited0.66%$28.4011.32%
AGII.JKPT Samator Indo Gas Tbk0.66%$10.4537.88%
ASME.DEASML Holding N.V.0.66%$6.5226.72%
FNVFranco-Nevada Corporation0.66%$1.3828.98%
FQT.DEFrequentis AG0.66%$0.5118.23%
GOEL.BOGoel Food Products Limited0.66%$0.101.87%