Consolidated Edison Inc (ED)

Days of sales outstanding (DSO)

		Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
Receivables turnover		6.09	7.15	7.07	7.12	10.04
DSO	days	59.89	51.06	51.62	51.27	36.34

December 31, 2023 calculation

DSO = 365 ÷ Receivables turnover
= 365 ÷ 6.09
= 59.89

Consolidated Edison, Inc.'s Days of Sales Outstanding (DSO) has shown fluctuations over the past five years. In 2023, the DSO increased to 94.29 days compared to 75.28 days in 2022, marking a significant rise in the average number of days it takes the company to collect its accounts receivable. This increase may indicate potential difficulties in collecting payments from customers promptly.

Comparing to 2021 and 2020, where the DSO was 82.90 days and 81.70 days, respectively, there seems to be a worsening trend in collections efficiency. In contrast, the DSO was lower at 61.39 days in 2019, indicating a more efficient collections process in that year.

Overall, the increasing trend in DSO over the years suggests a need for closer monitoring of accounts receivable management practices at Consolidated Edison, Inc. Efforts to streamline and accelerate the collections process may be necessary to improve cash flow and working capital management in the future.