10-Q Filing

ELI LILLY & CO CIK: 59478 Q1 2023

Filing Information

Form Type	10-Q
Accession Number	`0000059478-23-000162`
Period End Date	20230331
Filing Date	20230427
Fiscal Year	2023
Fiscal Period	Q1
XBRL Instance	lly-20230331_htm.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 80 Income Statement 28 Cash Flow Statement 60 Stockholders Equity 8 Comprehensive Income 6

Balance Sheet 80 line items

Line Item	Tag	Value	Unit	Period
Accounts receivable, allowances	`AllowanceForDoubtfulAccountsReceivableCurrent`	$16.00M	USD	Point-in-time
Accounts receivable, allowances	`AllowanceForDoubtfulAccountsReceivableCurrent`	$14.00M	USD	Point-in-time
Property and equipment, accumulated depreciation	`AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment`	$10.23B	USD	Point-in-time
Property and equipment, accumulated depreciation	`AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment`	$10.49B	USD	Point-in-time
Cash and cash equivalents (Note 5)	`CashAndCashEquivalentsAtCarryingValue`	$3.55B	USD	Point-in-time
Cash and cash equivalents (Note 5)	`CashAndCashEquivalentsAtCarryingValue`	$2.07B	USD	Point-in-time
Short-term investments (Note 5)	`ShortTermInvestments`	$123.40M	USD	Point-in-time
Short-term investments (Note 5)	`ShortTermInvestments`	$144.80M	USD	Point-in-time
Accounts receivable, net of allowances of $14.0 (2023) and $16.0 (2022)	`AccountsReceivableNetCurrent`	$6.90B	USD	Point-in-time
Accounts receivable, net of allowances of $14.0 (2023) and $16.0 (2022)	`AccountsReceivableNetCurrent`	$7.53B	USD	Point-in-time
Other receivables	`OtherReceivablesNetCurrent`	$1.50B	USD	Point-in-time
Other receivables	`OtherReceivablesNetCurrent`	$1.66B	USD	Point-in-time
Inventories	`InventoryNet`	$4.54B	USD	Point-in-time
Inventories	`InventoryNet`	$4.31B	USD	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpenseAndOtherAssetsCurrent`	$2.95B	USD	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpenseAndOtherAssetsCurrent`	$3.58B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$20.81B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$18.03B	USD	Point-in-time
Investments (Note 5)	`LongTermInvestments`	$2.90B	USD	Point-in-time
Investments (Note 5)	`LongTermInvestments`	$2.75B	USD	Point-in-time
Goodwill	`Goodwill`	$4.07B	USD	Point-in-time
Goodwill	`Goodwill`	$4.07B	USD	Point-in-time
Other intangibles, net	`IntangibleAssetsNetExcludingGoodwill`	$7.21B	USD	Point-in-time
Other intangibles, net	`IntangibleAssetsNetExcludingGoodwill`	$7.09B	USD	Point-in-time
Deferred tax assets	`DeferredIncomeTaxAssetsNet`	$3.41B	USD	Point-in-time
Deferred tax assets	`DeferredIncomeTaxAssetsNet`	$2.79B	USD	Point-in-time
Property and equipment, net of accumulated depreciation of $10,486.0 (2023) and $10,233.4 (2022)	`PropertyPlantAndEquipmentNet`	$10.14B	USD	Point-in-time
Property and equipment, net of accumulated depreciation of $10,486.0 (2023) and $10,233.4 (2022)	`PropertyPlantAndEquipmentNet`	$10.55B	USD	Point-in-time
Other noncurrent assets	`OtherAssetsNoncurrent`	$4.49B	USD	Point-in-time
Other noncurrent assets	`OtherAssetsNoncurrent`	$4.34B	USD	Point-in-time
Total assets	`Assets`	$53.16B	USD	Point-in-time
Total assets	`Assets`	$49.49B	USD	Point-in-time
Short-term borrowings and current maturities of long-term debt	`DebtCurrent`	$1.50B	USD	Point-in-time
Short-term borrowings and current maturities of long-term debt	`DebtCurrent`	$3.10M	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$1.93B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.02B	USD	Point-in-time
Employee compensation	`EmployeeRelatedLiabilitiesCurrent`	$1.06B	USD	Point-in-time
Employee compensation	`EmployeeRelatedLiabilitiesCurrent`	$739.70M	USD	Point-in-time
Sales rebates and discounts	`SalesRebatesAndDiscounts`	$9.53B	USD	Point-in-time
Sales rebates and discounts	`SalesRebatesAndDiscounts`	$8.78B	USD	Point-in-time
Dividends payable	`DividendsPayableCurrent`	$1.02B	USD	Point-in-time
Dividends payable	`DividendsPayableCurrent`	-	USD	Point-in-time
Income taxes payable	`TaxesPayableCurrent`	$1.53B	USD	Point-in-time
Income taxes payable	`TaxesPayableCurrent`	$475.10M	USD	Point-in-time
Other current liabilities	`OtherLiabilitiesCurrent`	$2.37B	USD	Point-in-time
Other current liabilities	`OtherLiabilitiesCurrent`	$2.19B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$17.14B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$16.01B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$14.74B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$18.88B	USD	Point-in-time
Accrued retirement benefits (Note 7)	`PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent`	$1.31B	USD	Point-in-time
Accrued retirement benefits (Note 7)	`PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent`	$1.31B	USD	Point-in-time
Long-term income taxes payable	`AccruedIncomeTaxesNoncurrent`	$3.84B	USD	Point-in-time
Long-term income taxes payable	`AccruedIncomeTaxesNoncurrent`	$3.71B	USD	Point-in-time
Other noncurrent liabilities	`OtherLiabilitiesNoncurrent`	$1.82B	USD	Point-in-time
Other noncurrent liabilities	`OtherLiabilitiesNoncurrent`	$1.82B	USD	Point-in-time
Total other liabilities	`LiabilitiesNoncurrent`	$21.58B	USD	Point-in-time
Total other liabilities	`LiabilitiesNoncurrent`	$25.86B	USD	Point-in-time
Commitments and Contingencies (Note 8)	`CommitmentsAndContingencies`	-	USD	Point-in-time
Commitments and Contingencies (Note 8)	`CommitmentsAndContingencies`	-	USD	Point-in-time
Common stock	`CommonStockValue`	$594.10M	USD	Point-in-time
Common stock	`CommonStockValue`	$593.50M	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapitalCommonStock`	$6.92B	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapitalCommonStock`	$6.79B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$10.64B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$10.04B	USD	Point-in-time
Employee benefit trust	`CommonStockSharesHeldInEmployeeTrust`	$3.01B	USD	Point-in-time
Employee benefit trust	`CommonStockSharesHeldInEmployeeTrust`	$3.01B	USD	Point-in-time
Accumulated other comprehensive loss (Note 9)	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-3.84B	USD	Point-in-time
Accumulated other comprehensive loss (Note 9)	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-3.78B	USD	Point-in-time
Cost of common stock in treasury	`TreasuryStockCommonValue`	$45.00M	USD	Point-in-time
Cost of common stock in treasury	`TreasuryStockCommonValue`	$50.50M	USD	Point-in-time
Total Eli Lilly and Company shareholders' equity	`StockholdersEquity`	$11.19B	USD	Point-in-time
Total Eli Lilly and Company shareholders' equity	`StockholdersEquity`	$10.65B	USD	Point-in-time
Noncontrolling interests	`MinorityInterest`	$104.50M	USD	Point-in-time
Noncontrolling interests	`MinorityInterest`	$125.60M	USD	Point-in-time
Total equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$11.29B	USD	Point-in-time
Total equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$10.78B	USD	Point-in-time
Total liabilities and equity	`LiabilitiesAndStockholdersEquity`	$53.16B	USD	Point-in-time
Total liabilities and equity	`LiabilitiesAndStockholdersEquity`	$49.49B	USD	Point-in-time

