Exhibit 99.2

SELECTED UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED FINANCIAL DATA

The unaudited pro forma condensed combined consolidated statements of operations information for the three months ended March 31, 2012, and the year ended December 31, 2011, give effect to the merger as if it had occurred on January 1, 2011. The unaudited pro forma condensed combined consolidated balance sheet information as of March 31, 2012, gives effect to the merger as if it had occurred on March 31, 2012.

We present the unaudited pro forma condensed combined consolidated financial statements for illustrative purposes only, and they are not necessarily indicative of the 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. Future results may vary significantly from the results reflected because of various factors, including those discussed in this document under the heading “Risk Factors” beginning on page 20. You should read the following selected unaudited pro forma condensed combined consolidated financial information in conjunction with the “Unaudited Pro Forma Condensed Combined Consolidated Financial Information” and related notes included in this document beginning on page 143.

1

COMPARATIVE HISTORICAL AND UNAUDITED PRO FORMA PER SHARE FINANCIAL DATA

The following tables present: (1) historical per share information for Duke Energy; (2) pro forma per share information of the combined company after giving effect to the merger; and (3) historical and equivalent pro forma per share information for Progress Energy.

We derived the combined company pro forma per share information primarily by combining information from the historical consolidated financial statements of Duke Energy and Progress Energy. You should read these tables together with the historical consolidated financial statements of Duke Energy and Progress Energy that are filed with the SEC. You should not rely on the pro forma per share information as being necessarily indicative of actual results had the merger occurred on January 1, 2011, for statement of operations purposes or March 31, 2012, for book value per share data.

2

UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED

FINANCIAL STATEMENTS

The Unaudited Pro Forma Condensed Combined Consolidated Financial Statements (which we refer to as the pro forma financial statements) have been primarily derived from the historical consolidated financial statements of Duke Energy and Progress Energy.

The Unaudited Pro Forma Condensed Combined Consolidated Statements of Operations (which we refer to as the pro forma statements of operations) for the three months ended March 31, 2012 and the year ended December 31, 2011, give effect to the merger as if it were completed on January 1, 2011. The Unaudited Pro Forma Condensed Combined Consolidated Balance Sheet (which we refer to as the pro forma balance sheet) as of March 31, 2012, gives effect to the merger as if it were completed on March 31, 2012.

The merger agreement provides that each outstanding share of Progress Energy common stock (other than shares owned by Progress Energy (other than in a fiduciary capacity), Duke Energy, or Diamond Acquisition Corporation, which will be cancelled) will be converted into the right to receive 2.6125 shares of Duke Energy common stock subject to appropriate adjustment for a reverse stock split of the Duke Energy common stock as contemplated in the merger agreement and with cash generally to be paid in lieu of fractional shares. The exchange ratio will be adjusted proportionately to reflect a 1-for-3 reverse stock split with respect to the issued and outstanding Duke Energy common stock that Duke Energy plans to implement prior to, and conditioned on, the completion of the merger. The resulting adjusted exchange ratio will be 0.87083 of a share of Duke Energy common stock for each share of Progress Energy common stock. The pro forma statement of operations illustrates pro forma earnings per common share and weighted average common shares outstanding based both on the unadjusted exchange ratio of 2.6125 and the reverse stock split adjusted exchange ratio of 0.87083.

The historical consolidated financial information has been adjusted in the pro forma financial statements to give effect to pro forma events that are: (1) directly attributable to the merger; (2) factually supportable; and (3) with respect to the statement of operations, expected to have a continuing impact on the combined results of Duke Energy and Progress Energy. As such, the impact from merger-related expenses is not included in the accompanying pro forma statement of operations. However, the impact of estimated future merger-related expenses is reflected in the pro forma balance sheet as an increase to accounts payable and a decrease to retained earnings.

The pro forma financial statements do not reflect any cost savings from operating efficiencies (e.g., savings related to fuel and joint dispatch of the combined entity’s generation) or associated costs to achieve such savings (e.g., potential costs associated with a wholesale market power mitigation plan, which are disclosed in Duke Energy’s Form 10-Q for the three months ended March 31, 2012), 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. In addition, the pro forma financial statements do not purport to project the future financial position or operating results of the combined company. Transactions between Progress Energy and Duke Energy during the periods presented in the pro forma financial statements have been eliminated as if Duke Energy and Progress Energy were consolidated affiliates during the periods.

