Analysis of Long-term (Investment) 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.
Long-term Activity Ratios (Summary)
Expedia Group Inc., long-term (investment) 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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Expedia Group Inc. net fixed asset turnover ratio improved from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Expedia Group Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Expedia Group Inc. total asset turnover ratio improved from Q3 2021 to Q4 2021 but then slightly deteriorated from Q4 2021 to Q1 2022. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Expedia Group Inc. equity turnover ratio improved from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
Net Fixed Asset Turnover
Expedia Group Inc., net fixed asset 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) | |||||||
| Property and equipment, net | 2,169) | 2,180) | 2,264) | 2,261) | 2,241) | 2,257) | 2,303) | 2,305) | 2,297) | 2,198) | 2,090) | 1,953) | 1,828) | 1,877) | 1,769) | 1,689) | 1,627) | 1,575) | 1,522) | 1,479) | 1,422) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 4.43 | 3.94 | 3.20 | 2.56 | 1.89 | 2.30 | 3.05 | 3.94 | 5.08 | 5.49 | 5.68 | 5.94 | 6.19 | 5.98 | 6.21 | 6.32 | 6.38 | 6.39 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 2.84 | 2.93 | 3.11 | 3.32 | 3.45 | 3.41 | 3.48 | 3.72 | 3.81 | 3.86 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 5.73 | 5.35 | 5.27 | 5.10 | 4.94 | 4.84 | 4.94 | 4.91 | 4.92 | 4.84 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 4.95 | 4.68 | 4.57 | 4.32 | 4.00 | 3.86 | 3.91 | 3.94 | 3.95 | 3.87 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 7.46 | 6.38 | 6.67 | 6.61 | 7.08 | 7.83 | 7.74 | 7.94 | 7.88 | 7.42 | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Net fixed asset turnover
= (RevenueQ1 2022
+ RevenueQ4 2021
+ RevenueQ3 2021
+ RevenueQ2 2021)
÷ Property and equipment, net
= (2,249 + 2,279 + 2,962 + 2,111)
÷ 2,169 = 4.43
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Expedia Group Inc. net fixed asset turnover ratio improved from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
Expedia Group Inc., net fixed asset turnover (including operating lease, right-of-use asset) 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) | |||||||
| Property and equipment, net | 2,169) | 2,180) | 2,264) | 2,261) | 2,241) | 2,257) | 2,303) | 2,305) | 2,297) | 2,198) | 2,090) | 1,953) | 1,828) | 1,877) | 1,769) | 1,689) | 1,627) | 1,575) | 1,522) | 1,479) | 1,422) | |||||||
| Operating lease right-of-use assets | 395) | 407) | 441) | 467) | 498) | 574) | 598) | 626) | 628) | 611) | 495) | 524) | 537) | —) | —) | —) | —) | —) | —) | —) | —) | |||||||
| Property and equipment, net (including operating lease, right-of-use asset) | 2,564) | 2,587) | 2,705) | 2,728) | 2,739) | 2,831) | 2,901) | 2,931) | 2,925) | 2,809) | 2,585) | 2,477) | 2,365) | 1,877) | 1,769) | 1,689) | 1,627) | 1,575) | 1,522) | 1,479) | 1,422) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 3.74 | 3.32 | 2.68 | 2.12 | 1.55 | 1.84 | 2.42 | 3.10 | 3.99 | 4.30 | 4.60 | 4.68 | 4.79 | 5.98 | 6.21 | 6.32 | 6.38 | 6.39 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 2.13 | 2.17 | 2.30 | 2.51 | 2.61 | 2.56 | 2.59 | 2.80 | 2.85 | 2.87 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 4.63 | 4.31 | 4.29 | 4.14 | 3.96 | 3.89 | 3.95 | 3.90 | 3.93 | 4.84 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 4.11 | 3.90 | 3.79 | 3.59 | 3.31 | 3.20 | 3.23 | 3.24 | 3.25 | 3.87 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 2.66 | 2.29 | 2.38 | 2.38 | 2.58 | 2.90 | 2.84 | 2.86 | 2.86 | 7.42 | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenueQ1 2022
+ RevenueQ4 2021
+ RevenueQ3 2021
+ RevenueQ2 2021)
÷ Property and equipment, net (including operating lease, right-of-use asset)
= (2,249 + 2,279 + 2,962 + 2,111)
÷ 2,564 = 3.74
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Expedia Group Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |
Total Asset Turnover
Expedia Group Inc., total asset 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) | |||||||
| Total assets | 24,577) | 21,548) | 21,944) | 24,181) | 21,866) | 18,690) | 19,679) | 21,905) | 20,417) | 21,416) | 21,381) | 22,201) | 20,963) | 18,033) | 19,141) | 20,554) | 20,429) | 18,516) | 19,035) | 18,623) | 17,669) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Total asset turnover1 | 0.39 | 0.40 | 0.33 | 0.24 | 0.19 | 0.28 | 0.36 | 0.41 | 0.57 | 0.56 | 0.56 | 0.52 | 0.54 | 0.62 | 0.57 | 0.52 | 0.51 | 0.54 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 1.16 | 1.12 | 1.20 | 1.23 | 1.30 | 1.20 | 1.23 | 1.25 | 1.34 | 1.25 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 1.95 | 1.87 | 1.88 | 1.88 | 1.91 | 2.15 | 2.12 | 2.12 | 2.13 | 2.46 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 1.84 | 1.92 | 1.68 | 1.55 | 1.62 | 1.83 | 1.80 | 1.76 | 1.66 | 2.07 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 1.25 | 1.04 | 1.06 | 1.27 | 1.45 | 1.73 | 1.67 | 1.75 | 1.76 | 2.72 | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Total asset turnover
= (RevenueQ1 2022
+ RevenueQ4 2021
+ RevenueQ3 2021
+ RevenueQ2 2021)
÷ Total assets
= (2,249 + 2,279 + 2,962 + 2,111)
÷ 24,577 = 0.39
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Expedia Group Inc. total asset turnover ratio improved from Q3 2021 to Q4 2021 but then slightly deteriorated from Q4 2021 to Q1 2022. |
Equity Turnover
Expedia Group Inc., equity 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) | |||||||
| Total Expedia Group, Inc. stockholders’ equity | 2,078) | 2,057) | 2,114) | 1,607) | 2,231) | 2,532) | 2,654) | 2,756) | 2,270) | 3,967) | 4,184) | 4,342) | 4,083) | 4,104) | 4,386) | 3,967) | 4,195) | 4,522) | 4,603) | 4,226) | 4,089) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Equity turnover1 | 4.62 | 4.18 | 3.42 | 3.60 | 1.90 | 2.05 | 2.65 | 3.29 | 5.14 | 3.04 | 2.84 | 2.67 | 2.77 | 2.73 | 2.50 | 2.69 | 2.47 | 2.22 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 3.57 | 3.40 | 3.80 | 3.86 | 4.06 | 4.13 | 4.20 | 4.36 | 4.54 | 4.52 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Home Depot Inc. | 80.86 | 40.05 | 81.84 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Lowe’s Cos. Inc. | 212.01 | 62.35 | 20.95 | 18.46 | 43.17 | 36.59 | 29.20 | 27.19 | 22.15 | 19.57 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| TJX Cos. Inc. | 6.16 | 5.51 | 6.00 | 7.24 | 7.78 | 7.01 | 7.33 | 7.55 | 7.71 | 7.72 | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Equity turnover
= (RevenueQ1 2022
+ RevenueQ4 2021
+ RevenueQ3 2021
+ RevenueQ2 2021)
÷ Total Expedia Group, Inc. stockholders’ equity
= (2,249 + 2,279 + 2,962 + 2,111)
÷ 2,078 = 4.62
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Expedia Group Inc. equity turnover ratio improved from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022. |