CEQP · Crestwood Equity Partners LP - Financials
Annual line items from SEC XBRL filings, sourced from EDGAR's Company Facts API with fallback to the quarterly Financial Statement Data Sets. See issuer overview for Form 4 activity and 10-K signals.
Income Statement
| Line item | FY 2022 | FY 2021 | FY 2020 | FY 2019 | FY 2018 | FY 2017 |
|---|---|---|---|---|---|---|
| Revenue | $6.00B | $4.57B | $2.25B | $3.18B | $3.65B | $3.88B |
| Cost of Revenue | $5.00B | $3.84B | $1.60B | $2.54B | $3.13B | $3.37B |
| Gross Profit | $1.00B | $725.10M | $653.80M | $637.00M | $524.70M | $506.20M |
| R&D | - | - | - | - | - | - |
| SG&A | $130.40M | $97.60M | $91.50M | $103.40M | $88.10M | $96.50M |
| Total Operating Expenses | $767.80M | $502.40M | $567.00M | $234.80M | $411.20M | $424.20M |
| D&A | - | - | - | - | - | - |
| Operating Income | $235.80M | $222.70M | $86.80M | $402.20M | $113.50M | ($79.40M) |
| Interest Expense | $177.40M | $132.10M | $133.60M | $115.40M | $99.20M | $99.40M |
| Income Tax | $1.90M | $200.0K | $400.0K | $300.0K | $100.0K | ($800.0K) |
| Net Income | $31.30M | ($78.50M) | ($56.10M) | $285.10M | $50.80M | ($191.90M) |
| EPS - Basic | - | ($2.11) | ($1.59) | ($0.13) | - | - |
| EPS - Diluted | - | ($2.11) | ($1.59) | ($3.64) | - | - |
Balance Sheet
| Line item | FY 2022 | FY 2021 | FY 2020 | FY 2019 | FY 2018 | FY 2017 |
|---|---|---|---|---|---|---|
| Cash & Equivalents | $7.50M | $13.30M | $14.00M | $25.70M | $900.0K | $1.30M |
| Accounts Receivable | $432.20M | $378.00M | $262.20M | $242.20M | $251.50M | $442.70M |
| Inventory | $122.60M | $156.50M | $89.10M | $53.70M | $64.60M | $68.40M |
| Accounts Payable | $305.50M | $336.50M | $160.30M | $189.20M | $213.00M | $349.40M |
| Current Assets | $653.80M | $604.70M | $405.90M | $376.40M | $379.30M | $530.50M |
| Total Assets | $6.57B | $4.45B | $5.24B | $5.35B | $4.29B | $4.28B |
| Current Liabilities | $510.20M | $598.40M | $377.80M | $357.80M | $332.10M | $505.10M |
| Long-term Debt | $3.38B | $2.05B | $2.48B | $2.33B | $1.75B | $1.49B |
| Total Liabilities | $4.23B | $2.91B | $3.16B | $2.99B | - | - |
| Stockholders' Equity | - | - | - | - | - | - |
| Retained Earnings | - | - | - | - | - | - |
Cash Flow
| Line item | FY 2022 | FY 2021 | FY 2020 | FY 2019 | FY 2018 | FY 2017 |
|---|---|---|---|---|---|---|
| Operating Cash Flow | $439.20M | $426.70M | $408.10M | $420.40M | $253.60M | $255.90M |
| Investing Cash Flow | ($391.10M) | $568.90M | ($273.30M) | ($943.70M) | ($241.20M) | $38.70M |
| Financing Cash Flow | ($53.90M) | ($996.30M) | ($146.50M) | $531.80M | $3.50M | ($294.90M) |
| CapEx | $229.30M | $83.20M | $168.30M | $455.50M | $305.50M | $188.40M |
| Free Cash Flow | $209.90M | $343.50M | $239.80M | ($35.10M) | ($51.90M) | $67.50M |
Ratios
| Metric | FY 2022 | FY 2021 | FY 2020 | FY 2019 | FY 2018 | FY 2017 |
|---|---|---|---|---|---|---|
| Profitability | ||||||
| Gross margin | 16.7% | 15.9% | 29.0% | 20.0% | 14.4% | 13.0% |
| Operating margin | 3.9% | 4.9% | 3.9% | 12.6% | 3.1% | -2.0% |
| EBITDA margin | - | - | - | - | - | - |
| Net margin | 0.5% | -1.7% | -2.5% | 9.0% | 1.4% | -4.9% |
| Free cash flow margin | 3.5% | 7.5% | 10.6% | -1.1% | -1.4% | 1.7% |
| FCF / Net income | 6.71 | -4.38 | -4.27 | -0.12 | -1.02 | -0.35 |
| R&D / Revenue | - | - | - | - | - | - |
| SG&A / Revenue | 2.2% | 2.1% | 4.1% | 3.2% | 2.4% | 2.5% |
| Effective tax rate | 5.7% | - | - | 0.1% | 0.2% | - |
| Return on assets | 0.5% | -1.8% | -1.1% | 5.3% | 1.2% | -4.5% |
| Return on equity | - | - | - | - | - | - |
| Return on invested capital | - | - | - | - | - | - |
| Liquidity | ||||||
| Current ratio | 1.28 | 1.01 | 1.07 | 1.05 | 1.14 | 1.05 |
| Quick ratio | 1.04 | 0.75 | 0.84 | 0.90 | 0.95 | 0.91 |
| Cash ratio | 0.01 | 0.02 | 0.04 | 0.07 | 0.00 | 0.00 |
| Leverage | ||||||
| Debt / Equity | - | - | - | - | - | - |
| Debt / Assets | 0.51 | 0.46 | 0.47 | 0.44 | 0.41 | 0.35 |
| Debt / EBITDA | - | - | - | - | - | - |
| Interest coverage | 1.3x | 1.7x | 0.6x | 3.5x | 1.1x | -0.8x |
| Equity multiplier | - | - | - | - | - | - |
| Liabilities / Assets | 0.64 | 0.65 | 0.60 | 0.56 | - | - |
| Efficiency | ||||||
| Asset turnover | 0.91 | 1.03 | 0.43 | 0.59 | 0.85 | 0.91 |
| Inventory turnover | 40.76 | 24.56 | 17.96 | 47.39 | 48.44 | 49.34 |
| Days sales outstanding | 26d | 30d | 42d | 28d | 25d | 42d |
| Days inventory outstanding | 9d | 15d | 20d | 8d | 8d | 7d |
| Days payable outstanding | 22d | 32d | 37d | 27d | 25d | 38d |
| Cash conversion cycle | 13d | 13d | 26d | 8d | 8d | 11d |
| Valuation | ||||||
| P / E | - | - | - | - | - | - |
| P / B | - | - | - | - | - | - |
| P / S | - | - | - | - | - | - |
| EV / EBITDA | - | - | - | - | - | - |
| Growth | ||||||
| Revenue growth (YoY) | 31.3% | 102.7% | -29.2% | -12.9% | -5.8% | 54.0% |
| Revenue CAGR (3y) | 23.5% | 7.7% | -16.6% | 8.1% | 11.5% | -0.4% |
| Revenue CAGR (5y) | 9.1% | 12.6% | -3.1% | -4.1% | 72.5% | 14.1% |
| Gross profit growth (YoY) | 38.4% | 10.9% | 2.6% | 21.4% | 3.7% | -15.0% |
| Operating income growth (YoY) | 5.9% | 156.6% | -78.4% | 254.4% | - | 27.0% |
| Net income growth (YoY) | - | -39.9% | - | 461.2% | - | 11.3% |
| EPS growth (YoY) | - | -32.7% | 56.3% | - | - | - |
| EPS CAGR (3y) | - | - | - | - | - | - |
| EPS CAGR (5y) | - | - | - | - | - | - |
| FCF growth (YoY) | -38.9% | 43.2% | - | 32.4% | - | -72.5% |
| FCF CAGR (5y) | 25.5% | 7.0% | -1.5% | - | - | - |
| Book value growth (YoY) | - | - | - | - | - | - |
Sales by segment
From XBRL dimensional facts in the 10-K period ending 2021-12-31.
Business segments
$4.57B totalStorage And Logistics Segment$3.89B · 85.1%
Gathering And Processing North Segment$574.70M · 12.6%
Gathering And Processing South Segment$105.90M · 2.3%
Product / service
$4.57B totalProduct$4.15B · 90.7%
Service$396.40M · 8.7%
Product Related Party$25.80M · 0.6%
Service Related Party$1.40M · 0.0%
Stability scores
Piotroski F-score
FY 2022 · 9-point quality
6/9
Neutral
- ✓Net income positive
- ✓Operating cash flow positive
- ✓ROA improved YoY
- ✓Cash flow > net income
- ✗Long-term debt decreased
- ✓Current ratio improved
- -No share dilution
- ✓Gross margin improved
- ✗Asset turnover improved
Peer comparison
Same SIC group: Natural Gas Transmisison & Distribution
Comparing Crestwood Equity Partners LP against the 5 most active filers in the same SIC group.