Cable One Inc (CABO)
Days of sales outstanding (DSO)
| 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Receivables turnover | 15.86 | 17.46 | 20.37 | 33.12 | 20.28 | 23.39 | 19.98 | 26.05 | 17.88 | 18.71 | 18.70 | 28.68 | 16.35 | 13.01 | 18.49 | 21.27 | 26.69 | 605.78 | 390.11 | 222.57 | |
| DSO | days | 23.02 | 20.90 | 17.92 | 11.02 | 18.00 | 15.60 | 18.27 | 14.01 | 20.42 | 19.51 | 19.52 | 12.73 | 22.32 | 28.06 | 19.74 | 17.16 | 13.67 | 0.60 | 0.94 | 1.64 |
December 31, 2023 calculation
DSO = 365 ÷ Receivables turnover
= 365 ÷ 15.86
= 23.02
Based on the data provided, Cable One Inc's days of sales outstanding (DSO) have shown some fluctuations in recent quarters. The DSO increased from 10.82 days in Q1 2022 to 15.56 days in Q4 2022, indicating a slower collection of accounts receivable. However, the trend reversed in Q1 2023, with the DSO decreasing significantly to 9.90 days, suggesting a more efficient collection process.
In the most recent quarter, Q4 2023, the DSO increased to 20.44 days, signaling a potential delay in collecting sales revenue from customers. The rising DSO in Q4 2023 compared to the previous quarters may indicate a need for closer monitoring of accounts receivable and potential credit risks.
Overall, Cable One Inc should further investigate the reasons behind the increase in DSO in Q4 2023 to ensure timely collections and maintain healthy cash flow levels. It is essential for the company to strike a balance between extending credit terms to customers and promptly collecting outstanding payments to optimize its working capital management.
Peer comparison
Dec 31, 2023