UBmatrix Calculation Trace Report
Line Concept Weight Decimals Precision Reported Calculated Source Message
1 Extended Link [ http://www.lilly.com/role/StatementConsolidatedCondensedBalanceSheets ]
2 Context As_Of_6_30_2009 [ 2009-06-30 - ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:Assets -5 [6] 26931500000 26,931,500,000 Instance OK
us-gaap:AssetsCurrent 1.0 -5 [6] 10935300000 10,935,300,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 -5 [5] 3322300000 3,322,300,000 Instance
us-gaap:ShortTermInvestments 1.0 -5 [4] 168100000 168,100,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 -5 [5] 2841300000 2,841,300,000 Instance
us-gaap:NotesAndLoansReceivableGrossCurrent 1.0 -5 [4] 488600000 488,600,000 Instance
us-gaap:InventoryNet 1.0 -5 [5] 2999700000 2,999,700,000 Instance
us-gaap:PrepaidExpenseCurrent 1.0 -5 [4] 824700000 824,700,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 -5 [4] 290600000 290,600,000 Instance
us-gaap:AssetsNoncurrent 1.0 -5 [5] 7401900000 7,401,900,000 Instance OK
us-gaap:LongTermInvestments 1.0 -5 [5] 1239000000 1,239,000,000 Instance
lly:GoodwillAndOtherIntangiblesNet 1.0 -5 [5] 3790300000 3,790,300,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 -5 [5] 2372600000 2,372,600,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 -5 [5] 8594300000 8,594,300,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -5 [6] 15215700000 15,215,700,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -5 [5] 6621400000 6,621,400,000 Instance
us-gaap:LiabilitiesCurrent -5 [5] 6989300000 6,989,300,000 Instance OK
us-gaap:TaxesPayableCurrent 1.0 -5 [4] 342800000 342,800,000 Instance
us-gaap:EmployeeRelatedLiabilitiesCurrent 1.0 -5 [4] 569000000 569,000,000 Instance
us-gaap:AccountsPayableCurrent 1.0 -5 [4] 918600000 918,600,000 Instance
lly:SalesRebatesAndDiscounts 1.0 -5 [4] 951000000 951,000,000 Instance
us-gaap:DividendsPayableCurrent 1.0 -5 [4] 538000000 538,000,000 Instance
us-gaap:ShortTermBorrowings 1.0 -5 [5] 1034900000 1,034,900,000 Instance
us-gaap:OtherLiabilitiesCurrent 1.0 -5 [5] 2635000000 2,635,000,000 Instance
us-gaap:LiabilitiesNoncurrent -5 [6] 11382200000 11,382,200,000 Instance OK
us-gaap:AccruedIncomeTaxesNoncurrent 1.0 -5 [4] 969600000 969,600,000 Instance
us-gaap:LongTermDebtNoncurrent 1.0 -5 [5] 6688000000 6,688,000,000 Instance
us-gaap:PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent 1.0 -5 [5] 2314200000 2,314,200,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 -5 [3] 79400000 79,400,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 -5 [5] 1331000000 1,331,000,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -5 [6] 26931500000 8,560,000,000 Instance Inconsistency found, calculated value is 8,560,000,000
us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest 1.0 -5 [5] 8560000000 8,560,000,000 Instance OK
us-gaap:TreasuryStockValue -1.0 -5 [3] 98500000 98,500,000 Instance
lly:ShareholdersEquityIncludingTreasuryShares 1.0 -5 [5] 8658500000 11,672,000,000 Instance Inconsistency found, calculated value is 11,672,000,000
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -5 [5] 9049500000 9,049,500,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -5 [5] -2466800000 -2,466,800,000 Instance
us-gaap:TreasuryStockDeferredEmployeeStockOwnershipPlan 1.0 -5 [3] -82000000 -82,000,000 Instance
us-gaap:AdditionalPaidInCapitalCommonStock 1.0 -5 [5] 4455400000 4,455,400,000 Instance
us-gaap:CommonStockValue 1.0 -5 [4] 718700000 718,700,000 Instance
us-gaap:MinorityInterest 1.0 -5 [2] -3100000 -3,100,000 Instance
2 Context As_Of_12_31_2008 [ 2008-12-31 - ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:Assets -5 [6] 29212600000 29,212,600,000 Instance OK
us-gaap:AssetsCurrent 1.0 -5 [6] 12453300000 12,453,300,000 Instance OK
us-gaap:CashAndCashEquivalentsAtCarryingValue 1.0 -5 [5] 5496700000 5,496,700,000 Instance
us-gaap:ShortTermInvestments 1.0 -5 [4] 429400000 429,400,000 Instance
us-gaap:AccountsReceivableNetCurrent 1.0 -5 [5] 2778800000 2,778,800,000 Instance
us-gaap:NotesAndLoansReceivableGrossCurrent 1.0 -5 [4] 498500000 498,500,000 Instance
us-gaap:InventoryNet 1.0 -5 [5] 2493200000 2,493,200,000 Instance
us-gaap:PrepaidExpenseCurrent 1.0 -5 [4] 374600000 374,600,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 -5 [4] 382100000 382,100,000 Instance
us-gaap:AssetsNoncurrent 1.0 -5 [5] 8133000000 8,133,000,000 Instance OK
us-gaap:LongTermInvestments 1.0 -5 [5] 1544600000 1,544,600,000 Instance
lly:GoodwillAndOtherIntangiblesNet 1.0 -5 [5] 3929100000 3,929,100,000 Instance
us-gaap:OtherAssetsNoncurrent 1.0 -5 [5] 2659300000 2,659,300,000 Instance
us-gaap:PropertyPlantAndEquipmentNet 1.0 -5 [5] 8626300000 8,626,300,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -5 [6] 15315900000 15,315,900,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -5 [5] 6689600000 6,689,600,000 Instance
us-gaap:LiabilitiesCurrent -5 [6] 13109700000 13,109,700,000 Instance OK
us-gaap:TaxesPayableCurrent 1.0 -5 [4] 229200000 229,200,000 Instance
us-gaap:EmployeeRelatedLiabilitiesCurrent 1.0 -5 [4] 771000000 771,000,000 Instance
us-gaap:AccountsPayableCurrent 1.0 -5 [4] 885800000 885,800,000 Instance
lly:SalesRebatesAndDiscounts 1.0 -5 [4] 873400000 873,400,000 Instance
us-gaap:DividendsPayableCurrent 1.0 -5 [4] 536800000 536,800,000 Instance
us-gaap:ShortTermBorrowings 1.0 -5 [5] 5846300000 5,846,300,000 Instance
us-gaap:OtherLiabilitiesCurrent 1.0 -5 [5] 3967200000 3,967,200,000 Instance
us-gaap:LiabilitiesNoncurrent -5 [5] 9365200000 9,365,200,000 Instance OK
us-gaap:AccruedIncomeTaxesNoncurrent 1.0 -5 [4] 906200000 906,200,000 Instance
us-gaap:LongTermDebtNoncurrent 1.0 -5 [5] 4615700000 4,615,700,000 Instance
us-gaap:PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent 1.0 -5 [5] 2387600000 2,387,600,000 Instance
us-gaap:DeferredTaxLiabilitiesNoncurrent 1.0 -5 [3] 74700000 74,700,000 Instance
us-gaap:OtherLiabilitiesNoncurrent 1.0 -5 [5] 1381000000 1,381,000,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -5 [6] 29212600000 6,737,700,000 Instance Inconsistency found, calculated value is 6,737,700,000
us-gaap:StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest 1.0 -5 [5] 6737700000 6,737,700,000 Instance OK
us-gaap:TreasuryStockValue -1.0 -5 [3] 99200000 99,200,000 Instance
lly:ShareholdersEquityIncludingTreasuryShares 1.0 -5 [5] 6836900000 9,471,900,000 Instance Inconsistency found, calculated value is 9,471,900,000
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -5 [5] 7654900000 7,654,900,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -5 [5] -2786800000 -2,786,800,000 Instance
us-gaap:TreasuryStockDeferredEmployeeStockOwnershipPlan 1.0 -5 [3] -86300000 -86,300,000 Instance
us-gaap:AdditionalPaidInCapitalCommonStock 1.0 -5 [5] 3976600000 3,976,600,000 Instance
us-gaap:CommonStockValue 1.0 -5 [4] 711100000 711,100,000 Instance
us-gaap:MinorityInterest 1.0 -5 [2] 2400000 2,400,000 Instance


1 Extended Link [ http://www.lilly.com/role/StatementConsolidatedCondensedStatementsOfCashFlows ]
2 Context Duration_1_1_2008_To_6_30_2008 [ 2008-01-01 - 2008-06-30 ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease -5 [4] -352200000 -352,200,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 -5 [5] 2783500000 2,783,500,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 -5 [5] -1874100000 -1,874,100,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 -5 [5] -1385400000 -1,385,400,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 -5 [4] 123800000 123,800,000 Instance
2 Context Duration_1_1_2009_To_6_30_2009 [ 2009-01-01 - 2009-06-30 ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease -5 [5] -2174400000 -2,174,400,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 -5 [5] 1011200000 1,011,200,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 -5 [4] 329400000 329,400,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 -5 [5] -3492000000 -3,492,000,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 -5 [3] -23000000 -23,000,000 Instance


1 Extended Link [ http://www.lilly.com/role/StatementConsolidatedCondensedStatementsOfIncome ]
2 Context Duration_4_1_2009_To_6_30_2009 [ 2009-04-01 - 2009-06-30 ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:NetIncomeLoss -5 [5] 1158500000 1,158,500,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [5] 1467700000 1,467,700,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 309200000 309,200,000 Instance
2 Context Duration_4_1_2008_To_6_30_2008 [ 2008-04-01 - 2008-06-30 ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:NetIncomeLoss -5 [4] 958800000 958,800,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [5] 1206300000 1,206,300,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 247500000 247,500,000 Instance
2 Context Duration_1_1_2008_To_6_30_2008 [ 2008-01-01 - 2008-06-30 ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:NetIncomeLoss -5 [5] 2023100000 2,023,100,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [5] 2262600000 2,262,600,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 239500000 239,500,000 Instance
2 Context Duration_1_1_2009_To_6_30_2009 [ 2009-01-01 - 2009-06-30 ]
c-equal
3 Unit Unit_12
u-equal
us-gaap:NetIncomeLoss -5 [5] 2471600000 2,471,600,000 Instance OK
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments 1.0 -5 [5] 3151100000 3,151,100,000 Instance
us-gaap:IncomeTaxExpenseBenefit -1.0 -5 [4] 679500000 679,500,000 Instance


Copyright (c) UBmatrix, Inc. 2009