10-Q Filing

MEDCO HEALTH SOLUTIONS INC CIK: 1170650 Q2 2011

Filing Information

Form Type	10-Q
Accession Number	`0000950123-11-068004`
Period End Date	20110630
Filing Date	20110726
Fiscal Year	2011
Fiscal Period	Q2
XBRL Instance	mhs-20110625.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 82 Income Statement 80 Cash Flow Statement 77 Stockholders Equity 29

Balance Sheet 82 line items

Line Item	Tag	Value	Unit	Period
Preferred stock, par value	`PreferredStockParOrStatedValuePerShare`	$0.01	USD	Point-in-time
Preferred stock, par value	`PreferredStockParOrStatedValuePerShare`	$0.01	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$1.18B	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$853.40M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$92.40M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$2.53B	USD	Point-in-time
Preferred stock, shares authorized	`PreferredStockSharesAuthorized`	10.00M	shares	Point-in-time
Preferred stock, shares authorized	`PreferredStockSharesAuthorized`	10.00M	shares	Point-in-time
Preferred stock, shares issued	`PreferredStockSharesIssued`	0.00	shares	Point-in-time
Short-term investments	`ShortTermInvestments`	$56.70M	USD	Point-in-time
Short-term investments	`ShortTermInvestments`	$8.20M	USD	Point-in-time
Preferred stock, shares issued	`PreferredStockSharesIssued`	0.00	shares	Point-in-time
Preferred stock, shares outstanding	`PreferredStockSharesOutstanding`	0.00	shares	Point-in-time
Manufacturer accounts receivable, net	`ManufacturerAccountsReceivableNet`	$1.90B	USD	Point-in-time
Manufacturer accounts receivable, net	`ManufacturerAccountsReceivableNet`	$1.91B	USD	Point-in-time
Preferred stock, shares outstanding	`PreferredStockSharesOutstanding`	0.00	shares	Point-in-time
Client accounts receivable, net	`ClientAccountsReceivableNet`	$2.48B	USD	Point-in-time
Client accounts receivable, net	`ClientAccountsReceivableNet`	$2.55B	USD	Point-in-time
Common stock, par value	`CommonStockParOrStatedValuePerShare`	$0.01	USD	Point-in-time
Common stock, par value	`CommonStockParOrStatedValuePerShare`	$0.01	USD	Point-in-time
Common stock, shares authorized	`CommonStockSharesAuthorized`	2.00B	shares	Point-in-time
Inventories, net	`InventoryNet`	$1.01B	USD	Point-in-time
Common stock, shares authorized	`CommonStockSharesAuthorized`	2.00B	shares	Point-in-time
Inventories, net	`InventoryNet`	$833.00M	USD	Point-in-time
Common stock, shares issued	`CommonStockSharesIssued`	666.84M	shares	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpensesAndOtherCurrentAssets`	$83.60M	USD	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpensesAndOtherCurrentAssets`	$75.80M	USD	Point-in-time
Common stock, shares issued	`CommonStockSharesIssued`	670.90M	shares	Point-in-time
Treasury stock, at cost, shares	`TreasuryStockShares`	279.36M	shares	Point-in-time
Deferred tax assets	`DeferredTaxAssetsNetCurrent`	$238.40M	USD	Point-in-time
Deferred tax assets	`DeferredTaxAssetsNetCurrent`	$248.30M	USD	Point-in-time
Treasury stock, at cost, shares	`TreasuryStockShares`	256.30M	shares	Point-in-time
Total current assets	`AssetsCurrent`	$6.69B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$5.66B	USD	Point-in-time
Property and equipment, net	`PropertyPlantAndEquipmentNet`	$993.60M	USD	Point-in-time
Property and equipment, net	`PropertyPlantAndEquipmentNet`	$1.00B	USD	Point-in-time
Goodwill	`Goodwill`	$6.94B	USD	Point-in-time
Goodwill	`Goodwill`	$6.96B	USD	Point-in-time
Intangible assets, net	`IntangibleAssetsNetExcludingGoodwill`	$2.29B	USD	Point-in-time
Intangible assets, net	`IntangibleAssetsNetExcludingGoodwill`	$2.41B	USD	Point-in-time
Other noncurrent assets	`OtherAssetsNoncurrent`	$68.70M	USD	Point-in-time
Other noncurrent assets	`OtherAssetsNoncurrent`	$85.80M	USD	Point-in-time
Total assets	`Assets`	$15.99B	USD	Point-in-time
Total assets	`Assets`	$17.10B	USD	Point-in-time
Claims and other accounts payable	`AccountsPayableCurrent`	$3.38B	USD	Point-in-time
Claims and other accounts payable	`AccountsPayableCurrent`	$3.50B	USD	Point-in-time
Client rebates and guarantees payable	`ClientRebatesAndGuaranteesPayable`	$2.45B	USD	Point-in-time
Client rebates and guarantees payable	`ClientRebatesAndGuaranteesPayable`	$2.26B	USD	Point-in-time
Accrued expenses and other current liabilities	`AccruedExpensesAndOtherCurrentLiabilities`	$683.60M	USD	Point-in-time
Accrued expenses and other current liabilities	`AccruedExpensesAndOtherCurrentLiabilities`	$910.20M	USD	Point-in-time
Short-term debt	`ShortTermBankLoansAndNotesPayable`	$31.90M	USD	Point-in-time
Short-term debt	`ShortTermBankLoansAndNotesPayable`	$23.60M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$2.00B	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	-	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$6.88B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$8.36B	USD	Point-in-time
Long-term debt, net	`LongTermDebtNoncurrent`	$5.00B	USD	Point-in-time
Long-term debt, net	`LongTermDebtNoncurrent`	$3.00B	USD	Point-in-time
Deferred tax liabilities	`DeferredTaxLiabilitiesNoncurrent`	$985.10M	USD	Point-in-time
Deferred tax liabilities	`DeferredTaxLiabilitiesNoncurrent`	$980.60M	USD	Point-in-time
Other noncurrent liabilities	`OtherLiabilitiesNoncurrent`	$239.40M	USD	Point-in-time
Other noncurrent liabilities	`OtherLiabilitiesNoncurrent`	$201.20M	USD	Point-in-time
Total liabilities	`Liabilities`	$12.55B	USD	Point-in-time
Total liabilities	`Liabilities`	$13.11B	USD	Point-in-time
Preferred stock, par value $0.01 - authorized: 10,000,000 shares; issued and outstanding: 0	`PreferredStockValue`	-	USD	Point-in-time
Preferred stock, par value $0.01 - authorized: 10,000,000 shares; issued and outstanding: 0	`PreferredStockValue`	-	USD	Point-in-time
Common stock, par value $0.01 - authorized: 2,000,000,000 shares; issued: 670,898,695 shares at June 25, 2011 and 666,836,033 shares at December 25, 2010	`CommonStockValue`	$6.70M	USD	Point-in-time
Common stock, par value $0.01 - authorized: 2,000,000,000 shares; issued: 670,898,695 shares at June 25, 2011 and 666,836,033 shares at December 25, 2010	`CommonStockValue`	$6.70M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-53.50M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-25.90M	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapitalCommonStock`	$8.46B	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapitalCommonStock`	$8.65B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$7.31B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$6.64B	USD	Point-in-time
Stockholders' equity before treasury stock	`StockholdersEquityBeforeTreasuryStock`	$15.05B	USD	Point-in-time
Stockholders' equity before treasury stock	`StockholdersEquityBeforeTreasuryStock`	$15.95B	USD	Point-in-time
Treasury stock, at cost: 279,358,024 shares at June 25, 2011 and 256,298,405 shares at December 25, 2010	`TreasuryStockValue`	$11.07B	USD	Point-in-time
Treasury stock, at cost: 279,358,024 shares at June 25, 2011 and 256,298,405 shares at December 25, 2010	`TreasuryStockValue`	$12.50B	USD	Point-in-time
Total stockholders' equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$3.44B	USD	Point-in-time
Total stockholders' equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$3.99B	USD	Point-in-time
Total liabilities and stockholders' equity	`LiabilitiesAndStockholdersEquity`	$17.10B	USD	Point-in-time
Total liabilities and stockholders' equity	`LiabilitiesAndStockholdersEquity`	$15.99B	USD	Point-in-time

Income Statement 80 line items

Line Item	Tag	Value	Unit	Period
Product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`SalesRevenueGoodsNet`	$32.25B	USD	2 Qtrs
Retail co-payments product net revenues	`RetailCoPaymentsProductNetRevenue`	$4.77B	USD	2 Qtrs
Product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`SalesRevenueGoodsNet`	$16.16B	USD	1 Quarter
Retail co-payments product net revenues	`RetailCoPaymentsProductNetRevenue`	$2.25B	USD	1 Quarter
Product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`SalesRevenueGoodsNet`	$16.72B	USD	1 Quarter
Product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`SalesRevenueGoodsNet`	$33.39B	USD	2 Qtrs
Retail co-payments product net revenues	`RetailCoPaymentsProductNetRevenue`	$2.28B	USD	1 Quarter
Retail co-payments product net revenues	`RetailCoPaymentsProductNetRevenue`	$4.75B	USD	2 Qtrs
Service revenues	`SalesRevenueServicesNet`	$244.20M	USD	1 Quarter
Service revenues	`SalesRevenueServicesNet`	$471.40M	USD	2 Qtrs
Service revenues	`SalesRevenueServicesNet`	$707.70M	USD	2 Qtrs
Service revenues	`SalesRevenueServicesNet`	$349.90M	USD	1 Quarter
Retail co-payments cost of product net revenues	`RetailCoPaymentsCostOfProductNetRevenue`	$2.25B	USD	1 Quarter
Total net revenues	`Revenues`	$32.72B	USD	2 Qtrs
Total net revenues	`Revenues`	$34.09B	USD	2 Qtrs
Retail co-payments cost of product net revenues	`RetailCoPaymentsCostOfProductNetRevenue`	$2.28B	USD	1 Quarter
Retail co-payments cost of product net revenues	`RetailCoPaymentsCostOfProductNetRevenue`	$4.77B	USD	2 Qtrs
Total net revenues	`Revenues`	$17.07B	USD	1 Quarter
Total net revenues	`Revenues`	$16.41B	USD	1 Quarter
Retail co-payments cost of product net revenues	`RetailCoPaymentsCostOfProductNetRevenue`	$4.75B	USD	2 Qtrs
Cost of product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`CostOfGoodsSold`	$31.67B	USD	2 Qtrs
Cost of product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`CostOfGoodsSold`	$15.28B	USD	1 Quarter
Cost of product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`CostOfGoodsSold`	$15.85B	USD	1 Quarter
Cost of product net revenues (Includes retail co-payments of $2,255 and $2,279 in the second quarters of 2011 and 2010, and $4,768 and $4,750 in the six months of 2011 and 2010)	`CostOfGoodsSold`	$30.54B	USD	2 Qtrs
Cost of service revenues	`CostOfServices`	$61.30M	USD	1 Quarter
Cost of service revenues	`CostOfServices`	$122.60M	USD	1 Quarter
Cost of service revenues	`CostOfServices`	$125.80M	USD	2 Qtrs
Cost of service revenues	`CostOfServices`	$243.00M	USD	2 Qtrs
Total cost of revenues	`CostOfGoodsAndServicesSold`	$15.35B	USD	1 Quarter
Total cost of revenues	`CostOfGoodsAndServicesSold`	$15.97B	USD	1 Quarter
Total cost of revenues	`CostOfGoodsAndServicesSold`	$30.66B	USD	2 Qtrs
Total cost of revenues	`CostOfGoodsAndServicesSold`	$31.92B	USD	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$807.40M	USD	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$727.00M	USD	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$420.30M	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$376.40M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$73.30M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$146.40M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$70.70M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$141.20M	USD	2 Qtrs
Interest expense	`InterestExpense`	$79.50M	USD	2 Qtrs
Interest expense	`InterestExpense`	$38.80M	USD	1 Quarter
Interest expense	`InterestExpense`	$52.30M	USD	1 Quarter
Interest expense	`InterestExpense`	$104.20M	USD	2 Qtrs
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$-4.30M	USD	2 Qtrs
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$-1.90M	USD	1 Quarter
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$7.70M	USD	2 Qtrs
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$6.30M	USD	1 Quarter
Total costs and expenses	`AggregateCostsAndExpenses`	$31.60B	USD	2 Qtrs
Total costs and expenses	`AggregateCostsAndExpenses`	$32.98B	USD	2 Qtrs
Total costs and expenses	`AggregateCostsAndExpenses`	$15.83B	USD	1 Quarter
Total costs and expenses	`AggregateCostsAndExpenses`	$16.52B	USD	1 Quarter
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$1.11B	USD	2 Qtrs
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$582.10M	USD	1 Quarter
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$1.11B	USD	2 Qtrs
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$557.60M	USD	1 Quarter
Provision for income taxes	`IncomeTaxExpenseBenefit`	$437.10M	USD	2 Qtrs
Provision for income taxes	`IncomeTaxExpenseBenefit`	$225.20M	USD	1 Quarter
Provision for income taxes	`IncomeTaxExpenseBenefit`	$437.50M	USD	2 Qtrs
Provision for income taxes	`IncomeTaxExpenseBenefit`	$214.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$356.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$675.90M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$677.40M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$342.80M	USD	1 Quarter
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	401.60M	shares	2 Qtrs
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	460.40M	shares	2 Qtrs
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	397.60M	shares	1 Quarter
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	453.00M	shares	1 Quarter
Basic earnings per share	`EarningsPerShareBasic`	$1.68	USD	2 Qtrs
Basic earnings per share	`EarningsPerShareBasic`	$0.86	USD	1 Quarter
Basic earnings per share	`EarningsPerShareBasic`	$0.79	USD	1 Quarter
Basic earnings per share	`EarningsPerShareBasic`	$1.47	USD	2 Qtrs
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	405.10M	shares	1 Quarter
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	409.60M	shares	2 Qtrs
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	470.10M	shares	2 Qtrs
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	462.00M	shares	1 Quarter
Diluted earnings per share	`EarningsPerShareDiluted`	$1.65	USD	2 Qtrs
Diluted earnings per share	`EarningsPerShareDiluted`	$1.44	USD	2 Qtrs
Diluted earnings per share	`EarningsPerShareDiluted`	$0.85	USD	1 Quarter
Diluted earnings per share	`EarningsPerShareDiluted`	$0.77	USD	1 Quarter

Cash Flow Statement 77 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$356.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$675.90M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$677.40M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$342.80M	USD	1 Quarter
Depreciation	`Depreciation`	$102.00M	USD	2 Qtrs
Depreciation	`Depreciation`	$89.20M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$73.30M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$146.40M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$70.70M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$141.20M	USD	2 Qtrs
Deferred income taxes	`AdjustmentForDeferredIncomeTaxes`	$-91.00M	USD	2 Qtrs
Deferred income taxes	`AdjustmentForDeferredIncomeTaxes`	$-66.80M	USD	2 Qtrs
Stock-based compensation on employee stock plans	`ShareBasedCompensation`	$77.80M	USD	2 Qtrs
Stock-based compensation on employee stock plans	`ShareBasedCompensation`	$83.80M	USD	2 Qtrs
Tax benefit on employee stock plans	`TaxBenefitFromStockOptionsExercised`	$62.50M	USD	2 Qtrs
Tax benefit on employee stock plans	`TaxBenefitFromStockOptionsExercised`	$63.40M	USD	2 Qtrs
Excess tax benefits from stock-based compensation arrangements	`ExcessTaxBenefitFromShareBasedCompensationOperatingActivities`	$27.90M	USD	2 Qtrs
Excess tax benefits from stock-based compensation arrangements	`ExcessTaxBenefitFromShareBasedCompensationOperatingActivities`	$34.10M	USD	2 Qtrs
Other	`AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivitiesOther`	$49.10M	USD	2 Qtrs
Other	`AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivitiesOther`	$40.30M	USD	2 Qtrs
Manufacturer accounts receivable, net	`IncreaseDecreaseInManufacturerAccountsReceivableNet`	$30.90M	USD	2 Qtrs
Manufacturer accounts receivable, net	`IncreaseDecreaseInManufacturerAccountsReceivableNet`	$14.20M	USD	2 Qtrs
Client accounts receivable, net	`IncreaseDecreaseInClientAccountsReceivableNet`	$80.30M	USD	2 Qtrs
Client accounts receivable, net	`IncreaseDecreaseInClientAccountsReceivableNet`	$-5.70M	USD	2 Qtrs
Income taxes receivable	`IncreaseDecreaseInIncomeTaxesReceivable`	$2.00M	USD	2 Qtrs
Income taxes receivable	`IncreaseDecreaseInIncomeTaxesReceivable`	$-174.60M	USD	2 Qtrs
Inventories, net	`IncreaseDecreaseInInventories`	$-181.10M	USD	2 Qtrs
Inventories, net	`IncreaseDecreaseInInventories`	$-121.80M	USD	2 Qtrs
Prepaid expenses and other current assets	`IncreaseDecreaseInPrepaidDeferredExpenseAndOtherAssets`	$6.10M	USD	2 Qtrs
Prepaid expenses and other current assets	`IncreaseDecreaseInPrepaidDeferredExpenseAndOtherAssets`	$9.90M	USD	2 Qtrs
Other noncurrent assets	`IncreaseDecreaseInOtherOperatingAssets`	$11.20M	USD	2 Qtrs
Other noncurrent assets	`IncreaseDecreaseInOtherOperatingAssets`	$16.00M	USD	2 Qtrs
Claims and other accounts payable	`IncreaseDecreaseInAccountsPayable`	$-110.60M	USD	2 Qtrs
Claims and other accounts payable	`IncreaseDecreaseInAccountsPayable`	$-345.30M	USD	2 Qtrs
Client rebates and guarantees payable	`IncreaseDecreaseInClientRebatesAndGuaranteesPayable`	$348.00M	USD	2 Qtrs
Client rebates and guarantees payable	`IncreaseDecreaseInClientRebatesAndGuaranteesPayable`	$-192.90M	USD	2 Qtrs
Accrued expenses and other current and noncurrent liabilities	`IncreaseDecreaseInAccruedExpensesAndOtherCurrentAndNoncurrentLiabilities`	$-220.80M	USD	2 Qtrs
Accrued expenses and other current and noncurrent liabilities	`IncreaseDecreaseInAccruedExpensesAndOtherCurrentAndNoncurrentLiabilities`	$-149.00M	USD	2 Qtrs
Net cash provided by operating activities	`NetCashProvidedByUsedInOperatingActivities`	$990.80M	USD	2 Qtrs
Net cash provided by operating activities	`NetCashProvidedByUsedInOperatingActivities`	$640.40M	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$66.60M	USD	1 Quarter
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$100.40M	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$111.10M	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$57.80M	USD	1 Quarter
Purchases of securities and other assets	`PurchaseOfSecuritiesAndOtherAssets`	$14.10M	USD	2 Qtrs
Purchases of securities and other assets	`PurchaseOfSecuritiesAndOtherAssets`	$23.20M	USD	2 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$33.80M	USD	2 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$3.40M	USD	2 Qtrs
Proceeds from sale of securities and other investments	`ProceedsFromSaleOfShortTermInvestments`	$18.50M	USD	2 Qtrs
Proceeds from sale of securities and other investments	`ProceedsFromSaleOfShortTermInvestments`	$48.50M	USD	2 Qtrs
Net cash used by investing activities	`NetCashProvidedByUsedInInvestingActivities`	$-80.10M	USD	2 Qtrs
Net cash used by investing activities	`NetCashProvidedByUsedInInvestingActivities`	$-138.90M	USD	2 Qtrs
Proceeds from revolving credit facility	`ProceedsFromLongTermLinesOfCredit`	$7.24B	USD	2 Qtrs
Proceeds from revolving credit facility	`ProceedsFromLongTermLinesOfCredit`	$200.00M	USD	2 Qtrs
Repayments on revolving credit facility	`RepaymentsOfLongTermLinesOfCredit`	$200.00M	USD	2 Qtrs
Repayments on revolving credit facility	`RepaymentsOfLongTermLinesOfCredit`	$7.24B	USD	2 Qtrs
Proceeds from accounts receivable financing facility and other	`ProceedsFromOtherShortTermDebt`	$3.30M	USD	2 Qtrs
Proceeds from accounts receivable financing facility and other	`ProceedsFromOtherShortTermDebt`	$546.30M	USD	2 Qtrs
Repayments under accounts receivable financing facility	`RepaymentsOfOtherShortTermDebt`	$538.00M	USD	2 Qtrs
Purchases of treasury stock	`PaymentsForRepurchaseOfCommonStock`	$1.44B	USD	2 Qtrs
Purchases of treasury stock	`PaymentsForRepurchaseOfCommonStock`	$2.26B	USD	2 Qtrs
Excess tax benefits from stock-based compensation arrangements	`ExcessTaxBenefitFromShareBasedCompensationFinancingActivities`	$34.10M	USD	2 Qtrs
Excess tax benefits from stock-based compensation arrangements	`ExcessTaxBenefitFromShareBasedCompensationFinancingActivities`	$27.90M	USD	2 Qtrs
Net proceeds from employee stock plans	`ProceedsFromIssuanceOfSharesUnderIncentiveAndShareBasedCompensationPlansIncludingStockOptions`	$79.10M	USD	2 Qtrs
Net proceeds from employee stock plans	`ProceedsFromIssuanceOfSharesUnderIncentiveAndShareBasedCompensationPlansIncludingStockOptions`	$24.10M	USD	2 Qtrs
Net cash used by financing activities	`NetCashProvidedByUsedInFinancingActivities`	$-2.20B	USD	2 Qtrs
Net cash used by financing activities	`NetCashProvidedByUsedInFinancingActivities`	$-1.32B	USD	2 Qtrs
Net decrease in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$-1.34B	USD	2 Qtrs
Net decrease in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$-761.00M	USD	2 Qtrs
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$1.18B	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$853.40M	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$92.40M	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$2.53B	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$1.18B	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$853.40M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$92.40M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$2.53B	USD	Point-in-time

