Sherwin-Williams Co (SHW)
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 | 22,557,900 | 22,588,100 | 22,534,900 | 22,159,400 | 21,735,200 | 21,387,100 | 20,505,700 | 20,027,700 | 19,578,700 | 19,305,400 | 19,277,600 | 18,501,700 | 18,080,200 | 17,705,800 | 17,534,900 | 17,893,700 | 17,900,800 | 17,850,600 | 17,714,400 | 17,610,400 |
| Total current assets | US$ in thousands | 5,512,900 | 6,198,800 | 6,350,600 | 6,292,800 | 5,907,700 | 6,117,200 | 6,259,500 | 6,086,400 | 5,053,700 | 5,378,400 | 5,185,700 | 5,109,600 | 4,591,400 | 5,175,600 | 4,883,200 | 4,928,000 | 4,631,700 | 4,907,700 | 5,090,000 | 4,815,200 |
| Total current liabilities | US$ in thousands | 6,626,900 | 6,623,200 | 6,339,100 | 6,306,000 | 5,960,700 | 6,096,000 | 7,198,200 | 6,953,100 | 5,719,500 | 6,478,500 | 6,190,400 | 5,651,600 | 4,594,400 | 4,358,300 | 4,459,600 | 5,220,200 | 4,521,900 | 4,865,800 | 6,342,600 | 5,000,600 |
| Working capital turnover | — | — | 1,959.56 | — | — | 1,008.83 | — | — | — | — | — | — | — | 21.66 | 41.39 | — | 163.03 | 426.03 | — | — |
December 31, 2023 calculation
Working capital turnover = Revenue (ttm) ÷ (Total current assets – Total current liabilities)
= $22,557,900K ÷ ($5,512,900K – $6,626,900K)
= —
Sherwin-Williams Co.'s working capital turnover ratio has shown fluctuation over the past few quarters, with a notable increase from 1,022.67 in Q3 2022 to 1,996.60 in Q2 2023. This indicates that the company is effectively generating revenue relative to its working capital. However, the lack of data in other quarters makes it challenging to discern a consistent trend. It would be beneficial to monitor future financial reports to better evaluate the company's efficiency in utilizing its working capital.
Peer comparison
Dec 31, 2023
See also:
Sherwin-Williams Co Working Capital Turnover (Quarterly Data)