Projected Income Statement: Airbnb, Inc.

Forecast Balance Sheet: Airbnb, Inc.

Forecast Balance Sheet - Airbnb, Inc.
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 -6,340 -7,635 -8,080 -8,620 -11,014 -11,209 -14,157 -17,915
Change - -20.43% -5.83% -6.68% -27.77% -1.77% -26.3% -26.55%
Announcement Date 2/15/22 2/14/23 2/13/24 2/13/25 2/12/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Airbnb, Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 25.32 25 47 - 33 43.65 56.99 59.92
Change - -1.27% 88% - - 32.27% 30.57% 5.13%
Free Cash Flow (FCF) 1 2,164 3,405 3,837 4,500 4,550 5,338 5,797 6,430
Change - 57.32% 12.69% 17.28% 1.11% 17.32% 8.61% 10.91%
Announcement Date 2/15/22 2/14/23 2/13/24 2/13/25 2/12/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Airbnb, Inc.

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

Profitability

        
EBITDA Margin (%) 26.59% 34.57% 36.84% 36.4% 35.13% 35.62% 36.49% 37.53%
EBIT Margin (%) 7.17% 21.45% 15.31% 23% 20.78% 22.49% 23.96% 25.78%
EBT Margin (%) -5.01% 23.68% 21.2% 30% 25.63% 27.13% 28.11% 29.96%
Net margin (%) -5.88% 22.54% 48.32% 23.85% 20.51% 22.43% 23.02% 24.12%
FCF margin (%) 36.12% 40.54% 38.69% 40.53% 37.17% 37.65% 36.64% 36.51%
FCF / Net Income (%) -614.82% 179.87% 80.07% 169.94% 181.2% 167.81% 159.12% 151.41%

Profitability

        
ROA -2.91% 12.73% 26.13% 12.73% 11.63% 12.99% 13.01% 13.1%
ROE -9.17% 36.63% 69.83% 31.95% 30.23% 34.2% 31.01% 28.31%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - -
Debt / Free cash flow - - - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 0.42% 0.3% 0.47% - 0.27% 0.31% 0.36% 0.34%
CAPEX / EBITDA (%) 1.59% 0.86% 1.29% - 0.77% 0.86% 0.99% 0.91%
CAPEX / FCF (%) 1.17% 0.73% 1.22% - 0.73% 0.82% 0.98% 0.93%

Items per share

        
Cash flow per share 1 3.555 5.044 5.867 7.005 7.458 9.469 9.858 9.776
Change - 41.88% 16.32% 19.39% 6.46% 26.98% 4.1% -0.83%
Dividend per Share 1 - - - - - - - -
Change - - - - - - - -
Book Value Per Share 1 7.754 - 12.33 13.5 13.16 16.34 21.15 26.27
Change - - - 9.47% -2.53% 24.17% 29.43% 24.23%
EPS 1 -0.57 2.79 7.24 4.11 4.03 5.31 6.26 7.498
Change - 589.47% 159.5% -43.23% -1.95% 31.76% 17.9% 19.77%
Nbr of stocks (in thousands) 626,189 633,177 640,926 624,772 606,350 589,586 589,586 589,586
Announcement Date 2/15/22 2/14/23 2/13/24 2/13/25 2/12/26 - - -
1USD
Estimates
2026 *2027 *
P/E 32.7x 27.7x
PBR 10.6x 8.21x
EV / Sales 6.43x 5.58x
Yield - -

EPS & Dividend

EPS & Dividend - Airbnb, Inc.


Y-o-Y evolution of P/E

Valuation ratios - P/E - Airbnb, Inc.
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Airbnb, Inc.
Trader
Investor
Global
Quality
ESG MSCI
-
MarketScreener Ratings - Airbnb, Inc.
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
44
Last Close Price
173.69USD
Average target price
183.40USD
Spread / Average Target
+5.59%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Airbnb, Inc.