UBmatrix Calculation Trace Report
Line Concept Weight Decimals Precision Reported Calculated Source Message
1 Extended Link [ http://colgate.com/role/Statement/StatementOfIncome ]
2 Context c00002 [ 2008-01-01 - 2008-06-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss -5 [4] 960300000 960,300,000 Instance OK
us-gaap:ProfitLoss 1.0 -5 [5] 1003700000 1,003,700,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [5] 1475000000 1,475,000,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 -5 [5] 1534100000 1,534,100,000 Instance OK
us-gaap:GrossProfit 1.0 -5 [5] 4339600000 4,339,600,000 Instance OK
us-gaap:SalesRevenueNet 1.0 -5 [5] 7677800000 7,677,800,000 Instance
us-gaap:CostOfRevenue -1.0 -5 [5] 3338200000 3,338,200,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 -5 [5] 2771600000 2,771,600,000 Instance
cl:OtherIncomeExpenseNet -1.0 -5 [3] 33900000 33,900,000 Instance
cl:InterestExpenseNet -1.0 -5 [3] 59100000 59,100,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 471300000 471,300,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 -5 [3] 43400000 43,400,000 Instance
2 Context c00003 [ 2008-04-01 - 2008-06-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss -5 [4] 493800000 493,800,000 Instance OK
us-gaap:ProfitLoss 1.0 -5 [4] 515200000 515,200,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [4] 763000000 763,000,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 -5 [4] 788400000 788,400,000 Instance OK
us-gaap:GrossProfit 1.0 -5 [5] 2239800000 2,239,800,000 Instance OK
us-gaap:SalesRevenueNet 1.0 -5 [5] 3964800000 3,964,800,000 Instance
us-gaap:CostOfRevenue -1.0 -5 [5] 1725000000 1,725,000,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 -5 [5] 1422700000 1,422,700,000 Instance
cl:OtherIncomeExpenseNet -1.0 -5 [3] 28700000 28,700,000 Instance
cl:InterestExpenseNet -1.0 -5 [3] 25400000 25,400,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 247800000 247,800,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 -5 [3] 21400000 21,400,000 Instance
2 Context c00004 [ 2009-01-01 - 2009-06-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss -5 [5] 1069500000 1,069,500,000 Instance OK
us-gaap:ProfitLoss 1.0 -5 [5] 1124300000 1,124,300,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [5] 1655800000 1,655,800,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 -5 [5] 1698500000 1,698,500,000 Instance OK
us-gaap:GrossProfit 1.0 -5 [5] 4213600000 4,213,600,000 Instance OK
us-gaap:SalesRevenueNet 1.0 -5 [5] 7247800000 7,247,800,000 Instance
us-gaap:CostOfRevenue -1.0 -5 [5] 3034200000 3,034,200,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 -5 [5] 2481400000 2,481,400,000 Instance
cl:OtherIncomeExpenseNet -1.0 -5 [3] 33700000 33,700,000 Instance
cl:InterestExpenseNet -1.0 -5 [3] 42700000 42,700,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 531500000 531,500,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 -5 [3] 54800000 54,800,000 Instance
2 Context c00005 [ 2009-04-01 - 2009-06-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:NetIncomeLoss -5 [4] 561600000 561,600,000 Instance OK
us-gaap:ProfitLoss 1.0 -5 [4] 587800000 587,800,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [4] 865600000 865,600,000 Instance OK
us-gaap:OperatingIncomeLoss 1.0 -5 [4] 887100000 887,100,000 Instance OK
us-gaap:GrossProfit 1.0 -5 [5] 2201200000 2,201,200,000 Instance OK
us-gaap:SalesRevenueNet 1.0 -5 [5] 3745000000 3,745,000,000 Instance
us-gaap:CostOfRevenue -1.0 -5 [5] 1543800000 1,543,800,000 Instance
us-gaap:SellingGeneralAndAdministrativeExpense -1.0 -5 [5] 1295700000 1,295,700,000 Instance
cl:OtherIncomeExpenseNet -1.0 -5 [3] 18400000 18,400,000 Instance
cl:InterestExpenseNet -1.0 -5 [3] 21500000 21,500,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 277800000 277,800,000 Instance
us-gaap:NetIncomeLossAttributableToNoncontrollingInterest -1.0 -5 [3] 26200000 26,200,000 Instance


1 Extended Link [ http://colgate.com/role/Statement/StatementOfFinancialPositionClassified ]
2 Context c00000 [ 2008-12-31 - ]
c-equal
3 Unit u000
u-equal
us-gaap:Assets -5 [5] 9979300000 9,979,300,000 Instance OK
us-gaap:AssetsCurrent 1.0 -5 [5] 3710000000 3,710,000,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 -5 [4] 554900000 554,900,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 -5 [5] 1591900000 1,591,900,000 Instance
us-gaap:InventoryNet 1.0 -5 [5] 1197100000 1,197,100,000 Instance
us-gaap:OtherAssetsCurrent 1.0 -5 [4] 366100000 366,100,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 -5 [5] 3119500000 3,119,500,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -5 [5] 5937100000 5,937,100,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -5 [5] 2817600000 2,817,600,000 Instance
us-gaap:Goodwill 1.0 -5 [5] 2152000000 2,152,000,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 -5 [4] 833500000 833,500,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 -5 [4] 164300000 164,300,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -5 [5] 9979300000 9,979,300,000 Instance OK
us-gaap:LiabilitiesCurrent 1.0 -5 [5] 2953300000 2,953,300,000 Instance OK
us-gaap:ShortTermBankLoansAndNotesPayable 1.0 -5 [4] 107200000 107,200,000 Instance
us-gaap:LongTermDebtCurrent 1.0 -5 [3] 91000000 91,000,000 Instance
us-gaap:AccountsPayableCurrent 1.0 -5 [5] 1061400000 1,061,400,000 Instance
us-gaap:AccruedIncomeTaxesCurrent 1.0 -5 [4] 272400000 272,400,000 Instance
us-gaap:OtherAccruedLiabilitiesCurrent 1.0 -5 [5] 1421300000 1,421,300,000 Instance
us-gaap:LongTermDebtAndCapitalLeaseObligations 1.0 -5 [5] 3585300000 3,585,300,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 -5 [3] 81900000 81,900,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 -5 [5] 1315500000 1,315,500,000 Instance
us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest 1.0 -5 [5] 2043300000 2,043,300,000 Instance OK
us-gaap:StockholdersEquity 1.0 -5 [5] 1922100000 1,922,100,000 Instance OK
us-gaap:PreferredStockValue 1.0 -5 [4] 181000000 181,000,000 Instance
us-gaap:CommonStockValue 1.0 -5 [4] 732900000 732,900,000 Instance
us-gaap:AdditionalPaidInCapital 1.0 -5 [5] 1609700000 1,609,700,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -5 [6] 11759500000 11,759,500,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -5 [5] -2477300000 -2,477,300,000 Instance
us-gaap:UnearnedESOPShares -1.0 -5 [4] 187000000 187,000,000 Instance
us-gaap:TreasuryStockValue -1.0 -5 [5] 9696700000 9,696,700,000 Instance
us-gaap:MinorityInterest 1.0 -5 [4] 121200000 121,200,000 Instance
2 Context c00006 [ 2009-06-30 - ]
c-equal c00009 ,
3 Unit u000
u-equal
us-gaap:Assets -5 [6] 10730100000 10,730,100,000 Instance OK
us-gaap:AssetsCurrent 1.0 -5 [5] 4217800000 4,217,800,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 -5 [4] 896000000 896,000,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 -5 [5] 1727800000 1,727,800,000 Instance
us-gaap:InventoryNet 1.0 -5 [5] 1223800000 1,223,800,000 Instance
us-gaap:OtherAssetsCurrent 1.0 -5 [4] 370200000 370,200,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 -5 [5] 3245400000 3,245,400,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -5 [5] 6251600000 6,251,600,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -5 [5] 3006200000 3,006,200,000 Instance
us-gaap:Goodwill 1.0 -5 [5] 2209100000 2,209,100,000 Instance
us-gaap:IntangibleAssetsNetExcludingGoodwill 1.0 -5 [4] 818200000 818,200,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 -5 [4] 239600000 239,600,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -5 [6] 10730100000 10,730,100,000 Instance OK
us-gaap:LiabilitiesCurrent 1.0 -5 [5] 3240200000 3,240,200,000 Instance OK
us-gaap:ShortTermBankLoansAndNotesPayable 1.0 -5 [3] 86500000 86,500,000 Instance
us-gaap:LongTermDebtCurrent 1.0 -5 [4] 347400000 347,400,000 Instance
us-gaap:AccountsPayableCurrent 1.0 -5 [5] 1038000000 1,038,000,000 Instance
us-gaap:AccruedIncomeTaxesCurrent 1.0 -5 [4] 254500000 254,500,000 Instance
us-gaap:OtherAccruedLiabilitiesCurrent 1.0 -5 [5] 1513800000 1,513,800,000 Instance
us-gaap:LongTermDebtAndCapitalLeaseObligations 1.0 -5 [5] 3367900000 3,367,900,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 -5 [4] 127900000 127,900,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 -5 [5] 1295100000 1,295,100,000 Instance
us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest 1.0 -5 [5] 2699000000 2,699,000,000 Instance OK
us-gaap:StockholdersEquity 1.0 -5 [5] 2540300000 2,540,300,000 Instance OK
us-gaap:PreferredStockValue 1.0 -5 [4] 173900000 173,900,000 Instance
us-gaap:CommonStockValue 1.0 -5 [4] 732900000 732,900,000 Instance
us-gaap:AdditionalPaidInCapital 1.0 -5 [5] 1643800000 1,643,800,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -5 [6] 12392400000 12,392,400,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -5 [5] -2277700000 -2,277,700,000 Instance
us-gaap:UnearnedESOPShares -1.0 -5 [4] 160900000 160,900,000 Instance
us-gaap:TreasuryStockValue -1.0 -5 [5] 9964100000 9,964,100,000 Instance
us-gaap:MinorityInterest 1.0 -5 [4] 158700000 158,700,000 Instance


1 Extended Link [ http://colgate.com/role/Statement/StatementOfCashFlowsIndirect ]
2 Context c00002 [ 2008-01-01 - 2008-06-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease -5 [4] 194100000 194,100,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 -5 [5] 1036400000 1,036,400,000 Instance OK
us-gaap:NetIncomeLoss 1.0 -5 [4] 960300000 960,300,000 Instance
cl:RestructuringNetOfCash 1.0 -5 [3] -47100000 -47,100,000 Instance
us-gaap:DepreciationDepletionAndAmortization 1.0 -5 [4] 172400000 172,400,000 Instance
cl:StockBasedCompensationExpense 1.0 -5 [3] 42700000 42,700,000 Instance
us-gaap:DeferredIncomeTaxesAndTaxCredits 1.0 -5 [3] 67000000 67,000,000 Instance
us-gaap:IncreaseDecreaseInReceivables 1.0 -5 [4] -132500000 -132,500,000 Instance
us-gaap:IncreaseDecreaseInInventories 1.0 -5 [4] -135200000 -135,200,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 1.0 -5 [3] 59800000 59,800,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingCapitalNet 1.0 -5 [3] 49000000 49,000,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 -5 [4] -171000000 171,000,000 Instance Inconsistency found, calculated value is 171,000,000
us-gaap:PaymentsToAcquireProductiveAssets -1.0 -5 [4] -216700000 -216,700,000 Instance
cl:SaleOfPropertyAndNonCoreProductLines -1.0 -5 [3] 44900000 44,900,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 -5 [1] 800000 800,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 -5 [4] -672500000 -672,500,000 Instance OK
cl:PrincipalPaymentsOnDebt 1.0 -5 [5] -1380800000 -1,380,800,000 Instance
cl:ProceedsFromIssuanceOfDebt -1.0 -5 [5] -1542900000 -1,542,900,000 Instance
cl:Dividendspaid 1.0 -5 [4] -409700000 -409,700,000 Instance
us-gaap:PaymentsForRepurchaseOfCommonStock -1.0 -5 [4] 542000000 542,000,000 Instance
cl:ProceedsFromExerciseOfStockOptionsAndExcessTaxBenefits -1.0 -5 [4] -117100000 -117,100,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 -5 [2] 1200000 1,200,000 Instance
2 Context c00004 [ 2009-01-01 - 2009-06-30 ]
c-equal
3 Unit u000
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease -5 [4] 341100000 341,100,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 -5 [5] 1210700000 1,210,700,000 Instance OK
us-gaap:NetIncomeLoss 1.0 -5 [5] 1069500000 1,069,500,000 Instance
cl:RestructuringNetOfCash 1.0 -5 [2] -9000000 -9,000,000 Instance
us-gaap:DepreciationDepletionAndAmortization 1.0 -5 [4] 172100000 172,100,000 Instance
cl:StockBasedCompensationExpense 1.0 -5 [3] 55700000 55,700,000 Instance
us-gaap:DeferredIncomeTaxesAndTaxCredits 1.0 -5 [3] 33900000 33,900,000 Instance
us-gaap:IncreaseDecreaseInReceivables 1.0 -5 [3] -86100000 -86,100,000 Instance
us-gaap:IncreaseDecreaseInInventories 1.0 -5 [2] 1800000 1,800,000 Instance
us-gaap:IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 1.0 -5 [3] -61600000 -61,600,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingCapitalNet 1.0 -5 [3] 34400000 34,400,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 -5 [4] -216700000 216,700,000 Instance Inconsistency found, calculated value is 216,700,000
us-gaap:PaymentsToAcquireProductiveAssets -1.0 -5 [4] -210100000 -210,100,000 Instance
cl:SaleOfPropertyAndNonCoreProductLines -1.0 -5 [3] 12400000 12,400,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 -5 [3] -19000000 -19,000,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 -5 [4] -664800000 -664,800,000 Instance OK
cl:PrincipalPaymentsOnDebt 1.0 -5 [5] -1514900000 -1,514,900,000 Instance
cl:ProceedsFromIssuanceOfDebt -1.0 -5 [5] -1607800000 -1,607,800,000 Instance
cl:Dividendspaid 1.0 -5 [4] -454100000 -454,100,000 Instance
us-gaap:PaymentsForRepurchaseOfCommonStock -1.0 -5 [4] 395700000 395,700,000 Instance
cl:ProceedsFromExerciseOfStockOptionsAndExcessTaxBenefits -1.0 -5 [3] -92100000 -92,100,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 -5 [3] 11900000 11,900,000 Instance


Copyright (c) UBmatrix, Inc. 2009