UBmatrix Calculation Trace Report
Line Concept Weight Balance Decimals Precision Reported Calculated Source Message
1 Extended Link [ http://colgate.com/role/Statement/StatementOfIncome ]
2 Context c00002 [ 2008-01-01 - 2008-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss NA -6 [4] 1460000000 1,460,000,000 Instance OK
us-gaap:ProfitLoss 1.0 NA -6 [4] 1525000000 1,525,000,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -6 [4] 2242000000 2,242,000,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 NA -6 [4] 2324000000 2,324,000,000 Instance OK
us-gaap:GrossProfit 1.0 NA -6 [4] 6576000000 6,576,000,000 Instance OK
us-gaap:SalesRevenueNet 1.0 credit -6 [5] 11666000000 11,666,000,000 Instance
us-gaap:CostOfRevenue -1.0 debit -6 [4] 5090000000 5,090,000,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 debit -6 [4] 4187000000 4,187,000,000 Instance
cl:OtherIncomeExpenseNet -1.0 debit -6 [2] 65000000 65,000,000 Instance
cl:InterestExpenseNet -1.0 debit -6 [2] 82000000 82,000,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -6 [3] 717000000 717,000,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 debit -6 [2] 65000000 65,000,000 Instance
2 Context c00003 [ 2009-01-01 - 2009-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss NA -6 [4] 1660000000 1,660,000,000 Instance OK
us-gaap:ProfitLoss 1.0 NA -6 [4] 1741000000 1,741,000,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -6 [4] 2565000000 2,565,000,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 NA -6 [4] 2624000000 2,624,000,000 Instance OK
us-gaap:GrossProfit 1.0 NA -6 [4] 6581000000 6,581,000,000 Instance OK
us-gaap:SalesRevenueNet 1.0 credit -6 [5] 11246000000 11,246,000,000 Instance
us-gaap:CostOfRevenue -1.0 debit -6 [4] 4665000000 4,665,000,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 debit -6 [4] 3885000000 3,885,000,000 Instance
cl:OtherIncomeExpenseNet -1.0 debit -6 [2] 72000000 72,000,000 Instance
cl:InterestExpenseNet -1.0 debit -6 [2] 59000000 59,000,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -6 [3] 824000000 824,000,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 debit -6 [2] 81000000 81,000,000 Instance
2 Context c00007 [ 2008-07-01 - 2008-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss NA -6 [3] 500000000 500,000,000 Instance OK
us-gaap:ProfitLoss 1.0 NA -6 [3] 522000000 522,000,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -6 [3] 768000000 768,000,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 NA -6 [3] 791000000 791,000,000 Instance OK
us-gaap:GrossProfit 1.0 NA -6 [4] 2236000000 2,236,000,000 Instance OK
us-gaap:SalesRevenueNet 1.0 credit -6 [4] 3988000000 3,988,000,000 Instance
us-gaap:CostOfRevenue -1.0 debit -6 [4] 1752000000 1,752,000,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 debit -6 [4] 1415000000 1,415,000,000 Instance
cl:OtherIncomeExpenseNet -1.0 debit -6 [2] 30000000 30,000,000 Instance
cl:InterestExpenseNet -1.0 debit -6 [2] 23000000 23,000,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -6 [3] 246000000 246,000,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 debit -6 [2] 22000000 22,000,000 Instance
2 Context c00008 [ 2009-07-01 - 2009-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss NA -6 [3] 590000000 590,000,000 Instance OK
us-gaap:ProfitLoss 1.0 NA -6 [3] 617000000 617,000,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 NA -6 [3] 909000000 909,000,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 NA -6 [3] 926000000 926,000,000 Instance OK
us-gaap:GrossProfit 1.0 NA -6 [4] 2367000000 2,367,000,000 Instance OK
us-gaap:SalesRevenueNet 1.0 credit -6 [4] 3998000000 3,998,000,000 Instance
us-gaap:CostOfRevenue -1.0 debit -6 [4] 1631000000 1,631,000,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 debit -6 [4] 1403000000 1,403,000,000 Instance
cl:OtherIncomeExpenseNet -1.0 debit -6 [2] 38000000 38,000,000 Instance
cl:InterestExpenseNet -1.0 debit -6 [2] 17000000 17,000,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 debit -6 [3] 292000000 292,000,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 debit -6 [2] 27000000 27,000,000 Instance


1 Extended Link [ http://colgate.com/role/Statement/StatementOfFinancialPositionClassified ]
2 Context c00004 [ 2008-12-31 - ]
c-equal
3 Unit u000
u-equal
us-gaap:Assets NA -6 [4] 9979000000 9,979,000,000 Instance OK
us-gaap:AssetsCurrent 1.0 NA -6 [4] 3710000000 3,710,000,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 debit -6 [3] 555000000 555,000,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 debit -6 [4] 1592000000 1,592,000,000 Instance
us-gaap:InventoryNet 1.0 debit -6 [4] 1197000000 1,197,000,000 Instance
us-gaap:OtherAssetsCurrent 1.0 debit -6 [3] 366000000 366,000,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 NA -6 [4] 3119000000 3,119,000,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 debit -6 [4] 5937000000 5,937,000,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 credit -6 [4] 2818000000 2,818,000,000 Instance
us-gaap:Goodwill 1.0 debit -6 [4] 2152000000 2,152,000,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 debit -6 [3] 834000000 834,000,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 debit -6 [3] 164000000 164,000,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity NA -6 [4] 9979000000 9,979,000,000 Instance OK
us-gaap:LiabilitiesCurrent 1.0 NA -6 [4] 2952000000 2,952,000,000 Instance OK
us-gaap:ShortTermBankLoansAndNotesPayable 1.0 credit -6 [3] 107000000 107,000,000 Instance
us-gaap:LongTermDebtCurrent 1.0 credit -6 [2] 91000000 91,000,000 Instance
us-gaap:AccountsPayableCurrent 1.0 credit -6 [4] 1061000000 1,061,000,000 Instance
us-gaap:AccruedIncomeTaxesCurrent 1.0 credit -6 [3] 272000000 272,000,000 Instance
us-gaap:OtherAccruedLiabilitiesCurrent 1.0 credit -6 [4] 1421000000 1,421,000,000 Instance
us-gaap:LongTermDebtAndCapitalLeaseObligations 1.0 credit -6 [4] 3585000000 3,585,000,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 credit -6 [2] 82000000 82,000,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 credit -6 [4] 1316000000 1,316,000,000 Instance
us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest 1.0 NA -6 [4] 2044000000 2,044,000,000 Instance OK
us-gaap:StockholdersEquity 1.0 NA -6 [4] 1923000000 1,923,000,000 Instance OK
us-gaap:PreferredStockValue 1.0 credit -6 [3] 181000000 181,000,000 Instance
us-gaap:CommonStockValue 1.0 credit -6 [3] 733000000 733,000,000 Instance
us-gaap:AdditionalPaidInCapital 1.0 credit -6 [4] 1610000000 1,610,000,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 credit -6 [5] 11760000000 11,760,000,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 credit -6 [4] -2477000000 -2,477,000,000 Instance
us-gaap:UnearnedESOPShares -1.0 debit -6 [3] 187000000 187,000,000 Instance
us-gaap:TreasuryStockValue -1.0 debit -6 [4] 9697000000 9,697,000,000 Instance
us-gaap:MinorityInterest 1.0 credit -6 [3] 121000000 121,000,000 Instance
2 Context c00005 [ 2009-09-30 - ]
c-equal
3 Unit u000
u-equal
us-gaap:Assets NA -6 [5] 11067000000 11,067,000,000 Instance OK
us-gaap:AssetsCurrent 1.0 NA -6 [4] 4204000000 4,204,000,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 debit -6 [3] 847000000 847,000,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 debit -6 [4] 1780000000 1,780,000,000 Instance
us-gaap:InventoryNet 1.0 debit -6 [4] 1241000000 1,241,000,000 Instance
us-gaap:OtherAssetsCurrent 1.0 debit -6 [3] 336000000 336,000,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 NA -6 [4] 3351000000 3,351,000,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 debit -6 [4] 6466000000 6,466,000,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 credit -6 [4] 3115000000 3,115,000,000 Instance
us-gaap:Goodwill 1.0 debit -6 [4] 2296000000 2,296,000,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 debit -6 [3] 826000000 826,000,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 debit -6 [3] 390000000 390,000,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity NA -6 [5] 11067000000 11,067,000,000 Instance OK
us-gaap:LiabilitiesCurrent 1.0 NA -6 [4] 3591000000 3,591,000,000 Instance OK
us-gaap:ShortTermBankLoansAndNotesPayable 1.0 credit -6 [2] 62000000 62,000,000 Instance
us-gaap:LongTermDebtCurrent 1.0 credit -6 [3] 318000000 318,000,000 Instance
us-gaap:AccountsPayableCurrent 1.0 credit -6 [4] 1084000000 1,084,000,000 Instance
us-gaap:AccruedIncomeTaxesCurrent 1.0 credit -6 [3] 289000000 289,000,000 Instance
us-gaap:OtherAccruedLiabilitiesCurrent 1.0 credit -6 [4] 1838000000 1,838,000,000 Instance
us-gaap:LongTermDebtAndCapitalLeaseObligations 1.0 credit -6 [4] 2883000000 2,883,000,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 credit -6 [3] 125000000 125,000,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 credit -6 [4] 1357000000 1,357,000,000 Instance
us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest 1.0 NA -6 [4] 3111000000 3,111,000,000 Instance OK
us-gaap:StockholdersEquity 1.0 NA -6 [4] 2952000000 2,952,000,000 Instance OK
us-gaap:PreferredStockValue 1.0 credit -6 [3] 171000000 171,000,000 Instance
us-gaap:CommonStockValue 1.0 credit -6 [3] 733000000 733,000,000 Instance
us-gaap:AdditionalPaidInCapital 1.0 credit -6 [4] 1694000000 1,694,000,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 credit -6 [5] 12761000000 12,761,000,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 credit -6 [4] -2125000000 -2,125,000,000 Instance
us-gaap:UnearnedESOPShares -1.0 debit -6 [3] 139000000 139,000,000 Instance
us-gaap:TreasuryStockValue -1.0 debit -6 [5] 10143000000 10,143,000,000 Instance
us-gaap:MinorityInterest 1.0 credit -6 [3] 159000000 159,000,000 Instance


1 Extended Link [ http://colgate.com/role/Statement/StatementOfCashFlowsIndirect ]
2 Context c00002 [ 2008-01-01 - 2008-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease NA -6 [3] 206000000 206,000,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 NA -6 [4] 1777000000 1,777,000,000 Instance OK
us-gaap:NetIncomeLoss 1.0 credit -6 [4] 1460000000 1,460,000,000 Instance
cl:RestructuringNetOfCash 1.0 debit -6 [2] -36000000 -36,000,000 Instance
us-gaap:DepreciationDepletionAndAmortization 1.0 debit -6 [3] 261000000 261,000,000 Instance
cl:StockBasedCompensationExpense 1.0 debit -6 [2] 82000000 82,000,000 Instance
us-gaap:DeferredIncomeTaxesAndTaxCredits 1.0 debit -6 [2] 38000000 38,000,000 Instance
us-gaap:IncreaseDecreaseInReceivables 1.0 credit -6 [3] -132000000 -132,000,000 Instance
us-gaap:IncreaseDecreaseInInventories 1.0 credit -6 [3] -176000000 -176,000,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 1.0 debit -6 [3] 162000000 162,000,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingCapitalNet 1.0 credit -6 [3] 118000000 118,000,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 NA -6 [3] -341000000 -341,000,000 Instance OK
us-gaap:PaymentsToAcquireProductiveAssets -1.0 credit -6 [3] 392000000 392,000,000 Instance
cl:SalePurchasesOfMarketableSecuritiesAndInvestments 1.0 debit -6 [1] 1000000 1,000,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 credit -6 [2] -50000000 -50,000,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 NA -6 [4] -1213000000 -1,213,000,000 Instance OK
cl:PrincipalPaymentsOnDebt 1.0 debit -6 [4] -1424000000 -1,424,000,000 Instance
cl:ProceedsFromIssuanceOfDebt -1.0 credit -6 [4] -1447000000 -1,447,000,000 Instance
cl:DividendsPaid 1.0 -6 [3] -627000000 -627,000,000 Instance
us-gaap:PaymentsForRepurchaseOfCommonStock -1.0 credit -6 [3] 833000000 833,000,000 Instance
cl:ProceedsFromExerciseOfStockOptionsAndExcessTaxBenefits -1.0 credit -6 [3] -224000000 -224,000,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 debit -6 [2] -17000000 -17,000,000 Instance
2 Context c00003 [ 2009-01-01 - 2009-09-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease NA -6 [3] 292000000 292,000,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 NA -6 [4] 2375000000 2,375,000,000 Instance OK
us-gaap:NetIncomeLoss 1.0 credit -6 [4] 1660000000 1,660,000,000 Instance
cl:RestructuringNetOfCash 1.0 debit -6 [2] -14000000 -14,000,000 Instance
us-gaap:DepreciationDepletionAndAmortization 1.0 debit -6 [3] 262000000 262,000,000 Instance
cl:StockBasedCompensationExpense 1.0 debit -6 [2] 97000000 97,000,000 Instance
us-gaap:DeferredIncomeTaxesAndTaxCredits 1.0 debit -6 [2] 16000000 16,000,000 Instance
us-gaap:IncreaseDecreaseInReceivables 1.0 credit -6 [3] -104000000 -104,000,000 Instance
us-gaap:IncreaseDecreaseInInventories 1.0 credit -6 [2] 10000000 10,000,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 1.0 debit -6 [3] 355000000 355,000,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingCapitalNet 1.0 credit -6 [2] 93000000 93,000,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 NA -6 [3] -484000000 -484,000,000 Instance OK
us-gaap:PaymentsToAcquireProductiveAssets -1.0 credit -6 [3] 347000000 347,000,000 Instance
cl:SalePurchasesOfMarketableSecuritiesAndInvestments 1.0 debit -6 [3] -147000000 -147,000,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 credit -6 [2] -10000000 -10,000,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 NA -6 [4] -1620000000 -1,620,000,000 Instance OK
cl:PrincipalPaymentsOnDebt 1.0 debit -6 [4] -3011000000 -3,011,000,000 Instance
cl:ProceedsFromIssuanceOfDebt -1.0 credit -6 [4] -2561000000 -2,561,000,000 Instance
cl:DividendsPaid 1.0 -6 [3] -702000000 -702,000,000 Instance
us-gaap:PaymentsForRepurchaseOfCommonStock -1.0 credit -6 [3] 664000000 664,000,000 Instance
cl:ProceedsFromExerciseOfStockOptionsAndExcessTaxBenefits -1.0 credit -6 [3] -196000000 -196,000,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 debit -6 [2] 21000000 21,000,000 Instance


Copyright (c) UBmatrix, Inc. 2009