Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

LLY Stock Forecast, Price Targets, Chart, Dividends & Analysis

Eli Lilly and Company logo

Eli Lilly and Company

Sector: Healthcare   

Industry: Drug Manufacturers - Major

859.73
 
USD
  
30.31
  
(3.65%)
Previous close: 829.42  Open: 836.0  Bid: 861.95  Ask: 862.5
52 week range    
677.09   
   972.53
Mkt Cap: 784,649 M  Avg Vol (90 Days): 3,659,837
Last updated: Friday 25th April 2025

Stock Rankings

51
MarketXLS Rank
20
Value
63
Technical
71
Quality
How are these ranks calculated?
Metrics

Growth

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

LLY Income Statement

Annual
Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23Dec-24
Amortization of intangibles5,035 M4,358 M4,370 M1,367 M6,618 M7,450 M7,692 M7,207 M6,907 M6,166 M
Basic EPS from continuing operations2.272.59-0.193.144.986.826.156.935.8211.76
Basic EPS total2.272.59-0.193.148.936.826.156.935.8211.76
Basic weighted shares outstanding1,062 M1,058 M1,052 M1,028 M931 M908 M907 M902 M900 M901 M
BasicDiscontinuousOperations3.95
Cost of sales5,037 M5,655 M6,151 M4,682 M4,721 M5,483 M7,313 M6,630 M7,082 M8,418 M
Depreciation1,428 M716 M763 M797 M815 M765 M787 M817 M1,527 M1,767 M
DepreciationAndAmortization1,428 M716 M763 M797 M815 M765 M787 M817 M1,527 M1,767 M
DevelopmentExpense909 M3,800 M3,280 M
Diluted EPS total2.262.58-0.193.138.896.796.126.95.811.71
Diluted normalized net income/share2.262.58-0.193.134.966.796.126.95.811.71
Diluted weighted shares outstanding1,066 M1,062 M1,052 M1,034 M936 M913 M912 M905 M903 M904 M
DilutedDiscontinuousOperations3.93
Dividends paid per share2.332.683.073.533.924.525.4
Earnings from equity interest-2,136 M-2,168 M-2,235 M
EarningsFromEquityInterestNetOfTax-2,136 M-2,168 M-2,235 M
GainOnSaleOfBusiness3,681 M
GainOnSaleOfSecurity255 M31 M176 M20 M-401 M1,442 M177 M-411 M-20 M-49 M
GainsLossOnDisposalOfDiscontinuedOperations310 M
GeneralAndAdministrativeExpense6,533 M6,452 M6,680 M5,975 M6,214 M6,121 M6,432 M6,440 M7,403 M8,594 M
Gross operating profit14,922 M15,567 M16,721 M16,812 M17,598 M19,057 M21,006 M21,912 M27,042 M36,624 M
Income before tax2,790 M3,374 M2,197 M3,680 M5,266 M7,230 M6,156 M6,806 M6,555 M12,680 M
Income restructuring and M&A368 M383 M1,674 M267 M576 M131 M316 M245 M68 M861 M
Income taxes382 M636 M2,402 M530 M628 M1,036 M574 M562 M1,314 M2,090 M
Interest income87 M109 M167 M159 M80 M33 M25 M63 M174 M175 M
InterestExpenseNonOperating161 M185 M225 M243 M401 M360 M340 M332 M486 M
InterestExpenseOperating-130 M-146 M-193 M-224 M-305 M-346 M-338 M-324 M-404 M-577 M
MinorityInterests14,590 M14,081 M11,668 M10,909 M2,699 M5,825 M
MiscOtherSpecialCharges101 M-85 M301 M146 M292 M1,172 M-202 M-321 M97 M-219 M
Net income from total operations2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M6,245 M5,240 M10,590 M
NetIncomeCommonStockholders2,943 M2,768 M909 M5,216 M8,558 M6,194 M5,582 M6,245 M5,240 M10,590 M
NetIncomeContinuousOperations2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M6,245 M5,240 M10,590 M
NetIncomeDiscontinuousOperations81 M3,681 M
NetNonOperatingInterestIncomeExpense-74 M-76 M-58 M-83 M-320 M-327 M-314 M-269 M174 M175 M
Normalized income2,224 M2,860 M3,306 M3,174 M1,055 M5,843 M13,849 M
Operating income3,592 M3,871 M4,683 M5,785 M5,790 M6,850 M7,643 M7,372 M6,525 M13,760 M
Operating income before depreciation (EBITDA)4,249 M4,909 M3,797 M5,308 M6,594 M8,913 M8,043 M8,661 M6,555 M14,447 M
OperatingExpense11,329 M11,696 M12,037 M11,026 M11,809 M12,207 M13,362 M13,258 M20,517 M22,864 M
Other income net-101 M85 M-300 M-146 M-292 M-1,172 M202 M-1,578 M-97 M219 M
OtherGainLossFromDispositionOfDiscontinuedOperations81 M3,681 M
OtherGandA6,533 M6,452 M6,680 M5,975 M6,214 M6,121 M6,432 M6,440 M7,403 M8,594 M
OtherImpairmentOfCapitalAssets43 M53 M50 M108 M435 M
OtherOperatingExpenses-131 M-73 M-134 M-798 M-187 M-226 M-310 M-274 M-364 M-694 M
PromotionAndAdvertising900 M1,100 M1,100 M1,200 M967 M1,120 M1,440 M
RentAndLandingFees226 M221 M225 M176 M
Research & development expense4,796 M5,244 M5,357 M5,051 M5,595 M6,086 M6,931 M8,099 M13,113 M14,271 M
ResearchExpense4,796 M5,244 M5,357 M5,051 M5,595 M6,086 M6,931 M7,191 M9,313 M10,991 M
RestructringAndMnAIncome368 M383 M1,674 M267 M576 M131 M316 M245 M68 M861 M
Revenue per share5,035 M4,358 M4,370 M1,367 M6,618 M7,450 M7,692 M7,207 M6,907 M6,166 M
SalariesAndWages-76 M-89 M-70 M-53 M-64 M-65 M-72 M-78 M-132 M-136 M
Selling Gen & administrative expense6,533 M6,452 M6,680 M5,975 M6,214 M6,121 M6,432 M6,440 M7,403 M8,594 M
SellingAndMarketingExpense900 M1,100 M1,100 M1,200 M967 M1,120 M1,440 M
Special income/charges-368 M-382 M-1,674 M-267 M-576 M-131 M-316 M-245 M-68 M-861 M
Total Income available for interest expense (EBIT)2,822 M3,413 M2,230 M3,699 M5,361 M7,590 M6,495 M7,138 M6,555 M12,680 M
Total common shares outstanding1,106 M1,103 M1,096 M1,035 M956 M958 M952 M950 M950 M948 M
Total net income2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M6,245 M5,240 M10,590 M
Total ordinary shares948 M948 M948 M948 M948 M948 M948 M948 M948 M948 M
Total revenues19,959 M21,222 M22,871 M21,493 M22,320 M24,540 M28,318 M28,541 M34,124 M45,043 M
TotalExpenses16,367 M17,351 M18,188 M15,708 M16,530 M17,690 M20,675 M19,888 M27,599 M31,283 M
TotalRevenue19,959 M21,222 M22,871 M21,493 M22,320 M24,540 M28,318 M28,541 M34,124 M45,043 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 provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

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

Lloyd L.

Professional Trader