Analysis of Short-term (Operating) 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.
Short-term Activity Ratios (Summary)
Airbnb Inc., short-term (operating) 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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Airbnb Inc. receivables turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Airbnb Inc. working capital turnover ratio improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. |
Receivables Turnover
Airbnb Inc., receivables 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) | |||||
| Customer receivables | 212) | 249) | 241) | 264) | 227) | 200) | 178) | 205) | 156) | 143) | 149) | 155) | 163) | |||||
| Short-term Activity Ratio | ||||||||||||||||||
| Receivables turnover1 | 48.31 | 39.83 | 39.84 | 34.42 | 38.36 | 42.00 | 45.08 | 36.09 | 42.42 | 42.04 | — | — | — | |||||
| Benchmarks | ||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | 6.68 | 6.57 | 5.98 | 6.90 | 8.87 | 7.67 | 7.01 | 6.51 | 7.77 | 8.07 | 5.93 | 5.57 | 9.64 | |||||
| Carnival Corp. & plc | 35.04 | 38.84 | 41.31 | 38.95 | 29.14 | 30.81 | 26.71 | 16.31 | 13.13 | 7.76 | 2.34 | 0.65 | 3.33 | |||||
| Chipotle Mexican Grill Inc. | 113.59 | 85.44 | 134.08 | 152.24 | 136.37 | 80.79 | 118.06 | 97.41 | 87.64 | 75.77 | 94.54 | 90.40 | 92.26 | |||||
| McDonald’s Corp. | 4.41 | 3.92 | 4.22 | 4.12 | 4.18 | 4.14 | 4.80 | 5.20 | 5.93 | 5.23 | 5.19 | 5.07 | 4.77 | |||||
| Starbucks Corp. | 31.49 | 30.38 | 30.71 | 28.67 | 28.30 | 27.44 | 27.91 | 31.27 | 29.45 | 30.92 | 29.76 | 27.09 | 26.09 | |||||
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
Receivables turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Customer receivables
= (2,142 + 2,218 + 3,397 + 2,484)
÷ 212 = 48.31
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Airbnb Inc. receivables turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level. |
Working Capital Turnover
Airbnb Inc., working capital 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) | ||||||||||||||||||
| Current assets | 20,393) | 16,509) | 17,523) | 20,052) | 18,869) | 14,861) | 14,867) | 17,826) | 15,761) | 12,386) | 12,221) | 14,096) | 10,927) | |||||
| Less: Current liabilities | 14,139) | 9,950) | 9,821) | 13,624) | 12,212) | 7,978) | 8,015) | 11,287) | 9,774) | 6,359) | 6,559) | 9,496) | 6,573) | |||||
| Working capital | 6,254) | 6,559) | 7,702) | 6,428) | 6,657) | 6,883) | 6,851) | 6,538) | 5,988) | 6,027) | 5,662) | 4,600) | 4,353) | |||||
| 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) | |||||
| Short-term Activity Ratio | ||||||||||||||||||
| Working capital turnover1 | 1.64 | 1.51 | 1.25 | 1.41 | 1.31 | 1.22 | 1.17 | 1.13 | 1.10 | 0.99 | — | — | — | |||||
| Benchmarks | ||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | 6.04 | 5.77 | 3.65 | 2.82 | 2.77 | 2.33 | 4.14 | 3.16 | 2.32 | 1.59 | 1.07 | 1.02 | 0.74 | |||||
| Carnival Corp. & plc | — | — | — | — | — | — | — | — | — | — | — | 0.10 | 0.22 | |||||
| Chipotle Mexican Grill Inc. | 15.74 | 16.73 | 16.40 | 16.17 | 24.45 | 34.00 | 32.42 | 37.95 | 29.78 | 14.86 | 10.78 | 11.18 | 10.14 | |||||
| McDonald’s Corp. | — | 8.64 | 3.33 | 7.11 | 3.99 | 5.39 | 4.03 | 6.64 | 23.54 | 3.13 | 5.58 | 5.19 | 9.32 | |||||
| Starbucks Corp. | — | — | — | — | — | — | — | — | — | 18.11 | 205.59 | 50.26 | 48.92 | |||||
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
Working capital turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Working capital
= (2,142 + 2,218 + 3,397 + 2,484)
÷ 6,254 = 1.64
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Airbnb Inc. working capital turnover ratio improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
Average Receivable Collection Period
Airbnb Inc., average receivable collection period 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 | ||||||||||||||||||
| Receivables turnover | 48.31 | 39.83 | 39.84 | 34.42 | 38.36 | 42.00 | 45.08 | 36.09 | 42.42 | 42.04 | — | — | — | |||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||
| Average receivable collection period1 | 8 | 9 | 9 | 11 | 10 | 9 | 8 | 10 | 9 | 9 | — | — | — | |||||
| Benchmarks (no. days) | ||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||
| Booking Holdings Inc. | 55 | 56 | 61 | 53 | 41 | 48 | 52 | 56 | 47 | 45 | 62 | 66 | 38 | |||||
| Carnival Corp. & plc | 10 | 9 | 9 | 9 | 13 | 12 | 14 | 22 | 28 | 47 | 156 | 560 | 110 | |||||
| Chipotle Mexican Grill Inc. | 3 | 4 | 3 | 2 | 3 | 5 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | |||||
| McDonald’s Corp. | 83 | 93 | 87 | 89 | 87 | 88 | 76 | 70 | 62 | 70 | 70 | 72 | 76 | |||||
| Starbucks Corp. | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 12 | 12 | 12 | 12 | 13 | 14 | |||||
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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 48.31 = 8
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. |