Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Eli Lilly and Company logo

Eli Lilly and Company

Sector: Healthcare   

Industry: Drug Manufacturers - Major

878.45
 
USD
  
-4.88
  
(-0.00552455)
Optionable: Yes  Market Cap: 822879991306.0  90-day average vol: 2591518.0

Previous close: 883.33  Open: 882.33  Bid: 878.7  Ask: 888.0
52 week range    
434.34   
   885.06
Last updated: Sunday 16th June 2024

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Valuation

24.114

64.23

129.0

13.48

NA , NA

Returns

0.015549132947976932

0.13918715634401915

0.15378755440907227

0.9767502042120565

3.1139803679142783

7.333649558865384

0.5069820901667469

Risk

0.5838

0.5297

Ranks

65.0

69.0

Dividends

4.86

0.0059

2024-05-15

2024-06-10

0.0055

5.2

68.77

Analyst Estimates

13.76

19.28

3.8

2.65

815.55

33.3

812.05

806.43

806.43

Financial Health

3.87

1.4

0.6

2.05

25.84

Technicals

77.9481554107

842.684285714

846.2807

21.0962061711

18.0313412857

785.3912

674.85725

48.7189799384

-6.17907472383

Growth

Profitability

10.48

22.6

51.15

18.82

17.2

80.2

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

