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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

TEVA Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""1,761 M1,585 M3,276 M3,646 M2,216 M2,345 M3,188 M1,426 M2,109 M1,672 M
Accounts payable1,718 M1,756 M1,686 M1,887 M2,602 M
Accounts receivable5,408 M5,350 M7,523 M7,128 M5,822 M5,676 M4,581 M4,529 M3,696 M3,408 M
Accrued expenses3,171 M1,918 M2,157 M2,069 M2,723 M1,718 M1,756 M1,686 M1,887 M2,602 M
Accumulated depreciation & depletion-3,345 M-3,529 M-3,853 M-17,100 M-4,928 M-4,914 M-5,092 M-5,241 M-5,518 M-5,637 M
Additional paid in capital14,121 M17,757 M23,409 M23,479 M27,210 M27,312 M27,443 M27,561 M27,688 M27,807 M
Building & improvements2,653 M2,591 M3,331 M3,329 M3,133 M2,839 M2,720 M2,568 M2,463 M2,488 M
Cash and equivalents2,226 M6,946 M988 M963 M1,782 M1,975 M2,177 M2,165 M2,801 M3,226 M
CashCashEquivalentsAndShortTermInvestments2,226 M6,946 M988 M963 M1,782 M1,975 M2,177 M2,165 M2,801 M3,226 M
CashEquivalents2,226 M6,946 M988 M963 M1,782 M1,975 M2,177 M
Common par50 M3,343 M3,674 M3,685 M56 M56 M57 M57 M57 M57 M
Common stock equity23,313 M29,769 M33,337 M17,359 M14,707 M20,131 M14,851 M10,278 M7,804 M7,506 M
CommonStock50 M52 M54 M54 M56 M56 M57 M57 M57 M57 M
Cost in excess18,408 M19,025 M44,409 M28,414 M24,917 M24,846 M20,624 M20,040 M17,633 M17,177 M
CurrentAccruedExpenses870 M693 M685 M
CurrentCapitalLeaseObligation139 M141 M0.0160 M435 M479 M416 M349 M320 M
CurrentDeferredAssets993 M735 M
CurrentDeferredTaxesAssets993 M735 M
CurrentDeferredTaxesLiabilities1,098 M1,900 M5,569 M3,132 M2,282 M-1,733 M-1,064 M-814 M910 M1,206 M
DeferredFinancingCosts-103 M-86 M-100 M-78 M-80 M
DefinedPensionBenefit188 M157 M197 M182 M146 M165 M192 M142 M58 M73 M
Finished goods2,268 M2,050 M2,832 M2,689 M2,665 M2,504 M2,378 M1,932 M1,987 M2,346 M
Float term debt8,566 M8,358 M32,524 M28,829 M26,700 M24,997 M23,210 M22,033 M19,452 M18,481 M
GoodwillAndOtherIntangibleAssets23,920 M26,700 M65,896 M46,054 M38,922 M36,078 M29,547 M27,506 M23,903 M22,564 M
Gross fixed assets (Plant Property & Equipment)9,880 M10,073 M11,926 M24,773 M11,796 M11,864 M11,947 M11,718 M11,676 M11,784 M
Intangibles5,512 M7,675 M21,487 M17,640 M14,005 M11,232 M8,923 M7,466 M6,270 M5,387 M
InterestPayable300 M270 M546 M875 M920 M881 M901 M891 M930 M1,029 M
Inventories4,371 M3,966 M4,954 M4,924 M4,731 M4,422 M4,403 M3,818 M3,833 M4,021 M
InventoriesAdjustmentsAllowances-4,200 M
Invested capital31,879 M39,452 M0.046,188 M41,407 M69,690 M60,792 M53,928 M46,359 M44,148 M
Land & improvements372 M394 M439 M390 M351 M323 M292 M262 M246 M246 M
Leases29 M32 M29 M32 M
LongTermCapitalLeaseObligation905 M435 M479 M416 M349 M320 M
LongTermDebtAndCapitalLeaseObligation8,566 M8,358 M32,524 M28,829 M26,700 M24,997 M23,210 M22,033 M19,452 M18,481 M
Machinery furniture & equipment4,893 M5,071 M5,748 M5,809 M5,658 M5,385 M5,245 M5,098 M5,026 M4,807 M
Minority interest42 M158 M1,656 M1,386 M1,087 M1,091 M1,035 M966 M794 M620 M
Net fixed assets (net PP&E)6,535 M6,544 M8,073 M7,673 M6,868 M6,950 M6,855 M6,477 M6,158 M6,147 M
NetOtherUnrealizedGainLoss11 M7 M18 M25 M
Non-current deferred income taxes1,101 M1,748 M5,413 M3,277 M2,140 M1,096 M964 M784 M548 M606 M
NonCurrentAccruedExpenses1,681 M3,405 M3,014 M1,868 M1,869 M1,780 M2,208 M2,151 M2,771 M
NonCurrentDeferredAssets368 M386 M695 M596 M1,458 M1,812 M
NonCurrentDeferredLiabilities1,101 M1,748 M5,413 M3,277 M2,140 M1,096 M964 M784 M548 M606 M
NonCurrentDeferredTaxesAssets229 M89 M-4,788 M-2,703 M368 M386 M695 M596 M1,458 M1,812 M
Notes payable1,401 M1,163 M6,158 M3,426 M
Number of employees37537.037537.037537.037537.037537.037537.037537.037537.037537.037537.0
Other current assets1,398 M1,401 M3,763 M2,367 M560 M521 M899 M984 M559 M574 M
Other equity adjustments5,849 M6,601 M7,839 M7,881 M6,711 M6,159 M4,824 M4,241 M3,750 M3,535 M
Other fixed assets1,391 M1,492 M1,774 M2,016 M2,089 M6,950 M6,855 M6,477 M6,158 M6,147 M
Other non-current assets1,569 M2,341 M1,235 M932 M731 M591 M538 M515 M441 M470 M
Other non-current liabilities1,109 M1,195 M1,639 M2,430 M1,727 M2,640 M2,240 M2,578 M3,945 M4,019 M
Other receivable585 M445 M621 M799 M18,271 M16,887 M16,659 M15,878 M14,925 M15,846 M
OtherCurrentBorrowings1,761 M1,585 M3,276 M3,646 M2,216 M2,345 M3,188 M1,426 M2,109 M1,672 M
OtherCurrentLiabilities1,508 M1,220 M1,811 M724 M804 M1,582 M1,618 M1,466 M1,571 M1,667 M
OtherEquityInterest40 M312 M-2,769 M-1,316 M
OtherInventories4,422 M4,403 M3,818 M3,833 M4,021 M
OtherPayable3,171 M1,918 M2,157 M2,069 M1,853 M1,718 M
Payables3,171 M1,918 M2,157 M2,069 M1,853 M1,718 M1,756 M1,686 M1,887 M2,602 M
Preferred securities of subsidiary trust3,291 M3,620 M3,631 M
PreferredStock3,291 M3,620 M3,631 M
Prepaid expenses899 M870 M945 M1,075 M1,162 M1,255 M
Raw materials1,279 M1,195 M1,385 M1,454 M1,328 M1,183 M1,231 M1,136 M1,059 M993 M
RecievablesAdjustmentsAllowances-146 M-191 M-232 M-232 M-135 M-126 M-90 M-91 M-95 M
Restricted cash33 M33 M
Retained earnings14,436 M14,851 M13,607 M-3,803 M-5,958 M-9,268 M-13,345 M-13,212 M-15,813 M-16,231 M
SecuritySoldNotYetRepurchased500 M439 M
Short term debt1,761 M1,585 M3,276 M3,646 M2,216 M2,345 M3,188 M1,426 M2,109 M1,672 M
Total assets46,420 M54,233 M93,057 M70,615 M60,683 M57,469 M50,640 M47,666 M44,011 M43,479 M
Total current assets14,396 M18,398 M17,228 M15,382 M13,794 M13,464 M13,005 M12,573 M12,051 M12,485 M
Total current liabilities12,289 M13,005 M18,488 M17,921 M14,322 M5,645 M6,562 M11,027 M11,469 M12,247 M
Total equity23,313 M29,769 M33,337 M17,359 M14,707 M20,131 M14,851 M10,278 M7,804 M7,506 M
Total liabilities23,065 M24,306 M58,064 M51,870 M44,889 M36,247 M34,756 M36,422 M35,413 M35,353 M
Total non-current assets32,024 M35,835 M75,829 M55,233 M46,889 M44,005 M37,635 M35,094 M31,960 M30,993 M
Total non-current liabilities10,776 M11,301 M39,576 M33,949 M30,567 M30,602 M28,194 M25,395 M23,944 M23,106 M
TotalEquityGrossMinority23,355 M29,927 M34,993 M18,745 M15,794 M21,222 M15,886 M11,244 M8,598 M8,126 M
TotalEquityGrossMinorityInterest23,355 M29,927 M34,993 M18,745 M15,794 M21,222 M15,886 M11,244 M8,598 M8,126 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest46,420 M54,233 M93,057 M70,615 M60,683 M57,469 M50,642 M47,666 M44,011 M43,479 M
TotalNonCurrentLiabilitiesNetMinorityInteres10,776 M11,301 M39,576 M33,949 M30,567 M30,602 M28,194 M25,395 M23,944 M23,106 M
Treasury stock-3,951 M-4,227 M-4,194 M-4,149 M-4,142 M-4,128 M-4,128 M-4,128 M-4,128 M-4,128 M
UnearnedIncome250 M625 M574 M
UnrealizedGainLoss5,849 M6,601 M7,839 M7,881 M6,711 M6,159 M4,824 M4,241 M3,750 M3,535 M
Work in progress638 M535 M538 M597 M590 M583 M605 M587 M555 M500 M
Working capital2,107 M5,393 M-1,260 M-2,539 M-528 M7,819 M6,443 M1,546 M582 M238 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