XML 63 R22.htm IDEA: XBRL DOCUMENT v2.4.0.6
Condensed consolidating financial information
12 Months Ended
Dec. 31, 2011
Condensed consolidating financial information [Abstract]  
Condensed consolidating financial information
14. Condensed consolidating financial information

Our senior notes are jointly and severally and fully and unconditionally (subject to certain customary release provisions, including sale, exchange, transfer or liquidation of the guarantor subsidiary) guaranteed by our 100% owned domestic subsidiaries, other than certain regulated subsidiaries including Express Scripts Insurance Company. The following condensed consolidating financial information has been prepared in accordance with the requirements for presentation of such information. The statement of comprehensive income has been excluded from this presentation because all components of other comprehensive income relate to the operations of non-guarantor subsidiaries and are immaterial to the condensed consolidating financial statements as a whole. Effective September 17, 2010, PMG was sold. The assets, liabilities, and operations of PMG are included as discontinued operations in those of the non-guarantors for all periods presented. Subsequent to the acquisition of NextRx on December 1, 2009, certain of the assets, liabilities and operations of the 100% owned domestic subsidiaries have been included in those of the guarantors. Certain amounts from prior periods have been reclassified to conform to current period presentation. The following presents the condensed consolidating financial information separately for:

 

  (i) Express Scripts, Inc. (the Parent Company), the issuer of certain guaranteed obligations (the Parent Company also guarantees the obligations of Aristotle);

 

  (ii) Aristotle Holding, Inc., incorporated in 2011 and the issuer of additional guaranteed obligations;

 

  (iii) Guarantor subsidiaries, on a combined basis, as specified in the indentures related to Express Scripts’ and Aristotle’s obligations under the notes;

 

  (iv) Non-guarantor subsidiaries, on a combined basis;

 

  (v) Consolidating entries and eliminations representing adjustments to (a) eliminate intercompany transactions between or among the Parent Company, the guarantor subsidiaries and the non-guarantor subsidiaries, (b) eliminate the investments in our subsidiaries and (c) record consolidating entries; and

 

  (vi) Express Scripts, Inc and subsidiaries on a consolidated basis.

 

Condensed Consolidating Balance Sheet

 

 

 

                                                 

(in millions)

  Express
Scripts, Inc.
    Aristotle
Holding,
Inc.
    Guarantors     Non-
Guarantors
    Eliminations     Consolidated  

As of December 31, 2011

                                               

Cash and cash equivalents

  $ 5,522.2     $ —       $ 5.4     $ 92.5     $ —       $ 5,620.1  

Restricted cash and investments

    —         —         13.1       4.7       —         17.8  

Receivables, net

    1,289.4       —         592.3       34.0       —         1,915.7  

Other current assets

    33.8       —         453.1       17.5       —         504.4  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current assets

    6,845.4       —         1,063.9       148.7       —         8,058.0  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Property and equipment, net

    293.0       —         105.2       18.0       —         416.2  

