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)
Booking Holdings Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (filing date: 2021-05-05), 10-K (filing date: 2021-02-24), 10-Q (filing date: 2020-11-05), 10-Q (filing date: 2020-08-06), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-07), 10-Q (filing date: 2019-08-07), 10-Q (filing date: 2019-05-09), 10-K (filing date: 2019-02-27), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-09), 10-Q (filing date: 2018-05-09), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-11-07), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-07), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-04).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Booking Holdings Inc.’s receivables turnover ratio improved from Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Booking Holdings Inc.’s working capital turnover ratio deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021. |
| 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. | Booking Holdings Inc.’s number of days of receivables outstanding improved from Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021. |
Receivables Turnover
Booking Holdings Inc., receivables turnover calculation (quarterly data)
| 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 | Dec 31, 2016 | Sep 30, 2016 | Jun 30, 2016 | Mar 31, 2016 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Revenues | 1,141 | 1,238 | 2,640 | 630 | 2,288 | 3,339 | 5,040 | 3,850 | 2,837 | 3,213 | 4,849 | 3,537 | 2,928 | 2,803 | 4,434 | 3,025 | 2,419 | 2,348 | 3,691 | 2,556 | 2,148 | |||||||
| Accounts receivable, net of allowance for credit losses | 586 | 529 | 859 | 566 | 667 | 1,680 | 1,788 | 1,973 | 1,491 | 1,523 | 1,719 | 1,715 | 1,530 | 1,218 | 1,438 | 1,231 | 934 | 860 | 1,105 | 983 | 857 | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Receivables turnover1 | 9.64 | 12.85 | 10.36 | 19.96 | 21.76 | 8.97 | 8.36 | 7.48 | 9.68 | 9.54 | 8.21 | 7.99 | 8.62 | 10.41 | 8.50 | 9.33 | 11.79 | 12.49 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Home Depot Inc. | 42.95 | 52.34 | 49.72 | 48.38 | 47.32 | 55.89 | 48.64 | 48.21 | 44.41 | 51.69 | 45.81 | 44.52 | 44.23 | 46.62 | 46.80 | 46.13 | 45.44 | 46.84 | — | — | — | |||||||
| TJX Cos. Inc. | 213.66 | 108.00 | 91.76 | 106.12 | 100.60 | 112.54 | 92.44 | 105.97 | 99.83 | 109.62 | 99.38 | 111.01 | 105.37 | 128.21 | 106.64 | 111.30 | 112.28 | 129.98 | — | — | — | |||||||
Based on: 10-Q (filing date: 2021-05-05), 10-K (filing date: 2021-02-24), 10-Q (filing date: 2020-11-05), 10-Q (filing date: 2020-08-06), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-07), 10-Q (filing date: 2019-08-07), 10-Q (filing date: 2019-05-09), 10-K (filing date: 2019-02-27), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-09), 10-Q (filing date: 2018-05-09), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-11-07), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-07), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-04).
1 Q1 2021 Calculation
Receivables turnover
= (RevenuesQ1 2021
+ RevenuesQ4 2020
+ RevenuesQ3 2020
+ RevenuesQ2 2020)
÷ Accounts receivable, net of allowance for credit losses
= (1,141 + 1,238 + 2,640 + 630)
÷ 586 = 9.64
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. | Booking Holdings Inc.’s receivables turnover ratio improved from Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021. |
Payables Turnover
Booking Holdings Inc., payables turnover calculation (quarterly data)
| 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 | Dec 31, 2016 | Sep 30, 2016 | Jun 30, 2016 | Mar 31, 2016 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Cost of revenues | — | — | — | — | — | — | — | — | — | — | — | — | — | 33 | 59 | 73 | 85 | 72 | 101 | 126 | 129 | |||||||
| Accounts payable | 570 | 735 | 1,114 | 581 | 926 | 1,239 | 1,275 | 1,291 | 934 | 1,134 | 1,175 | 1,054 | 841 | 668 | 806 | 598 | 408 | 419 | 495 | 432 | 335 | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Payables turnover1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | 0.09 | 0.20 | 0.38 | 0.36 | 0.55 | 0.94 | 1.02 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 3.93 | 3.22 | 3.57 | 3.77 | 4.39 | 3.51 | 4.37 | 4.11 | 4.47 | 3.64 | 4.30 | 4.61 | 4.78 | 3.23 | 3.93 | 4.48 | 4.86 | 3.49 | — | — | — | |||||||
| Home Depot Inc. | 7.35 | 9.33 | 7.91 | 7.62 | 6.99 | 9.16 | 7.66 | 7.29 | 6.90 | 9.19 | 7.63 | 7.51 | 6.90 | 8.90 | 7.63 | 7.32 | 6.83 | 8.87 | — | — | — | |||||||
| Lowe’s Cos. Inc. | 4.63 | 6.42 | 5.54 | 5.18 | 4.26 | 5.85 | 5.16 | 5.22 | 4.53 | 6.86 | 5.09 | 5.15 | 4.41 | 6.40 | 5.21 | 5.18 | 4.45 | 6.84 | — | — | — | |||||||
| Target Corp. | 5.94 | 5.53 | 4.86 | 5.93 | 6.45 | 5.46 | 4.45 | 5.75 | 6.35 | 5.89 | 4.94 | 6.48 | 7.47 | 6.74 | 5.98 | 7.39 | 8.02 | 7.01 | — | — | — | |||||||
| TJX Cos. Inc. | 25.79 | 11.17 | 8.45 | 11.00 | 10.97 | 10.53 | 8.28 | 9.99 | 10.42 | 10.25 | 8.18 | 10.28 | 10.91 | 10.56 | 8.62 | 10.11 | 10.52 | 10.00 | — | — | — | |||||||
Based on: 10-Q (filing date: 2021-05-05), 10-K (filing date: 2021-02-24), 10-Q (filing date: 2020-11-05), 10-Q (filing date: 2020-08-06), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-07), 10-Q (filing date: 2019-08-07), 10-Q (filing date: 2019-05-09), 10-K (filing date: 2019-02-27), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-09), 10-Q (filing date: 2018-05-09), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-11-07), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-07), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-04).
1 Q1 2021 Calculation
Payables turnover
= (Cost of revenuesQ1 2021
+ Cost of revenuesQ4 2020
+ Cost of revenuesQ3 2020
+ Cost of revenuesQ2 2020)
÷ Accounts payable
= (0 + 0 + 0 + 0)
÷ 570 = 0.00
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. |
Working Capital Turnover
Booking Holdings Inc., working capital turnover calculation (quarterly data)
| 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 | Dec 31, 2016 | Sep 30, 2016 | Jun 30, 2016 | Mar 31, 2016 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Current assets | 14,108 | 12,206 | 12,583 | 11,453 | 9,260 | 9,833 | 10,056 | 10,020 | 7,077 | 8,407 | 9,468 | 10,033 | 9,505 | 9,035 | 9,125 | 8,273 | 6,988 | 5,402 | 5,834 | 5,914 | 4,865 | |||||||
| Less: Current liabilities | 6,468 | 3,425 | 3,968 | 3,909 | 4,136 | 5,366 | 5,528 | 6,349 | 5,576 | 3,555 | 3,930 | 5,222 | 4,447 | 3,498 | 3,624 | 3,757 | 3,248 | 2,859 | 2,906 | 2,210 | 1,988 | |||||||
| Working capital | 7,640 | 8,781 | 8,615 | 7,544 | 5,124 | 4,467 | 4,528 | 3,671 | 1,501 | 4,852 | 5,538 | 4,811 | 5,057 | 5,537 | 5,500 | 4,516 | 3,740 | 2,543 | 2,928 | 3,705 | 2,877 | |||||||
| Revenues | 1,141 | 1,238 | 2,640 | 630 | 2,288 | 3,339 | 5,040 | 3,850 | 2,837 | 3,213 | 4,849 | 3,537 | 2,928 | 2,803 | 4,434 | 3,025 | 2,419 | 2,348 | 3,691 | 2,556 | 2,148 | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Working capital turnover1 | 0.74 | 0.77 | 1.03 | 1.50 | 2.83 | 3.37 | 3.30 | 4.02 | 9.62 | 2.99 | 2.55 | 2.85 | 2.61 | 2.29 | 2.22 | 2.54 | 2.95 | 4.22 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 69.81 | 60.82 | 31.47 | 18.92 | 47.22 | 32.92 | 38.37 | 35.44 | 42.11 | 34.71 | 48.44 | 56.56 | 69.39 | 76.87 | 107.01 | 308.26 | 69.18 | 69.20 | — | — | — | |||||||
| Home Depot Inc. | 28.53 | 76.81 | 68.95 | 57.87 | 124.59 | 59.68 | 65.46 | 43.91 | 33.09 | 36.84 | 26.96 | 20.77 | 27.68 | 26.34 | 18.99 | 20.84 | 23.41 | 19.82 | — | — | — | |||||||
| Lowe’s Cos. Inc. | 20.57 | 530.50 | 119.81 | 74.71 | 46.13 | — | 1,031.26 | 78.17 | 266.87 | 101.51 | 254.28 | 166.37 | 112.95 | 2,500.65 | 657.58 | 363.64 | 25.59 | 856.14 | — | — | — | |||||||
| Target Corp. | 389.66 | — | — | — | — | — | — | — | — | — | — | — | — | — | 352.16 | 143.21 | 37.77 | 48.93 | — | — | — | |||||||
| TJX Cos. Inc. | 6.55 | 23.97 | 24.08 | 23.99 | 26.62 | 13.27 | 11.75 | 11.43 | 10.67 | 10.67 | 11.76 | 11.64 | 11.36 | 11.09 | 10.72 | 12.87 | 12.25 | 13.06 | — | — | — | |||||||
Based on: 10-Q (filing date: 2021-05-05), 10-K (filing date: 2021-02-24), 10-Q (filing date: 2020-11-05), 10-Q (filing date: 2020-08-06), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-07), 10-Q (filing date: 2019-08-07), 10-Q (filing date: 2019-05-09), 10-K (filing date: 2019-02-27), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-09), 10-Q (filing date: 2018-05-09), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-11-07), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-07), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-04).
1 Q1 2021 Calculation
Working capital turnover
= (RevenuesQ1 2021
+ RevenuesQ4 2020
+ RevenuesQ3 2020
+ RevenuesQ2 2020)
÷ Working capital
= (1,141 + 1,238 + 2,640 + 630)
÷ 7,640 = 0.74
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. | Booking Holdings Inc.’s working capital turnover ratio deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021. |
Average Receivable Collection Period
Booking Holdings Inc., average receivable collection period calculation (quarterly data)
| 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 | Dec 31, 2016 | Sep 30, 2016 | Jun 30, 2016 | Mar 31, 2016 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Receivables turnover | 9.64 | 12.85 | 10.36 | 19.96 | 21.76 | 8.97 | 8.36 | 7.48 | 9.68 | 9.54 | 8.21 | 7.99 | 8.62 | 10.41 | 8.50 | 9.33 | 11.79 | 12.49 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average receivable collection period1 | 38 | 28 | 35 | 18 | 17 | 41 | 44 | 49 | 38 | 38 | 44 | 46 | 42 | 35 | 43 | 39 | 31 | 29 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||
| Home Depot Inc. | 8 | 7 | 7 | 8 | 8 | 7 | 8 | 8 | 8 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | — | — | — | |||||||
| TJX Cos. Inc. | 2 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | — | — | — | |||||||
Based on: 10-Q (filing date: 2021-05-05), 10-K (filing date: 2021-02-24), 10-Q (filing date: 2020-11-05), 10-Q (filing date: 2020-08-06), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-07), 10-Q (filing date: 2019-08-07), 10-Q (filing date: 2019-05-09), 10-K (filing date: 2019-02-27), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-09), 10-Q (filing date: 2018-05-09), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-11-07), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-07), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-04).
1 Q1 2021 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 9.64 = 38
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. | Booking Holdings Inc.’s number of days of receivables outstanding improved from Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021. |
Average Payables Payment Period
Booking Holdings Inc., average payables payment period calculation (quarterly data)
| 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 | Dec 31, 2016 | Sep 30, 2016 | Jun 30, 2016 | Mar 31, 2016 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||||
| Payables turnover | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | 0.09 | 0.20 | 0.38 | 0.36 | 0.55 | 0.94 | 1.02 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average payables payment period1 | — | — | — | — | — | — | — | — | — | — | 12,933 | 4,151 | 1,857 | 972 | 1,016 | 659 | 387 | 357 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | 93 | 113 | 102 | 97 | 83 | 104 | 84 | 89 | 82 | 100 | 85 | 79 | 76 | 113 | 93 | 81 | 75 | 105 | — | — | — | |||||||
| Home Depot Inc. | 50 | 39 | 46 | 48 | 52 | 40 | 48 | 50 | 53 | 40 | 48 | 49 | 53 | 41 | 48 | 50 | 53 | 41 | — | — | — | |||||||
| Lowe’s Cos. Inc. | 79 | 57 | 66 | 70 | 86 | 62 | 71 | 70 | 81 | 53 | 72 | 71 | 83 | 57 | 70 | 70 | 82 | 53 | — | — | — | |||||||
| Target Corp. | 61 | 66 | 75 | 62 | 57 | 67 | 82 | 63 | 57 | 62 | 74 | 56 | 49 | 54 | 61 | 49 | 45 | 52 | — | — | — | |||||||
| TJX Cos. Inc. | 14 | 33 | 43 | 33 | 33 | 35 | 44 | 37 | 35 | 36 | 45 | 35 | 33 | 35 | 42 | 36 | 35 | 36 | — | — | — | |||||||
Based on: 10-Q (filing date: 2021-05-05), 10-K (filing date: 2021-02-24), 10-Q (filing date: 2020-11-05), 10-Q (filing date: 2020-08-06), 10-Q (filing date: 2020-05-07), 10-K (filing date: 2020-02-26), 10-Q (filing date: 2019-11-07), 10-Q (filing date: 2019-08-07), 10-Q (filing date: 2019-05-09), 10-K (filing date: 2019-02-27), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-09), 10-Q (filing date: 2018-05-09), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-11-07), 10-Q (filing date: 2017-08-08), 10-Q (filing date: 2017-05-09), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-07), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-04).
1 Q1 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 0.00 = —
2 Click competitor name to see calculations.