Attached files

file filename
8-K/A - 8-K/A - NGL Energy Partners LPa11-31395_18ka.htm
EX-99.1 - EX-99.1 - NGL Energy Partners LPa11-31395_1ex99d1.htm

Exhibit 99.2

 

NGL ENERGY PARTNERS LP AND SUBSIDIARIES

 

UNAUDITED PRO FORMA CONDENSED CONSOLIDATED FINANCIAL STATEMENTS

 

Introduction

 

The following represents the unaudited pro forma condensed consolidated balance sheet of NGL Energy Partners LP (“we”, “NGL” or “the Partnership”) as of June 30, 2011 and the unaudited pro forma condensed consolidated statement of operations for the year ended March 31, 2011, and for the three months ended June 30, 2011. NGL was formed in September 2010.  As part of our formation, we acquired and combined the assets and operations of NGL Supply, Inc. (“NGL Supply”), Hicks LLC and Gifford (collectively, “Hicksgas”) with an effective date of October 1, 2010.  We became a public company in May 2011 and filed our first Form 10-K for the six months ended March 31, 2011.  NGL Supply was the deemed acquirer for accounting purposes in our combination; therefore, the financial statements of NGL Supply for all periods prior to our combination became our prior period financial statements.

 

As discussed further below, subsequent to June 30, 2011, we had the following transactions which have a significant impact on our financial position and results of operations:

 

·                  In August 2011, we amended our credit agreement to increase our total facility to $330 million, consisting of a $130 million working capital facility and a $200 million acquisition facility and extended the final maturity to October 1, 2016, except for a $30 million portion of our working capital facility that terminates in February 2012.

 

·                  On October 3, 2011, we closed a business combination transaction with E. Osterman Propane, Inc., its affiliated companies and members of the Osterman family (collectively, “Osterman” or “the Osterman Associated Companies”) for retail propane operations in the northeastern United States.  We issued four million common units and paid $96 million in exchange for the receipt of the assets and operations from Osterman.

 

·                  On November 1, 2011, we closed a business combination transaction with SemStream, L.P. (“SemStream”) for substantially all of SemStream’s natural gas liquids business and assets.  We issued 8,932,031 common units and paid approximately $93.1 million in exchange for the receipt of the assets and operations of SemStream.  The impact of this transaction is not reflected herein.  We are filing a separate Form 8-K/A for this transaction which we expect to file by its due date on January 17, 2012.

 

The accompanying unaudited pro forma condensed consolidated balance sheet as of June 30, 2011 gives pro forma effect to the modification of our credit agreement and the business combination with Osterman as if such transactions occurred on June 30, 2011.

 

The accompanying unaudited pro forma condensed consolidated statement of operations for the year ended March 31, 2011 gives pro forma effect to the following transactions as if such transactions occurred on April 1, 2010:

 



 

·                  Our combination with NGL Supply, Hicks LLC and Gifford;

 

·                  Our initial public offering;

 

·                  The modifications of the terms of our credit agreement; and,

 

·                  The business combination with Osterman.

 

The accompanying unaudited pro forma condensed consolidated statement of operations for the three months ended June 30, 2011 gives pro forma effect to the following transactions as if such transactions occurred on April 1, 2011:

 

·                  Our initial public offering;

 

·                  The modifications of the terms of our credit agreement; and,

 

·                  The business combination with Osterman.

 

Business Combination with Hicksgas

 

We purchased the retail propane operations of Hicksgas in October 2010 as part of our formation transactions.  The following table presents the final allocation of the acquisition cost to the assets acquired and liabilities assumed, based on their fair values, in the acquisition of the retail propane businesses of Hicksgas described above (in thousands):

 



 

Accounts receivable

 

$

5,669

 

Propane inventory

 

6,182

 

Other current assets

 

2,600

 

Property, plant and equipment:

 

 

 

Land

 

2,666

 

Tanks and other retail propane equipment (15 years)

 

23,016

 

Vehicles (5 years)

 

6,599

 

Buildings (30 years)

 

7,053

 

Other equipment (5 years)

 

523

 

Amortizable intangible assets:

 

 

 

Customer relationships (15 years)

 

2,170

 

Non-compete agreements (5 years)

 

550

 

Tradenames (indefinite life)

 

830

 

Goodwill, retail propane segment

 

3,716

 

Total assets

 

61,574

 

 

 

 

 

Accounts payable

 

1,837

 

Customer advances and deposits

 

12,089

 

Accrued and other current liabilities

 

2,152

 

 

 

16,078

 

 

 

 

 

Long-term debt

 

5,768

 

Other long-term liabilities

 

274

 

Total liabilities assumed

 

22,120

 

 

 

 

 

Net assets acquired

 

$

39,454

 

 

The Hicksgas acquisition accounting was based on the estimated fair value of the assets acquired and liabilities assumed, based primarily on an independent appraisal completed in July 2011.  The assets acquired and liabilities assumed in the Hicksgas combination are included in our historical consolidated balance sheet since October 1, 2010 and the operations of Hicksgas have been included in our consolidated statement of operations since October 1, 2010.  Additional information related to our business combination with Hicksgas is available in our Form 10-K for the year ended March 31, 2011.

 

