Stock Analysis on Net

Airbnb Inc. (NASDAQ:ABNB)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Airbnb Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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
Turnover Ratios
Receivables turnover 51.62 50.75 48.31 39.83 39.84 34.42 38.36 42.00 45.08 36.09 42.42 42.04
Working capital turnover 1.55 1.64 1.64 1.51 1.25 1.41 1.31 1.22 1.17 1.13 1.10 0.99
Average No. Days
Average receivable collection period 7 7 8 9 9 11 10 9 8 10 9 9

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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 improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Airbnb Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 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)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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 3,732 2,748 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 210 207 212 249 241 264 227 200 178 205 156 143 149 155 163
Short-term Activity Ratio
Receivables turnover1 51.62 50.75 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.32 5.87 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
Chipotle Mexican Grill Inc. 117.86 109.32 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.04 4.10 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.83 32.90 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-09-30), 10-Q (reporting date: 2024-06-30), 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 Q3 2024 Calculation
Receivables turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Customer receivables
= (3,732 + 2,748 + 2,142 + 2,218) ÷ 210 = 51.62

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Working Capital Turnover

Airbnb Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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 18,319 22,252 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 11,336 15,828 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,983 6,424 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 3,732 2,748 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.55 1.64 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. 5.99 7.26 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
Chipotle Mexican Grill Inc. 17.10 14.35 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. 33.38 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-09-30), 10-Q (reporting date: 2024-06-30), 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 Q3 2024 Calculation
Working capital turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Working capital
= (3,732 + 2,748 + 2,142 + 2,218) ÷ 6,983 = 1.55

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Receivable Collection Period

Airbnb Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 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 51.62 50.75 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 7 7 8 9 9 11 10 9 8 10 9 9
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Booking Holdings Inc. 58 62 55 56 61 53 41 48 52 56 47 45 62 66 38
Chipotle Mexican Grill Inc. 3 3 3 4 3 2 3 5 3 4 4 5 4 4 4
McDonald’s Corp. 90 89 83 93 87 89 87 88 76 70 62 70 70 72 76
Starbucks Corp. 11 11 12 12 12 13 13 13 13 12 12 12 12 13 14

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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 Q3 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 51.62 = 7

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.