Stock Analysis on Net

Hilton Worldwide Holdings Inc. (NYSE:HLT)

This company has been moved to the archive! The financial data has not been updated since August 7, 2024.

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

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 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
Turnover Ratios
Receivables turnover 6.85 7.17 6.88 7.21 6.97 7.20 6.61 6.39 5.85 6.30 5.42 4.78 4.23 4.09 5.59 6.50 8.76 8.25 7.50
Working capital turnover 67.25 3.29 2.43 2.53 3.19 9.87
Average No. Days
Average receivable collection period 53 51 53 51 52 51 55 57 62 58 67 76 86 89 65 56 42 44 49

Based on: 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 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).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Hilton Worldwide Holdings Inc. receivables turnover ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 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.

Receivables Turnover

Hilton Worldwide Holdings Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 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
Selected Financial Data (US$ in millions)
Revenues 2,951 2,573 2,609 2,673 2,660 2,293 2,444 2,368 2,240 1,721 1,836 1,749 1,329 874 890 933 564 1,920 2,369 2,395 2,484 2,204
Accounts receivable, net of allowance for credit losses 1,578 1,467 1,487 1,396 1,402 1,298 1,327 1,278 1,289 1,054 1,068 1,012 952 797 771 890 827 1,111 1,261 1,193 1,190 1,102
Short-term Activity Ratio
Receivables turnover1 6.85 7.17 6.88 7.21 6.97 7.20 6.61 6.39 5.85 6.30 5.42 4.78 4.23 4.09 5.59 6.50 8.76 8.25 7.50
Benchmarks
Receivables Turnover, Competitors2
Airbnb Inc. 50.75 48.31 39.83 39.84 34.42 38.36 42.00 45.08 36.09 42.42 42.04
Booking Holdings Inc. 5.87 6.68 6.57 5.98 6.90 8.87 7.67 7.01 6.51 7.77 8.07 5.93 5.57 9.64 12.85 10.36 19.96 21.76 8.97
Chipotle Mexican Grill Inc. 109.32 113.59 85.44 134.08 152.24 136.37 80.79 118.06 97.41 87.64 75.77 94.54 90.40 92.26 57.27 83.86 82.63 89.64 69.36
McDonald’s Corp. 4.10 4.41 3.92 4.22 4.12 4.18 4.14 4.80 5.20 5.93 5.23 5.19 5.07 4.77 3.86 3.46 2.94 5.43 4.24
Starbucks Corp. 32.90 31.49 30.38 30.71 28.67 28.30 27.44 27.91 31.27 29.45 30.92 29.76 27.09 26.09 26.62 27.31 28.33 29.70 30.15 32.97 36.32 35.04

Based on: 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 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).

1 Q2 2024 Calculation
Receivables turnover = (RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023) ÷ Accounts receivable, net of allowance for credit losses
= (2,951 + 2,573 + 2,609 + 2,673) ÷ 1,578 = 6.85

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. Hilton Worldwide Holdings Inc. receivables turnover ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.

Working Capital Turnover

Hilton Worldwide Holdings Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 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
Selected Financial Data (US$ in millions)
Current assets 2,689 3,183 2,614 2,484 2,580 2,561 2,870 2,976 2,840 2,861 2,871 2,694 2,379 3,468 4,202 4,584 4,577 3,149 2,093 2,255 2,215 1,876
Less: Current liabilities 4,226 3,774 3,722 3,561 3,435 3,390 3,372 3,365 3,195 3,085 3,019 2,622 2,779 2,476 2,431 2,299 2,306 2,220 2,871 2,900 2,780 2,794
Working capital (1,537) (591) (1,108) (1,077) (855) (829) (502) (389) (355) (224) (148) 72 (400) 992 1,771 2,285 2,271 929 (778) (645) (565) (918)
 
Revenues 2,951 2,573 2,609 2,673 2,660 2,293 2,444 2,368 2,240 1,721 1,836 1,749 1,329 874 890 933 564 1,920 2,369 2,395 2,484 2,204
Short-term Activity Ratio
Working capital turnover1 67.25 3.29 2.43 2.53 3.19 9.87
Benchmarks
Working Capital Turnover, Competitors2
Airbnb Inc. 1.64 1.64 1.51 1.25 1.41 1.31 1.22 1.17 1.13 1.10 0.99
Booking Holdings Inc. 7.26 6.04 5.77 3.65 2.82 2.77 2.33 4.14 3.16 2.32 1.59 1.07 1.02 0.74 0.77 1.03 1.50 2.83 3.37
Chipotle Mexican Grill Inc. 14.35 15.74 16.73 16.40 16.17 24.45 34.00 32.42 37.95 29.78 14.86 10.78 11.18 10.14 10.01 14.20 13.16 13.89 13.77
McDonald’s Corp. 33.38 8.64 3.33 7.11 3.99 5.39 4.03 6.64 23.54 3.13 5.58 5.19 9.32 131.28 18.14 2.58
Starbucks Corp. 18.11 205.59 50.26 48.92 51.17 14.17 11.24

Based on: 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 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).

1 Q2 2024 Calculation
Working capital turnover = (RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023) ÷ Working capital
= (2,951 + 2,573 + 2,609 + 2,673) ÷ -1,537 =

2 Click competitor name to see calculations.


Average Receivable Collection Period

Hilton Worldwide Holdings Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 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
Selected Financial Data
Receivables turnover 6.85 7.17 6.88 7.21 6.97 7.20 6.61 6.39 5.85 6.30 5.42 4.78 4.23 4.09 5.59 6.50 8.76 8.25 7.50
Short-term Activity Ratio (no. days)
Average receivable collection period1 53 51 53 51 52 51 55 57 62 58 67 76 86 89 65 56 42 44 49
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Airbnb Inc. 7 8 9 9 11 10 9 8 10 9 9
Booking Holdings Inc. 62 55 56 61 53 41 48 52 56 47 45 62 66 38 28 35 18 17 41
Chipotle Mexican Grill Inc. 3 3 4 3 2 3 5 3 4 4 5 4 4 4 6 4 4 4 5
McDonald’s Corp. 89 83 93 87 89 87 88 76 70 62 70 70 72 76 95 106 124 67 86
Starbucks Corp. 11 12 12 12 13 13 13 13 12 12 12 12 13 14 14 13 13 12 12 11 10 10

Based on: 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 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).

1 Q2 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.85 = 53

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.