Initial Public Offering

 

During May 2011, we sold a total of 4,025,000 common units (including the exercise by the underwriters of their option to purchase additional common units from us) in our initial public offering at $21 per unit.  Our proceeds from the sale of 3,850,000 common units of approximately $72.0 million, net of total offering costs of approximately $9.0 million, were used to repay advances under our acquisition credit facility and for general partnership purposes.  Proceeds from the sale of 175,000 common units ($3.4 million) from the underwriters’ exercise of their option to purchase additional common units from us were used to redeem 175,000 of the common units outstanding prior to our initial public offering.  The advances under our acquisition credit facility were used to fund our business combination with NGL Supply and Hicksgas.   Additional information related to our initial public offering is available in our Form 10-K for the year ended March 31, 2011 and our Form 10-Q for the three months ended June 30, 2011.

 



 

Immediately prior to our initial public offering we executed the following unit transactions:

 

·                  Effected a 3.7219 to one split of our common units; and,

 

·                  Converted 5,919,346 of our post-split common units to subordinated units.

 

Modification of Credit Facility

 

We expanded our revolving credit facility in August 2011.  Presently, our revolving credit facility provides for a total credit facility of $330 million, represented by a $130 million working capital facility and a $200 million acquisition facility.  Borrowings under the working capital facility are subject to a defined borrowing base.  The borrowing base is determined in part by reference to certain trade position reports and mark-to-market reports delivered to the administrative agent and is subject to immediate adjustment for reductions in certain components of those reports.  A reduction to the borrowing base could require us to repay indebtedness in excess of the borrowing base.  In addition, three times per year, we can elect to reallocate up to $75 million of our acquisition facility to the working capital facility.  During October 2011, we elected to reallocate $50 million from our acquisition facility to our working capital facility.

 

Subsequent to June 30, 2011, we have borrowed approximately $107 million under our acquisition facility and an additional approximately $126 million under our working capital facility primarily in connection with our acquisitions of Osterman and SemStream and to fund our seasonal inventory build.  At December 5, 2011, we had outstanding borrowings of $138.2 million (including outstanding letters of credit of $14.2 million) and $107.0 million under our working capital and acquisition facility, respectively.

 

Our revolving credit facility has a final maturity on October 1, 2016.  However, a total of $30 million of our working capital facility matures in February 2012.  In addition to customary mandatory prepayment restrictions, once a year we must reduce the outstanding working capital revolving loans and collateralize outstanding letters of credit to less than $10.0 million for 30 consecutive days.

 

Additional information related to our credit agreement is available in our Form 10-Q for the three months ended June 30, 2011.

 

Osterman Combination

 

On August 15, 2011, we entered into the business combination agreement with Osterman for retail propane operations in the northeastern United States to expand our retail propane operations.  The agreement closed on October 3, 2011 and was funded with cash of $96 million and the issuance of four million common units, and also contemplates a working capital payment post closing for certain specified working capital items that might be payable to the Partnership or Osterman.  The cash payments were funded with advances under our acquisition facility.  We have valued the four million common units at $20.47 per unit, the closing price of our common units on the closing date.  We also incurred and charged to general and administrative expense subsequent to June 30, 2011 approximately $530,000 of costs incurred in connection with the Osterman transaction that cannot be capitalized under GAAP.

 



 

Our total consideration paid in the Osterman combination consists of the following (in thousands):

 

Cash

 

$

96,000

 

Common units

 

81,880

 

 

 

$

177,880

 

 

We will include the results of Osterman’s operations in our consolidated financial statements beginning October 3, 2011. As discussed further below, we have not completed the initial accounting for the Osterman business combination. We are in the process of identifying, and obtaining an independent appraisal of, the fair value of the assets acquired in the combination. We expect to complete this process prior to our year end of March 31, 2012. On a preliminary basis, we have estimated the fair values of the acquired assets and liabilities as follows (in thousands):

 

Cash

 

$

2,492

 

Accounts receivable

 

2,955

 

Inventory

 

3,981

 

Prepaid expenses

 

637

 

Property, plant and equipment

 

97,520

 

Intangible assets

 

73,479

 

Assumed current liabilities

 

(3,184

)

 

 

$

177,880

 

 

These estimates of fair value are preliminary and are subject to change as additional information is obtained, including the impact of the post closing working capital settlement which has not been completed at the date of this filing.  Such changes could be material.  Additional information as to the fair value estimates is provided in Note 2 to the unaudited pro forma condensed consolidated financial statements.

 

Pro Forma Financial Statements

 

The unaudited pro forma condensed consolidated financial statements are provided for informational purposes only and should be read in conjunction with the audited and unaudited historical financial statements of NGL Supply, Hicks LLC and Gifford which were included in our Form S-1, the audited and unaudited historical financial statements of Osterman included in this Form 8-K/A, our Form 10-K for the year ended March 31, 2011 and our Form 10-Q for the three months ended June 30, 2011. The unaudited pro forma condensed consolidated financial statements include the following:

 

