Hasbro Inc (HAS)
Working capital turnover
| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (ttm) | US$ in thousands | 5,003,300 | 5,392,900 | 5,565,400 | 5,694,600 | 5,856,700 | 6,191,600 | 6,485,700 | 6,468,700 | 6,420,400 | 6,129,970 | 5,936,590 | 5,474,669 | 5,465,439 | 5,170,479 | 4,969,029 | 5,093,287 | 4,720,227 | 4,681,377 | 4,675,897 | 4,595,818 |
| Total current assets | US$ in thousands | 2,323,600 | 3,240,100 | 2,509,000 | 2,539,200 | 2,999,100 | 3,260,500 | 3,085,400 | 3,255,300 | 3,728,100 | 3,730,400 | 3,616,400 | 3,236,000 | 3,846,600 | 3,759,000 | 3,185,700 | 3,318,500 | 6,747,520 | 3,413,130 | 2,830,100 | 2,631,860 |
| Total current liabilities | US$ in thousands | 2,056,400 | 2,024,200 | 1,950,400 | 1,897,400 | 2,189,700 | 2,356,900 | 2,158,200 | 2,043,000 | 2,455,900 | 2,450,400 | 2,045,600 | 1,753,400 | 2,403,300 | 2,315,600 | 1,981,600 | 1,738,600 | 1,257,080 | 1,466,740 | 1,072,700 | 948,725 |
| Working capital turnover | 18.72 | 4.44 | 9.96 | 8.87 | 7.24 | 6.85 | 6.99 | 5.34 | 5.05 | 4.79 | 3.78 | 3.69 | 3.79 | 3.58 | 4.13 | 3.22 | 0.86 | 2.41 | 2.66 | 2.73 |
December 31, 2023 calculation
Working capital turnover = Revenue (ttm) ÷ (Total current assets – Total current liabilities)
= $5,003,300K ÷ ($2,323,600K – $2,056,400K)
= 18.72
The working capital turnover ratio for Hasbro, Inc. has shown fluctuations over the past eight quarters. In Q4 2023, the ratio was at its highest level of 18.72, indicating that the company generated revenue nearly 19 times the amount of working capital invested during that period. This suggests efficient management of working capital to support sales.
On the other hand, in Q3 2023, the ratio dropped significantly to 4.44, signaling a potential issue with efficiently utilizing working capital to generate revenue. The ratio then improved in Q2 2023 to 9.96, indicating a better utilization of working capital compared to the previous quarter. Q1 2023 also showed a solid working capital turnover of 8.87, further supporting the notion of efficient working capital management.
Comparing the data to the previous year, Q4 2022 had a working capital turnover ratio of 7.24, which was lower than the Q4 2023 ratio. Overall, despite some fluctuations, the trend in working capital turnover for Hasbro, Inc. shows variations in efficiency in utilizing working capital to generate sales revenue over the analyzed quarters.