Airbnb, Inc. Financial Ratios — ABNB Stock

Profitability (USD)

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Return on Common Equity (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Assets (%)	- -	-0.51	-9.04	-48.77	-2.91	12.73	26.13	12.73	11.63
Return on Capital (%)	- -	6.82	- -	- -	- -	-50.66	- -	-161.07	-89.65
Return on Invested Capital (%)	- -	- -	- -	- -	- -	21.98	- -	17.62	17.82
Gross Margin (%)	74.72	76.34	75.1	74.07	80.71	82.15	82.83	83.08	82.96
EBITDA Margin (%)	-0.08	2.77	-8.06	-98.07	11.35	23.48	15.75	23.58	20.78
Operating Margin (%)	-3.18	0.51	-10.44	-101.79	9.05	22.51	15.31	23	20.78
Incremental Operating Margin (%)	- -	9.18	- -	- -	152.3	56.04	-24.57	87.34	-0.79
Pretax Margin (%)	-2.31	1.29	-8.57	-138.59	-5.01	23.68	21.2	30	25.63
Profit Margin (%)	-2.73	-0.46	-14.03	-135.71	-5.87	22.54	48.32	23.85	20.51
Net Income to Common Margin (%)	-2.73	-0.46	-14.03	-135.71	-5.87	22.54	48.32	23.85	20.51
Effective Tax Rate (%)	- -	135.85	- -	- -	- -	4.83	- -	20.5	19.96
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -

Credit (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Total Debt	- -	- -	419	2,330	2,418	2,341	2,304	2,058	2,067
ST Debt	- -	- -	38	83	63	59	61	63	2,067
LT Debt	- -	- -	381	2,246	2,355	2,282	2,243	1,995	- -
Total Debt/EBITDA	- -	- -	-1.08	-0.7	3.56	1.19	1.48	0.79	0.81
Net Debt/EBITDA	- -	-21.17	5.2	1.1	-6.01	-2.73	-3.13	-1.86	-1.79
Total Debt/EBIT	- -	- -	-0.84	-0.68	4.46	1.24	1.52	0.81	0.81
Net Debt/EBIT	- -	-114.22	4.01	1.06	-7.54	-2.85	-3.22	-1.91	-1.79
EBITDA to Interest Expense	-0.12	3.87	-38.86	-19.3	1.55	82.17	18.82	- -	- -
EBITDA-CapEx/Interest Expense	-6.23	0.4	-51.45	-19.51	1.49	81.12	18.82	- -	- -
EBIT to Interest Expense	-4.96	0.72	-50.32	-20.03	1.24	78.79	18.29	- -	- -
Interest Expense	16	26	10	172	438	24	83	- -	- -
Common Equity/Total Assets	- -	-11.63	-17.1	-57.24	-46.38	-37.19	-16.59	-20.16	-24.77
Long-Term Debt/Equity (%)	- -	- -	- -	77.42	49.32	41.04	27.47	23.72	- -
Long-Term Debt/Capital (%)	- -	- -	-38.08	-61.11	-59.77	-62.97	-200.09	-92.06	- -
Long-Term Debt/Total Assets (%)	- -	- -	4.59	21.41	17.18	14.23	10.86	9.52	- -
Total Debt/Equity (%)	- -	- -	-51.93	80.29	50.64	42.1	28.22	24.47	25.21
Total Debt/Capital (%)	- -	- -	-41.87	-63.38	-61.37	-64.6	-205.53	-94.97	-60.17
Total Debt/Total Assets (%)	- -	- -	5.05	22.21	17.64	14.6	11.16	9.82	9.31
Net Debt to Equity	- -	413.85	249.3	-125.38	-85.53	-96.96	-59.8	-57.88	-55.63
Net Debt/Capital (%)	- -	73.58	66.78	39.73	40.81	49	61.08	53.91	45.63
EBITDA	-2	101	-387	-3,313	680	1,972	1,562	2,618	2,544
EBITDA-CapEx	-102	11	-513	-3,350	655	1,947	1,562	2,618	2,544
Operating Income (Loss)	-81	19	-502	-3,439	542	1,891	1,518	2,553	2,544

Liquidity (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Cash Ratio	- -	0.89	0.59	1.24	1.31	1.21	1.01	1.04	0.81
Current Ratio	- -	1.57	1.25	1.73	1.95	1.86	1.66	1.69	1.38
Quick Ratio	- -	1.51	1.19	1.67	1.89	1.83	1.62	1.64	1.33
CFO/Avg Current Liab	- -	0.32	0.05	-0.12	0.4	0.48	0.43	0.45	0.39
Common Equity/Total Assets	- -	-11.63	-17.1	-57.24	-46.38	-37.19	-16.59	-20.16	-24.77
Long-Term Debt/Equity (%)	- -	- -	- -	77.42	49.32	41.04	27.47	23.72	- -
Long-Term Debt/Capital (%)	- -	- -	-38.08	-61.11	-59.77	-62.97	-200.09	-92.06	- -
Long-Term Debt/Total Assets (%)	- -	- -	4.59	21.41	17.18	14.23	10.86	9.52	- -
Total Debt/Equity (%)	- -	- -	-51.93	80.29	50.64	42.1	28.22	24.47	25.21
Total Debt/Capital (%)	- -	- -	-41.87	-63.38	-61.37	-64.6	-205.53	-94.97	-60.17
Total Debt/Total Assets (%)	- -	- -	5.05	22.21	17.64	14.6	11.16	9.82	9.31
CFO/Total Liabilities	- -	8.35	2.44	-8.3	25.89	32.74	31.12	36.01	33.16
CFO/CapEx	2.51	6.57	1.78	-16.85	91.34	137.2	- -	- -	- -
Altman's Z-Score	- -	0.83	0.36	2.09	7.36	4.07	5.08	5.06	4.45

Working Capital (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Accounts Receivable Turnover	- -	- -	- -	- -	- -	83.99	48.97	63.08	73.52
Days Sales Outstanding	- -	- -	- -	- -	- -	4.35	7.45	5.79	4.96
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	24.47	10.78	7.57	11.68	11.76	12.25	13.27	11.16
Accounts Payable Turnover Days	- -	14.92	33.87	48.19	31.24	31.05	29.79	27.5	32.72
Cash Conversion Cycle	- -	-14.92	-33.87	-48.19	-31.24	-26.7	-22.34	-21.71	-27.76
Inventory to Cash Days	- -	- -	- -	- -	- -	4.35	7.45	5.79	4.96
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Market Capitalization	- -	- -	- -	41,744	102,540	54,464	86,721	83,051	83,196
- Cash & Cash Equivalents	- -	2,141	2,014	5,481	6,067	7,378	6,874	6,864	6,560
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	419	2,330	2,418	2,341	2,304	2,058	2,067
Enterprise Value	- -	-3,329	-2,655	37,683	96,636	47,182	78,954	74,498	74,249
Total Capital	- -	-769	-1,002	-3,676	-3,940	-3,624	-1,121	-2,167	-3,435
Total Debt/Capital (%)	- -	- -	-41.87	-63.38	-61.37	-64.6	-205.53	-94.97	-60.17
Total Debt / EV	- -	- -	-0.16	0.06	0.03	0.05	0.03	0.03	0.03
EV/Sales	- -	- -	- -	11.15	16.13	5.62	7.96	6.71	6.07
EV/EBITDA	- -	- -	- -	- -	142.11	23.93	50.55	28.46	29.19
EV/EBIT	- -	- -	- -	- -	178.29	24.95	52.01	29.18	29.19
EV/Cash Flow to Firm	- -	- -	- -	- -	34.18	13.66	19.38	16.49	15.98
EV/Free Cash Flow to Firm	- -	- -	- -	- -	33.88	13.57	19.38	16.49	15.98
Diluted Market Cap	- -	- -	- -	41,744	102,540	58,140	90,125	84,759	84,554
Diluted Enterprise Value	- -	-2,141	-1,594	38,594	98,891	53,103	85,555	79,953	80,061
EV per Share	- -	- -	- -	132.52	156.9	74.07	123.95	117.88	121.12
TTM Sales	2,562	3,652	4,805	3,378	5,992	8,399	9,917	11,102	12,241
TTM EBITDA	-2	101	-387	-3,313	680	1,972	1,562	2,618	2,544
TTM Operating Income	-81	19	-502	-3,439	542	1,891	1,518	2,553	2,544
TTM Cash Flow to Firm	271	586	239	-462	2,827	3,453	4,073	4,518	4,646
TTM Free Cash Flow to Firm	371	677	365	-424	2,852	3,478	4,073	4,518	4,646

Multiples (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Price/Free Cash Flow	- -	- -	- -	-70.47	43.85	16.83	23.2	18.76	18.2
EV/EBIT	- -	- -	- -	- -	178.29	24.95	52.01	29.18	29.19
Enterprise Value	- -	-3,329	-2,655	37,683	96,636	47,182	78,954	74,498	74,249
Low Price	- -	- -	- -	121.5	129.71	81.91	84.3	110.38	99.88
EV/Sales	- -	- -	- -	11.15	16.13	5.62	7.96	6.71	6.07
EV/EBITDA	- -	- -	- -	- -	142.11	23.93	50.55	28.46	29.19
Price/Earnings	- -	- -	- -	- -	- -	28.77	18.1	31.36	33.13
Price/Earnings Average	- -	- -	- -	-9.16	-293.23	42.1	16.56	33.89	31.39
Price/Earnings High	- -	- -	- -	-10.85	-384.83	64.52	20.6	40.6	40.02
Price/Earnings Low	- -	- -	- -	-7.54	-226.95	27.56	11.21	26.34	24.38
Price/Book Value	- -	- -	- -	-6.95	-16.13	-9.13	-25.32	-19.66	-15.12
Price/Book Value Average	- -	- -	- -	-6.99	-16.23	-13.36	-23.18	-21.24	-14.32
Price/Book Value High	- -	- -	- -	-8.28	-21.31	-20.47	-28.82	-25.44	-18.26
Price/Book Value Low	- -	- -	- -	-5.75	-12.56	-8.75	-15.68	-16.51	-11.13
Price/Tangible Book Value	- -	- -	- -	19.24	25.19	11.17	11.76	10.88	11.2
Price/Tangible Book Value Average	- -	- -	- -	19.34	25.36	16.34	10.77	11.75	10.61
Price/Tangible Book Value High	- -	- -	- -	22.93	33.28	25.05	13.39	14.08	13.53
Price/Tangible Book Value Low	- -	- -	- -	15.92	19.63	10.7	7.28	9.14	8.24
Price/Sales	- -	- -	- -	12.36	17.11	6.48	8.74	7.48	6.8
Price/Sales Average	- -	- -	- -	12.43	17.23	9.49	8	8.08	6.44
Price/Sales High	- -	- -	- -	14.73	22.61	14.54	9.95	9.68	8.21
Price/Sales Low	- -	- -	- -	10.23	13.33	6.21	5.41	6.28	5
Price/Cash Flow	- -	- -	- -	-66.29	44.33	15.88	22.33	18.38	17.91
Price/Cash Flow Average	- -	- -	- -	-66.66	44.62	23.23	20.44	19.86	16.96
Price/Cash Flow High	- -	- -	- -	-79.01	58.56	35.61	25.41	23.79	21.63
Price/Cash Flow Low	- -	- -	- -	-54.86	34.54	15.21	13.83	15.44	13.18
Price/Free Cash Flow Average	- -	- -	- -	-70.87	44.14	24.62	21.24	20.27	17.24
Price/Free Cash Flow High	- -	- -	- -	-83.99	57.93	37.74	26.41	24.28	21.98
Price/Free Cash Flow Low	- -	- -	- -	-58.33	34.16	16.12	14.37	15.76	13.39
EV/Sales Average	- -	- -	- -	11.49	16.62	8.89	7.54	7.65	6.07
EV/Sales High	- -	- -	- -	13.8	22	13.94	9.49	9.25	7.84
EV/Sales Low	- -	- -	- -	9.29	12.72	5.61	4.95	5.85	4.63
EV/EBITDA Average	- -	-21.17	4.12	-11.72	146.42	37.86	47.89	32.44	29.21
EV/EBITDA High	- -	-21.17	4.12	-14.07	193.84	59.38	60.26	39.23	37.73
EV/EBITDA Low	- -	-21.17	4.12	-9.48	112.12	23.9	31.45	24.81	22.3
EV/EBIT Average	- -	-114.22	3.18	-11.29	183.7	39.48	49.28	33.27	29.21
EV/EBIT High	- -	-114.22	3.18	-13.55	243.19	61.92	62.01	40.23	37.73
EV/EBIT Low	- -	-114.22	3.18	-9.13	140.66	24.93	32.36	25.44	22.3
Last Price	- -	- -	- -	146.8	166.49	85.5	136.14	131.41	135.72
High Price	- -	- -	- -	174.97	219.94	191.73	154.95	170.1	163.93
Enterprise Value Average	- -	-2,141	-1,594	38,829	99,568	74,651	74,807	84,931	74,317
Enterprise Value High	- -	-2,141	-1,594	46,604	131,810	117,095	94,133	102,697	95,996
Enterprise Value Low	- -	-2,141	-1,594	31,399	76,238	47,140	49,129	64,954	56,733

Shares Outstanding	- -	587	587	599	634	631	638	623	602
Diluted Weighted Avg Shares	522	531	531	284	616	680	662	645	623
Basic Weighted Avg Shares	522	531	531	284	616	637	637	632	613
Revenue per Share	4.91	6.88	9.05	11.88	9.73	13.19	15.57	17.57	19.97
EBITDA per Share	- -	0.19	-0.73	-11.65	1.1	3.1	2.45	4.14	4.15
Operating Income per Share	-0.16	0.04	-0.94	-12.09	0.88	2.97	2.38	4.04	4.15
Basic EPS, GAAP	-0.13	-0.03	-1.27	-16.12	-0.57	2.97	7.52	4.19	4.1
Basic EPS from Cont Ops	-0.13	-0.03	-1.27	-16.12	-0.57	2.97	7.52	4.19	4.1
Diluted EPS, GAAP	-0.13	-0.03	-1.27	-16.12	-0.57	2.78	7.24	4.11	4.03
Diluted EPS from Cont Ops	-0.13	-0.03	-1.27	-16.12	-0.57	2.78	7.24	4.11	4.03
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	0.48	1.12	0.42	-2.21	3.76	5.38	6.1	7.15	7.58
Free Cash Flow per Basic Share	0.29	0.95	0.18	-2.35	3.71	5.35	6.1	7.15	7.58
Cash & Equivalents per Share	- -	6.27	5.79	22.48	13.51	15.11	15.81	16.79	17.97
Book Value per Share	- -	-1.45	-2.68	-21.12	-10.32	-9.36	-5.38	-6.69	-8.98
Tangible Book Value per Share	- -	-1.57	-2.94	7.63	6.61	7.65	11.57	12.08	12.12

Airbnb, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)