Consolidated Edison Inc (ED)
Activity ratios
Short-term
Turnover ratios
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | Mar 31, 2024 | 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Inventory turnover | 13.69 | 13.92 | 14.60 | 15.60 | 15.48 | 17.17 | 18.32 | 19.17 | 16.23 | 13.53 | 15.06 | 15.77 | 13.75 | 14.37 | 15.59 | 15.91 | 14.32 | 14.57 | 15.73 | 15.92 |
| Receivables turnover | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Payables turnover | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Working capital turnover | 66.06 | 283.70 | 54.67 | — | 195.51 | — | 118.65 | 16.46 | 9.58 | — | — | 299.13 | 110.29 | — | — | — | — | — | — | — |
Consolidated Edison Inc's Inventory Turnover ratio has been relatively stable over the years, ranging from around 13.53 to 19.17. This indicates that the company efficiently manages its inventory by converting it into sales multiple times during the year.
The Receivables Turnover ratio data is missing for all periods, which may suggest that the company does not rely heavily on credit sales or has not provided this information.
Similarly, the Payables Turnover ratio data is not available, making it difficult to assess how efficiently the company pays its suppliers.
On the other hand, the Working Capital Turnover ratio shows significant fluctuations, with notable peaks and troughs. This ratio ranged from values as low as 9.58 to as high as 299.13, indicating fluctuations in how effectively the company uses its working capital to generate revenue.
Overall, the analysis of Consolidated Edison Inc's activity ratios reveals a mixed picture, with a stable inventory turnover but insufficient data to evaluate receivables and payables turnover. The significant fluctuations in the working capital turnover ratio suggest varying efficiency in utilizing working capital to drive business operations.
Average number of days
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | Mar 31, 2024 | 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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Days of inventory on hand (DOH) | days | 26.66 | 26.21 | 25.00 | 23.40 | 23.59 | 21.26 | 19.92 | 19.04 | 22.49 | 26.97 | 24.23 | 23.14 | 26.54 | 25.40 | 23.41 | 22.94 | 25.49 | 25.05 | 23.21 | 22.92 |
| Days of sales outstanding (DSO) | days | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Number of days of payables | days | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
Consolidated Edison Inc's Days of Inventory on Hand (DOH) has varied over the past years, ranging from a low of 19.04 days as of March 31, 2023, to a high of 26.97 days as of September 30, 2022. The DOH indicates the number of days a company takes to sell its average inventory balance.
The Days of Sales Outstanding (DSO) and Number of Days of Payables data are not available, which limits a comprehensive analysis of Consolidated Edison Inc's activity ratios related to sales collection efficiency and payment periods to suppliers.
In conclusion, while the DOH provides insights into inventory management efficiency, more detailed information on sales collection and payment periods would be necessary to fully assess Consolidated Edison Inc's overall working capital management.
Long-term
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | Mar 31, 2024 | 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fixed asset turnover | — | — | — | — | — | 27.28 | 0.32 | 0.34 | 0.34 | 0.30 | 0.29 | 0.29 | 0.28 | 0.28 | 0.27 | 0.27 | 0.26 | 0.27 | 0.27 | 0.27 |
| Total asset turnover | 0.22 | 0.22 | 0.22 | 0.22 | 0.22 | 0.24 | 0.24 | 2.13 | 0.23 | 0.23 | 0.22 | 0.22 | 0.22 | 0.21 | 0.21 | 0.20 | 0.20 | 0.21 | 0.21 | 0.20 |
The Fixed Asset Turnover ratio for Consolidated Edison Inc has shown a steady improvement from 0.27 in March 2020 to 0.34 in December 2022 before dropping slightly to 0.32 in June 2023. Notably, the ratio sharply declined to 27.28 in September 2023, which may indicate an anomaly in the data reported for that period. The ratio then showed no data in the subsequent periods.
On the other hand, the Total Asset Turnover ratio ranged from 0.20 to 0.23 between March 2020 and December 2022, demonstrating relatively stable performance. However, there was a significant increase to 2.13 in March 2023, suggesting a sharp jump in the efficiency of asset utilization during that period. The ratio reverted to 0.24 in June 2023 and remained steady at around 0.22 for the periods following that.
Overall, the Fixed Asset Turnover ratio indicates the efficiency of converting fixed assets into revenue, showing a generally increasing trend, while the Total Asset Turnover ratio measures the effectiveness of using all assets to generate revenue, displaying some fluctuations but also an overall improvement in asset utilization efficiency.