Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Wayfair Inc. Class A logo

Wayfair Inc. Class A

Sector: Consumer Cyclical   

Industry: Specialty Retail

50.95
 
USD
  
-1.97
  
(-3.72%)
Optionable: Yes  Market Cap: 6,951 M  90-day average vol: 4,082,537

Previous close: 52.92  Open: 50.76  Bid: 51.4  Ask: 51.8
52 week range    
29.51   
   90.71
Peers   
NILE / 
CONN / 
PRTY / 
Last updated: Friday 26th April 2024
27
MarketXLS Rank
40
Value
7
Technical
36
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

W Balance Sheet

Annual
Invalid dateDec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Accounts payable148 M271 M379 M440 M650 M908 M1,157 M1,166 M1,204 M
Accounts receivable6 M10 M19 M38 M51 M100 M110 M226 M272 M
Accrued expenses190 M322 M447 M561 M863 M908 M1,157 M1,166 M1,204 M
Accumulated depreciation & depletion-43 M-64 M-110 M-184 M-290 M-456 M-703 M-967 M-1,228 M
Additional paid in capital364 M378 M409 M537 M754 M1,123 M699 M337 M737 M
Cash and equivalents356 M334 M280 M559 M849 M583 M2,130 M1,706 M1,050 M
CashCashEquivalentsAndShortTermInvestments416 M386 M349 M620 M964 M987 M462 M693 M228 M
CashEquivalents849 M583 M
Common par37000.046000.050000.057000.063000.067000.073000.0
Common stock equity306 M243 M79 M-48 M-331 M-944 M-1,192 M-1,619 M-2,550 M
CommonStock37000.046000.050000.057000.063000.067000.0426 M265 M-2,550 M
Construction in progress4 M
Cost in excess4 M2 M2 M2 M2 M400000.0400000.0400000.0400000.0
CurrentAccruedExpenses42 M52 M68 M120 M213 M299 M
CurrentCapitalLeaseObligation21 M48 M71 M106 M91 M97 M110 M125 M
CurrentDeferredRevenue27 M51 M66 M94 M148 M168 M293 M299 M214 M
CurrentDeferredTaxesAssets9 M20 M47 M62 M158 M366 M450 M328 M310 M
CurrentDeferredTaxesLiabilities55000.013000.026000.013 M66 M120 M-471 M-329 M-310 M
Deferred revenues27 M51 M66 M94 M148 M168 M
Float term debt333 M739 M1,456 M3,529 M3,944 M4,030 M
Gross fixed assets (Plant Property & Equipment)104 M176 M350 M545 M1,421 M1,844 M2,195 M2,490 M2,841 M
Intangibles7 M6 M5 M5 M500000.019 M17 M16 M15 M
Inventories20 M20 M19 M28 M46 M62 M52 M69 M90 M
Invested capital306 M243 M79 M285 M408 M512 M4,996 M5,377 M4,617 M
LineOfCredit3 M6 M11 M15 M27 M47 M
LongTermCapitalLeaseObligation29 M83 M183 M823 M870 M892 M893 M
LongTermDebtAndCapitalLeaseObligation29 M415 M922 M2,279 M3,529 M3,944 M4,030 M
Net fixed assets (net PP&E)61 M112 M239 M361 M1,131 M1,388 M1,492 M1,523 M1,613 M
Non-current deferred income taxes3 M13 M34 M35 M73 M14 M-42 M-35 M-54 M
NonCurrentDeferredTaxesAssets68 M90 M171 M241 M405 M779 M778 M896 M1,500 M
Number of employees15745.015745.015745.015745.015745.015745.015745.015745.015745.0
Other current assets200000.029 M24 M33 M33 M
Other equity adjustments-366000.0-136000.013000.0-2 M-2 M-1 M
Other fixed assets1,492 M1,523 M1,613 M
Other non-current assets2 M6 M10 M11 M19 M32 M32 M35 M34 M
Other non-current liabilities17 M55 M96 M106 M160 M7 M67 M28 M28 M
Other receivable4,721 M6,779 M9,127 M14,145 M13,708 M12,218 M
OtherCurrentLiabilities16 M24 M44 M85 M128 M703 M1,009 M1,051 M868 M
OtherInventories52 M69 M90 M
Payables148 M271 M379 M440 M650 M908 M1,157 M1,166 M1,204 M
Preferred securities of subsidiary trust10 M10 M
PreferredStock10 M10 M
Prepaid expenses45 M76 M91 M131 M195 M229 M292 M318 M293 M
RecievablesAdjustmentsAllowances-9 M-23 M-21 M-12 M-24 M
Restricted cash2,130 M1,706 M1,050 M
Retained earnings-58 M-136 M-330 M-583 M-1,083 M-2,065 M-1,891 M-1,956 M-3,287 M
Total assets556 M695 M762 M1,213 M1,891 M2,953 M4,570 M4,570 M3,580 M
Total current assets487 M492 M477 M817 M1,256 M1,377 M3,046 M3,012 M1,933 M
Total current liabilities233 M397 M557 M740 M1,139 M1,612 M2,166 M2,217 M2,072 M
Total equity306 M243 M79 M-48 M-331 M-944 M-1,192 M-1,619 M-2,550 M
Total liabilities250 M452 M682 M1,262 M2,222 M3,897 M5,762 M6,189 M6,130 M
Total non-current assets69 M202 M285 M397 M1,159 M1,576 M1,524 M1,558 M1,647 M
Total non-current liabilities17 M55 M125 M522 M1,082 M2,286 M3,596 M3,972 M4,058 M
TotalEquityGrossMinority305 M243 M79 M-48 M-331 M-944 M-1,192 M-1,619 M-2,550 M
TotalEquityGrossMinorityInterest305 M243 M79 M-48 M-331 M-944 M-1,192 M-1,619 M-2,550 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest556 M695 M762 M1,213 M1,891 M2,953 M4,570 M4,570 M3,580 M
TotalNonCurrentLiabilitiesNetMinorityInteres17 M55 M125 M522 M1,082 M2,286 M3,596 M3,972 M4,058 M
Treasury stock-380 M-300 M
UnearnedIncome6 M4 M4 M3 M3 M19 M
Working capital254 M95 M-80 M77 M117 M-234 M880 M795 M-139 M
ltinv80 M31 M22 M7 M156 M8 M11 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