Attached files

file filename
8-K - FORM 8-K - AETNA INC /PA/dp33001_8k.htm
EX-99.4 - EXHIBIT 99.4 - AETNA INC /PA/dp33001_ex9904.htm
EX-99.3 - EXHIBIT 99.3 - AETNA INC /PA/dp33001_ex9903.htm
EX-99.2 - EXHIBIT 99.2 - AETNA INC /PA/dp33001_ex9902.htm

Exhibit 99.5

 

AETNA AND COVENTRY UNAUDITED PRO FORMA CONDENSED COMBINED FINANCIAL STATEMENTS

The unaudited pro forma condensed combined statements of income for the fiscal year ended December 31, 2011, and for the six months ended June 30, 2012, combine the historical consolidated statements of income of Aetna and Coventry, giving effect to the merger of a wholly owned subsidiary of Aetna (which is referred to as Merger Sub) with and into Coventry (which is referred to as the merger) as if it had occurred on January 1, 2011. The unaudited pro forma condensed combined balance sheet as of June 30, 2012, combines the historical consolidated balance sheets of Aetna and Coventry, giving effect to the merger as if it had occurred on June 30, 2012. The historical consolidated financial information has been adjusted in the unaudited pro forma condensed combined 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 statements of income, expected to have a continuing impact on the combined results. The unaudited pro forma condensed combined financial information should be read in conjunction with the accompanying notes to the unaudited pro forma condensed combined financial statements. In addition, the unaudited pro forma condensed combined financial information was based on and should be read in conjunction with the following historical consolidated financial statements and accompanying notes:

 

   

separate historical financial statements of Aetna as of, and for the year ended, December 31, 2011, and the related notes included in Aetna’s Annual Report on Form 10-K for the year ended December 31, 2011;

 

   

separate historical financial statements of Coventry as of, and for the year ended, December 31, 2011, and the related notes included in Coventry’s Annual Report on Form 10-K for the year ended December 31, 2011;

 

   

separate historical financial statements of Aetna as of, and for the six months ended, June 30, 2012, and the related notes included in Aetna’s Quarterly Report on Form 10-Q for the quarterly period ended June 30, 2012; and

 

   

separate historical financial statements of Coventry as of, and for the six months ended, June 30, 2012, and the related notes included in Coventry’s Quarterly Report on Form 10-Q for the quarterly period ended June 30, 2012.

The unaudited pro forma condensed combined financial information has been prepared by Aetna using the acquisition method of accounting in accordance with U.S. generally accepted accounting principles. The acquisition accounting is dependent upon certain valuation and other studies that have yet to commence or progress to a stage where there is sufficient information for a definitive measurement. The proposed merger has not yet received the necessary approvals from governmental authorities, and under the Hart-Scott-Rodino Antitrust Improvements Act of 1976, as amended, and the rules and regulations thereunder (which is referred to as the HSR Act) and other relevant laws and regulations, before completion of the merger, there are significant limitations regarding what Aetna can learn about Coventry. The assets and liabilities of Coventry have been measured based on various preliminary estimates using assumptions that Aetna believes are reasonable based on information that is currently available. Differences between these preliminary estimates and the final acquisition accounting will occur, and those differences could have a material impact on the accompanying unaudited pro forma condensed combined financial statements and the combined company’s future results of operations and financial position. The pro forma adjustments are preliminary and have been made solely for the purpose of providing unaudited pro forma condensed combined financial statements prepared in accordance with the rules and regulations of the Securities and Exchange Commission.

Aetna intends to commence the necessary valuation and other studies required to complete the acquisition accounting promptly upon completion of the merger and will finalize the acquisition accounting as soon as practicable within the required measurement period in accordance with Financial Accounting Standards Board, Accounting Standards Codification (which is referred to as ASC) 805, but in no event later than one year following completion of the merger.

 

1


 

The unaudited pro forma condensed combined financial information has been presented for informational purposes only. The unaudited pro forma condensed combined financial information does not purport to represent the actual results of operations that Aetna and Coventry would have achieved had the companies been combined during these periods and is not intended to project the future results of operations that the combined company may achieve after the merger. The unaudited pro forma condensed combined financial information does not reflect the realization of any cost savings following completion of the merger and also does not reflect any related restructuring and integration charges to achieve those cost savings. Material intercompany transactions between Aetna and Coventry during the periods presented in the unaudited pro forma condensed combined financial statements have been eliminated (refer to Note 7. Income Statement Pro Forma Adjustments and Note 8. Balance Sheet Pro Forma Adjustments).

 

2


 

Unaudited Pro Forma Condensed Combined

Statement of Income

For the Year Ended December 31, 2011

 

    Aetna     Coventry     Disposition
(Note 6)
    Pro Forma
Adjustments
(Note 7)
    Pro Forma
Combined
 
    (Millions, except per common share data)  

Revenue:

 

