Projected Income Statement: 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 -10,901 -13,364 -16,397
Change - -20.43% -5.83% -6.68% -27.77% 1.03% -22.59% -22.7%
Announcement Date 15/2/22 14/2/23 13/2/24 13/2/25 12/2/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 46.25 59.47 64.02
Change - -1.27% 88% - - 40.14% 28.59% 7.66%
Free Cash Flow (FCF) 1 2,164 3,405 3,837 4,500 4,550 5,329 5,800 6,430
Change - 57.32% 12.69% 17.28% 1.11% 17.12% 8.84% 10.86%
Announcement Date 15/2/22 14/2/23 13/2/24 13/2/25 12/2/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.57% 36.46% 37.58%
EBIT Margin (%) 7.17% 21.45% 15.31% 23% 20.78% 22.35% 23.86% 25.53%
EBT Margin (%) -5.01% 23.68% 21.2% 30% 25.63% 27.03% 27.93% 29.65%
Net margin (%) -5.88% 22.54% 48.32% 23.85% 20.51% 22.43% 22.91% 23.95%
FCF margin (%) 36.12% 40.54% 38.69% 40.53% 37.17% 37.66% 36.83% 36.84%
FCF / Net Income (%) -614.82% 179.87% 80.07% 169.94% 181.2% 167.91% 160.75% 153.83%

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% 33.78% 30.56% 27.8%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 0.42% 0.3% 0.47% - 0.27% 0.33% 0.38% 0.37%
CAPEX / EBITDA (%) 1.59% 0.86% 1.29% - 0.77% 0.92% 1.04% 0.98%
CAPEX / FCF (%) 1.17% 0.73% 1.22% - 0.73% 0.87% 1.03% 1%

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 - - - - - - 0.025 0.05
Change - - - - - - - 100%
Book Value Per Share 1 7.754 - 12.33 13.5 13.16 16.29 20.96 25.77
Change - - - 9.47% -2.53% 23.74% 28.68% 22.99%
EPS 1 -0.57 2.79 7.24 4.11 4.03 5.291 6.186 7.386
Change - 589.47% 159.5% -43.23% -1.95% 31.3% 16.91% 19.4%
Nbr of stocks (in thousands) 626,189 633,177 640,926 624,772 606,350 589,586 589,586 589,586
Announcement Date 15/2/22 14/2/23 13/2/24 13/2/25 12/2/26 - - -
1USD
Estimates
2026 *2027 *
P/E 35.4x 30.3x
PBR 11.5x 8.94x
EV / Sales 7.03x 6.16x
Yield - 0.01%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
45
Last Close Price
187.30USD
Average target price
175.50USD
Spread / Average Target
-6.30%

Quarterly revenue - Rate of surprise