Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Airbnb Inc., long-term (investment) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-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 deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
| 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) deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Airbnb Inc. total asset turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Airbnb Inc. equity turnover ratio improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
Net Fixed Asset Turnover
Airbnb Inc., net fixed asset turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||
| Revenue | 2,142) | 2,218) | 3,397) | 2,484) | 1,818) | 1,902) | 2,884) | 2,104) | 1,509) | 1,532) | 2,237) | 1,335) | 887) | |||||
| Property and equipment, net | 171) | 160) | 147) | 132) | 122) | 121) | 118) | 118) | 143) | 157) | 174) | 193) | 211) | |||||
| Long-term Activity Ratio | ||||||||||||||||||
| Net fixed asset turnover1 | 59.89 | 61.98 | 65.31 | 68.85 | 71.38 | 69.41 | 67.78 | 62.54 | 46.34 | 38.27 | — | — | — | |||||
| Benchmarks | ||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | 27.33 | 27.25 | 28.14 | 26.42 | 26.00 | 25.55 | 18.23 | 17.07 | 14.82 | 13.33 | 12.09 | 9.60 | 7.70 | |||||
| Carnival Corp. & plc | 0.54 | 0.54 | 0.50 | 0.44 | 0.38 | 0.31 | 0.25 | 0.15 | 0.09 | 0.05 | 0.02 | 0.00 | 0.02 | |||||
| Chipotle Mexican Grill Inc. | 4.63 | 4.55 | 4.56 | 4.59 | 4.53 | 4.43 | 4.50 | 4.49 | 4.40 | 4.27 | 4.18 | 4.11 | 3.91 | |||||
| McDonald’s Corp. | 1.04 | 1.02 | 1.05 | 1.00 | 0.98 | 0.98 | 1.02 | 1.01 | 0.97 | 0.94 | 0.92 | 0.88 | 0.80 | |||||
| Starbucks Corp. | 4.82 | 4.87 | 4.96 | 4.99 | 4.91 | 4.92 | 4.99 | 4.85 | 4.75 | 4.56 | 4.41 | 3.89 | 3.75 | |||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31).
1 Q1 2024 Calculation
Net fixed asset turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Property and equipment, net
= (2,142 + 2,218 + 3,397 + 2,484)
÷ 171 = 59.89
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 deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
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 (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||
| Revenue | 2,142) | 2,218) | 3,397) | 2,484) | 1,818) | 1,902) | 2,884) | 2,104) | 1,509) | 1,532) | 2,237) | 1,335) | 887) | |||||
| Property and equipment, net | 171) | 160) | 147) | 132) | 122) | 121) | 118) | 118) | 143) | 157) | 174) | 193) | 211) | |||||
| Operating lease right-of-use assets | 111) | 119) | 123) | 131) | 138) | 138) | 154) | 165) | 263) | 272) | 280) | 289) | 301) | |||||
| Property and equipment, net (including operating lease, right-of-use asset) | 282) | 279) | 270) | 263) | 260) | 259) | 273) | 283) | 406) | 429) | 454) | 482) | 512) | |||||
| Long-term Activity Ratio | ||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 36.32 | 35.54 | 35.56 | 34.55 | 33.49 | 32.43 | 29.45 | 26.12 | 16.30 | 13.98 | — | — | — | |||||
| Benchmarks | ||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | 14.99 | 14.35 | 14.99 | 14.43 | 13.76 | 13.01 | 12.51 | 11.24 | 9.40 | 8.31 | 7.63 | 5.96 | 4.65 | |||||
| Carnival Corp. & plc | 0.53 | 0.52 | 0.49 | 0.43 | 0.37 | 0.30 | 0.24 | 0.14 | 0.08 | 0.05 | 0.02 | 0.00 | 0.02 | |||||
| Chipotle Mexican Grill Inc. | 1.74 | 1.72 | 1.69 | 1.70 | 1.69 | 1.64 | 1.62 | 1.62 | 1.59 | 1.54 | 1.49 | 1.48 | 1.41 | |||||
| Starbucks Corp. | 2.26 | 2.28 | 2.30 | 2.26 | 2.22 | 2.21 | 2.21 | 2.14 | 2.08 | 1.99 | 1.91 | 1.68 | 1.61 | |||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31).
1 Q1 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Property and equipment, net (including operating lease, right-of-use asset)
= (2,142 + 2,218 + 3,397 + 2,484)
÷ 282 = 36.32
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) deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level. |
Total Asset Turnover
Airbnb Inc., total asset turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||
| Revenue | 2,142) | 2,218) | 3,397) | 2,484) | 1,818) | 1,902) | 2,884) | 2,104) | 1,509) | 1,532) | 2,237) | 1,335) | 887) | |||||
| Total assets | 24,537) | 20,645) | 21,439) | 21,188) | 20,018) | 16,038) | 16,077) | 19,059) | 17,068) | 13,708) | 13,582) | 15,485) | 12,339) | |||||
| Long-term Activity Ratio | ||||||||||||||||||
| Total asset turnover1 | 0.42 | 0.48 | 0.45 | 0.43 | 0.44 | 0.52 | 0.50 | 0.39 | 0.39 | 0.44 | — | — | — | |||||
| Benchmarks | ||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | 0.79 | 0.88 | 0.80 | 0.73 | 0.72 | 0.67 | 0.73 | 0.60 | 0.56 | 0.46 | 0.39 | 0.30 | 0.24 | |||||
| Carnival Corp. & plc | 0.45 | 0.44 | 0.40 | 0.34 | 0.29 | 0.24 | 0.19 | 0.11 | 0.07 | 0.04 | 0.01 | 0.00 | 0.01 | |||||
| Chipotle Mexican Grill Inc. | 1.21 | 1.23 | 1.21 | 1.23 | 1.27 | 1.25 | 1.23 | 1.24 | 1.21 | 1.13 | 1.09 | 1.08 | 1.03 | |||||
| McDonald’s Corp. | 0.48 | 0.45 | 0.48 | 0.48 | 0.45 | 0.46 | 0.48 | 0.48 | 0.47 | 0.43 | 0.43 | 0.42 | 0.38 | |||||
| Starbucks Corp. | 1.26 | 1.22 | 1.22 | 1.19 | 1.16 | 1.15 | 1.14 | 1.08 | 1.05 | 0.93 | 0.92 | 0.84 | 0.77 | |||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31).
1 Q1 2024 Calculation
Total asset turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Total assets
= (2,142 + 2,218 + 3,397 + 2,484)
÷ 24,537 = 0.42
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 Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
Equity Turnover
Airbnb Inc., equity turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||
| Revenue | 2,142) | 2,218) | 3,397) | 2,484) | 1,818) | 1,902) | 2,884) | 2,104) | 1,509) | 1,532) | 2,237) | 1,335) | 887) | |||||
| Stockholders’ equity | 7,896) | 8,165) | 9,123) | 5,059) | 5,291) | 5,560) | 5,540) | 5,245) | 4,737) | 4,776) | 4,449) | 3,393) | 3,159) | |||||
| Long-term Activity Ratio | ||||||||||||||||||
| Equity turnover1 | 1.30 | 1.21 | 1.05 | 1.80 | 1.65 | 1.51 | 1.45 | 1.41 | 1.40 | 1.25 | — | — | — | |||||
| Benchmarks | ||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | — | — | — | — | 16.92 | 6.14 | 4.37 | 3.66 | 2.86 | 1.77 | 1.66 | 1.50 | 1.19 | |||||
| Carnival Corp. & plc | 3.38 | 3.14 | 2.88 | 2.98 | 2.43 | 1.72 | 1.15 | 0.71 | 0.34 | 0.16 | 0.04 | 0.01 | 0.04 | |||||
| Chipotle Mexican Grill Inc. | 3.04 | 3.22 | 3.30 | 3.36 | 3.62 | 3.65 | 3.62 | 3.78 | 3.67 | 3.29 | 3.11 | 3.15 | 3.01 | |||||
| McDonald’s Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||
| Starbucks Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31).
1 Q1 2024 Calculation
Equity turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Stockholders’ equity
= (2,142 + 2,218 + 3,397 + 2,484)
÷ 7,896 = 1.30
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 Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |