Projected Income Statement: Wayfair Inc.

Forecast Balance Sheet: Wayfair Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 653 1,859 1,741 1,510 1,691 1,181 520 -83.4
Change - 184.69% -6.35% -13.27% 11.99% -30.16% -55.97% -116.04%
Announcement Date 2/24/22 2/23/23 2/22/24 2/20/25 2/19/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Wayfair Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 101 186 148 73 70 200.2 208.1 246.8
Change - 84.16% -20.43% -50.68% -4.11% 186.04% 3.91% 18.61%
Free Cash Flow (FCF) 1 130 -1,132 -2 83 329 644 689.4 843.2
Change - -970.77% 99.82% 4,250% 296.39% 95.73% 7.06% 22.3%
Announcement Date 2/24/22 2/23/23 2/22/24 2/20/25 2/19/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Wayfair Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 4.48% -3.4% 2.55% 3.82% 5.96% 6.38% 6.96% 7.43%
EBIT Margin (%) 2.13% -6.44% -0.92% 0.56% 3.52% 4.13% 4.73% 5.24%
EBT Margin (%) -0.95% -10.8% -6.07% -4.07% -2.44% 0.45% 1.29% 2.2%
Net margin (%) -0.96% -10.89% -6.15% -4.15% -2.51% 0.43% 1.24% 2.33%
FCF margin (%) 0.95% -9.27% -0.02% 0.7% 2.64% 4.92% 4.97% 5.75%
FCF / Net Income (%) -99.24% 85.05% 0.27% -16.87% -105.11% 1,132.91% 399.07% 247.18%

Profitability

        
ROA 6.04% -32.66% -3.6% -14.19% -9.07% 6.8% 9.69% 2.8%
ROE - - - - - 1.7% - -

Financial Health

        
Leverage (Debt/EBITDA) 1.06x -4.47x 5.69x 3.33x 2.28x 1.41x 0.54x -
Debt / Free cash flow 5.02x -1.64x -870.5x 18.19x 5.14x 1.83x 0.75x -

Capital Intensity

        
CAPEX / Current Assets (%) 0.74% 1.52% 1.23% 0.62% 0.56% 1.53% 1.5% 1.68%
CAPEX / EBITDA (%) 16.45% -44.71% 48.37% 16.11% 9.42% 23.97% 21.54% 22.64%
CAPEX / FCF (%) 77.69% -16.43% -7,400% 87.95% 21.28% 31.09% 30.18% 29.27%

Items per share

        
Cash flow per share 1 3.942 -6.358 3.061 2.577 4.172 4.999 5.239 4.7
Change - -261.29% 148.15% -15.81% 61.87% 19.84% 4.8% -10.29%
Dividend per Share 1 - - - - - 0.013 - -
Change - - - - - - - -
Book Value Per Share 1 -15.44 -23.48 -23.75 -22.4 -21.34 -15.9 -11.7 -7.385
Change - -52.06% -1.12% 5.67% 4.71% 25.51% 26.4% 36.9%
EPS 1 -1.26 -12.54 -6.47 -4.01 -2.44 0.3861 1.207 2.355
Change - -895.24% 48.41% 38.02% 39.15% 115.82% 212.64% 95.08%
Nbr of stocks (in thousands) 104,544 107,122 117,947 125,319 130,338 130,748 130,748 130,748
Announcement Date 2/24/22 2/23/23 2/22/24 2/20/25 2/19/26 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 194x 62x
PBR -4.71x -6.39x
EV / Sales 0.84x 0.74x
Yield 0.02% -

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
32
Last Close Price
74.83USD
Average target price
104.89USD
Spread / Average Target
+40.17%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. W Stock
  4. Financials Wayfair Inc.
SPRING SALE -40%: The Best Tools Reserved for Subscribers to Identify Tomorrow's Top Investments!
d
:
:
BENEFIT NOW