Balance Sheet Eli Lilly and Company

Equities

LLY

US5324571083

Pharmaceuticals

Real-time Estimate Cboe BZX Other stock markets 03:40:22 2024-09-11 pm EDT			5-day change	1st Jan Change
916.66 ^USD	+1.71%		-2.91%	+57.61%

10:56am	Eli Lilly: phase 3 trials on weekly insulin	CF
Sep. 10	Health Care Up on Defensive Bias -- Health Care Roundup	DJ

ead3f4980aec.68U47ebd8sbS--q3SWOIIVUo4yW9hDA5vshp6iwWuPQ.ob0Ai42Jl5Lgjb3CfzLDZBhaphb43Vt17awlhxlRyLfTinrbi6WooLGLqw

Published financial data: ELI LILLY AND COMPANY

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	22.32B	24.54B	28.32B	28.54B	34.12B
Total Revenues	22.32B	24.54B	28.32B	28.54B	34.12B
Cost of Goods Sold, Total	4.72B	5.48B	6.97B	6.63B	7.08B
Gross Profit	17.6B	19.06B	21.35B	21.91B	27.04B
Selling General & Admin Expenses, Total	6B	5.87B	6.14B	6.07B	6.94B
R&D Expenses	5.6B	6.09B	7.03B	7.19B	9.31B
Other Operating Expenses, Total	11.6B	11.96B	13.17B	13.26B	16.25B
Operating Income	6B	7.1B	8.18B	8.65B	10.79B
Interest Expense, Total	-401M	-360M	-340M	-332M	-486M
Interest And Investment Income	80.4M	33M	25.4M	62.8M	174M
Net Interest Expenses	-320M	-327M	-314M	-269M	-312M
Currency Exchange Gains (Loss)	-61.9M	124M	-205M	-191M	-26.4M
Other Non Operating Income (Expenses)	404M	-316M	-85.1M	177M	-6.3M
EBT, Excl. Unusual Items	6.02B	6.58B	7.57B	8.37B	10.44B
Restructuring Charges	-77.8M	-151M	-13M	-23M	-45.5M
Merger & Related Restructuring Charges	-401M	-	-	-	-
Gain (Loss) On Sale Of Investments	2.4M	1.44B	518M	-411M	-20.2M
Gain (Loss) On Sale Of Assets	310M	-	-	-	-
Asset Writedown	-	-	-	-	-
In Process R&D Expenses	-240M	-660M	-875M	-908M	-3.8B
Other Unusual Items	-350M	20M	-1.05B	-222M	-22.2M
EBT, Incl. Unusual Items	5.27B	7.23B	6.16B	6.81B	6.55B
Income Tax Expense	628M	1.04B	574M	562M	1.31B
Earnings From Continuing Operations	4.64B	6.19B	5.58B	6.24B	5.24B
Earnings Of Discontinued Operations	3.68B	-	-	-	-
Net Income to Company	8.32B	6.19B	5.58B	6.24B	5.24B
Net Income - (IS)	8.32B	6.19B	5.58B	6.24B	5.24B
Net Income to Common Incl Extra Items	8.32B	6.19B	5.58B	6.24B	5.24B
Net Income to Common Excl. Extra Items	4.64B	6.19B	5.58B	6.24B	5.24B
Per Share Items
Net EPS - Basic	8.93	6.82	6.15	6.93	5.82
Basic EPS - Continuing Operations	4.98	6.82	6.15	6.93	5.82
Basic Weighted Average Shares Outstanding	931M	908M	907M	902M	900M
Net EPS - Diluted	8.89	6.79	6.12	6.9	5.8
Diluted EPS - Continuing Operations	4.96	6.79	6.12	6.9	5.8
Diluted Weighted Average Shares Outstanding	936M	913M	912M	905M	903M
Normalized Basic EPS	4.04	4.53	5.22	5.8	7.25
Normalized Diluted EPS	4.02	4.51	5.19	5.78	7.23
Dividend Per Share	2.58	2.96	3.4	3.92	4.52
Payout Ratio	28.97	43.38	55.3	56.62	77.65
American Depositary Receipts Ratio (ADR)	0.03	0.03	0.03	0.03	0.03
Supplemental Items
EBITDA	7.23B	8.43B	9.73B	10.18B	12.31B
EBITA	6.23B	7.53B	8.81B	9.23B	11.29B
EBIT	6B	7.1B	8.18B	8.65B	10.79B
EBITDAR	7.4B	8.58B	9.88B	10.32B	12.49B
Effective Tax Rate - (Ratio)	11.93	14.33	9.32	8.25	20.05
Current Domestic Taxes	266M	520M	910M	2.2B	3.04B
Current Foreign Taxes	300M	650M	466M	548M	613M
Total Current Taxes	566M	1.17B	1.38B	2.75B	3.66B
Deferred Domestic Taxes	86.5M	-118M	-977M	-2.11B	-2.38B
Deferred Foreign Taxes	-24.1M	-16.6M	175M	-78.2M	34.2M
Total Deferred Taxes	62.4M	-134M	-802M	-2.19B	-2.34B
Normalized Net Income	3.76B	4.11B	4.73B	5.23B	6.53B
Interest Capitalized	-	-	-	-	-
Non-Cash Pension Expense	-60.4M	-74.9M	-120M	-205M	-282M
Supplemental Operating Expense Items
Advertising Expense	1.1B	1.1B	1.2B	1B	1.12B
Selling and Marketing Expenses	1.1B	1.1B	1.2B	1B	1.12B
Research And Development Expense From Footnotes	5.83B	6.75B	7.9B	8.1B	13.11B
Net Rental Expense, Total	173M	155M	159M	149M	171M
Imputed Operating Lease Interest Expense	42.04M	27.02M	25.12M	23.17M	31.07M
Imputed Operating Lease Depreciation	131M	128M	134M	126M	140M
Stock-Based Comp., Other (Total)	312M	308M	343M	371M	628M
Total Stock-Based Compensation	312M	308M	343M	371M	628M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	2.34B	3.66B	3.82B	2.07B	2.82B
Short Term Investments	101M	24.2M	90.1M	145M	109M
Trading Asset Securities, Total	-	-	4.8M	230M	114M
Total Cash And Short Term Investments	2.44B	3.68B	3.91B	2.44B	3.04B
Accounts Receivable, Total	4.55B	5.88B	6.67B	6.9B	9.09B
Other Receivables	976M	1.01B	1.44B	1.41B	2B
Total Receivables	5.52B	6.89B	8.11B	8.3B	11.09B
Inventory	3.19B	3.98B	3.89B	4.31B	5.77B
Prepaid Expenses	2.54B	2.87B	2.53B	2.95B	5.54B
Other Current Assets, Total	18.4M	41.1M	9.9M	26.6M	279M
Total Current Assets	13.71B	17.46B	18.45B	18.03B	25.73B
Gross Property Plant And Equipment	17.57B	18.25B	18.96B	20.38B	24.01B
Accumulated Depreciation	-9.16B	-9.57B	-9.98B	-10.23B	-11.1B
Net Property Plant And Equipment	8.4B	8.68B	8.99B	10.14B	12.91B
Long-term Investments	2.13B	3.2B	3.4B	3.2B	3.41B
Goodwill	3.68B	3.77B	3.89B	4.07B	4.94B
Other Intangibles, Total	6.62B	7.45B	7.69B	7.21B	6.91B
Deferred Tax Assets Long-Term	2.57B	2.83B	2.49B	2.79B	5.48B
Other Long-Term Assets, Total	2.18B	3.24B	3.89B	4.04B	4.64B
Total Assets	39.29B	46.63B	48.81B	49.49B	64.01B
Liabilities
Accounts Payable, Total	1.41B	1.61B	1.67B	1.93B	2.6B
Accrued Expenses, Total	5.92B	6.93B	7.88B	9.92B	13.42B
Short-term Borrowings	1.49B	-	-	-	-
Current Portion of Long-Term Debt	21.4M	101M	1.54B	1.54B	6.94B
Current Portion of Leases	127M	151M	148M	154M	197M
Current Income Taxes Payable	161M	495M	127M	475M	-
Deferred Tax Liability Current	-	-	-	-	-
Other Current Liabilities	2.65B	3.2B	3.69B	3.12B	4.14B
Total Current Liabilities	11.78B	12.48B	15.05B	17.14B	27.29B
Long-Term Debt	13.83B	16.78B	15.39B	14.87B	18.42B
Long-Term Leases	501M	513M	537M	574M	910M
Pension & Other Post Retirement Benefits	3.7B	4.09B	1.95B	1.31B	1.44B
Deferred Tax Liability Non Current	2.19B	2.1B	1.73B	87.3M	-
Other Non Current Liabilities	4.6B	4.83B	4.99B	4.74B	5.08B
Total Liabilities	36.59B	40.81B	39.65B	38.71B	53.14B
Common Stock, Total	599M	598M	596M	594M	594M
Additional Paid In Capital	6.69B	6.78B	6.83B	6.92B	7.25B
Retained Earnings	4.92B	7.83B	8.96B	10.04B	10.31B
Treasury Stock	-60.8M	-55.7M	-52.7M	-50.5M	-44.2M
Comprehensive Income and Other	-9.54B	-9.51B	-7.36B	-6.86B	-7.34B
Total Common Equity	2.61B	5.64B	8.98B	10.65B	10.77B
Minority Interest	92.2M	184M	176M	126M	91.8M
Total Equity	2.7B	5.83B	9.15B	10.78B	10.86B
Total Liabilities And Equity	39.29B	46.63B	48.81B	49.49B	64.01B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	906M	908M	902M	900M	900M
ECS Total Common Shares Outstanding	908M	907M	904M	900M	899M
Book Value / Share	2.87	6.22	9.94	11.83	11.98
Tangible Book Value	-7.69B	-5.57B	-2.6B	-630M	-1.07B
Tangible Book Value Per Share	-8.47	-6.15	-2.88	-0.7	-1.19
Total Debt	15.97B	17.55B	17.61B	17.14B	26.47B
Net Debt	13.53B	13.87B	12.42B	14.01B	22.71B
Debt Equivalent of Unfunded Proj. Benefit Obligation	3.39B	3.65B	1.15B	26.2M	549M
Debt Equivalent Oper. Leases	1.38B	1.24B	1.28B	1.19B	1.37B
Minority Interest, Total (Incl. Fin. Div)	92.2M	184M	176M	126M	91.8M
Equity Method Investments, Total	299M	472M	772M	781M	962M
Account Code - Inventory Valuation	4	4	4	4	4
LIFO Reserve, Total	51.2M	34.8M	34.2M	8.9M	102M
Inventories - Raw Materials, Total	425M	651M	717M	802M	1.63B
Inventories - Work In Process, Total	2.07B	2.54B	2.37B	2.6B	3.25B
Inventories - Finished Goods, Total	647M	759M	762M	901M	792M
Land - (BS)	170M	227M	259M	257M	320M
Buildings, Total	7.07B	7.33B	7.59B	7.92B	8.28B
Machinery, Total	7.91B	8.56B	8.94B	9.41B	10.33B
Full Time Employees	33.62K	35K	35K	39K	43K
Accumulated Allowance for Doubtful Accounts (Supple)	22.4M	25.9M	22.5M	16M	14.8M

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	8.32B	6.19B	5.58B	6.24B	5.24B
Depreciation & Amortization - CF	1.01B	896M	919M	943M	1.02B
Amortization of Goodwill and Intangible Assets - (CF)	226M	428M	629M	580M	506M
Depreciation & Amortization, Total	1.23B	1.32B	1.55B	1.52B	1.53B
Amortization of Deferred Charges, Total - (CF)	-	-	-	-	-
(Gain) Loss From Sale Of Asset	-310M	-	-	-	-1.88B
(Gain) Loss on Sale of Investments - (CF)	-	-1.44B	-178M	420M	23.5M
Asset Writedown & Restructuring Costs	240M	660M	875M	421M	3.8B
Stock-Based Compensation (CF)	312M	308M	343M	371M	628M
Net Cash From Discontinued Operations	-3.68B	-	-	-	-
Other Operating Activities, Total	411M	199M	114M	-1.88B	-2.05B
Change In Accounts Receivable	-127M	-1.35B	-1.28B	-300M	-2.45B
Change In Inventories	-259M	-533M	-236M	-600M	-1.42B
Change In Accounts Payable	-478M	1.27B	-664M	1.33B	4.27B
Change In Income Taxes	-221M	322M	-360M	347M	-
Change in Other Net Operating Assets	-602M	-457M	1.52B	-794M	-3.45B
Cash from Operations	4.84B	6.5B	7.26B	7.08B	4.24B
Capital Expenditure	-1.03B	-1.39B	-1.31B	-1.85B	-3.45B
Sale of Property, Plant, and Equipment	-	-	-	-	-
Cash Acquisitions	-6.92B	-849M	-747M	-327M	-1.04B
Divestitures	-19.2M	-	-	-	-
Sale (Purchase) of Intangible assets	-320M	-641M	-563M	-630M	-2.34B
Investment in Marketable and Equity Securities, Total	456M	517M	-166M	-244M	-129M
Other Investing Activities, Total	-249M	103M	24.3M	-206M	-192M
Cash from Investing	-8.08B	-2.26B	-2.76B	-3.26B	-7.15B
Short Term Debt Issued, Total	995M	-	-	1.5B	4.69B
Long-Term Debt Issued, Total	6.56B	2.06B	2.41B	-	3.96B
Total Debt Issued	7.55B	2.06B	2.41B	1.5B	8.65B
Short Term Debt Repaid, Total	-	-1.49B	-4M	-	-
Long-Term Debt Repaid, Total	-2.87B	-276M	-1.91B	-1.56B	-
Total Debt Repaid	-2.87B	-1.77B	-1.91B	-1.56B	-
Issuance of Common Stock	-	-	-	-	-
Repurchase of Common Stock	-4.4B	-500M	-1.25B	-1.5B	-750M
Common Dividends Paid	-2.41B	-2.69B	-3.09B	-3.54B	-4.07B
Common & Preferred Stock Dividends Paid	-2.41B	-2.69B	-3.09B	-3.54B	-4.07B
Other Financing Activities, Total	-200M	-242M	-296M	-309M	-335M
Cash from Financing	-2.32B	-3.14B	-4.13B	-5.41B	3.5B
Foreign Exchange Rate Adjustments	-89.9M	216M	-206M	-168M	169M
Net Change in Cash	-5.66B	1.32B	161M	-1.75B	752M
Supplemental Items
Cash Interest Paid	306M	346M	338M	324M	404M
Cash Income Tax Paid (Refund)	1.18B	955M	1.6B	2.67B	5.56B
Levered Free Cash Flow	4.87B	3.28B	5.14B	5.49B	237M
Unlevered Free Cash Flow	5.12B	3.51B	5.35B	5.7B	541M
Change In Net Working Capital	-1.18B	535M	-226M	-878M	2.57B
Net Debt Issued / Repaid	4.69B	292M	501M	-62M	8.65B

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	9.01	10.33	10.71	11	11.88
Return on Total Capital	18.77	21.42	20.66	20.03	20.91
Return On Equity %	68.16	145.32	74.52	62.67	48.43
Return on Common Equity	74.59	150.18	76.35	63.63	48.93
Margin Analysis
Gross Profit Margin %	78.85	77.66	75.38	76.77	79.25
SG&A Margin	26.9	23.92	21.69	21.26	20.34
EBITDA Margin %	32.4	34.33	34.34	35.65	36.09