Health care and other premiums

  $ 28,965.0      $ 11,015.0      $ (138.4   $ —        $ 39,841.6   

Fees and other revenue

    3,884.0        1,191.3        —          (21.7 )(a)      5,053.6   

Net investment income

    930.8        69.4        (.8     (35.8 )(b)(c)      963.6   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total revenue

    33,779.8        12,275.7        (139.2     (57.5     45,858.8   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Benefits and expenses:

         

Health care costs and benefits

    23,530.0        9,324.9        (125.2     —          32,729.7   

Selling, general and administrative expenses

    6,925.1        1,993.6        (14.5     23.3 (a)(d)(e)      8,927.5   

Interest expense

    246.9        99.1        —          30.5 (f)      376.5   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total benefits and expenses

    30,702.0        11,417.6        (139.7     53.8        42,033.7   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income before income taxes

    3,077.8        858.1        .5        (111.3     3,825.1   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income tax expense

    1,092.1        315.0        .2        (39.0 )(g)      1,368.3   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income

  $ 1,985.7      $ 543.1      $ .3      $ (72.3   $ 2,456.8   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Earnings per common share:

         

Basic

  $ 5.33      $ 3.75          $ 5.79   
 

 

 

   

 

 

       

 

 

 

Diluted

  $ 5.22      $ 3.70          $ 5.68   
 

 

 

   

 

 

       

 

 

 

Weighted-average shares:

         

Basic

    372.5        144.8          (92.8 )(h)      424.5   
 

 

 

   

 

 

     

 

 

   

 

 

 

Diluted

    380.2        146.7          (94.7 )(h)      432.2   
 

 

 

   

 

 

     

 

 

   

 

 

 

See the accompanying notes to the unaudited pro forma condensed combined financial statements, which are an integral part of these statements. The pro forma adjustments are explained in Note 7. Income Statement Pro Forma Adjustments.

 

3


 

Unaudited Pro Forma Condensed Combined

Statement of Income

For the Six Months Ended June 30, 2012

 

    Aetna     Coventry     Disposition
(Note 6)
    Pro Forma
Adjustments (Note 7)
    Pro Forma
Combined
 
    (Millions, except per common share data)  

Revenue:

 

Health care and other premiums

  $ 15,300.4      $ 6,595.9      $ (76.4   $ —        $ 21,819.9   

Fees and other revenue

    1,987.1        632.4        —          (9.1 )(a)      2,610.4   

Net investment income

    463.4        36.4        (.5     (13.6 )(b)(c)      485.7   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total revenue

  $ 17,750.9      $ 7,264.7      $ (76.9   $ (22.7   $ 24,916.0   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Benefits and expenses:

         

Health care costs and benefits

  $ 12,760.0      $ 5,700.6      $ (67.2   $ —        $ 18,393.4   

Selling, general and administrative expenses

    3,387.2        1,087.5        (8.0     4.5 (a)(d)(e)      4,471.2   

Interest expense

    123.7        50.2        —          15.7 (f)      189.6   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total benefits and expenses

    16,270.9        6,838.3        (75.2     20.2        23,054.2   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income before income taxes

    1,480.0        426.4        (1.7     (42.9     1,861.8   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income tax expense

    511.4        163.9        (.6     (15.0 )(g)      659.7   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income

  $ 968.6      $ 262.5      $ (1.1   $ (27.9   $ 1,202.1   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Earnings per common share:

         

Basic

  $ 2.80      $ 1.86          $ 3.02   
 

 

 

   

 

 

       

 

 

 

Diluted

  $ 2.76      $ 1.85          $ 2.98   
 

 

 

   

 

 

       

 

 

 

Weighted-average shares:

         

Basic

    346.0        139.2          (87.2 )(h)      398.0   
 

 

 

   

 

 

     

 

 

   

 

 

 

Diluted

    351.5        139.9          (87.9 )(h)      403.5   
 

 

 

   

 

 

     

 

 

   

 

 

 

See the accompanying notes to the unaudited pro forma condensed combined financial statements, which are an integral part of these statements. The pro forma adjustments are explained in Note 7. Income Statement Pro Forma Adjustments.

 

4


 

Unaudited Pro Forma Condensed Combined

Balance Sheet

As of June 30, 2012

 

    Aetna     Coventry     Disposition
(Note 6)
    Pro Forma
Adjustments
(Note 8)
    Pro Forma
Combined
 
    (Millions)  

Assets:

         

Current assets:

         

Cash and cash equivalents

  $ 922.1      $ 1,516.0      $ (9.1   $ (931.5 )(a)    $ 1,497.5   

Investments

    2,347.0        177.9        —          —          2,524.9   

Premiums and other receivables, net

    1,625.9        1,207.3        (20.4     (2.4 )(b)      2,810.4   

Other current assets

    1,579.7        202.2        (.4     46.8 (c)      1,828.3   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current assets

    6,474.7        3,103.4        (29.9     (887.1     8,661.1   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Long-term investments

    18,331.0        2,535.0        —          (350.0 )(a)      20,516.0   

Goodwill

    6,202.2        2,590.0        (3.0     871.7 (d)      9,660.9   

Intangibles

    885.3        351.6        —          948.4 (e)      2,185.3   

Other long-term assets

    2,238.4        293.4        —          (74.4 )(a)(f)      2,457.4   

Separate Accounts assets

    5,321.1        —          —          —          5,321.1   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total assets

  $ 39,452.7      $ 8,873.4      $ (32.9   $ 508.6      $ 48,801.8   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Liabilities and shareholders’ equity:

         

Current liabilities:

         

Health care costs payable and unpaid claims

  $ 3,494.7      $ 1,491.4      $ (19.5   $ —        $ 4,966.6   

Short term debt

    —          —          —          500.0 (g)      500.0   

Accrued expenses and other current liabilities

    4,940.4        910.9        (13.4     162.4 (b)(h)      6,000.3   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current liabilities

    8,435.1        2,402.3        (32.9     662.4        11,466.9   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Long-term debt, less current portion

    4,706.3        1,584.9        —          2,190.0 (i)      8,481.2   

Other long-term liabilities

    10,734.4        379.9        —          239.9 (j)      11,354.2   

Separate Accounts liabilities

    5,321.1        —          —          —          5,321.1   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total liabilities

    29,196.9        4,367.1        (32.9     3,092.3        36,623.4   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Shareholders’ equity:

         

Common stock and additional paid-in-capital (1)

    1,039.8        30.0        (9.5     2,000.8 (k)      3,061.1   

Retained earnings

    10,270.9        4,410.5        11.4        (4,518.7 )(l)      10,174.1   

Accumulated other comprehensive loss

    (1,054.9     65.8        (1.9     (65.8 )(m)      (1,056.8
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total shareholders’ equity

    10,255.8        4,506.3        —          (2,583.7     12,178.4   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total liabilities and shareholders’ equity

  $ 39,452.7      $ 8,873.4      $ (32.9   $ 508.6      $ 48,801.8   
 

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

(1) On an historical basis, share information of Aetna is as follows: 2.6 billion shares authorized; 334.2 million shares issued and outstanding. On a pro forma combined basis, share information is as follows: 2.6 billion shares authorized; 386.2 million shares issued and outstanding.

See the accompanying notes to the unaudited pro forma condensed combined financial statements, which are an integral part of these statements. The pro forma adjustments are explained in Note 8. Balance Sheet Pro Forma Adjustments.

 

5


 

NOTES TO THE UNAUDITED PRO FORMA CONDENSED

COMBINED FINANCIAL STATEMENTS

 

1. Description of Transaction

On August 19, 2012, Aetna, Merger Sub and Coventry entered into the Agreement and Plan of Merger (which is referred to as the merger agreement), pursuant to which, subject to the terms and conditions set forth in the merger agreement, Coventry will become a wholly owned subsidiary of Aetna. Upon completion of the merger, each share of Coventry common stock issued and outstanding will be converted into the right to receive $27.30 in cash, without interest, and 0.3885 of an Aetna common share.

At completion of the merger, each option to purchase shares of Coventry common stock outstanding under any Coventry employee benefit plan, whether or not vested or exercisable, with a per share exercise price less than the sum of (a) $27.30 and (b) the product of (i) the Aetna closing price multiplied by 0.3885 (which sum is referred to as the equity award cash consideration and which options are referred to as in-the-money options), will be cancelled and converted into the right to receive an amount in cash, without interest and less applicable withholding taxes, equal to the product of (x) the excess of (i) the equity award cash consideration over (ii) the applicable per share exercise price of that in-the-money option multiplied by (y) the total number of shares of Coventry common stock underlying that in-the-money option. The average of the volume weighted averages of the trading prices for Aetna common shares on the New York Stock Exchange for each of the five trading days ending on the trading day that is two trading days prior to the completion of the merger is referred to as the Aetna closing price.

During the 60-day period following the date of the merger agreement, Aetna, in consultation with Coventry, will consider the appropriate treatment of each option to purchase shares of Coventry common stock outstanding under any Coventry employee benefit plan, whether or not vested or exercisable, with a per share exercise price equal to or greater than the equity award cash consideration (which options are referred to as underwriter options), taking into account the appropriate terms and conditions of each such underwater option.

At completion of the merger, each outstanding restricted share of Coventry common stock (which represents a share of Coventry common stock subject to vesting and forfeiture restrictions) will be converted into the right to receive the merger consideration payable to holders of shares of Coventry common stock, less applicable withholding taxes.

At completion of the merger, each Coventry performance share unit and restricted stock unit outstanding under any Coventry employee benefit plan (which are collectively referred to as Coventry stock units) that, pursuant to its terms as of the date of the merger agreement, is vested or becomes vested upon completion of the merger (and each Coventry stock unit held by Allen F. Wise), which are collectively referred to as cashed-out units, will be converted into the right to receive an amount in cash, without interest and less applicable withholding taxes, equal to the product of (a) the equity award cash consideration multiplied by (b) the number of shares of Coventry common stock underlying that cashed-out unit.

At completion of the merger, each Coventry stock unit outstanding under any Coventry employee benefit plan that, pursuant to its terms as of the date of the merger agreement, is not vested and will not become vested upon completion of the merger (other than the Coventry stock units held by Mr. Wise), which are referred to as rollover units, will be converted into a cash-settled Aetna restricted stock unit with the number of Aetna common shares underlying that cash-settled Aetna restricted stock unit equal to the product of (x) the number of shares of Coventry common stock underlying that rollover unit immediately prior to completion of the merger multiplied by (y) the quotient of (i) the equity award cash consideration divided by (ii) the Aetna closing price. Each such cash-settled Aetna restricted stock unit will be subject to the same terms and conditions (including service-based vesting) as applied to the corresponding rollover unit immediately prior to completion of the merger.

The merger is subject to adoption of the merger agreement by Coventry stockholders, early termination or expiration of the waiting period under the HSR Act, the required governmental authorizations having been obtained and being in full force and effect and other usual and customary conditions to completion. As of the date of this Current Report on Form 8-K, the merger is expected to be completed in mid-2013.

 

2. Basis of Presentation

The unaudited pro forma condensed combined financial information was prepared using the acquisition method of accounting and was based on the historical financial statements of Aetna and Coventry. The acquisition method of accounting is based on ASC 805 and uses the fair value concepts defined in ASC 820, Fair Value Measurements.

 

6


 

ASC 805 requires, among other things, that most assets acquired and liabilities assumed be recognized at their fair values as of the acquisition date. In addition, ASC 805 requires that the consideration transferred be measured at the date the merger is completed at the then-current market price. This requirement will likely result in a per share equity component that is different from the amount assumed in these unaudited pro forma condensed combined financial statements.

ASC 820 defines the term “fair value” and sets forth the valuation requirements for any asset or liability measured at fair value, expands related disclosure requirements and specifies a hierarchy of valuation techniques based on the nature of the inputs used to develop the fair value measures. Fair value is defined in ASC 820 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.” This is an exit price concept for the valuation of the asset or liability. In addition, market participants are assumed to be buyers and sellers in the principal (or the most advantageous) market for the asset or liability. Fair value measurements for an asset assume the highest and best use by these market participants. As a result of these standards, Aetna may be required to record the fair value of assets which are not intended to be used or sold and/or to value assets at fair value measures that do not reflect Aetna’s intended use of those assets. Many of these fair value measurements can be highly subjective, and it is possible that other professionals, applying reasonable judgment to the same facts and circumstances, could develop and support a range of alternative estimated amounts.

Under the acquisition method of accounting, the assets acquired and liabilities assumed will be recorded, as of completion of the merger, primarily at their respective fair values and added to those of Aetna. Financial statements and reported results of operations of Aetna issued after completion of the merger will reflect these values, but will not be retroactively restated to reflect the historical financial position or results of operations of Coventry.

Under ASC 805, acquisition-related transaction costs (e.g., advisory, legal, valuation and other professional fees) are not included as a component of consideration transferred but are accounted for as expenses in the periods in which the costs are incurred. Total acquisition-related transaction costs expected to be incurred by Aetna and Coventry are estimated to be approximately $120 million and $45 million, respectively, of which none had been incurred as of June 30, 2012. Acquisition-related transaction costs expected to be incurred by Aetna include estimated fees related to a bridge financing commitment and agreement and estimated interest costs associated with the expected issuance of long-term transaction-related debt in the fourth quarter of 2012. Those costs are reflected in the unaudited pro forma condensed combined balance sheet as an increase to accrued expenses and other current liabilities, with the related tax benefits reflected as an increase in other current assets and the after tax impact presented as a decrease to retained earnings.

The unaudited pro forma condensed combined financial statements do not reflect the projected realization of cost savings following completion of the merger. These cost savings opportunities are from administrative cost savings, as well as network and medical management savings. Although Aetna projects that cost savings will result from the merger, there can be no assurance that these cost savings will be achieved. The unaudited pro forma condensed combined financial statements do not reflect projected pretax restructuring and integration charges associated with the projected cost savings, which are projected to be approximately $250 million to $300 million over a period of three years following completion of the merger. Such restructuring and integration charges will be expensed in the appropriate accounting periods after completion of the merger.

 

3. Accounting Policies

At completion of the merger, Aetna will review Coventry’s accounting policies. As a result of that review, Aetna may identify differences between the accounting policies of the two companies that, when conformed, could have a material impact on the combined financial statements. At this time, Aetna is not aware of any differences that would have a material impact on the combined financial statements. The unaudited pro forma condensed combined financial statements assume there are no differences in accounting policies.

 

7


 
4. Estimate of Consideration Expected to be Transferred

The following is a preliminary estimate of consideration expected to be transferred to effect the acquisition of Coventry:

 

    Conversion
Calculation
     Estimated
Fair Value
     Form of
Consideration
    (Millions, except per common share data)

Consideration Transferred:

       

Number of shares of Coventry common stock outstanding at September 14, 2012

    132.6         

Multiplied by Aetna’s share price at September 14, 2012, multiplied by the exchange ratio ($39.04*0.3885)

  $ 15.17       $ 2,010.9       Aetna
Common Shares

Multiplied by the per common share cash consideration

  $ 27.30       $ 3,618.9       Cash
 

 

 

    

 

 

    

 

Number of shares underlying in-the-money Coventry stock options vested and unvested outstanding as of September 14, 2012, expected to be canceled and exchanged for cash

    5.2         

Multiplied by the excess, if any, of (1) the sum of (x) the per common share cash consideration plus (y) Aetna’s stock price at September 14, 2012, multiplied by the exchange ratio ($39.04*0.3885) over (2) the weighted-average exercise price of such in-the-money stock options

  $ 14.34       $ 73.9       Cash
 

 

 

    

 

 

    

 

Number of Coventry performance share units and restricted stock units outstanding at September 14, 2012, expected to be canceled and paid in cash (a)

    1.2         

Multiplied by the Equity Award Cash Consideration

  $ 42.47       $ 52.6       Cash
 

 

 

    

 

 

    

 

Number of Coventry restricted shares outstanding at September 14, 2012

    1.3         

Multiplied by Aetna’s stock price at September 14, 2012, multiplied by the exchange ratio ($39.04*0.3885)

  $ 15.17       $ 19.9       Aetna
Common Shares

Multiplied by the per common share cash consideration

  $ 27.30       $ 36.1       Cash
 

 

 

    

 

 

    

 

Estimate of Total Consideration Expected to be Transferred (b)

     $ 5,812.3      
    

 

 

    

 

Certain amounts may reflect rounding adjustments.

 

(a) Pursuant to the terms of the Employment Agreement between Coventry and Allen F. Wise, dated April 30, 2009, as amended on June 16, 2010 and January 31, 2012, on January 1, 2013, Mr. Wise is entitled to receive Coventry stock units with a grant date fair value of $7,600,000, which is referred to as the Wise 2013 Grant. The Wise 2013 Grant is not reflected in the table above.
   
(b) The estimated consideration expected to be transferred reflected in these unaudited pro forma condensed combined financial statements does not purport to represent the actual consideration that will be transferred when the merger is completed. In accordance with ASC 805, the fair value of equity securities issued as part of the consideration transferred will be measured on the date the merger is completed at the then-current market price. This requirement will likely result in a different value of the common share component of the purchase consideration and a per share equity component different from the $15.17 assumed in these unaudited pro forma condensed combined financial statements, and that difference may be material. For example, if the price of Aetna’s common shares on the date the merger is completed increased or decreased by 10% from the price assumed in these unaudited pro forma condensed combined financial statements, the consideration transferred would increase or decrease by approximately $211 million, which would be reflected in these unaudited pro forma condensed combined financial statements as an increase or decrease to goodwill.

 

8


 
5. Estimate of Assets to be Acquired and Liabilities to be Assumed

The following is a preliminary estimate of the assets to be acquired and the liabilities to be assumed by Aetna in the merger, reconciled to the estimate of total consideration expected to be transferred:

 

     At June 30, 2012  
     (Millions)  

Assets Acquired and Liabilities Assumed:

  

Net book value of net assets acquired

   $ 4,506.3   

Less historical:

  

Goodwill

     (2,590.0

Intangible assets

     (351.6

Capitalized internal-use software

     (89.5

Deferred tax assets on outstanding equity awards

     (54.6

Deferred tax liabilities on historical internal-use software

     28.7   

Deferred tax liabilities on historical intangible assets

     179.8   
  

 

 

 

Adjusted book value of net assets acquired

   $ 1,629.1   
  

 

 

 

Adjustments to:

  

Goodwill (a)

   $ 3,461.7   

Identified intangible assets (b)

     1,300.0   

Deferred tax liabilities (c)

     (388.5

Fair value adjustment to debt (d)

     (190.0

Property and equipment (e)

     —     

Total adjustments

     4,183.2   
  

 

 

 

Consideration transferred

   $ 5,812.3   
  

 

 

 

 

(a) Goodwill is calculated as the difference between the acquisition date fair value of the total consideration expected to be transferred and the aggregate values assigned to the assets acquired and liabilities assumed. Goodwill is not amortized.
   
(b) As of completion of the merger, identifiable intangible assets are required to be measured at fair value, and these acquired assets could include assets that are not intended to be used or sold or that are intended to be used in a manner other than their highest and best use. For purposes of these unaudited pro forma condensed combined financial statements and consistent with the ASC 820 requirements for fair value measurements, it is assumed that all assets will be used, and that all assets will be used in a manner that represents the highest and best use of those assets, but it is not assumed that any market participant synergies will be achieved.

The fair value of identifiable intangible assets is determined primarily using variations of the “income approach,” which is based on the present value of the future after tax cash flows attributable to each identified intangible asset. Other valuation methods, including the market approach and cost approach, were also considered in estimating the fair value. Under the HSR Act and other relevant laws and regulations, there are significant limitations on Aetna’s ability to obtain specific information about the Coventry intangible assets prior to completion of the merger.

At this time, Aetna does not have sufficient information as to the amount, timing and risk of cash flows of all of Coventry’s identifiable intangible assets to determine their fair value. Some of the more significant assumptions inherent in the development of intangible asset values, from the perspective of a market participant, include: the amount and timing of projected future cash flows (including revenue and profitability); the discount rate selected to measure the risks inherent in the future cash flows; and the assessment of the asset’s life cycle and the competitive trends impacting the asset. However, for purposes of these unaudited pro forma condensed combined financial statements and using publicly available

 

9


 

information, such as historical revenues, Coventry’s cost structure, industry information for comparable intangible assets and certain other high-level assumptions, the fair value of Coventry’s identifiable intangible assets and their weighted-average useful lives have been estimated as follows:

 

     Estimated
Fair Value (Millions)
     Estimated
Useful Life (Years)
 

Customer lists

   $ 625.0         8   

Provider networks

     525.0         17   

Trademarks/tradenames

     120.0         10   

Technology

     30.0         5   
  

 

 

    

 

 

 

Total

   $ 1,300.0      
  

 

 

    

These preliminary estimates of fair value and weighted-average useful life will likely be different from the final acquisition accounting, and the difference could have a material impact on the accompanying unaudited pro forma condensed combined financial statements. Once Aetna has full access to information about Coventry’s intangible assets, additional insight will be gained that could impact (i) the estimated total value assigned to intangible assets, (ii) the estimated allocation of value between finite-lived and indefinite-lived intangible assets and/or (iii) the estimated weighted-average useful life of each category of intangible assets. The estimated intangible asset values and their useful lives could be impacted by a variety of factors that may become known to Aetna only upon access to additional information and/or by changes in such factors that may occur prior to completion of the merger. These factors include, but are not limited to, changes in the regulatory, legislative, legal, technological and competitive environments. Increased knowledge about these and/or other elements could result in a change to the estimated fair value of the identifiable Coventry intangible assets and/or to the estimated weighted-average useful lives from what Aetna has assumed in these unaudited pro forma condensed combined financial statements. The combined effect of any such changes could then also result in a significant increase or decrease to Aetna’s estimate of associated amortization expense.

 

(c) As of completion of the merger, Aetna will establish deferred taxes and make other tax adjustments as part of the accounting for the acquisition, primarily related to estimated fair value adjustments for identifiable intangible assets and debt (see (b) and (d)). The pro forma adjustment to record the effect of deferred taxes was computed as follows:

 

     (Millions)  

Estimated fair value of identifiable intangible assets to be acquired

   $ 1,300.0   

Estimated fair value adjustment of debt to be assumed

     (190.0
  

 

 

 

Total estimated fair value adjustments of assets to be acquired and liabilities to be assumed

   $ 1,110.0   
  

 

 

 

Deferred taxes associated with the estimated fair value adjustments of assets to be acquired and liabilities to be assumed, at 35% (*)

   $ 388.5   
  

 

 

 

 

  (*) Aetna assumed a 35% tax rate when estimating the deferred tax aspects of the acquisition.

 

(d) As of completion of the merger, debt is required to be measured at fair value. Aetna has calculated the pro forma adjustment using publicly available information and believes the pro forma adjustment amount to be reasonable.
   
(e)

As of completion of the merger, property and equipment is required to be measured at fair value, unless those assets are classified as held-for-sale on the acquisition date. The acquired assets can include assets that are not intended to be used or sold, or that are intended to be used in a manner other than their highest and best use. Aetna does not have sufficient information at this time as to the specific nature, age, condition or location of Coventry’s property and equipment, and Aetna does not know the appropriate valuation premise, in-use or in-exchange, as the valuation premise requires a certain level of knowledge about the assets being evaluated as well as a profile of the associated market participants. All of these elements can cause

 

10


 
  differences between fair value and net book value. Accordingly, for the purposes of these unaudited pro forma condensed combined financial statements, Aetna has assumed that the current Coventry book values represent the best estimate of fair value except for capitalized internal-use software for which the historical book value was eliminated as the fair value was estimated in (b) above. This estimate is preliminary and subject to change and could vary materially from the actual value on the date the merger is completed.

 

6. Disposition

Aetna and Coventry each have a Missouri Medicaid business. The unaudited pro forma condensed combined financial information assumes Aetna will dispose of its Missouri Medicaid business at the time of the merger and continue to operate Coventry’s Missouri Medicaid business. Specifically, the unaudited pro forma condensed combined statements of income reflect the elimination of the revenues associated with Aetna’s Missouri Medicaid business as well as elimination of the costs specifically identifiable with that revenue. Aetna does not currently have market participant bids or other information regarding similar transactions that may be indicative of the fair value of the Missouri Medicaid business. As a result, the unaudited pro forma condensed combined balance sheet reflects the disposal of Aetna’s Missouri Medicaid business assuming that the book value of that business approximates fair value, and also assumes cash consideration received equal to book value.

 

7. Income Statement Pro Forma Adjustments

This note should be read in conjunction with Note 1. Description of Transaction; Note 2. Basis of Presentation; Note 4. Estimate of Consideration Expected to be Transferred; and Note 5. Estimate of Assets to be Acquired and Liabilities to be Assumed. Adjustments included in the column under the heading “Pro Forma Adjustments” represent the following:

 

(a) Elimination of intercompany transactions between Aetna and Coventry primarily related to network rental fees, consisting of aggregate revenue and expenses of $21.7 million for the year ended 2011 and $9.1 million for the six months ended June 30, 2012.

 

(b) For purposes of these unaudited pro forma condensed combined financial statements, Aetna estimated foregone interest income associated with cash and cash equivalents and long-term investments assumed to have been used to partially fund the merger. For purposes of such financial statements, the estimated foregone interest income for the combined entity in 2011 and for the six months ended June 30, 2012, is approximately $10.4 million and $5.1 million, respectively. Aetna’s estimate is based on a weighted-average annual interest rate on cash, cash equivalents and long-term investments in 2011 of 0.80% and for the six months ended June 30, 2012, of 0.78%.

 

(c) For purposes of these unaudited pro forma condensed combined financial statements, Aetna estimated foregone interest income associated with adjusting the amortized cost of Coventry’s investment portfolio to fair value as of completion of the merger. Foregone interest income due to fair value adjustments to the investment portfolio under the acquisition method of accounting is projected to be approximately $25.4 million and $8.5 million in 2011 and for the six months ended June 30, 2012, respectively.

 

(d) To adjust amortization expense, as follows:

 

     Year Ended
December 31, 2011
    Six Months Ended
June 30, 2012
 
     (Millions)  

Eliminate Coventry’s historical intangible asset amortization expense

   $ (64.4   $ (41.1

Estimated intangible asset amortization*

     108.3        54.2   
  

 

 

   

 

 

 

Estimated adjustment to intangible asset amortization expense

   $ 43.9      $ 13.1   
  

 

 

   

 

 

 

 

(*) Assumes an estimated $1.3 billion of finite-lived intangibles and a weighted average amortization period of 12 years (Refer to Note 5. Estimate of Assets to be Acquired and Liabilities to be Assumed).

 

(e)

Aetna estimates additional general and administrative expense of about $1.1 million in 2011 and $0.5 million for the six months ended June 30, 2012, related to the amortization of debt issuance costs associated

 

11


 
  with the $2.0 billion of long-term debt securities Aetna expects to issue to finance the merger. Issuance costs related to those long-term debt securities are assumed to be amortized over an estimated weighted average term of approximately 14 years.

 

(f) Aetna estimates interest expense of $30.5 million in 2011 and $15.7 million in the six months ended June 30, 2012, associated with debt issued to finance the merger and the amortization of the estimated fair value adjustment to Coventry’s debt:

 

   

Additional interest expense of approximately $63.0 million in 2011 and $31.5 million in the six months ended June 30, 2012, based on approximately $2.0 billion of long-term fixed-rate debt securities Aetna expects to issue to partially fund the merger. The calculation of interest expense on the long-term debt securities assumes maturity tranches of 5, 10, and 30 years and an estimated weighted average annual interest rate of 3.15%. If interest rates were to increase or decrease by 0.5% from the rates assumed in estimating this pro forma adjustment to interest expense, pro forma interest expense could increase or decrease by approximately $10.0 million in 2011 and $5.0 million in the six months ended June 30, 2012.

 

   

Additional interest expense of approximately $2.3 million in 2011 and $1.6 million in the six months ended June 30, 2012, based on approximately $500 million of commercial paper Aetna expects to issue to partially fund the merger. The interest expense on the commercial paper was estimated using an annual interest rate of 0.62%. The pro forma income statements for the year ended December 31, 2011 and the six months ended June 30, 2012, each assume Aetna retires the incremental $500 million of commercial paper borrowings over a one-year period. Commercial paper issued to partially fund the merger is assumed to be $500 million at each of January 1, 2011 and January 1, 2012, and to be reduced to $250 million on each of June 30, 2011 and June 30, 2012, and, for purposes of the pro forma income statement for the year ended December 31, 2011, further reduced to zero on December 31, 2011. As a result of this assumed pattern of retirement, interest expense in the pro forma income statement for the six months ended June 30, 2012, is unaffected by expected commercial paper retirement as $500 million will remain outstanding for the entire six month period. If commercial paper interest rates were to increase or decrease by 0.5% from the rate that was assumed in estimating this pro forma adjustment to interest expense, pro forma interest expense could increase or decrease by approximately $1.9 million in 2011 and $1.3 million for the six months ended June 30, 2012.

 

   

As a direct result of the merger, Aetna expects to amend its unsecured $1.5 billion five-year revolving credit agreement to increase the available commitments to $2.0 billion. Aetna does not expect to draw on that facility; however Aetna assumes that it would have incurred an estimated $0.5 million and $0.2 million of facility fees on the incremental commitment in 2011 and for the six months ended June 30, 2012, respectively, which is reflected in the respective pro forma adjustments to interest expense for these periods.

 

   

Additional interest expense associated with incremental debt issued to finance the merger is offset by estimated reductions to interest expense of $35.3 million in 2011 and $17.6 million in the six months ended June 30, 2012. These reductions are from the amortization of the estimated fair value adjustment to Coventry’s debt over the remaining weighted-average life of its outstanding debt of 5.4 years. Debt is required to be measured at fair value under the acquisition method of accounting.

 

(g) Aetna assumed a blended 35% tax rate when estimating the tax impact of the acquisition, representing the federal statutory tax rate and exclusion of any state tax impacts which are unknown at this time but expected to be immaterial. The effective tax rate of the combined company could be significantly different depending upon post-acquisition activities of the combined company.

 

(h) The combined basic and diluted earnings per share for the periods presented are based on the combined weighted average basic and diluted shares of Aetna and Coventry. The historical weighted average basic and diluted shares of Coventry were assumed to be replaced by the shares expected to be issued by Aetna to effect the merger.

 

12


 

The following table summarizes the computation of the unaudited pro forma combined weighted average basic and diluted shares outstanding:

 

     Year Ended
December 31, 2011
     Six Months Ended
June 30, 2012
 
     (Millions)  

Aetna weighted average shares used to compute basic EPS

     372.5         346.0   

Coventry shares outstanding at September 14, 2012, converted at the exchange ratio (132.6*0.3885)

     51.5         51.5   
  

 

 

    

 

 

 

Combined weighted average basic shares outstanding

     424.0         397.5   
  

 

 

    

 

 

 

Number of Coventry restricted shares outstanding at September 14, 2012, converted at the exchange ratio (1.3*0.3885)

     .5         .5   
  

 

 

    

 

 

 

Pro forma weighted average basic shares outstanding

     424.5         398.0   
  

 

 

    

 

 

 

Dilutive effect of Aetna’s outstanding stock-based compensation awards (1)

     7.7         5.5   
  

 

 

    

 

 

 

Pro forma weighted average shares used to compute diluted EPS

     432.2         403.5   
  

 

 

    

 

 

 

 

Certain amounts may reflect rounding adjustments.

 

(1) Does not include Coventry’s outstanding performance share units, restricted stock units or vested or unvested stock options that will be paid in cash and canceled upon completion of the merger as described in Note 4. Estimate of Consideration Expected to be Transferred.

 

8. Balance Sheet Pro Forma Adjustments

This note should be read in conjunction with Note 1. Description of Transaction; Note 2. Basis of Presentation; Note 4. Estimate of Consideration Expected to be Transferred; and Note 5. Estimate of Assets to be Acquired and Liabilities to be Assumed. Adjustments included in the column under the heading “Pro Forma Adjustments” represent the following:

 

(a) To reflect the use of an estimated $932 million of available cash and an estimated $350 million of cash raised by liquidating long-term investments, in aggregate $1.3 billion of cash in order to fund a portion of the total consideration expected to be transferred to fund the merger. The remainder of the estimated cash consideration expected to be transferred to fund the merger is expected to be financed with $2.0 billion of long-term debt securities and approximately $500 million of commercial paper (See Note 4. Estimate of Consideration Expected to be Transferred). Estimated debt issuance costs of approximately $15.1 million are reflected in other long-term assets.

 

(b) To eliminate intercompany accounts receivable and accrued expenses primarily related to network rental fees of $2.4 million.

 

(c) To adjust current tax assets to include $46.8 million related to estimated acquisition-related transaction costs.

 

(d) To adjust goodwill to an estimate of acquisition-date goodwill, as follows:

 

     (Millions)  

Eliminate Coventry’s historical goodwill

   $ (2,590.0

Estimated transaction goodwill

     3,461.7   
  

 

 

 

Total

   $ 871.7   
  

 

 

 

 

13


 
(e) To adjust intangible assets to an estimate of fair value, as follows:

 

     (Millions)  

Eliminate Coventry’s historical intangible assets

   $ (351.6

Estimated fair value of intangible assets acquired

     1,300.0   
  

 

 

 

Total

   $ 948.4   
  

 

 

 

 

(f) To eliminate Coventry’s historical capitalized internal use software of $89.5 million.

 

(g) Aetna expects to issue approximately $2.5 billion of debt to partially fund the merger, comprised of approximately $2.0 billion of long-term debt securities and approximately $500 million of commercial paper.

 

(h) To record estimated acquisition-related transaction costs. Total acquisition-related transaction costs estimated to be incurred by Aetna and Coventry are $120 million and $45 million, respectively. Pursuant to requirements for the preparation of pro forma financial information under Article 11 of Regulation S-X, these acquisition-related transaction costs are not included in the pro forma condensed combined income statements.

 

(i) To record long-term debt incurred by Aetna to effect the merger and to adjust Coventry’s debt to an estimate of fair value, as follows:

 

     (Millions)  

Establish incremental long-term debt to effect the merger

   $ 2,000.0   

Estimated fair value increase to debt assumed

     190.0   
  

 

 

 

Total

   $ 2,190.0   
  

 

 

 

 

(j) To adjust tax liabilities as follows:

 

     (Millions)  

Eliminate Coventry’s deferred tax liability on intangible assets

   $ (179.8

Eliminate Coventry’s deferred tax liability on internal-use software

     (28.7

Eliminate Coventry’s deferred tax asset on outstanding equity/unit awards

     54.6   

Estimated transaction deferred tax liability on identifiable intangible assets

     455.0   

Estimated transaction deferred tax asset for fair value increase to assumed debt

     (66.5

Estimated transaction current tax liability for debt issuance costs

     5.3   
  

 

 

 

Total

   $ 239.9   
  

 

 

 

 

(k) To eliminate Coventry’s historical common stock and additional paid-in capital and record the stock portion of the merger consideration as follows:

 

     (Millions)  

Eliminate Coventry’s historical common stock and additional paid-in capital

   $ (30.0

Issuance of Aetna common shares

     2,030.8   
  

 

 

 

Total

   $ 2,000.8   
  

 

 

 

 

(l) To eliminate Coventry’s historical retained earnings, to estimate the after-tax portion of the remaining merger-related transaction costs and to estimate the after-tax portion of debt issuance costs as follows:

 

     (Millions)  

Eliminate Coventry’s historical retained earnings

   $ (4,410.5

Transaction costs incurred

     (118.0

Debt issuance costs incurred

     9.8   
  

 

 

 

Total

   $ (4,518.7
  

 

 

 

 

14


 
(m) To eliminate Coventry’s historical accumulated other comprehensive income.

The unaudited pro forma condensed combined financial statements do not present a combined dividend per share amount. On both April 27, 2012 and July 27, 2012, Aetna paid dividends of $0.175 per Aetna common share. On both April 9, 2012 and July 9, 2012, Coventry paid dividends of $0.125 per share of Coventry common stock. In addition, on August 27, 2012, Coventry declared a dividend of $0.125, which will be paid on October 8, 2012, and is not reflected in the unaudited pro forma condensed combined financial statements. Coventry is not permitted to declare, set aside or pay a dividend or other distribution other than its regular quarterly cash dividend in the ordinary course of business consistent with past practice, in an amount not in excess of $0.125 per share of Coventry common stock prior to completion of the merger, and any future payment of Coventry’s quarterly dividend is subject to future approval and declaration by the Coventry board of directors. Prior to completion of the merger, Aetna is not permitted to declare, set aside or pay any dividend or other distribution other than its regular cash dividend in the ordinary course of business consistent with past practice. The dividend policy of Aetna following completion of the merger will be determined by the Aetna board of directors following completion of the merger.

The unaudited pro forma condensed combined financial statements do not reflect the projected realization of cost savings following completion of the merger. These cost savings opportunities are from administrative cost savings, as well as network and medical management savings. Although Aetna management projects that cost savings will result from the merger, there can be no assurance that these cost savings will be achieved.

 

15