United States generally accepted accounting principles require that one party to the merger be identified as the acquirer. In accordance with these standards, the merger of Duke Energy and Progress Energy will be accounted for as an acquisition of Progress Energy common stock by Duke Energy and will follow the acquisition method of accounting for business combinations. The purchase price will ultimately be determined on the acquisition date based upon the fair value of the shares of Duke Energy common stock issued in the merger. The purchase price for the pro forma financial statements is based on the closing price of Duke Energy common stock on the NYSE on May 7, 2012, of $21.47 per share and the exchange of Progress Energy’s outstanding shares of common stock for the right to receive 2.6125 shares of Duke Energy common stock (refer to Note 2 to the pro forma financial statements for additional information related to the preliminary purchase price).

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 and the final purchase price.

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.

3

The following pro forma financial statements should be read in conjunction with:

4

DUKE ENERGY CORPORATION AND PROGRESS ENERGY, INC.

UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED STATEMENT OF OPERATIONS

For the Three Months Ended March 31, 2012

(In millions, except per-share amounts)

See accompanying Notes to the Unaudited Pro Forma Condensed Combined Consolidated Financial Statements, which are an integral part of these statements.

5

DUKE ENERGY CORPORATION AND PROGRESS ENERGY, INC.

UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED STATEMENT OF OPERATIONS

For the Year Ended December 31, 2011

(In millions, except per-share amounts)

See accompanying Notes to the Unaudited Pro Forma Condensed Combined Consolidated Financial Statements, which are an integral part of these statements.

6

DUKE ENERGY CORPORATION AND PROGRESS ENERGY, INC.

UNAUDITED PRO FORMA CONDENSED COMBINED CONSOLIDATED BALANCE SHEET

As of March 31, 2012

(In millions)

See accompanying Notes to the Unaudited Pro Forma Condensed Combined Consolidated Financial Statements, which are an integral part of these statements.

7

NOTES TO THE UNAUDITED PRO FORMA CONDENSED

COMBINED CONSOLIDATED FINANCIAL STATEMENTS

Note 1. Basis of Pro Forma Presentation

The pro forma statements of operations for the three months ended March 31, 2012, and the year ended December 31, 2011, give effect to the merger as if it were completed on January 1, 2011. The pro forma balance sheet as of March 31, 2012, gives effect to the merger as if it were completed on March 31, 2012.

The pro forma financial statements have been derived from the historical consolidated financial statements of Duke Energy and Progress Energy. Assumptions and estimates underlying the pro forma adjustments are described in these 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 an acquisition of Progress Energy by Duke Energy, based on the guidance provided by accounting standards for business combinations. Under these accounting standards, the total estimated purchase price is calculated as described in Note 2 to the pro forma financial statements, and the assets acquired and the liabilities assumed have been measured at estimated fair value. For the purpose of measuring the estimated fair value of the assets acquired and liabilities assumed, Duke Energy has applied the accounting guidance for fair value measurements. Fair value is defined as the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants as of the measurement date. The fair value measurements utilize estimates based on key assumptions of the merger, including historical and current market data. The pro forma adjustments included herein are preliminary and will be revised at the time of the merger as additional information becomes available and as additional analyses are performed. The final purchase price allocation will be determined at the time that the merger is completed, and the final amounts recorded for the merger may differ materially from the information presented.

Estimated merger-related costs have been excluded from the pro forma statements of operations 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 increase to accounts payable and a decrease to retained earnings.

The pro forma financial statements do not reflect any cost savings from operating efficiencies (e.g., savings related to fuel and joint dispatch of the combined entity’s generation) or associated costs to achieve such savings (e.g., potential costs associated with a wholesale market power mitigation plan, which are disclosed in Duke Energy’s Form 10-Q for the three months ended March 31, 2012), 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.

