Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Merck & Company Inc. (new) logo

Merck & Company Inc. (new)

Sector: Healthcare   

Industry: Drug Manufacturers - Major

130.72
 
USD
  
3.72
  
(2.93%)
Optionable: Yes  Market Cap: 321,342 M  90-day average vol: 8,431,073

Previous close: 127.0  Open: 129.69  Bid: 130.02  Ask: 130.54
52 week range    
99.14   
   133.10
Peers   
PFE / 
JNJ / 
BMY / 
LLY / 
SNY / 
GSK / 
TEVA / 
NVS / 
ABT / 
Last updated: Friday 26th April 2024
70
MarketXLS Rank
65
Value
84
Technical
63
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

MRK Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""2,704 M2,583 M568 M3,057 M5,308 M3,610 M6,431 M2,412 M1,946 M1,372 M
Accounts payable2,625 M2,533 M2,807 M3,102 M3,318 M3,738 M4,327 M4,609 M4,264 M3,922 M
Accounts receivable6,626 M6,484 M7,018 M6,873 M7,071 M6,778 M6,803 M9,230 M9,450 M10,349 M
Accrued expenses5,170 M5,402 M6,362 M5,130 M6,747 M6,061 M7,598 M7,601 M8,134 M8,556 M
Accumulated depreciation & depletion-18,004 M-15,923 M-15,749 M-16,602 M-16,324 M-17,686 M-18,162 M-18,192 M-17,985 M-18,266 M
Additional paid in capital40,423 M40,222 M39,939 M39,902 M38,808 M39,660 M39,588 M44,238 M44,379 M44,509 M
Building & improvements13,101 M12,154 M11,439 M11,726 M11,486 M11,989 M11,998 M12,529 M13,166 M14,966 M
Cash and equivalents7,441 M8,524 M6,515 M6,092 M7,965 M9,676 M8,050 M8,096 M12,694 M6,841 M
CashCashEquivalentsAndShortTermInvestments15,719 M13,427 M14,341 M8,498 M8,864 M10,450 M8,050 M8,096 M13,192 M7,093 M
CashEquivalents7,441 M8,524 M6,515 M6,092 M7,965 M9,676 M102 M
Common par1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M
Common stock equity119,171 M121,744 M121,180 M121,924 M128,559 M137,807 M138,891 M38,184 M45,991 M37,581 M
CommonStock1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M1,788 M
Construction in progress1,448 M1,525 M1,871 M2,301 M3,355 M5,013 M6,968 M8,313 M9,186 M8,262 M
Cost in excess12,992 M17,723 M18,162 M18,284 M18,253 M19,425 M18,882 M21,264 M21,204 M21,197 M
CurrentCapitalLeaseObligation232 M213 M200 M255 M188 M236 M291 M304 M281 M285 M
CurrentDeferredAssets5,257 M
CurrentDeferredTaxesAssets3,520 M2,952 M3,109 M1,995 M1,770 M2,251 M2,433 M2,270 M3,015 M3,937 M
CurrentDeferredTaxesLiabilities7,186 M8,879 M7,640 M3,641 M2,816 M3,001 M2,656 M5,019 M4,307 M2,840 M
DefinedPensionBenefit17,900 M16,700 M18,400 M20,500 M19,000 M22,800 M26,300 M24,900 M17,200 M
DividendsPayable1,308 M1,309 M1,316 M1,320 M1,458 M1,587 M1,674 M1,768 M1,884 M1,985 M
Finished goods1,588 M1,343 M1,304 M1,334 M1,658 M1,772 M1,610 M1,747 M1,841 M1,954 M
Float term debt18,699 M23,829 M24,274 M21,353 M19,806 M22,736 M25,360 M30,690 M28,745 M33,683 M
GoodwillAndOtherIntangibleAssets33,378 M40,325 M35,467 M32,467 M31,357 M33,621 M32,983 M44,197 M41,473 M39,208 M
Gross fixed assets (Plant Property & Equipment)31,140 M28,430 M27,775 M29,041 M29,615 M32,739 M35,162 M37,471 M39,407 M41,317 M
IncomeTaxPayable1,237 M1,560 M2,239 M708 M1,971 M736 M1,597 M1,224 M1,986 M2,649 M
Intangibles20,386 M22,602 M17,305 M14,183 M13,104 M14,196 M14,101 M22,933 M20,269 M18,011 M
InterestPayable-732 M-672 M-693 M-754 M-772 M-893 M-831 M-806 M-962 M-1,146 M
Inventories5,571 M4,700 M4,866 M5,096 M5,440 M5,978 M5,554 M5,953 M5,911 M6,358 M
Invested capital156,569 M169,402 M169,728 M164,630 M168,171 M183,279 M189,611 M99,564 M103,481 M104,947 M
Land & improvements541 M490 M412 M365 M333 M343 M336 M326 M295 M326 M
LongTermCapitalLeaseObligation21,400 M26,500 M24,800 M24,400 M25,100 M1,004 M1,626 M1,529 M1,294 M1,389 M
LongTermDebtAndCapitalLeaseObligation18,699 M23,829 M24,274 M21,353 M19,806 M22,736 M25,360 M30,690 M28,745 M33,683 M
Machinery furniture & equipment16,050 M14,261 M14,053 M14,649 M14,441 M15,394 M15,860 M16,303 M16,760 M17,763 M
Minority interest144 M91 M220 M233 M181 M94 M87 M73 M67 M54 M
Net fixed assets (net PP&E)13,136 M12,507 M12,026 M12,439 M13,291 M15,053 M17,000 M19,279 M21,422 M23,051 M
NetOtherUnrealizedGainLoss-26 M-64 M-68 M-85 M
NetUnrealizedGainLossInvestments741 M
Non-current deferred income taxes4,467 M6,535 M5,077 M2,219 M1,702 M1,470 M1,005 M3,441 M1,795 M871 M
NonCurrentAccountsReceivable80 M10 M
NonCurrentDeferredAssets5,533 M6,055 M5,854 M6,075 M5,881 M6,771 M9,881 M11,582 M9,528 M
NonCurrentDeferredLiabilities4,467 M6,535 M5,077 M2,219 M1,702 M1,470 M1,005 M3,441 M1,795 M871 M
NonCurrentDeferredTaxesAssets5,533 M6,055 M5,854 M6,075 M5,881 M6,771 M9,881 M11,582 M3,614 M4,593 M
Number of employees68000.068000.068000.068000.068000.068000.068000.068000.068000.068000.0
Other current assets4,689 M5,140 M4,389 M4,299 M4,500 M4,277 M7,357 M6,987 M7,169 M8,368 M
Other equity adjustments-4,323 M-4,148 M-5,226 M-4,910 M-5,545 M-6,193 M-6,634 M
Other fixed assets13,136 M12,507 M12,026 M12,439 M13,291 M15,053 M17,000 M19,279 M21,422 M23,051 M
Other non-current assets1,600 M1,569 M1,117 M1,187 M1,417 M1,480 M3,175 M2,194 M9,528 M11,996 M
Other non-current liabilities7,813 M7,345 M8,514 M11,117 M12,041 M11,970 M12,306 M9,434 M8,323 M8,792 M
Other receivable45 M34 M1000000.0
OtherCurrentBorrowings2,704 M2,583 M568 M3,057 M5,308 M3,610 M6,431 M2,412 M1,946 M1,372 M
OtherCurrentLiabilities10,523 M11,216 M10,274 M10,427 M10,151 M12,549 M13,298 M13,859 M14,159 M15,766 M
OtherInventories5,571 M4,700 M4,866 M5,096 M5,440 M5,978 M5,554 M5,953 M5,911 M6,358 M
OtherPayable1,000 M146 M780 M396 M267 M
Payables5,170 M5,402 M6,362 M5,130 M6,747 M6,061 M7,598 M7,601 M8,134 M8,556 M
Preferred securities of subsidiary trust20 M20 M20 M20 M20 M20 M20 M
PreferredStock20 M20 M20 M20 M20 M20 M20 M
RecievablesAdjustmentsAllowances-153 M-165 M-195 M-159 M-119 M-86 M-67 M-62 M-72 M-88 M
Restricted cash4 M2 M258 M103 M71 M79 M68 M
Retained earnings41,698 M41,200 M38,907 M36,440 M37,034 M40,409 M40,728 M49,267 M56,313 M48,734 M
SecuritySoldNotYetRepurchased7,703 M
Short term debt2,704 M2,583 M568 M3,057 M5,308 M3,610 M6,431 M2,412 M1,946 M1,372 M
Total assets98,167 M101,677 M95,377 M87,872 M82,637 M84,397 M91,588 M105,694 M109,160 M106,675 M
Total current assets32,605 M29,751 M30,614 M24,766 M25,875 M27,483 M27,764 M30,266 M35,722 M32,168 M
Total current liabilities18,397 M19,201 M17,204 M18,614 M22,206 M22,220 M27,327 M23,872 M24,239 M25,694 M
Total equity119,171 M121,744 M121,180 M121,924 M128,559 M137,807 M138,891 M38,184 M45,991 M37,581 M
Total liabilities49,376 M56,910 M55,069 M53,303 M55,755 M58,396 M66,184 M67,437 M63,102 M69,040 M
Total non-current assets65,562 M71,926 M64,763 M63,106 M56,762 M56,914 M63,824 M75,428 M73,438 M74,507 M
Total non-current liabilities30,979 M37,709 M37,865 M34,689 M33,549 M36,176 M38,857 M43,565 M38,863 M43,346 M
TotalEquityGrossMinority119,315 M121,835 M121,400 M122,157 M128,740 M137,901 M138,978 M38,257 M46,058 M37,635 M
TotalEquityGrossMinorityInterest119,315 M121,835 M121,400 M122,157 M128,740 M137,901 M138,978 M38,257 M46,058 M37,635 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest98,167 M102,000 M95,377 M87,872 M82,637 M84,397 M91,588 M105,694 M109,160 M106,675 M
TotalNonCurrentLiabilitiesNetMinorityInteres30,979 M37,709 M37,865 M34,689 M33,549 M36,176 M38,857 M43,565 M38,863 M43,346 M
TotalTaxPayable1,237 M1,560 M2,239 M708 M1,971 M736 M1,597 M1,224 M1,986 M2,649 M
Treasury stock35,262 M38,534 M40,546 M43,794 M50,929 M55,950 M56,787 M57,109 M56,489 M57,450 M
Work in progress5,141 M4,374 M4,222 M4,703 M5,004 M5,650 M5,949 M6,220 M7,063 M
Working capital14,208 M10,550 M13,410 M6,152 M3,669 M5,263 M437 M6,394 M11,483 M6,474 M
ltinv13,515 M13,039 M11,416 M12,125 M6,233 M1,469 M785 M370 M1,015 M252 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