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 115 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
002515.SZJinzi Ham Co.,Ltd.0.49%$0.0366.70%
094480.KQGalaxiaMoneytree Co.,Ltd0.49%$45.0538.73%
0JG5.LBittium Oyj0.49%$0.1452.63%
0REZ.LAddLife AB (publ)0.49%$0.7523.10%
102710.KQENF Technology Co., Ltd.0.49%$243.137.08%
300171.SZTofflon Science and Technology Group Co., Ltd.0.49%$0.0833.65%
300351.SZZhejiang Yonggui Electric Equipment Co., Ltd.0.49%$0.0935.92%
600528.SSChina Railway Hi-tech Industry Corporation Limited0.49%$0.046.13%
600592.SSFujian Longxi Bearing (Group) Co., Ltd0.49%$0.1369.32%
603179.SSJiangsu Xinquan Automotive Trim Co.,Ltd.0.49%$0.3619.37%
688377.SSNanjing Develop Advanced Manufacturing Co., Ltd.0.49%$0.1830.90%
688617.SSAPT Medical Inc.0.49%$1.2022.16%
688728.SSGalaxyCore Inc.0.49%$0.0781.53%
8818.TKeihanshin Building Co., Ltd.0.49%$9.539.42%
ALSTI.PASTIF S.a.0.49%$0.265.48%
BRGE5.SAConsórcio Alfa de Administração S.A.0.49%$0.0714.26%
DNORD.CODampskibsselskabet Norden A/S0.49%$1.2325.43%
MAKRO.BKSiam Makro Public Company Limited0.49%$0.1824.56%
OROR Royalties Inc.0.49%$0.1722.03%
SEALMATIC.BOSealmatic India Limited0.49%$1.837.91%
TUB.BRFinancière de Tubize S.A.0.49%$1.0425.35%
ZFSTEERING.BOZF Steering Gear (India) Limited0.49%$3.9533.81%
000931.SZBeijing Centergate Technologies (holding) Co., Ltd.0.48%$0.0234.16%
002051.SZChina CAMC Engineering Co., Ltd.0.48%$0.0418.75%
002245.SZJiangsu Azure Corporation0.48%$0.0913.88%
002510.SZTianjin Motor Dies Co.,Ltd.0.48%$0.0462.40%
002518.SZShenzhen KSTAR Science and Technology Co., Ltd.0.48%$0.2327.91%
002625.SZKuang-Chi Technologies Co., Ltd.0.48%$0.2369.49%
300718.SZZhejiang Changsheng Sliding Bearings Co., Ltd.0.48%$0.4149.19%
3162.TWOUnited Alloy-Tech Company0.48%$0.3012.28%
5452.TWOUNIC Technology Corp.0.48%$0.1550.09%
600580.SSWolong Electric Group Co.,Ltd.0.48%$0.2437.73%
603217.SSYuanli Chemical Group Co.,Ltd.0.48%$0.1212.42%
603701.SSZhejiang Dehong Automotive Electronic & Electrical Co., Ltd.0.48%$0.1060.08%
688259.SSTriductor Technology (Suzhou) Inc.0.48%$0.2027.03%
688501.SSQingdao Daneng Environmental Protection Equipment Co., Ltd.0.48%$0.138.66%
688621.SSBeijing Sun-Novo Pharmaceutical Research Co., Ltd.0.48%$0.3024.53%
688800.SSSuzhou Recodeal Interconnect System Co.,Ltd0.48%$0.4027.01%
SOLA.JKXolare RCR Energy Tbk.0.48%$0.609.38%
001339.SZJWIPC Technology Co., Ltd.0.47%$0.2433.98%
003002.SZShanxi Huhua Group Co., Ltd.0.47%$0.1516.74%
067310.KQHANA Micron Inc.0.47%$124.2534.47%
300059.SZEast Money Information Co.,Ltd.0.47%$0.1113.64%
300334.SZTianjin MOTIMO Membrane Technology Co.,Ltd0.47%$0.0340.56%
300458.SZAllwinnertech Technology Co.,Ltd.0.47%$0.2055.67%
300801.SZShandong Taihe Water Treatment Technologies Co., Ltd.0.47%$0.1322.29%
3888.HKKingsoft Corporation Limited0.47%$0.1411.27%
600508.SSShanghai Datun Energy Resources Co., Ltd.0.47%$0.0611.54%
600927.SSYongan Futures0.47%$0.0817.34%
600967.SSInner Mongolia First Machinery Group Co.,Ltd.0.47%$0.0825.49%