Progress Energy’s regulated operations comprise electric generation, transmission and distribution operations. These operations are subject to the rate-setting authority of the Federal Energy Regulatory Commission, the North Carolina Utilities Commission, the Public Service Commission of South Carolina, and the Florida Public Service Commission and are accounted for pursuant to U.S. generally accepted accounting principles, including the accounting guidance for regulated operations. The rate-setting and cost recovery provisions currently in place for Progress Energy’s regulated operations provide revenues derived from costs including a return on investment of assets and liabilities included in rate base. Thus, the fair values of Progress Energy’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 net adjustments related to these amounts.

8

NOTES TO THE UNAUDITED PRO FORMA CONDENSED

COMBINED CONSOLIDATED FINANCIAL STATEMENTS — (Continued)

Note 2. Preliminary Purchase Price

The merger agreement provides that each outstanding share of Progress Energy common stock (other than shares owned by Progress Energy (other than in a fiduciary capacity), Duke Energy, or Diamond Acquisition Corporation, which will be cancelled) will be converted into the right to receive 2.6125 shares of Duke Energy common stock subject to appropriate adjustment for a reverse stock split of the Duke Energy common stock as contemplated in the merger agreement and with cash generally to be paid in lieu of fractional shares. Each outstanding option to acquire, and each outstanding equity award relating to, one share of Progress Energy common stock will be converted into an option to acquire, or an equity award relating to, 2.6125 shares of Duke Energy common stock, as applicable, subject to appropriate adjustment for the reverse stock split. The exchange ratio will be adjusted proportionately to reflect a 1-for-3 reverse stock split with respect to the issued and outstanding Duke Energy common stock that Duke Energy plans to implement prior to, and conditioned on, the completion of the merger. The resulting adjusted exchange ratio is 0.87083 of a share of Duke Energy common stock for each share of Progress Energy common stock.

The purchase price for the merger is estimated as follows (shares in thousands):

The preliminary purchase price was computed using Progress Energy’s outstanding shares as of March 31, 2012, adjusted for the exchange ratio. The preliminary purchase price reflects the market value of Duke Energy’s common stock to be issued in connection with the merger based on the closing price of Duke Energy’s common stock on May 7, 2012. The preliminary purchase price also reflects the total estimated fair value of Progress Energy stock compensation awards outstanding as of March 31, 2012, excluding the value associated with employee service yet to be rendered.

The preliminary purchase price as adjusted for the reverse stock split assumes that the reverse stock split will result in the price of Duke Energy common stock increasing by a factor of 3. It should be noted that there is no guarantee that the Duke Energy reverse stock split will result in a proportionate increase in the market price of Duke Energy common stock.

The preliminary purchase price will fluctuate with the market price of Duke Energy’s common stock until it is reflected on an actual basis when the merger is completed. An increase or decrease of 20 percent in Duke Energy’s common share price from the price used above would increase or decrease the purchase price by approximately $3,300 million.

Note 3. Adjustments to Pro Forma Financial Statements

The pro forma adjustments included in the pro forma financial statements are as follows:

(a) Duke Energy and Progress Energy historical presentation. Based on the amounts reported in the consolidated statements of operations and balance sheets of Duke Energy and Progress Energy as of and for the three months ended March 31, 2012, and in the consolidated statements of operations of Duke Energy and Progress Energy for the year ended December 31, 2011, certain financial statement line items included in Progress Energy’s historical presentation have been reclassified to conform to corresponding financial statement line items included in Duke Energy’s historical presentation. These reclassifications have no material impact on the historical operating income, net income from continuing operations attributable to controlling interests, total assets, liabilities or shareholders’ equity reported by Duke Energy or Progress Energy. The accompanying pro forma statements of operations exclude the results of discontinued operations.

9

NOTES TO THE UNAUDITED PRO FORMA CONDENSED

COMBINED CONSOLIDATED FINANCIAL STATEMENTS — (Continued)

Additionally, based on Duke Energy’s review of Progress Energy’s summary of significant accounting policies disclosed in Progress Energy’s financial statements and preliminary discussions with Progress Energy management, the nature and amount of any adjustments to the historical financial statements of Progress Energy to conform its accounting policies to those of Duke Energy are not expected to be material. Upon completion of the merger, further review of Progress Energy’s accounting policies and financial statements may result in revisions to Progress Energy’s policies and classifications to conform to Duke Energy.

