Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Bristol-Myers Squibb Company logo

Bristol-Myers Squibb Company

Sector: Healthcare   

Industry: Drug Manufacturers - Major

48.30
 
USD
  
0.46
  
(0.96%)
Optionable: Yes  Market Cap: 97,591 M  90-day average vol: 15,655,496

Previous close: 47.84  Open: 47.93  Bid: 48.02  Ask: 48.3
52 week range    
47.58   
   70.94
Peers   
PFE / 
MRK / 
LLY / 
NVS / 
SNY / 
AZN / 
ABBV / 
JNJ / 
ABT / 
Last updated: Friday 19th April 2024
47
MarketXLS Rank
80
Value
23
Technical
39
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

BMY Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""590 M139 M992 M987 M1,703 M3,346 M2,340 M4,948 M4,264 M3,119 M
Accounts payable2,487 M1,565 M1,664 M2,248 M1,892 M2,445 M2,713 M2,949 M3,040 M3,259 M
Accounts receivable2,193 M3,070 M3,948 M4,599 M4,914 M6,888 M7,882 M8,723 M8,848 M9,551 M
Accrued expenses5,853 M6,875 M7,087 M8,493 M1,892 M2,445 M2,713 M2,949 M3,040 M3,259 M
Accumulated depreciation & depletion-4,649 M-4,219 M-4,193 M-3,986 M-3,818 M-3,955 M-3,585 M-4,033 M-4,164 M-4,803 M
Additional paid in capital1,507 M1,459 M1,725 M1,898 M2,081 M43,709 M44,325 M44,361 M45,165 M45,684 M
Building & improvements4,515 M4,930 M4,848 M5,231 M6,336 M5,732 M5,897 M5,920 M6,495 M
Cash and equivalents5,571 M2,385 M4,237 M5,421 M6,911 M12,346 M14,546 M13,979 M9,123 M11,464 M
CashCashEquivalentsAndShortTermInvestments7,435 M4,270 M6,350 M6,812 M8,759 M15,393 M15,831 M16,966 M9,253 M12,280 M
CashEquivalents5,571 M2,385 M4,237 M5,421 M140 M
CommercialPaper299 M
Common par221 M221 M221 M221 M221 M292 M292 M292 M292 M292 M
Common stock equity14,852 M14,266 M16,177 M11,741 M14,031 M51,598 M37,822 M35,946 M31,061 M29,430 M
CommonStock221 M221 M221 M221 M221 M292 M292 M292 M292 M292 M
Construction in progress662 M849 M980 M548 M527 M487 M764 M1,053 M1,075 M
Cost in excess7,027 M6,881 M6,875 M6,863 M6,538 M22,488 M20,547 M20,502 M21,149 M21,169 M
CurrentAccruedExpenses2,459 M4,738 M5,271 M6,014 M6,489 M
CurrentCapitalLeaseObligation100 M133 M164 M169 M136 M162 M
CurrentDeferredAssets1,644 M
CurrentDeferredRevenue1,167 M1,003 M762 M83 M172 M
CurrentDeferredTaxesAssets1,644 M4,058 M4,273 M2,319 M1,585 M2,086 M3,542 M2,696 M4,145 M7,334 M
CurrentDeferredTaxesLiabilities2,488 M2,813 M2,949 M1,565 M814 M-8,030 M-7,788 M-5,758 M-4,967 M-4,904 M
Deferred revenues1,167 M1,003 M762 M83 M172 M
DefinedPensionBenefit7,001 M6,363 M6,381 M7,114 M6,461 M2,934 M3,200 M2,900 M2,027 M2,212 M
DividendsPayable645 M655 M660 M654 M669 M1,025 M1,129 M1,186 M1,196 M1,213 M
EmployeeBenefits1,115 M949 M
Finished goods500 M381 M310 M384 M356 M2,227 M932 M543 M509 M663 M
Float term debt7,242 M6,550 M5,716 M6,975 M5,646 M43,387 M48,336 M39,605 M35,056 M36,653 M
GoodwillAndOtherIntangibleAssets8,780 M8,300 M8,260 M8,073 M7,629 M86,457 M73,790 M63,029 M57,008 M48,241 M
Gross fixed assets (Plant Property & Equipment)9,066 M8,631 M9,173 M8,987 M8,845 M10,207 M9,471 M10,082 M10,419 M11,449 M
IncomeTaxPayable262 M572 M152 M231 M398 M1,517 M647 M754 M942 M1,371 M
Intangibles1,753 M1,419 M1,385 M1,210 M1,091 M63,969 M53,243 M42,527 M35,859 M27,072 M
InterestPayable203 M184 M167 M196 M183 M656 M1,420 M1,334 M1,232 M1,166 M
Inventories1,560 M1,221 M1,241 M1,166 M1,195 M4,293 M2,074 M2,095 M2,339 M2,662 M
Invested capital29,336 M27,366 M27,609 M25,691 M25,323 M138,372 M134,494 M115,156 M101,173 M102,736 M
Land & improvements107 M107 M100 M104 M187 M189 M169 M162 M162 M
LongTermCapitalLeaseObligation966 M997 M1,043 M1,397 M2,130 M
LongTermDebtAndCapitalLeaseObligation7,242 M6,550 M5,716 M6,975 M5,646 M43,387 M48,336 M39,605 M35,056 M36,653 M
LongTermProvisions12 M12 M4 M7 M14 M
Machinery furniture & equipment3,347 M3,287 M3,059 M2,962 M3,157 M3,063 M3,252 M3,284 M3,717 M
Minority interest131 M158 M170 M106 M96 M100 M60 M60 M57 M55 M
Net fixed assets (net PP&E)4,417 M4,412 M4,980 M5,001 M5,027 M6,252 M5,886 M6,049 M6,255 M6,646 M
NetOtherUnrealizedGainLoss-2,181 M-2,080 M-2,097 M-1,883 M-2,102 M-899 M-976 M-768 M-623 M-738 M
NetUnrealizedGainLossForeignCurrency-360 M-399 M-437 M-419 M-681 M-646 M-639 M-680 M-890 M-812 M
NetUnrealizedGainLossInvestments31 M-23 M-7 M32 M-30 M6 M11 M2 M2 M
Non-current deferred income taxes-832 M-802 M-855 M-527 M19 M6,454 M5,407 M4,501 M2,166 M338 M
NonCurrentAccountsReceivable436 M
NonCurrentAccruedExpenses560 M742 M973 M3,548 M3,024 M5,368 M5,017 M4,835 M3,992 M3,288 M
NonCurrentDeferredAssets915 M2,844 M2,996 M1,610 M815 M510 M1,161 M1,439 M1,344 M2,768 M
NonCurrentDeferredLiabilities770 M586 M547 M454 M19 M6,454 M5,407 M4,501 M2,166 M338 M
NonCurrentDeferredRevenue770 M586 M547 M454 M468 M424 M357 M326 M283 M300 M
NonCurrentDeferredTaxesAssets915 M2,844 M2,996 M1,610 M815 M510 M1,161 M1,439 M1,344 M2,768 M
NonCurrentPensionAndOtherPostretirementBenefitPlans1,115 M949 M-566 M-725 M-899 M-654 M-402 M-480 M
Number of employees34300.034300.034300.034300.034300.034300.034300.034300.034300.034300.0
Other current assets579 M625 M570 M576 M2,015 M1,983 M3,786 M4,832 M5,795 M5,907 M
Other equity adjustments-2,425 M-2,468 M-2,503 M-2,289 M
Other fixed assets4,417 M4,412 M4,980 M5,001 M5,027 M6,252 M5,886 M6,049 M6,255 M6,646 M
Other non-current assets621 M1,117 M1,048 M1,533 M2,024 M6,604 M7,019 M5,535 M4,940 M5,370 M
Other non-current liabilities618 M1,429 M1,283 M1,164 M4,540 M10,101 M7,776 M7,334 M6,590 M6,421 M
Other receivable3,390 M4,299 M5,543 M6,300 M5,747 M7,685 M8,501 M9,369 M9,886 M10,921 M
OtherCurrentBorrowings590 M139 M992 M987 M1,703 M3,346 M2,340 M4,948 M4,264 M3,119 M
OtherCurrentLiabilities851 M904 M818 M869 M7,059 M12,513 M14,027 M13,971 M14,586 M15,884 M
OtherEquityInterest-899 M-768 M
OtherInventories1,560 M1,221 M1,241 M1,166 M1,195 M4,293 M2,074 M2,095 M2,339 M2,662 M
OtherPayable1,246 M24,777 M13,084 M300 M
Payables3,394 M2,137 M1,816 M2,479 M1,892 M2,445 M2,713 M2,949 M3,040 M3,259 M
Preferred securities of subsidiary trust50 M50 M
PreferredStock50 M50 M
Prepaid expenses484 M774 M819 M1,799 M2,786 M3,547 M3,927 M
Raw materials204 M199 M264 M273 M116 M172 M207 M350 M464 M475 M
RecievablesAdjustmentsAllowances-93 M-25 M-48 M-43 M-33 M-21 M-18 M-21 M-22 M-23 M
Restricted cash474 M89 M140 M148 M55 M
Retained earnings30,116 M29,145 M31,010 M28,871 M31,303 M32,954 M19,442 M22,552 M24,222 M27,220 M
Short term debt590 M139 M992 M987 M1,703 M3,346 M2,340 M4,948 M4,264 M3,119 M
TaxesReceivable178 M182 M627 M691 M
Total assets33,749 M31,748 M33,707 M33,551 M34,986 M129,944 M118,481 M109,314 M96,820 M95,159 M
Total current assets14,608 M10,415 M13,704 M14,854 M17,716 M29,354 M30,192 M33,262 M27,273 M31,770 M
Total current liabilities8,461 M8,017 M8,841 M9,563 M10,654 M18,304 M19,080 M21,868 M21,890 M22,262 M
Total equity14,852 M14,266 M16,177 M11,741 M14,031 M51,598 M37,822 M35,946 M31,061 M29,430 M
Total liabilities18,766 M17,324 M17,360 M21,704 M20,859 M78,246 M80,599 M73,308 M65,702 M65,674 M
Total non-current assets19,141 M21,333 M20,003 M18,697 M17,270 M100,590 M88,289 M76,052 M69,547 M63,389 M
Total non-current liabilities10,305 M9,307 M8,519 M12,141 M10,205 M59,942 M61,519 M51,440 M43,812 M43,412 M
TotalEquityGrossMinority14,983 M14,424 M16,347 M11,847 M14,127 M51,698 M37,882 M36,006 M31,118 M29,485 M
TotalEquityGrossMinorityInterest14,983 M14,424 M16,347 M11,847 M14,127 M51,698 M37,882 M36,006 M31,118 M29,485 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest33,749 M31,748 M33,707 M33,551 M34,986 M129,944 M118,481 M109,314 M96,820 M95,159 M
TotalNonCurrentLiabilitiesNetMinorityInteres10,305 M9,307 M8,519 M12,141 M10,205 M59,942 M61,519 M51,440 M43,812 M43,412 M
TotalTaxPayable262 M572 M152 M231 M398 M
Treasury stock-16,992 M-16,559 M-16,779 M-19,249 M-19,574 M-25,357 M-26,237 M-31,259 M-38,618 M-43,766 M
UnearnedPremiums1,914 M1,755 M1,408 M924 M872 M
Work in progress856 M868 M988 M931 M1,152 M3,267 M2,015 M2,111 M1,850 M2,430 M
Working capital6,147 M2,398 M4,863 M5,291 M7,062 M11,050 M11,112 M11,394 M5,383 M9,508 M
ltinv4,408 M4,660 M2,719 M2,480 M1,775 M767 M433 M666 M546 M364 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