Exhibit 99.1
UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED FINANCIAL INFORMATION
The Unaudited Pro Forma Condensed Combined Consolidated Financial Statements (sometimes referred to as pro forma financial statements) have been derived from the historical consolidated financial statements of AGL Resources and Nicor.
The Unaudited Pro Forma Condensed Combined Consolidated Statement of Income (sometimes referred to as pro forma statement of income) for the year ended December 31, 2010, gives effect to the merger as if it were completed on January 1, 2010. The Unaudited Pro Forma Condensed Combined Statement of Financial Position (sometimes referred to as pro forma balance sheet) as of December 31, 2010, gives effect to the merger as if it were completed on December 31, 2010.
The historical consolidated financial information has been adjusted in the pro forma financial statements to give effect to pro forma events that are: (i) directly attributable to the merger; (ii) factually supportable; and (iii) with respect to the pro forma statement of income, expected to have a continuing impact on the combined results of AGL Resources and Nicor. As such, the impact from merger related expenses is not included in the accompanying pro forma statement of income. However, the impact of these expenses is reflected in the pro forma balance sheet as a decrease to retained earnings.
The pro forma financial statements do not reflect any cost savings (or associated costs to achieve such savings) from operating efficiencies, synergies or other restructuring that could result from the merger. Further, the pro forma financial statements do not reflect the effect of any regulatory actions that may impact the pro forma financial statements when the merger is completed.
The acquisition of Nicor common stock by AGL Resources in the merger will be accounted for in accordance with the acquisition method of accounting and the regulations of the SEC. The purchase price will be computed using (i) Nicor’s outstanding shares at the date of the merger, and the market value of AGL Resources’ common stock anticipated to be issued in connection with the merger based on the closing price of AGL Resources’ common stock at the date of the merger and (ii) the cost of debt to be issued based on Nicor’s outstanding shares at the date of the merger and the commitment to pay cash of $21.20 per Nicor common share.
Assumptions and estimates underlying the pro forma adjustments are described in the accompanying notes, which should be read in connection with the pro forma financial statements. Since the pro forma financial statements have been prepared based on preliminary estimates, the final amounts recorded at the date of the merger may differ materially from the information presented. These estimates are subject to change pending further review of the assets acquired and liabilities assumed.
The pro forma financial statements have been presented for illustrative purposes only and are not necessarily indicative of results of operations and financial position that would have been achieved had the pro forma events taken place on the dates indicated, or the future consolidated results of operations or financial position of the combined company.
The following pro forma financial statements should be read in conjunction with:
· | The accompanying notes to the Unaudited Pro Forma Condensed Combined Consolidated Financial Statements; |
· | The consolidated financial statements of AGL Resources as of and for the year ended December 31, 2010, included in AGL Resources’ Form 10-K filed with the SEC on February 9, 2011; |
· | The consolidated financial statements of Nicor as of and for the year ended December 31, 2010, included in Nicor’s Form 10-K filed with the SEC on February 24, 2011. |
AGL RESOURCES INC. AND NICOR INC.
UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED STATEMENT OF INCOME
For the Year Ended December 31, 2010
| | AGL | | | | | | Pro Forma | | | Pro Forma | |
| | Resources | | | Nicor (a) | | | Adjustments | | | Combined | |
| | (In millions, except per share amounts) | |
| | | | | | | | | | | | | | | | |
OPERATING REVENUES | | $ | 2,373 | | | $ | 2,710 | | | $ | - | | | $ | 5,083 | |
OPERATING EXPENSES: | | | | | | | | | | | | | | | | |
Cost of gas | | | 1,164 | | | | 1,406 | | | | - | | | | 2,570 | |
Operation and maintenance | | | 503 | | | | 692 | | | | (10) | (b) | | | 1,185 | |
Depreciation and amortization | | | 160 | | | | 203 | | | | 6 | (c) | | | 369 | |
Taxes other than income taxes | | | 46 | | | | 173 | | | | - | | | | 219 | |
Total operating expenses | | | 1,873 | | | | 2,474 | | | | (4) | | | | 4,343 | |
OPERATING INCOME | | | 500 | | | | 236 | | | | 4 | | | | 740 | |
Interest expense | | | (109) | | | | (37) | | | | (46) | (d) | | | (192) | |
Other (loss) income | | | (1) | | | | 9 | | | | - | | | | 8 | |
INCOME BEFORE INCOME TAXES | | | 390 | | | | 208 | | | | (42) | | | | 556 | |
INCOME TAXES | | | 140 | | | | 70 | | | | (16) | (e) | | | 194 | |
NET INCOME | | | 250 | | | | 138 | | | | (26) | | | | 362 | |
Less: net income attributable to the noncontrolling interest | | | 16 | | | | - | | | | - | | | | 16 | |
NET INCOME ATTRIBUTABLE TO PARENT | | $ | 234 | | | $ | 138 | | | $ | (26) | | | $ | 346 | |
BASIC EARNINGS PER SHARE OF COMMON STOCK | | $ | 3.02 | | | $ | 3.02 | | | | | | | $ | 2.98 | |
WEIGHTED-AVERAGE NUMBER OF BASIC SHARES OUTSTANDING | | | 77.4 | | | | 45.7 | | | | (7.1) | (f) | | | 116.0 | |
DILUTED EARNINGS PER SHARE OF COMMON STOCK | | $ | 3.00 | | | $ | 3.02 | | | | | | | $ | 2.97 | |
WEIGHTED-AVERAGE NUMBER OF DILUTED SHARES OUTSTANDING | | | 77.8 | | | | 45.7 | | | | (7.1) | (f) | | | 116.4 | |
See accompanying Notes to the Pro Forma Condensed Combined Consolidated Financial Statements, which are an integral part of these statements.
AGL RESOURCES INC. AND NICOR INC.
UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED STATEMENT OF FINANCIAL POSITION
As of and for the Year Ended December 31, 2010
| | AGL | | | | | | Pro Forma | | | Pro Forma | |
| | Resources | | | Nicor (a) | | | Adjustments | | | Combined | |
| | | | | (In millions) | | | | |
| | | | | | | | | | | | | | | | |
ASSETS |
Current Assets: | | | | | | | | | | | | | | | | |
Cash and cash equivalents | | $ | 24 | | | $ | 32 | | | $ | - | | | $ | 56 | |
Total receivables | | | 1,162 | | | | 472 | | | | - | | | | 1,634 | |
Inventories, net | | | 639 | | | | 164 | | | | - | | | | 803 | |
Derivative financial instruments | | | 182 | | | | 49 | | | | - | | | | 231 | |
Recoverable regulatory assets | | | 69 | | | | 35 | | | | 54 | (g) | | | 158 | |
Other current assets | | | 86 | | | | 202 | | | | - | | | | 288 | |
| | | 2,162 | | | | 954 | | | | 54 | | | | 3,170 | |
| | | | | | | | | | | | | | | | |
Property, plant and equipment, net | | | 4,405 | | | | 3,023 | | | | 13 | (h) | | | 7,441 | |
| | | | | | | | | | | | | | | | |
Goodwill | | | 418 | | | | 27 | | | | 1,351 | (i) | | | 1,796 | |
Recoverable regulatory assets | | | 452 | | | | 242 | | | | - | | | | 694 | |
Derivative financial instruments | | | 46 | | | | 18 | | | | - | | | | 64 | |
Other | | | 35 | | | | 233 | | | | 43 | (j) | | | 311 | |
| | | | | | | | | | | | | | | | |
| | $ | 7,518 | | | $ | 4,497 | | | $ | 1,461 | | | $ | 13,476 | |
|
LIABILITIES AND EQUITY |
Current Liabilities: | | | | | | | | | | | | | | | | |
Short-term debt | | $ | 733 | | | $ | 425 | | | $ | - | | | $ | 1,158 | |
Accounts payable | | | 928 | | | | 282 | | | | - | | | | 1,210 | |
Current portion of long-term debt | | | 300 | | | | - | | | | - | | | | 300 | |
Accrued expenses | | | 141 | | | | 86 | | | | 72 | (k) | | | 299 | |
Derivative financial instruments | | | 44 | | | | 83 | | | | - | | | | 127 | |
Accrued regulatory liabilities | | | 103 | | | | 41 | | | | - | | | | 144 | |
Other current liabilities | | | 179 | | | | 157 | | | | - | | | | 336 | |
| | | 2,428 | | | | 1,074 | | | | 72 | | | | 3,574 | |
| | | | | | | | | | | | | | | | |
Long-term debt | | | 1,673 | | | | 498 | | | | 1,031 | (l) | | | 3,202 | |
Accumulated deferred income taxes | | | 768 | | | | 423 | | | | 18 | (m) | | | 1,209 | |
Accrued regulatory liabilities | | | 508 | | | | 875 | | | | - | | | | 1,383 | |
Accrued pension and postretirement expenses | | | 222 | | | | 230 | | | | - | | | | 452 | |
Derivative financial instruments | | | 4 | | | | 19 | | | | - | | | | 23 | |
Other long-term liabilities and other deferred credits | | | 79 | | | | 274 | | | | - | | | | 353 | |
| | | 3,254 | | | | 2,319 | | | | 1,049 | | | | 6,622 | |
| | | | | | | | | | | | | | | | |
Equity: | | | | | | | | | | | | | | | | |
Common shareholders’ equity | | | 1,813 | | | | 1,104 | | | | 340 | (n) | | | 3,257 | |
Noncontrolling interest | | | 23 | | | | - | | | | - | | | | 23 | |
| | | 1,836 | | | | 1,104 | | | | 340 | | | | 3,280 | |
| | | | | | | | | | | | | | | | |
| | $ | 7,518 | | | $ | 4,497 | | | $ | 1,461 | | | $ | 13,476 | |
See accompanying Notes to the Pro Forma Condensed Combined Consolidated Financial Statements, which are an integral part of these statements.
NOTES TO THE UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED FINANCIAL STATEMENTS
Note 1. | Basis of Pro Forma Presentation |
The pro forma statement of income for the year ended December 31, 2010, gives effect to the merger as if it were completed on January 1, 2010. The pro forma statement of financial position as of December 31, 2010, gives effect to the merger as if it were completed on December 31, 2010.
The pro forma financial statements have been derived from the historical consolidated financial statements of AGL Resources and Nicor. Assumptions and estimates underlying the pro forma adjustments are described in the accompanying notes, which should be read in conjunction with the pro forma financial statements. Since the pro forma financial statements have been prepared based upon preliminary estimates, the final amounts recorded at the date of the merger may differ materially from the information presented. These estimates are subject to change pending further review of the assets acquired and liabilities assumed.
The merger is reflected in the pro forma financial statements as being accounted for based on the guidance provided by Accounting Standards Codification (ASC) 805 (sometimes referred to as ASC 805), Business Combinations. Under the acquisition method, the total estimated purchase price is calculated as described in Note 2 to the pro forma financial statements. In accordance with ASC 805, the assets acquired, and the liabilities assumed, have been measured at fair value. The fair value measurements utilize estimates based on key assumptions of the merger, including prior acquisition experience, benchmarking of similar acquisitions and historical and current market data. The pro forma adjustments included herein may be revised as additional information becomes available and as additional analyses are performed. The final purchase price allocation will be determined after the merger is completed and the final amounts recorded for the merger may differ materially from the information presented.
Estimated transaction costs have been excluded from the pro forma statement of income as they reflect non-recurring charges directly related to the merger. However, the anticipated transaction costs are reflected in the pro forma balance sheet, as an accrual to accrued expenses and a reduction to retained earnings.
The pro forma financial statements do not reflect any cost savings (or associated costs to achieve such savings) from operating efficiencies, synergies or other restructuring that could result from the merger. Further, the pro forma financial statements do not reflect the effect of any regulatory actions that may impact the pro forma financial statements when the merger is completed.
Nicor’s regulated operations are primarily comprised of the distribution of natural gas. These operations are subject to the rate-setting authority of the Illinois Commerce Commission (sometimes referred to as the Illinois Commission) and are accounted for pursuant to ASC 980, Regulated Operations. The pro forma financial statements have been prepared on a basis assuming that the merger will not have an impact on the determination of utility service rates for Nicor’s regulated operations. However, any change in the rate-setting practices of the Illinois Commission could have a material effect on Nicor’s financial statements. The rate-setting and cost recovery provisions currently in place for Nicor’s regulated operations provide revenues derived from costs including a return on investment of net assets and liabilities included in rate base. Thus, the fair values of Nicor’s tangible and intangible assets and liabilities subject to these rate-setting provisions approximate their carrying values, and the pro forma financial statements do not reflect any adjustments related to these amounts.
For the purpose of measuring the estimated fair value of the assets acquired and liabilities assumed, as reflected in the pro forma financial statements, AGL Resources has applied ASC 820, Fair Value Measurements and Disclosures, which defines fair value as the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date.
Note 2. | Preliminary Purchase Price |
AGL Resources will acquire all of the outstanding shares of Nicor’s common stock. Nicor shareholders will be entitled to receive for each share of Nicor common stock, $21.20 in cash and 0.8382 of a share of AGL Resources common stock. The purchase price for the merger is estimated as follows:
Nicor shares outstanding at February 16, 2011 (millions) | | | 45.5 | |
Estimated additional shares outstanding under Nicor’s stock compensation plans granted prior to the execution of the merger agreement (millions) | | | 0.6 | |
Estimated Nicor shares outstanding (millions) | | | 46.1 | |
Exchange ratio | | | 0.8382 | |
Number of shares of AGL Resources to be issued (millions) | | | 38.6 | |
Closing price of AGL Resources common stock on March 4, 2011 | | $ | 38.71 | |
Cost of equity issued (millions) | | $ | 1,496 | |
Estimated Nicor shares outstanding (millions) | | | 46.1 | |
Cash payment per share of Nicor common stock | | $ | 21.20 | |
Cost of debt issued (millions) | | $ | 977 | |
Total purchase price (millions) | | $ | 2,473 | |
The preliminary purchase price was computed using (i) Nicor’s estimated shares outstanding and the market value of AGL Resources’ common stock anticipated to be issued in connection with the merger based on the closing price of AGL Resources’ common stock on March 4, 2011 and (ii) the cost of debt to be issued based on Nicor’s estimated shares outstanding and the commitment to pay cash of $21.20 per Nicor common share.
The preliminary purchase price will fluctuate with the market price of AGL Resources’ common stock until it is reflected on an actual basis when the merger is completed. An increase or decrease of 10% in AGL Resources’ common stock price would increase or decrease the consideration transferred by approximately $150 million, which would be reflected as an increase or decrease to the purchase price of Nicor. The increase or decrease in AGL Resources’ common stock price by as much as 10% is reasonably possible based upon the recent history of AGL Resources’ common stock price.
Note 3. | Pro Forma Adjustments |
The pro forma adjustments included in the pro forma financial statements are as follows:
Adjustments to Pro Forma Financial Statements
(a) AGL Resources and Nicor historical presentation — Based on the amounts reported in the Consolidated Statement of Income and Statements of Financial Position of AGL Resources and Nicor, certain financial line items included in Nicor’s historical presentation have been reclassified to corresponding line items included in AGL Resources’ historical presentation. These reclassifications have no material impact on the historical operating income, net income, earnings available to parent, total assets, liabilities or shareholder’ equity reported by AGL Resources or Nicor.
Additionally, based on AGL Resources’ review of Nicor’s summary of significant accounting policies disclosed in Nicor’s financial statements and preliminary discussions with Nicor management, the nature and amount of any adjustments to the historical financial statements of Nicor to conform its accounting policies to those of AGL Resources are not expected to be material. Upon completion of the merger, further review of Nicor’s accounting policies and financial statements may result in revisions to Nicor’s policies and classifications to conform to AGL Resources.
The allocation of the preliminary purchase price to the fair values of assets acquired and liabilities assumed includes pro forma adjustments for the fair value Nicor’s assets and liabilities. The final allocation of the purchase price could differ materially from the preliminary allocation used for the Unaudited Pro Forma Condensed Combined Consolidated Statement of Financial Position. The allocation of the preliminary purchase price is as follows (in millions):
Current assets | | $ | 1,008 | |
Property, plant and equipment | | | 3,036 | |
Goodwill | | | 1,378 | |
Other noncurrent assets, excluding goodwill | | | 527 | |
Current liabilities | | | (1,086) | |
Noncurrent liabilities | | | (2,390) | |
Purchase price | | $ | 2,473 | |
Adjustments to Pro Forma Condensed Combined Consolidated Statement of Income
(b) Operation and maintenance — Represents a decrease in operation and maintenance expense by removing the non-recurring transaction costs incurred through December 31, 2010.
(c) Provision for depreciation and amortization, net — Represents the net incremental depreciation expense and incremental amortization of identified intangibles resulting from the pro forma fair value adjustment of Nicor’s unregulated property, plant and equipment. The estimate is preliminary, subject to change and could vary materially from the actual adjustment at the time the merger is completed.
(d) Interest expense — Represents an increase in interest expense as the result of AGL Resources borrowing an additional $977 million to fund the cash payment requirement of $21.20 for each outstanding common share of Nicor. AGL Resources’ borrowing rate is tied to the U.S. Bond yield rate which is variable in nature. An increase or decrease of one-eighth percent to the U.S. Bond yield rate would increase or decrease AGL Resources’ interest expense by $1 million.
(e) Income taxes — Adjustment reflects the income tax effect of the pro forma adjustments, which was calculated using an estimated statutory income tax rate of 37.0%.
(f) Shares outstanding — Reflects the elimination of Nicor’s common stock offset by issuance of approximately 38.6 million shares of AGL Resources common stock. This share issuance does not consider that fractional shares will be paid in cash. The pro forma weighted-average number of basic shares outstanding is calculated by adding AGL Resources’ weighted-average number of basic shares of common stock outstanding for the year ended December 31, 2010, to the number of AGL Resources’ shares expected to be issued as a result of the merger. The pro forma weighted-average number of diluted shares outstanding is calculated by adding AGL Resources’ weighted-average number of diluted shares of common stock outstanding for the year ended December 31, 2010, to the number of AGL Resources’ shares expected to be issued as a result of the merger.
| | Year Ended |
| | December 31, |
| | 2010 |
Basic (millions): | | |
AGL Resources weighted-average number of basic shares outstanding | | | 77.4 | |
Equivalent Nicor common shares after exchange | | | 38.6 | |
| | | 116.0 | |
Diluted (millions): | | | | |
AGL Resources weighted-average number of diluted shares outstanding | | | 77.8 | |
Equivalent Nicor common shares after exchange | | | 38.6 | |
| | | 116.4 | |
Adjustments to Pro Forma Condensed Combined Consolidated Balance Sheet
(g) Regulatory assets — Represents the estimated fair value adjustment of $54 million, based on prevailing market prices at December 31, 2010, associated with AGL Resources assuming Nicor’s debt.
(h) Property, Plant and Equipment — Reflects an increase to record Nicor’s unregulated property, plant and equipment to the estimated fair value. The estimate is preliminary, subject to change and could vary materially from the actual adjustment at the time the merger is completed.
(i) Goodwill — Reflects the preliminary estimate of the excess of the purchase price paid over the fair value of Nicor’s assets acquired and liabilities assumed. The estimated purchase price of the transaction, based on the closing price of AGL Resources common stock on the NYSE on March 4, 2011, and the excess purchase price over the fair value of the assets acquired and liabilities assumed is calculated as follows (in millions):
Purchase price | | $ | 2,473 | |
Less: Fair value of net assets acquired | | | 1,095 | |
Less: Nicor existing goodwill | | | 27 | |
Pro forma goodwill adjustment | | $ | 1,351 | |
(j) Other assets — Represents (i) the estimated fair value of $34 million associated with customer relationships, trade names and other intangible assets in the retail, wholesale and shipping segments of Nicor and (ii) the estimated debt issuance costs of $9 million associated with the issuance of $977 million of debt instruments by AGL Resources. The debt issuance costs will be amortized over the life of the debt.
(k) Accrued expenses — Reflects the accrual for estimated non-recurring transaction costs of $78 million to be incurred after December 31, 2010, partially offset by the current portion of income tax expense of $6 million.
(l) Debt — In connection with the merger agreement, AGL Resources will assume all of Nicor’s outstanding debt. The pro forma adjustments represent the issuance of $977 million of debt by AGL Resources and the fair value adjustment of Nicor’s debt based on prevailing market prices at December 31, 2010 of $54 million.
(m) Accumulated deferred income taxes — Represents the estimated deferred tax liability, based on AGL Resources’ estimated post-merger composite statutory tax rate of 37.0% multiplied by the fair value adjustments recorded to the assets acquired and liabilities assumed, excluding goodwill. This estimated tax rate is different from AGL Resources’ effective tax rate for the year ended December 31, 2010, which includes other tax charges or benefits, and does not take into account any historical or possible future tax events that may impact the combined company.
(n) Equity — The pro forma balance sheet reflects the elimination of Nicor’s historical equity balance, recognition of additional 38.6 million AGL Resources common shares issued and adjustment to reduce retained earnings by $52 million (net of tax) for the remaining estimated non-recurring transaction costs. These transaction costs are shown as an adjustment to retained earnings to reflect the impact of accounting guidance applicable to business combinations, which requires that these costs be expensed. Estimated transaction costs have been excluded from the pro forma income statement as they reflect non-recurring charges directly related to the merger.