Balance Sheet Airbnb, Inc.

Equities

ABNB

US0090661010

Internet Services

Market Closed - Nasdaq Other stock markets 01:30:00 07/09/2024 am IST			5-day change	1st Jan Change
114.28 ^USD	-1.62%		-2.58%	-16.06%

05/09	Cantor Fitzgerald Initiates Airbnb at Underweight With $94 Price Target	MT
04/09	Argus Downgrades Airbnb to Hold From Buy	MT

6a722de09e4732ead5921a3a9f3468.3buJuq7jbRvue0IkOuuCF9N1OjyaB1aWAbhetR_8d80.l4K769SWOlmoIwZWeID4Jqs-VGbdNTTGS8IJ2WzRGqWOg-_r6olVSoM4MQ

Published financial data: AIRBNB, INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	4.81B	3.38B	5.99B	8.4B	9.92B
Total Revenues	4.81B	3.38B	5.99B	8.4B	9.92B
Cost of Goods Sold, Total	1.2B	876M	1.16B	1.5B	1.7B
Gross Profit	3.61B	2.5B	4.84B	6.9B	8.21B
Selling General & Admin Expenses, Total	3.12B	3.16B	2.95B	3.5B	4.97B
R&D Expenses	977M	2.75B	1.43B	1.5B	1.72B
Other Operating Expenses, Total	4.1B	5.91B	4.38B	5.01B	6.7B
Operating Income	-486M	-3.41B	460M	1.89B	1.52B
Interest Expense, Total	-9.97M	-172M	-438M	-24M	-83M
Interest And Investment Income	85.9M	27.12M	12.73M	186M	721M
Net Interest Expenses	75.93M	-145M	-425M	162M	638M
Income (Loss) On Equity Invest.	-	-8.2M	-3.5M	-5.4M	-
Currency Exchange Gains (Loss)	-4.8M	31.5M	-5.1M	29.5M	-48M
Other Non Operating Income (Expenses)	7.98M	-857M	-301M	-58.2M	-
EBT, Excl. Unusual Items	-407M	-4.39B	-274M	2.02B	2.11B
Restructuring Charges	-	-151M	-113M	-89M	-
Merger & Related Restructuring Charges	-15.2M	-	-	-	-
Gain (Loss) On Sale Of Investments	10.72M	-114M	5.17M	59.1M	-6M
Asset Writedown	-	-	-	-2.5M	-
Legal Settlements	-	-	81.7M	-	-
Other Unusual Items	-	-30.9M	-	-	-
EBT, Incl. Unusual Items	-412M	-4.68B	-300M	1.99B	2.1B
Income Tax Expense	263M	-97.22M	51.83M	96M	-2.69B
Earnings From Continuing Operations	-674M	-4.58B	-352M	1.89B	4.79B
Net Income to Company	-674M	-4.58B	-352M	1.89B	4.79B
Net Income - (IS)	-674M	-4.58B	-352M	1.89B	4.79B
Net Income to Common Incl Extra Items	-674M	-4.58B	-352M	1.89B	4.79B
Net Income to Common Excl. Extra Items	-674M	-4.58B	-352M	1.89B	4.79B
Per Share Items
Net EPS - Basic	-2.59	-16.12	-0.57	2.97	7.52
Basic EPS - Continuing Operations	-2.59	-16.12	-0.57	2.97	7.52
Basic Weighted Average Shares Outstanding	261M	284M	616M	637M	637M
Net EPS - Diluted	-2.59	-16.12	-0.57	2.79	7.24
Diluted EPS - Continuing Operations	-2.59	-16.12	-0.57	2.79	7.24
Diluted Weighted Average Shares Outstanding	261M	284M	616M	680M	662M
Normalized Basic EPS	-0.98	-9.64	-0.28	1.98	2.07
Normalized Diluted EPS	-0.98	-9.64	-0.28	1.86	1.99
American Depositary Receipts Ratio (ADR)	0.05	0.05	0.05	0.05	0.05
Supplemental Items
EBITDA	-383M	-3.3B	532M	1.95B	1.55B
EBITA	-440M	-3.37B	484M	1.91B	1.53B
EBIT	-486M	-3.41B	460M	1.89B	1.52B
EBITDAR	-290M	-3.2B	632M	2.05B	1.63B
Effective Tax Rate - (Ratio)	-63.79	2.08	-17.26	4.83	-127.97
Current Domestic Taxes	230M	-92.07M	6.94M	29M	27M
Current Foreign Taxes	38.66M	14.45M	33.95M	68M	158M
Total Current Taxes	268M	-77.62M	40.89M	97M	185M
Deferred Domestic Taxes	-1.81M	102K	98K	-	-2.87B
Deferred Foreign Taxes	-3.82M	-19.7M	10.84M	-1M	-4M
Total Deferred Taxes	-5.63M	-19.6M	10.94M	-1M	-2.88B
Normalized Net Income	-255M	-2.74B	-171M	1.26B	1.32B
Interest on Long-Term Debt	-	157M	209M	4.2M	4M
Supplemental Operating Expense Items
Marketing Expenses	1.14B	479M	723M	1.03B	1.21B
Selling and Marketing Expenses	1.62B	1.14B	1.19B	1.52B	1.76B
General and Administrative Expenses	682M	1.13B	835M	948M	2.02B
Research And Development Expense From Footnotes	977M	2.75B	1.43B	1.5B	1.72B
Net Rental Expense, Total	92.78M	104M	99.55M	100M	80M
Imputed Operating Lease Interest Expense	-	104M	147M	8.07M	22.87M
Imputed Operating Lease Depreciation	-	83.24K	-47.24M	91.93M	57.13M
Stock-Based Comp., R&D Exp. (Total)	56.63M	-	545M	548M	694M
Stock-Based Comp., S&M Exp. (Total)	23.92M	-	99.97M	114M	130M
Stock-Based Comp., G&A Exp. (Total)	16.18M	-	205M	205M	228M
Stock-Based Comp., SG&A Exp. (Total)	817K	-	48.47M	63M	68M
Stock-Based Comp., Other (Total)	-	3B	-17K	-	-
Total Stock-Based Compensation	97.55M	3B	899M	930M	1.12B

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	2.01B	5.48B	6.07B	7.38B	6.87B
Short Term Investments	1.06B	911M	2.26B	2.24B	3.2B
Total Cash And Short Term Investments	3.07B	6.39B	8.32B	9.62B	10.07B
Accounts Receivable, Total	-	-	112M	161M	205M
Total Receivables	-	-	112M	161M	205M
Prepaid Expenses	336M	297M	196M	264M	313M
Restricted Cash	-	33.85M	14.76M	17M	24M
Other Current Assets, Total	3.15B	2.19B	3.74B	4.8B	5.9B
Total Current Assets	6.56B	8.92B	12.39B	14.86B	16.51B
Gross Property Plant And Equipment	866M	922M	808M	571M	389M
Accumulated Depreciation	-179M	-268M	-379M	-312M	-110M
Net Property Plant And Equipment	687M	654M	429M	259M	279M
Long-term Investments	13.03M	89.59M	85.44M	79M	87M
Goodwill	652M	656M	653M	650M	752M
Other Intangibles, Total	103M	75.89M	52.31M	34M	40M
Deferred Tax Assets Long-Term	-	-	-	-	2.88B
Other Long-Term Assets, Total	294M	99.57M	103M	155M	97M
Total Assets	8.31B	10.49B	13.71B	16.04B	20.64B
Liabilities
Accounts Payable, Total	151M	79.9M	118M	137M	141M
Accrued Expenses, Total	802M	957M	1.04B	1B	1.56B
Current Portion of Long-Term Debt	-	26.76M	-	-	-
Current Portion of Leases	38.02M	56.59M	63.48M	59M	61M
Current Income Taxes Payable	15.42M	12M	25.11M	-	-
Unearned Revenue Current, Total	675M	408M	1B	1.32B	1.43B
Other Current Liabilities	3.55B	3.6B	4.11B	5.46B	6.77B
Total Current Liabilities	5.23B	5.14B	6.36B	7.98B	9.95B
Long-Term Debt	-	1.82B	1.98B	1.99B	1.99B
Long-Term Leases	381M	431M	372M	295M	252M
Other Non Current Liabilities	271M	203M	218M	218M	287M
Total Liabilities	5.89B	7.59B	8.93B	10.48B	12.48B
Preferred Stock Convertible	3.23B	-	-	-	-
Total Preferred Equity	3.23B	-	-	-	-
Common Stock, Total	26K	60K	63K	-	-
Additional Paid In Capital	618M	8.9B	11.14B	11.56B	11.64B
Retained Earnings	-1.42B	-6.01B	-6.36B	-5.96B	-3.42B
Comprehensive Income and Other	-4.41M	2.64M	-6.89M	-32M	-49M
Total Common Equity	-808M	2.9B	4.78B	5.56B	8.16B
Total Equity	2.42B	2.9B	4.78B	5.56B	8.16B
Total Liabilities And Equity	8.31B	10.49B	13.71B	16.04B	20.64B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	264M	599M	634M	631M	638M
ECS Total Common Shares Outstanding	264M	599M	634M	631M	638M
Book Value / Share	-3.06	4.84	7.54	8.81	12.8
Tangible Book Value	-1.56B	2.17B	4.07B	4.88B	7.37B
Tangible Book Value Per Share	-5.92	3.62	6.43	7.73	11.56
Total Debt	419M	2.33B	2.42B	2.34B	2.3B
Net Debt	-2.65B	-4.06B	-5.9B	-7.28B	-7.77B
Debt Equivalent Oper. Leases	742M	832M	796M	800M	640M
Equity Method Investments, Total	-	-	-	-	8M
Account Code - Inventory Valuation	3	3	3	3	3
Buildings, Total	16.84M	16.84M	16.84M	17M	-
Machinery, Total	101M	104M	99.68M	55M	47M
Full Time Employees	-	5.6K	6.13K	6.81K	6.91K
Accumulated Allowance for Doubtful Accounts (Supple)	-	-	30.87M	39M	44M

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	-674M	-4.58B	-352M	1.89B	4.79B
Depreciation & Amortization - CF	57.16M	67.18M	48.42M	34.3M	18M
Amortization of Goodwill and Intangible Assets - (CF)	46.1M	36.2M	23.6M	19.1M	13M
Depreciation & Amortization, Total	103M	103M	72.02M	53.4M	31M
Amortization of Deferred Charges, Total - (CF)	10.9M	40.82M	74.74M	27.6M	13M
(Gain) Loss on Sale of Investments - (CF)	-12.76M	114M	-5.17M	-2M	-
Asset Writedown & Restructuring Costs	-	35.77M	113M	91M	-
Stock-Based Compensation (CF)	97.55M	3B	899M	930M	1.12B
Provision and Write-off of Bad Debts	77.05M	108M	27.28M	49M	-
Other Operating Activities, Total	686K	836M	724M	69M	-2.79B
Change In Accounts Payable	75.72M	-73.11M	39.95M	20M	-
Change in Unearned Revenues	176M	-267M	496M	280M	242M
Change in Other Net Operating Assets	368M	55.51M	102M	19M	478M
Cash from Operations	223M	-630M	2.19B	3.43B	3.88B
Capital Expenditure	-125M	-37.37M	-25.32M	-25M	-
Cash Acquisitions	-192M	-	-	-	-
Investment in Marketable and Equity Securities, Total	-63.25M	126M	-1.33B	-1M	-928M
Other Investing Activities, Total	33.66M	-8.6M	500K	-2M	-114M
Cash from Investing	-347M	79.59M	-1.35B	-28M	-1.04B
Long-Term Debt Issued, Total	-	1.93B	1.98B	-	-
Total Debt Issued	-	1.93B	1.98B	-	-
Long-Term Debt Repaid, Total	-	-5M	-2B	-	-
Total Debt Repaid	-	-5M	-2B	-	-
Issuance of Common Stock	5.87M	3.67B	188M	88M	110M
Repurchase of Common Stock	-	-1.65B	-53.96M	-2.11B	-3.48B
Issuance of Preferred Stock	-	-	-	-	-
Other Financing Activities, Total	849M	-999M	1.31B	1.33B	936M
Cash from Financing	855M	2.94B	1.43B	-689M	-2.43B
Foreign Exchange Rate Adjustments	-25.28M	134M	-210M	-337M	152M
Net Change in Cash	705M	2.52B	2.06B	2.38B	564M
Supplemental Items
Cash Interest Paid	5.18M	130M	49.89M	8M	55M
Cash Income Tax Paid (Refund)	28.19M	15.1M	17.29M	68M	132M
Levered Free Cash Flow	294M	1.69B	735M	2.6B	2.83B
Unlevered Free Cash Flow	300M	1.78B	1B	2.62B	2.88B
Change In Net Working Capital	-518M	-823M	299M	-448M	-771M
Net Debt Issued / Repaid	-	1.92B	-15.83M	-	-

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	-4.07	-22.66	2.38	7.96	5.17
Return on Total Capital	-10.94	-52.76	4.63	15.68	10.33
Return On Equity %	-26.25	-172.18	-9.17	36.63	69.83
Return on Common Equity	101.79	-437.87	-9.17	36.63	69.83
Margin Analysis
Gross Profit Margin %	75.1	74.07	80.71	82.15	82.83
SG&A Margin	64.9	93.46	49.24	41.73	50.16
EBITDA Margin %	-7.97	-97.82	8.89	23.18	15.62
EBITA Margin %	-9.16	-99.81	8.08	22.77	15.44
EBIT Margin %	-10.12	-100.88	7.68	22.54	15.31
Income From Continuing Operations Margin %	-14.03	-135.71	-5.88	22.54	48.32
Net Income Margin %	-14.03	-135.71	-5.88	22.54	48.32
Net Avail. For Common Margin %	-14.03	-135.71	-5.88	22.54	48.32
Normalized Net Income Margin	-5.3	-81.15	-2.86	15.04	13.29
Levered Free Cash Flow Margin	6.12	50.15	12.27	30.98	28.56
Unlevered Free Cash Flow Margin	6.25	52.79	16.69	31.16	29.08
Asset Turnover
Asset Turnover	0.64	0.36	0.5	0.56	0.54
Fixed Assets Turnover	9.65	5.04	11.07	24.42	36.87
Receivables Turnover (Average Receivables)	-	-	56.83	61.53	54.19
Short Term Liquidity
Current Ratio	1.25	1.73	1.95	1.86	1.66
Quick Ratio	0.59	1.24	1.33	1.23	1.03
Operating Cash Flow to Current Liabilities	0.04	-0.12	0.34	0.43	0.39
Days Sales Outstanding (Average Receivables)	-	-	6.42	5.93	6.74
Average Days Payable Outstanding	33.87	48.32	31.3	31.05	29.79
Long Term Solvency
Total Debt/Equity	17.3	80.29	50.64	42.1	28.22
Total Debt / Total Capital	14.75	44.53	33.62	29.63	22.01
LT Debt/Equity	15.73	77.42	49.31	41.04	27.47
Long-Term Debt / Total Capital	13.41	42.94	32.73	28.88	21.43
Total Liabilities / Total Assets	70.83	72.34	65.16	65.33	60.45
EBIT / Interest Expense	-48.79	-19.85	1.05	78.9	18.29
EBITDA / Interest Expense	-29.12	-18.64	1.44	85.29	19.63
(EBITDA - Capex) / Interest Expense	-41.71	-18.86	1.39	84.25	19.63
Total Debt / EBITDA	-1.44	-0.73	3.83	1.14	1.41
Net Debt / EBITDA	9.15	1.27	-9.34	-3.56	-4.77
Total Debt / (EBITDA - Capex)	-1.01	-0.72	3.99	1.16	1.41
Net Debt / (EBITDA - Capex)	6.39	1.25	-9.73	-3.6	-4.77
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	31.58	-29.7	77.37	40.17	18.07
Gross Profit, 1 Yr. Growth %	29.45	-30.67	93.27	42.68	19.04
EBITDA, 1 Yr. Growth %	-531.66	762.62	-116.11	217.24	-20.4
EBITA, 1 Yr. Growth %	-1.18K	665.87	-114.36	238.09	-19.93
EBIT, 1 Yr. Growth %	-2.69K	600.72	-113.51	249.35	-19.81
Earnings From Cont. Operations, 1 Yr. Growth %	3.9K	579.88	-92.32	-637.78	153.14
Net Income, 1 Yr. Growth %	3.9K	579.88	-92.32	-637.78	153.14
Normalized Net Income, 1 Yr. Growth %	-965.83	977.07	-93.75	-936.33	1.1
Diluted EPS Before Extra, 1 Yr. Growth %	3.83K	522.96	-96.45	-588.2	159.64
Accounts Receivable, 1 Yr. Growth %	-	-	12.54	43.75	27.33
Net Property, Plant and Equip., 1 Yr. Growth %	121.99	-4.75	-34.49	-39.63	7.72
Total Assets, 1 Yr. Growth %	25.66	26.25	30.66	17	28.73
Tangible Book Value, 1 Yr. Growth %