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

348.01
 
USD
  
-1.72
  
(-0.49%)
Optionable: Yes  Market Cap: 329,132 M  90-day average vol: 2,814,319

Previous close: 349.73  Open: 351.0  Bid: 348.85  Ask: 348.85
52 week range    
231.87   
   384.44
Peers   
BMY / 
MRK / 
JNJ / 
PFE / 
SNY / 
GSK / 
ABBV / 
AMGN / 
NVS / 
Last updated: Friday 27th January 2023
45
MarketXLS Rank marketxls
40
Value marketxls
30
Technical marketxls
65
Quality marketxls

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
Are you?
twitterstocktwits
Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ABBV

0.0401242 B33.1142.53

AMGN

0.0347129 B23.4223.53

AZN

BMY

0.0332145 B-27.366.19

GSK

JNJ

0.0247450 B22.1171.06

MRK

0.0356207 B28.877.58

NVS

PFE

0.0302298 B15.153.21

SNY

News
Financials

LLY Income Statement

Annual
Save
Dec-12Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21
Total revenues22,603 M23,113 M19,616 M19,959 M21,222 M19,974 M21,493 M22,320 M24,540 M28,318 M
Cost of sales3,334 M3,463 M3,554 M3,610 M4,214 M2,880 M3,073 M3,489 M4,159 M5,765 M
Gross operating profit17,807 M18,205 M14,683 M14,922 M15,512 M15,526 M16,812 M17,598 M19,057 M21,006 M
Selling Gen & administrative expense7,514 M7,126 M6,621 M6,533 M6,528 M6,429 M5,975 M6,214 M6,121 M6,432 M
Research & development expense5,278 M5,531 M4,734 M4,796 M5,310 M5,096 M5,051 M5,595 M6,086 M7,026 M
Operating income5,015 M5,548 M3,329 M3,592 M3,674 M4,001 M5,785 M5,790 M6,850 M7,548 M
floaterest income0000000000
floaterest expense0000000000
Other income net466 M382 M-301 M-728 M-223 M-1,637 M-2,022 M-203 M707 M-1,078 M
Pre-tax Income (EBT)5,408 M5,889 M3,000 M2,790 M3,374 M2,305 M3,680 M5,266 M7,230 M6,156 M
Income taxes1,320 M1,205 M610 M382 M636 M2,391 M530 M628 M1,036 M574 M
Net income from total operations4,089 M4,685 M2,391 M2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M
Minority floaterest0000000000
Total net income4,089 M4,685 M2,391 M2,408 M2,738 M-204 M3,232 M8,318 M6,194 M5,582 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common4,089 M4,685 M2,391 M2,408 M2,738 M-86 M3,151 M4,638 M6,194 M5,582 M
Depreciation1,462 M1,446 M1,379 M1,428 M1,497 M1,567 M1,609 M1,233 M1,324 M1,548 M
Amortization0000000000
Operating income before depreciation (EBITDA)7,048 M7,495 M4,528 M4,379 M5,056 M4,097 M5,532 M6,899 M8,913 M8,043 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total3.674.332.232.272.59-0.193.148.936.826.15
Diluted EPS total3.664.322.232.262.58-0.193.138.896.796.12
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today