NYSE:CEQP (USA) Also trade in: Germany

Crestwood Equity Partners LP

$ 36.15 -0.15 (-0.41%)
Volume: 137,807 Avg Vol (1m): 233,115
Market Cap $: 2.60 Bil Enterprise Value $: 4.55 Bil
P/E (TTM): 0.00 P/B: 1.43
Earnings Power Value -28.83
Net Current Asset Value -30.71
Tangible Book 15.77
Projected FCF 28.07
Median P/S Value 26
Graham Number 0
Peter Lynch Value 0
DCF (FCF Based) 0
DCF (Earnings Based) 0
YTD (-%)

Financial Strength : 4/10

GuruFocus Financial Strength Rank measures how strong a company's financial situation is . It is based on these factors
1. The debt burden that the company has as measured by its Interest coverage (current year).
2. Debt to revenue ratio. The lower, the better
3. Altman Z-score.
A company ranks high with financial strength is likely to withstand any business slowdowns and recessions.
Current vs industry vs history
Equity-to-Asset 0.42
Equity-to-Asset ranked higher than
62.62% of 107 companies
in the Oil & Gas Midstream industry.
Industry Max: 0.93, Med: 0.42, Min: -0.68
CEQP: 0.42
Ranked among companies with meaningful Equity-to-Asset only.
Equity-to-Asset range over the past 10 years
Min: -0.07, Med: 0.41, Max: 0.65
Current: 0.42
-0.07
0.65
Debt-to-Equity 0.98
Debt-to-Equity ranked higher than
62.22% of 90 companies
in the Oil & Gas Midstream industry.
Industry Max: 47.17, Med: 0.95, Min: 0.01
CEQP: 0.98
Ranked among companies with meaningful Debt-to-Equity only.
Debt-to-Equity range over the past 10 years
Min: -8.12, Med: 1.05, Max: 31.72
Current: 0.98
-8.12
31.72
Debt-to-EBITDA 5.71
Debt-to-EBITDA ranked lower than
96.94% of 98 companies
in the Oil & Gas Midstream industry.
Industry Max: 21.29, Med: 4.43, Min: 0.09
CEQP: 5.71
Ranked among companies with meaningful Debt-to-EBITDA only.
Debt-to-EBITDA range over the past 10 years
Min: -1.34, Med: 5.79, Max: 12.07
Current: 5.71
-1.34
12.07
Interest Coverage 1.31
Interest Coverage ranked lower than
100.00% of 105 companies
in the Oil & Gas Midstream industry.
Industry Max: 10000, Med: 4.51, Min: 0.3
CEQP: 1.31
Ranked among companies with meaningful Interest Coverage only.
Interest Coverage range over the past 10 years
Min: 0.75, Med: 1.41, Max: 2.52
Current: 1.31
0.75
2.52
Piotroski F-Score 6
0
1
2
3
4
5
6
7
8
9
Altman Z-Score 1.54
DISTRESS
GREY
SAFE
Beneish M-Score -3.25
Not Manipulator
Manipulator
WACC vs ROIC %
ROIC 3.53%
WACC 9.06%

Profitability & Growth : 4/10

GuruFocus Profitability Rank ranks how profitable a company is and how likely the company's business will stay that way.
Current vs industry vs history
Operating Margin % 3.86
Operating Margin ranked lower than
93.52% of 108 companies
in the Oil & Gas Midstream industry.
Industry Max: 587.6, Med: 21.95, Min: -65855.19
CEQP: 3.86
Ranked among companies with meaningful Operating Margin only.
Operating Margin range over the past 10 years
Min: 2.11, Med: 5.08, Max: 11.3
Current: 3.86
2.11
11.3
Net Margin % 0.91
Net Margin ranked lower than
92.59% of 108 companies
in the Oil & Gas Midstream industry.
Industry Max: 168.31, Med: 10.85, Min: -37757.79
CEQP: 0.91
Ranked among companies with meaningful Net Margin only.
Net Margin range over the past 10 years
Min: -63.31, Med: 1.11, Max: 27.65
Current: 0.91
-63.31
27.65
ROE % -1.56
ROE ranked lower than
92.31% of 104 companies
in the Oil & Gas Midstream industry.
Industry Max: 53026.41, Med: 8.53, Min: -3295.45
CEQP: -1.56
Ranked among companies with meaningful ROE only.
ROE range over the past 10 years
Min: -94.54, Med: 1.83, Max: 50.62
Current: -1.56
-94.54
50.62
ROA % 0.72
ROA ranked lower than
93.81% of 113 companies
in the Oil & Gas Midstream industry.
Industry Max: 19039.05, Med: 4.17, Min: -3295.45
CEQP: 0.72
Ranked among companies with meaningful ROA only.
ROA range over the past 10 years
Min: -23.44, Med: 0.61, Max: 20
Current: 0.72
-23.44
20
ROC (Joel Greenblatt) % 7.40
ROC (Joel Greenblatt) ranked lower than
91.74% of 109 companies
in the Oil & Gas Midstream industry.
Industry Max: 329050, Med: 9.5, Min: -25437.45
CEQP: 7.4
Ranked among companies with meaningful ROC (Joel Greenblatt) only.
ROC (Joel Greenblatt) range over the past 10 years
Min: -58.56, Med: 4.43, Max: 38.47
Current: 7.4
-58.56
38.47
3-Year Total Revenue Growth Rate 11.50
3-Year Revenue Growth Rate ranked lower than
91.84% of 98 companies
in the Oil & Gas Midstream industry.
Industry Max: 397.4, Med: -1.4, Min: -100
CEQP: -15.5
Ranked among companies with meaningful 3-Year Revenue Growth Rate only.
3-Year Revenue Growth Rate range over the past 10 years
Min: -35.9, Med: 4.65, Max: 182.4
Current: -15.5
-35.9
182.4
3-Year EPS w/o NRI Growth Rate 37.80
3-Year EPS w/o NRI Growth Rate ranked lower than
100.00% of 80 companies
in the Oil & Gas Midstream industry.
Industry Max: 202.3, Med: 7.3, Min: -100
CEQP: 37.8
Ranked among companies with meaningful 3-Year EPS w/o NRI Growth Rate only.
3-Year EPS w/o NRI Growth Rate range over the past 10 years
Min: 0, Med: -32.1, Max: 51.6
Current: 37.8
0
51.6

» CEQP's 30-Y Financials

Financials (Next Earnings Date: 2019-07-31)

Guru Trades Click for details

» Details

Insider Trades

SEC Filings

Gurus Latest Trades with NYSE:CEQP

» Interactive Chart

Peter Lynch Chart

Business Description

Industry Oil & Gas - Midstream » Oil & Gas Midstream    NAICS : 213112    SIC : 1389
Compare NYSE:TCP BOG:PROMIGAS NYSE:GEL HKSE:03633 TSX:GEI NYSE:HEP NYSE:NS XBRU:FLUX NAS:ALTM TSX:ALA NYSE:BPMP NYSE:PAGP NYSE:NBLX SZSE:002267 XKAZ:KZTO TSX:KML NYSE:HESM NYSE:PBFX HKSE:00934 NYSE:SEMG
Traded in other countries IY12.Germany
Address 811 Main Street, Suite 3400, Houston, TX, USA, 77002
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, Marketing, Supply and Logistics Operations, and Storage and Transportation. It serves various producers in unconventional shale plays located in across the United States. The firm also owns gas systems in the Marcellus, Barnett, Granite Wash, and dry gas gathering systems in the Barnett, Fayetteville and Haynesville/Bossier Shale plays.

Ratios

Current vs industry vs history
Forward PE Ratio 43.48
Forward P/E ranked lower than
100.00% of 70 companies
in the Oil & Gas Midstream industry.
Industry Max: 2500, Med: 18.12, Min: 7.14
CEQP: 43.48
Ranked among companies with meaningful Forward P/E only.
N/A
PB Ratio 1.43
PB Ratio ranked higher than
78.10% of 105 companies
in the Oil & Gas Midstream industry.
Industry Max: 9493.33, Med: 1.74, Min: 0.18
CEQP: 1.43
Ranked among companies with meaningful PB Ratio only.
PB Ratio range over the past 10 years
Min: 0.22, Med: 1.21, Max: 28.68
Current: 1.43
0.22
28.68
PS Ratio 0.76
PS Ratio ranked higher than
86.67% of 105 companies
in the Oil & Gas Midstream industry.
Industry Max: 388, Med: 2.3, Min: 0.03
CEQP: 0.76
Ranked among companies with meaningful PS Ratio only.
PS Ratio range over the past 10 years
Min: 0.08, Med: 0.55, Max: 1.45
Current: 0.76
0.08
1.45
Price-to-Operating-Cash-Flow 10.97
Price-to-Operating-Cash-Flow ranked higher than
53.19% of 94 companies
in the Oil & Gas Midstream industry.
Industry Max: 122.64, Med: 7.92, Min: 1.24
CEQP: 10.97
Ranked among companies with meaningful Price-to-Operating-Cash-Flow only.
Price-to-Operating-Cash-Flow range over the past 10 years
Min: 0.5, Med: 5.52, Max: 269.57
Current: 10.97
0.5
269.57
EV-to-EBIT 31.00
EV-to-EBIT ranked lower than
100.00% of 96 companies
in the Oil & Gas Midstream industry.
Industry Max: 142.02, Med: 18.53, Min: 2.17
CEQP: 31
Ranked among companies with meaningful EV-to-EBIT only.
EV-to-EBIT range over the past 10 years
Min: -1729.3, Med: 11.7, Max: 504.1
Current: 31
-1729.3
504.1
EV-to-EBITDA 14.67
EV-to-EBITDA ranked lower than
94.17% of 103 companies
in the Oil & Gas Midstream industry.
Industry Max: 142.02, Med: 12.84, Min: 2.17
CEQP: 14.67
Ranked among companies with meaningful EV-to-EBITDA only.
EV-to-EBITDA range over the past 10 years
Min: -6.6, Med: 11.9, Max: 59.3
Current: 14.67
-6.6
59.3
EV-to-Revenue 1.35
EV-to-Revenue ranked higher than
87.85% of 107 companies
in the Oil & Gas Midstream industry.
Industry Max: 1949.94, Med: 4.87, Min: 0.08
CEQP: 1.35
Ranked among companies with meaningful EV-to-Revenue only.
EV-to-Revenue range over the past 10 years
Min: 0.8, Med: 1.4, Max: 6.1
Current: 1.35
0.8
6.1
Shiller PE Ratio 38.93
Shiller PE Ratio ranked higher than
77.27% of 44 companies
in the Oil & Gas Midstream industry.
Industry Max: 233.51, Med: 19.42, Min: 6.17
CEQP: 38.93
Ranked among companies with meaningful Shiller PE Ratio only.
Shiller PE Ratio range over the past 10 years
Min: 1.69, Med: 12.13, Max: 39.82
Current: 38.93
1.69
39.82
Current Ratio 0.92
Current Ratio ranked higher than
52.78% of 108 companies
in the Oil & Gas Midstream industry.
Industry Max: 14, Med: 1, Min: 0.02
CEQP: 0.92
Ranked among companies with meaningful Current Ratio only.
Current Ratio range over the past 10 years
Min: 0.8, Med: 1.14, Max: 3.88
Current: 0.92
0.8
3.88
Quick Ratio 0.80
Quick Ratio ranked lower than
51.85% of 108 companies
in the Oil & Gas Midstream industry.
Industry Max: 14, Med: 0.93, Min: 0.02
CEQP: 0.8
Ranked among companies with meaningful Quick Ratio only.
Quick Ratio range over the past 10 years
Min: 0.46, Med: 0.88, Max: 3.36
Current: 0.8
0.46
3.36
Days Inventory 7.35
Days Inventory ranked higher than
71.25% of 80 companies
in the Oil & Gas Midstream industry.
Industry Max: 187.09, Med: 13.28, Min: 0.02
CEQP: 7.35
Ranked among companies with meaningful Days Inventory only.
Days Inventory range over the past 10 years
Min: 6.36, Med: 17.21, Max: 36.57
Current: 7.35
6.36
36.57
Days Sales Outstanding 27.65
Days Sales Outstanding ranked lower than
67.71% of 96 companies
in the Oil & Gas Midstream industry.
Industry Max: 135.52, Med: 34.27, Min: 0.35
CEQP: 27.65
Ranked among companies with meaningful Days Sales Outstanding only.
Days Sales Outstanding range over the past 10 years
Min: 19.13, Med: 28.96, Max: 105.56
Current: 27.65
19.13
105.56
Days Payable 27.12
Days Payable ranked lower than
63.16% of 76 companies
in the Oil & Gas Midstream industry.
Industry Max: 742.7, Med: 48.11, Min: 0.04
CEQP: 27.12
Ranked among companies with meaningful Days Payable only.
Days Payable range over the past 10 years
Min: 23.57, Med: 29.63, Max: 118.21
Current: 27.12
23.57
118.21

Dividend & Buy Back

