Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

Sector: Consumer Cyclical   

Industry: Specialty Retail

279.53
 
USD
  
-1.51
  
(-0.54%)
Optionable: Yes  Market Cap: 18,115 M  90-day average vol: 1,105,297

Previous close: 281.04  Open: 283.02  Bid: 259.87  Ask: 297.64
52 week range    
109.44   
   319.78
Peers   
BBBY / 
KIRK / 
Last updated: Friday 19th April 2024
59
MarketXLS Rank
55
Value
46
Technical
76
Quality

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

Financials

WSM Cash Flow

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
(Increase) Decrease in inventories-175 M-77 M-93 M4 M-80 M-70 M24 M99 M-240 M-209 M
(Increase) Decrease in other current assets-14 M-61000.0-9 M-6 M-16 M-55 M-3 M-16 M
(Increase) Decrease in other current liabilities22 M34 M36 M-3 M-2 M39 M-640000.083 M75 M32 M
(Increase) Decrease in payables143 M-13 M95 M-41 M36 M27 M-10 M72 M67 M-132 M
(Increase) Decrease in receivables786000.0-9 M-13 M-10 M149000.0-15 M-5 M-32 M12 M16 M
Acquisitions-81 M
Amortization of intangibles-25 M-24 M-6 M-4 M-3 M
CapitalExpenditureReported194 M205 M203 M197 M190 M190 M186 M170 M227 M354 M
Cash at beginning of period425 M330 M223 M194 M214 M390 M339 M432 M1,200 M850 M
Cash at end of period330 M223 M194 M214 M390 M339 M432 M1,632 M850 M367 M
Cash flow454 M462 M544 M525 M500 M586 M607 M1,275 M1,371 M1,053 M
CashFlowFromContinuingInvestingActivities-191 M-189 M-202 M-197 M-270 M-188 M-186 M-169 M-226 M-354 M
ChangeInAccountPayable135 M4 M61 M3 M2 M62 M-11 M25 M57 M-114 M
ChangeInAccruedExpense44 M9 M-135000.026 M9 M46 M13 M129 M49 M-62 M
ChangeInIncomeTaxPayable7 M-17 M35 M-44 M34 M-35 M735000.047 M10 M-18 M
ChangeInInterestPayable44 M9 M-135000.026 M9 M46 M13 M129 M49 M-62 M
ChangeInPayablesAndAccruedExpense186 M-4 M95 M-15 M45 M73 M3 M202 M116 M-194 M
ChangeInPrepaidAssets4 M-386000.05 M5 M-403000.0-16 M-2 M-12 M
ChangeInTaxPayable7 M-17 M35 M-44 M34 M-35 M735000.047 M10 M-18 M
ChangeInWorkingCapital24 M-56 M21 M-24 M-54 M-28 M18 M336 M-38 M-367 M
ChangesInAccountReceivables786000.0-9 M-13 M-10 M149000.0-15 M-5 M-32 M12 M16 M
CommonStockDividendPaid-112 M-126 M-128 M-134 M-135 M-140 M-151 M-158 M-188 M-217 M
CommonStockPayments-239 M-224 M-225 M-151 M-196 M-295 M-149 M-150 M-899 M-880 M
Current deferred income taxes-28 M-248000.0-7 M7 M63 M24 M-3 M-13 M3 M-24 M
Deferred income taxes-28 M-248000.0-7 M7 M63 M24 M-3 M-13 M3 M-24 M
Depreciation150 M162 M168 M173 M183 M189 M188 M189 M196 M214 M
Depreciation unreconciled124 M138 M143 M148 M158 M163 M180 M183 M192 M211 M
DepreciationAndAmortization124 M138 M143 M148 M158 M163 M180 M183 M192 M211 M
Effect of exchange rate changes-2 M-1 M-2 M-2 M-2 M797000.0-1 M5 M-3 M-3 M
ExcessTaxBenefitFromStockBasedCompensation-9 M-27 M-14 M-5 M
FinancingCashFlow-355 M-379 M-369 M-306 M-52 M-450 M-327 M-343 M-1,492 M-1,179 M
Free cash flow260 M257 M341 M327 M310 M396 M421 M1,105 M1,145 M699 M
GainLossOnSaleOfPPE3 M2 M4 M4 M2 M10 M2 M32 M1 M25 M
IncomeTaxPaidSupplementalData187 M172 M134 M203 M99 M108 M113 M163 M306 M401 M
InterestPaidSupplementalData1 M1 M2 M2 M3 M11 M13 M18 M3 M788000.0
IssuanceOfDebt-2 M-2 M-2 M300 M-300 M
Net cash from financing activities-355 M-379 M-369 M-306 M-52 M-450 M-327 M89 M-1,492 M-1,179 M
Net cash from investing activities-191 M-189 M-202 M-197 M-270 M-188 M-186 M-169 M-226 M-354 M
Net cash from operating activities454 M462 M544 M525 M500 M586 M607 M1,275 M1,371 M1,053 M
Net change in cash & cash equivalents-94 M-107 M-29 M20 M176 M-51 M93 M773 M-350 M-480 M
Net income from continuing operations279 M309 M310 M305 M260 M334 M356 M681 M1,126 M1,128 M
NetBusinessPurchaseAndSale-81 M
NetCommonStockIssuance-239 M-224 M-225 M-151 M-196 M-295 M-149 M-150 M-899 M-880 M
NetInvestmentPropertiesPurchaseAndSale3 M16 M769000.0439000.0480000.02 M728000.0629000.0270000.0162000.0
NetInvestmentPurchaseAndSale3 M16 M769000.0439000.0480000.02 M728000.0629000.0270000.0162000.0
NetIssuancePaymentsOfDebt-2 M-2 M-2 M300 M-300 M
NetLongTermDebtIssuance-2 M-2 M-2 M300 M-300 M
NetPPEPurchaseAndSale-194 M-205 M-203 M-197 M-190 M-190 M-186 M-170 M-227 M-354 M
Operating (gains) losses3 M2 M4 M4 M2 M10 M2 M32 M1 M25 M
Other financing charges net-9 M-31 M-17 M-22 M-19 M-14 M-28 M400 M-104 M-81 M
Other investing changes net3 M16 M769000.0439000.0480000.02 M728000.0629000.0270000.0162000.0
Other non-cash items52 M69 M73 M85 M71 M84 M54 M56 M88 M79 M
Payment of cash dividends112 M126 M128 M134 M135 M140 M151 M158 M188 M217 M
ProceedsFromStockOptionExercised7 M4 M3 M2 M
Purchase of property plant & equipment-194 M-205 M-203 M-197 M-190 M-190 M-186 M-170 M-227 M-354 M
Purchase of short term investments300 M
PurchaseOfPPE-194 M-205 M-203 M-197 M-190 M-190 M-186 M-170 M-227 M-354 M
Repayment of debt-2 M-2 M-2 M-300 M
RepaymentOfDebt-2 M-92 M-202 M-125 M-170 M-60 M-100 M-488 M-300 M
Repurchase of capital stock-239 M-224 M-225 M-151 M-196 M-295 M-149 M-150 M-899 M-880 M
Revenue per share-25 M-24 M-25 M-25 M-25 M-26 M-8 M-6 M-4 M-3 M
ShortTermDebtIssuance90 M200 M125 M170 M60 M100 M488 M
ShortTermDebtPayments-90 M-200 M-125 M-170 M-60 M-100 M-488 M
StockBasedCompensation39 M45 M41 M51 M43 M60 M64 M73 M95 M90 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