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

865.97
 
USD
  
8.50
  
(0.99%)
Optionable: Yes  Market Cap: 894,902 M  90-day average vol: 2,859,698

Previous close: 857.47  Open: 864.8  Bid: 866.0  Ask: 867.0
52 week range    
446.56   
   966.10
Last updated: Tuesday 23rd July 2024
45
MarketXLS Rank
25
Value
46
Technical
65
Quality

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

Financials

LLY Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable1,128 M1,338 M1,349 M1,411 M1,207 M1,405 M1,607 M1,671 M1,931 M2,599 M
Accounts receivable3,801 M4,072 M4,029 M4,546 M4,594 M4,547 M5,875 M6,673 M6,896 M9,091 M
Accrued expenses1,752 M2,236 M2,017 M2,534 M2,251 M2,237 M2,872 M2,683 M2,948 M3,768 M
Accumulated depreciation & depletion-8,065 M-8,607 M-8,525 M-9,265 M-8,667 M-9,162 M-9,571 M-9,977 M-10,233 M-11,099 M
Additional paid in capital5,292 M5,552 M5,641 M5,818 M6,584 M6,685 M6,779 M6,833 M6,921 M7,250 M
Building & improvements6,516 M6,787 M6,918 M7,426 M7,117 M7,067 M7,326 M7,588 M7,916 M8,280 M
Cash and equivalents3,872 M3,666 M4,582 M6,536 M15,319 M2,338 M3,657 M3,819 M2,067 M2,819 M
CashCashEquivalentsAndShortTermInvestments4,827 M4,452 M6,039 M8,034 M15,407 M2,439 M3,681 M3,909 M2,212 M2,928 M
CashEquivalents3,872 M3,666 M4,582 M6,536 M7,998 M2,338 M
CommercialPaper2,681 M-1,299 M-2,697 M-499 M-1,494 M-1,498 M-6,189 M
Common par-2,319 M-2,322 M-2,321 M-2,322 M-2,352 M-2,411 M-2,412 M-2,414 M-2,416 M-2,416 M
Common stock equity15,373 M14,571 M14,011 M11,595 M9,829 M2,610 M5,645 M8,982 M10,650 M10,772 M
CommonStock-2,319 M-2,322 M-2,321 M-2,322 M-2,352 M-2,411 M-2,412 M-2,414 M-2,416 M-2,416 M
Construction in progress1,698 M1,665 M1,798 M1,784 M1,589 M1,884 M2,139 M2,178 M2,799 M5,084 M
Cost in excess1,758 M4,040 M3,973 M4,370 M1,367 M3,679 M3,767 M3,892 M4,073 M4,940 M
CurrentAccruedExpenses759 M967 M897 M998 M1,055 M916 M997 M958 M
CurrentCapitalLeaseObligation135 M131 M156 M
CurrentDeferredTaxesAssets2,550 M2,947 M2,961 M2,539 M4,338 M4,990 M5,802 M5,787 M7,285 M9,396 M
CurrentDeferredTaxesLiabilities2,982 M2,656 M-3,176 M-1,541 M-3,037 M-4,605 M-5,071 M-5,031 M-4,579 M5,373 M
Deferred revenues1,467 M
DefinedPensionBenefit10,880 M10,750 M11,490 M13,900 M12,570 M15,170 M
DividendsPayable530 M539 M548 M591 M651 M672 M771 M886 M1,017 M1,169 M
EmployeeBenefits2,563 M2,160 M2,454 M3,514 M2,802 M3,698 M4,095 M1,954 M1,305 M1,439 M
Finished goods838 M1,053 M987 M1,211 M578 M647 M759 M762 M901 M792 M
Float term debt5,333 M7,972 M8,368 M9,941 M9,196 M13,818 M16,587 M15,346 M14,738 M18,321 M
GoodwillAndOtherIntangibleAssets4,642 M9,075 M8,331 M8,399 M2,435 M10,297 M11,217 M11,584 M11,280 M11,846 M
Gross fixed assets (Plant Property & Equipment)16,029 M16,661 M16,778 M18,091 M17,193 M17,035 M18,253 M18,962 M20,377 M24,013 M
IncomeTaxPayable94 M359 M119 M533 M393 M161 M495 M127 M475 M
Intangibles2,884 M5,035 M4,358 M4,029 M1,068 M6,618 M7,450 M7,692 M7,207 M6,907 M
InterestPayable149 M161 M185 M225 M243 M401 M360 M340 M332 M486 M
Inventories2,740 M3,446 M3,562 M4,458 M3,098 M3,191 M3,980 M3,886 M4,310 M5,773 M
InventoriesAdjustmentsAllowances-340 M
Invested capital26,039 M30,516 M30,747 M31,476 M28,222 M30,246 M38,818 M39,675 M40,125 M47,414 M
Land & improvements205 M221 M198 M193 M166 M170 M227 M259 M257 M320 M
LineOfCredit3,310 M1,300 M2,870 M6 M6,170 M5,210 M5,240 M5,260 M7,330 M7,420 M
LongTermCapitalLeaseObligation487 M761 M776 M823 M1,392 M
LongTermDebtAndCapitalLeaseObligation5,333 M7,972 M8,368 M9,941 M9,196 M13,818 M16,587 M15,346 M14,738 M18,321 M
Machinery furniture & equipment7,610 M7,989 M7,865 M8,689 M7,792 M7,913 M8,561 M8,937 M9,406 M10,329 M
Minority interest15 M19 M73 M76 M1,080 M92 M184 M176 M126 M92 M
Net fixed assets (net PP&E)7,964 M8,054 M8,253 M8,827 M8,526 M7,873 M8,682 M8,985 M10,144 M12,914 M
NetOtherUnrealizedGainLoss18 M53 M34 M48 M
Non-current deferred income taxes-425 M-412 M-399 M-282 M1,313 M2,188 M2,100 M1,734 M-433 M-495 M
NonCurrentAccruedExpenses999 M869 M689 M3,777 M3,700 M3,607 M3,838 M3,920 M3,710 M3,849 M
NonCurrentDeferredAssets1,166 M2,614 M2,573 M2,830 M2,489 M2,793 M5,477 M
NonCurrentDeferredLiabilities1,313 M2,188 M2,100 M1,734 M87 M
NonCurrentDeferredTaxesAssets3,151 M3,538 M3,609 M1,166 M2,614 M2,573 M2,830 M2,489 M2,793 M5,477 M
NonCurrentPensionAndOtherPostretirementBenefitPlans2,563 M2,160 M2,454 M3,514 M2,802 M3,698 M4,095 M1,954 M1,305 M1,439 M
Notes payable4,873 M7,700 M8,777 M10,757 M9,641 M13,639 M16,349 M16,741 M14,815 M19,105 M
Other current assets1,339 M1,067 M853 M1,015 M2,229 M2,109 M2,552 M2,798 M7 M150 M
Other equity adjustments-3,992 M-4,581 M-5,274 M-5,719 M-5,729 M-6,524 M-6,496 M-4,343 M
Other fixed assets7,964 M8,054 M8,253 M8,827 M8,526 M7,873 M8,682 M8,985 M10,144 M12,914 M
Other non-current assets7,204 M2,221 M1,914 M1,708 M8,309 M2,871 M3,475 M4,083 M4,337 M4,990 M
Other non-current liabilities4,353 M1,747 M6,143 M6,011 M1,358 M6,435 M1,708 M1,644 M1,824 M13,930 M
Other receivable737 M716 M1,183 M994 M1,054 M1,454 M1,663 M2,246 M
OtherCurrentBorrowings2,689 M6 M1,937 M3,707 M1,102 M1,499 M9 M1,538 M1,501 M6,905 M
OtherCurrentLiabilities3,232 M5,987 M3,118 M3,830 M8,535 M3,105 M9,601 M10,831 M12,689 M4,932 M
OtherInventories2,740 M3,446 M3,562 M4,458 M3,098 M3,191 M3,980 M3,886 M4,310 M5,773 M
OtherPayable551 M5,283 M45 M240 M849 M747 M327 M
Payables1,752 M2,236 M2,017 M2,534 M2,251 M2,237 M2,872 M2,683 M2,948 M3,768 M
Preferred securities of subsidiary trust5 M5 M5 M5 M5 M5 M
PreferredStock5 M5 M5 M5 M5 M5 M
Prepaid expenses560 M604 M735 M1,448 M2,037 M2,539 M2,872 M2,531 M2,947 M5,541 M
Raw materials315 M403 M435 M489 M426 M425 M651 M717 M802 M1,630 M
RecievablesAdjustmentsAllowances-55 M-44 M-40 M-39 M-24 M-22 M-26 M-22 M-16 M-15 M
Retained earnings12,491 M11,431 M10,772 M8,176 M5,667 M-1,603 M1,334 M4,615 M6,198 M5,985 M
SecuritySoldNotYetRepurchased600 M300 M
Short term debt2,689 M6 M1,937 M3,707 M1,102 M1,499 M9 M1,538 M1,501 M6,905 M
Total assets36,308 M35,569 M38,806 M44,981 M43,908 M39,286 M46,633 M48,806 M49,490 M64,006 M
Total current assets11,928 M12,574 M15,101 M19,202 M28,548 M13,710 M17,462 M18,452 M18,035 M25,727 M
Total current liabilities7,672 M8,230 M7,072 M10,071 M11,888 M6,842 M12,482 M15,053 M17,138 M27,293 M
Total equity15,373 M14,571 M14,011 M11,595 M9,829 M2,610 M5,645 M8,982 M10,650 M10,772 M
Total liabilities20,920 M20,979 M24,725 M33,313 M32,999 M36,587 M40,808 M39,651 M38,714 M53,143 M
Total non-current assets24,379 M22,995 M23,705 M25,779 M23,889 M25,577 M29,171 M30,354 M31,455 M38,279 M
Total non-current liabilities13,247 M12,749 M17,654 M23,242 M21,111 M29,745 M28,326 M24,599 M21,576 M25,849 M
TotalEquityGrossMinority15,388 M14,590 M14,084 M11,671 M10,909 M2,702 M5,828 M9,158 M10,775 M10,864 M
TotalEquityGrossMinorityInterest15,388 M14,590 M14,084 M11,671 M10,909 M2,702 M5,828 M9,158 M10,775 M10,864 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest36,308 M35,569 M38,809 M44,984 M43,908 M39,286 M46,633 M48,806 M49,490 M64,006 M
TotalNonCurrentLiabilitiesNetMinorityInteres13,247 M12,749 M17,654 M23,242 M21,111 M29,745 M28,326 M24,599 M21,576 M25,849 M
TotalTaxPayable94 M359 M119 M533 M393 M161 M495 M127 M475 M
Treasury stock-91 M-90 M-80 M-76 M-69 M-61 M-56 M-53 M-50 M-44 M
Work in progress1,715 M2,058 M2,117 M2,698 M2,058 M2,068 M2,535 M2,373 M2,598 M3,249 M
Working capital4,256 M4,344 M8,030 M9,131 M16,660 M6,868 M4,981 M3,400 M896 M-1,566 M
debtc2,689 M6 M1,937 M3,707 M1,102 M1,499 M9 M1,538 M1,501 M6,905 M
ltinv4,569 M3,647 M5,208 M5,679 M2,005 M1,962 M2,967 M3,213 M2,902 M3,052 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