Sherwin-Williams Co (SHW)

Receivables 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
Receivables US$ in thousands 2,467,900 2,940,900 3,117,800 2,909,200 2,563,600 2,897,600 2,982,500 2,783,600 2,352,400 2,598,000 2,590,600 2,414,100 2,078,100 2,454,500 2,472,500 2,291,500 2,088,900 2,479,040 2,659,050 2,339,550
Receivables turnover 9.14 7.68 7.23 7.62 8.48 7.38 6.88 7.19 8.32 7.43 7.44 7.66 8.70 7.21 7.09 7.81 8.57 7.20 6.66 7.53

December 31, 2023 calculation

Receivables turnover = Revenue (ttm) ÷ Receivables
= $22,557,900K ÷ $2,467,900K
= 9.14

The receivables turnover ratio for Sherwin-Williams Co. has shown fluctuations over the past eight quarters. The ratio was highest in Q4 2023 at 9.34, indicating that the company collected its accounts receivable approximately 9.34 times during that quarter. This suggests that Sherwin-Williams Co. was more efficient in collecting payments from customers in Q4 2023 compared to previous quarters.

However, the ratio has varied between 6.97 and 9.34 over the period, with the lowest turnover occurring in Q2 2022. Overall, the trend indicates that the company has been relatively effective in managing its accounts receivable, with fluctuations possibly driven by seasonal factors or changes in credit policies. Further analysis and comparison with industry averages may provide more insights into Sherwin-Williams Co.'s receivables management efficiency.


Peer comparison

Dec 31, 2023

Company name
Symbol
Receivables turnover
Sherwin-Williams Co
SHW
9.14
Fastenal Company
FAST
6.75
Tractor Supply Company
TSCO

See also:

Sherwin-Williams Co Receivables Turnover (Quarterly Data)