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 113 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
300201.SZXuzhou Handler Special Vehicle Co., Ltd0.54%$0.0413.64%
300254.SZShanXi C&Y Pharmaceutical Group Co., Ltd.0.54%$0.0666.26%
300618.SZNanjing Hanrui Cobalt Co.,Ltd.0.54%$0.2427.60%
300777.SZSinofibers Technology Co.,Ltd.0.54%$0.2223.25%
300835.SZSinomag Technology Co., Ltd.0.54%$0.3527.98%
300965.SZBeijing Hengyu Datacom Aviation Equipment co., Ltd.0.54%$0.3868.61%
301596.SZReach Machinery Co Ltd0.54%$0.4330.79%
5432.TWOSolomon Data International Corporation0.54%$1.0070.10%
5TP.SICNMC Goldmine Holdings Limited0.54%$0.0112.36%
600166.SSBeiqi Foton Motor Co., Ltd.0.54%$0.0216.31%
600171.SSShanghai Belling Co., Ltd.0.54%$0.1733.39%
600459.SSSino-Platinum Metals Co.,Ltd0.54%$0.1012.03%
600741.SSHUAYU Automotive Systems Company Limited0.54%$0.114.97%
600819.SSShanghai Yaohua Pilkington Glass Group Co., Ltd.0.54%$0.0428.59%
600906.SSCaida Securities Co., Ltd.0.54%$0.0411.87%
603949.SSXuelong Group Co.,Ltd0.54%$0.1027.46%
HMM-A.TOHammond Manufacturing Company Limited0.54%$0.063.93%
WPMWheaton Precious Metals Corp.0.54%$0.6429.16%
000525.SZNanjing Red Sun Co.,Ltd.0.53%$0.0341.59%
002481.SZYantai Shuangta Food Co., Ltd.0.53%$0.0350.34%
002590.SZZhejiang VIE Science & Technology Co., Ltd.0.53%$0.0819.59%
0069.HKShangri-La Asia Limited0.53%$0.0333.68%
010620.KSHd Hyundai Mipo Co. Ltd.0.53%$1,189.7714.34%
1299.HKAIA Group Limited0.53%$0.4443.34%
300580.SZWuxi Best Precision Machinery Co., Ltd.0.53%$0.1423.35%
301163.SZJiangsu Hongde Special Parts Co.,Ltd.0.53%$0.1432.32%
4916.TWParpro Corporation0.53%$0.3121.99%
600759.SSGeo-Jade Petroleum Corporation0.53%$0.0215.23%
6701.TNEC Corporation0.53%$28.0315.93%
688127.SSZhejiang Lante Optics Co., Ltd.0.53%$0.2026.44%
688608.SSBestechnic (Shanghai) Co., Ltd.0.53%$1.1930.21%
002333.SZZYF Lopsking Aluminum Co., Ltd.0.52%$0.0339.44%
120030.KSCHOSUN WELDING POHANG Co., Ltd0.52%$506.373.69%
1250.HKShandong Hi-Speed New Energy Group Limited0.52%$0.013.33%
267270.KSHyundai Construction Equipment Co., Ltd.0.52%$507.929.77%
294570.KQCOOCON Corporation0.52%$150.375.17%
300145.SZNanfang Pump Industry Co., Ltd. Class A0.52%$0.0218.75%
300236.SZShanghai Sinyang Semiconductor Materials Co., Ltd.0.52%$0.3339.76%
301165.SZRuijie Networks Co., Ltd.0.52%$0.4643.33%
3CP.FXiaomi Corporation0.52%$0.024.20%
5398.KLGamuda Berhad0.52%$0.0315.33%
600521.SSZhejiang Huahai Pharmaceutical Co., Ltd.0.52%$0.0928.05%
601880.SSLiaoning Port Co., Ltd.0.52%$0.0113.15%
605300.SSJiahe Foods Industry Co., Ltd.0.52%$0.0698.92%
8095.HKBeijing Beida Jade Bird Universal Sci-Tech Company Limited0.52%$0.0112.52%
WTC.AXWiseTech Global Limited0.52%$0.3620.57%
000631.SZShunfa Hengye Corporation0.51%$0.0238.02%
000768.SZAVIC Xi'an Aircraft Industry Group Company Ltd.0.51%$0.1333.44%
000936.SZJiangsu Huaxicun Co.,Ltd.0.51%$0.0411.81%
002023.SZSichuan Haite High-tech Co., Ltd.0.51%$0.0740.25%