Stock Analysis on Net
Stock Analysis on Net

Booking Holdings Inc. (NASDAQ:BKNG)

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

Beginner level

Short-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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
Turnover Ratios
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
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
Working capital turnover 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
Average No. Days
Average receivable collection period 38 28 35 18 17 41 44 49 38 38 44 46 42 35 43 39 31 29
Average payables payment period 12,933 4,151 1,857 972 1,016 659 387 357

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)

Microsoft Excel LibreOffice Calc
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)

Microsoft Excel LibreOffice Calc
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)

Microsoft Excel LibreOffice Calc
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)

Microsoft Excel LibreOffice Calc
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)

Microsoft Excel LibreOffice Calc
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.