The allocation of the preliminary purchase price to the fair values of assets acquired and liabilities assumed includes pro forma adjustments to reflect the fair values of Progress Energy’s assets and liabilities. The allocation of the preliminary purchase price is as follows (in millions):

Adjustments to Pro Forma Condensed Combined Consolidated Statement of Operations

(b) Operating Revenues – Regulated Electric and Operating Expenses – Fuel Used in Electric Generation and Purchase Power – Regulated. Primarily reflects the elimination of electric transmission transactions between Duke Energy and Progress Energy that occurred during the three months ended March 31, 2012, and the year ended December 31, 2011, as if Duke Energy and Progress Energy were consolidated affiliates during the periods.

(c) Operating Expenses – Operation, Maintenance and Other. Reflects the elimination of approximately $10 million for the three months ended March 31, 2012, and approximately $85 million for the year ended December 31, 2011, in nonrecurring transaction and integration costs directly attributable to the merger. Also refer to Note 3(k).

(d) Interest Expense. The net adjustment amount reflects a reduction in interest expense as a result of the amortization of the pro forma fair value adjustment of Progress Energy’s parent company debt ($10 million for the three months ended March 31, 2012 and $40 million for the year ended December 31, 2011) and the elimination of amortization of deferred costs related to this debt ($2 million for the three months ended March 31, 2012, and $7 million for the year ended December 31, 2011). The effect of the fair value adjustment is being amortized over the remaining life of the individual debt issuances, with the longest amortization period being approximately 27 years. The final fair value determination of the debt will be based on prevailing market interest rates at the completion of the merger and the necessary adjustment will be amortized as a reduction (in the case of a premium to book value) or an increase (in the case of a discount to book value) to interest expense over the remaining life of the individual debt issuances. The portion of the adjustment related to Progress Energy’s regulated company debt is offset by a net increase to regulatory assets, and amortization of these adjustments ($22 million for the three months ended March 31, 2012, and $89 million for the year ended December 31, 2011) offset each other with no effect on earnings.

(e) Income Tax Expense. The pro forma adjustments include the income tax effects of the pro forma adjustments calculated using an estimated statutory income tax rate of 39%. This estimated tax rate is different from Duke Energy’s effective tax rate for the three months ended March 31, 2012, and the year ended December 31, 2011, which include other tax charges or benefits, and does not take into account any historical or possible future tax events that may impact the combined company.

(f) Shares Outstanding. Reflects the elimination of Progress Energy’s common stock and the issuance of approximately 773 million common shares of Duke Energy using the unadjusted exchange ratio of 2.6125; or 258 million shares using the adjusted exchange ratio of 0.87083. The adjusted exchange ratio of 0.87083 reflects the planned 1-for-3 reverse stock split, as discussed in Note 2. This share issuance does not consider that fractional shares will be paid in cash, as applicable.

10

NOTES TO THE UNAUDITED PRO FORMA CONDENSED

COMBINED CONSOLIDATED FINANCIAL STATEMENTS — (Continued)

The pro forma weighted average number of basic shares outstanding is calculated by adding Duke Energy’s weighted average number of basic shares outstanding for the three months ended March 31, 2012, and for the year ended December 31, 2011 (presented without consideration of the planned reverse stock split and also presented to adjust for the planned reverse stock split), and the number of Duke Energy shares expected to be issued to Progress Energy shareholders as a result of the merger (presented without consideration of the planned reverse stock split and also presented to adjust for the planned reverse stock split). The pro forma weighted average number of diluted shares outstanding is calculated by adding Duke Energy’s weighted average number of diluted shares outstanding for the three months ended March 31, 2012, and for the year ended December 31, 2011 (presented without consideration of the planned reverse stock split and also presented to adjust for the planned reverse stock split), and the number of Duke Energy shares expected to be issued as a result of the merger (presented without consideration of the planned reverse stock split and also presented to adjust for the planned reverse stock split).