Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Mode

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 116 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
601717.SSZCZL Industrial Technology Group Company Limited Class A0.47%$0.124.37%
603999.SSDuZhe Publish&Media Co.,Ltd0.47%$0.0327.06%
605196.SSHebei Huatong Wires and Cables Group Co., Ltd.0.47%$0.1627.88%
6831.TWOTaiwan Microloops Corp.0.47%$1.1234.18%
7715.TNagano Keiki Co., Ltd.0.47%$11.384.07%
ORIENTCQ.BOOriental Carbon & Chemicals Limited0.47%$3.599.54%
SABE.PASaint Jean Groupe S.A.0.47%$0.1010.99%
SANDSandstorm Gold Ltd.0.47%$0.0649.36%
000967.SZInfore Environment Technology Group Co., Ltd.0.46%$0.0328.13%
002517.SZKingnet Network Co., Ltd.0.46%$0.1011.06%
002687.SZZhejiang Giuseppe Garment Co., Ltd0.46%$0.0218.23%
012450.KSHanwha Aerospace Co., Ltd.0.46%$4,318.978.54%
017960.KSHankuk Carbon Co., Ltd.0.46%$127.059.66%
0580.HKSun.King Technology Group Limited0.46%$0.016.21%
300615.SZXDC Industries (Shenzhen) Limited0.46%$0.0684.60%
3017.TWAsia Vital Components Co., Ltd.0.46%$6.7322.60%
5939.TOtani Kogyo Co.,Ltd.0.46%$29.848.22%
600883.SSYunnan Bowin Technology Industry Co.,Ltd0.46%$0.0424.13%
603078.SSJiangyin Jianghua Microelectronics Materials Co., Ltd0.46%$0.0835.00%
603881.SSShanghai AtHub Co.,Ltd.0.46%$0.1468.23%
605086.SSLongyan Kaolin Clay Co., Ltd.0.46%$0.2133.54%
688318.SSShenzhen Fortune Trend technology Co., Ltd.0.46%$0.6032.56%
7581.TSaizeriya Co.,Ltd.0.46%$25.1611.12%
CASN3.SACompanhia Catarinense de Águas e Saneamento - CASAN0.46%$0.0516.52%
000100.KSYuhan Corporation0.45%$506.9855.01%
002580.SZShandong Sacred Sun Power Sources Co.,Ltd0.45%$0.0612.88%
002595.SZHimile Mechanical Science and Technology (Shandong) Co., Ltd0.45%$0.3812.60%
300239.SZBaotou Dongbao Bio-Tech Co.,Ltd0.45%$0.0322.62%
300442.SZRange Intelligent Computing Technology Group Company Limited0.45%$0.248.12%
300850.SZLuoyang Xinqianglian Slewing Bearing Co., Ltd.0.45%$0.189.66%
300877.SZAnHui Jinchun Nonwoven Co., Ltd.0.45%$0.1316.98%
3013.TWChenming Electronic Tech. Corp.0.45%$0.5915.42%
600353.SSChengdu Xuguang Electronics Co., Ltd.0.45%$0.0749.07%
600668.SSZhejiang Jianfeng Group Co., Ltd.0.45%$0.053.04%
600673.SSGuangdong Hec Technologyholding Co., Ltd0.45%$0.1030.44%
600980.SSBGRIMM Technology Co., Ltd.0.45%$0.1017.50%
601117.SSChina National Chemical Engineering Co., Ltd0.45%$0.033.39%
603678.SSFujian Torch Electron Technology Co., Ltd.0.45%$0.1626.27%
ADVE.STAdvenica AB (publ)0.45%$0.0916.90%
DSV.CODSV A/S0.45%$7.1516.56%
MTRS.STMunters Group AB (publ)0.45%$0.8853.87%
ODL.OLOdfjell Drilling Ltd.0.45%$0.4090.93%
POLYCAB.BOPolycab India Limited0.45%$34.9321.40%
002276.SZZhejiang Wanma Co., Ltd.0.44%$0.0715.00%
035420.KSNAVER Corporation0.44%$1,089.508.47%
074600.KQWonik QnC Corporation0.44%$99.819.58%
214150.KQCLASSYS Inc.0.44%$257.0016.59%
300113.SZHangzhou Shunwang Technology Co,Ltd0.44%$0.0916.69%
300557.SZWuhan Ligong Guangke Co., Ltd.0.44%$0.1639.53%
300772.SZWindey Energy Technology Group Co., Ltd.0.44%$0.0814.53%