Income Statement 28 line items

Line Item	Tag	Value	Unit	Period
Revenue (Note 2)	`Revenues`	$6.96B	USD	1 Quarter
Revenue (Note 2)	`Revenues`	$7.81B	USD	1 Quarter
Cost of sales	`CostOfGoodsAndServicesSold`	$1.63B	USD	1 Quarter
Cost of sales	`CostOfGoodsAndServicesSold`	$2.07B	USD	1 Quarter
Research and development	`ResearchAndDevelopmentExpense`	$1.61B	USD	1 Quarter
Research and development	`ResearchAndDevelopmentExpense`	$1.99B	USD	1 Quarter
Marketing, selling, and administrative	`SellingGeneralAndAdministrativeExpense`	$1.56B	USD	1 Quarter
Marketing, selling, and administrative	`SellingGeneralAndAdministrativeExpense`	$1.75B	USD	1 Quarter
Acquired in-process research and development (Note 3)	`AcquiredInProcessResearchAndDevelopment`	$105.00M	USD	1 Quarter
Acquired in-process research and development (Note 3)	`AcquiredInProcessResearchAndDevelopment`	$165.60M	USD	1 Quarter
Othernet, (income) expense (Note 10)	`NonoperatingIncomeExpense`	$35.70M	USD	1 Quarter
Othernet, (income) expense (Note 10)	`NonoperatingIncomeExpense`	$-350.70M	USD	1 Quarter
Costs, expenses, and other	`CostOfSalesOperatingExpensesAndOtherNet`	$5.76B	USD	1 Quarter
Costs, expenses, and other	`CostOfSalesOperatingExpensesAndOtherNet`	$5.43B	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$1.53B	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$2.05B	USD	1 Quarter
Income taxes (Note 6)	`IncomeTaxExpenseBenefit`	$150.70M	USD	1 Quarter
Income taxes (Note 6)	`IncomeTaxExpenseBenefit`	$184.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.34B	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.90B	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$2.11	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$1.49	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$1.49	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$2.10	USD	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	901.00M	shares	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	903.70M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	903.30M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	906.40M	shares	1 Quarter