·                  The unaudited pro forma condensed consolidated balance sheet of NGL Energy Partners LP as of June 30, 2011 as if the modification of our credit agreement and the combination transaction with Osterman occurred on June 30, 2011;

 

·                  The unaudited pro forma condensed consolidated statement of operations of NGL Energy Partners LP for the year ended March 31, 2011 as if the combination transactions with NGL Supply, Hicks LLC, Gifford and Osterman, our initial public offering and the modification of our credit agreement, had occurred on April 1, 2010; and,

 



 

·                  The unaudited pro forma condensed consolidated statement of operations of NGL Energy Partners LP for the three months ended June 30, 2011 as if the combination transaction with Osterman, our initial public offering and the modification of our credit agreement had occurred on April 1, 2011.

 

The following unaudited pro forma condensed consolidated financial statements are based on certain assumptions and do not purport to be indicative of the results which actually would have been achieved if the combination transactions with NGL Supply, Hicks LLC, Gifford, and Osterman and our initial public offering and related equity issuances and the modification of our credit agreement had been completed on the dates indicated. Moreover, they do not project NGL Energy’s financial position or results of operations for any future date or period.

 

The accompanying pro forma condensed consolidated financial statements reflect asset and liability fair value estimates which are preliminary as our identification of the assets and liabilities acquired, and the fair value determinations thereof, for the Osterman business combination reflected in the pro forma statements has not been completed. We have engaged an independent appraisal firm to prepare an appraisal of the assets and liabilities acquired in the combination.  We expect to complete such appraisal and fair value determination by our fiscal year end of March 31, 2012. The fair value determination is also impacted by the amount of current assets and liabilities due to working capital adjustment provisions contained in the combination agreement. The fair value estimates reflected in the accompanying pro forma condensed consolidated financial statements are based on the best estimates available at this time and on the unaudited balance sheets of Osterman as of June 30, 2011. There is no guarantee that the preliminary fair value estimates, and consequently the pro forma condensed consolidated financial statements, will not change. To the extent that the final combination accounting results in an increased allocation to goodwill, this amount would not be subject to amortization, but would be subject to an annual impairment testing and if necessary, written-down to a lower fair value should circumstances warrant. To the extent the final combination accounting results in a decrease to the preliminary computation of goodwill done for the purpose of preparing these pro forma financial statements, the amount would be subject to depreciation or amortization which would result in a decrease to the estimated pro forma income reflected in the accompanying pro forma condensed consolidated statements of operations for the respective periods.

 



 

NGL ENERGY PARTNERS LP

UNAUDITED PRO FORMA CONDENSED CONSOLIDATED BALANCE SHEET

AS OF JUNE 30, 2011

US DOLLARS IN THOUSANDS

 

 

 

 

 

 

 

Pro Forma

 

 

 

 

 

Historical As of June 30, 2011

 

Adjustments

 

 

 

 

 

 

 

 

 

Note

 

NGL

 

 

 

NGL

 

Osterman

 

Osterman

 

2

 

Pro Forma

 

ASSETS

 

 

 

 

 

 

 

 

 

 

 

Current Assets:

 

 

 

 

 

 

 

 

 

 

 

Cash and cash equivalents

 

$

8,721

 

$

22,114

 

$

82

 

(a)

 

$

11,295

 

 

 

 

 

 

 

(19,622

)

(a)

 

 

 

Accounts receivable- trade

 

48,083

 

7,915

 

(4,960

)

(a)

 

51,038

 

Accounts receivable- affiliates

 

295

 

6,222

 

(6,222

)

(a)

 

295

 

Inventories

 

53,121

 

3,762

 

219

 

(a)

 

57,102

 

Product exchanges

 

416

 

 

 

 

 

416

 

Prepaid expenses and other current assets

 

2,487

 

1,295

 

(658

)

(a)

 

3,124

 

Total current assets

 

113,123

 

41,308

 

(31,161

)

 

 

123,270

 

 

 

 

 

 

 

 

 

 

 

 

 

Property, Plant and Equipment, net

 

65,706

 

18,762

 

78,758

 

(a)

 

163,226

 

 

 

 

 

 

 

 

 

 

 

 

 

Goodwill

 

8,568

 

380

 

(380

)

(a)

 

8,568

 

 

 

 

 

 

 

 

 

 

 

 

 

Intangible Assets, net

 

11,271

 

3,542

 

69,937

 

(a)

 

84,750

 

 

 

 

 

 

 

 

 

 

 

 

 

Other Long-Term Assets

 

 

225

 

(225

)

(a)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total assets

 

$

198,668

 

$

64,217

 

$

116,929

 

 

 

$

379,814

 

 

 

 

 

 

 

 

 

 

 

 

 

LIABILITIES AND PARTNERS’ EQUITY

 

 

 

 

 

 

 

 

 

 

 

Current Liabilities:

 

 

 

 

 

 

 

 

 

 

 

Trade accounts payable

 

$

49,315

 

$

3,720

 

$

(1,873

)

(a)

 

$

51,162

 

Accrued expenses and other payables

 

5,117

 

