Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

SHW Stock Forecast, Price Targets, Chart, Dividends & Analysis

Sherwin-Williams Company (The) logo

Sherwin-Williams Company (The)

Sector: Basic Materials   

Industry: Specialty Chemicals

336.88
 
USD
  
-4.14
  
(-1.21%)
Previous close: 341.02  Open: 339.3  Bid: 337.25  Ask: 350.0
52 week range    
282.09   
   400.42
Mkt Cap: 84,680 M  Avg Vol (90 Days): 1,894,884
Last updated: Wednesday 16th April 2025

Stock Rankings

56
MarketXLS Rank
60
Value
27
Technical
81
Quality
How are these ranks calculated?
Metrics

Growth

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

SHW Income Statement

Annual
Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23Dec-24
AllowancesForConstruction8,203 M
Amortization of intangibles1,143 M25 M207 M318 M313 M313 M310 M7,583 M7,626 M7,580 M
Basic EPS from continuing operations3.794.116.513.975.67.487.17.839.3510.68
Basic EPS total3.794.116.363.975.67.487.17.839.3510.68
Basic weighted shares outstanding277 M276 M279 M279 M275 M271 M263 M258 M255 M251 M
BasicDiscontinuousOperations-0.15
Cost of sales5,780 M5,933 M8,265 M10,116 M9,865 M9,679 M11,402 M12,824 M12,294 M11,903 M
Depreciation170 M172 M8,265 M278 M262 M268 M263 M264 M292 M297 M
Depreciation unreconciled25 M8,472 M318 M313 M313 M310 M317 M
DepreciationAndAmortization170 M25 M8,472 M318 M313 M313 M310 M264 M292 M297 M
Diluted EPS total3.724.06.223.895.57.366.987.729.2510.55
Diluted normalized net income/share3.724.06.373.895.57.366.987.729.2510.55
Diluted weighted shares outstanding282 M283 M285 M285 M280 M276 M267 M262 M258 M254 M
DilutedDiscontinuousOperations-0.15
Dividends paid per share0.891.121.131.151.511.792.22.42.422.86
GainOnSaleOfBusiness-112 M20 M
GainOnSaleOfPPE803000.031 M-5 M-13 M-16 M9 M6 M18 M-900000.050 M
GainOnSaleOfSecurity1 M5 M9 M5 M25 M11 M
GainsLossOnDisposalOfDiscontinuedOperations-42 M
GeneralAndAdministrativeExpense3,914 M4,135 M4,798 M5,034 M5,275 M5,478 M5,573 M6,332 M7,065 M7,422 M
Gross operating profit5,559 M5,923 M6,719 M7,419 M8,036 M8,683 M8,543 M9,325 M10,758 M11,195 M
ImpairmentOfCapitalAssets11 M2 M16 M58 M
Income before tax1,549 M1,595 M1,469 M1,360 M1,982 M2,519 M2,249 M2,573 M3,110 M3,452 M
Income restructuring and M&A-234 M-239 M-223 M-251 M-329 M-304 M-372 M-644 M-888 M-1,070 M
Income taxes495 M463 M-300 M251 M441 M489 M384 M553 M721 M770 M
Interest income5 M8 M25 M
InterestExpenseNonOperating62 M154 M263 M367 M349 M340 M335 M391 M375 M355 M
MinorityInterests868 M1,878 M3,648 M3,731 M
MiscOtherSpecialCharges-6 M5 M33 M-15 M9 M-2 M20 M-47 M-65 M45 M
Net income from total operations1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M2,681 M
NetIncomeCommonStockholders1,084 M1,145 M1,749 M1,298 M1,580 M2,030 M1,864 M2,020 M2,389 M2,681 M
NetIncomeContinuousOperations1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M2,681 M
NetIncomeDiscontinuousOperations-42 M
NetNonOperatingInterestIncomeExpense-62 M-154 M-263 M-367 M-349 M-340 M-330 M395 M-398 M-400 M
NonRecurringOperationExpense136 M-35 M
Normalized income6,552 M776 M954 M972 M1,318 M1,722 M2,366 M
Operating income7,426 M1,763 M1,714 M2,067 M2,448 M2,864 M2,559 M3,018 M3,626 M3,812 M
Operating income before depreciation (EBITDA)1,813 M2,010 M2,347 M2,335 M2,915 M3,441 M3,156 M2,964 M4,107 M4,431 M
OperatingExpense3,914 M10,093 M13,269 M5,352 M5,588 M5,819 M5,984 M6,329 M7,133 M7,383 M
Other income net5 M-10 M-41 M15 M113 M4 M-19 M-28 M40 M-56 M
Other special charges5,780 M-1 M-21 M
OtherGainLossFromDispositionOfDiscontinuedOperations-42 M
OtherGandA3,914 M4,135 M4,798 M5,034 M5,275 M5,478 M5,573 M6,332 M7,065 M7,422 M
OtherImpairmentOfCapitalAssets122 M2 M16 M
OtherOperatingExpenses-4 M-6 M-7 M-13 M-15 M28 M102 M-25 M67 M-39 M
OtherWriteOff63 M43 M38 M58 M65 M69 M
PromotionAndAdvertising338 M351 M374 M358 M
RentAndLandingFees394 M418 M465 M553 M
Research & development expense58 M5,933 M58 M10,116 M
ResearchExpense58 M5,933 M58 M10,116 M
RestructringAndMnAIncome-234 M-239 M-223 M-251 M-329 M-304 M-372 M-644 M-888 M-1,070 M
Revenue per share1,146 M25 M207 M318 M313 M313 M310 M7,900 M7,956 M7,907 M
SalariesAndWages-72 M-27 M-34 M-20 M-25 M-24 M-24 M-25 M-29 M-34 M
Selling Gen & administrative expense3,914 M4,135 M4,798 M5,034 M5,275 M5,478 M5,573 M6,332 M7,065 M7,422 M
SellingAndMarketingExpense338 M351 M374 M358 M
Special income/charges-5,780 M-11 M-2 M-136 M35 M304 M372 M-15 M-58 M1,070 M
Total Income available for interest expense (EBIT)1,611 M1,749 M1,733 M1,726 M2,331 M2,860 M2,583 M2,964 M3,485 M3,807 M
Total common shares outstanding277 M280 M282 M278 M277 M269 M260 M258 M254 M251 M
Total net income1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M2,681 M
Total ordinary shares251 M251 M251 M251 M251 M251 M251 M251 M251 M251 M
Total revenues11,339 M11,856 M14,984 M17,535 M17,901 M18,362 M19,945 M22,149 M23,052 M23,099 M
TotalExpenses9,694 M16,026 M21,534 M15,468 M15,452 M15,498 M17,386 M19,152 M19,426 M19,287 M
TotalRevenue11,339 M11,856 M14,984 M17,535 M17,901 M18,362 M19,945 M22,149 M23,052 M23,099 M
WriteDown5,780 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader