10-Q Filing

MEDCO HEALTH SOLUTIONS INC CIK: 1170650 Q2 2010

Filing Information

Form Type	10-Q
Accession Number	`0000950123-10-067319`
Period End Date	20100630
Filing Date	20100722
Fiscal Year	2010
Fiscal Period	Q2
XBRL Instance	mhs-20100626.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 82 Income Statement 80 Cash Flow Statement 73 Stockholders Equity 28

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
Preferred stock, shares authorized	`PreferredStockSharesAuthorized`	10.00M	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$2.09B	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$2.53B	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$938.40M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$1.18B	USD	Point-in-time
Preferred stock, shares authorized	`PreferredStockSharesAuthorized`	10.00M	shares	Point-in-time
Short-term investments	`ShortTermInvestments`	$54.00M	USD	Point-in-time
Preferred stock, shares issued	`PreferredStockSharesIssued`	0.00	shares	Point-in-time
Preferred stock, shares issued	`PreferredStockSharesIssued`	0.00	shares	Point-in-time
Short-term investments	`ShortTermInvestments`	$20.10M	USD	Point-in-time
Manufacturer accounts receivable, net	`ManufacturerAccountsReceivableNet`	$1.77B	USD	Point-in-time
Manufacturer accounts receivable, net	`ManufacturerAccountsReceivableNet`	$1.80B	USD	Point-in-time
Preferred stock, shares outstanding	`PreferredStockSharesOutstanding`	0.00	shares	Point-in-time
Preferred stock, shares outstanding	`PreferredStockSharesOutstanding`	0.00	shares	Point-in-time
Client accounts receivable, net	`ClientAccountsReceivableNet`	$2.08B	USD	Point-in-time
Client accounts receivable, net	`ClientAccountsReceivableNet`	$2.06B	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
Income taxes receivable	`IncomeTaxesReceivable`	$198.30M	USD	Point-in-time
Common stock, shares authorized	`CommonStockSharesAuthorized`	2.00B	shares	Point-in-time
Common stock, shares authorized	`CommonStockSharesAuthorized`	2.00B	shares	Point-in-time
Income taxes receivable	`IncomeTaxesReceivable`	$23.70M	USD	Point-in-time
Inventories, net	`InventoryNet`	$1.29B	USD	Point-in-time
Common stock, shares issued	`CommonStockSharesIssued`	660.85M	shares	Point-in-time
Inventories, net	`InventoryNet`	$1.16B	USD	Point-in-time
Common stock, shares issued	`CommonStockSharesIssued`	664.02M	shares	Point-in-time
Treasury stock, shares	`TreasuryStockShares`	223.41M	shares	Point-in-time
Treasury stock, shares	`TreasuryStockShares`	186.35M	shares	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpensesAndOtherCurrentAssets`	$67.10M	USD	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpensesAndOtherCurrentAssets`	$77.00M	USD	Point-in-time
Deferred tax assets	`DeferredTaxAssetsNetCurrent`	$232.60M	USD	Point-in-time
Deferred tax assets	`DeferredTaxAssetsNetCurrent`	$230.80M	USD	Point-in-time
Total current assets	`AssetsCurrent`	$6.61B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$8.16B	USD	Point-in-time
Property and equipment, net	`PropertyPlantAndEquipmentNet`	$923.30M	USD	Point-in-time
Property and equipment, net	`PropertyPlantAndEquipmentNet`	$912.50M	USD	Point-in-time
Goodwill	`Goodwill`	$6.33B	USD	Point-in-time
Goodwill	`Goodwill`	$6.35B	USD	Point-in-time
Intangible assets, net	`IntangibleAssetsNetExcludingGoodwill`	$2.30B	USD	Point-in-time
Intangible assets, net	`IntangibleAssetsNetExcludingGoodwill`	$2.43B	USD	Point-in-time
Other noncurrent assets	`OtherAssetsNoncurrent`	$82.60M	USD	Point-in-time
Other noncurrent assets	`OtherAssetsNoncurrent`	$61.90M	USD	Point-in-time
Total assets	`Assets`	$17.92B	USD	Point-in-time
Total assets	`Assets`	$16.24B	USD	Point-in-time
Claims and other accounts payable	`AccountsPayableCurrent`	$3.51B	USD	Point-in-time
Claims and other accounts payable	`AccountsPayableCurrent`	$3.16B	USD	Point-in-time
Client rebates and guarantees payable	`ClientRebatesAndGuaranteesPayable`	$2.45B	USD	Point-in-time
Client rebates and guarantees payable	`ClientRebatesAndGuaranteesPayable`	$2.11B	USD	Point-in-time
Accrued expenses and other current liabilities	`AccruedExpensesAndOtherCurrentLiabilities`	$718.60M	USD	Point-in-time
Accrued expenses and other current liabilities	`AccruedExpensesAndOtherCurrentLiabilities`	$553.00M	USD	Point-in-time
Short-term debt	`ShortTermBankLoansAndNotesPayable`	$15.80M	USD	Point-in-time
Short-term debt	`ShortTermBankLoansAndNotesPayable`	$19.10M	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$6.35B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$6.19B	USD	Point-in-time
Long-term debt, net	`LongTermDebtNoncurrent`	$4.00B	USD	Point-in-time
Long-term debt, net	`LongTermDebtNoncurrent`	$4.00B	USD	Point-in-time
Deferred tax liabilities	`DeferredTaxLiabilitiesNoncurrent`	$958.80M	USD	Point-in-time
Deferred tax liabilities	`DeferredTaxLiabilitiesNoncurrent`	$897.10M	USD	Point-in-time
Other noncurrent liabilities	`OtherLiabilitiesNoncurrent`	$227.50M	USD	Point-in-time
Other noncurrent liabilities	`OtherLiabilitiesNoncurrent`	$221.70M	USD	Point-in-time
Total liabilities	`Liabilities`	$11.31B	USD	Point-in-time
Total liabilities	`Liabilities`	$11.53B	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: 664,015,857 shares at June 26, 2010 and 660,846,867 shares at December 26, 2009	`CommonStockValue`	$6.60M	USD	Point-in-time
Common stock, par value $0.01 - authorized: 2,000,000,000 shares; issued: 664,015,857 shares at June 26, 2010 and 660,846,867 shares at December 26, 2009	`CommonStockValue`	$6.60M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-61.10M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-44.20M	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapitalCommonStock`	$8.16B	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapitalCommonStock`	$8.29B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$5.21B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$5.89B	USD	Point-in-time
Stockholders' equity before treasury stock	`StockholdersEquityBeforeTreasuryStock`	$13.33B	USD	Point-in-time
Stockholders' equity before treasury stock	`StockholdersEquityBeforeTreasuryStock`	$14.12B	USD	Point-in-time
Treasury stock, at cost: 223,411,093 shares at June 26, 2010 and 186,353,868 shares at December 26, 2009	`TreasuryStockValue`	$6.94B	USD	Point-in-time
Treasury stock, at cost: 223,411,093 shares at June 26, 2010 and 186,353,868 shares at December 26, 2009	`TreasuryStockValue`	$9.20B	USD	Point-in-time
Total stockholders' equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$6.39B	USD	Point-in-time
Total stockholders' equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$4.93B	USD	Point-in-time
Total liabilities and stockholders' equity	`LiabilitiesAndStockholdersEquity`	$17.92B	USD	Point-in-time
Total liabilities and stockholders' equity	`LiabilitiesAndStockholdersEquity`	$16.24B	USD	Point-in-time

Income Statement 80 line items

Line Item	Tag	Value	Unit	Period
Product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`SalesRevenueGoodsNet`	$16.16B	USD	1 Quarter
Product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`SalesRevenueGoodsNet`	$32.25B	USD	2 Qtrs
Retail co-payments product net revenue	`RetailCoPaymentsProductNetRevenue`	$2.28B	USD	1 Quarter
Retail co-payments product net revenue	`RetailCoPaymentsProductNetRevenue`	$4.37B	USD	2 Qtrs
Retail co-payments product net revenue	`RetailCoPaymentsProductNetRevenue`	$2.11B	USD	1 Quarter
Product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`SalesRevenueGoodsNet`	$14.73B	USD	1 Quarter
Product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`SalesRevenueGoodsNet`	$29.35B	USD	2 Qtrs
Retail co-payments product net revenue	`RetailCoPaymentsProductNetRevenue`	$4.75B	USD	2 Qtrs
Service revenues	`SalesRevenueServicesNet`	$418.50M	USD	2 Qtrs
Service revenues	`SalesRevenueServicesNet`	$471.40M	USD	2 Qtrs
Service revenues	`SalesRevenueServicesNet`	$244.20M	USD	1 Quarter
Service revenues	`SalesRevenueServicesNet`	$200.80M	USD	1 Quarter
Retail co-payments cost of product net revenue	`RetailCoPaymentsCostOfProductNetRevenue`	$2.11B	USD	1 Quarter
Retail co-payments cost of product net revenue	`RetailCoPaymentsCostOfProductNetRevenue`	$2.28B	USD	1 Quarter
Retail co-payments cost of product net revenue	`RetailCoPaymentsCostOfProductNetRevenue`	$4.37B	USD	2 Qtrs
Total net revenues	`Revenues`	$16.41B	USD	1 Quarter
Total net revenues	`Revenues`	$32.72B	USD	2 Qtrs
Total net revenues	`Revenues`	$14.93B	USD	1 Quarter
Retail co-payments cost of product net revenue	`RetailCoPaymentsCostOfProductNetRevenue`	$4.75B	USD	2 Qtrs
Total net revenues	`Revenues`	$29.76B	USD	2 Qtrs
Cost of product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`CostOfGoodsSold`	$13.86B	USD	1 Quarter
Cost of product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`CostOfGoodsSold`	$27.69B	USD	2 Qtrs
Cost of product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`CostOfGoodsSold`	$30.54B	USD	2 Qtrs
Cost of product net revenues (Includes retail co-payments of $2,279 and $2,114 in the second quarters of 2010 and 2009, and $4,750 and $4,373 in the six months of 2010 and 2009)	`CostOfGoodsSold`	$15.28B	USD	1 Quarter
Cost of service revenues	`CostOfServices`	$116.30M	USD	2 Qtrs
Cost of service revenues	`CostOfServices`	$61.30M	USD	1 Quarter
Cost of service revenues	`CostOfServices`	$58.50M	USD	1 Quarter
Cost of service revenues	`CostOfServices`	$125.80M	USD	2 Qtrs
Total cost of revenues	`CostOfGoodsAndServicesSold`	$13.91B	USD	1 Quarter
Total cost of revenues	`CostOfGoodsAndServicesSold`	$27.80B	USD	2 Qtrs
Total cost of revenues	`CostOfGoodsAndServicesSold`	$15.35B	USD	1 Quarter
Total cost of revenues	`CostOfGoodsAndServicesSold`	$30.66B	USD	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$711.00M	USD	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$370.70M	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$376.40M	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$727.00M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$70.70M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$151.80M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$75.90M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$141.20M	USD	2 Qtrs
Interest expense	`InterestExpense`	$88.50M	USD	2 Qtrs
Interest expense	`InterestExpense`	$43.40M	USD	1 Quarter
Interest expense	`InterestExpense`	$79.50M	USD	2 Qtrs
Interest expense	`InterestExpense`	$38.80M	USD	1 Quarter
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$2.20M	USD	1 Quarter
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$6.30M	USD	1 Quarter
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$5.70M	USD	2 Qtrs
Interest (income) and other (income) expense, net	`OtherNonoperatingIncomeExpense`	$7.70M	USD	2 Qtrs
Total costs and expenses	`TotalCostsAndExpenses`	$28.75B	USD	2 Qtrs
Total costs and expenses	`TotalCostsAndExpenses`	$31.60B	USD	2 Qtrs
Total costs and expenses	`TotalCostsAndExpenses`	$15.83B	USD	1 Quarter
Total costs and expenses	`TotalCostsAndExpenses`	$14.40B	USD	1 Quarter
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$528.00M	USD	1 Quarter
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$1.11B	USD	2 Qtrs
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$1.01B	USD	2 Qtrs
Income before provision for income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$582.10M	USD	1 Quarter
Provision for income taxes	`IncomeTaxExpenseBenefit`	$225.20M	USD	1 Quarter
Provision for income taxes	`IncomeTaxExpenseBenefit`	$215.90M	USD	1 Quarter
Provision for income taxes	`IncomeTaxExpenseBenefit`	$411.20M	USD	2 Qtrs
Provision for income taxes	`IncomeTaxExpenseBenefit`	$437.10M	USD	2 Qtrs
Net income	`ProfitLoss`	$603.20M	USD	2 Qtrs
Net income	`ProfitLoss`	$677.40M	USD	2 Qtrs
Net income	`ProfitLoss`	$356.90M	USD	1 Quarter
Net income	`ProfitLoss`	$312.10M	USD	1 Quarter
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	453.00M	shares	1 Quarter
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	460.40M	shares	2 Qtrs
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	485.90M	shares	2 Qtrs
Basic weighted average shares outstanding	`WeightedAverageNumberOfSharesOutstandingBasic`	479.60M	shares	1 Quarter
Basic earnings per share	`EarningsPerShareBasic`	$0.79	USD	1 Quarter
Basic earnings per share	`EarningsPerShareBasic`	$1.24	USD	2 Qtrs
Basic earnings per share	`EarningsPerShareBasic`	$1.47	USD	2 Qtrs
Basic earnings per share	`EarningsPerShareBasic`	$0.65	USD	1 Quarter
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	470.10M	shares	2 Qtrs
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	494.50M	shares	2 Qtrs
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	488.00M	shares	1 Quarter
Diluted weighted average shares outstanding	`WeightedAverageNumberOfDilutedSharesOutstanding`	462.00M	shares	1 Quarter
Diluted earnings per share	`EarningsPerShareDiluted`	$0.77	USD	1 Quarter
Diluted earnings per share	`EarningsPerShareDiluted`	$1.44	USD	2 Qtrs
Diluted earnings per share	`EarningsPerShareDiluted`	$0.64	USD	1 Quarter
Diluted earnings per share	`EarningsPerShareDiluted`	$1.22	USD	2 Qtrs

Cash Flow Statement 73 line items

Line Item	Tag	Value	Unit	Period
Net income	`ProfitLoss`	$603.20M	USD	2 Qtrs
Net income	`ProfitLoss`	$677.40M	USD	2 Qtrs
Net income	`ProfitLoss`	$356.90M	USD	1 Quarter
Net income	`ProfitLoss`	$312.10M	USD	1 Quarter
Depreciation	`Depreciation`	$89.20M	USD	2 Qtrs
Depreciation	`Depreciation`	$87.40M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$70.70M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$151.80M	USD	2 Qtrs
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$75.90M	USD	1 Quarter
Amortization of intangibles	`AmortizationOfIntangibleAssets`	$141.20M	USD	2 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-91.00M	USD	2 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-132.90M	USD	2 Qtrs
Stock-based compensation on employee stock plans	`ShareBasedCompensation`	$71.20M	USD	2 Qtrs
Stock-based compensation on employee stock plans	`ShareBasedCompensation`	$77.80M	USD	2 Qtrs
Tax benefit on employee stock plans	`TaxBenefitFromStockOptionsExercised`	$43.80M	USD	2 Qtrs
Tax benefit on employee stock plans	`TaxBenefitFromStockOptionsExercised`	$63.40M	USD	2 Qtrs
Excess tax benefits from stock-based compensation arrangements	`ExcessTaxBenefitFromShareBasedCompensationOperatingActivities`	$34.10M	USD	2 Qtrs
Excess tax benefits from stock-based compensation arrangements	`ExcessTaxBenefitFromShareBasedCompensationOperatingActivities`	$20.40M	USD	2 Qtrs
Other	`AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivitiesOther`	$83.10M	USD	2 Qtrs
Other	`AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivitiesOther`	$49.10M	USD	2 Qtrs
Manufacturer accounts receivable, net	`IncreaseDecreaseInManufacturerAccountsReceivableNet`	$20.90M	USD	2 Qtrs
Manufacturer accounts receivable, net	`IncreaseDecreaseInManufacturerAccountsReceivableNet`	$30.90M	USD	2 Qtrs
Client accounts receivable, net	`IncreaseDecreaseInClientAccountsReceivableNet`	$80.30M	USD	2 Qtrs
Client accounts receivable, net	`IncreaseDecreaseInClientAccountsReceivableNet`	$334.30M	USD	2 Qtrs
Income taxes receivable	`IncreaseDecreaseInIncomeTaxesReceivable`	$-174.60M	USD	2 Qtrs
Income taxes receivable	`IncreaseDecreaseInIncomeTaxesReceivable`	$-17.50M	USD	2 Qtrs
Inventories, net	`IncreaseDecreaseInInventories`	$-359.30M	USD	2 Qtrs
Inventories, net	`IncreaseDecreaseInInventories`	$-121.80M	USD	2 Qtrs
Prepaid expenses and other current assets	`IncreaseDecreaseInPrepaidDeferredExpenseAndOtherAssets`	$-257.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`	$-7.00M	USD	2 Qtrs
Claims and other accounts payable	`IncreaseDecreaseInAccountsPayable`	$644.10M	USD	2 Qtrs
Claims and other accounts payable	`IncreaseDecreaseInAccountsPayable`	$-345.30M	USD	2 Qtrs
Client rebates and guarantees payable	`IncreaseDecreaseInClientRebatesAndGuaranteesPayable`	$510.40M	USD	2 Qtrs
Client rebates and guarantees payable	`IncreaseDecreaseInClientRebatesAndGuaranteesPayable`	$348.00M	USD	2 Qtrs
Accrued expenses and other current and noncurrent liabilities	`IncreaseDecreaseInAccruedExpensesAndOtherCurrentAndNoncurrentLiabilities`	$-61.90M	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`	$2.27B	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$98.10M	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$57.80M	USD	1 Quarter
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$62.70M	USD	1 Quarter
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$100.40M	USD	2 Qtrs
Purchases of securities and other assets	`PurchaseOfSecuritiesAndOtherAssets`	$105.20M	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
Proceeds from sale of securities and other investments	`ProceedsFromSaleOfShortTermInvestments`	$18.50M	USD	2 Qtrs
Proceeds from sale of securities and other investments	`ProceedsFromSaleOfShortTermInvestments`	$44.10M	USD	2 Qtrs
Net cash used by investing activities	`NetCashProvidedByUsedInInvestingActivities`	$-159.20M	USD	2 Qtrs
Net cash used by investing activities	`NetCashProvidedByUsedInInvestingActivities`	$-138.90M	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
Proceeds from short-term debt	`ProceedsFromOtherShortTermDebt`	$9.10M	USD	2 Qtrs
Proceeds from short-term debt	`ProceedsFromOtherShortTermDebt`	$3.30M	USD	2 Qtrs
Purchases of treasury stock	`PaymentsForRepurchaseOfCommonStock`	$1.01B	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`	$20.40M	USD	2 Qtrs
Net proceeds from employee stock plans	`ProceedsFromIssuanceOfSharesUnderIncentiveAndShareBasedCompensationPlansIncludingStockOptions`	$18.40M	USD	2 Qtrs
Net proceeds from employee stock plans	`ProceedsFromIssuanceOfSharesUnderIncentiveAndShareBasedCompensationPlansIncludingStockOptions`	$24.10M	USD	2 Qtrs
Net cash used by financing activities	`NetCashProvidedByUsedInFinancingActivities`	$-959.20M	USD	2 Qtrs
Net cash used by financing activities	`NetCashProvidedByUsedInFinancingActivities`	$-2.20B	USD	2 Qtrs
Net (decrease) increase in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$1.15B	USD	2 Qtrs
Net (decrease) increase in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$-1.34B	USD	2 Qtrs
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$2.09B	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$2.53B	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$938.40M	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$1.18B	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$2.09B	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$2.53B	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$938.40M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$1.18B	USD	Point-in-time

Stockholders Equity 28 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 amortization of prior service credit included in net periodic benefit cost	`OtherComprehensiveIncomeAmortizationOfDefinedBenefitPlanNetPriorServiceCostRecognizedInNetPeriodicPensionCostTax`	$800.00K	USD	2 Qtrs
Tax portion on net gains included in net periodic benefit cost	`OtherComprehensiveIncomeReclassificationOfDefinedBenefitPlansNetGainLossRecognizedInNetPeriodicBenefitCostTax`	$-500.00K	USD	2 Qtrs
Beginning Balances, value	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$6.39B	USD	Point-in-time
Beginning Balances, value	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$4.93B	USD	Point-in-time
Net income	`ProfitLoss`	$603.20M	USD	2 Qtrs
Net income	`ProfitLoss`	$677.40M	USD	2 Qtrs
Net income	`ProfitLoss`	$356.90M	USD	1 Quarter
Net income	`ProfitLoss`	$312.10M	USD	1 Quarter
Foreign currency translation loss	`OtherComprehensiveIncomeForeignCurrencyTransactionAndTranslationGainLossBeforeReclassificationAndTax`	$-17.60M	USD	2 Qtrs
Amortization of unrealized loss on cash flow hedge, net of tax of $(0.7)	`OtherComprehensiveIncomeReclassificationAdjustmentOnDerivativesIncludedInNetIncomeNetOfTax`	$1.10M	USD	2 Qtrs
Amortization of prior service credit included in net periodic benefit cost, net of tax of $0.8	`OtherComprehensiveIncomeAmortizationOfDefinedBenefitPlanNetPriorServiceCostRecognizedInNetPeriodicPensionCostNetOfTax`	$-1.20M	USD	2 Qtrs
Net gains included in net periodic benefit cost, net of tax of $(0.5)	`OtherComprehensiveIncomeReclassificationOfDefinedBenefitPlansNetGainLossRecognizedInNetPeriodicBenefitCostNetOfTax`	$800.00K	USD	2 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPeriodIncreaseDecrease`	$-16.90M	USD	2 Qtrs
Total comprehensive income (loss)	`ComprehensiveIncomeNetOfTaxIncludingPortionAttributableToNoncontrollingInterest`	$660.50M	USD	2 Qtrs
Stock option activity, including tax benefit, value	`StockOptionActivityIncludingTaxBenefitValue`	$113.40M	USD	2 Qtrs
Issuance of common stock under employee stock purchase plan, value	`StockIssuedDuringPeriodValueEmployeeStockPurchasePlan`	$10.90M	USD	2 Qtrs
Restricted stock unit activity, including tax benefit, value	`RestrictedStockUnitActivityIncludingTaxBenefitValue`	$11.20M	USD	2 Qtrs
Treasury stock acquired, value	`TreasuryStockValueAcquiredCostMethod`	$-2.26B	USD	2 Qtrs
Treasury stock acquired, value	`TreasuryStockValueAcquiredCostMethod`	$-9.20B	USD	19 Qtrs
Treasury stock acquired, shares	`TreasuryStockSharesAcquired`	18.30M	shares	1 Quarter
Treasury stock acquired, shares	`TreasuryStockSharesAcquired`	37.10M	shares	2 Qtrs
Treasury stock acquired, shares	`TreasuryStockSharesAcquired`	23.60M	shares	2 Qtrs
Treasury stock acquired, shares	`TreasuryStockSharesAcquired`	182.60M	shares	13 Qtrs
Treasury stock acquired, shares	`TreasuryStockSharesAcquired`	17.60M	shares	1 Quarter
Treasury stock acquired, shares	`TreasuryStockSharesAcquired`	223.30M	shares	19 Qtrs
Ending Balances, value	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$6.39B	USD	Point-in-time
Ending Balances, value	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$4.93B	USD	Point-in-time

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