Definitive Analysis
Definitive Analysis

Financial Statements

Analysis Mode

Search

The Sherwin-Williams Company (0L5V.L)

Company Dividend Discount ModelIndustry: Industrial MaterialsSector: Basic Materials

Valuation Snapshot

Stable Growth$440.33 - $2,030.64$994.15
Multi-Stage$230.80 - $252.46$241.43
Blended Fair Value$617.79
Current Price$346.26
Upside78.42%
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 Rate7.46%7.46%7.46%
Growth Rate5.50%6.50%7.50%
Fair Value$440.33$994.15$2,030.64
Upside / Downside27.17%187.11%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 Rate7.46%7.46%7.46%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)1,062.261,072.331,082.40
Year 2 PV (M)1,339.951,365.481,391.24
Year 3 PV (M)1,607.181,653.321,700.33
Year 4 PV (M)1,864.231,935.922,009.66
Year 5 PV (M)2,111.382,213.362,319.24
PV of Terminal Value (M)50,147.6052,569.7555,084.60
Equity Value (M)58,132.6060,810.1563,587.47
Shares Outstanding (M)251.88251.88251.88
Fair Value$230.80$241.43$252.46
Upside / Downside-33.35%-30.27%-27.09%

High-Yield Dividend Screener

« Prev Page 29 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
SUSuncor Energy Inc.5.07%$2.3153.29%
023410.KQEugene Corporation5.06%$183.4563.50%
7537.TMarubun Corporation5.06%$65.8855.36%
GLJ.DEGrenke AG5.06%$0.7954.91%
KZOS.MEKazan Public Joint Stock Company Organichesky sintez5.06%$3.3620.60%
LTLS.JKPT Lautan Luas Tbk5.06%$43.7440.34%
MDS-UN.TOHealthcare Special Opportunities Fund5.06%$0.5664.99%
PUUILO.HEPuuilo Oyj5.06%$0.6382.63%
VCI.VVitreous Glass Inc.5.06%$0.3791.09%
051600.KSKEPCO Plant Service & Engineering Co.,Ltd.5.05%$2,469.0084.53%
BLXBanco Latinoamericano de Comercio Exterior, S. A.5.05%$2.2137.06%
TLI.BKThai Life Insurance Public Company Limited5.05%$0.5047.29%
031330.KQSAMT Co., Ltd.5.04%$200.0045.01%
DCR.WADecora S.A.5.04%$3.7855.77%
PST.MIPoste Italiane S.p.A.5.04%$1.0965.05%
RDX.AXRedox Limited5.04%$0.1554.66%
UPOIC.BKUnited Palm Oil Industry Public Company Limited5.04%$0.3361.35%
WKL.ASWolters Kluwer N.V.5.04%$4.4348.01%
000600.SZJointo Energy Investment Co., Ltd. Hebei5.03%$0.4345.84%
0QNN.LBurckhardt Compression Holding AG5.03%$27.4847.49%
002233.SZGuangdong Tapai Group Co., Ltd.5.02%$0.4570.96%
9308.TInui Global Logistics Co., Ltd.5.02%$68.9239.29%
FFI.AXFFI Holdings Limited5.02%$0.2431.68%
SJWD.BKSCGJWD Logistics Public Company Limited5.02%$0.3762.75%
007590.KSDONGBANG AGRO Corporation5.01%$300.1154.47%
0151.HKWant Want China Holdings Limited5.01%$0.2363.82%
2971.TEscon Japan REIT Investment Corporation5.01%$6,447.9060.16%
BBL-R.BKBangkok Bank Public Company Limited5.01%$8.5034.27%
DIC.AEDubai Investments PJSC5.01%$0.1858.95%
006390.KSHanil Hyundai Cement Co., Ltd5.00%$900.0433.14%
600998.SSJointown Pharmaceutical Group Co., Ltd5.00%$0.2646.36%
7020.SREtihad Etisalat Company5.00%$3.3172.99%
KA8.DEKlassik Radio AG5.00%$0.1595.39%
ORDS.QAOoredoo Q.P.S.C.4.99%$0.6557.81%
002616.SZGuangdong Chant Group Inc.4.98%$0.2771.11%
039130.KSHanatour Service Inc.4.98%$2,419.0255.18%
1264.TWOTehmag Foods Corporation4.98%$13.9967.27%
1295.KLPublic Bank Berhad4.98%$0.2260.48%
AW-UN.TOA&W Revenue Royalties Income Fund4.98%$1.8492.91%
WPK.TOWinpak Ltd.4.98%$2.2699.45%
000776.SZGF Securities Co., Ltd.4.97%$1.0960.30%
5236.KLMatrix Concepts Holdings Berhad4.97%$0.0756.54%
601298.SSQingdao Port International Co., Ltd.4.97%$0.4149.05%
7133.KLUnited U-LI Corporation Berhad4.97%$0.0846.08%
9925.TWTaiwan Shin Kong Security Co., Ltd.4.97%$2.0281.40%
034590.KSIncheon City Gas Co., Ltd.4.96%$1,251.1528.53%
0QP4.ILGeorg Fischer AG4.96%$2.6644.86%
4163.SRAl-Dawaa Medical Services Company4.96%$2.5157.67%
9163.TNareru Group Inc.4.96%$114.0343.61%
CPFE3.SACPFL Energia S.A.4.96%$2.6656.33%