GURUFOCUS.COM » STOCK LIST » Utilities » Utilities - Regulated » Consolidated Edison Inc (NYSE:ED) » Definitions » Inventory Turnover

Consolidated Edison (Consolidated Edison) Inventory Turnover

: 3.69 (As of Dec. 2023)
View and export this data going back to 1948. Start your Free Trial

Inventory Turnover measures how fast the company turns over its inventory within a year. It is calculated as Cost of Goods Sold divided by Total Inventories. Consolidated Edison's Cost of Goods Sold for the three months ended in Dec. 2023 was $1,706 Mil. Consolidated Edison's Average Total Inventories for the quarter that ended in Dec. 2023 was $462 Mil. Consolidated Edison's Inventory Turnover for the quarter that ended in Dec. 2023 was 3.69.

Days Inventory indicates the number of days of goods in sales that a company has in the inventory. Consolidated Edison's Days Inventory for the three months ended in Dec. 2023 was 24.71.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Consolidated Edison's Inventory-to-Revenue for the quarter that ended in Dec. 2023 was 0.13.


Consolidated Edison Inventory Turnover Historical Data

The historical data trend for Consolidated Edison's Inventory Turnover can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Consolidated Edison Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Inventory Turnover
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 16.36 14.40 15.15 17.19 15.11

Consolidated Edison Quarterly Data
Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23
Inventory Turnover Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 4.41 4.89 3.38 4.13 3.69

Consolidated Edison Inventory Turnover Calculation

Consolidated Edison's Inventory Turnover for the fiscal year that ended in Dec. 2023 is calculated as

Inventory Turnover (A: Dec. 2023 )
=Cost of Goods Sold / Average Total Inventories
=Cost of Goods Sold (A: Dec. 2023 ) / ((Total Inventories (A: Dec. 2022 ) + Total Inventories (A: Dec. 2023 )) / count )
=7258 / ((492 + 469) / 2 )
=7258 / 480.5
=15.11

Consolidated Edison's Inventory Turnover for the quarter that ended in Dec. 2023 is calculated as

Inventory Turnover (Q: Dec. 2023 )
=Cost of Goods Sold / Average Total Inventories
=Cost of Goods Sold (Q: Dec. 2023 ) / ((Total Inventories (Q: Sep. 2023 ) + Total Inventories (Q: Dec. 2023 )) / count )
=1706 / ((455 + 469) / 2 )
=1706 / 462
=3.69

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


Consolidated Edison  (NYSE:ED) Inventory Turnover Explanation

Inventory Turnover measures how fast the company turns over its inventory within a year. A higher Inventory Turnover means the company has light inventory. Therefore the company spends less money on storage, write downs, and obsolete inventory. If the inventory is too light, it may affect sales because the company may not have enough to meet demand.

1. Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Consolidated Edison's Days Inventory for the three months ended in Dec. 2023 is calculated as:

Days Inventory =Average Total Inventories (Q: Dec. 2023 )/Cost of Goods Sold (Q: Dec. 2023 )*Days in Period
=462/1706*365 / 4
=24.71

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Consolidated Edison's Inventory to Revenue for the quarter that ended in Dec. 2023 is calculated as

Inventory-to-Revenue=Average Total Inventories (Q: Dec. 2023 ) / Revenue (Q: Dec. 2023 )
=462 / 3444
=0.13

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


Be Aware

Usually retailers pile up their inventories at holiday seasons to meet the stronger demand. Therefore, the inventory of a particular quarter of a year should not be used to calculate Inventory Turnover. An average inventory is a better indication.


Consolidated Edison Inventory Turnover Related Terms

Thank you for viewing the detailed overview of Consolidated Edison's Inventory Turnover provided by GuruFocus.com. Please click on the following links to see related term pages.


Consolidated Edison (Consolidated Edison) Business Description

Traded in Other Exchanges
Address
4 Irving Place, Room 700, New York, NY, USA, 10003
Con Ed is a holding company for Consolidated Edison of New York, or CECONY, and Orange & Rockland, or O&R. These utilities provide steam, natural gas, and electricity to customers in southeastern New York—including New York City—and small parts of New Jersey. The two utilities generate nearly all of Con Ed's earnings following the sale of its clean energy business to RWE in early 2023.
Executives
Christina Ho officer: VP, Strategic Planning 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Deneen L Donnley officer: SVP and General Counsel 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Stuart Nachmias officer: President & CEO CET 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Robert Sanchez officer: SVP, Corporate Shared Services 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Timothy Cawley officer: President & CEO, O&R 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Robert N Hoglund officer: Senior Vice President Finance 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Joseph Miller officer: VP & Controller 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Nancy Shannon officer: SVP, Utility Shared Services 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Matthew Ketschke officer: President CECONY 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Gurudatta D Nadkarni officer: Vice President 4 IRVING PLACE, ROOM 1450-S, NEW YORK NY 10003
Jennifer Hensley officer: SVP, Corporate Affairs 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Frances Resheske officer: Senior VP Public Affairs 4 IRVING PLACE, NEW YORK NY 10003
De La Bastide Lore officer: SVP, Utility Shared Services 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
John Mcavoy officer: President & CEO, O&R 4 IRVING PLACE, ROOM 16-205, NEW YORK NY 10003
Yukari Saegusa officer: Vice President and Treasurer 4 IRVING PLACE, ROOM 1450-S, NEW YORK NY 10003