Stock Analysis on Net

Airbnb Inc. (NASDAQ:ABNB)

Analysis of Long-term (Investment) Activity Ratios

Microsoft Excel

Long-term Activity Ratios (Summary)

Airbnb Inc., long-term (investment) activity ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Net fixed asset turnover 61.98 69.41 38.27 12.50
Net fixed asset turnover (including operating lease, right-of-use asset) 35.54 32.43 13.98 5.16
Total asset turnover 0.48 0.52 0.44 0.32
Equity turnover 1.21 1.51 1.25 1.16

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Airbnb Inc. net fixed asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Airbnb Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2021 to 2022 and from 2022 to 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Airbnb Inc. total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Airbnb Inc. equity turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Net Fixed Asset Turnover

Airbnb Inc., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 9,917 8,399 5,992 3,378
Property and equipment, net 160 121 157 270
Long-term Activity Ratio
Net fixed asset turnover1 61.98 69.41 38.27 12.50
Benchmarks
Net Fixed Asset Turnover, Competitors2
Booking Holdings Inc. 27.25 25.55 13.33 8.99
Carnival Corp. & plc 0.54 0.31 0.05 0.15
Chipotle Mexican Grill Inc. 4.55 4.43 4.27 3.78
McDonald’s Corp. 0.95 0.92 0.94 0.77
Starbucks Corp. 4.87 4.92 4.56 3.77
Net Fixed Asset Turnover, Sector
Consumer Services 1.61 1.39 1.09 0.90
Net Fixed Asset Turnover, Industry
Consumer Discretionary 3.24 3.18 2.98 2.99

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2023 Calculation
Net fixed asset turnover = Revenue ÷ Property and equipment, net
= 9,917 ÷ 160 = 61.98

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Airbnb Inc. net fixed asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Airbnb Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 9,917 8,399 5,992 3,378
 
Property and equipment, net 160 121 157 270
Operating lease right-of-use assets 119 138 272 384
Property and equipment, net (including operating lease, right-of-use asset) 279 259 429 654
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 35.54 32.43 13.98 5.16
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Booking Holdings Inc. 14.35 13.01 8.31 5.29
Carnival Corp. & plc 0.52 0.30 0.05 0.14
Chipotle Mexican Grill Inc. 1.72 1.64 1.54 1.38
McDonald’s Corp. 0.66 0.64 0.61 0.50
Starbucks Corp. 2.28 2.21 1.99 1.64
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Consumer Services 1.20 1.04 0.80 0.65
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Consumer Discretionary 2.53 2.48 2.32 2.34

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2023 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Revenue ÷ Property and equipment, net (including operating lease, right-of-use asset)
= 9,917 ÷ 279 = 35.54

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Airbnb Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2021 to 2022 and from 2022 to 2023.

Total Asset Turnover

Airbnb Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 9,917 8,399 5,992 3,378
Total assets 20,645 16,038 13,708 10,491
Long-term Activity Ratio
Total asset turnover1 0.48 0.52 0.44 0.32
Benchmarks
Total Asset Turnover, Competitors2
Booking Holdings Inc. 0.88 0.67 0.46 0.31
Carnival Corp. & plc 0.44 0.24 0.04 0.10
Chipotle Mexican Grill Inc. 1.23 1.25 1.13 1.00
McDonald’s Corp. 0.45 0.46 0.43 0.36
Starbucks Corp. 1.22 1.15 0.93 0.80
Total Asset Turnover, Sector
Consumer Services 0.66 0.57 0.43 0.37
Total Asset Turnover, Industry
Consumer Discretionary 0.95 0.93 0.84 0.81

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2023 Calculation
Total asset turnover = Revenue ÷ Total assets
= 9,917 ÷ 20,645 = 0.48

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Airbnb Inc. total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Equity Turnover

Airbnb Inc., equity turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 9,917 8,399 5,992 3,378
Stockholders’ equity 8,165 5,560 4,776 2,902
Long-term Activity Ratio
Equity turnover1 1.21 1.51 1.25 1.16
Benchmarks
Equity Turnover, Competitors2
Booking Holdings Inc. 6.14 1.77 1.39
Carnival Corp. & plc 3.14 1.72 0.16 0.27
Chipotle Mexican Grill Inc. 3.22 3.65 3.29 2.96
McDonald’s Corp.
Starbucks Corp.
Equity Turnover, Sector
Consumer Services 46.63 33.19 5.09 4.37
Equity Turnover, Industry
Consumer Discretionary 3.85 4.15 3.60 4.40

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2023 Calculation
Equity turnover = Revenue ÷ Stockholders’ equity
= 9,917 ÷ 8,165 = 1.21

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Airbnb Inc. equity turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.