Express Scripts 2013 Annual Report Download - page 108

Download and view the complete annual report

Please find page 108 of the 2013 Express Scripts annual report below. You can navigate through the pages in the report by either clicking on the pages listed below, or by using the keyword search tool below to find specific information within the annual report.

Page out of 124

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124

Express Scripts 2013 Annual Report 108
Condensed Consolidating Statement of Cash Flows
(in millions)
Express
Scripts
Holding
Company
Express
Scripts, Inc.
Medco
Health
Solutions,
Inc. Guarantors
Non-
Guarantors Eliminations Consolidated
For the year ended December 31, 2012
Net cash flows provided by (used in)
operating activities $ (147.3) $ 655.1 $ 3,355.4 $ 916.7 $ 1.7 $ — $ 4,781.6
Cash flows from investing activities:
Purchases of property and equipment — (70.0) — (85.9) (4.3) — (160.2)
Proceeds from the sale of business — 31.5 30.0———61.5
Acquisitions, net of cash acquired (10,283.6) — — — (42.4) — (10,326.0)
Other — (5.0) — — 1.0 — (4.0)
Net cash (used in) provided by investing
activities—continuing operations (10,283.6) (43.5) 30.0 (85.9) (45.7) — (10,428.7)
Acquisitions, cash acquired—
discontinued operations ————42.4 — 42.4
Net cash used in investing activities—
discontinued operations — — — (3.8) (1.6) — (5.4)
Net cash (used in) provided by investing
activities (10,283.6) (43.5) 30.0 (89.7) (4.9) — (10,391.7)
Cash flows from financing activities:
Repayment of long-term debt (1,368.4) (1,000.1) (1,500.0) — — — (3,868.5)
Net proceeds from employee stock
plans 295.2 — 30.8———326.0
Excess tax benefit relating to
employee stock-based compensation — 37.2 8.1———45.3
Distributions paid to non-controlling
interest ————(8.1) — (8.1)
Proceeds from long-term debt, net of
discounts 7,458.9—————7,458.9
Repayment of revolving credit line,
net — — (1,000.0) — — — (1,000.0)
Proceeds from accounts receivable
financing facility ————600.0 — 600.0
Repayment of accounts receivable
financing facility ————(600.0) — (600.0)
Deferred financing fees (52.4) (50.8) ————(103.2)
Net intercompany transactions 4,097.6 (2,773.5) (924.3) (705.5) 305.7 — —
Net cash provided by (used in)
financing activities—continuing
operations 10,430.9 (3,787.2) (3,385.4) (705.5) 297.6 — 2,850.4
Net cash used in financing activities—
discontinued operations ————(26.8) — (26.8)
Net cash provided by (used in)
financing activities 10,430.9 (3,787.2) (3,385.4) (705.5) 270.8 — 2,823.6
Effect of foreign currency translation
adjustment ————2.0—2.0
Less cash attributable to discontinued
operations ————(42.5) — (42.5)
Net (decrease) increase in cash and cash
equivalents — (3,175.6) — 121.5 227.1 — (2,827.0)
Cash and cash equivalents at beginning
of year — 5,522.2 — 5.4 92.5 — 5,620.1
Cash and cash equivalents at end of
year $ — $ 2,346.6 $ — $ 126.9 $ 319.6 $ — $ 2,793.1