Financials Airbnb, Inc.

Equities

ABNB

US0090661010

Internet Services

Real-time Estimate Cboe BZX Other stock markets 10:59:19 2024-10-04 am EDT			5-day change	1st Jan Change
128.86 ^USD	+2.85%		+0.16%	-5.64%

Oct. 03	Airbnb Insider Sold Shares Worth $5,402,924, According to a Recent SEC Filing	MT
Oct. 03	Airbnb drives short-term rental boom in tourist haven Rio	RE

Projected Income Statement: Airbnb, Inc.

Fiscal Period: Diciembre	2019	2020	2021	2022	2023	2024	2025	2026
Net sales ¹	4,805	3,378	5,992	8,399	9,917	11,020	12,148	13,392
Change	-	-29.7%	77.37%	40.18%	18.07%	11.12%	10.23%	10.25%
EBITDA ¹	-	-250.7	1,593	2,903	3,653	3,900	4,348	4,936
Change	-	-	-	82.21%	25.82%	6.76%	11.47%	13.54%
EBIT ¹	-	-3,379	429.3	1,802	1,518	2,427	2,784	3,286
Change	-	-	-	319.74%	-15.76%	59.9%	14.68%	18.05%
Interest Paid ¹	-	-171.7	-437.6	-24	-83	-31.21	-20.17	-22.25
Earnings before Tax (EBT) ¹	-	-4,682	-300.2	1,989	2,102	3,212	3,585	4,241
Change	-	-	-93.59%	-	5.68%	52.82%	11.61%	18.28%
Net income ¹	-	-4,585	-352	1,893	4,792	2,661	2,952	3,440
Change	-	-	-92.32%	-	153.14%	-44.47%	10.95%	16.54%
Announcement Date	8/19/20	2/25/21	2/15/22	2/14/23	2/13/24	-	-	-

¹USD in Million

Estimates

Fiscal Period: Diciembre	2020 Q4	2021 Q1	2021 Q2	2021 Q3	2021 Q4	2022 Q1	2022 Q2	2022 Q3	2022 Q4	2023 Q1	2023 Q2	2023 Q3	2023 Q4	2024 Q1	2024 Q2	2024 Q3	2024 Q4	2025 Q1	2025 Q2	2025 Q3	2025 Q4	2026 Q1	2026 Q2
Net sales ¹	859.3	886.9	1,335	2,237	1,532	1,509	2,104	2,884	1,902	1,818	2,484	3,397	2,218	2,142	2,748	3,710	2,422	2,345	3,047	4,090	2,687	2,610	3,348
Change	-	3.22%	50.54%	67.57%	-31.52%	-1.52%	39.44%	37.08%	-34.06%	-4.42%	36.63%	36.76%	-34.71%	-3.43%	28.29%	35.02%	-34.72%	-3.19%	29.95%	34.23%	-34.3%	-2.86%	28.28%
EBITDA ¹	-20.52	-58.64	217.4	1,101	333.4	229.1	711.2	1,457	506	262	819	1,834	738	424	894	1,854	720.8	442.3	1,004	2,071	833.4	532.9	1,093
Change	-	185.77%	-	406.58%	-69.73%	-31.28%	210.43%	104.87%	-65.27%	-48.22%	212.6%	123.93%	-59.76%	-42.55%	110.85%	107.38%	-61.12%	-38.64%	127%	106.26%	-59.75%	-36.06%	105.01%
EBIT ¹	-2,944	-446.9	-51.28	852	75.57	-5.131	368.8	1,203	235	-5	523	1,496	-496	101	497	1,479	351.8	86.36	590.4	1,686	455.8	195.6	701.3
Change	-	-84.82%	-88.53%	-	-91.13%	-	-	226.3%	-80.47%	-	-	186.04%	-	-	392.08%	197.63%	-76.22%	-75.45%	583.65%	185.56%	-72.97%	-57.08%	258.54%
Charge d'intérêts ¹	-64.14	-421.9	-6.52	-6.649	-2.519	-5.764	-7.483	-5.682	-5	-4	-2	-6	-71	-10	-42	-6.043	-6.043	-4	-4	-4	-4	-	-
Earnings before Tax (EBT) ¹	-3,993	-1,166	-56.98	850.5	72.22	-8.086	383.1	1,270	344	130	676	1,679	-383	293	681	1,677	557.5	277.9	786.7	1,887	674.3	520.6	1,036
Change	-	-70.8%	-95.11%	-	-91.51%	-	-	231.47%	-72.91%	-62.21%	420%	148.37%	-	-	132.42%	146.32%	-66.77%	-50.16%	183.13%	139.8%	-64.26%	-22.79%	98.91%
Net income ¹	-3,888	-1,172	-68.22	833.9	54.5	-18.79	378.8	1,214	319	117	650	4,374	-349	264	555	1,392	459.4	227.9	655.8	1,576	560.1	426.9	849.1
Change	-	-69.85%	-94.18%	-	-93.46%	-	-	220.53%	-73.73%	-63.32%	455.56%	572.92%	-	-	110.23%	150.73%	-66.99%	-50.39%	187.78%	140.31%	-64.46%	-23.78%	98.9%
Announcement Date	2/25/21	5/13/21	8/12/21	11/4/21	2/15/22	5/3/22	8/2/22	11/1/22	2/14/23	5/9/23	8/3/23	11/1/23	2/13/24	5/8/24	8/6/24	-	-	-	-	-	-	-	-

