ELI LILLY AND COMPANY (LLY)

Import this data to Google Sheets with:

=jivedata("LLY","financials")

Full statements spill as a table. For one cell: =jivedata("LLY","Revenue") or =jivedata("LLY","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

ELI LILLY AND COMPANY

LLY • CIK 0000059478

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenues	$34,124,100	$45,042,700	$65,179,000	$79,665,800
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$6,554,600	$12,680,400	$25,731,000	$33,595,500
Income Tax Expense (Benefit)	$1,314,200	$2,090,400	$5,091,000	$6,884,300
Net Income (Loss) Attributable to Parent	$5,240,400	$10,590,000	$20,640,000	$26,711,200
Cost of Goods and Services Sold	$7,082,200	$8,418,300	$11,052,000	$13,225,000
Research and Development Expense (Excluding Acquired in Process Cost)	$9,313,400	$10,990,600	$13,337,000	$14,596,200
Selling, General and Administrative Expense	$7,403,100	$8,593,800	$11,094,000	$12,236,200
Research and Development Asset Acquired Other than Through Business Combination, Written-off	$3,799,800	$3,280,400	$2,910,000	$4,544,500
Restructuring, Settlement and Impairment Provisions	$67,700	$860,600	$484,000	$1,431,000
Nonoperating Income (Expense)	$96,700	$-218,600	$-571,000	$-37,400
Weighted Average Number of Shares Outstanding, Basic	900,181,000	900,605,000	897,300,000	892,500,000
Weighted Average Number of Shares Outstanding, Diluted	903,284,000	904,059,000	899,300,000	893,900,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$2,818,600	$3,268,400	$7,268,000	$8,950,000
Accounts Receivable, after Allowance for Credit Loss, Current	$9,090,500	$11,005,700	$17,760,000	$20,083,000
Other Receivables, Net, Current	$2,245,700	$2,269,700	$2,395,000	$3,392,000
Assets	$64,006,300	$78,714,900	$112,476,000	$142,283,000
Inventory, Net	$5,772,800	$7,589,200	$13,744,000	$16,793,000
Prepaid Expense, Current	$5,540,800	$8,340,500	$14,315,000	$15,368,000
Other Assets, Current	$149,500	$111,400	$147,000	$86,000
Assets, Current	$25,727,000	$32,739,700	$55,629,000	$64,672,000
Long-term Investments	$3,052,200	$3,215,900	$2,802,000	$3,856,000
Goodwill	$4,939,700	$5,770,300	$5,898,000	$8,849,000
Intangible Assets, Net (Excluding Goodwill)	$6,906,600	$6,166,300	$6,521,000	$18,110,000
Deferred Income Tax Assets, Net	$5,477,300	$8,000,600	$9,959,000	$10,028,000
Property, Plant and Equipment, Net	$12,913,600	$17,102,400	$24,675,000	$29,286,000
Stockholders' Equity Attributable to Parent	$10,771,900	$14,192,100	$26,535,000	$33,879,000
Other Assets, Noncurrent	$4,989,900	$5,719,700	$6,992,000	$7,482,000
Debt, Current	$6,904,500	$5,117,100	$1,635,000	$7,050,000
Accounts Payable, Current	$2,598,800	$3,228,600	$5,379,000	$6,112,000
Employee-related Liabilities, Current	$1,650,400	$2,093,900	$2,375,000	$1,798,000
Other Liabilities, Current	$3,281,300	$5,051,400	$8,457,000	$11,659,000
Liabilities, Current	$27,293,200	$28,376,600	$35,228,000	$47,741,000
Long-term Debt, Excluding Current Maturities	$18,320,800	$28,527,100	$40,868,000	$47,858,000
Accrued Income Taxes, Noncurrent	$3,849,200	$4,060,900	$5,875,000	$5,461,000
Other Liabilities, Noncurrent	$2,240,600	$2,178,200	$3,970,000	$7,344,000
Liabilities, Noncurrent	$25,849,400	$36,066,700	$50,713,000	$60,663,000
Common Stock, Value, Issued	$593,600	$592,400	$590,000	$588,000
Additional Paid in Capital, Common Stock	$7,250,400	$7,439,300	$7,346,000	$7,117,000
Retained Earnings (Accumulated Deficit)	$10,312,300	$13,545,000	$24,470,000	$31,893,000
Common Stock, Shares Held in Employee Trust	$3,013,200	$3,013,200	$3,013,000	$3,013,000
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-4,327,000	$-4,321,900	$-2,880,000	$-2,761,000
Other Additional Capital	—	—	$22,000	$55,000
Common Stock, Shares Authorized	3,200,000,000	3,200,000,000	3,200,000,000	3,200,000,000
Common Stock, Shares, Issued	949,781,000	947,903,000	944,800,000	944,800,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$5,240,400	$10,590,000	$20,640,000	$26,711,200
Net Cash Provided by (Used in) Operating Activities	$4,240,100	$8,817,900	$16,813,000	$28,083,500
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$168,600	$-296,700	$372,000	$-20,400
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$751,600	$449,800	$4,000,000	$5,574,500
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Including Disposal Group and Discontinued Operations	$2,818,600	$3,268,400	$7,268,000	$9,456,700
Depreciation, Depletion and Amortization	$1,527,300	$1,766,600	$1,997,000	$2,098,700
Payments to Acquire Other Property, Plant, and Equipment	$3,447,600	$5,057,800	$7,841,000	$9,893,400
Increase (Decrease) in Deferred Income Taxes	$2,341,000	$2,683,100	$1,707,000	$679,700
Proceeds from Sale and Maturity of Other Investments	$508,100	$373,600	$964,000	$964,000
Share-based Payment Arrangement, Noncash Expense	$628,500	$645,600	$626,000	$649,200
Payments to Acquire Other Investments	$730,800	$677,300	$645,000	$881,100
Gain (Loss) on Disposition of Intangible Assets	$1,878,900	$223,800	$180,000	$180,000
Proceeds from Sale of Intangible Assets	$1,604,300	$601,300	$218,000	$218,000
Research and Development Asset Acquired Other than Through Business Combination, Written-off	$3,799,800	$3,280,400	$2,910,000	$4,544,500
Payments to Acquire in Process Research and Development	$3,944,500	$3,345,800	$3,008,000	$4,630,200
Other Operating Activities, Cash Flow Statement	$295,500	$777,400	$620,000	$-225,200
Other Payments to Acquire Businesses	$1,044,300	$947,700	$661,000	$10,466,000
Payments for (Proceeds from) Other Investing Activities	$191,900	$298,200	$-1,000	$132,200
Net Cash Provided by (Used in) Investing Activities	$-7,152,700	$-9,301,500	$-10,972,000	$-25,096,800
Payments of Dividends	$4,069,300	$4,680,400	$5,384,000	$5,784,700
Proceeds from (Repayments of) Short-term Debt	$4,691,400	$-1,851,800	$-4,338,000	$1,191,900
Proceeds from Issuance of Long-term Debt	$3,958,500	$11,417,100	$13,167,000	$15,647,000
Repayments of Long-term Debt	$0	$664,200	$778,000	$1,622,900
Payments for Repurchase of Common Stock	$750,000	$2,500,000	$4,108,000	$6,172,800
Proceeds from (Payments for) Other Financing Activities	$-335,000	$-490,600	$-772,000	$-650,300
Net Cash Provided by (Used in) Financing Activities	$3,495,600	$1,230,100	$-2,213,000	$2,608,200
Increase (Decrease) in Accounts and Other Receivables	$2,451,000	$2,155,200	$7,000,000	$7,000,000
Increase (Decrease) in Inventories	$1,425,000	$2,507,400	$4,671,000	$4,671,000
Increase (Decrease) in Prepaid Expense and Other Assets	—	$3,331,200	$6,609,000	$6,609,000
Increase (Decrease) in Accounts Payable and Accrued Liabilities	$4,274,400	$2,608,800	$10,187,000	$10,187,000

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("LLY","financials")

Full statements spill as a table. For one cell: =jivedata("LLY","Revenue") or =jivedata("LLY","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.