Condensed consolidating financial information | Note 12 - Condensed consolidating financial information The senior notes issued by us, ESI and Medco 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 certain of our 100% owned domestic subsidiaries, other than certain regulated subsidiaries, and, with respect to notes issued by ESI and Medco, by Express Scripts Holding Company. The following condensed consolidating financial information has been prepared in accordance with the requirements for presentation of such information. The condensed consolidating financial information presented below is not indicative of what the financial position, results of operations or cash flows would have been had each of the entities operated as an independent company during the period for various reasons, including, but not limited to, intercompany transactions and integration of systems. The following presentation reflects the structure that exists as of the most recent balance sheet date. The condensed consolidating financial information is presented separately for: (i) Express Scripts Holding Company (the Parent Company), the issuer of certain guaranteed obligations; (ii) ESI, guarantor, the issuer of additional guaranteed obligations; (iii) Medco, guarantor, the issuer of additional guaranteed obligations; (iv) Guarantor subsidiaries, on a combined basis (but excluding ESI and Medco), as specified in the indentures related to Express Scripts Holding Company’s, ESI’s and Medco’s obligations under the notes; (v) Non-guarantor subsidiaries, on a combined basis; (vi) Consolidating entries and eliminations representing adjustments to (a) eliminate intercompany transactions between or among Express Scripts Holding Company, ESI, Medco, the guarantor subsidiaries and the non-guarantor subsidiaries, (b) eliminate the investments in our subsidiaries and (c) record consolidating entries; and (vii) Express Scripts Holding Company and its subsidiaries on a consolidated basis. In 2017, as part of an ongoing reorganization since 2015, certain subsidiaries have been merged within the structure defined above through non-cash transfers. The 2017 reorganizations qualified as a transfer of assets and are reflected prospectively in the condensed consolidating balance sheet, statement of operations and statement of cash flows. These events had no impact on our consolidated balance sheet, consolidated statement of operations or consolidated statement of cash flows. In conjunction with the ongoing reorganization, during both the first and second quarters of 2017, we executed certain intercompany agreements and transfer pricing agreements effective retrospectively to January 1, 2017. These intercompany agreements resulted in increased SG&A for our subsidiaries and reduced SG&A for ESI in the condensed consolidating statement of operations for the three and nine months ended September 30, 2017 . The transfer pricing agreements resulted in increased revenues and costs of revenues for ESI, Medco and our subsidiaries with a resulting increase in the eliminations column. These events had no impact on our consolidated balance sheet, consolidated statement of operations or consolidated statement of cash flows. Condensed Consolidating Balance Sheet (in millions) Express Scripts Holding Company Express Scripts, Medco Health Solutions, Guarantors Non-Guarantors Eliminations Consolidated As of September 30, 2017 Cash and cash equivalents $ 1,276.8 $ 1,554.2 $ — $ 51.6 $ 513.3 $ — $ 3,395.9 Receivables, net — 3,862.1 330.5 1,923.4 755.5 — 6,871.5 Other current assets — 286.5 — 2,101.6 23.5 — 2,411.6 Total current assets 1,276.8 5,702.8 330.5 4,076.6 1,292.3 — 12,679.0 Property and equipment, net — 790.1 3.3 445.0 28.2 — 1,266.6 Investments in subsidiaries 46,836.1 13,567.9 8,949.3 — — (69,353.3 ) — Intercompany — — 2,677.3 17,918.4 — (20,595.7 ) — Goodwill — 3,122.4 22,609.9 3,670.4 22.1 — 29,424.8 Other intangible assets, net — 507.7 6,168.9 1,012.5 8.7 — 7,697.8 Other assets 4.0 161.7 29.1 28.9 4.3 (90.0 ) 138.0 Total assets $ 48,116.9 $ 23,852.6 $ 40,768.3 $ 27,151.8 $ 1,355.6 $ (90,039.0 ) $ 51,206.2 Claims and rebates payable $ — $ 6,940.5 $ 2,543.0 $ — $ — $ — $ 9,483.5 Accounts payable — 1,048.3 41.1 3,247.7 40.8 — 4,377.9 Accrued expenses 87.2 1,054.1 282.3 296.5 594.2 — 2,314.3 Current maturities of long-term debt 335.2 — 845.9 — — — 1,181.1 Total current liabilities 422.4 9,042.9 3,712.3 3,544.2 635.0 — 17,356.8 Long-term debt 12,886.9 336.6 503.2 — — — 13,726.7 Intercompany 18,891.1 1,213.5 — — 491.1 (20,595.7 ) — Deferred taxes — — 2,199.4 1,281.0 11.5 (90.0 ) 3,401.9 Other liabilities — 478.5 298.4 19.2 2.4 — 798.5 Non-controlling interest — — — — 5.8 — 5.8 Express Scripts stockholders’ equity 15,916.5 12,781.1 34,055.0 22,307.4 209.8 (69,353.3 ) 15,916.5 Total liabilities and stockholders’ equity $ 48,116.9 $ 23,852.6 $ 40,768.3 $ 27,151.8 $ 1,355.6 $ (90,039.0 ) $ 51,206.2 Condensed Consolidating Balance Sheet (in millions) Express Scripts Holding Company Express Scripts, Medco Health Solutions, Guarantors Non-Guarantors Eliminations Consolidated As of December 31, 2016 Cash and cash equivalents $ 583.5 $ 1,234.2 $ 4.4 $ 46.8 $ 1,208.3 $ — $ 3,077.2 Receivables, net — 3,595.8 878.7 1,960.1 627.5 — 7,062.1 Other current assets — 194.3 — 1,998.4 31.4 — 2,224.1 Total current assets 583.5 5,024.3 883.1 4,005.3 1,867.2 — 12,363.4 Property and equipment, net — 780.1 3.4 468.2 21.9 — 1,273.6 Investments in subsidiaries 44,372.3 11,248.2 9,068.3 — — (64,688.8 ) — Intercompany — — 1,606.5 15,090.4 — (16,696.9 ) — Goodwill — 3,122.4 22,609.9 3,525.0 20.5 — 29,277.8 Other intangible assets, net — 682.2 6,924.5 1,020.2 10.0 — 8,636.9 Other assets 7.1 219.5 25.0 40.0 12.7 (111.1 ) 193.2 Total assets $ 44,962.9 $ 21,076.7 $ 41,120.7 $ 24,149.1 $ 1,932.3 $ (81,496.8 ) $ 51,744.9 Claims and rebates payable $ — $ 6,182.3 $ 2,654.6 $ — $ — $ — $ 8,836.9 Accounts payable — 1,118.2 42.5 2,655.5 59.5 — 3,875.7 Accrued expenses 125.0 1,147.2 368.4 191.0 1,161.6 — 2,993.2 Current maturities of long-term debt 722.3 — — — — — 722.3 Total current liabilities 847.3 8,447.7 3,065.5 2,846.5 1,221.1 — 16,428.1 Long-term debt 13,137.0 336.2 1,372.8 — — — 14,846.0 Intercompany 14,742.6 1,527.6 — — 426.7 (16,696.9 ) — Deferred taxes — — 2,468.9 1,245.5 — (111.1 ) 3,603.3 Other liabilities — 378.4 228.0 10.0 7.3 — 623.7 Non-controlling interest — — — — 7.8 — 7.8 Express Scripts stockholders’ equity 16,236.0 10,386.8 33,985.5 20,047.1 269.4 (64,688.8 ) 16,236.0 Total liabilities and stockholders’ equity $ 44,962.9 $ 21,076.7 $ 41,120.7 $ 24,149.1 $ 1,932.3 $ (81,496.8 ) $ 51,744.9 Condensed Consolidating Statement of Operations and Comprehensive Income (in millions) Express Scripts Holding Company Express Scripts, Inc. Medco Health Solutions, Inc. Guarantors Non-Guarantors Eliminations Consolidated For the three months ended September 30, 2017 Revenues $ — $ 17,032.6 $ 4,787.9 $ 15,109.6 $ 524.3 $ (12,771.0 ) $ 24,683.4 Operating expenses — 16,988.4 4,708.8 13,815.0 463.8 (12,771.0 ) 23,205.0 Operating income — 44.2 79.1 1,294.6 60.5 — 1,478.4 Other (expense) income: Interest (expense) income and other, net (127.6 ) 1.7 (7.1 ) (2.0 ) 0.9 — (134.1 ) Intercompany interest income (expense) 48.0 (24.0 ) — (24.0 ) — — — Other (expense) income, net (79.6 ) (22.3 ) (7.1 ) (26.0 ) 0.9 — (134.1 ) Income (loss) before income taxes (79.6 ) 21.9 72.0 1,268.6 61.4 — 1,344.3 Provision (benefit) for income taxes (28.2 ) 7.1 28.8 482.5 9.1 — 499.3 Income (loss) before equity in earnings of subsidiaries (51.4 ) 14.8 43.2 786.1 52.3 — 845.0 Equity in earnings of subsidiaries 893.1 768.7 66.4 — — (1,728.2 ) — Net income 841.7 783.5 109.6 786.1 52.3 (1,728.2 ) 845.0 Less: Net income attributable to non-controlling interest — — — — 3.3 — 3.3 Net income attributable to Express Scripts 841.7 783.5 109.6 786.1 49.0 (1,728.2 ) 841.7 Other comprehensive income 3.7 3.7 — — 3.7 (7.4 ) 3.7 Comprehensive income attributable to Express Scripts $ 845.4 $ 787.2 $ 109.6 $ 786.1 $ 52.7 $ (1,735.6 ) $ 845.4 For the three months ended September 30, 2016 Revenues $ — $ 9,910.4 $ 6,044.4 $ 9,973.0 $ 472.0 $ (989.7 ) $ 25,410.1 Operating expenses — 9,148.0 5,699.5 9,770.7 365.6 (989.7 ) 23,994.1 Operating income — 762.4 344.9 202.3 106.4 — 1,416.0 Other (expense) income: Interest expense and other, net (211.8 ) (29.9 ) (21.3 ) — (2.1 ) — (265.1 ) Intercompany interest income (expense) 132.8 (66.4 ) — (66.4 ) — — — Other expense, net (79.0 ) (96.3 ) (21.3 ) (66.4 ) (2.1 ) — (265.1 ) Income (loss) before income taxes (79.0 ) 666.1 323.6 135.9 104.3 — 1,150.9 Provision (benefit) for income taxes (27.9 ) 279.2 91.3 58.4 21.4 — 422.4 Income (loss) before equity in earnings of subsidiaries (51.1 ) 386.9 232.3 77.5 82.9 — 728.5 Equity in earnings (loss) of subsidiaries 774.0 178.1 (23.3 ) — — (928.8 ) — Net income 722.9 565.0 209.0 77.5 82.9 (928.8 ) 728.5 Less: Net income attributable to non-controlling interest — — — — 5.6 — 5.6 Net income attributable to Express Scripts 722.9 565.0 209.0 77.5 77.3 (928.8 ) 722.9 Other comprehensive loss (1.7 ) (1.7 ) — — (1.7 ) 3.4 (1.7 ) Comprehensive income attributable to Express Scripts $ 721.2 $ 563.3 $ 209.0 $ 77.5 $ 75.6 $ (925.4 ) $ 721.2 Condensed Consolidating Statement of Operations and Comprehensive Income (in millions) Express Scripts Holding Company Express Scripts, Inc. Medco Health Solutions, Inc. Guarantors Non-Guarantors Eliminations Consolidated For the nine months ended September 30, 2017 Revenues $ — $ 51,684.3 $ 14,305.8 $ 44,867.2 $ 1,751.5 $ (37,923.0 ) $ 74,685.8 Operating expenses — 51,468.0 14,039.1 41,561.7 1,628.4 (37,923.0 ) 70,774.2 Operating income — 216.3 266.7 3,305.5 123.1 — 3,911.6 Other (expense) income: Interest (expense) income and other, net (381.3 ) 1.9 (28.2 ) (0.8 ) (2.8 ) — (411.2 ) Intercompany interest income (expense) 147.0 (73.5 ) — (73.5 ) — — — Other expense, net (234.3 ) (71.6 ) (28.2 ) (74.3 ) (2.8 ) — (411.2 ) Income (loss) before income taxes (234.3 ) 144.7 238.5 3,231.2 120.3 — 3,500.4 Provision (benefit) for income taxes (84.8 ) 51.5 110.0 1,220.1 2.8 — 1,299.6 Income (loss) before equity in earnings of subsidiaries (149.5 ) 93.2 128.5 2,011.1 117.5 — 2,200.8 Equity in earnings of subsidiaries 2,339.3 2,010.2 107.4 — — (4,456.9 ) — Net income 2,189.8 2,103.4 235.9 2,011.1 117.5 (4,456.9 ) 2,200.8 Less: Net income attributable to non-controlling interest — — — — 11.0 — 11.0 Net income attributable to Express Scripts 2,189.8 2,103.4 235.9 2,011.1 106.5 (4,456.9 ) 2,189.8 Other comprehensive income 8.4 8.4 — — 8.4 (16.8 ) 8.4 Comprehensive income attributable to Express Scripts $ 2,198.2 $ 2,111.8 $ 235.9 $ 2,011.1 $ 114.9 $ (4,473.7 ) $ 2,198.2 For the nine months ended September 30, 2016 Revenues $ — $ 29,302.2 $ 18,519.0 $ 28,866.0 $ 1,641.1 $ (2,904.1 ) $ 75,424.2 Operating expenses — 27,439.3 17,620.3 28,263.2 1,392.4 (2,904.1 ) 71,811.1 Operating income — 1,862.9 898.7 602.8 248.7 — 3,613.1 Other (expense) income: Interest (expense) income and other, net (420.1 ) (59.1 ) (42.8 ) 4.3 (3.7 ) — (521.4 ) Intercompany interest income (expense) 262.4 (131.2 ) — (131.2 ) — — — Other expense, net (157.7 ) (190.3 ) (42.8 ) (126.9 ) (3.7 ) — (521.4 ) Income (loss) before income taxes (157.7 ) 1,672.6 855.9 475.9 245.0 — 3,091.7 Provision (benefit) for income taxes (57.4 ) 620.8 301.9 209.5 29.1 — 1,103.9 Income (loss) before equity in earnings of subsidiaries (100.3 ) 1,051.8 554.0 266.4 215.9 — 1,987.8 Equity in earnings (loss) of subsidiaries 2,070.0 509.5 (45.3 ) — — (2,534.2 ) — Net income 1,969.7 1,561.3 508.7 266.4 215.9 (2,534.2 ) 1,987.8 Less: Net income attributable to non-controlling interest — — — — 18.1 — 18.1 Net income attributable to Express Scripts 1,969.7 1,561.3 508.7 266.4 197.8 (2,534.2 ) 1,969.7 Other comprehensive income 4.4 4.4 — — 4.4 (8.8 ) 4.4 Comprehensive income attributable to Express Scripts $ 1,974.1 $ 1,565.7 $ 508.7 $ 266.4 $ 202.2 $ (2,543.0 ) $ 1,974.1 Condensed Consolidating Statements of Cash Flows (in millions) Express Scripts Holding Company Express Scripts, Inc. Medco Health Solutions, Inc. Guarantors Non-Guarantors Eliminations Consolidated For the nine months ended September 30, 2017 Net cash flows provided by (used in) operating activities $ (174.8 ) $ 868.3 $ 1,066.5 $ 2,955.0 $ (546.2 ) $ (187.3 ) $ 3,981.5 Cash flows from investing activities: Purchases of property and equipment — (128.0 ) — (39.8 ) (9.5 ) — (177.3 ) Acquisition of business, net of cash acquired — (122.7 ) — — — — (122.7 ) Other, net — (15.3 ) — 1.2 2.8 — (11.3 ) Net cash used in investing activities — (266.0 ) — (38.6 ) (6.7 ) — (311.3 ) Cash flows from financing activities: Treasury stock acquired (2,735.7 ) — — — — — (2,735.7 ) Repayment of long-term debt (650.0 ) — — — — — (650.0 ) Net proceeds from employee stock plans 51.3 — — — — — 51.3 Other, net — (19.0 ) — (9.3 ) (181.5 ) 187.3 (22.5 ) Net intercompany transactions 4,202.5 (263.3 ) (1,070.9 ) (2,902.3 ) 34.0 — — Net cash (used in) provided by financing activities 868.1 (282.3 ) (1,070.9 ) (2,911.6 ) (147.5 ) 187.3 (3,356.9 ) Effect of foreign currency translation adjustment — — — — 5.4 — 5.4 Net increase (decrease) in cash and cash equivalents 693.3 320.0 (4.4 ) 4.8 (695.0 ) — 318.7 Cash and cash equivalents at beginning of period 583.5 1,234.2 4.4 46.8 1,208.3 — 3,077.2 Cash and cash equivalents at end of period $ 1,276.8 $ 1,554.2 $ — $ 51.6 $ 513.3 $ — $ 3,395.9 Condensed Consolidating Statements of Cash Flows (in millions) Express Scripts Holding Company Express Scripts, Inc. Medco Health Solutions, Inc. Guarantors Non-Guarantors Eliminations Consolidated For the nine months ended September 30, 2016 Net cash flows provided by (used in) operating activities $ (1.4 ) $ 2,136.0 $ 21.8 $ 908.6 $ (394.5 ) $ — $ 2,670.5 Cash flows from investing activities: Purchases of property and equipment — (177.4 ) — (53.8 ) (6.4 ) — (237.6 ) Other, net — 2.3 — (1.0 ) (8.9 ) — (7.6 ) Net cash used in investing activities — (175.1 ) — (54.8 ) (15.3 ) — (245.2 ) Cash flows from financing activities: Treasury stock acquired (3,892.7 ) — — — — — (3,892.7 ) Repayment of long-term debt (3,363.8 ) (1,662.5 ) (368.7 ) — — — (5,395.0 ) Net proceeds from employee stock plans 56.0 — — — — — 56.0 Proceeds from long-term debt, net of discounts 5,986.8 — — — — — 5,986.8 Excess tax benefit relating to employee stock-based compensation — 7.4 3.7 — — — 11.1 Other, net (49.0 ) (15.0 ) 28.6 (9.7 ) (30.6 ) — (75.7 ) Net intercompany transactions 1,264.1 (475.4 ) 311.7 (828.3 ) (272.1 ) — — Net cash (used in) provided by financing activities 1.4 (2,145.5 ) (24.7 ) (838.0 ) (302.7 ) — (3,309.5 ) Effect of foreign currency translation adjustment — — — — 2.6 — 2.6 Net (decrease) increase in cash and cash equivalents — (184.6 ) (2.9 ) 15.8 (709.9 ) — (881.6 ) Cash and cash equivalents at beginning of period — 1,957.3 2.9 28.8 1,197.3 — 3,186.3 Cash and cash equivalents at end of period $ — $ 1,772.7 $ — $ 44.6 $ 487.4 $ — $ 2,304.7 |