Crestwood Equity Partners LP (Crestwood Equity Partners LP) Days Inventory : 12.93 (As of Sep. 2023)

View and export this data going back to 2001. Start your Free Trial

What is Crestwood Equity Partners LP Days Inventory?

Days Inventory is also known as Days Sales of Inventory (DSI). Crestwood Equity Partners LP's Average Total Inventories for the three months ended in Sep. 2023 was $139 Mil. Crestwood Equity Partners LP's Cost of Goods Sold for the three months ended in Sep. 2023 was $982 Mil. Hence, Crestwood Equity Partners LP's Days Inventory for the three months ended in Sep. 2023 was 12.93.

The historical rank and industry rank for Crestwood Equity Partners LP's Days Inventory or its related term are showing as below:

CEQP' s Days Inventory Range Over the Past 10 Years
Min: 6.36 Med: 8.62 Max: 25.06
Current: 11.63

During the past 13 years, Crestwood Equity Partners LP's highest Days Inventory was 25.06. The lowest was 6.36. And the median was 8.62.

CEQP's Days Inventory is not ranked
in the Oil & Gas industry.
Industry Median: 31.5 vs CEQP: 11.63

Crestwood Equity Partners LP's Days Inventory increased from Sep. 2022 (10.87) to Sep. 2023 (12.93). It might indicate that Crestwood Equity Partners LP's sales slowed down.

Inventory Turnover measures how fast the company turns over its inventory within a year. Crestwood Equity Partners LP's Inventory Turnover for the three months ended in Sep. 2023 was 7.06.

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. Crestwood Equity Partners LP's Inventory-to-Revenue for the three months ended in Sep. 2023 was 0.12.

Crestwood Equity Partners LP Days Inventory Historical Data

The historical data trend for Crestwood Equity Partners LP'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.

Crestwood Equity Partners LP Days Inventory Chart

Crestwood Equity Partners LP Annual Data

Trend

Dec13

Dec14

Dec15

Dec16

Dec17

Dec18

Dec19

Dec20

Dec21

Dec22

Days Inventory

Get a 7-Day Free Trial

7.36

7.88

14.18

10.96

9.56

Crestwood Equity Partners LP Quarterly Data
	Dec18	Mar19	Jun19	Sep19	Dec19	Mar20	Jun20	Sep20	Dec20	Mar21	Jun21	Sep21	Dec21	Mar22	Jun22	Sep22	Dec22	Mar23	Jun23	Sep23
Days Inventory	Get a 7-Day Free Trial															10.87	10.54	9.44	10.48	12.93

Competitive Comparison of Crestwood Equity Partners LP's Days Inventory

For the Oil & Gas Midstream subindustry, Crestwood Equity Partners LP'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.

Crestwood Equity Partners LP's Days Inventory Distribution in the Oil & Gas Industry

For the Oil & Gas industry and Energy sector, Crestwood Equity Partners LP's Days Inventory distribution charts can be found below:

* The bar in red indicates where Crestwood Equity Partners LP's Days Inventory falls into.

Crestwood Equity Partners LP Days Inventory Calculation

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

Crestwood Equity Partners LP's Days Inventory for the fiscal year that ended in Dec. 2022 is calculated as

	Days Inventory (A: Dec. 2022 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (A: Dec. 2021 )	+	Total Inventories (A: Dec. 2022 ))	/	count )	/	Cost of Goods Sold (A: Dec. 2022 )	*	Days in Period
=	( (156.5	+	122.6)	/	2 )	/	5326	*	365
=	139.55					/	5326	*	365
=	9.56

Crestwood Equity Partners LP's Days Inventory for the quarter that ended in Sep. 2023 is calculated as:

	Days Inventory (Q: Sep. 2023 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (Q: Jun. 2023 )	+	Total Inventories (Q: Sep. 2023 ))	/	count )	/	Cost of Goods Sold (Q: Sep. 2023 )	*	Days in Period
=	( (98.3	+	179.9)	/	2 )	/	981.8	*	365 / 4
=	139.1					/	981.8	*	365 / 4
=	12.93

Crestwood Equity Partners LP (NYSE:CEQP) 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.

Crestwood Equity Partners LP's Inventory Turnover for the three months ended in Sep. 2023 is calculated as

Inventory Turnover	=	Cost of Goods Sold	/	Average Total Inventories
	=	981.8	/	139.1
	=	7.06

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.

Crestwood Equity Partners LP's Inventory to Revenue for the three months ended in Sep. 2023 is calculated as

Inventory-to-Revenue	=	Average Total Inventories	/	Revenue
	=	139.1	/	1139.4
	=	0.12

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.

Crestwood Equity Partners LP Days Inventory Related Terms

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

Crestwood Equity Partners LP (Crestwood Equity Partners LP) Business Description

Industry

GURUFOCUS.COM » STOCK LIST » Energy » Oil & Gas » Crestwood Equity Partners LP (NYSE:CEQP) » Definitions » Days Inventory

Comparable Companies

PAGP STNG HEP INSW GLNG NS HESM VNOM ETRN KNTK TSX:ENB EPD WMB ET LNG OKE KMI MPLX TSX:TRP CQP

Traded in Other Exchanges

N/A

Address

811 Main Street, Suite 3400, Houston, TX, USA, 77002

Website

https://www.crestwoodlp.com

Crestwood Equity Partners LP develops, acquires, owns or controls, and operates fee-based assets and operations within the energy midstream sector. The company has a diversified portfolio of crude oil and natural gas gathering, processing, storage, and transportation assets that connect fundamental energy supply with energy demand across North America. It has three reporting segments: Gathering and Processing North, Gathering, and Processing South, and Storage and Logistics. The company serves various producers in unconventional shale plays located across the United States. It generates maximum revenue from the Gathering and Processing North division.

Executives

Clay C Williams	director
Jeffrey M Cathey	officer: SVP, Controller	2440 PERSHING ROAD, SUITE 600, KANSAS CITY MO 64108
Black John William Iii	officer: EVP, Chief Financial Officer	811 MAIN STREET, SUITE 3400, HOUSTON TX 77002
Diaco Aviki	officer: EVP, Chief Operating Officer	811 MAIN STREET, SUITE 3400, HOUSTON TX 77002
Frances M Vallejo	director	1700 LINCOLN STREET, SUITE 3700, DENVER CO 80203
David Lumpkins	director	600 TRAVIS STREET, SUITE 3250, HOUSTON TX 77002
William H. Moore	officer: EVP - Corporate Strategy	TWO BRUSH CREEK BOULEVARD, SUITE 200, KANSAS CITY MO 64112
Halpin Robert Thornbury Iii	officer: President	CRESTWOOD MIDSTREAM PARTNERS LP, 717 TEXAS AVENUE, STE 3150, HOUSTON TX 77002
Joel Christian Lambert	officer: EVP, Legal, Safety Compliance	600 TRAVIS STREET, SUITE 6000, HOUSTON TX 77002
Robert G Phillips	director, officer: Founder, Chairman & CEO	2727 NORTH LOOP WEST, HOUSTON TX 77008
Janeen S Judah	director	10713 WEST SAM HOUSTON PARKWAY N, SUITE 800, HOUSTON TX 77064
Angela A Minas	director	3262 WESTHEIMER ROAD #627, HOUSTON TX 77098
Warren H Gfeller	director
Oasis Petroleum Inc.	10 percent owner	1001 FANNIN STREET, SUITE 1500, HOUSTON TX 77002
Gary Duane Reaves	director	ONE LAFAYETTE PLACE, THIRD FLOOR, GREENWICH CT 06830