Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Sherwin-Williams Company (The) logo

Sherwin-Williams Company (The)

Sector: Basic Materials   

Industry: Specialty Chemicals

Optionable: Yes  Market Cap: 79,627 M  90-day average vol: 1,386,005

Previous close: 314.02  Open: 315.89  Bid: 312.39  Ask: 312.9
52 week range    
VAL / 
PPG / 
RPM / 
DD / 
MAS / 
FUL / 
Last updated: Monday 20th May 2024
MarketXLS Rank

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord



StockDividendMarket Cap (B)PEPrice ($)



0.015840 B7.175.37


0.00964 B24.269.53


0.0184385 B24.6357.35


0.015615 B34.660.32


0.015437 B26152.83


0.018511 B25.386.59



SHW Income Statement

AllowancesForConstruction8,203 M
Amortization of intangibles1,158 M1,143 M25 M207 M318 M313 M313 M310 M7,583 M7,626 M
Basic EPS from continuing operations2.983.794.116.513.975.67.487.17.839.35
Basic EPS total2.983.794.116.363.975.67.487.17.839.35
Basic weighted shares outstanding289 M277 M276 M279 M279 M275 M271 M263 M258 M255 M
Cost of sales5,965 M5,780 M5,933 M8,265 M10,116 M9,865 M9,679 M11,402 M12,824 M12,294 M
Depreciation169 M170 M172 M8,265 M278 M262 M268 M263 M264 M292 M
Depreciation unreconciled25 M8,472 M318 M313 M313 M310 M317 M
DepreciationAndAmortization169 M170 M25 M8,472 M318 M313 M313 M310 M264 M292 M
Diluted EPS total2.933.724.06.223.895.57.366.987.729.25
Diluted normalized net income/share2.933.724.06.373.895.57.366.987.729.25
Diluted weighted shares outstanding294 M282 M283 M285 M285 M280 M276 M267 M262 M258 M
Dividends paid per share0.730.891.
GainOnSaleOfBusiness-112 M20 M
GainOnSaleOfPPE-1 M803000.031 M-5 M-13 M-16 M9 M6 M18 M-900000.0
GainOnSaleOfSecurity1 M5 M9 M5 M
GainsLossOnDisposalOfDiscontinuedOperations-42 M
GeneralAndAdministrativeExpense3,860 M3,914 M4,135 M4,798 M5,034 M5,275 M5,478 M5,573 M6,332 M7,065 M
Gross operating profit5,164 M5,559 M5,923 M6,719 M7,419 M8,036 M8,683 M8,543 M9,325 M10,758 M
ImpairmentOfCapitalAssets5,965 M11 M2 M16 M58 M
Income before tax1,258 M1,549 M1,595 M1,469 M1,360 M1,982 M2,519 M2,249 M2,573 M3,110 M
Income restructuring and M&A-201 M-234 M-239 M-223 M-251 M-329 M-304 M-372 M-644 M-888 M
Income taxes392 M495 M463 M-300 M251 M441 M489 M384 M553 M721 M
Interest income5 M8 M25 M
InterestExpenseNonOperating64 M62 M154 M263 M367 M349 M340 M335 M391 M418 M
MinorityInterests996 M868 M1,878 M3,648 M3,731 M
MiscOtherSpecialCharges18 M-6 M5 M33 M-15 M9 M-2 M20 M-47 M-65 M
Net income from total operations866 M1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M
NetIncomeCommonStockholders866 M1,084 M1,145 M1,749 M1,298 M1,580 M2,030 M1,864 M2,020 M2,389 M
NetIncomeContinuousOperations866 M1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M
NetIncomeDiscontinuousOperations-42 M
NetNonOperatingInterestIncomeExpense-64 M-62 M-154 M-263 M-367 M-349 M-340 M-330 M-383 M-392 M
NonRecurringOperationExpense136 M-35 M
Normalized income622 M6,552 M776 M954 M972 M1,318 M1,722 M1,672 M
Operating income1,304 M7,426 M1,763 M1,714 M2,067 M2,448 M2,864 M2,559 M3,018 M3,626 M
Operating income before depreciation (EBITDA)1,521 M1,813 M2,010 M2,347 M2,335 M2,915 M3,448 M3,216 M3,584 M4,215 M
OperatingExpense9,825 M3,914 M10,093 M13,269 M5,352 M5,588 M5,819 M5,984 M6,307 M7,133 M
Other income net-18 M5 M-10 M-41 M15 M113 M4 M-19 M47 M66 M
Other special charges3 M5,780 M-1 M-21 M
OtherGainLossFromDispositionOfDiscontinuedOperations-42 M
OtherGandA3,860 M3,914 M4,135 M4,798 M5,034 M5,275 M5,478 M5,573 M6,332 M7,065 M
OtherImpairmentOfCapitalAssets122 M2 M16 M
OtherOperatingExpenses-3 M-4 M-6 M-7 M-13 M-15 M28 M102 M-25 M67 M
OtherWriteOff63 M43 M38 M58 M65 M
PromotionAndAdvertising299 M338 M351 M374 M358 M
RentAndLandingFees377 M394 M418 M465 M553 M
Research & development expense50 M58 M5,933 M58 M10,116 M
ResearchExpense50 M58 M5,933 M58 M10,116 M
RestructringAndMnAIncome-201 M-234 M-239 M-223 M-251 M-329 M-304 M-372 M-644 M-888 M
Revenue per share1,158 M1,146 M25 M207 M318 M313 M313 M310 M7,900 M7,956 M
SalariesAndWages-65 M-72 M-27 M-34 M-20 M-25 M-24 M-24 M-25 M-29 M
Selling Gen & administrative expense9,825 M3,914 M4,135 M4,798 M5,034 M5,275 M5,478 M5,573 M6,332 M7,065 M
SellingAndMarketingExpense5,965 M338 M351 M374 M358 M
SellingExpense5,965 M
Special income/charges198 M-5,780 M-11 M-2 M-136 M35 M304 M372 M-15 M-58 M
Total Income available for interest expense (EBIT)1,322 M1,611 M1,749 M1,733 M1,726 M2,331 M2,860 M2,583 M2,964 M3,527 M
Total common shares outstanding285 M277 M280 M282 M278 M277 M269 M260 M258 M254 M
Total net income866 M1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M
Total ordinary shares254 M254 M254 M254 M254 M254 M254 M254 M254 M254 M
Total revenues11,130 M11,339 M11,856 M14,984 M17,535 M17,901 M18,362 M19,945 M22,149 M23,052 M
TotalExpenses15,791 M9,694 M16,026 M21,534 M15,468 M15,452 M15,498 M17,386 M19,131 M19,426 M
TotalRevenue11,130 M11,339 M11,856 M14,984 M17,535 M17,901 M18,362 M19,945 M22,149 M23,052 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 is a complete Excel stock solution

Kevin Hsu


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

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University