Investments in subsidiaries

    6,812.6       —         —         —         (6,812.6     —    

Intercompany

    —         4,057.3       3,953.8       —         (8,011.1     —    

Goodwill

    2,921.4       —         2,538.8       25.5       —         5,485.7  

Other intangible assets, net

    1,331.4       29.2       256.8       3.5       —         1,620.9  

Other assets

    22.1       —         2.5       1.6       —         26.2  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total assets

  $ 18,225.9     $ 4,086.5     $ 7,921.0     $ 197.3     $ (14,823.7   $ 15,607.0  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

Claims and rebates payable

  $ 2,873.5     $ —       $ 0.6     $ —       $ —       $ 2,874.1  

Accounts payable

    686.6       —         238.4       3.1       —         928.1  

Accrued expenses

    256.5       —         362.5       37.0       —         656.0  

Current maturities of long-term debt

    999.9       —         —         —         —         999.9  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current liabilities

    4,816.5       —         601.5       40.1       —         5,458.1  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Long-term debt

    2,989.9       4,086.5       —         —         —         7,076.4  

Intercompany

    7,899.1       —         —         112.0       (8,011.1     —    

Other liabilities

    46.7       —         546.4       5.7       —         598.8  

Stockholders’ equity

    2,473.7       —         6,773.1       39.5       (6,812.6     2,473.7  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total liabilities and stockholders’ equity

  $ 18,225.9     $ 4,086.5     $ 7,921.0     $ 197.3     $ (14,823.7   $ 15,607.0  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

As of December 31, 2010

                                               

Cash and cash equivalents

  $ 456.7     $ —       $ 9.0     $ 58.0     $ —       $ 523.7  

Restricted cash and investments

    —         —         11.7       4.6       —         16.3  

Receivables, net

    1,175.6       —         536.2       9.1       —         1,720.9  

Other current assets

    249.0       —         396.0       35.4       —         680.4  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current assets

    1,881.3       —         952.9       107.1       —         2,941.3  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Property and equipment, net

    231.5       —         127.2       14.0       —         372.7  

Investments in subsidiaries

    6,382.2       —         —         —         (6,382.2     —    

Intercompany

    —         —         3,214.0       —         (3,214.0     —    

Goodwill

    2,921.4       —         2,538.8       26.0       —         5,486.2  

Other intangible assets, net

    1,426.2       —         294.8       4.0       —         1,725.0  

Other assets

    20.6       —         10.1       1.9       —         32.6  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total assets

  $ 12,863.2     $ —       $ 7,137.8     $ 153.0     $ (9,596.2   $ 10,557.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

Claims and rebates payable

  $ 2,664.9     $ —       $ 1.6     $ —       $ —       $ 2,666.5  

Accounts payable

    634.4       —         17.7       4.6       —         656.7  

Accrued expenses

    288.7       —         294.5       10.7       —         593.9  

Current maturities of long-term debt

    —         —         0.1       —         —         0.1  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total current liabilities

    3,588.0       —         313.9       15.3       —         3,917.2  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Long-term debt

    2,493.7       —         —         —         —         2,493.7  

Intercompany

    3,094.8       —         —         119.2       (3,214.0     —    

Other liabilities

    80.1       —         455.5       4.7       —         540.3  

Stockholders’ equity

    3,606.6       —         6,368.4       13.8       (6,382.2     3,606.6  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total liabilities and stockholders’ equity

  $ 12,863.2     $ —       $ 7,137.8     $ 153.0     $ (9,596.2   $ 10,557.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

Condensed Consolidating Statement of Operations

 

 

 

                                                 

(in millions)

  Express
Scripts, Inc.
    Aristotle
Holding,
Inc.
    Guarantors     Non-
Guarantors
    Eliminations     Consolidated  

For the year ended December 31, 2011

  

                                       

Revenues

  $ 29,450.9     $ —       $ 16,520.3     $ 157.1     $ —       $ 46,128.3  

Operating expenses

    27,847.9       —         15,841.3       127.4       —         43,816.6  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Operating income

    1,603.0       —         679.0       29.7       —         2,311.7  

Interest (expense) income, net

    (259.8     (22.2     (5.9     0.6       —         (287.3
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income before income taxes

    1,343.2       (22.2     673.1       30.3       —         2,024.4  

Provision for income taxes

    487.9       (8.1     263.8       5.0       —         748.6  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income (loss) from continuing operations

    855.3       (14.1     409.3       25.3       —         1,275.8  

Equity in earnings of subsidiaries

    420.5       —         —         —         (420.5     —    
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income (loss)

  $ 1,275.8     $ (14.1   $ 409.3     $ 25.3     $ (420.5   $ 1,275.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

For the year ended December 31, 2010

                                               

Revenues

  $ 29,594.6     $ —       $ 15,287.8     $ 90.8     $ —       $ 44,973.2  

Operating expenses

    28,176.8       —         14,635.8       89.7       —         42,902.3  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Operating income

    1,417.8       —         652.0       1.1       —         2,070.9  

Interest (expense) income, net

    (156.2     —         (6.2     0.2       —         (162.2
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income before income taxes

    1,261.6       —         645.8       1.3       —         1,908.7  

Provision for income taxes

    462.3       —         241.0       0.8       —         704.1  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income from continuing operations

    799.3       —         404.8       0.5       —         1,204.6  

Net loss from discontinued operations, net of tax

    —         —         —         (23.4     —         (23.4

Equity in earnings of subsidiaries

    381.9       —         —         —         (381.9     —    
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income (loss)

  $ 1,181.2     $ —       $ 404.8     $ (22.9   $ (381.9   $ 1,181.2  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

For the year ended December 31, 2009

                                               

Revenues

  $ 14,642.9     $ —       $ 10,004.2     $ 75.2     $ —       $ 24,722.3  

Operating expenses

    13,654.9       —         9,497.7       72.2       —         23,224.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Operating income

    988.0       —         506.5       3.0       —         1,497.5  

Interest expense, net

    (179.6     —         (6.5     (3.0     —         (189.1
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Income before income taxes

    808.4       —         500.0       —         —         1,308.4  

Provision for income taxes

    293.0       —         185.9       2.9       —         481.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income (loss) from continuing operations

    515.4       —         314.1       (2.9     —         826.6  

Net income from discontinued operations, net of tax

    —         —         —         1.0       —         1.0  

Equity in earnings of subsidiaries

    312.2       —         —         —         (312.2     —    
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net income (loss)

  $ 827.6     $ —       $ 314.1     $ (1.9   $ (312.2   $ 827.6  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

Condensed Consolidating Statement of Cash Flows

 

 

 

                                                 

(in millions)

  Express
Scripts, Inc.
    Aristotle
Holding,
Inc.
    Guarantors     Non-
Guarantors
    Eliminations     Consolidated  

For the year ended December 31, 2011

                                               
             

Net cash flows provided by (used in) operating activities

  $ 1,846.9     $ (14.1   $ 753.1     $ 26.6     $ (420.5   $ 2,192.0  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

Cash flows from investing activities:

                                               

Purchase of property and equipment

    (124.9     —         (13.4     (6.1     —         (144.4

Other

    (1.0     —         1.3       20.2       —         20.5  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash (used in) provided by investing activities

    (125.9     —         (12.1     14.1       —         (123.9
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

Cash flows from financing activities:

                                               

Proceeds from long-term debt, net of discounts

    1,494.0       4,086.3       —         —         —         5,580.3  

Treasury stock acquired

    (2,515.7     —         —         —         —         (2,515.7

Deferred financing fees

    (62.4     (29.2     —         —         —         (91.6

Net proceeds from employee stock plans

    32.2       —         —         —         —         32.2  

Tax benefit relating to employee stock-based compensation

    28.3       —         —         —         —         28.3  

Repayment of long-term debt

    (0.1     —         —         —         —         (0.1

Other

    (2.9     —         —         —         —         (2.9

Net transactions with parent

    4,371.1       (4,043.0     (744.6     (4.0     420.5       —    
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash provided by (used in) financing activities

    3,344.5       14.1       (744.6     (4.0     420.5       3,030.5  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

Effect of foreign currency translation adjustment

    —         —         —         (2.2     —         (2.2
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
             

Net increase (decrease) in cash and cash equivalents

    5,065.5       —         (3.6     34.5       —         5,096.4  

Cash and cash equivalents at beginning of year

    456.7       —         9.0       58.0       —         523.7  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cash and cash equivalents at end of year

  $ 5,522.2     $ —       $ 5.4     $ 92.5     $ —       $ 5,620.1  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

Condensed Consolidating Statement of Cash Flows

 

 

 

                                         

(in millions)

  Express
Scripts, Inc.
    Guarantors     Non-
Guarantors
    Eliminations     Consolidated  

For the year ended December 31, 2010

                                       
           

Net cash flows provided by (used in) operating activities

  $ 1,709.3     $ 773.2     $ 16.8     $ (381.9   $ 2,117.4  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Cash flows from investing activities:

                                       

Purchase of property and equipment

    (53.1     (61.3     (5.5     —         (119.9

Purchase of short-term investments

    —         —         (38.0     —         (38.0

Other

    17.6       (4.3     (0.5     —         12.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash used in investing activities – continuing operations

    (35.5     (65.6     (44.0     —         (145.1

Net cash used in investing activities – discontinued operations

    —         —         (0.8     —         (0.8
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash used in investing activities

    (35.5     (65.6     (44.8     —         (145.9
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Cash flows from financing activities:

                                       

Repayment of long-term debt

    (1,340.1     —         —         —         (1,340.1

Treasury stock acquired

    (1,276.2     —         —         —         (1,276.2

Tax benefit relating to employee stock-based compensation

    58.9       —         —         —         58.9  

Net proceeds from employee stock plans

    35.3       —         —         —         35.3  

Deferred financing fees

    (3.9     —         —         —         (3.9

Other

    3.0       —         —         —         3.0  

Net transactions with parent

    300.9       (708.6     25.8       381.9       —    
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash (used in) provided by financing activities

    (2,222.1     (708.6     25.8       381.9       (2,523.0
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Effect of foreign currency translation adjustment

    —         —         4.8       —         4.8  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Net (decrease) increase in cash and cash equivalents

    (548.3     (1.0     2.6       —         (546.7

Cash and cash equivalents at beginning of year

    1,005.0       10.0       55.4       —         1,070.4  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cash and cash equivalents at end of year

  $ 456.7     $ 9.0     $ 58.0     $ —       $ 523.7  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

 

Condensed Consolidating Statement of Cash Flows

 

 

 

                                         

(in millions)

  Express
Scripts, Inc.
    Guarantors     Non-
Guarantors
    Eliminations     Consolidated  

For the year ended December 31, 2009

                                       

Net cash flows provided by (used in) operating activities

  $ 1,684.9     $ 385.2     $ 13.6     $ (312.2   $ 1,771.5  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Cash flows from investing activities:

                                       

Acquisitions, net of cash acquired

    (8,881.7     (465.9     —         4,675.0       (4,672.6

Purchase of short-term investments

    (1,201.4     —         —         —         (1,201.4

Sale of short-term investments

    1,198.9       —         —         —         1,198.9  

Purchase of property and equipment

    (116.6     (22.6     (8.3     —         (147.5

Other

    6.4       (2.7     (1.6     —         2.1  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash (used in) provided by investing activities – continuing operations

    (8,994.4     (491.2     (9.9     4,675.0       (4,820.5

Net cash used in investing activities – discontinued operations

    —         —         (1.9     —         (1.9
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash (used in) provided by investing activities

    (8,994.4     (491.2     (11.8     4,675.0       (4,822.4
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Cash flows from financing activities:

                                       

Proceeds from long-term debt, net of discounts

    2,491.6       —         —         —         2,491.6  

Net proceeds from stock issuance

    1,569.1       —         —         —         1,569.1  

Repayment of long-term debt

    (420.1     —         —         —         (420.1

Deferred financing fees

    (79.5     —         —         —         (79.5

Tax benefit relating to employee stock-based compensation

    13.4       —         —         —         13.4  

Net proceeds from employee stock plans

    12.5       —         —         —         12.5  

Net transactions with parent

    4,239.4       107.1       16.3       (4,362.8     —    
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Net cash provided by (used in) financing activities

    7,826.4       107.1       16.3       (4,362.8     3,587.0  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Effect of foreign currency translation adjustment

    —         —         3.6       —         3.6  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 
           

Net increase in cash and cash equivalents

    516.9       1.1       21.7       —         539.7  

Cash and cash equivalents at beginning of year

    488.1       8.9       33.7       —         530.7  
   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Cash and cash equivalents at end of year

  $ 1,005.0     $ 10.0     $ 55.4     $ —       $ 1,070.4