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

SHW Stock Annual Balance Sheet. Download in Excel

Sherwin-Williams Company (The) logo

Sherwin-Williams Company (The)

Sector: Basic Materials   

Industry: Specialty Chemicals

345.47
 
USD
  
3.09
  
(0.90%)
Previous close: 342.38  Open: 339.74  Bid: 345.47  Ask: 352.63
52 week range    
282.09   
   400.42
Mkt Cap: 91,370 M  Avg Vol (90 Days): 2,543,495
Peers   
VAL / 
PPG / 
RPM / 
AKZOY / 
DD / 
MAS / 
FUL / 
Last updated: Sunday 22nd December 2024

Stock Rankings

47
MarketXLS Rank
60
Value
23
Technical
60
Quality
How are these ranks calculated?
Search for a stock

Financials

SHW Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable1,042 M1,158 M1,035 M1,792 M1,799 M1,876 M2,118 M2,403 M2,437 M2,315 M
Accounts receivable1,131 M1,114 M1,231 M2,105 M2,019 M2,089 M2,078 M2,352 M2,564 M2,468 M
Accrued expenses1,129 M1,239 M1,111 M1,871 M1,880 M1,962 M2,301 M2,563 M2,634 M2,512 M
Accumulated depreciation & depletion-1,814 M-1,882 M-2,005 M-2,090 M-2,263 M-2,547 M-2,714 M-2,797 M-2,982 M-3,040 M
Additional paid in capital2,080 M2,330 M2,489 M2,723 M2,896 M3,153 M3,491 M3,793 M3,964 M4,194 M
Building & improvements698 M696 M715 M962 M979 M1,044 M
Cash and equivalents41 M206 M890 M204 M156 M162 M227 M166 M199 M277 M
CashCashEquivalentsAndShortTermInvestments41 M206 M890 M204 M156 M162 M227 M166 M199 M277 M
CashEquivalents41 M206 M227 M
Common par115 M116 M117 M118 M118 M119 M90 M91 M91 M92 M
Common stock equity996 M868 M1,878 M3,648 M3,731 M4,123 M3,611 M2,437 M3,102 M3,716 M
CommonStock115 M116 M117 M118 M118 M119 M90 M91 M91 M92 M
Construction in progress59 M81 M117 M177 M148 M144 M
Cost in excess1,158 M1,143 M1,127 M6,814 M6,957 M7,005 M7,049 M7,135 M7,583 M7,626 M
CurrentAccruedExpenses360 M338 M398 M508 M505 M553 M753 M
CurrentCapitalLeaseObligation297 M318 M343 M391 M412 M372 M387 M410 M425 M449 M
CurrentDeferredAssets109 M88 M57 M
CurrentDeferredRevenue209 M277 M243 M266 M260 M293 M366 M
CurrentDeferredTaxesAssets109 M88 M390 M267 M343 M847 M931 M899 M958 M1,004 M
CurrentDeferredTaxesLiabilities340 M364 M398 M1,623 M1,398 M1,759 M1,710 M1,604 M1,563 M1,611 M
CurrentProvisions17 M22 M20 M29 M51 M58 M69 M46 M50 M88 M
DeferredFinancingCosts49 M51 M53 M58 M57 M49 M
DefinedPensionBenefit250 M245 M226 M297 M271 M43 M53 M
DividendsPayable619 M624 M
EmployeeBenefits278 M249 M250 M275 M258 M263 M276 M259 M139 M133 M
Finished goods842 M841 M899 M1,356 M1,426 M1,510 M1,428 M1,379 M1,958 M1,811 M
Float term debt1,123 M1,907 M1,211 M9,886 M8,708 M9,421 M9,701 M10,062 M11,104 M9,887 M
GoodwillAndOtherIntangibleAssets1,447 M1,399 M1,382 M12,817 M12,158 M11,739 M11,520 M11,136 M11,585 M11,507 M
Gross fixed assets (Plant Property & Equipment)2,835 M2,923 M3,101 M3,967 M4,040 M6,068 M6,310 M6,485 M7,055 M7,764 M
IncomeTaxPayable87 M81 M77 M80 M81 M86 M184 M160 M197 M197 M
Intangibles289 M255 M255 M6,002 M5,202 M4,735 M4,471 M4,002 M4,002 M3,881 M
InterestPayable-62 M154 M-263 M-367 M-349 M-340 M-335 M-391 M-417 M
Inventories1,034 M1,019 M1,068 M1,742 M1,815 M1,890 M1,804 M1,927 M2,627 M2,330 M
InventoriesAdjustmentsAllowances-91 M-91 M-88 M-104 M-106 M-115 M-126 M-119 M-139 M-171 M
Invested capital3,242 M4,682 M4,301 M23,419 M21,147 M21,595 M21,579 M21,090 M23,797 M21,981 M
Land & improvements126 M120 M116 M255 M245 M242 M
LineOfCredit44 M75 M66 M61 M51 M89 M150 M146 M
LongTermCapitalLeaseObligation1,371 M1,434 M1,471 M1,513 M1,510 M
LongTermDebtAndCapitalLeaseObligation1,123 M1,907 M1,211 M9,886 M8,708 M9,421 M9,701 M10,062 M11,104 M9,887 M
LongTermProvisions130 M164 M180 M323 M315 M301 M277 M240 M231 M
Machinery furniture & equipment1,952 M2,027 M2,153 M2,573 M2,669 M2,952 M
Net fixed assets (net PP&E)1,021 M1,042 M1,096 M1,877 M1,777 M3,521 M3,596 M3,688 M4,074 M4,724 M
NetOtherUnrealizedGainLoss118 M104 M125 M51 M
NetUnrealizedGainLossForeignCurrency354 M483 M501 M-353 M
NetUnrealizedGainLossInvestments593000.0-120000.01 M2 M
Non-current deferred income taxes44 M33 M74 M1,420 M1,131 M970 M846 M768 M682 M683 M
NonCurrentDeferredAssets57 M
NonCurrentDeferredLiabilities74 M1,420 M1,131 M970 M846 M768 M682 M683 M
NonCurrentDeferredRevenue9 M18 M10 M8 M9 M7 M4 M
NonCurrentDeferredTaxesAssets112 M116 M57 M113 M162 M204 M233 M192 M204 M206 M
NonCurrentPensionAndOtherPostretirementBenefitPlans278 M249 M250 M275 M258 M263 M276 M259 M139 M133 M
Other current assets253 M231 M381 M356 M355 M491 M483 M608 M519 M438 M
Other equity adjustments-472 M-587 M-540 M-385 M-630 M-679 M-718 M
Other fixed assets3,521 M3,596 M3,688 M4,074 M4,724 M
Other non-current assets421 M436 M422 M502 M584 M561 M694 M789 M1,027 M1,211 M
Other non-current liabilities628 M613 M509 M684 M1,146 M1,209 M1,374 M1,421 M1,606 M1,908 M
Other receivable17,901 M18,362 M19,945 M22,149 M23,052 M
OtherCurrentBorrowings679 M39 M41 M634 M328 M205 M100000.0764 M978 M374 M
OtherCurrentLiabilities869 M861 M977 M1,481 M1,646 M1,542 M1,881 M1,722 M1,923 M2,192 M
OtherEquityInterest354 M-483 M85 M51 M45 M
OtherInventories253 M288 M377 M1,890 M1,804 M1,927 M2,627 M2,330 M
OtherPayable8,810 M77 M
Payables1,129 M1,239 M1,111 M1,871 M1,880 M1,962 M2,301 M2,563 M2,634 M2,512 M
Preferred securities of subsidiary trust30 M30 M30 M30 M30 M30 M30 M
PreferredStock30 M30 M30 M30 M30 M30 M30 M
RecievablesAdjustmentsAllowances-54 M-49 M-40 M-53 M-46 M-36 M-53 M-49 M-57 M-60 M
Retained earnings1,953 M2,642 M3,509 M5,074 M5,617 M6,687 M126 M1,423 M2,823 M4,664 M
Short term debt683 M43 M741 M635 M636 M635 M25 M1,024 M979 M1,473 M
Total assets5,706 M5,779 M6,753 M19,900 M19,134 M20,496 M20,402 M20,667 M22,594 M22,954 M
Total current assets2,567 M2,657 M3,570 M4,407 M4,345 M4,632 M4,591 M5,054 M5,908 M5,513 M
Total current liabilities2,681 M2,142 M2,829 M3,987 M4,161 M4,510 M4,594 M5,720 M5,961 M6,627 M
Total equity996 M868 M1,878 M3,648 M3,731 M4,123 M3,611 M2,437 M3,102 M3,716 M
Total liabilities4,710 M4,911 M4,874 M16,252 M15,404 M16,373 M16,791 M18,230 M19,492 M19,239 M
Total non-current assets3,139 M3,122 M3,182 M15,493 M14,790 M15,865 M15,810 M15,613 M16,686 M17,442 M
Total non-current liabilities2,029 M2,769 M2,045 M12,264 M11,242 M11,863 M12,196 M12,510 M13,531 M12,612 M
TotalEquityGrossMinority996 M868 M1,878 M3,648 M3,731 M4,123 M3,611 M2,437 M3,102 M3,716 M
TotalEquityGrossMinorityInterest996 M868 M1,878 M3,648 M3,731 M4,123 M3,611 M2,437 M3,102 M3,716 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest5,706 M5,779 M6,753 M19,900 M19,134 M20,496 M20,402 M20,667 M22,594 M22,954 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,029 M2,769 M2,045 M12,264 M11,242 M11,863 M12,196 M12,510 M13,531 M12,612 M
TotalTaxPayable87 M81 M77 M80 M81 M86 M184 M160 M197 M197 M
Treasury stock-3,150 M-4,220 M-4,236 M-4,266 M-4,901 M-5,836 M-96 M-2,870 M-3,776 M-5,234 M
UnearnedPremiums26 M25 M
Work in progress192 M178 M170 M386 M389 M380 M377 M548 M669 M519 M
Working capital-114 M515 M741 M420 M183 M122 M-3 M-666 M-53 M-1,114 M
debtc683 M43 M741 M635 M636 M1,006 M413 M1,434 M1,404 M1,922 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

StockKevin.com

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.

Dave

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