$2.4 B

CEQP Mkt cap, 18-Jul-2018

$1.1 B

Crestwood Equity Partners Revenue Q1, 2018
Crestwood Equity Partners EBIT (Q1, 2018)46 M
Crestwood Equity Partners Cash, 30-Jun-20172.3 M
Crestwood Equity Partners EV2.4 B

Crestwood Equity Partners Income Statement

Annual

usdFY, 2011FY, 2012FY, 2013FY, 2014FY, 2015FY, 2016

Revenue

205.8 m239.5 m1.4 b3.9 b2.6 b2.5 b

Revenue growth, %

16%496%176%(33%)(4%)

General and administrative expense

88.2 m

Operating expense total

88.2 m

EBIT

28.2 m118.6 m(2 b)(108.7 m)

EBIT margin, %

2%3%(77%)(4%)

Interest expense

27.6 m35.8 m

Pre tax profit

(49.6 m)(9.3 m)(2.3 b)(191.8 m)

Income tax expense

1 m1.1 m(1.4 m)(300 k)

Net Income

(50.6 m)(10.4 m)(2.3 b)(192.1 m)

Quarterly

USDQ3, 2013Q1, 2014Q2, 2014Q3, 2014Q1, 2015Q2, 2015Q3, 2015Q1, 2016Q2, 2016Q3, 2016Q1, 2017Q2, 2017Q1, 2018

Revenue

427.2 m971.6 m926.3 m1 b731.5 m641.5 m630.7 m536 m601.9 m587.6 m828.1 m850.3 m1.1 b

General and administrative expense

27.9 m24.1 m21.4 m27.5 m30.6 m32.8 m23 m28.9 m18.3 m26.4 m22.7 m

Operating expense total

121.7 m138.3 m144 m149 m152.3 m149.3 m157.6 m127.1 m138.3 m101.7 m108.5 m105.6 m

EBIT

15.8 m45.7 m29.4 m43 m48.5 m(248.9 m)(588.3 m)(64.2 m)(19.1 m)17.1 m36.1 m15.1 m46 m

EBIT margin, %

4%5%3%4%7%(39%)(93%)(12%)(3%)3%4%2%4%

Pre tax profit

(7.4 m)14 m(4.6 m)12 m18.5 m(296.3 m)(623.7 m)(93.7 m)(37.1 m)3.2 m(19.5 m)300 k

Income tax expense

500 k800 k200 k100 k400 k(300 k)(300 k)(200 k)100 k

Net Income

(7.9 m)13.2 m(4.8 m)11.9 m18.1 m(296 m)(623.4 m)(93.7 m)(37.1 m)3 m(19.4 m)300 k

Crestwood Equity Partners Balance Sheet

Annual

USDFY, 2013FY, 2014FY, 2015FY, 2016

Cash

5.2 m8.8 m500 k1.6 m

Inventories

16.1 m23.3 m21.7 m66 m

Current Assets

522 m538.1 m335.8 m373.4 m

PP&E

3.9 b3.9 b3.3 b2.1 b

Goodwill

2.6 b2.5 b1.1 b199 m

Total Assets

8.5 b8.5 b5.8 b4.4 b

Accounts Payable

379 m241.2 m144.1 m217.2 m

Short-term debt

5.1 m3.7 m1.1 m1 m

Current Liabilities

596.1 m424.9 m258.2 m337.3 m

Total Debt

1 m

Debt to Assets Ratio

0 x

Quarterly

USDQ3, 2013Q1, 2014Q2, 2014Q3, 2014Q1, 2015Q2, 2015Q3, 2015Q1, 2016Q2, 2016Q3, 2016Q1, 2017Q2, 2017

Cash

8.8 m7.7 m18.2 m2.2 m67.7 m1.3 m9 m1.1 m900 k1 m1 m2.3 m

Accounts Receivable

364.3 m379.4 m430.5 m289.8 m302.9 m302.5 m209.6 m247.5 m224.3 m

Inventories

95.7 m39.8 m58.8 m104.7 m23.9 m38.8 m49.9 m26.6 m43.5 m61.8 m58.8 m63.1 m

Current Assets

