Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

The Sherwin-Williams Company (0L5V.L)

Company Dividend Discount ModelIndustry: Industrial MaterialsSector: Basic Materials

Valuation Snapshot

Stable Growth$239.52 - $635.37$366.24
Multi-Stage$165.05 - $180.27$172.52
Blended Fair Value$269.38
Current Price$346.26
Upside-22.20%
DecisionDon't Buy

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 Rate9.10%9.10%9.10%
Growth Rate5.50%6.50%7.50%
Fair Value$239.52$366.24$635.37
Upside / Downside-30.83%5.77%83.49%

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 Rate9.10%9.10%9.10%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)1,046.281,056.201,066.12
Year 2 PV (M)1,299.951,324.711,349.70
Year 3 PV (M)1,535.751,579.831,624.75
Year 4 PV (M)1,754.581,822.051,891.46
Year 5 PV (M)1,957.302,051.842,150.00
PV of Terminal Value (M)33,978.7335,619.9137,323.91
Equity Value (M)41,572.5843,454.5445,405.93
Shares Outstanding (M)251.88251.88251.88
Fair Value$165.05$172.52$180.27
Upside / Downside-52.33%-50.17%-47.94%

High-Yield Dividend Screener

« Prev Page 4 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EG7.IRFBD Holdings plc12.49%$1.9761.47%
WILCG. Willi-Food International Ltd.12.48%$3.5852.70%
9908.HKJiaXing Gas Group Co., Ltd.12.44%$1.0240.94%
MPMX.JKPT Mitra Pinasthika Mustika Tbk12.44%$120.0095.84%
0QL5.LCarlo Gavazzi Holding AG12.42%$20.0062.49%
GOZ.AXGrowthpoint Properties Australia12.40%$0.3016.37%
1999.HKMan Wah Holdings Limited12.39%$0.5757.62%
1285.HKJiashili Group Limited12.38%$0.1455.24%
600015.SSHua Xia Bank Co., Limited12.36%$0.8549.77%
BNP.DEBNP Paribas S.A.12.28%$10.0751.11%
0836.HKChina Resources Power Holdings Company Limited12.20%$2.1541.97%
BIS.AXBisalloy Steel Group Limited12.19%$0.5981.88%
KBS.BKKhonburi Sugar Public Company Limited12.17%$0.7056.34%
9300.SRAlwaha REIT Fund12.14%$1.1871.67%
2005.HKSSY Group Limited12.13%$0.3550.50%
BGI-UN.TOBrookfield Global Infrastructure Securities Income Fund12.09%$0.9646.13%
2003.HKVCREDIT Holdings Limited12.07%$0.3218.47%
1713.HKSichuan Energy Investment Development Co., Ltd.12.02%$0.2941.35%
NSI.ASNSI N.V.12.02%$2.3330.60%
RIO1.DERio Tinto Group12.02%$8.2864.54%
IGL.AXIVE Group Limited12.01%$0.3574.81%
0G5B.LSto SE & Co. KGaA12.00%$14.6483.41%
CDU.LSConduril - Engenharia, S.A.12.00%$1.8069.00%
2156.HKC&D Property Management Group Co. Limited11.98%$0.3354.74%
0057.HKChen Hsong Holdings Limited11.94%$0.1945.38%
BBSE3.SABB Seguridade Participações S.A.11.93%$4.2691.94%
SWUT.VISW Umwelttechnik Stoiser & Wolschner AG11.93%$3.7034.18%
0Q76.LCBo Territoria S.A.11.92%$0.4461.80%
ALCOF.PACofidur S.A.11.92%$34.8038.87%
0239.HKPak Fah Yeow International Limited11.87%$0.2852.60%
2356.HKDah Sing Banking Group Limited11.87%$1.2941.19%
3311.HKChina State Construction International Holdings Limited11.87%$1.1029.31%
ENGI.PAEngie S.A.11.87%$2.7376.93%
SENA.BKSena Development Public Company Limited11.86%$0.2074.93%
4348.SRAlkhabeer REIT Fund11.85%$0.6698.08%
AWZ.SIMulti-Chem Limited11.83%$0.4160.70%
0331.HKFSE Lifestyle Services Limited11.81%$0.6731.73%
SUL.AXSuper Retail Group Limited11.78%$1.8791.92%
2877.HKChina Shineway Pharmaceutical Group Limited11.77%$1.0139.47%
DSWLDeswell Industries, Inc.11.77%$0.4027.95%
0855.HKChina Water Affairs Group Limited11.75%$0.6256.78%
0659.HKCTF Services Limited11.70%$0.8876.18%
DRA.AXDRA Global Limited11.69%$0.2158.65%
GWA.AXGWA Group Limited11.68%$0.2995.40%
0968.HKXinyi Solar Holdings Limited11.67%$0.3670.18%
ENI-UN.TOEnergy Income Fund11.66%$0.2356.38%
TCF.AX360 Capital Mortgage REIT11.66%$0.6776.18%
3316.HKBinjiang Service Group Co. Ltd.11.65%$2.7669.09%
CC3.SIStarHub Ltd11.65%$0.1381.69%
TFG-R.BKThaifoods Group Public Company Limited11.65%$0.5242.58%