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

SHW Stock Annual Cash Flow. 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 Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-101 M-41 M-53 M-90 M-119 M-75 M84 M-228 M-667 M323 M
(Increase) Decrease in other working capital-31 M-12 M50 M-29 M-68 M19 M-62 M-47 M33 M307 M
(Increase) Decrease in payables92 M165 M-121 M146 M117 M41 M326 M313 M9 M-250 M
(Increase) Decrease in receivables-117 M-38 M-115 M-65 M39 M-121 M51 M-326 M-153 M111 M
Acquisitions-8,810 M-77 M-211 M-1,003 M-265 M
Amortization of intangibles30 M28 M25 M321 M318 M313 M313 M363 M356 M396 M
AssetImpairmentCharge11 M2 M122 M2 M16 M58 M
CapitalExpenditureReported199 M234 M239 M223 M251 M329 M304 M372 M645 M888 M
Cash at beginning of period745 M41 M206 M890 M204 M156 M162 M227 M166 M199 M
Cash at end of period41 M206 M890 M204 M156 M162 M227 M166 M199 M277 M
Cash flow1,081 M1,447 M1,308 M1,842 M1,944 M2,321 M3,409 M2,245 M1,920 M3,522 M
CashFlowFromContinuingInvestingActivities-310 M-289 M-304 M-9,048 M-252 M-463 M-322 M-476 M-1,608 M-1,039 M
CashFromDiscontinuedOperatingActivities42 M
ChangeInAccountPayable79 M160 M-119 M167 M114 M36 M227 M346 M47 M-241 M
ChangeInAccruedExpense30 M-13 M61 M11 M5 M50 M198 M-11 M66 M76 M
ChangeInIncomeTaxPayable13 M5 M-2 M-21 M3 M5 M99 M-33 M-38 M-9 M
ChangeInPayablesAndAccruedExpense121 M152 M-60 M157 M121 M91 M524 M303 M74 M-174 M
ChangeInTaxPayable13 M5 M-2 M-21 M3 M5 M99 M-33 M-38 M-9 M
ChangeInWorkingCapital-128 M61 M-178 M-27 M-28 M-87 M597 M-299 M-712 M567 M
ChangesInAccountReceivables-80 M-57 M-114 M-50 M18 M-73 M10 M-288 M-200 M86 M
CommonStockDividendPaid-215 M-250 M-312 M-319 M-323 M-421 M-488 M-587 M-618 M-624 M
CommonStockPayments-1,489 M-1,035 M-613 M-779 M-2,446 M-2,752 M-883 M-1,432 M
Current deferred income taxes-19 M5 M-68 M-621 M-143 M-131 M-145 M-80 M-145 M-89 M
Deferred income taxes-19 M5 M-68 M-621 M-143 M-131 M-145 M-80 M-145 M-89 M
Depreciation169 M170 M172 M285 M278 M262 M268 M263 M264 M292 M
Depreciation unreconciled199 M202 M261 M614 M608 M584 M589 M633 M620 M688 M
DepreciationAndAmortization199 M202 M261 M614 M608 M584 M581 M573 M581 M623 M
Effect of exchange rate changes-9 M-13 M-13 M-36 M6 M-6 M-1 M5 M3 M20 M
FinancingCashFlow-1,467 M-980 M-307 M6,514 M-1,747 M-1,846 M-3,020 M-1,834 M-282 M-2,425 M
Free cash flow882 M1,224 M1,108 M1,708 M1,731 M1,999 M3,166 M1,887 M1,309 M2,704 M
GainLossOnSaleOfBusiness112 M-20 M
GainLossOnSaleOfPPE1 M-803000.0-31 M5 M13 M16 M-9 M-6 M-11 M900000.0
IncomeTaxPaidSupplementalData310 M335 M478 M420 M292 M408 M437 M466 M580 M817 M
InterestPaidSupplementalData67 M49 M154 M221 M368 M336 M341 M339 M371 M417 M
Issuance of capital stock182 M12 M22 M
Issuance of debt591 M-630 M-899000.0356 M-301 M-123 M-205 M764 M214 M-604 M
IssuanceOfCapitalStock182 M12 M22 M
IssuanceOfDebt92 M167 M-67 M6,729 M-1,159 M-679 M-420 M1,324 M947 M-740 M
Net cash from financing activities-1,467 M-980 M-307 M6,514 M-1,747 M-1,846 M-3,020 M-1,834 M-282 M-2,425 M
Net cash from investing activities-310 M-289 M-304 M-9,048 M-252 M-463 M-322 M-476 M-1,608 M-1,039 M
Net cash from operating activities1,081 M1,447 M1,308 M1,884 M1,944 M2,321 M3,409 M2,245 M1,920 M3,522 M
Net change in cash & cash equivalents-696 M178 M697 M-650 M-55 M12 M66 M-66 M30 M58 M
Net income from continuing operations866 M1,054 M1,133 M1,728 M1,109 M1,541 M2,030 M1,864 M2,020 M2,389 M
NetBusinessPurchaseAndSale-8,810 M-77 M-88 M-1,003 M-161 M
NetCommonStockIssuance-1,489 M-1,035 M-613 M-779 M-2,264 M-2,741 M-861 M-1,432 M
NetInvestmentPropertiesPurchaseAndSale-111 M-66 M-103 M-62 M-39 M-63 M-79 M-31 M7 M-60 M
NetInvestmentPurchaseAndSale-111 M-66 M-103 M-62 M-39 M-63 M-79 M-31 M7 M-60 M
NetIssuancePaymentsOfDebt92 M167 M-67 M6,729 M-1,159 M-679 M-420 M1,324 M947 M-740 M
NetLongTermDebtIssuance-499 M798 M-66 M6,373 M-858 M-557 M-216 M560 M732 M-136 M
NetPPEPurchaseAndSale-199 M-223 M-201 M-176 M-213 M-322 M-243 M-357 M-611 M-818 M
Operating (gains) losses29 M25 M12 M25 M208 M71 M18 M66 M4 M39 M
Other financing charges net45 M47 M-15 M-40 M258 M-122 M-31 M-23 M184 M260 M
Other investing changes net-111 M-66 M-103 M-62 M-39 M-63 M-79 M-31 M7 M-60 M
Other non-cash items135 M101 M149 M123 M190 M343 M320 M61 M133 M-72 M
Payment of cash dividends215 M250 M312 M319 M323 M421 M488 M587 M619 M624 M
PensionAndEmployeeBenefitExpense990000.06 M15 M18 M36 M43 M8 M7 M-2 M-16 M
ProceedsFromStockOptionExercised100 M90 M87 M144 M91 M155 M183 M193 M67 M112 M
Purchase of property plant & equipment-199 M-223 M-201 M-176 M-213 M-322 M-243 M-357 M-611 M-818 M
Purchase of short term investments1 M798 M500000.08,275 M1,333 M999 M995 M1,000 M
PurchaseOfPPE-199 M-234 M-239 M-223 M-251 M-329 M-304 M-372 M-644 M-888 M
Repayment of debt-501 M-66 M-1,902 M-858 M-1,889 M-1,215 M-434 M-268 M-136 M
RepaymentOfDebt-501 M-630 M-66 M-1,902 M-1,159 M-2,012 M-1,419 M-434 M-268 M-136 M
Repurchase of capital stock-1,489 M-1,035 M-613 M-779 M-2,446 M-2,752 M-883 M-1,432 M
Revenue per share30 M31 M89 M329 M330 M322 M321 M370 M356 M396 M
SaleOfBusiness123 M104 M
SaleOfPPE11 M38 M47 M38 M7 M61 M15 M33 M70 M
ShortTermDebtIssuance591 M-630 M-899000.0356 M764 M214 M-604 M
ShortTermDebtPayments591 M-630 M-899000.0356 M-301 M-123 M-205 M
StockBasedCompensation65 M72 M72 M90 M83 M102 M96 M98 M100 M116 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