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)
Expedia Group Inc., short-term (operating) activity ratios (quarterly data)
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Expedia Group Inc. receivables turnover ratio improved from Q3 2021 to Q4 2021 but then slightly deteriorated from Q4 2021 to Q1 2022 not reaching Q3 2021 level. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Expedia Group Inc. payables turnover ratio increased from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
| 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. | Expedia Group Inc. number of days of receivables outstanding improved from Q3 2021 to Q4 2021 but then slightly deteriorated from Q4 2021 to Q1 2022 not reaching Q3 2021 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. | Expedia Group Inc. number of days of payables outstanding decreased from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
Receivables Turnover
Expedia Group Inc., receivables turnover calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Revenue | 2,249) | 2,279) | 2,962) | 2,111) | 1,246) | 920) | 1,504) | 566) | 2,209) | 2,747) | 3,558) | 3,153) | 2,609) | 2,559) | 3,276) | 2,880) | 2,508) | 2,319) | 2,966) | 2,586) | 2,189) | |||||||
| Accounts receivable, net of allowance | 1,736) | 1,264) | 1,485) | 1,440) | 1,007) | 701) | 839) | 1,002) | 1,423) | 2,524) | 2,684) | 2,893) | 2,617) | 2,151) | 2,294) | 2,359) | 2,253) | 1,866) | 1,835) | 1,810) | 1,580) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Receivables turnover1 | 5.53 | 6.80 | 4.87 | 4.01 | 4.21 | 7.42 | 8.37 | 9.06 | 8.20 | 4.78 | 4.43 | 4.01 | 4.33 | 5.22 | 4.79 | 4.52 | 4.61 | 5.39 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Home Depot Inc. | 39.00 | 44.15 | 47.12 | 46.57 | 42.95 | 52.34 | 49.72 | 48.38 | 47.32 | 55.89 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 60.88 | 69.69 | 72.02 | 75.94 | 213.66 | 108.00 | 91.76 | 106.12 | 100.60 | 112.54 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q1 2022 Calculation
Receivables turnover
= (RevenueQ1 2022
+ RevenueQ4 2021
+ RevenueQ3 2021
+ RevenueQ2 2021)
÷ Accounts receivable, net of allowance
= (2,249 + 2,279 + 2,962 + 2,111)
÷ 1,736 = 5.53
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. | Expedia Group Inc. receivables turnover ratio improved from Q3 2021 to Q4 2021 but then slightly deteriorated from Q4 2021 to Q1 2022 not reaching Q3 2021 level. |
Payables Turnover
Expedia Group Inc., payables turnover calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Cost of revenue, exclusive of depreciation and amortization | 371) | 395) | 442) | 374) | 311) | 287) | 375) | 389) | 629) | 539) | 548) | 500) | 490) | 476) | 504) | 498) | 487) | 437) | 459) | 439) | 422) | |||||||
| Accounts payable, merchant | 1,292) | 1,333) | 1,264) | 1,157) | 727) | 602) | 581) | 531) | 836) | 1,921) | 1,813) | 1,970) | 1,736) | 1,699) | 1,877) | 1,811) | 1,713) | 1,838) | 1,780) | 1,715) | 1,424) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Payables turnover1 | 1.22 | 1.14 | 1.12 | 1.16 | 1.87 | 2.79 | 3.33 | 3.96 | 2.65 | 1.08 | 1.11 | 1.00 | 1.13 | 1.16 | 1.03 | 1.04 | 1.06 | 0.96 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 4.03 | 3.46 | 3.76 | 3.98 | 3.93 | 3.22 | 3.57 | 3.77 | 4.39 | 3.51 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 6.44 | 7.52 | 6.42 | 6.73 | 7.35 | 9.33 | 7.91 | 7.62 | 6.99 | 9.16 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 4.52 | 5.51 | 4.48 | 4.18 | 4.63 | 6.42 | 5.54 | 5.18 | 4.26 | 5.85 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 6.17 | 5.09 | 4.13 | 10.64 | 25.79 | 11.17 | 8.45 | 11.00 | 10.97 | 10.53 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q1 2022 Calculation
Payables turnover
= (Cost of revenue, exclusive of depreciation and amortizationQ1 2022
+ Cost of revenue, exclusive of depreciation and amortizationQ4 2021
+ Cost of revenue, exclusive of depreciation and amortizationQ3 2021
+ Cost of revenue, exclusive of depreciation and amortizationQ2 2021)
÷ Accounts payable, merchant
= (371 + 395 + 442 + 374)
÷ 1,292 = 1.22
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. | Expedia Group Inc. payables turnover ratio increased from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
Working Capital Turnover
Expedia Group Inc., working capital turnover calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Current assets | 11,147) | 8,181) | 9,043) | 11,113) | 8,836) | 5,634) | 6,735) | 8,944) | 7,652) | 7,735) | 7,969) | 8,824) | 7,702) | 5,197) | 6,172) | 7,794) | 7,431) | 5,540) | 5,984) | 6,027) | 5,328) | |||||||
| Less: Current liabilities | 12,469) | 9,450) | 9,751) | 11,713) | 8,774) | 5,406) | 5,636) | 7,872) | 9,608) | 10,714) | 10,582) | 11,676) | 10,726) | 8,060) | 8,763) | 10,497) | 9,991) | 7,879) | 8,273) | 8,745) | 8,020) | |||||||
| Working capital | (1,322) | (1,269) | (708) | (600) | 62) | 228) | 1,099) | 1,072) | (1,956) | (2,979) | (2,613) | (2,852) | (3,024) | (2,863) | (2,591) | (2,703) | (2,560) | (2,339) | (2,289) | (2,718) | (2,691) | |||||||
| Revenue | 2,249) | 2,279) | 2,962) | 2,111) | 1,246) | 920) | 1,504) | 566) | 2,209) | 2,747) | 3,558) | 3,153) | 2,609) | 2,559) | 3,276) | 2,880) | 2,508) | 2,319) | 2,966) | 2,586) | 2,189) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Working capital turnover1 | — | — | — | — | 68.32 | 22.80 | 6.39 | 8.47 | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | — | 24.33 | 31.50 | 19.23 | 69.81 | 60.82 | 31.47 | 18.92 | 47.22 | 32.92 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 48.51 | 24.87 | 13.79 | 16.66 | 28.53 | 76.81 | 68.95 | 57.87 | 124.59 | 59.68 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 24.04 | 24.92 | 11.60 | 12.67 | 20.57 | 530.50 | 119.81 | 74.71 | 46.13 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 7.40 | 6.51 | 6.91 | 8.72 | 6.55 | 23.97 | 24.08 | 23.99 | 26.62 | 13.27 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q1 2022 Calculation
Working capital turnover
= (RevenueQ1 2022
+ RevenueQ4 2021
+ RevenueQ3 2021
+ RevenueQ2 2021)
÷ Working capital
= (2,249 + 2,279 + 2,962 + 2,111)
÷ -1,322 = —
2 Click competitor name to see calculations.
Average Receivable Collection Period
Expedia Group Inc., average receivable collection period calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Receivables turnover | 5.53 | 6.80 | 4.87 | 4.01 | 4.21 | 7.42 | 8.37 | 9.06 | 8.20 | 4.78 | 4.43 | 4.01 | 4.33 | 5.22 | 4.79 | 4.52 | 4.61 | 5.39 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average receivable collection period1 | 66 | 54 | 75 | 91 | 87 | 49 | 44 | 40 | 45 | 76 | 82 | 91 | 84 | 70 | 76 | 81 | 79 | 68 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||
| Home Depot Inc. | 9 | 8 | 8 | 8 | 8 | 7 | 7 | 8 | 8 | 7 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 6 | 5 | 5 | 5 | 2 | 3 | 4 | 3 | 4 | 3 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q1 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.53 = 66
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. | Expedia Group Inc. number of days of receivables outstanding improved from Q3 2021 to Q4 2021 but then slightly deteriorated from Q4 2021 to Q1 2022 not reaching Q3 2021 level. |
Average Payables Payment Period
Expedia Group Inc., average payables payment period calculation (quarterly data)
| Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Payables turnover | 1.22 | 1.14 | 1.12 | 1.16 | 1.87 | 2.79 | 3.33 | 3.96 | 2.65 | 1.08 | 1.11 | 1.00 | 1.13 | 1.16 | 1.03 | 1.04 | 1.06 | 0.96 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average payables payment period1 | 298 | 320 | 326 | 314 | 195 | 131 | 110 | 92 | 138 | 338 | 329 | 365 | 322 | 316 | 356 | 351 | 343 | 382 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 91 | 105 | 97 | 92 | 93 | 113 | 102 | 97 | 83 | 104 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 57 | 49 | 57 | 54 | 50 | 39 | 46 | 48 | 52 | 40 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 81 | 66 | 81 | 87 | 79 | 57 | 66 | 70 | 86 | 62 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 59 | 72 | 88 | 34 | 14 | 33 | 43 | 33 | 33 | 35 | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).
1 Q1 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 1.22 = 298
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. | Expedia Group Inc. number of days of payables outstanding decreased from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |