Crestwood Equity Partners LP New (CEQP) Fundamental Analysis & Valuation

NYSE:CEQP • US2263442087

28.26 USD
+1.18 (+4.36%)
At close: Nov 2, 2023
28.05 USD
-0.21 (-0.74%)
After Hours: 11/2/2023, 8:04:00 PM

This CEQP fundamental analysis includes valuation metrics, fair value assessment, financial health analysis, profitability trends, growth metrics and dividend sustainability analysis.

Fundamental Rating

3

CEQP gets a fundamental rating of 3 out of 10. The analysis compared the fundamentals against 207 industry peers in the Oil, Gas & Consumable Fuels industry. Both the profitability and financial health of CEQP have multiple concerns. CEQP has a decent growth rate and is not valued too expensively. CEQP also has an excellent dividend rating.


Dividend Valuation Growth Profitability Health

2

1. CEQP Profitability Analysis

1.1 Basic Checks

  • In the past year CEQP was profitable.
  • CEQP had a positive operating cash flow in the past year.
CEQP Yearly Net Income VS EBIT VS OCF VS FCFCEQP Yearly Net Income VS EBIT VS OCF VS FCFYearly Net Income VS EBIT VS OCF VS FCF 2016 2017 2018 2019 2020 2021 2022 0 200M -200M 400M

1.2 Ratios

  • CEQP has a worse Return On Assets (1.63%) than 74.21% of its industry peers.
  • The Return On Equity of CEQP (5.37%) is worse than 71.49% of its industry peers.
  • The Return On Invested Capital of CEQP (5.34%) is worse than 71.04% of its industry peers.
  • CEQP had an Average Return On Invested Capital over the past 3 years of 4.49%. This is significantly below the industry average of 22.51%.
  • The 3 year average ROIC (4.49%) for CEQP is below the current ROIC(5.34%), indicating increased profibility in the last year.
Industry RankSector Rank
ROA 1.63%
ROE 5.37%
ROIC 5.34%
ROA(3y)-1.92%
ROA(5y)-0.36%
ROE(3y)-7.04%
ROE(5y)-2.01%
ROIC(3y)4.49%
ROIC(5y)3.89%
CEQP Yearly ROA, ROE, ROICCEQP Yearly ROA, ROE, ROICYearly ROA, ROE, ROIC 2016 2017 2018 2019 2020 2021 2022 0 5 -5 10 -10

1.3 Margins

  • CEQP has a Profit Margin of 1.96%. This is in the lower half of the industry: CEQP underperforms 75.57% of its industry peers.
  • CEQP's Operating Margin of 7.64% is on the low side compared to the rest of the industry. CEQP is outperformed by 74.66% of its industry peers.
  • CEQP's Operating Margin has improved in the last couple of years.
  • CEQP has a Gross Margin of 20.02%. This is in the lower half of the industry: CEQP underperforms 71.49% of its industry peers.
  • CEQP's Gross Margin has improved in the last couple of years.
Industry RankSector Rank
OM 7.64%
PM (TTM) 1.96%
GM 20.02%
OM growth 3Y0.43%
OM growth 5Y24.56%
PM growth 3YN/A
PM growth 5YN/A
GM growth 3Y-5.82%
GM growth 5Y5.1%
CEQP Yearly Profit, Operating, Gross MarginsCEQP Yearly Profit, Operating, Gross MarginsYearly Profit, Operating, Gross Margins 2016 2017 2018 2019 2020 2021 2022 0 10 20

1

2. CEQP Health Analysis

2.1 Basic Checks

  • The Return on Invested Capital (ROIC) is below the Cost of Capital (WACC), so CEQP is destroying value.
  • CEQP has more shares outstanding than it did 1 year ago.
  • The debt/assets ratio for CEQP is higher compared to a year ago.
CEQP Yearly Shares OutstandingCEQP Yearly Shares OutstandingYearly Shares Outstanding 2016 2017 2018 2019 2020 2021 2022 20M 40M 60M 80M 100M
CEQP Yearly Total Debt VS Total AssetsCEQP Yearly Total Debt VS Total AssetsYearly Total Debt VS Total Assets 2016 2017 2018 2019 2020 2021 2022 2B 4B 6B

2.2 Solvency

  • CEQP has a debt to FCF ratio of 17.41. This is a negative value and a sign of low solvency as CEQP would need 17.41 years to pay back of all of its debts.
  • Looking at the Debt to FCF ratio, with a value of 17.41, CEQP is doing worse than 66.06% of the companies in the same industry.
  • A Debt/Equity ratio of 1.70 is on the high side and indicates that CEQP has dependencies on debt financing.
  • CEQP has a worse Debt to Equity ratio (1.70) than 80.09% of its industry peers.
Industry RankSector Rank
Debt/Equity 1.7
Debt/FCF 17.41
Altman-Z N/A
ROIC/WACC0.65
WACC8.16%
CEQP Yearly LT Debt VS Equity VS FCFCEQP Yearly LT Debt VS Equity VS FCFYearly LT Debt VS Equity VS FCF 2016 2017 2018 2019 2020 2021 2022 0 1B 2B 3B

2.3 Liquidity

  • CEQP has a Current Ratio of 1.37. This is a normal value and indicates that CEQP is financially healthy and should not expect problems in meeting its short term obligations.
  • CEQP's Current ratio of 1.37 is in line compared to the rest of the industry. CEQP outperforms 59.73% of its industry peers.
  • A Quick Ratio of 1.10 indicates that CEQP should not have too much problems paying its short term obligations.
  • CEQP has a Quick ratio (1.10) which is in line with its industry peers.
Industry RankSector Rank
Current Ratio 1.37
Quick Ratio 1.1
CEQP Yearly Current Assets VS Current LiabilitesCEQP Yearly Current Assets VS Current LiabilitesYearly Current Assets VS Current Liabilites 2016 2017 2018 2019 2020 2021 2022 200M 400M 600M

6

3. CEQP Growth Analysis

3.1 Past

  • The Earnings Per Share has grown by an impressive 764.29% over the past year.
  • The Revenue has decreased by -6.83% in the past year.
  • CEQP shows quite a strong growth in Revenue. Measured over the last years, the Revenue has been growing by 9.11% yearly.
EPS 1Y (TTM)764.29%
EPS 3YN/A
EPS 5YN/A
EPS Q2Q%728.57%
Revenue 1Y (TTM)-6.83%
Revenue growth 3Y23.55%
Revenue growth 5Y9.11%
Sales Q2Q%-29.48%

3.2 Future

  • CEQP is expected to show a strong growth in Earnings Per Share. In the coming years, the EPS will grow by 117.91% yearly.
  • CEQP is expected to show a strong growth in Revenue. In the coming years, the Revenue will grow by 24.06% yearly.
EPS Next Y761.73%
EPS Next 2Y187.44%
EPS Next 3Y117.91%
EPS Next 5YN/A
Revenue Next Year35.68%
Revenue Next 2Y16%
Revenue Next 3Y24.06%
Revenue Next 5YN/A

3.3 Evolution

  • The Revenue growth rate is accelerating: in the next years the growth will be better than in the last years.
CEQP Yearly Revenue VS EstimatesCEQP Yearly Revenue VS EstimatesYearly Revenue VS Estimates 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2B 4B 6B
CEQP Yearly EPS VS EstimatesCEQP Yearly EPS VS EstimatesYearly EPS VS Estimates 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 0 -10 -20 -30

4

4. CEQP Valuation Analysis

4.1 Price/Earnings Ratio

  • A Price/Earnings ratio of 30.39 indicates a quite expensive valuation of CEQP.
  • Based on the Price/Earnings ratio, CEQP is valued a bit more expensive than 76.47% of the companies in the same industry.
  • CEQP's Price/Earnings ratio indicates a similar valuation than the S&P500 average which is at 25.71.
  • CEQP is valuated correctly with a Price/Forward Earnings ratio of 16.12.
  • Compared to the rest of the industry, the Price/Forward Earnings ratio of CEQP indicates a slightly more expensive valuation: CEQP is more expensive than 66.52% of the companies listed in the same industry.
  • CEQP is valuated rather cheaply when we compare the Price/Forward Earnings ratio to 23.82, which is the current average of the S&P500 Index.
Industry RankSector Rank
PE 30.39
Fwd PE 16.12
CEQP Price Earnings VS Forward Price EarningsCEQP Price Earnings VS Forward Price Earnings ChartPrice Earnings - Forward Price Earnings PE FPE 10 20 30

4.2 Price Multiples

  • Based on the Enterprise Value to EBITDA ratio, CEQP is valued a bit more expensive than 60.63% of the companies in the same industry.
  • CEQP's Price/Free Cash Flow is on the same level as the industry average.
Industry RankSector Rank
P/FCF 15.84
EV/EBITDA 8.44
CEQP Per share dataCEQP EPS, Sales, OCF, FCF, BookValue per sharePer Share Data Per Share 10 20 30 40

4.3 Compensation for Growth

  • CEQP's low PEG Ratio(NY), which compensates the Price/Earnings for growth, indicates a rather cheap valuation of the company.
  • A more expensive valuation may be justified as CEQP's earnings are expected to grow with 117.91% in the coming years.
PEG (NY)0.04
PEG (5Y)N/A
EPS Next 2Y187.44%
EPS Next 3Y117.91%

8

5. CEQP Dividend Analysis

5.1 Amount

  • With a Yearly Dividend Yield of 9.27%, CEQP is a good candidate for dividend investing.
  • CEQP's Dividend Yield is rather good when compared to the industry average which is at 3.41. CEQP pays more dividend than 83.71% of the companies in the same industry.
  • CEQP's Dividend Yield is rather good when compared to the S&P500 average which is at 1.82.
Industry RankSector Rank
Dividend Yield 9.27%

5.2 History

  • On average, the dividend of CEQP grows each year by 8.30%, which is quite nice.
  • CEQP has paid a dividend for at least 10 years, which is a reliable track record.
  • CEQP has not decreased its dividend in the past 5 years, so it has a somewhat stable track record.
Dividend Growth(5Y)8.3%
Div Incr Years1
Div Non Decr Years5
CEQP Yearly Dividends per shareCEQP Yearly Dividends per shareYearly Dividends per share 2016 2017 2018 2019 2020 2021 2022 2023 1 2 3

5.3 Sustainability

  • 327.84% of the earnings are spent on dividend by CEQP. This is not a sustainable payout ratio.
  • CEQP's earnings are growing more than its dividend. This makes the dividend growth sustainable.
DP327.84%
EPS Next 2Y187.44%
EPS Next 3Y117.91%
CEQP Yearly Income VS Free CF VS DividendCEQP Yearly Income VS Free CF VS DividendYearly Income VS Free CF VS Dividend 2016 2017 2018 2019 2020 2021 2022 0 100M -100M 200M -200M 300M
CEQP Dividend Payout.CEQP Dividend Payout, showing the Payout Ratio.CEQP Dividend Payout.PayoutRetained Earnings

CEQP Fundamentals: All Metrics, Ratios and Statistics

Crestwood Equity Partners LP New

NYSE:CEQP (11/2/2023, 8:04:00 PM)

After market: 28.05 -0.21 (-0.74%)

28.26

+1.18 (+4.36%)

Chartmill FA Rating
GICS SectorEnergy
GICS IndustryGroupEnergy
GICS IndustryOil, Gas & Consumable Fuels
Earnings (Last)11-02
Earnings (Next)02-19
Inst Owners0.19%
Inst Owner Change0%
Ins Owners1.05%
Ins Owner Change0%
Market Cap2.97B
Revenue(TTM)5.25B
Net Income(TTM)103.10M
Analysts71.43
Price Target29.33 (3.79%)
Short Float %N/A
Short RatioN/A
Dividend
Industry RankSector Rank
Dividend Yield 9.27%
Yearly Dividend3.88
Dividend Growth(5Y)8.3%
DP327.84%
Div Incr Years1
Div Non Decr Years5
Ex-DateN/A
Surprises & Revisions
EPS beat(2)2
Avg EPS beat(2)106.63%
Min EPS beat(2)16.71%
Max EPS beat(2)196.55%
EPS beat(4)3
Avg EPS beat(4)-6.32%
Min EPS beat(4)-259.25%
Max EPS beat(4)196.55%
EPS beat(8)N/A
Avg EPS beat(8)N/A
EPS beat(12)N/A
Avg EPS beat(12)N/A
EPS beat(16)N/A
Avg EPS beat(16)N/A
Revenue beat(2)0
Avg Revenue beat(2)-16.44%
Min Revenue beat(2)-19.34%
Max Revenue beat(2)-13.53%
Revenue beat(4)0
Avg Revenue beat(4)-11.75%
Min Revenue beat(4)-19.34%
Max Revenue beat(4)-5.95%
Revenue beat(8)N/A
Avg Revenue beat(8)N/A
Revenue beat(12)N/A
Avg Revenue beat(12)N/A
Revenue beat(16)N/A
Avg Revenue beat(16)N/A
PT rev (1m)0.88%
PT rev (3m)-4.17%
EPS NQ rev (1m)3.67%
EPS NQ rev (3m)-1.79%
EPS NY rev (1m)0%
EPS NY rev (3m)41.8%
Revenue NQ rev (1m)0%
Revenue NQ rev (3m)-7.81%
Revenue NY rev (1m)-12.77%
Revenue NY rev (3m)-15.5%
Valuation
Industry RankSector Rank
PE 30.39
Fwd PE 16.12
P/S 0.57
P/FCF 15.84
P/OCF 6.54
P/B 1.55
P/tB 4.1
EV/EBITDA 8.44
EPS(TTM)0.93
EY3.29%
EPS(NY)1.75
Fwd EY6.2%
FCF(TTM)1.78
FCFY6.31%
OCF(TTM)4.32
OCFY15.3%
SpS49.98
BVpS18.26
TBVpS6.89
PEG (NY)0.04
PEG (5Y)N/A
Graham NumberN/A
Profitability
Industry RankSector Rank
ROA 1.63%
ROE 5.37%
ROCE 6.75%
ROIC 5.34%
ROICexc 5.34%
ROICexgc 6.69%
OM 7.64%
PM (TTM) 1.96%
GM 20.02%
FCFM 3.57%
ROA(3y)-1.92%
ROA(5y)-0.36%
ROE(3y)-7.04%
ROE(5y)-2.01%
ROIC(3y)4.49%
ROIC(5y)3.89%
ROICexc(3y)4.5%
ROICexc(5y)3.9%
ROICexgc(3y)5.71%
ROICexgc(5y)4.91%
ROCE(3y)5.69%
ROCE(5y)4.93%
ROICexgc growth 3Y16.02%
ROICexgc growth 5Y23.88%
ROICexc growth 3Y16.17%
ROICexc growth 5Y23.69%
OM growth 3Y0.43%
OM growth 5Y24.56%
PM growth 3YN/A
PM growth 5YN/A
GM growth 3Y-5.82%
GM growth 5Y5.1%
F-Score6
Asset Turnover0.83
Health
Industry RankSector Rank
Debt/Equity 1.7
Debt/FCF 17.41
Debt/EBITDA 4.43
Cap/Depr 79.4%
Cap/Sales 5.08%
Interest Coverage 250
Cash Conversion 61.61%
Profit Quality 181.86%
Current Ratio 1.37
Quick Ratio 1.1
Altman-Z N/A
F-Score6
WACC8.16%
ROIC/WACC0.65
Cap/Depr(3y)58.23%
Cap/Depr(5y)117.68%
Cap/Sales(3y)4.37%
Cap/Sales(5y)7.16%
Profit Quality(3y)N/A
Profit Quality(5y)N/A
High Growth Momentum
Growth
EPS 1Y (TTM)764.29%
EPS 3YN/A
EPS 5YN/A
EPS Q2Q%728.57%
EPS Next Y761.73%
EPS Next 2Y187.44%
EPS Next 3Y117.91%
EPS Next 5YN/A
Revenue 1Y (TTM)-6.83%
Revenue growth 3Y23.55%
Revenue growth 5Y9.11%
Sales Q2Q%-29.48%
Revenue Next Year35.68%
Revenue Next 2Y16%
Revenue Next 3Y24.06%
Revenue Next 5YN/A
EBIT growth 1Y38.99%
EBIT growth 3Y24.07%
EBIT growth 5Y35.9%
EBIT Next Year167.37%
EBIT Next 3Y44.84%
EBIT Next 5Y29.27%
FCF growth 1Y-60.26%
FCF growth 3YN/A
FCF growth 5Y25.47%
OCF growth 1Y-12.33%
OCF growth 3Y1.47%
OCF growth 5Y11.41%

Crestwood Equity Partners LP New / CEQP FAQ

What is the ChartMill fundamental rating of Crestwood Equity Partners LP New (CEQP) stock?

ChartMill assigns a fundamental rating of 3 / 10 to CEQP.


Can you provide the valuation status for Crestwood Equity Partners LP New?

ChartMill assigns a valuation rating of 3 / 10 to Crestwood Equity Partners LP New (CEQP). This can be considered as Overvalued.


How profitable is Crestwood Equity Partners LP New (CEQP) stock?

Crestwood Equity Partners LP New (CEQP) has a profitability rating of 3 / 10.


What is the earnings growth outlook for Crestwood Equity Partners LP New?

The Earnings per Share (EPS) of Crestwood Equity Partners LP New (CEQP) is expected to grow by 761.73% in the next year.


How sustainable is the dividend of Crestwood Equity Partners LP New (CEQP) stock?

The dividend rating of Crestwood Equity Partners LP New (CEQP) is 8 / 10 and the dividend payout ratio is 327.84%.