Stock Analysis on Net

Airbnb Inc. (NASDAQ:ABNB)

Analysis of Short-term (Operating) Activity Ratios 

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Turnover Ratios
Receivables turnover 75.52 48.38 52.17 53.67 34.05
Payables turnover 13.23 12.08 10.94 9.77 10.96
Working capital turnover 1.58 1.51 1.22 0.99 0.89
Average No. Days
Average receivable collection period 5 8 7 7 11
Average payables payment period 28 30 33 37 33

Based on: 10-K (reporting date: 2024-12-31), 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).

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 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Airbnb Inc. payables turnover ratio increased from 2022 to 2023 and from 2023 to 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Airbnb Inc. working capital turnover ratio improved from 2022 to 2023 and from 2023 to 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. Airbnb Inc. number of days of receivables outstanding deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
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 decreased from 2022 to 2023 and from 2023 to 2024.

Receivables Turnover

Airbnb Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 11,102 9,917 8,399 5,992 3,378
Customer receivables, net of reserve 147 205 161 112 99
Short-term Activity Ratio
Receivables turnover1 75.52 48.38 52.17 53.67 34.05
Benchmarks
Receivables Turnover, Competitors2
Booking Holdings Inc. 7.42 6.57 7.67 8.07 12.85
Chipotle Mexican Grill Inc. 78.59 85.44 80.79 75.77 57.27
McDonald’s Corp. 4.10 3.92 4.14 5.23 3.86
Starbucks Corp. 29.80 30.38 27.44 30.92 26.62
Receivables Turnover, Sector
Consumer Services 13.00 11.99 12.98 14.46 12.83
Receivables Turnover, Industry
Consumer Discretionary 18.67 17.85 17.96 21.22 21.85

Based on: 10-K (reporting date: 2024-12-31), 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 2024 Calculation
Receivables turnover = Revenue ÷ Customer receivables, net of reserve
= 11,102 ÷ 147 = 75.52

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 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Payables Turnover

Airbnb Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of revenue 1,878 1,703 1,499 1,156 876
Accounts payable 142 141 137 118 80
Short-term Activity Ratio
Payables turnover1 13.23 12.08 10.94 9.77 10.96
Benchmarks
Payables Turnover, Competitors2
Booking Holdings Inc. 6.21 6.14 6.82 6.91 9.25
Chipotle Mexican Grill Inc. 39.38 36.86 35.61 35.79 40.52
McDonald’s Corp. 8.10 7.46 7.53 7.99 9.42
Starbucks Corp. 16.59 16.92 16.57 17.06 18.50
Payables Turnover, Sector
Consumer Services 10.10 10.01 10.75 11.42 14.22
Payables Turnover, Industry
Consumer Discretionary 5.36 5.18 4.80 4.66 4.74

Based on: 10-K (reporting date: 2024-12-31), 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 2024 Calculation
Payables turnover = Cost of revenue ÷ Accounts payable
= 1,878 ÷ 142 = 13.23

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 increased from 2022 to 2023 and from 2023 to 2024.

Working Capital Turnover

Airbnb Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Current assets 17,180 16,509 14,861 12,386 8,916
Less: Current liabilities 10,161 9,950 7,978 6,359 5,140
Working capital 7,019 6,559 6,883 6,027 3,777
 
Revenue 11,102 9,917 8,399 5,992 3,378
Short-term Activity Ratio
Working capital turnover1 1.58 1.51 1.22 0.99 0.89
Benchmarks
Working Capital Turnover, Competitors2
Booking Holdings Inc. 4.90 5.77 2.33 1.59 0.77
Chipotle Mexican Grill Inc. 18.49 16.73 34.00 14.86 10.01
McDonald’s Corp. 13.25 8.64 5.39 3.13 131.28
Starbucks Corp. 18.11 51.17
Working Capital Turnover, Sector
Consumer Services 8.38 8.74 5.39 3.49 3.50
Working Capital Turnover, Industry
Consumer Discretionary 13.56 14.99 18.57 11.02 13.68

Based on: 10-K (reporting date: 2024-12-31), 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 2024 Calculation
Working capital turnover = Revenue ÷ Working capital
= 11,102 ÷ 7,019 = 1.58

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 2022 to 2023 and from 2023 to 2024.

Average Receivable Collection Period

Airbnb Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Receivables turnover 75.52 48.38 52.17 53.67 34.05
Short-term Activity Ratio (no. days)
Average receivable collection period1 5 8 7 7 11
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Booking Holdings Inc. 49 56 48 45 28
Chipotle Mexican Grill Inc. 5 4 5 5 6
McDonald’s Corp. 89 93 88 70 95
Starbucks Corp. 12 12 13 12 14
Average Receivable Collection Period, Sector
Consumer Services 28 30 28 25 28
Average Receivable Collection Period, Industry
Consumer Discretionary 20 20 20 17 17

Based on: 10-K (reporting date: 2024-12-31), 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 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 75.52 = 5

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. Airbnb Inc. number of days of receivables outstanding deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Average Payables Payment Period

Airbnb Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Payables turnover 13.23 12.08 10.94 9.77 10.96
Short-term Activity Ratio (no. days)
Average payables payment period1 28 30 33 37 33
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Booking Holdings Inc. 59 59 54 53 39
Chipotle Mexican Grill Inc. 9 10 10 10 9
McDonald’s Corp. 45 49 48 46 39
Starbucks Corp. 22 22 22 21 20
Average Payables Payment Period, Sector
Consumer Services 36 36 34 32 26
Average Payables Payment Period, Industry
Consumer Discretionary 68 70 76 78 77

Based on: 10-K (reporting date: 2024-12-31), 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 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 13.23 = 28

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 decreased from 2022 to 2023 and from 2023 to 2024.