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-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 improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Airbnb Inc. payables turnover ratio decreased from Q2 2023 to Q3 2023 but then slightly increased from Q3 2023 to Q4 2023. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Airbnb Inc. working capital turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| 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. | |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Airbnb Inc. number of days of payables outstanding increased from Q2 2023 to Q3 2023 but then slightly decreased from Q3 2023 to Q4 2023. |
Receivables Turnover
Airbnb Inc., receivables turnover calculation (quarterly data)
| 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,218) | 3,397) | 2,484) | 1,818) | 1,902) | 2,884) | 2,104) | 1,509) | 1,532) | 2,237) | 1,335) | 887) | ||||
| Customer receivables | 249) | 241) | 264) | 227) | 200) | 178) | 205) | 156) | 143) | 149) | 155) | 163) | ||||
| Short-term Activity Ratio | ||||||||||||||||
| Receivables turnover1 | 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.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 | 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. | 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. | 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. | 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-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 Q4 2023 Calculation
Receivables turnover
= (RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023
+ RevenueQ1 2023)
÷ Customer receivables
= (2,218 + 3,397 + 2,484 + 1,818)
÷ 249 = 39.83
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 improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023. |
Payables Turnover
Airbnb Inc., payables turnover calculation (quarterly data)
| 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) | ||||||||||||||||
| Cost of revenue | 384) | 459) | 432) | 428) | 345) | 401) | 390) | 363) | 295) | 312) | 294) | 255) | ||||
| Accounts payable | 141) | 163) | 100) | 161) | 137) | 153) | 139) | 128) | 118) | 97) | 98) | 117) | ||||
| Short-term Activity Ratio | ||||||||||||||||
| Payables turnover1 | 12.08 | 10.21 | 16.06 | 9.72 | 10.94 | 9.49 | 9.76 | 9.86 | 9.77 | — | — | — | ||||
| Benchmarks | ||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||
| Booking Holdings Inc. | 6.14 | 6.83 | 9.11 | 8.52 | 6.82 | 7.52 | 6.54 | 8.32 | 6.91 | 6.29 | 6.98 | 9.91 | ||||
| Carnival Corp. & plc | 12.26 | 13.01 | 13.26 | 12.76 | 11.20 | 10.78 | 8.94 | 7.97 | 5.84 | 5.24 | 6.92 | 10.41 | ||||
| Chipotle Mexican Grill Inc. | 36.86 | 34.04 | 42.59 | 36.87 | 35.61 | 38.60 | 39.82 | 36.05 | 35.79 | 32.44 | 38.26 | 34.83 | ||||
| McDonald’s Corp. | 7.46 | 9.30 | 9.50 | 9.05 | 7.53 | 9.57 | 10.74 | 11.40 | 7.99 | 10.16 | 10.42 | 10.52 | ||||
| Starbucks Corp. | 16.92 | 17.11 | 17.49 | 18.12 | 16.57 | 15.70 | 17.03 | 16.81 | 17.06 | 17.36 | 17.82 | 17.44 | ||||
Based on: 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 Q4 2023 Calculation
Payables turnover
= (Cost of revenueQ4 2023
+ Cost of revenueQ3 2023
+ Cost of revenueQ2 2023
+ Cost of revenueQ1 2023)
÷ Accounts payable
= (384 + 459 + 432 + 428)
÷ 141 = 12.08
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Airbnb Inc. payables turnover ratio decreased from Q2 2023 to Q3 2023 but then slightly increased from Q3 2023 to Q4 2023. |
Working Capital Turnover
Airbnb Inc., working capital turnover calculation (quarterly data)
| 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 | 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 | 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,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,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.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. | 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. | 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-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 Q4 2023 Calculation
Working capital turnover
= (RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023
+ RevenueQ1 2023)
÷ Working capital
= (2,218 + 3,397 + 2,484 + 1,818)
÷ 6,559 = 1.51
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 deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Average Receivable Collection Period
Airbnb Inc., average receivable collection period calculation (quarterly data)
| 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 | 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 | 9 | 9 | 11 | 10 | 9 | 8 | 10 | 9 | 9 | — | — | — | ||||
| Benchmarks (no. days) | ||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||
| Booking Holdings Inc. | 56 | 61 | 53 | 41 | 48 | 52 | 56 | 47 | 45 | 62 | 66 | 38 | ||||
| Carnival Corp. & plc | 9 | 9 | 9 | 13 | 12 | 14 | 22 | 28 | 47 | 156 | 560 | 110 | ||||
| Chipotle Mexican Grill Inc. | 4 | 3 | 2 | 3 | 5 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | ||||
| McDonald’s Corp. | 93 | 87 | 89 | 87 | 88 | 76 | 70 | 62 | 70 | 70 | 72 | 76 | ||||
| Starbucks Corp. | 12 | 12 | 13 | 13 | 13 | 13 | 12 | 12 | 12 | 12 | 13 | 14 | ||||
Based on: 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 Q4 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 39.83 = 9
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. |
Average Payables Payment Period
Airbnb Inc., average payables payment period calculation (quarterly data)
| 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 | ||||||||||||||||
| Payables turnover | 12.08 | 10.21 | 16.06 | 9.72 | 10.94 | 9.49 | 9.76 | 9.86 | 9.77 | — | — | — | ||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||
| Average payables payment period1 | 30 | 36 | 23 | 38 | 33 | 38 | 37 | 37 | 37 | — | — | — | ||||
| Benchmarks (no. days) | ||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||
| Booking Holdings Inc. | 59 | 53 | 40 | 43 | 54 | 49 | 56 | 44 | 53 | 58 | 52 | 37 | ||||
| Carnival Corp. & plc | 30 | 28 | 28 | 29 | 33 | 34 | 41 | 46 | 62 | 70 | 53 | 35 | ||||
| Chipotle Mexican Grill Inc. | 10 | 11 | 9 | 10 | 10 | 9 | 9 | 10 | 10 | 11 | 10 | 10 | ||||
| McDonald’s Corp. | 49 | 39 | 38 | 40 | 48 | 38 | 34 | 32 | 46 | 36 | 35 | 35 | ||||
| Starbucks Corp. | 22 | 21 | 21 | 20 | 22 | 23 | 21 | 22 | 21 | 21 | 20 | 21 | ||||
Based on: 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 Q4 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 12.08 = 30
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Airbnb Inc. number of days of payables outstanding increased from Q2 2023 to Q3 2023 but then slightly decreased from Q3 2023 to Q4 2023. |