Consolidated Edison Inc (ED)
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 | 14,663,000 | 15,250,000 | 15,543,000 | 16,014,000 | 15,671,000 | 15,055,000 | 14,503,000 | 14,059,000 | 13,676,000 | 13,221,000 | 12,941,000 | 12,689,000 | 12,246,000 | 12,237,000 | 12,269,000 | 12,294,000 | 12,574,000 | 12,572,000 | 12,535,000 | 12,487,000 |
| Receivables | US$ in thousands | 2,406,000 | 2,020,000 | 1,663,000 | 2,040,000 | 2,192,000 | 2,095,000 | 2,042,000 | 2,160,000 | 1,934,000 | 1,924,000 | 1,714,000 | 1,953,000 | 1,720,000 | 1,530,000 | 1,348,000 | 1,334,000 | 1,252,000 | 1,259,000 | 1,125,000 | 1,351,000 |
| Receivables turnover | 6.09 | 7.55 | 9.35 | 7.85 | 7.15 | 7.19 | 7.10 | 6.51 | 7.07 | 6.87 | 7.55 | 6.50 | 7.12 | 8.00 | 9.10 | 9.22 | 10.04 | 9.99 | 11.14 | 9.24 |
December 31, 2023 calculation
Receivables turnover = Revenue (ttm) ÷ Receivables
= $14,663,000K ÷ $2,406,000K
= 6.09
The receivables turnover ratio for Consolidated Edison, Inc. has shown a fluctuating trend over the past eight quarters. The ratio ranged from a low of 3.87 in Q4 2023 to a high of 5.29 in Q2 2023.
On average, the company collected its accounts receivable approximately 4.59 times a year over the period analyzed. This indicates that Consolidated Edison, Inc. is efficient in collecting outstanding customer balances, with a moderate level of consistency.
A higher receivables turnover ratio suggests that the company has a more effective credit and collection process, turning its accounts receivable into cash more frequently. Conversely, a lower ratio may indicate issues with collecting payments in a timely manner.
Overall, a receivables turnover ratio of around 4.59 for Consolidated Edison, Inc. indicates a reasonable effectiveness in managing its accounts receivables. Further analysis and comparison with industry benchmarks could provide additional insights into the company's financial performance and efficiency in managing its receivables.
Peer comparison
Dec 31, 2023