1,529

 

(317

)

(a)

 

6,329

 

Product exchanges

 

7,423

 

 

 

 

 

7,423

 

Advance payments received from customers

 

15,545

 

1,774

 

(1,649

)

(a)

 

15,670

 

Current maturities of long-term debt (Note 4)

 

1,830

 

156

 

(156

)

(a)

 

1,830

 

Total current liabilities

 

79,230

 

7,179

 

(3,995

)

 

 

82,414

 

 

 

 

 

 

 

 

 

 

 

 

 

Long-Term Debt, net of current maturities (Note 4)

 

10,376

 

1,624

 

96,000

 

(a)

 

106,376

 

 

 

 

 

 

 

(1,624

)

(a)

 

 

 

Other Non-Current Liabilities

 

370

 

348

 

(348

)

(a)

 

370

 

 

 

 

 

 

 

 

 

 

 

 

 

Partners’ Equity (Note 5):

 

 

 

 

 

 

 

 

 

 

 

General partner

 

146

 

 

 

82

 

(a)

 

228

 

Limited partners-

 

 

 

 

 

 

 

 

 

 

 

Common units

 

86,545

 

 

 

81,880

 

(a)

 

168,425

 

Subordinated units

 

21,940

 

 

 

 

 

 

21,940

 

Accumulated other comprehensive income

 

61

 

 

 

 

 

 

61

 

Total partners’ equity

 

108,692

 

 

81,962

 

 

 

190,654

 

 

 

 

 

 

 

 

 

 

 

 

 

Equity of Combined Businesses

 

 

55,066

 

(55,066

)

(b)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total liabilities and partners’ equity

 

$

198,668

 

$

64,217

 

$

116,929

 

 

 

$

379,814

 

 

See accompanying notes.

 



 

NGL ENERGY PARTNERS LP

UNAUDITED PRO FORMA CONDENSED CONSOLIDATED

STATEMENT OF OPERATIONS

FOR THE YEAR ENDED MARCH 31, 2011

US DOLLARS IN THOUSANDS, EXCEPT PER UNIT AMOUNTS

(Page 1 of 2)

 

 

 

Historical

 

Pro Forma Adjustments

 

Preliminary

 

 

 

NGL

 

NGL Supply

 

Hicks LLC

 

Gifford

 

Hicksgas/NGL Supply

 

 

 

 

 

 

 

Pro Forma

 

 

 

Six Months Ended

 

Six Months Ended

 

Six Months Ended

 

Six Months Ended

 

Combination

 

Note

 

Offering

 

Note

 

NGL

 

 

 

March 31, 2011

 

September 30, 2010

 

September 30, 2010

 

September 30, 2010

 

Transaction

 

2

 

Transaction

 

2

 

To Page 2 of 2

 

REVENUES:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Retail propane

 

$

72,813

 

$

6,868

 

$

18,339

 

$

4,583

 

$

(2,349

)

(c)

 

 

 

 

 

$

100,254

 

Wholesale supply and marketing

 

546,782

 

309,029

 

 

 

(595

)

(c)

 

 

 

 

 

855,216

 

Midstream

 

2,637

 

1,046

 

 

 

 

 

 

 

 

 

 

3,683

 

 

 

622,232

 

316,943

 

18,339

 

4,583

 

(2,944

)

 

 

 

 

 

959,153

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

COST OF SALES:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Retail propane

 

46,985

 

4,749

 

11,520

 

2,622

 

(2,349

)

(c)

 

 

 

 

 

63,527

 

Wholesale supply and marketing

 

535,755

 

305,965

 

 

 

(595

)

(c)

 

 

 

 

 

841,125

 

Midstream

 

292

 

194

 

 

 

 

 

 

 

 

 

 

486

 

 

 

583,032

 

310,908

 

11,520

 

2,622

 

(2,944

)

 

 

 

 

 

905,138

 

Gross Margin

 

39,200

 

6,035

 

6,819

 

1,961

 

 

 

 

 

 

 

54,015

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

OPERATING COSTS AND EXPENSES:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating and general and administrative

 

20,922

 

8,441

 

9,306

 

2,869

 

(2,064

)

(d)

 

 

 

 

 

39,474

 

Depreciation and amortization

 

3,441

 

1,389

 

1,061

 

150

 

689

 

(e)

 

 

 

 

 

6,730

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating Income (Loss)

 

14,837

 

(3,795

)

(3,548

)

(1,058

)

1,375

 

 

 

 

 

 

7,811

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

OTHER INCOME (EXPENSE):

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Interest expense

 

(2,482

)

(372

)

(240

)

(3

)

 

 

 

 

120

 

(i)

 

