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 6 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
FFord Motor Company5.53%$0.7463.45%
LCNBLCNB Corp.5.48%$0.8953.03%
PPBIPacific Premier Bancorp, Inc.5.48%$1.3492.42%
VGRVector Group Ltd.5.48%$0.8263.35%
DLXDeluxe Corporation5.43%$1.2166.43%
BAFNBayFirst Financial Corp.5.41%$0.4321.50%
IPGThe Interpublic Group of Companies, Inc.5.41%$1.3388.72%
PEBOPeoples Bancorp Inc.5.39%$1.6256.40%
OKEONEOK, Inc.5.38%$4.0075.29%
BUSEFirst Busey Corporation5.37%$1.2875.92%
OASOasis Petroleum Inc.5.37%$5.8765.40%
EIXEdison International5.36%$3.2639.45%
0R1X.LGeneral Mills, Inc.5.35%$2.4545.62%
FIBKFirst Interstate BancSystem, Inc.5.35%$1.8979.54%
FNCBFNCB Bancorp, Inc.5.33%$0.3651.41%
DHILDiamond Hill Investment Group, Inc.5.31%$9.0552.46%
SLRCSLR Investment Corp.5.31%$0.8249.67%
EPSNEpsilon Energy Ltd.5.30%$0.2491.92%
UVVUniversal Corporation5.28%$2.7862.64%
FLICThe First of Long Island Corporation5.27%$0.6386.64%
AUBAtlantic Union Bankshares Corporation5.22%$1.8576.04%
SAFESafehold Inc.5.20%$0.7145.17%
GAB-PGThe Gabelli Equity Trust Inc. PFD-G5.19%$1.0881.70%
HPQHP Inc.5.19%$1.1543.02%
SOISolaris Oilfield Infrastructure, Inc.5.18%$0.7025.64%
MBINOMerchants Bancorp5.17%$1.2924.09%
0JXQ.LMain Street Capital Corporation5.13%$3.1752.63%
EMNEastman Chemical Company5.12%$3.2954.36%
EMBCEmbecta Corp.5.10%$0.5936.96%
AMAntero Midstream Corporation5.09%$0.9193.18%
CZNCCitizens & Northern Corporation5.09%$1.0257.64%
FMNBFarmers National Banc Corp.5.09%$0.6846.83%
0J66.LHost Hotels & Resorts, Inc.5.08%$0.9084.69%
GLPIGaming and Leisure Properties, Inc.5.07%$2.2582.42%
PFISPeoples Financial Services Corp.5.07%$2.4446.22%
TBBAT&T Inc. 5.35% GLB NTS 665.07%$1.1436.88%
KFRCKforce Inc.5.02%$1.5768.10%
TTPTortoise Pipeline & Energy Fund, Inc.5.02%$2.3920.11%
STAR-PGiStar Inc.4.94%$1.2434.23%
PFSProvident Financial Services, Inc.4.93%$0.9761.13%
UBFOUnited Security Bancshares4.92%$0.4873.45%
DDTDillards Capital Trust I CAP SECS 7.5%4.90%$1.293.46%
SGUStar Group, L.P.4.89%$0.5836.90%
AGRAvangrid, Inc.4.88%$1.7660.70%
KMBKimberly-Clark Corporation4.88%$4.9583.80%
OCFCOceanFirst Financial Corp.4.86%$0.8761.98%
0I0J.LThe Clorox Company4.85%$4.8976.11%
FNLCThe First Bancorp, Inc.4.83%$1.2845.40%
RILYZB. Riley Financial, Inc. 5.25% Senior Notes due 20284.83%$0.5856.91%
BSETBassett Furniture Industries, Incorporated4.82%$0.8089.43%