Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)

LLY

NYE
Eli Lilly and Company
HealthcareDrug Manufacturers - Major
Watchlist:
Last updated: Friday 4th July 2025
780.67
+1.39 (0.18%)
Prev Close:779.28
Open:780.46
Bid:776.0
Ask:780.0
52 Week Range
677.09
972.53
Volume:3,974,024
Mkt Cap:735,348 M
Price Target
$897.77
+15.0%
Financials

Financial Statements

LLY - Balance Sheet (Annual)

Dec-24Dec-23Dec-22Dec-21Dec-20Dec-19Dec-18Dec-17Dec-16Dec-15
Accounts Payable3,229 M2,599 M1,931 M1,671 M1,607 M1,405 M1,207 M1,411 M1,349 M1,338 M
Accumulated Depreciation & Depletion-11,789 M-11,099 M-10,233 M-9,977 M-9,571 M-9,162 M-8,667 M-9,265 M-8,525 M-8,607 M
Cash And Equivalents3,268 M2,819 M2,067 M3,819 M3,657 M2,338 M15,319 M6,536 M4,582 M3,666 M
Cash Cash Equivalents And Short Term Investments3,423 M2,928 M2,212 M3,909 M3,681 M2,439 M15,407 M8,034 M6,039 M4,452 M
Cash Equivalents2,338 M7,998 M6,536 M4,582 M3,666 M
Commercial Paper-1,498 M-1,494 M-499 M-2,697 M-1,299 M
Common Stock-2,418 M-2,416 M-2,416 M-2,414 M-2,412 M-2,411 M-2,352 M-2,322 M-2,321 M-2,322 M
Current Accrued Expenses958 M997 M916 M1,055 M998 M897 M967 M
Current Capital Lease Obligation156 M131 M135 M
Current Deferred Taxes Assets11,459 M9,396 M7,285 M5,787 M5,802 M4,990 M4,338 M2,539 M2,961 M2,947 M
Current Deferred Taxes Liabilities-3,533 M-4,022 M-4,579 M-5,031 M-5,071 M-4,605 M-3,037 M-1,541 M-3,176 M2,656 M
Defined Pension Benefit15,170 M12,570 M13,900 M11,490 M10,750 M
Dividends Payable1,346 M1,169 M1,017 M886 M771 M672 M651 M591 M548 M539 M
Employee Benefits1,301 M1,439 M1,305 M1,954 M4,095 M3,698 M2,802 M3,514 M2,454 M2,160 M
Float Term Debt28,527 M18,321 M14,738 M15,346 M16,587 M13,818 M9,196 M9,941 M8,368 M7,972 M
Goodwill And Other Intangible Assets11,937 M11,846 M11,280 M11,584 M11,217 M10,297 M2,435 M8,399 M8,331 M9,075 M
Income Tax Payable475 M127 M495 M161 M393 M533 M119 M359 M
Interest Payable340 M360 M401 M243 M225 M185 M161 M
Inventories Adjustments Allowances-340 M
Land & Improvements382 M320 M257 M259 M227 M170 M166 M193 M198 M221 M
Line Of Credit7,330 M5,260 M5,240 M5,210 M6,170 M6 M2,870 M1,300 M
Long Term Capital Lease Obligation823 M776 M761 M487 M
Long Term Debt And Capital Lease Obligation28,527 M18,321 M14,738 M15,346 M16,587 M13,818 M9,196 M9,941 M8,368 M7,972 M
Minority Interest80 M92 M126 M176 M184 M92 M1,080 M76 M73 M19 M
Net Other Unrealized Gain Loss48 M34 M53 M
Non Current Accrued Expenses4,061 M3,849 M3,710 M3,920 M3,838 M3,607 M3,700 M3,777 M689 M869 M
Non Current Deferred Assets8,001 M5,477 M2,793 M2,489 M2,830 M2,573 M2,614 M1,166 M
Non Current Deferred Liabilities87 M1,734 M2,100 M2,188 M1,313 M
Non Current Deferred Taxes Assets8,001 M5,477 M2,793 M2,489 M2,830 M2,573 M2,614 M1,166 M3,609 M3,538 M
Non Current Pension And Other Postretirement Benefit Plans1,301 M1,439 M1,305 M1,954 M4,095 M3,698 M2,802 M3,514 M2,454 M2,160 M
Notes Payable14,815 M16,741 M16,349 M13,639 M9,641 M10,757 M8,777 M7,700 M
Other Current Borrowings5,117 M6,905 M1,501 M1,538 M9 M1,499 M1,102 M3,707 M1,937 M6 M
Other Current Liabilities7,145 M4,932 M12,689 M10,831 M9,601 M3,105 M8,535 M3,830 M3,118 M5,987 M
Other Inventories7,589 M5,773 M4,310 M3,886 M3,980 M3,191 M3,098 M4,458 M3,562 M3,446 M
Other Payable327 M747 M849 M240 M45 M5,283 M
Payables4,575 M3,768 M2,948 M2,683 M2,872 M2,237 M2,251 M2,534 M2,017 M2,236 M
Preferred Stock5 M5 M5 M5 M5 M
Raw Materials802 M717 M651 M425 M426 M489 M435 M403 M
Recievables Adjustments Allowances-15 M-15 M-16 M-22 M-26 M-22 M-24 M-39 M-40 M-44 M
Retained Earnings9,223 M5,985 M6,198 M4,615 M1,334 M-1,603 M5,667 M8,176 M10,772 M11,431 M
Security Sold Not Yet Repurchased300 M600 M
Total Capitalization71,246 M47,414 M40,125 M39,675 M38,818 M30,246 M28,222 M31,476 M30,747 M30,516 M
Total Equity Gross Minority14,272 M10,864 M10,775 M9,158 M5,828 M2,702 M10,909 M11,671 M14,084 M14,590 M
Total Equity Gross Minority Interest14,272 M10,864 M10,775 M9,158 M5,828 M2,702 M10,909 M11,671 M14,084 M14,590 M
Total Liabilities And Total Equity Gross Minority Interest78,715 M64,006 M49,490 M48,806 M46,633 M39,286 M43,908 M44,984 M38,809 M35,569 M
Total Non Current Liabilities Net Minority Interes36,067 M25,849 M21,576 M24,599 M28,326 M29,745 M21,111 M23,242 M17,654 M12,749 M
Total Tax Payable475 M127 M495 M161 M393 M533 M119 M359 M
Working Capital4,363 M-1,566 M896 M3,400 M4,981 M6,868 M16,660 M9,131 M8,030 M4,344 M
Accrec11,006 M9,091 M6,896 M6,673 M5,875 M4,547 M4,594 M4,546 M4,029 M4,072 M
Addpaid7,439 M7,250 M6,921 M6,833 M6,779 M6,685 M6,584 M5,818 M5,641 M5,552 M
Build8,807 M8,280 M7,916 M7,588 M7,326 M7,067 M7,117 M7,426 M6,918 M6,787 M
Capstk-2,418 M-2,416 M-2,416 M-2,414 M-2,412 M-2,411 M-2,352 M-2,322 M-2,321 M-2,322 M
Comstkeqty14,192 M10,772 M10,650 M8,982 M5,645 M2,610 M9,829 M11,595 M14,011 M14,571 M
Constr8,245 M5,084 M2,799 M2,178 M2,139 M1,884 M1,589 M1,784 M1,798 M1,665 M
Curdebt5,117 M6,905 M1,501 M1,538 M9 M1,499 M1,102 M3,707 M1,937 M6 M
Curdebtcaplease5,117 M6,905 M1,501 M1,538 M9 M1,499 M1,102 M3,707 M1,937 M6 M
Fingds901 M762 M759 M647 M578 M1,211 M987 M1,053 M
Gainlossnoearn-4,343 M-6,496 M-6,524 M-5,729 M-5,719 M-5,274 M-4,581 M
Goodwill5,770 M4,940 M4,073 M3,892 M3,767 M3,679 M1,367 M4,370 M3,973 M4,040 M
Grosppe28,891 M24,013 M20,377 M18,962 M18,253 M17,035 M17,193 M18,091 M16,778 M16,661 M
Inv7,589 M5,773 M4,310 M3,886 M3,980 M3,191 M3,098 M4,458 M3,562 M3,446 M
Invadv3,216 M3,052 M2,902 M3,213 M2,967 M1,962 M2,005 M5,679 M5,208 M3,647 M
Mach11,458 M10,329 M9,406 M8,937 M8,561 M7,913 M7,792 M8,689 M7,865 M7,989 M
Netppe17,102 M12,914 M10,144 M8,985 M8,682 M7,873 M8,526 M8,827 M8,253 M8,054 M
Noncurdefliab-433 M1,734 M2,100 M2,188 M1,313 M-282 M-399 M-412 M
Othca111 M150 M7 M2,798 M2,552 M2,109 M2,229 M1,015 M853 M1,067 M
Othintang6,166 M6,907 M7,207 M7,692 M7,450 M6,618 M1,068 M4,029 M4,358 M5,035 M
Othnca5,720 M4,990 M4,337 M4,083 M3,475 M2,871 M8,309 M1,708 M1,914 M2,221 M
Othncl13,718 M13,930 M1,824 M1,644 M1,708 M6,435 M1,358 M6,011 M6,143 M1,747 M
Othprop17,102 M12,914 M10,144 M8,985 M8,682 M7,873 M8,526 M8,827 M8,253 M8,054 M
Othrec2,270 M2,246 M1,663 M1,454 M1,054 M994 M1,183 M716 M737 M
Payacc4,575 M3,768 M2,948 M2,683 M2,872 M2,237 M2,251 M2,534 M2,017 M2,236 M
Prepaid8,341 M5,541 M2,947 M2,531 M2,872 M2,539 M2,037 M1,448 M735 M604 M
Totassets78,715 M64,006 M49,490 M48,806 M46,633 M39,286 M43,908 M44,981 M38,806 M35,569 M
Totca32,740 M25,727 M18,035 M18,452 M17,462 M13,710 M28,548 M19,202 M15,101 M12,574 M
Totcl28,377 M27,293 M17,138 M15,053 M12,482 M6,842 M11,888 M10,071 M7,072 M8,230 M
Toteqty14,192 M10,772 M10,650 M8,982 M5,645 M2,610 M9,829 M11,595 M14,011 M14,571 M
Totliab64,443 M53,143 M38,714 M39,651 M40,808 M36,587 M32,999 M33,313 M24,725 M20,979 M
Totnca45,975 M38,279 M31,455 M30,354 M29,171 M25,577 M23,889 M25,779 M23,705 M22,995 M
Totncl36,067 M25,849 M21,576 M24,599 M28,326 M29,745 M21,111 M23,242 M17,654 M12,749 M
Treastk-49 M-44 M-50 M-53 M-56 M-61 M-69 M-76 M-80 M-90 M
Trustpref5 M5 M5 M5 M5 M
Wip2,598 M2,373 M2,535 M2,068 M2,058 M2,698 M2,117 M2,058 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