Stockholders Equity 29 line items

Line Item	Tag	Value	Unit	Period
Tax portion on amortization of unrealized loss on cash flow hedge	`OtherComprehensiveIncomeReclassificationAdjustmentOnDerivativesIncludedInNetIncomeTax`	$-700.00K	USD	2 Qtrs
Tax portion on net activity due to curtailments	`OtherComprehensiveIncomeFinalizationOfPensionAndNonPensionPostretirementPlanValuationTax`	$-11.60M	USD	2 Qtrs
Tax portion on amortization of prior service credit included in net periodic benefit cost	`OtherComprehensiveIncomeAmortizationOfDefinedBenefitPlanNetPriorServiceCostRecognizedInNetPeriodicPensionCostTax`	$600.00K	USD	2 Qtrs
Beginning Balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$3.44B	USD	Point-in-time
Beginning Balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$3.99B	USD	Point-in-time
Tax portion on net gains included in net periodic benefit cost	`OtherComprehensiveIncomeReclassificationOfDefinedBenefitPlansNetGainLossRecognizedInNetPeriodicBenefitCostTax`	$-100.00K	USD	2 Qtrs
Net income	`NetIncomeLoss`	$356.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$675.90M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$677.40M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$342.80M	USD	1 Quarter
Foreign currency translation gain and other	`OtherComprehensiveIncomeForeignCurrencyTransactionAndTranslationGainLossBeforeReclassificationAndTax`	$9.90M	USD	2 Qtrs
Amortization of unrealized loss on cash flow hedge, net of tax of $(0.7)	`OtherComprehensiveIncomeReclassificationAdjustmentOnDerivativesIncludedInNetIncomeNetOfTax`	$-1.10M	USD	2 Qtrs
Net activity due to curtailments, net of tax of $(11.6)	`OtherComprehensiveIncomeFinalizationOfPensionAndNonPensionPostretirementPlanValuationNetOfTax`	$-17.30M	USD	2 Qtrs
Amortization of prior service credit included in net periodic benefit cost, net of tax of $0.6	`OtherComprehensiveIncomeAmortizationOfDefinedBenefitPlanNetPriorServiceCostRecognizedInNetPeriodicPensionCostNetOfTax`	$-900.00K	USD	2 Qtrs
Net gains included in net periodic benefit cost, net of tax of $(0.1)	`OtherComprehensiveIncomeReclassificationOfDefinedBenefitPlansNetGainLossRecognizedInNetPeriodicBenefitCostNetOfTax`	$200.00K	USD	2 Qtrs
Other comprehensive income	`OtherComprehensiveIncomeLossNetOfTaxPeriodIncreaseDecrease`	$27.60M	USD	2 Qtrs
Total comprehensive income	`ComprehensiveIncomeNetOfTaxIncludingPortionAttributableToNoncontrollingInterest`	$703.50M	USD	2 Qtrs
Stock option activity, including tax benefit	`StockOptionActivityIncludingTaxBenefitValue`	$162.70M	USD	2 Qtrs
Issuance of common stock under employee stock purchase plan	`StockIssuedDuringPeriodValueEmployeeStockPurchasePlan`	$11.70M	USD	2 Qtrs
Restricted stock unit activity, including tax benefit	`RestrictedStockUnitActivityIncludingTaxBenefitValue`	$16.10M	USD	2 Qtrs
Treasury stock acquired	`TreasuryStockValueAcquiredCostMethod`	$1.44B	USD	2 Qtrs
Treasury stock acquired, Shares	`TreasuryStockSharesAcquired`	9.60M	shares	1 Quarter
Treasury stock acquired, Shares	`TreasuryStockSharesAcquired`	23.10M	shares	2 Qtrs
Treasury stock acquired, Shares	`TreasuryStockSharesAcquired`	37.10M	shares	2 Qtrs
Treasury stock acquired, Shares	`TreasuryStockSharesAcquired`	17.60M	shares	1 Quarter
Treasury stock acquired, Shares	`TreasuryStockSharesAcquired`	223.30M	shares	19 Qtrs
Treasury stock acquired, Shares	`TreasuryStockSharesAcquired`	279.30M	shares	23 Qtrs
Ending Balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$3.44B	USD	Point-in-time
Ending Balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$3.99B	USD	Point-in-time

Data is extracted from SEC EDGAR XBRL filings. Values shown are as reported in the filing.