Cash Flow Statement 60 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$1.34B	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.90B	USD	1 Quarter
Depreciation and amortization	`DepreciationDepletionAndAmortization`	$435.70M	USD	1 Quarter
Depreciation and amortization	`DepreciationDepletionAndAmortization`	$362.30M	USD	1 Quarter
Change in deferred income taxes	`IncreaseDecreaseInDeferredIncomeTaxes`	$559.40M	USD	1 Quarter
Change in deferred income taxes	`IncreaseDecreaseInDeferredIncomeTaxes`	$506.60M	USD	1 Quarter
Stock-based compensation expense	`ShareBasedCompensation`	$131.20M	USD	1 Quarter
Stock-based compensation expense	`ShareBasedCompensation`	$101.00M	USD	1 Quarter
Net investment losses	`GainLossOnInvestments`	$-426.10M	USD	1 Quarter
Net investment losses	`GainLossOnInvestments`	$-14.20M	USD	1 Quarter
Acquired in-process research and development (Note 3)	`AcquiredInProcessResearchAndDevelopment`	$105.00M	USD	1 Quarter
Acquired in-process research and development (Note 3)	`AcquiredInProcessResearchAndDevelopment`	$165.60M	USD	1 Quarter
Other changes in operating assets and liabilities, net of acquisitions and divestitures	`IncreaseDecreaseInOtherOperatingCapitalNet`	$-164.10M	USD	1 Quarter
Other changes in operating assets and liabilities, net of acquisitions and divestitures	`IncreaseDecreaseInOtherOperatingCapitalNet`	$34.30M	USD	1 Quarter
Other operating activities, net	`OtherOperatingActivitiesCashFlowStatement`	$32.60M	USD	1 Quarter
Other operating activities, net	`OtherOperatingActivitiesCashFlowStatement`	$168.30M	USD	1 Quarter
Net Cash Provided by Operating Activities	`NetCashProvidedByUsedInOperatingActivities`	$2.52B	USD	1 Quarter
Net Cash Provided by Operating Activities	`NetCashProvidedByUsedInOperatingActivities`	$1.73B	USD	1 Quarter
Purchases of property and equipment	`PaymentsToAcquireOtherPropertyPlantAndEquipment`	$365.40M	USD	1 Quarter
Purchases of property and equipment	`PaymentsToAcquireOtherPropertyPlantAndEquipment`	$668.50M	USD	1 Quarter
Proceeds from sales and maturities of short-term investments	`ProceedsFromSaleOfShortTermInvestments`	$61.50M	USD	1 Quarter
Proceeds from sales and maturities of short-term investments	`ProceedsFromSaleOfShortTermInvestments`	$26.70M	USD	1 Quarter
Purchases of short-term investments	`PaymentsToAcquireShortTermInvestments`	$14.60M	USD	1 Quarter
Purchases of short-term investments	`PaymentsToAcquireShortTermInvestments`	$23.00M	USD	1 Quarter
Proceeds from sales of and distributions from noncurrent investments	`ProceedsFromSaleAndMaturityOfOtherInvestments`	$281.90M	USD	1 Quarter
Proceeds from sales of and distributions from noncurrent investments	`ProceedsFromSaleAndMaturityOfOtherInvestments`	$81.40M	USD	1 Quarter
Purchases of noncurrent investments	`PaymentsToAcquireOtherInvestments`	$116.70M	USD	1 Quarter
Purchases of noncurrent investments	`PaymentsToAcquireOtherInvestments`	$146.00M	USD	1 Quarter
Purchases of in-process research and development	`PurchasesOfInProcessResearchAndDevelopment`	$515.60M	USD	1 Quarter
Purchases of in-process research and development	`PurchasesOfInProcessResearchAndDevelopment`	$235.00M	USD	1 Quarter
Other investing activities, net	`PaymentsForProceedsFromOtherInvestingActivities`	$-40.30M	USD	1 Quarter
Other investing activities, net	`PaymentsForProceedsFromOtherInvestingActivities`	$133.40M	USD	1 Quarter
Net Cash Used for Investing Activities	`NetCashProvidedByUsedInInvestingActivities`	$-688.80M	USD	1 Quarter
Net Cash Used for Investing Activities	`NetCashProvidedByUsedInInvestingActivities`	$-1.04B	USD	1 Quarter
Dividends paid	`PaymentsOfDividends`	$885.50M	USD	1 Quarter
Dividends paid	`PaymentsOfDividends`	$1.02B	USD	1 Quarter
Net change in short-term borrowings	`ProceedsFromRepaymentsOfShortTermDebt`	$-1.50B	USD	1 Quarter
Net change in short-term borrowings	`ProceedsFromRepaymentsOfShortTermDebt`	$499.70M	USD	1 Quarter
Proceeds from issuance of long-term debt	`ProceedsFromIssuanceOfLongTermDebt`	$3.96B	USD	1 Quarter
Proceeds from issuance of long-term debt	`ProceedsFromIssuanceOfLongTermDebt`	-	USD	1 Quarter
Repayments of long-term debt	`RepaymentsOfLongTermDebt`	$710.10M	USD	1 Quarter
Repayments of long-term debt	`RepaymentsOfLongTermDebt`	-	USD	1 Quarter
Purchases of common stock	`PaymentsForRepurchaseOfCommonStock`	$1.50B	USD	1 Quarter
Purchases of common stock	`PaymentsForRepurchaseOfCommonStock`	$750.00M	USD	1 Quarter
Other financing activities, net	`ProceedsFromPaymentsForOtherFinancingActivities`	$-281.00M	USD	1 Quarter
Other financing activities, net	`ProceedsFromPaymentsForOtherFinancingActivities`	$-282.40M	USD	1 Quarter
Net Cash Provided by (Used for) Financing Activities	`NetCashProvidedByUsedInFinancingActivities`	$412.30M	USD	1 Quarter
Net Cash Provided by (Used for) Financing Activities	`NetCashProvidedByUsedInFinancingActivities`	$-2.88B	USD	1 Quarter
Effect of exchange rate changes on cash and cash equivalents	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$24.80M	USD	1 Quarter
Effect of exchange rate changes on cash and cash equivalents	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$33.60M	USD	1 Quarter
Net increase (decrease) in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$1.48B	USD	1 Quarter
Net increase (decrease) in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$-1.36B	USD	1 Quarter
Cash and cash equivalents at January 1	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$3.55B	USD	Point-in-time
Cash and cash equivalents at January 1	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$2.46B	USD	Point-in-time
Cash and cash equivalents at January 1	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$2.07B	USD	Point-in-time
Cash and cash equivalents at January 1	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$3.82B	USD	Point-in-time
Cash and Cash Equivalents at March 31	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$3.55B	USD	Point-in-time
Cash and Cash Equivalents at March 31	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$2.46B	USD	Point-in-time
Cash and Cash Equivalents at March 31	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$2.07B	USD	Point-in-time
Cash and Cash Equivalents at March 31	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsIncludingDisposalGroupAndDiscontinuedOperations`	$3.82B	USD	Point-in-time

Stockholders Equity 8 line items

Line Item	Tag	Value	Unit	Period
Stock repurchase program, remaining authorized amount	`StockRepurchaseProgramRemainingAuthorizedRepurchaseAmount1`	$2.50B	USD	Point-in-time
Stock repurchase program, authorized amount	`StockRepurchaseProgramAuthorizedAmount1`	$5.00B	USD	Point-in-time
Beginning balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$11.29B	USD	Point-in-time
Beginning balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$10.78B	USD	Point-in-time
Other comprehensive income, net of tax	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$117.80M	USD	1 Quarter
Other comprehensive income, net of tax	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$67.30M	USD	1 Quarter
Ending balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$11.29B	USD	Point-in-time
Ending balance	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$10.78B	USD	Point-in-time

Comprehensive Income 6 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$1.34B	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.90B	USD	1 Quarter
Other comprehensive income, net of tax (Note 9)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$117.80M	USD	1 Quarter
Other comprehensive income, net of tax (Note 9)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$67.30M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$1.41B	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$2.02B	USD	1 Quarter

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