Wayfair Inc Stock Research

Market Summary

USD34.34+1.86

Market Closed

5.73%

W Alerts

3 major insider sales recently.
Big fall in earnings (Y/Y)
Losses in recent quarter

W Stock Price

W RSI Chart

W Valuation

Market Cap

3.4B

Price/Earnings (Trailing)

-2.59

Price/Sales (Trailing)

0.28

EV/EBITDA

-6

Price/Free Cashflow

-4

W Price/Sales (Trailing)

W Profitability

EBT Margin

-10.80%

Return on Assets

-37.18%

Free Cashflow Yield

-24.98%

W Fundamentals

W Revenue

Revenue (TTM)

12.2B

Revenue Y/Y

-4.64%

Revenue Q/Q

9.19%

W Earnings

Earnings (TTM)

-1.3B

Earnings Y/Y

-73.76%

Earnings Q/Q

-24.03%

Price Action

52 Week Range

28.11121.35

(Low)(High)

Last 7 days

-0.3%

Last 30 days

-19.8%

Last 90 days

-1.2%

Trailing 12 Months

-73.3%

W Financial Health

Current Ratio

0.93

Debt/Cashflow

-0.21

W Investor Care

Shares Dilution (1Y)

1.92%

Diluted EPS (TTM)

-12.54

Peers (Alternatives to Wayfair)

View All Peers In Detail

Name	Mkt Capsorted ascending	Revenue	Price %, 1M	Returns, 1Y	P/E	P/S	Rev 1-Yr	Inc 1-Yr
LARGE-CAP
AMZN	1.1T	514.0B	8.25%	-38.67%	-388.65	2.06	9.40%	-108.16%
EBAY	23.9B	9.8B	-4.34%	-25.69%	-18.85	2.44	-6.00%	-109.33%
CHWY	15.8B	9.8B	-9.05%	-13.81%	-771.83	1.62	14.45%	-288.94%
ETSY	13.9B	2.6B	-10.40%	-19.16%	-20.05	5.43	11.73%	-479.56%
MID-CAP
W	3.4B	12.2B	-19.78%	-73.26%	-2.59	0.28	-10.87%	-916.03%
SMALL-CAP
RVLV	1.9B	1.1B	-5.35%	-53.75%	32.02	1.71	23.56%	-41.21%
OSTK	905.8M	1.9B	4.03%	-56.87%	-25.71	0.47	-30.01%	-109.05%
SFIX	538.2M	1.8B	2.79%	-53.90%	-1.82	0.29	-16.43%	-882.41%
LE	336.9M	1.6B	34.34%	-41.59%	-158.78	0.21	-2.37%	-104.59%
PETS	335.1M	260.5M	-15.34%	-37.54%	29.39	1.29	-6.68%	-47.81%
REAL	116.9M	603.5M	-12.59%	-84.97%	-0.6	0.19	29.04%	16.80%
APRN	23.6M	458.7M	-22.08%	-83.10%	-0.21	0.05	-4.21%	-54.13%
IMBI	14.9M	453.2M	-33.08%	-91.44%	-0.33	0.03	-5.99%	-122.89%

Financials for Wayfair

Income Statement (Last 12 Months)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Revenue	-1.2%	12,218,000,000	12,369,000,000	12,650,000,000	13,223,000,000	13,708,000,000
Gross Profit	0.4%	3,416,000,000	3,404,000,000	3,463,000,000	3,695,000,000	3,895,000,000
Operating Expenses	3.1%	4,800,000,000	4,654,000,000	4,411,000,000	4,125,000,000	3,989,000,000
EBITDA	-15.4%	-921,000,000	-798,000,000	-610,026,000	-111,876,000	219,000,000
EBITDA Margin	-16.8%	-0.08	-0.06	-0.05	-0.01	0.02
Earnings Before Taxes	-11.4%	-1,319,000,000	-1,184,000,000	-976,000,000	-464,000,000	-130,000,000
EBT Margin	-12.8%	-0.11	-0.10	-0.08	-0.04	-0.01
Interest Expenses	-20.6%	27,000,000	34,000,000	26,000,000	25,000,000	27,000,000
Net Income	-12.6%	-1,331,000,000	-1,182,000,000	-977,000,000	-468,000,000	-131,000,000
Net Income Margin	-14.0%	-0.11	-0.10	-0.08	-0.04	-0.01
Free Cahsflow	-2.1%	-860,000,000	-842,000,000	-527,928,000	-110,000,000	309,000,000