¹USD in Million

Estimates

Forecast Balance Sheet: Airbnb, Inc.

Fiscal Period: Diciembre	2019	2020	2021	2022	2023	2024	2025	2026
Net Debt ¹	-	-4,576	-6,340	-7,635	-8,080	-8,873	-10,823	-14,609
Change	-	-	-238.55%	-220.43%	-205.83%	-209.81%	-221.98%	-234.98%
Announcement Date	8/19/20	2/25/21	2/15/22	2/14/23	2/13/24	-	-	-

¹USD in Million

Estimates

Cash Flow Forecast: Airbnb, Inc.

Fiscal Period: Diciembre	2020	2021	2022	2023	2024	2025	2026
CAPEX ¹	37.37	25.32	25	47	45.86	55.74	64.81
Change	-	-32.24%	-1.27%	88%	-2.42%	21.55%	16.27%
Free Cash Flow (FCF) ¹	-667.1	2,164	3,405	3,837	4,445	4,432	4,813
Change	-	-424.44%	57.32%	12.69%	15.83%	-0.28%	8.6%
Announcement Date	2/25/21	2/15/22	2/14/23	2/13/24	-	-	-

¹USD in Million

Estimates

Forecast Financial Ratios: Airbnb, Inc.

Fiscal Period: Diciembre	2019	2020	2021	2022	2023	2024	2025	2026
Profitability
EBITDA Margin (%)	-	-7.42%	26.59%	34.57%	36.84%	35.39%	35.79%	36.86%
EBIT Margin (%)	-	-100.01%	7.17%	21.45%	15.31%	22.03%	22.91%	24.54%
EBT Margin (%)	-	-138.59%	-5.01%	23.68%	21.2%	29.15%	29.51%	31.66%
Net margin (%)	-	-135.71%	-5.88%	22.54%	48.32%	24.15%	24.3%	25.69%
FCF margin (%)	-	-19.75%	36.12%	40.54%	38.69%	40.33%	36.48%	35.94%
FCF / Net Income (%)	-	14.55%	-614.82%	179.87%	80.07%	167.04%	150.13%	139.9%
Profitability
ROA	-	-48.77%	-2.91%	12.73%	26.13%	13.48%	13.53%	16.13%
ROE	-	-437.87%	-9.17%	36.63%	69.83%	28.27%	26.34%	24.39%
Financial Health
Leverage (Debt/EBITDA)	-	-	-	-	-	-	-	-
Debt / Free cash flow	-	-	-	-	-	-	-	-
Capital Intensity
CAPEX / Current Assets (%)	-	1.11%	0.42%	0.3%	0.47%	0.42%	0.46%	0.48%
CAPEX / EBITDA (%)	-	-14.91%	1.59%	0.86%	1.29%	1.18%	1.28%	1.31%
CAPEX / FCF (%)	-	-5.6%	1.17%	0.73%	1.22%	1.03%	1.26%	1.35%
Items per share
Cash flow per share ¹	-	-2.214	3.555	5.044	5.867	5.477	6.645	6.346
Change	-	-	-260.55%	41.88%	16.32%	-6.65%	21.32%	-4.49%
Dividend per Share ¹	-	-	-	-	-	-	-	-
Change	-	-	-	-	-	-	-	-
Book Value Per Share ¹	-	4.843	7.754	-	12.33	15.06	18.89	24.34
Change	-	-	60.12%	-	-	22.14%	25.37%	28.87%
EPS ¹	-5.18	-16.12	-0.57	2.79	7.24	4.116	4.602	5.43
Change	-	211.2%	-96.46%	-589.47%	159.5%	-43.15%	11.81%	18%
Nbr of stocks (in thousands)	-	593,248	626,189	633,177	640,926	632,423	632,423	632,423
Announcement Date	8/19/20	2/25/21	2/15/22	2/14/23	2/13/24	-	-	-