387.2 m451.3 m493.8 m585.1 m438.8 m401.2 m415.6 m272.4 m367.3 m357.6 m340 m375.5 m

PP&E

3.6 b3.9 b4 b4 b3.9 b3.9 b3.8 b3.3 b2.1 b2.1 b2.1 b2 b

Goodwill

2.9 b2.5 b2.5 b2.5 b2.5 b2.2 b1.6 b975.8 m249.5 m249.5 m199 m199 m

Total Assets

8.1 b8.5 b8.6 b8.7 b8.3 b8 b7.3 b5.6 b4.6 b4.5 b4.4 b4.4 b

Accounts Payable

212.1 m317.4 m304.4 m336.8 m218.7 m178.1 m165.8 m119.1 m164.5 m149.6 m193.7 m237.5 m

Short-term debt

4.4 m14 m29 m10.5 m36.3 m12.3 m17.6 m900 k900 k900 k14.8 m1 m

Current Liabilities

396.9 m520.9 m538.4 m558.2 m341.4 m305.1 m310 m224.1 m277.5 m278.2 m296 m331 m

Total Debt

4.4 m14 m29 m10.5 m36.3 m12.3 m17.6 m900 k900 k900 k14.8 m1 m

Crestwood Equity Partners Cash Flow

Annual

usdFY, 2013FY, 2014FY, 2015FY, 2016

Net Income

(50.6 m)(10.4 m)(2.3 b)(192.1 m)

Depreciation and Amortization

167.9 m285.3 m300.1 m229.6 m

Accounts Receivable

(40 m)60.4 m120 m(76.9 m)

Inventories

11.2 m(11 m)1.8 m(22.5 m)

Accounts Payable

(420.6 m)(2.7 m)(2.7 m)

Cash From Operating Activities

188.3 m283 m440.7 m346.1 m

Purchases of PP&E

(347 m)(424 m)(182.7 m)(100.7 m)

Cash From Investing Activities

(1 b)(483 m)(212.7 m)867.2 m

Long-term Borrowings

(333.3 m)(2.7 b)(4.1 b)(2.5 b)

Cash From Financing Activities

859.7 m203.6 m(236.3 m)(1.2 b)

Interest Paid

64.9 m114.4 m129 m121.5 m

Income Taxes Paid

2.5 m6.6 m4.7 m1.4 m

Quarterly

USDQ3, 2013Q1, 2014Q2, 2014Q3, 2014Q1, 2015Q2, 2015Q3, 2015Q1, 2016Q2, 2016Q3, 2016Q1, 2017Q2, 2017Q1, 2018

Net Income

(8.5 m)13.2 m8.4 m20.3 m18.1 m(277.9 m)(901.3 m)(93.7 m)(130.8 m)(127.8 m)(19.4 m)(19.1 m)

Depreciation and Amortization

66.3 m137.5 m209.2 m74.2 m149 m224.5 m62.3 m126.7 m177 m48.4 m97.1 m

Accounts Receivable

(61.8 m)

Inventories

(47.2 m)

Accounts Payable

(208.9 m)

Cash From Operating Activities

114.1 m72.3 m111.5 m157.2 m156.6 m211.1 m301.6 m134.3 m193 m244.5 m58.9 m132.9 m

Purchases of PP&E

(198.6 m)(72.8 m)(172.3 m)(270.7 m)(47.4 m)(83.5 m)(122.8 m)(55.6 m)(76.2 m)(79.3 m)(22.7 m)(88.7 m)

Cash From Investing Activities

(333.9 m)(104.7 m)(240.4 m)(371.7 m)(65.2 m)(108.4 m)(155.5 m)(60.3 m)865.8 m866.8 m(12.3 m)(85.1 m)

Long-term Borrowings

(160.2 m)(372.6 m)(1.2 b)(1.9 b)(1.2 b)(2 b)(3.3 b)(286.2 m)(2 b)(2.3 b)(1.1 b)(1.6 b)

Cash From Financing Activities

228.5 m34.9 m141.9 m211.5 m(32.5 m)(110.2 m)(145.9 m)(73.4 m)(1.1 b)(1.1 b)(47.2 m)(47.1 m)(90 m)
Report incorrect company information