Balance Sheet					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Assets	-2.0%	3,580	3,653	4,098	4,256	4,570
Current Assets	-3.5%	1,933	2,004	2,460	2,680	3,012
Cash Equivalents	43.6%	1,050	731	1,094	1,200	1,706
Inventory	-12.6%	90.00	103	98.00	80.00	69.00
Net PPE	1.4%	774	763	730	698	674
Goodwill	0%	0.00	0.00	-	-	-
Liabilities	1.6%	6,130	6,031	6,243	6,160	6,189
Current Liabilities	5.7%	2,072	1,961	2,218	2,199	2,217
Long Term Debt	0.1%	3,137	3,134	3,054	3,054	3,052
Retained Earnings	-12.0%	-3,280	-2,929	-2,646	-2,268	-1,949
Additional Paid-In Capital	30.4%	737	565	513	374	337
Accumulated Depreciation	-	967	-	-	-	-
Shares Outstanding	1.0%	106	105	105	-	-

Cashflow (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Cashflow From Operations	1.3%	-674	-683	-383	7.00	410
Share Based Compensation	11.0%	513	462	423	373	344
Cashflow From Investing	100.2%	1.00	-450	-508	-504	-515
Cashflow From Financing	6.7%	16.00	15.00	-78.00	-378	-303
Buy Backs	0%	75.00	75.00	75.00	375	300

Risks for W

What is the probability of a big loss on W?

100%

Probability that Wayfair stock will be more than 20% underwater in next one year

96.9%

Probability that Wayfair stock will be more than 30% underwater in next one year.

71.2%

Probability that Wayfair stock will be more than 40% underwater in next one year.

*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does W drawdown profile look like?

Y-axis is the maximum loss one would have experienced if Wayfair was unfortunately bought at previous high price.

Drawdowns

Returns for W

Cumulative Returns on W

-4%

7-Year Cumulative Returns

-13.6%

5-Year Cumulative Returns

-14.5%

3-Year Cumulative Returns

What are the long-term rolling returns for W?

FIve years rolling returns for Wayfair.

Annualized Returns

Which funds bought or sold W recently?

View All Details

Datesorted ascending	Fund Name	Type	% Chg	$ Change	$ Held	% Portfolio
2023-03-27	Neo Ivy Capital Management	new	-	526,000	526,000	0.36%
2023-03-23	MetLife Investment Management, LLC	reduced	-0.96	92.00	119,095	-%
2023-03-17	American Portfolios Advisors	unchanged	-	-1,101	3,255	-%
2023-03-10	VICTORY CAPITAL MANAGEMENT INC	reduced	-0.05	2,468	264,468	-%
2023-03-10	BAILLIE GIFFORD & CO	reduced	-3.48	-7,160,810	281,969,000	0.29%
2023-03-06	Rockefeller Capital Management L.P.	reduced	-21.91	-4,000	12,000	-%
2023-03-01	B. Riley Financial, Inc.	new	-	23,785	23,785	-%
2023-02-28	Voya Investment Management LLC	added	2.11	-22,618,400	81,345,600	0.12%
2023-02-24	NATIXIS	new	-	132	132	-%
2023-02-24	SRS Capital Advisors, Inc.	new	-	921	921	-%

Latest Funds Activity

Are funds buying W calls or puts?

Calls

Puts

Are funds bullish or bearish(Calls - Puts)?

Net Call Options

No. of funds that own W

No. of Funds

Wayfair News

Schedule 13G FIlings of Wayfair

Date Filed	Name of Filer	Percent of Class	No. of Shares	Form Type
Feb 14, 2023	spruce house investment management llc	5.08%	4,166,728	SC 13G/A
Feb 14, 2023	prescott general partners llc	4.7%	3,823,239	SC 13G/A
Feb 13, 2023	shah niraj	12.8%	11,973,790	SC 13G/A
Feb 13, 2023	conine steven	12.8%	11,973,564	SC 13G/A
Feb 13, 2023	capital world investors	12.9%	10,530,299	SC 13G/A
Feb 09, 2023	fmr llc	-	0	SC 13G/A
Feb 09, 2023	vanguard group inc	8.41%	6,845,552	SC 13G/A
Jan 20, 2023	baillie gifford & co	10.53%	8,573,098	SC 13G/A
Feb 24, 2022	blackrock inc.	4.6%	3,646,229	SC 13G/A
Feb 14, 2022	prescott general partners llc	4.9%	3,823,239	SC 13G/A

W Fair Value

Wayfair fair value in different scenarios

The table shows the Fair Value estimates for Wayfair for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.

Fair Value	Very Pessimistic	Pessimistic	Base Case	Optimistic	Very Optimistic
Very Low Inflation	- -	- -	- -	- -	- -
Current Inflation	- -	4.07 -88.15%	41.39 20.53%	110.39 221.46%	218.38 535.93%
Very High Inflation	- -	- -	- -	- -	- -

Historical Wayfair Fair Value Estimates

Very Pessimistic Case

Pessimistic Case

Fair Value

Optimistic Case

Very Optimistic Case

Closing Stock Price

Recent SEC filings of Wayfair

View All Filings

Date Filed	Form Type	Document
Mar 17, 2023	4	Insider Trading
Mar 14, 2023	ARS	ARS
Mar 14, 2023	DEF 14A	DEF 14A
Mar 14, 2023	DEFA14A	DEFA14A
Mar 08, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading

Latest Insider Trading transactions for W

Filter Transactions

Datesorted ascending	Name	Buy/Sell	$ Value	Avg. Price	# Shares	Title
2023-03-16	Oblak Steve	sold	-16,238	31.84	-510	chief commercial officer
2023-03-15	Oblak Steve	acquired	-	-	1,037	chief commercial officer
2023-03-02	NAYLOR JEFFREY G	acquired	-	-	6,356	-
2023-03-02	Netzer Thomas	sold	-106,393	38.59	-2,757	chief operating officer
2023-03-02	Oblak Steve	sold	-111,775	38.69	-2,889	chief commercial officer
2023-03-02	Tan Fiona	sold	-124,395	38.62	-3,221	chief technology officer
2023-03-02	Schaferkordt Anke	sold	-465	38.81	-12.00	-
2023-03-02	Kumin Michael Andrew	acquired	-	-	6,356	-
2023-03-02	Gulliver Kate	sold	-55,675	38.61	-1,442	cfo and chief admin officer
2023-03-01	Tan Fiona	acquired	-	-	6,376	chief technology officer

About Wayfair

Niraj S. Shah

www.wayfair.com

16700

Wayfair Inc. engages in the e-commerce business in the United States and internationally. The company provides approximately thirty-three million products for the home sector under various brands. It offers online selections of furniture, dÃƒÂ©cor, housewares, and home improvement products through its sites, including Wayfair, Joss & Main, AllModern, Birch Lane, and Perigold brands. The company was founded in 2002 and is headquartered in Boston, Massachusetts.

W Income Statement

2022-12-31

CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Millions, $ in Millions	12 Months Ended
	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Income Statement [Abstract]
Net revenue	$ 12,218	$ 13,708	$ 14,145
Cost of goods sold	8,802	9,813	10,033
Gross profit	3,416	3,895	4,112
Operating expenses:
Customer service and merchant fees	632	584	510
Advertising	1,473	1,378	1,412
Selling, operations, technology, general and administrative	2,625	2,015	1,826
Impairment and other related net charges	39	12	0
Restructuring charges	31	0	4
Total operating expenses	4,800	3,989	3,752
(Loss) income from operations	(1,384)	(94)	360
Interest expense, net	(27)	(32)	(146)
Other expense, net	(4)	(4)	(9)
Gain on debt extinguishment	96	0	0
(Loss) income before income taxes	(1,319)	(130)	205
Provision for income taxes, net	12	1	20
Net (loss) income	$ (1,331)	$ (131)	$ 185
(Loss) earnings per share:
Basic (in dollars per share)	$ (12.54)	$ (1.26)	$ 1.93
Diluted (in dollars per shares)	$ (12.54)	$ (1.26)	$ 1.86
Weighted-average number of shares of common stock outstanding used in computing per share amounts:
Basic (in shares)	106	104	96
Diluted (in shares)	106	104	99

W Balance Sheet

2022-12-31

CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions	Dec. 31, 2022	Dec. 31, 2021
Current assets
Cash and cash equivalents	$ 1,050	$ 1,706
Short-term investments	228	693
Accounts receivable, net	272	226
Inventories	90	69
Prepaid expenses and other current assets	293	318
Total current assets	1,933	3,012
Operating lease right-of-use assets	839	849
Property and equipment, net	774	674
Other non-current assets	34	35
Total assets	3,580	4,570
Current liabilities
Accounts payable	1,204	1,166
Other current liabilities	868	1,051
Total current liabilities	2,072	2,217
Long-term debt	3,137	3,052
Operating lease liabilities, net of current	893	892
Other non-current liabilities	28	28
Total liabilities	6,130	6,189
Commitments and contingencies (Note 7)
Stockholders’ deficit:
Convertible preferred stock, $0.001 par value per share: 10,000,000 shares authorized and none issued at December 31, 2022 and 2021	0	0
Additional paid-in capital	737	337
Accumulated deficit	(3,280)	(1,949)
Accumulated other comprehensive loss	(7)	(7)
Total stockholders' deficit	(2,550)	(1,619)
Total liabilities and stockholders' deficit	3,580	4,570
Class A common stock
Stockholders’ deficit:
Common stock	0	0
Class B common stock
Stockholders’ deficit:
Common stock	$ 0	$ 0