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 94 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
AKVA.OLAKVA group ASA1.13%$1.0021.19%
CPCanadian Pacific Kansas City Ltd.1.13%$0.8418.03%
000698.SZShenyang Chemical Industry Co., Ltd.1.12%$0.0431.22%
000887.SZAnhui Zhongding Sealing Parts Co., Ltd.1.12%$0.2622.74%
002019.SZYifan Pharmaceutical Co., Ltd.1.12%$0.1339.99%
002489.SZYotrio Group Co., Ltd.1.12%$0.0414.30%
002545.SZQingdao East Steel Tower Stock Co.Ltd1.12%$0.2127.84%
002876.SZShenzhen Sunnypol Optoelectronics Co.,Ltd.1.12%$0.2796.20%
1133.HKHarbin Electric Company Limited1.12%$0.2013.64%
2081.SRAlkhorayef Water & Power Technologies1.12%$1.5020.25%
300014.SZEVE Energy Co., Ltd.1.12%$0.7443.77%
600452.SSChongqing Fuling Electric Power Industrial Co., Ltd.1.12%$0.1141.35%
600498.SSFiberhome Telecommunication Technologies Co., Ltd.1.12%$0.3651.86%
603290.SSStarPower Semiconductor Ltd.1.12%$1.0855.22%
603379.SSZhejiang Sanmei Chemical Industry Co., Ltd.1.12%$0.6823.00%
688077.SSEarth-Panda Advanced Magnetic Material Co.,Ltd.1.12%$0.3480.86%
688113.SSJiangsu Liance Electromechanical Technology Co., Ltd.1.12%$0.4427.68%
9697.TCapcom Co., Ltd.1.12%$40.8030.63%
JLJ-Long Group Limited1.12%$0.0710.02%
MREI.JKPT Maskapai Reasuransi Indonesia Tbk1.12%$13.567.63%
RRRP3.SA3R Petroleum Óleo e Gás S.A.1.12%$0.205.90%
RSGK.JKPT Kedoya Adyaraya Tbk1.12%$11.0030.42%
TKBP.SWThurgauer Kantonalbank1.12%$1.8211.49%
001203.SZInner Mongolia Dazhong Mining Co., Ltd.1.11%$0.3473.27%
002928.SZChina Express Airlines Co.,LTD1.11%$0.1226.84%
002971.SZHubei Heyuan Gas Co.,Ltd.1.11%$0.3396.40%
052690.KSKEPCO Engineering & Construction Company, Inc.1.11%$998.7236.59%
0QJY.LSchaffner Holding AG1.11%$5.5222.35%
0ROQ.LComet Holding AG1.11%$2.5034.42%
0Y4Q.LWillis Towers Watson Public Limited Company1.11%$3.5816.92%
600817.SSYutong Heavy Industries Co.,Ltd.1.11%$0.1323.44%
601127.SSSeres Group Co.,Ltd.1.11%$1.3530.47%
603228.SSShenzhen Kinwong Electronic Co., Ltd.1.11%$0.8162.37%
6742.KLYTL Power International Berhad1.11%$0.0413.90%
6920.TLasertec Corporation1.11%$328.9731.31%
FERGFerguson plc1.11%$2.4925.04%
FRAS3.SAFras-le S.A.1.11%$0.2720.45%
WTN.AXWinton Land Limited1.11%$0.032.57%
002559.SZJiangsu Yawei Machine Tool Co., Ltd.1.10%$0.1180.31%
002891.SZYantai China Pet Foods Co., Ltd.1.10%$0.5740.72%
002901.SZDouble Medical Technology Inc.1.10%$0.5239.26%
002922.SZEaglerise Electric & Electronic (China) Co., Ltd1.10%$0.3452.70%
012610.KSKyungin Synthetic Co., Ltd.1.10%$54.9429.75%
300735.SZDBG Technology Co., Ltd.1.10%$0.2764.53%
301135.SZGuangdong Real-Design Intelligent Technology Co., Ltd1.10%$0.3176.35%
5272.KLRanhill Utilities Berhad1.10%$0.0233.57%
600597.SSBright Dairy & Food Co.,Ltd1.10%$0.0917.78%
6445.TJANOME Corporation1.10%$12.7626.30%
688230.SSShanghai Prisemi Electronics Co.,Ltd.1.10%$0.8091.66%
688551.SSHefei Kewell Power System Co.,Ltd.1.10%$0.4168.90%