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 15/02/22 14/02/23 13/02/24 13/02/25 12/02/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 45.66 58.4 62.3
Change - -1.27% 88% - - 38.36% 27.9% 6.68%
Free Cash Flow (FCF) 1 2,164 3,405 3,837 4,500 4,550 5,339 5,800 6,430
Change - 57.32% 12.69% 17.28% 1.11% 17.35% 8.63% 10.86%
Announcement Date 15/02/22 14/02/23 13/02/24 13/02/25 12/02/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.51% 37.58%
EBIT Margin (%) 7.17% 21.45% 15.31% 23% 20.78% 22.38% 23.86% 25.57%
EBT Margin (%) -5.01% 23.68% 21.2% 30% 25.63% 27.07% 28% 29.78%
Net margin (%) -5.88% 22.54% 48.32% 23.85% 20.51% 22.4% 22.95% 24%
FCF margin (%) 36.12% 40.54% 38.69% 40.53% 37.17% 37.67% 36.64% 36.53%
FCF / Net Income (%) -614.82% 179.87% 80.07% 169.94% 181.2% 168.18% 159.7% 152.2%

Profitability

        
ROA -2.91% 12.73% 26.13% 12.73% 11.63% 13.01% 13% 13.1%
ROE -9.17% 36.63% 69.83% 31.95% 30.23% 34.16% 30.94% 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.32% 0.37% 0.35%
CAPEX / EBITDA (%) 1.59% 0.86% 1.29% - 0.77% 0.9% 1.01% 0.94%
CAPEX / FCF (%) 1.17% 0.73% 1.22% - 0.73% 0.86% 1.01% 0.97%

Items per share

        
Cash flow per share 1 3.555 5.044 5.867 7.005 7.458 9.376 9.753 9.776
Change - 41.88% 16.32% 19.39% 6.46% 25.73% 4.02% 0.23%
Dividend per Share 1 - - - - - - - -
Change - - - - - - - -
Book Value Per Share 1 7.754 - 12.33 13.5 13.16 16.33 21.11 26.27
Change - - - 9.47% -2.53% 24.09% 29.26% 24.48%
EPS 1 -0.57 2.79 7.24 4.11 4.03 5.298 6.249 7.499
Change - 589.47% 159.5% -43.23% -1.95% 31.45% 17.96% 20%
Nbr of stocks (in thousands) 626,189 633,177 640,926 624,772 606,350 589,586 589,586 589,586
Announcement Date 15/02/22 14/02/23 13/02/24 13/02/25 12/02/26 - - -
1USD
Estimates
2026 *2027 *
P/E 30.3x 25.7x
PBR 9.84x 7.61x
EV / Sales 5.89x 5.09x
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
-
Ratings Surperformance© - Airbnb, Inc.
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
43
Last Close Price
160.63USD
Average target price
183.56USD
Spread / Average Target
+14.28%

Quarterly revenue - Rate of surprise

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