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)
Hilton Worldwide Holdings Inc., short-term (operating) activity ratios (quarterly data)
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).
- Receivables Turnover
- The receivables turnover ratio shows notable fluctuations over the reported periods. Beginning with a range of 7.5 to 8.76 in early 2020, the ratio declined to a low of 4.09 by mid-2021, indicating a slower collection of receivables during that period. Subsequently, the ratio gradually recovered to approximately 6.3 to 6.61 in late 2021 and through 2022. By 2023 and into the first half of 2024, the turnover stabilized around a range of approximately 6.85 to 7.2. This pattern suggests an initial deterioration in receivables management or collection efficiency, followed by a progressive improvement toward pre-2020 levels.
- Working Capital Turnover
- The working capital turnover ratio data is sparse, with values only available for a few quarters in 2020 and 2021. It shows high variability, starting at 9.87 in the second quarter of 2020, but dropping sharply to 3.19, then further decreasing to 2.43 by the end of 2020. A significant outlier appears in 2021 with a spike to 67.25, which may indicate either a one-time operational or accounting event or an anomaly in the data. Due to the limited and irregular data points, it is difficult to discern a consistent trend, but the volatility observed suggests fluctuations in the efficiency of working capital utilization.
- Average Receivable Collection Period
- The average receivable collection period displays an inverse trend relative to the receivables turnover ratio. Starting at 49 days in early 2020, it decreased to around 42 days by Q3 2020, reflecting faster collections initially. However, the period then lengthened, reaching a peak of 89 days mid-2021, indicating slowed receivables collection. Following this peak, the collection period steadily shortened over the subsequent quarters, falling to around 51 to 53 days by early to mid-2024. This trend corroborates the observed improvement in receivables turnover during the latter periods, suggesting enhanced effectiveness in collecting outstanding receivables.
Turnover Ratios
Average No. Days
Receivables Turnover
Hilton Worldwide Holdings Inc., receivables turnover calculation (quarterly data)
| 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. | 60.03 | 58.52 | 48.38 | 46.60 | 41.69 | 47.07 | 52.17 | 53.27 | 43.30 | 53.74 | 53.67 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| 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 | — | — | — | — | — | — | — | |||||||
| 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 | — | — | — | — | — | — | — | |||||||
| DoorDash, Inc. | 16.43 | 16.69 | 16.20 | 19.54 | 20.07 | 18.75 | 16.46 | 18.66 | 16.30 | 16.41 | 14.01 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| 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 | — | — | — | — | — | — | — | |||||||
| 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 | — | — | — | |||||||
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.
- Revenue Trends
- Revenues exhibited a generally stable pattern from Q1 2019 to Q4 2019, staying within a range of approximately $2.2 billion to $2.5 billion. Beginning Q1 2020, a significant decline occurred, with revenues dropping sharply to $1.92 billion and reaching a low of $564 million by Q2 2020, reflecting a notable contraction. A gradual recovery is visible through the remainder of 2020 and into 2021, with revenues increasing to $1.836 billion by Q4 2021. The recovery trend continued, with revenues surpassing pre-pandemic levels in 2022 and 2023, peaking at $2.951 billion in Q2 2024. This pattern suggests resilience and growth momentum post-downturn.
- Accounts Receivable (Net) Dynamics
- Accounts receivable values showed a relatively moderate increase from Q1 2019 ($1.1 billion) through Q4 2019 ($1.261 billion). In early 2020, a decrease is observed, with a trough at $771 million in Q4 2020, paralleling the revenue decline, possibly due to reduced business activity and collection effects. From Q1 2021 onward, there is a steady increase, reaching $1.578 billion by Q2 2024, indicating growing credit extended to customers as business activity recovered and expanded.
- Receivables Turnover Ratio
- Receivables turnover ratios began at 7.5 in Q1 2020 and showed an upward trend peaking at 8.76 in Q3 2020, indicating improved efficiency in collections despite lower revenue levels. However, a sharp decline followed in Q4 2020 to 6.5, with further decrease in Q1 2021 to 5.59 and bottoming near 4.09 in Q2 2021. From mid-2021 through 2024, the ratio improved steadily, stabilizing around 6.85 to 7.21, implying recovery in receivables management correlating with the revenue growth phase.
- Summary of Financial Health Indicators
- Overall, the data reflects a significant operational impact during 2020, likely attributable to external economic disruptions, with sharp declines in revenue and receivables followed by recovery phases. The receivables turnover ratio mirrored these changes, initially suggesting effective collections during the sharp downturn but declining as volumes normalized and expanding again with revenue growth. The steady increase in accounts receivable trailing revenue gains indicates expanding sales on credit terms consistent with growing business activity. The company demonstrates resilience over the analyzed quarters, with financial metrics trending toward recovery and growth beyond pre-impact levels by mid-2024.
Working Capital Turnover
Hilton Worldwide Holdings Inc., working capital turnover calculation (quarterly data)
| 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 | — | — | — | — | — | — | — | |||||||
| 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 | — | — | — | — | — | — | — | |||||||
| DoorDash, Inc. | 3.71 | 3.82 | 3.95 | 3.78 | 4.09 | 3.70 | 3.03 | 2.45 | 2.01 | 1.98 | 1.74 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| 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 | — | — | — | — | — | — | — | |||||||
| Starbucks Corp. | — | — | — | — | — | — | — | — | — | — | 18.11 | 205.59 | 50.26 | 48.92 | 51.17 | — | — | — | — | — | — | — | |||||||
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.
The data reveals several notable trends in key financial metrics over the period analyzed, with particular fluctuations related to the economic environment affecting the company.
- Working Capital
- Working capital exhibited significant volatility. Initially, the company reported negative working capital from March 2019 through December 2019, ranging from approximately -918 million to -778 million US dollars, suggesting tight short-term liquidity. Beginning March 2020, working capital sharply improved to positive values, peaking around 2,285 million in September 2020. This sudden increase likely reflects strategic changes or external funding during the earlier phases of the pandemic. However, from the end of 2020 into 2024, working capital trended downward again, returning to negative values and reaching nearly -1,537 million in June 2024. This decline indicates increased short-term liabilities relative to current assets toward the end of the observed period.
- Revenues
- Revenues showed a distinct dip from the end of 2019 through mid-2020, falling from roughly 2,369 million to a low of 564 million in June 2020, consistent with the global impact of the COVID-19 pandemic on the hospitality sector. Following this low point, revenues progressively recovered, surpassing pre-pandemic levels by mid-2022 and continuing an upward trajectory through mid-2024, reaching a peak of approximately 2,951 million in June 2024. This recovery reflects a strong rebound in business activity and demand.
- Working Capital Turnover Ratio
- The working capital turnover ratio data is limited but shows extreme variation early in the pandemic period. From June 2020 to December 2020, there is a steep decline from 9.87 to 2.43, indicating that revenue generation relative to working capital investment slowed significantly. The single value of 67.25 recorded in June 2021 likely reflects an anomaly or data inconsistency and should be interpreted cautiously. No further consistent data points are available to assess subsequent trends.
In summary, the company experienced severe short-term liquidity fluctuations and a sharp revenue decline at the outset of 2020, followed by a recovery phase extending into mid-2024. Working capital management appears challenged in the later periods, with negative working capital reemerging despite revenue growth, which may warrant further investigation into operational or financing changes.
Average Receivable Collection Period
Hilton Worldwide Holdings Inc., average receivable collection period calculation (quarterly data)
| 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. | 6 | 6 | 8 | 8 | 9 | 8 | 7 | 7 | 8 | 7 | 7 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Booking Holdings Inc. | 62 | 55 | 56 | 61 | 53 | 41 | 48 | 52 | 56 | 47 | 45 | 62 | 66 | 38 | 28 | — | — | — | — | — | — | — | |||||||
| Chipotle Mexican Grill Inc. | 3 | 3 | 4 | 3 | 2 | 3 | 5 | 3 | 4 | 4 | 5 | 4 | 4 | 4 | 6 | — | — | — | — | — | — | — | |||||||
| DoorDash, Inc. | 22 | 22 | 23 | 19 | 18 | 19 | 22 | 20 | 22 | 22 | 26 | — | — | — | — | — | — | — | — | — | — | — | |||||||
| McDonald’s Corp. | 89 | 83 | 93 | 87 | 89 | 87 | 88 | 76 | 70 | 62 | 70 | 70 | 72 | 76 | 95 | — | — | — | — | — | — | — | |||||||
| Starbucks Corp. | 11 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 12 | 12 | 12 | 12 | 13 | 14 | 14 | 13 | 13 | 12 | 12 | — | — | — | |||||||
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.
- Receivables Turnover Ratio
- The receivables turnover ratio displays notable fluctuations throughout the observed periods. Beginning in March 2020 with a value of 7.5, the ratio improved slightly to 8.25 in June 2020 and peaked at 8.76 by September 2020, indicating an increased efficiency in collecting receivables during this initial phase. However, a marked decline follows, dropping to 6.5 in December 2020 and further descending to its lowest point of 4.09 by June 2021. After this trough, the ratio gradually recovers over the subsequent quarters, rising steadily to 7.17 by March 2024. This pattern suggests initial disruption likely tied to external factors, followed by a recovery towards pre-disruption levels, with some intermittence in the trend.
- Average Receivable Collection Period (Days)
- The average receivable collection period inversely mirrors the trends seen in the turnover ratio, revealing an increase from 49 days in March 2020 to a peak of 89 days in June 2021, highlighting a slowdown in receivables collection efficiency. This extended collection period signifies that the company required a longer time to convert receivables into cash during this phase. Subsequently, the number of days declined gradually, reaching a lower range around 51 to 53 days by early 2023 and maintaining relative stability through mid-2024. This recovery implies a return towards improved credit management and collection practices over time.
- Overall Trends and Insights
- The period under review reflects an initial phase of volatility and reduced efficiency in receivables management, potentially related to external economic disruptions. The initial high turnover ratios coupled with shorter collection periods deteriorated sharply into mid-2021, signifying possible challenges in collections. From late 2021 onward, there is clear evidence of operational adjustments and recovery, as indicated by increasing turnover ratios and shortening collection periods, approaching a trend of stabilization by 2023 and into 2024. Monitoring these metrics will be important for assessing ongoing credit risk management and cash flow implications.