LLY Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles2,884 M5,035 M4,358 M4,370 M1,367 M6,618 M7,450 M7,692 M7,207 M6,907 M
Basic EPS from continuing operations2.232.272.59-0.193.144.986.826.156.935.82
Basic EPS total2.232.272.59-0.193.148.936.826.156.935.82
Basic weighted shares outstanding1,070 M1,062 M1,058 M1,052 M1,028 M931 M908 M907 M902 M900 M
BasicDiscontinuousOperations3.95
Cost of sales4,933 M5,037 M5,655 M6,151 M4,682 M4,721 M5,483 M7,313 M6,630 M7,082 M
Depreciation1,379 M1,428 M716 M763 M797 M815 M765 M787 M817 M902 M
DepreciationAndAmortization1,379 M1,428 M716 M763 M797 M815 M765 M787 M817 M902 M
DevelopmentExpense909 M3,800 M
Diluted EPS total2.232.262.58-0.193.138.896.796.126.95.8
Diluted normalized net income/share2.232.262.58-0.193.134.966.796.126.95.8
Diluted weighted shares outstanding1,074 M1,066 M1,062 M1,052 M1,034 M936 M913 M912 M905 M903 M
DilutedDiscontinuousOperations3.93
Dividends paid per share2.332.683.073.534.074.69
Earnings from equity interest-2,108 M-2,136 M-2,168 M-2,235 M
EarningsFromEquityInterestNetOfTax-2,108 M-2,136 M-2,168 M-2,235 M
GainOnSaleOfBusiness3,681 M
GainOnSaleOfSecurity354 M255 M31 M176 M20 M-401 M1,442 M177 M-411 M-20 M
GainsLossOnDisposalOfDiscontinuedOperations310 M
GeneralAndAdministrativeExpense6,621 M6,533 M6,452 M6,680 M5,975 M6,214 M6,121 M6,432 M6,440 M7,403 M
Gross operating profit14,683 M14,922 M15,567 M16,721 M16,812 M17,598 M19,057 M21,006 M21,912 M27,042 M
Income before tax3,000 M2,790 M3,374 M2,197 M3,680 M5,266 M7,230 M6,156 M6,806 M6,555 M
Income restructuring and M&A469 M368 M383 M1,674 M267 M576 M131 M316 M245 M68 M
Income taxes610 M382 M636 M2,402 M530 M628 M1,036 M574 M562 M1,314 M
Interest income121 M87 M109 M167 M159 M80 M33 M25 M63 M174 M
InterestExpenseNonOperating149 M161 M185 M225 M243 M401 M360 M340 M332 M486 M
InterestExpenseOperating-140 M-130 M-146 M-193 M-224 M-305 M-346 M-338 M-324 M-404 M
MinorityInterests15,388 M14,590 M14,081 M11,668 M10,909 M2,699 M5,825 M
MiscOtherSpecialCharges341 M101 M-85 M301 M146 M292 M1,172 M-202 M-321 M97 M
Net income from total operations2,391 M2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M6,245 M5,240 M
NetIncomeCommonStockholders2,591 M2,943 M2,768 M909 M5,216 M8,558 M6,854 M5,582 M6,245 M5,240 M
NetIncomeContinuousOperations2,391 M2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M6,245 M5,240 M
NetIncomeDiscontinuousOperations81 M3,681 M
NetNonOperatingInterestIncomeExpense-28 M-74 M-76 M-58 M-83 M-320 M-327 M-314 M-269 M-312 M
Normalized income2,431 M2,224 M2,860 M3,306 M3,174 M1,055 M5,843 M5,246 M
Operating income3,329 M3,592 M3,871 M4,683 M5,785 M5,790 M6,850 M7,643 M7,372 M6,525 M
Operating income before depreciation (EBITDA)4,388 M4,249 M4,909 M3,797 M5,308 M6,594 M8,568 M7,705 M8,337 M8,164 M
OperatingExpense11,354 M11,329 M11,696 M12,037 M11,026 M11,809 M12,207 M13,362 M14,540 M20,517 M
Other income net-340 M-101 M85 M-300 M-146 M-292 M-1,172 M202 M321 M-97 M
OtherGainLossFromDispositionOfDiscontinuedOperations81 M3,681 M
OtherGandA6,621 M6,533 M6,452 M6,680 M5,975 M6,214 M6,121 M6,432 M6,440 M7,403 M
OtherImpairmentOfCapitalAssets13 M43 M53 M50 M108 M
OtherOperatingExpenses-126 M-131 M-73 M-134 M-798 M-187 M-226 M-310 M-274 M-364 M
PromotionAndAdvertising900 M1,100 M1,100 M1,200 M967 M1,120 M
RentAndLandingFees227 M226 M221 M225 M176 M
Research & development expense4,734 M4,796 M5,244 M5,357 M5,051 M5,595 M6,086 M6,931 M8,099 M13,113 M
ResearchExpense4,734 M4,796 M5,244 M5,357 M5,051 M5,595 M6,086 M6,931 M7,191 M9,313 M
RestructringAndMnAIncome469 M368 M383 M1,674 M267 M576 M131 M316 M245 M68 M
Revenue per share2,884 M5,035 M4,358 M4,370 M1,367 M6,618 M7,450 M7,692 M7,207 M6,907 M
SalariesAndWages-55 M-76 M-89 M-70 M-53 M-64 M-65 M-72 M-78 M-132 M
Selling Gen & administrative expense6,621 M6,533 M6,452 M6,680 M5,975 M6,214 M6,121 M6,432 M6,440 M7,403 M
SellingAndMarketingExpense900 M1,100 M1,100 M1,200 M967 M1,120 M
Special income/charges-469 M-368 M-382 M-1,674 M-267 M-576 M-131 M-316 M-245 M-68 M
Total Income available for interest expense (EBIT)3,009 M2,822 M3,413 M2,230 M3,699 M5,361 M7,244 M6,157 M6,814 M6,636 M
Total common shares outstanding1,111 M1,106 M1,103 M1,096 M1,035 M956 M958 M952 M950 M950 M
Total net income2,391 M2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M6,245 M5,240 M
Total ordinary shares950 M950 M950 M950 M950 M950 M950 M950 M950 M950 M
Total revenues19,616 M19,959 M21,222 M22,871 M21,493 M22,320 M24,540 M28,318 M28,541 M34,124 M
TotalExpenses16,287 M16,367 M17,351 M18,188 M15,708 M16,530 M17,690 M20,675 M21,170 M27,599 M
TotalRevenue19,616 M19,959 M21,222 M22,871 M21,493 M22,320 M24,540 M28,318 M28,541 M34,124 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University