Consolidated Edison Inc (ED)
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 | 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 |
| Total current assets | US$ in thousands | 6,537,000 | 5,939,000 | 6,203,000 | 5,868,000 | 12,972,000 | 5,733,000 | 6,016,000 | 5,462,000 | 5,551,000 | 5,096,000 | 5,110,000 | 4,587,000 | 5,301,000 | 4,204,000 | 4,564,000 | 5,026,000 | 4,272,000 | 3,581,000 | 3,707,000 | 3,781,000 |
| Total current liabilities | US$ in thousands | 6,462,000 | 6,050,000 | 6,072,000 | 4,895,000 | 11,336,000 | 6,890,000 | 6,823,000 | 5,415,000 | 5,427,000 | 5,255,000 | 5,557,000 | 6,559,000 | 7,354,000 | 7,160,000 | 6,705,000 | 6,311,000 | 6,287,000 | 6,219,000 | 5,969,000 | 6,348,000 |
| Working capital turnover | 195.51 | — | 118.65 | 16.46 | 9.58 | — | — | 299.13 | 110.29 | — | — | — | — | — | — | — | — | — | — | — |
December 31, 2023 calculation
Working capital turnover = Revenue (ttm) ÷ (Total current assets – Total current liabilities)
= $14,663,000K ÷ ($6,537,000K – $6,462,000K)
= 195.51
Consolidated Edison, Inc.'s working capital turnover fluctuated significantly over the past eight quarters. In Q4 2023, the working capital turnover ratio was 195.51, indicating that the company generated $195.51 in revenue for every dollar of working capital invested. This represents a substantial improvement compared to the previous quarters, where the ratios were relatively lower, with Q1 2023 at 16.46 and Q4 2022 at 9.58.
The working capital turnover spiked in Q1 2022 to 299.13, showcasing the company's ability to efficiently utilize its working capital to generate revenue. However, there are missing data points in Q3 2023 and Q3/Q2 2022, making it challenging to assess the overall trend accurately.
Overall, the fluctuating trend in working capital turnover suggests varying efficiency levels in managing working capital to generate revenue. It is essential for Consolidated Edison, Inc. to sustain or improve its working capital turnover ratio to ensure optimal utilization of resources and enhance financial performance.
Peer comparison
Dec 31, 2023