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

314.02
 
USD
  
5.61
  
(1.82%)
Optionable: Yes  Market Cap: 19,773 M  90-day average vol: 1,063,641

Previous close: 308.41  Open: 312.94  Bid: 314.0  Ask: 316.88
52 week range    
109.44   
   317.65
Peers   
BBBY / 
KIRK / 
Last updated: Thursday 28th March 2024
69
MarketXLS Rank
55
Value
76
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 Balance Sheet

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
"""debtc"""2 M2 M528 M509 M217 M232 M
Accounts payable405 M397 M447 M454 M459 M527 M521 M543 M613 M508 M
Accrued expenses592 M566 M642 M607 M652 M712 M719 M880 M1,012 M817 M
Accumulated depreciation & depletion-1,382 M-1,386 M-1,454 M-1,586 M-1,687 M-1,813 M-1,883 M-1,954 M-2,062 M-2,154 M
Additional paid in capital523 M527 M541 M557 M563 M582 M606 M638 M601 M573 M
Cash and equivalents344 M223 M194 M214 M390 M339 M432 M1,200 M850 M367 M
CashCashEquivalentsAndShortTermInvestments344 M223 M194 M214 M390 M339 M432 M1,200 M850 M367 M
CashEquivalents344 M223 M194 M214 M390 M339 M432 M1,200 M850 M367 M
Common par941000.0919000.0896000.0873000.0837000.0789000.0772000.0764000.0720000.0663000.0
Common stock equity1,256 M1,225 M1,198 M1,248 M1,204 M1,156 M1,236 M1,651 M1,664 M1,701 M
CommonStock941000.0919000.0896000.0873000.0837000.0789000.0772000.0764000.0720000.0663000.0
Cost in excess19 M19 M19 M19 M19 M85 M85 M85 M85 M77 M
CurrentAccruedExpenses138 M136 M127 M130 M136 M164 M175 M268 M320 M248 M
CurrentCapitalLeaseObligation232 M238 M258 M269 M289 M292 M228 M210 M217 M232 M
CurrentDeferredAssets121 M131 M
CurrentDeferredRevenue228 M262 M297 M294 M292 M290 M290 M373 M448 M479 M
CurrentDeferredTaxesAssets121 M131 M
CurrentDeferredTaxesLiabilities37 M135 M142 M135 M67 M42 M45 M59 M55 M79 M
Deferred revenues228 M262 M297 M294 M292 M290 M290 M373 M448 M479 M
DerivativeProductLiabilities9000.0115000.0
DividendsPayable122 M125 M130 M134 M136 M145 M156 M163 M199 M216 M
Float term debt2 M299 M300 M
GoodwillAndOtherIntangibleAssets85 M85 M85 M85 M77 M
Gross fixed assets (Plant Property & Equipment)2,232 M2,269 M2,341 M2,509 M2,619 M930 M3,979 M3,914 M4,116 M4,506 M
IncomeTaxPayable49 M32 M67 M23 M57 M21 M23 M69 M80 M61 M
Inventories813 M888 M978 M978 M1,062 M1,125 M1,101 M1,006 M1,246 M1,456 M
InventoriesAdjustmentsAllowances-10 M-10 M-10 M-14 M-13 M-14 M-13 M-10 M-14 M-25 M
Invested capital1,258 M1,225 M1,198 M1,248 M1,503 M1,455 M1,236 M1,651 M1,664 M1,701 M
LineOfCredit6 M7 M7 M7 M6 M4 M4 M500000.0
LongTermCapitalLeaseObligation1,095 M1,025 M1,067 M1,212 M
LongTermDebtAndCapitalLeaseObligation2 M299 M300 M1,095 M1,025 M1,067 M1,212 M
LongTermProvisions158 M167 M173 M196 M202 M28 M21 M16 M10 M
Net fixed assets (net PP&E)849 M883 M887 M923 M932 M930 M2,095 M1,960 M2,054 M2,352 M
Non-current deferred income taxes10 M5 M22 M17 M201 M37 M55 M77 M65 M
NonCurrentDeferredAssets14 M4 M142 M135 M67 M44 M48 M62 M57 M81 M
NonCurrentDeferredLiabilities201 M28 M
NonCurrentDeferredTaxesAssets14 M4 M142 M135 M67 M44 M48 M62 M57 M81 M
Number of employees12500.012500.012500.012500.012500.012500.012500.012500.012500.012500.0
Other current assets11 M13 M11 M11 M12 M22 M21 M23 M26 M32 M
Other equity adjustments-3 M-11 M-10 M-7 M-11 M-15 M-7 M-11 M-14 M
Other non-current assets55 M51 M53 M51 M150 M59 M70 M87 M106 M116 M
Other non-current liabilities60 M63 M50 M71 M73 M81 M86 M117 M107 M104 M
Other receivable60 M67 M79 M89 M90 M107 M112 M144 M132 M116 M
OtherCurrentBorrowings2 M2 M
OtherCurrentLiabilities39 M47 M58 M60 M63 M73 M73 M86 M95 M108 M
OtherEquityInterest7 M-3 M
OtherPayable194 M205 M203 M197 M190 M190 M
Payables454 M430 M514 M477 M516 M548 M544 M612 M692 M570 M
Preferred securities of subsidiary trust7500.07500.08 M
PreferredStock7500.07500.08 M
Prepaid expenses69 M70 M74 M77 M83 M101 M90 M94 M69 M65 M
Retained earnings729 M701 M669 M702 M647 M584 M645 M1,020 M1,074 M1,142 M
SecuritySoldNotYetRepurchased239 M224 M225 M151 M196 M295 M149 M150 M899 M880 M
Short term debt2 M2 M300 M299 M
Total assets2,337 M2,330 M2,417 M2,477 M2,786 M2,813 M4,054 M4,661 M4,626 M4,663 M
Total current assets1,419 M1,392 M1,336 M1,367 M1,636 M1,694 M1,756 M2,467 M2,324 M2,036 M
Total current liabilities861 M876 M996 M961 M1,008 M1,075 M1,610 M1,848 M1,772 M1,636 M
Total equity1,256 M1,225 M1,198 M1,248 M1,204 M1,156 M1,236 M1,651 M1,664 M1,701 M
Total liabilities1,081 M1,106 M1,219 M1,229 M1,582 M1,657 M2,818 M3,010 M2,961 M2,962 M
Total non-current assets918 M938 M1,081 M1,110 M1,149 M1,119 M2,298 M2,194 M2,302 M2,627 M
Total non-current liabilities220 M230 M223 M267 M574 M582 M1,209 M1,162 M1,190 M1,326 M
TotalEquityGrossMinority1,256 M1,225 M1,198 M1,248 M1,204 M1,156 M1,236 M1,651 M1,664 M1,701 M
TotalEquityGrossMinorityInterest1,256 M1,225 M1,198 M1,248 M1,204 M1,156 M1,236 M1,651 M1,664 M1,701 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,337 M2,330 M2,417 M2,477 M2,786 M2,813 M4,054 M4,661 M4,626 M4,663 M
TotalNonCurrentLiabilitiesNetMinorityInteres220 M230 M223 M267 M574 M582 M1,209 M1,162 M1,190 M1,326 M
TotalTaxPayable49 M32 M67 M23 M57 M21 M23 M69 M80 M61 M
Treasury stock-3 M-2 M-2 M-1 M-725000.0-235000.0-941000.0-599000.0-711000.0-739000.0
Working capital558 M516 M340 M406 M629 M620 M146 M619 M552 M400 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.

We respect your privacy and will never share your email.
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