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

127.00
 
USD
  
0.12
  
(0.09%)
Optionable: Yes  Market Cap: 321,342 M  90-day average vol: 8,359,468

Previous close: 126.88  Open: 126.815  Bid: 126.0  Ask: 126.5
52 week range    
99.14   
   133.10
Peers   
PFE / 
JNJ / 
BMY / 
LLY / 
SNY / 
GSK / 
TEVA / 
NVS / 
ABT / 
Last updated: Thursday 25th April 2024
68
MarketXLS Rank
65
Value
76
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 Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories79 M805 M206 M-145 M-911 M-508 M-895 M-674 M-161 M-816 M
(Increase) Decrease in other current liabilities190 M-277 M-809 M-123 M-266 M-237 M-617 M484 M-545 M456 M
(Increase) Decrease in other working capital-98 M-5 M862 M-1,087 M-674 M-32 M-2,433 M-1,758 M-1,473 M-2,314 M
(Increase) Decrease in payables572 M-303 M402 M-3,037 M1,057 M-1,960 M1,498 M-135 M91 M-166 M
(Increase) Decrease in receivables-554 M-480 M-619 M297 M-418 M294 M-1,002 M-2,033 M-644 M-1,148 M
Acquisitions-3,881 M-7,744 M-780 M-396 M-431 M-294 M-2,365 M-12,907 M-121 M
AssetImpairmentCharge1,222 M162 M3,948 M646 M296 M1,040 M1,718 M302 M1,700 M792 M
CapitalExpenditureReported2,317 M1,283 M1,614 M1,888 M2,615 M3,473 M4,429 M4,448 M4,388 M3,863 M
Cash at beginning of period15,621 M7,441 M8,524 M6,515 M6,096 M7,967 M9,934 M8,153 M8,167 M12,773 M
Cash at end of period7,441 M8,524 M6,515 M6,096 M7,967 M9,955 M8,196 M8,167 M12,773 M6,909 M
Cash flow7,860 M12,538 M10,376 M6,451 M10,922 M13,461 M7,648 M11,588 M19,022 M12,978 M
Cash from disc. financing activities-504 M
Cash from disc. investing activities-250 M-134 M
CashFlowFromContinuingInvestingActivities-374 M-4,758 M-3,210 M2,679 M4,314 M-2,629 M-9,193 M-16,421 M-4,960 M-14,083 M
CashFromDiscontinuedOperatingActivities2,636 M987 M
ChangeInAccountPayable593 M-37 M278 M254 M230 M399 M684 M405 M-289 M-380 M
ChangeInAccruedExpense1,635 M-8 M-2,018 M-922 M-341 M376 M-1,152 M277 M-50 M1,783 M
ChangeInIncomeTaxPayable-21 M-266 M124 M-3,291 M827 M-2,359 M814 M-540 M380 M214 M
ChangeInInterestPayable1,635 M-8 M-2,018 M-922 M-341 M376 M-1,138 M
ChangeInPayablesAndAccruedExpense2,207 M-311 M-1,616 M-3,959 M716 M-1,584 M346 M142 M41 M1,617 M
ChangeInTaxPayable-21 M-266 M124 M-3,291 M827 M-2,359 M814 M-540 M380 M214 M
ChangeInWorkingCapital1,824 M-268 M-1,976 M-5,017 M-1,553 M-2,067 M-4,601 M-3,839 M-2,782 M-2,205 M
ChangesInAccountReceivables-554 M-480 M-619 M297 M-418 M294 M-1,002 M-2,033 M-644 M-1,148 M
CommonStockDividendPaid-5,247 M-5,117 M-5,124 M-5,167 M-5,172 M-5,695 M-6,215 M-6,610 M-7,012 M-7,445 M
CommonStockPayments-7,703 M-4,186 M-3,434 M-4,014 M-9,091 M-4,780 M-1,281 M-840 M-1,346 M
Current deferred income taxes-2,600 M-764 M-1,521 M-2,621 M-509 M-556 M-566 M187 M-1,568 M-1,899 M
Deferred income taxes-2,600 M-764 M-1,521 M-2,621 M-509 M-556 M-566 M187 M-1,568 M-1,899 M
Depreciation6,691 M6,375 M5,441 M4,676 M4,519 M1,700 M1,700 M1,600 M1,800 M1,800 M
Depreciation unreconciled6,691 M6,375 M5,441 M4,676 M4,519 M3,673 M3,517 M3,236 M3,885 M3,844 M
DepreciationAndAmortization6,691 M6,375 M5,441 M4,676 M4,519 M3,673 M3,517 M3,236 M3,885 M3,844 M
EarningsLossesFromEquityInvestments-813 M-155 M-70 M-40 M-1,338 M-1,940 M1,419 M-340 M
Effect of exchange rate changes-553 M-1,310 M-131 M457 M-205 M17 M253 M-133 M-410 M23 M
FinancingCashFlow-15,113 M-5,387 M-9,044 M-10,006 M-13,160 M-8,861 M-2,832 M3,097 M-9,119 M-4,810 M
Free cash flow5,543 M11,255 M8,762 M4,563 M8,307 M9,988 M5,855 M8,674 M14,707 M9,143 M
GainLossOnSaleOfBusiness-11,209 M
Issuance of debt-460 M-1,540 M-26 M5,124 M-3,710 M2,549 M-3,986 M
IssuanceOfDebt-3,931 M3,492 M-1,307 M-1,129 M837 M1,248 M5,011 M1,631 M-2,251 M4,184 M
Net cash from financing activities-15,113 M-5,387 M-9,044 M-10,006 M-13,160 M-8,861 M-2,832 M4,653 M-9,119 M-4,810 M
Net cash from investing activities-374 M-4,758 M-3,210 M2,679 M4,314 M-2,629 M-9,443 M-16,421 M-4,960 M-14,083 M
Net cash from operating activities7,860 M12,538 M10,376 M6,451 M10,922 M13,461 M10,284 M13,122 M19,095 M13,006 M
Net change in cash & cash equivalents-8,180 M1,083 M-2,009 M-419 M1,871 M1,988 M-1,738 M147 M5,016 M-5,887 M
Net income from continuing operations11,934 M4,459 M3,941 M2,418 M6,193 M9,777 M4,523 M12,358 M14,526 M377 M
NetBusinessPurchaseAndSale-2,293 M-7,428 M-780 M-396 M-431 M-294 M-2,365 M-12,907 M-121 M
NetCommonStockIssuance-7,703 M-4,186 M-3,434 M-4,014 M-9,091 M-4,780 M-1,281 M-840 M-1,346 M
NetForeignCurrencyExchangeGainLoss876 M
NetIntangiblesPurchaseAndSale-1,000 M
NetInvestmentPropertiesPurchaseAndSale4,236 M3,953 M-816 M4,963 M7,360 M1,138 M-2,399 M934 M-451 M-10,220 M
NetInvestmentPurchaseAndSale4,236 M3,953 M-816 M4,963 M7,360 M1,138 M-2,399 M934 M-451 M-10,220 M
NetIssuancePaymentsOfDebt-3,931 M3,492 M-1,307 M-1,129 M837 M1,248 M5,011 M1,631 M-2,251 M4,184 M
NetLongTermDebtIssuance-3,471 M5,032 M-1,307 M-1,103 M-4,287 M4,958 M2,462 M5,617 M-2,251 M4,184 M
NetPPEPurchaseAndSale-1,317 M-1,283 M-1,614 M-1,888 M-2,615 M-3,473 M-4,429 M-4,448 M-4,388 M-3,863 M
Operating (gains) losses-11,394 M721 M-70 M-40 M-1,338 M-1,940 M1,419 M-340 M
Other financing charges net208 M-61 M-118 M-195 M-325 M5 M-436 M10,270 M-240 M-328 M
Other investing changes net13,871 M82 M482 M38 M102 M-4,282 M-5,116 M-91 M32 M-12,068 M
Other non-cash items1,405 M2,015 M4,561 M6,995 M2,272 M2,634 M6,113 M1,586 M3,542 M13,201 M
Payment of cash dividends5,247 M5,117 M5,124 M5,167 M5,172 M5,695 M6,215 M6,610 M7,012 M7,445 M
ProceedsFromStockOptionExercised1,560 M485 M939 M499 M591 M361 M89 M202 M384 M125 M
Purchase of Float term investments-24,944 M-16,681 M-15,651 M-10,739 M-7,994 M-3,202 M-95 M-1000000.0-1,204 M-955 M
Purchase of property plant & equipment-2,317 M-1,283 M-1,614 M-1,888 M-2,615 M-3,473 M-4,429 M-4,448 M-4,388 M-3,863 M
Purchase of short term investments3,146 M7,938 M1,079 M4,958 M4,419 M7,936 M5,939 M
PurchaseOfIntangibles-1,000 M
PurchaseOfInvestment-24,749 M-16,542 M-15,651 M-10,739 M-7,994 M-3,202 M-95 M-1000000.0-1,204 M-955 M
PurchaseOfLongTermInvestments195 M139 M-15,651 M-10,739 M-7,994 M-3,202 M-95 M
PurchaseOfPPE-1,317 M-1,283 M-1,614 M-1,888 M-2,615 M-3,473 M-4,429 M-4,448 M-4,388 M-3,863 M
Repayment of debt-6,617 M-2,906 M-2,386 M-1,103 M-4,287 M-1,957 M-2,319 M-2,251 M-1,755 M
RepaymentOfDebt-6,617 M-2,906 M-2,386 M-1,103 M-4,287 M-3,710 M-1,957 M-2,319 M-2,251 M-1,755 M
Repurchase of capital stock-7,703 M-4,186 M-3,434 M-4,014 M-9,091 M-4,780 M-1,281 M-840 M-1,346 M
Revenue per share1,973 M1,817 M1,636 M2,085 M2,044 M
Sale of Float term investments721 M2,803 M
Sale of short term investments15,114 M20,413 M14,353 M15,664 M15,252 M8,622 M2,812 M1,026 M721 M
SaleOfBusiness1,588 M316 M
SaleOfInvestment15,114 M20,413 M14,353 M15,664 M15,252 M8,622 M2,812 M1,026 M721 M2,803 M
ShortTermDebtIssuance-460 M-1,540 M-26 M5,124 M-3,710 M2,549 M-3,986 M
ShortTermDebtPayments-460 M-1,540 M-26 M5,124 M-3,710 M2,549 M
StockBasedCompensation278 M299 M300 M312 M348 M417 M441 M479 M541 M645 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