Current vs industry vs history
Dividend Yield % 6.64
Trailing Dividend Yield ranked lower than
55.17% of 116 companies
in the Oil & Gas Midstream industry.
Industry Max: 145.96, Med: 8.48, Min: 0.35
CEQP: 6.64
Ranked among companies with meaningful Trailing Dividend Yield only.
Trailing Dividend Yield range over the past 10 years
Min: 3.53, Med: 14.71, Max: 67.99
Current: 6.64
3.53
67.99
3-Year Dividend Growth Rate (Per Share) -24.20
3-Year Dividend Growth Rate ranked lower than
94.03% of 67 companies
in the Oil & Gas Midstream industry.
Industry Max: 101.8, Med: 7.8, Min: -100
CEQP: -24.2
Ranked among companies with meaningful 3-Year Dividend Growth Rate only.
N/A
Forward Dividend Yield % 6.64
Forward Dividend Yield ranked lower than
58.68% of 121 companies
in the Oil & Gas Midstream industry.
Industry Max: 200.14, Med: 8.78, Min: 0.41
CEQP: 6.64
Ranked among companies with meaningful Forward Dividend Yield only.
N/A
Yield-on-Cost (5-Year) % 1.75
Yield-on-Cost (5y) ranked lower than
100.00% of 121 companies
in the Oil & Gas Midstream industry.
Industry Max: 145.96, Med: 13.08, Min: 0.17
CEQP: 1.75
Ranked among companies with meaningful Yield-on-Cost (5y) only.
Yield-on-Cost (5y) range over the past 10 years
Min: 0.93, Med: 3.88, Max: 17.93
Current: 1.75
0.93
17.93
3-Year Share Buyback Rate -1.30
3-Year Share Buyback Rate ranked lower than
93.83% of 81 companies
in the Oil & Gas Midstream industry.
Industry Max: 35.2, Med: -8.9, Min: -152
CEQP: -1.3
Ranked among companies with meaningful 3-Year Share Buyback Rate only.
3-Year Share Buyback Rate range over the past 10 years
Min: -73.3, Med: -27.65, Max: -0.1
Current: -1.3
-73.3
-0.1

Valuation & Return

Current vs industry vs history
Price-to-Tangible-Book 2.29
Price-to-Tangible-Book ranked higher than
67.02% of 94 companies
in the Oil & Gas Midstream industry.
Industry Max: 9493.33, Med: 2.29, Min: 0.18
CEQP: 2.29
Ranked among companies with meaningful Price-to-Tangible-Book only.
Price-to-Tangible-Book range over the past 10 years
Min: 0.92, Med: 3.17, Max: 83.87
Current: 2.29
0.92
83.87
Price-to-Projected-FCF 1.28
Price-to-Intrinsic-Value-Projected-FCF ranked higher than
73.47% of 49 companies
in the Oil & Gas Midstream industry.
Industry Max: 601, Med: 1.84, Min: 0.39
CEQP: 1.28
Ranked among companies with meaningful Price-to-Intrinsic-Value-Projected-FCF only.
Price-to-Intrinsic-Value-Projected-FCF range over the past 10 years
Min: 0.14, Med: 0.88, Max: 14.09
Current: 1.28
0.14
14.09
Price-to-Median-PS-Value 1.39
Price-to-Median-PS-Value ranked lower than
57.45% of 94 companies
in the Oil & Gas Midstream industry.
Industry Max: 3.67, Med: 0.94, Min: 0.07
CEQP: 1.39
Ranked among companies with meaningful Price-to-Median-PS-Value only.
Price-to-Median-PS-Value range over the past 10 years
Min: 0.25, Med: 0.96, Max: 2.61
Current: 1.39
0.25
2.61
Earnings Yield (Joel Greenblatt) % 3.23
Earnings Yield (Greenblatt) ranked lower than
90.09% of 111 companies
in the Oil & Gas Midstream industry.
Industry Max: 46.08, Med: 4.95, Min: -120.72
CEQP: 3.23
Ranked among companies with meaningful Earnings Yield (Greenblatt) only.
Earnings Yield (Greenblatt) range over the past 10 years
Min: -69.5, Med: 1.9, Max: 28.8
Current: 3.23
-69.5
28.8
Forward Rate of Return (Yacktman) % -37.71
Forward Rate of Return ranked lower than
98.25% of 57 companies
in the Oil & Gas Midstream industry.
Industry Max: 28.88, Med: 2.64, Min: -174.01
CEQP: -37.71
Ranked among companies with meaningful Forward Rate of Return only.
Forward Rate of Return range over the past 10 years
Min: -43.3, Med: -1.9, Max: 31.8
Current: -37.71
-43.3
31.8

More Statistics

Revenue (TTM) (Mil) $ 3,374.3
EPS (TTM) $ -0.41
Beta 1.42
Volatility % 36.95
52-Week Range $ 26.55 - 40.55
Shares Outstanding (Mil) 71.84

Analyst Estimate

Piotroski F-Score Details

Piotroski F-Score 6
Positive ROA Y
Positive CFROA Y
Higher ROA yoy Y
CFROA > ROA Y
Lower Leverage yoy N
Higher Current Ratio yoy N
Less Shares Outstanding yoy Y
Higher Gross Margin yoy Y
Higher Asset Turnover yoy N