GURUFOCUS.COM » STOCK LIST » USA » NYSE » NiSource Inc (NYSE:NI) » Definitions » Days Inventory
Switch to:

NiSource Days Inventory

: 44.98 (As of Jun. 2022)
View and export this data going back to 1988. Start your Free Trial

Days Inventory is also known as Days Sales of Inventory (DSI). NiSource's Average Total Inventories for the three months ended in Jun. 2022 was $377 Mil. NiSource's Cost of Goods Sold for the three months ended in Jun. 2022 was $766 Mil. Hence, NiSource's Days Inventory for the three months ended in Jun. 2022 was 44.98.

The historical rank and industry rank for NiSource's Days Inventory or its related term are showing as below:

NI' s Days Inventory Range Over the Past 10 Years
Min: 39.64   Med: 57.25   Max: 68.65
Current: 45.68

During the past 13 years, NiSource's highest Days Inventory was 68.65. The lowest was 39.64. And the median was 57.25.

NI's Days Inventory is ranked worse than
77.23% of 426 companies
in the Utilities - Regulated industry
Industry Median: 21.11 vs NI: 45.68

NiSource's Days Inventory increased from Jun. 2021 (44.54) to Jun. 2022 (44.98). It might indicate that NiSource's sales slowed down.

Inventory Turnover measures how fast the company turns over its inventory within a year. NiSource's Inventory Turnover for the three months ended in Jun. 2022 was 2.03.

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. NiSource's Inventory-to-Revenue for the three months ended in Jun. 2022 was 0.32.


NiSource Days Inventory Historical Data

The historical data trend for NiSource's Days Inventory 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.

NiSource Annual Data
Trend Dec12 Dec13 Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21
Days Inventory
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 56.47 39.64 53.51 55.92 57.65

NiSource Quarterly Data
Sep17 Dec17 Mar18 Jun18 Sep18 Dec18 Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22
Days Inventory 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 44.54 65.44 51.50 31.57 44.98

Competitive Comparison

For the Utilities - Regulated Gas subindustry, NiSource's Days Inventory, along with its competitors' market caps and Days Inventory data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.

   

NiSource Days Inventory Distribution

For the Utilities - Regulated industry and Utilities sector, NiSource's Days Inventory distribution charts can be found below:

* The bar in red indicates where NiSource's Days Inventory falls into.



NiSource Days Inventory Calculation

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

NiSource's Days Inventory for the fiscal year that ended in Dec. 2021 is calculated as

Days Inventory (A: Dec. 2021 )
=Average Total Inventories / Cost of Goods Sold*Days in Period
=( (Total Inventories (A: Dec. 2020 ) + Total Inventories (A: Dec. 2021 )) / count ) / Cost of Goods Sold (A: Dec. 2021 )*Days in Period
=( (401.1 + 498.7) / 2 ) / 2848.3*365
=449.9 / 2848.3*365
=57.65

NiSource's Days Inventory for the quarter that ended in Jun. 2022 is calculated as:

Days Inventory (Q: Jun. 2022 )
=Average Total Inventories / Cost of Goods Sold*Days in Period
=( (Total Inventories (Q: Mar. 2022 ) + Total Inventories (Q: Jun. 2022 )) / count ) / Cost of Goods Sold (Q: Jun. 2022 )*Days in Period
=( (263.2 + 491.6) / 2 ) / 765.6*365 / 4
=377.4 / 765.6*365 / 4
=44.98

* 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.


NiSource  (NYSE:NI) Days Inventory Explanation

Days Inventory indicates the liquidity of the inventory. Generally, a lower Days Inventory is preferred as it indicates a shorter duration to clear off the inventory. An increase of the ratio may indicate the company's sales slowed. Similar ratios related to Days Inventory are:

1. Inventory Turnover measures how fast the company turns over its inventory within a year.

NiSource's Inventory Turnover for the three months ended in Jun. 2022 is calculated as

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.

NiSource's Inventory to Revenue for the three months ended in Jun. 2022 is calculated as

* 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

A lot of business are seasonable. It makes more sense to compare Days Inventory from the same period in the previous year instead of from the previous quarter.


NiSource Days Inventory Related Terms

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


NiSource Business Description

NiSource logo
Address
801 East 86th Avenue, Merrillville, IN, USA, 46410
NiSource is one of the nation's largest natural gas distribution companies with approximately 3.5 million customers in Indiana, Kentucky, Maryland, Ohio, Pennsylvania, and Virginia. NiSource's electric utility transmits and distributes electricity in northern Indiana to about 500,000 customers. The regulated electric utility also owns more than 3,000 megawatts of generation capacity, most of which is now coal-fired but is being replaced by natural gas and renewable energy.
Executives
Johnson William D director 77 BEALE ST PO BOX 770000 SAN FRANCISCO CA 94177
Lee Cassandra S. director 7615 ZIONSVILLE RD INDIANAPOLIS IN 46268
Barbour Sondra L director 6801 ROCKLEDGE DRIVE BETHESDA MD 20817
Cuccia Kimberly S officer: VP, Interim GC & Corp Sec 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Gode Gunnar officer: VP & Chief Accounting Officer 1000 MAINE AVENUE, SW WASHINGTON DC 20024
D'angelo Anne-marie W officer: SVP, Gen Counsel & Corp Sec 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Anderson Shawn officer: SVP & Chief Strategy & Risk 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Creekmur Daniel A officer: SVP & President, Gas Utilities 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Hooper Michael officer: SVP and President, NIPSCO 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Yates Lloyd M director 1N 2ND ST HARTSVILLE SC 29550
Shafer Charles Edward Ii officer: SVP & Chief Safety Officer 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Keener Kenneth E officer: SVP HR & Chief HR Officer 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Hersman Deborah director 801 E. 86TH AVENUE MERRILLVILLE IN 46410
Bunting Theodore H Jr director P. O. BOX 61000 NEW ORLEANS LA 70161
Kempic Mark officer: Chief Transformation Officer 801 E. 86TH AVENUE MERRILLVILLE IN 46410

NiSource Headlines

Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)