Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
AbbVie Inc. logo

AbbVie Inc.

Sector: Healthcare   

Industry: Drug Manufacturers - Major

169.54
 
USD
  
1.65
  
(0.98%)
Optionable: Yes  Market Cap: 287,123 M  90-day average vol: 5,608,385

Previous close: 167.89  Open: 168.59  Bid: 169.54  Ask: 170.55
52 week range    
130.96   
   182.89
Peers   
PFE / 
BMY / 
LLY / 
AMGN / 
GILD / 
BIIB / 
GSK / 
AZN / 
Last updated: Wednesday 24th April 2024
55
MarketXLS Rank
60
Value
46
Technical
60
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

ABBV Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""4,439 M2,431 M402 M6,415 M5,308 M3,753 M8,502 M12,495 M4,136 M7,191 M
Accounts payable6,954 M8,463 M9,379 M10,226 M11,931 M11,832 M20,159 M22,699 M25,402 M30,650 M
Accounts receivable3,735 M4,730 M4,758 M5,088 M5,384 M5,428 M8,822 M9,977 M11,254 M11,155 M
Accrued expenses6,954 M8,463 M9,379 M10,226 M11,931 M11,832 M20,159 M22,699 M25,402 M30,650 M
Accumulated depreciation & depletion-4,620 M-4,769 M-4,922 M-5,268 M-5,513 M-5,226 M-5,611 M-5,617 M-6,051 M-6,646 M
Additional paid in capital4,194 M13,080 M13,678 M14,270 M14,756 M15,193 M17,384 M18,305 M19,245 M20,180 M
Cash and equivalents8,348 M8,399 M5,100 M9,303 M7,289 M39,924 M8,449 M9,746 M9,201 M12,814 M
CashCashEquivalentsAndShortTermInvestments8,374 M8,407 M6,423 M9,789 M8,061 M39,924 M8,479 M9,830 M9,229 M12,816 M
CashEquivalents8,348 M8,399 M5,100 M9,303 M7,289 M39,924 M8,449 M9,746 M
Common par16 M17 M18 M18 M18 M18 M18 M18 M18 M18 M
Common stock equity1,742 M3,945 M4,636 M5,097 M-8,446 M-8,172 M13,076 M15,408 M17,254 M10,360 M
CommonStock16 M17 M18 M18 M18 M18 M18 M18 M18 M18 M
Cost in excess5,862 M13,168 M15,416 M15,785 M15,663 M15,604 M33,124 M32,379 M32,156 M32,293 M
CurrentCapitalLeaseObligation114 M119 M131 M143 M116 M28 M175 M178 M166 M166 M
CurrentDeferredTaxesAssets1,980 M2,369 M2,371 M1,924 M2,662 M2,786 M5,359 M5,188 M5,532 M6,458 M
CurrentDeferredTaxesLiabilities896 M-7,417 M-9,036 M-4,146 M-3,401 M-3,401 M-6,591 M-5,923 M-4,702 M-2,655 M
Deferred revenues896 M
DefinedPensionBenefit4,173 M4,800 M5,300 M6,300 M6,000 M7,600 M10,500 M10,500 M7,700 M8,600 M
DividendsPayable-2,806 M-3,431 M-3,823 M-4,221 M-6,045 M-6,533 M-8,278 M-9,470 M-10,179 M-10,647 M
Finished goods341 M469 M223 M610 M473 M485 M1,318 M932 M1,162 M1,356 M
Float term debt10,538 M29,240 M36,440 M30,953 M35,002 M62,975 M77,554 M64,189 M59,135 M52,194 M
GoodwillAndOtherIntangibleAssets1,513 M32,877 M44,313 M43,344 M36,896 M34,253 M116,000 M108,330 M99,595 M87,903 M
Gross fixed assets (Plant Property & Equipment)7,105 M7,334 M7,526 M8,071 M8,396 M8,188 M10,859 M10,727 M10,986 M11,635 M
Intangibles1,513 M19,709 M28,897 M27,559 M21,233 M18,649 M82,876 M75,951 M67,439 M55,610 M
InterestPayable429 M719 M1,047 M1,150 M1,348 M1,784 M2,454 M2,423 M2,230 M2,224 M
Inventories1,124 M1,719 M1,444 M1,605 M1,605 M1,813 M3,310 M3,128 M3,579 M4,099 M
Invested capital22,818 M62,425 M77,516 M67,003 M61,558 M117,778 M168,184 M143,786 M135,524 M114,748 M
Leases27 M33 M25 M35 M
LongTermCapitalLeaseObligation14,586 M31,265 M36,465 M36,968 M36,611 M66,728 M832 M713 M754 M1,008 M
LongTermDebtAndCapitalLeaseObligation10,538 M29,240 M36,440 M30,953 M35,002 M62,975 M77,554 M64,189 M59,135 M52,194 M
Minority interest21 M28 M33 M37 M
Net fixed assets (net PP&E)2,485 M2,565 M2,604 M2,803 M2,883 M2,962 M5,248 M5,110 M4,935 M4,989 M
NetOtherUnrealizedGainLoss-9 M-8 M-11 M
Non-current deferred income taxes159 M5,276 M6,890 M2,490 M1,067 M1,130 M3,646 M3,009 M2,190 M1,952 M
NonCurrentAccruedExpenses4,675 M4,311 M3,453 M3,847 M3,442 M4,615 M3,988 M
NonCurrentDeferredLiabilities159 M5,276 M6,890 M2,490 M1,067 M1,130 M3,646 M3,009 M2,190 M1,952 M
NonCurrentDeferredRevenue2,378 M2,498 M
NonCurrentDeferredTaxesAssets2,152 M2,439 M2,447 M2,032 M2,765 M3,517 M6,562 M14,579 M15,159 M19,936 M
NonCurrentPensionAndOtherPostretirementBenefitPlans-2,220 M-1,949 M-2,085 M-2,740 M-1,840 M-2,949 M-3,413 M-3,153 M-1,638 M-1,538 M
Number of employees50000.050000.050000.050000.050000.050000.050000.050000.050000.050000.0
Other current assets421 M954 M1,168 M2,701 M2,852 M2,661 M5,264 M5,489 M5,670 M5,762 M
Other equity adjustments-2,031 M-2,561 M-2,586 M-2,727 M-2,480 M-3,596 M-3,117 M-2,899 M
Other fixed assets2,485 M2,565 M2,604 M2,803 M2,883 M2,962 M5,248 M5,110 M4,935 M4,989 M
Other non-current assets1,480 M1,149 M1,212 M1,326 M1,208 M2,288 M4,851 M4,884 M5,571 M8,513 M
Other non-current liabilities990 M844 M3,941 M4,266 M4,306 M17,597 M27,607 M28,701 M30,655 M32,327 M
Other receivable28,216 M32,753 M33,266 M45,804 M56,197 M58,054 M54,318 M
OtherCurrentBorrowings425 M406 M377 M400 M3,699 M34 M14 M1000000.0
OtherCurrentLiabilities3,681 M3,695 M8,352 M15,605 M14,490 M830 M1,669 M1,785 M1,469 M1,952 M
OtherInventories1,124 M1,719 M1,444 M1,605 M1,605 M1,813 M3,310 M3,128 M3,579 M4,099 M
OtherPayable622 M964 M262 M308 M736 M1,135 M1,350 M1,377 M-539 M-1,223 M
Payables6,954 M8,463 M9,379 M10,226 M11,931 M11,832 M20,159 M22,699 M25,402 M30,650 M
Preferred securities of subsidiary trust200 M200 M200 M200 M200 M200 M200 M200 M
PreferredStock200 M200 M200 M200 M200 M200 M200 M200 M
Prepaid expenses1,952 M1,458 M3,562 M4,741 M1,895 M2,354 M3,562 M4,993 M4,401 M4,932 M
Raw materials154 M169 M141 M173 M270 M386 M791 M1,003 M1,000 M1,100 M
RecievablesAdjustmentsAllowances-74 M-78 M-72 M-58 M-51 M-46 M-262 M
Retained earnings-1,496 M-313 M1,792 M2,732 M888 M1,121 M-2,062 M228 M2,585 M-3,305 M
Short term debt4,439 M2,431 M402 M6,415 M5,308 M3,753 M8,502 M12,495 M4,136 M7,191 M
TaxesReceivable556 M347 M2,100 M488 M
Total assets27,513 M53,050 M66,099 M70,786 M59,352 M89,115 M150,565 M146,529 M138,805 M134,711 M
Total current assets15,185 M16,314 M16,187 M21,223 M16,945 M49,519 M24,173 M27,928 M28,463 M33,002 M
Total current liabilities15,970 M14,589 M18,133 M32,246 M31,729 M15,585 M28,661 M35,194 M29,538 M37,841 M
Total equity1,742 M3,945 M4,636 M5,097 M-8,446 M-8,172 M13,076 M15,408 M17,254 M10,360 M
Total liabilities26,667 M49,105 M61,463 M65,689 M67,798 M97,287 M137,468 M131,093 M121,518 M124,314 M
Total non-current assets5,570 M36,736 M49,912 M49,563 M42,407 M39,596 M126,392 M118,601 M110,342 M101,709 M
Total non-current liabilities10,697 M34,516 M43,330 M33,443 M36,069 M81,702 M108,807 M95,899 M91,980 M86,473 M
TotalEquityGrossMinority1,742 M3,945 M4,636 M5,097 M-8,446 M-8,172 M13,097 M15,436 M17,287 M10,397 M
TotalEquityGrossMinorityInterest1,742 M3,945 M4,636 M5,097 M-8,446 M-8,172 M13,097 M15,436 M17,287 M10,397 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest28,409 M53,050 M66,099 M70,786 M59,352 M89,115 M150,565 M146,529 M138,805 M134,711 M
TotalNonCurrentLiabilitiesNetMinorityInteres10,697 M34,516 M43,330 M33,443 M36,069 M81,702 M108,807 M95,899 M91,980 M86,473 M
Treasury stock-972 M-8,839 M-10,852 M-11,923 M-24,108 M-24,504 M-2,264 M-3,143 M-4,594 M-6,533 M
Work in progress629 M1,081 M1,080 M822 M862 M942 M1,201 M1,193 M1,417 M1,643 M
Working capital-785 M1,725 M-1,946 M-11,023 M-14,784 M33,934 M-4,488 M-7,266 M-1,075 M-4,839 M
ltinv92 M145 M1,783 M2,090 M1,420 M93 M293 M277 M241 M304 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