(1,187

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1,790

 

(j)

 

 

 

Other, net

 

324

 

190

 

87

 

54

 

 

 

 

 

 

 

 

 

655

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Income (Loss) Before Income Taxes

 

12,679

 

(3,977

)

(3,701

)

(1,007

)

1,375

 

 

 

1,910

 

 

 

7,279

 

INCOME TAX (PROVISION) BENEFIT

 

 

1,417

 

1,845

 

 

 

(3,262

)

(f)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NET INCOME (LOSS)

 

12,679

 

(2,560

)

(1,856

)

(1,007

)

(1,887

)

 

 

1,910

 

 

 

7,279

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

INCOME (LOSS) ALLOCABLE TO GENERAL PARTNER

 

13

 

 

 

 

 

 

 

(8

)

(g)

 

2

 

(k)

 

7

 

NET LOSS ATTRIBUTABLE TO NONCONTROLLING INTEREST

 

 

45

 

 

 

 

 

(45

)

(h)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NET INCOME (LOSS) ALLOCABLE TO LIMITED PARTNERS

 

$

12,666

 

$

(2,515

)

$

(1,856

)

$

(1,007

)

$

(1,924

)

 

 

$

1,908

 

 

 

$

7,272

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Basic and Diluted Earnings per Unit -

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Common

 

$

1.16

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Subordinated

 

$

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Weighted Average Units Outstanding -

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Common

 

10,933,568

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Subordinated

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

See accompanying notes and continuation on Page 2 of 2.

 



 

NGL ENERGY PARTNERS LP

UNAUDITED PRO FORMA CONDENSED CONSOLIDATED

STATEMENTS OF OPERATIONS

FOR THE YEAR ENDED MARCH 31, 2011

US DOLLARS IN THOUSANDS, EXCEPT PER UNIT AMOUNTS

(Page 2 of 2)

 

 

 

Preliminary

 

Historical

 

Pro Forma

 

Pro Forma

 

 

 

Pro Forma

 

Osterman

 

Adjustments

 

NGL

 

 

 

NGL

 

12 Mo. Ended

 

 

 

Note

 

Year Ended

 

 

 

From Page 1 of 2

 

March 31, 2011

 

Osterman

 

2

 

March 31, 2011

 

REVENUES:

 

 

 

 

 

 

 

 

 

 

 

Retail propane

 

$

100,254

 

$

105,061

 

 

 

 

 

$

205,315

 

Wholesale supply and marketing

 

855,216

 

 

 

 

 

 

855,216

 

Midstream

 

3,683

 

 

 

 

 

 

3,683

 

 

 

959,153

 

105,061

 

 

 

 

1,064,214

 

 

 

 

 

 

 

 

 

 

 

 

 

COST OF SALES:

 

 

 

 

 

 

 

 

 

 

 

Retail propane

 

63,527

 

64,076

 

 

 

 

 

127,603

 

Wholesale supply and marketing

 

841,125

 

 

 

 

 

 

841,125

 

Midstream

 

486

 

 

 

 

 

 

486

 

 

 

905,138

 

64,076

 

 

 

 

969,214

 

Gross Margin

 

54,015

 

40,985

 

 

 

 

95,000

 

 

 

 

 

 

 

 

 

 

 

 

 

OPERATING COSTS AND EXPENSES:

 

 

 

 

 

 

 

 

 

 

 

Operating and general and administrative

 

39,474

 

21,549

 

 

 

 

 

61,023

 

Depreciation and amortization

 

6,730

 

3,752

 

4,686

 

(l)

 

15,168

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating Income

 

7,811

 

15,684

 

(4,686

)

 

 

18,809

 

 

 

 

 

 

 

 

 

 

 

 

 

OTHER INCOME (EXPENSE):

 

 

 

 

 

 

 

 

 

 

 

Interest expense

 

(1,187

)

(191

)

(5,501

)

(m)

 

(6,879

)

Other, net

 

655

 

(218

)

 

 

 

 

437

 

 

 

 

 

 

 

 

 

 

 

 

 

Income (Loss) Before Income Taxes

 

7,279

 

15,275

 

(10,187

)

 

 

12,367

 

INCOME TAX (PROVISION) BENEFIT

 

 

(502

)

502

 

(n)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NET INCOME (LOSS)

 

7,279

 

14,773

 

(9,685

)

 

 

12,367

 

 

 

 

 

 

 

 

 

 

 

 

 

INCOME ALLOCABLE TO GENERAL PARTNER

 

7

 

 

 

5

 

(o)

 

12

 

 

 

 

 

 

 

 

 

 

 

 

 

NET INCOME (LOSS) ALLOCABLE TO LIMITED PARTNERS

 

$

7,272

 

$

14,773

 

$

(9,690

)

 

 

$

12,355

 

 

 

 

 

 

 

 

 

 

 

 

 

Basic and Diluted Earnings per Unit -

 

 

 

 

 

 

 

 

 

 

 

Common

 

 

 

 

 

 

 

 

 

$

0.66

 

Subordinated

 

 

 

 

 

 

 

 

 

$

0.66

 

 

 

 

 

 

 

 

 

 

 

 

 

Weighted Average Units Outstanding -

 

 

 

 

 

 

 

 

 

 

 

Common

 

 

 

 

 

 

 

 

 

12,864,222

 

Subordinated

 

 

 

 

 

 

 

 

 

5,919,346

 

 

See accompanying notes.

 



 

NGL ENERGY PARTNERS LP

UNAUDITED PRO FORMA CONDENSED CONSOLIDATED

STATEMENTS OF OPERATIONS

FOR THE THREE MONTHS ENDED JUNE 30, 2011

US DOLLARS IN THOUSANDS, EXCEPT PER UNIT AMOUNTS

 

 

 

Three Months Ended

 

 

 

 

 

 

 

 

 

 

 

 

 

June 30, 2011

 

Pro Forma Adjustments

 

 

 

 

 

Historical

 

Historical

 

Offering

 

Note

 

 

 

Note

 

NGL

 

 

 

NGL

 

Osterman

 

Transaction

 

2

 

Osterman

 

2

 

Pro Forma

 

REVENUES:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Retail propane

 

$

12,852

 

$

18,632

 

 

 

 

 

 

 

 

 

$

31,484

 

Wholesale supply and marketing

 

177,497

 

 

 

 

 

 

 

 

 

 

177,497

 

Midstream

 

497

 

 

 

 

 

 

 

 

 

 

497

 

 

 

190,846

 

18,632

 

 

 

 

 

 

 

209,478

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

COST OF SALES:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Retail propane

 

8,106

 

10,132

 

 

 

 

 

 

 

 

 

18,238

 

Wholesale supply and marketing

 

177,769

 

 

 

 

 

 

 

 

 

 

177,769

 

Midstream

 

98

 

 

 

 

 

 

 

 

 

 

98

 

 

 

185,973

 

10,132

 

 

 

 

 

 

 

196,105

 

Gross Margin

 

4,873

 

8,500

 

 

 

 

 

 

 

13,373

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

OPERATING COSTS AND EXPENSES:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating and general and administrative

 

9,178

 

4,937

 

 

 

 

 

 

 

 

 

14,115

 

Depreciation and amortization

 

1,377

 

1,132

 

 

 

 

 

977

 

(q)

 

3,486

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating Income (Loss)

 

(5,682

)

2,431

 

 

 

 

 

(977

)

 

 

(4,228

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

OTHER INCOME (EXPENSE):

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Interest expense

 

(1,301

)

(94

)

476

 

(p)

 

(1,318

)

(r)

 

(2,237

)

Other, net

 

211

 

(98

)

 

 

 

 

 

 

 

 

113

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Income (Loss) Before Income Taxes

 

(6,772

)

2,239

 

476

 

 

 

(2,295

)

 

 

(6,352

)

INCOME TAX (PROVISION) BENEFIT

 

 

108

 

 

 

 

 

(108

)

(s)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NET INCOME (LOSS)

 

(6,772

)

2,347

 

476

 

 

 

(2,403

)

 

 

(6,352

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LOSS ALLOCABLE TO GENERAL PARTNER

 

(7

)

 

 

 

 

 

 

 

 

 

 

(7

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NET INCOME (LOSS) ALLOCABLE TO LIMITED PARTNERS

 

$

(6,765

)

$

2,347

 

$

476

 

 

 

$

(2,403

)

 

 

$

(6,345

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Basic and Diluted Earnings per Unit -

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Common

 

$

(0.53

)

 

 

 

 

 

 

 

 

 

 

$

(0.34

)

Subordinated

 

$

(0.53

)

 

 

 

 

 

 

 

 

 

 

$

(0.34

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Weighted Average Units Outstanding -

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Common

 

9,883,342

 

 

 

 

 

 

 

 

 

 

 

12,864,222

 

Subordinated

 

2,927,149

 

 

 

 

 

 

 

 

 

 

 

5,919,346

 

 

See accompanying notes.

 



 

NGL ENERGY PARTNERS LP

Notes to Unaudited Pro Forma Condensed Consolidated Financial Statements

 

Note 1 — Basis of Presentation

 

See “— Introduction” for more information regarding the basis of presentation for our unaudited pro forma condensed consolidated financial statements.

 

The entities included in the unaudited pro forma condensed consolidated financial statements are identified as follows due to space limitations:

 

·                 NGL Energy Partners LP - “NGL”

·                 NGL Supply, Inc. - “NGL Supply”

·                 Hicks LLC

·                 Gifford

·                 Osterman Associated Companies - “Osterman”

 

The results of operations of Osterman for the twelve months ended March 31, 2011 were compiled by reducing the individual amounts for the year ended September 30, 2010 by the results for the six months ended March 31, 2010, and increasing the amounts for the six months ended March 31, 2011.  The results of operations for the six month periods ended March 31, 2010 and 2011 are not separately included herein.

 

These unaudited pro forma condensed consolidated financial statements exclude the impact of the SemStream business combination.  We expect to file a Form 8-K/A for the SemStream business combination, including updated pro forma financial statements, by its due date on January 17, 2012.

 

Note 2 — Pro Forma Adjustments

 

Our unaudited pro forma condensed consolidated financial statements reflect the impact of the following pro forma adjustments:

 

Balance Sheet as of June 30, 2011

 

Osterman Combination

 

(a)          Represents the consideration paid in the combination and the resulting net adjustments to the historical net assets at June 30, 2011 to reflect the preliminary allocation of the Osterman acquisition cost based on the following estimate of the fair values of the assets acquired and liabilities assumed (in thousands):

 



 

NGL ENERGY PARTNERS LP

Notes to Unaudited Pro Forma Condensed Consolidated Financial Statements (Continued)

 

 

 

Fair Value Estimates

 

Cash

 

$

2,492

 

Accounts receivable

 

2,955

 

Propane and other inventory

 

3,981

 

Other current assets

 

637

 

Property, plant and equipment:

 

 

 

Land

 

4,500

 

Tanks and other retail propane equipment (20 years)

 

65,000

 

Vehicles (5 years)

 

20,000

 

Buildings (30 years)

 

6,500

 

Other equipment (5 years)

 

1,520

 

Amortizable intangible assets:

 

 

 

Customer relationships (20 years)

 

68,479

 

Tradenames (indefinite life)

 

5,000

 

Assumed current liabilities

 

(3,184

)

Consideration paid

 

$

177,880

 

 

See “— Osterman Combination” for additional information as to the consideration paid.

 

The pro forma adjustment to cash and cash equivalents and partners’ equity includes a contribution from our general partner of $82,000 in order to maintain its 0.1% interest in the Partnership.

 

(b)         Reflects the elimination of the historical net equity of Osterman as of June 30, 2011.

 

Statement of Operations for the Year Ended March 31, 2011

 

Hicksgas/NGL Supply  Combination Transaction Adjustments

 

(c)          Eliminates the effects of intercompany propane sales between Hicks LLC and Gifford and between NGL Supply and Hicks LLC on revenues and cost of sales.

 

(d)         Reflects the elimination of expenses incurred directly in connection with our combination with NGL Supply and Hicksgas.

 

(e)          The assets acquired in the Hicksgas combination are included in our historical balance sheet as of June 30, 2011.  The final fair value determination was made using an independent appraisal of the tangible and intangible assets and the results of the working capital adjustment. The pro forma depreciation and amortization adjustment reflects the estimated net adjustment to historical Hicks LLC and Gifford depreciation and amortization expense resulting from the final fair value computation of property, plant and equipment, identifiable intangible assets and goodwill acquired in the combination. Goodwill is an indefinite-lived asset subject to annual tests for impairment, thus no amortization has been reflected in our unaudited pro forma condensed consolidated statement of operations for the amount allocated to goodwill.

 

(f)            Reflects the elimination of the historical income tax expense or benefit of NGL Supply and Hicks LLC. NGL Supply and Hicks LLC each made elections to be treated as pass through entities for federal income tax purposes just prior to our combination.

 



 

NGL ENERGY PARTNERS LP

Notes to Unaudited Pro Forma Condensed Consolidated Financial Statements (Continued)

 

(g)         Reflects the general partner’s 0.1% share of the income of NGL Supply, Hicks and Gifford after the effect of the pro forma adjustments.

 

(h)         Reflects the effect of the acquisition of the noncontrolling interest in the initial combination transactions with NGL Supply and Hicksgas.

 

Initial Public Offering Transaction Adjustments

 

(i)             Reflects the elimination of historical interest expense related to the acquisition facility of NGL Supply prior to our combination transaction with NGL Supply.

 

(j)             Reflects the elimination of our historical interest expense on the amount borrowed under our acquisition credit facility to finance the Hicksgas combination which was paid using the proceeds from our initial public offering.

 

(k)          Represents the general partner’s 0.1% share of the pro forma adjustments for the initial public offering.

 

Osterman Combination Transaction Adjustments

 

(l)             Reflects the increase in historical depreciation and amortization expense of the Osterman long-lived assets based on the estimated fair value of the assets contributed in the Osterman combination.  The pro forma average depreciation and amortization rate based on the estimated fair value and useful lives of the long-lived assets is 6.77%.  An increase in the estimated fair value of the long-lived assets of $1 million would result in an increase of approximately $68,000 of depreciation and amortization expense for the year ended March 31, 2011.  See Note 2 (a) for the detail of the estimated fair values of the individual long-lived assets and their estimated useful life.

 

(m)       Represents the additional interest expense resulting from the advances from our acquisition facility to finance the Osterman combination at the actual average interest rate of 5.73% for the year ended March 31, 2011.  A change in the interest rate of 0.125% would result in a change of pro forma interest expense of approximately $120,000.

 

(n)         Represents the elimination of the historical income tax provision for Osterman.

 

(o)         Represents the general partner’s 0.1% share of the Osterman income after the effect of the pro forma adjustments.

 

Statement of Operations for the Three Months Ended June 30, 2011

 

Offering Transaction

 

(p)         Reflects the elimination of our historical interest expense on the amount borrowed under our acquisition credit facility to finance the Hicksgas combination which was paid using the proceeds from our initial public offering.

 



 

NGL ENERGY PARTNERS LP

Notes to Unaudited Pro Forma Condensed Consolidated Financial Statements (Continued)

 

Osterman Combination Transaction Adjustments

 

(q)         Reflects the increase in historical depreciation and amortization expense of the Osterman long-lived assets based on the estimated fair value of the assets contributed in the Osterman combination.  The pro forma average depreciation and amortization rate based on the estimated fair value of the long-lived assets is 6.77%.  An increase in the estimated fair value of the long-lived assets of $1 million would result in an increase of approximately $17,000 of depreciation and amortization expense for the three months ended June 30, 2011.  See Note 2 (a) for the detail of the estimated fair values of the individual long-lived assets and their estimated useful life.

 

(r)            Represents the additional interest expense resulting from the advances from our acquisition facility to finance the Osterman combination at the actual average interest rate of 5.49% for the three months ended June 30, 2011.  A change in the interest rate of 0.125% would result in a change of pro forma interest expense of approximately $30,000 for the three months ended June 30, 2011.

 

(s)          Represents the elimination of the historical income tax provision for Osterman.

 

Note 3 — Pro Forma Earnings per Unit Computation

 

Our net income for income statement presentation and partners’ capital purposes is allocated to our general partner and limited partners in accordance with their respective ownership interests, and in accordance with our partnership agreement after giving effect to priority income allocations for incentive distributions, if any, to our general partner (the holder of the incentive distribution rights) pursuant to our partnership agreement, which are declared and paid following the close of each quarter.  These incentive distributions could result in less income allocable to the common and subordinated unitholders.

 

For purposes of computing pro forma basic and diluted net income per common and subordinated unit, we have assumed that (a) the minimum quarterly distributions would have been paid to all unitholders for all outstanding units for each quarter during the periods presented, and (b) there would be no incentive distributions to the general partner. Any earnings in excess of distributions are allocated to our general partner and limited partners based on their respective ownership interests.

 

The pro forma earnings per unit have been computed under the two-class method based on earnings or losses allocated to the limited partners after deducting the total earnings allocation to the general partner. The computation is based on the number of common and subordinated units outstanding after the Osterman combination.  The pro forma basic and diluted earnings per unit are equal as there are no dilutive units.

 

Earnings per unit are computed as follows (dollars in thousands except per unit information):

 



 

NGL ENERGY PARTNERS LP

Notes to Unaudited Pro Forma Condensed Consolidated Financial Statements (Continued)

 

 

 

Historical

 

Year Ended

 

Three Months Ended

 

 

 

NGL Energy

 

March 31, 2011

 

June 30, 2011

 

 

 

Six Months Ended

 

Pro

 

 

 

Pro

 

 

 

March 31, 2011

 

Forma

 

Historical

 

Forma

 

Net income (loss)

 

$

12,679

 

$

12,367

 

$

(6,772

)

$

(6,352

)

 

 

 

 

 

 

 

 

 

 

General partner 0.1% share of income (loss)

 

13

 

12

 

(7

)

(7

)

General partner incentive distributions

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Income (loss) allocated to limited partners

 

$

12,666

 

$

12,355

 

$

(6,765

)

$

(6,345

)

Common unitholders

 

$

12,666

 

$

8,462

 

$

(5,219

)

$

(4,345

)

Subordinated unitholders

 

$

 

$

3,893

 

$

(1,546

)

$

(2,000

)

 

 

 

 

 

 

 

 

 

 

Basic and Diluted Earnings per Unit —

 

 

 

 

 

 

 

 

 

Common unitholders

 

$

1.16

 

$

0.66

 

$

(0.53

)

$

(0.34

)

Subordinated unitholders

 

$

 

$

0.66

 

$

(0.53

)

$

(0.34

)

 

 

 

 

 

 

 

 

 

 

Weighted Average Units Outstanding —

 

 

 

 

 

 

 

 

 

Common

 

10,933,568

 

12,864,222

 

9,883,342

 

12,864,222

 

Subordinated

 

 

5,919,346

 

2,927,149

 

5,919,346

 

 

For the pro forma earnings per unit computation, we have assumed that all units were outstanding during the entire period for each of the periods presented.

 

Note 4 — Long-Term Debt

 

Our historical and pro forma long-term debt as of June 30, 2011 are as follows:

 

 

 

Historical

 

Pro Forma

 

 

 

 

 

 

 

Working capital facility

 

$

11,000

 

$

11,000

 

Acquisition facility

 

 

96,000

 

Other

 

1,206

 

1,206

 

 

 

$

12,206

 

$

108,206

 

 

 

 

 

 

 

Less - Current maturities

 

1,830

 

1,830

 

Long-term debt

 

$

10,376

 

$

106,376

 

 

Note 5 — Partners’ Equity

 

Outstanding general and limited partner units on a historical and pro forma basis as of June 30, 2011 are as follows:

 



 

NGL ENERGY PARTNERS LP

Notes to Unaudited Pro Forma Condensed Consolidated Financial Statements (Continued)

 

 

 

Historical

 

Pro Forma

 

 

 

 

 

 

 

General partner notional units

 

14,799

 

27,744

 

Limited partner -

 

 

 

 

 

Common units

 

8,864,222

 

12,864,222

 

Subordinated units

 

5,919,346

 

5,919,346

 

 

The four million common units issued in the Osterman combination are not eligible for distributions until the distribution for the quarter ending December 31, 2011.