Hilton Worldwide Holdings Inc (HLT)

Days of inventory on hand (DOH)

		Dec 31, 2024	Sep 30, 2024	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
Inventory turnover		—	0.19	—	—	2.88	2.29	2.43	2.29	2.99	2.55	2.80	2.39	3.41	3.38	3.85	5.54	8.18	4.75	5.30	4.11
DOH	days	—	1,958.71	—	—	126.80	159.10	150.18	159.73	122.11	143.25	130.49	152.92	107.10	107.95	94.82	65.84	44.61	76.84	68.86	88.81

December 31, 2024 calculation

DOH = 365 ÷ Inventory turnover
= 365 ÷ —
= —

The days of inventory on hand (DOH) ratio for Hilton Worldwide Holdings Inc fluctuated over the period from March 31, 2020, to December 31, 2024. Initially, the DOH stood at 88.81 days on March 31, 2020, indicating that Hilton held inventory for approximately 89 days before selling it.

The DOH ratio decreased steadily over the next few quarters, reaching a low of 44.61 days on December 31, 2020. This suggests that Hilton was managing its inventory more efficiently, reducing the number of days it held inventory before selling it.

However, the trend reversed in the following quarters, with the DOH increasing to 107.95 days by September 30, 2021. This upward trend continued into 2022, with the DOH peaking at 159.73 days on March 31, 2023. A high DOH value indicates that Hilton was holding onto inventory for a longer period, which could tie up capital and impact profitability.

Notably, there were instances of missing data points in the DOH ratio, such as on March 31, 2024, June 30, 2024, and December 31, 2024. The missing data points may be due to various reasons, such as data reporting issues or changes in the business environment.

The most significant anomaly was observed on September 30, 2024, where the DOH ratio spiked to an unusually high value of 1,958.71 days. This outlying figure could be a data error or anomaly that requires further investigation.

Overall, the trend in Hilton's days of inventory on hand reflects fluctuations in inventory management efficiency over the analyzed period, with some periods showing improvements in inventory turnover while others suggesting potential challenges in managing inventory levels.