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

Johnson & Johnson

Sector: Healthcare   

Industry: Drug Manufacturers - Major

146.82
 
USD
  
-1.71
  
(-1.15%)
Optionable: Yes  Market Cap: 360,255 M  90-day average vol: 7,612,526

Previous close: 148.53  Open: 149.37  Bid: 146.69  Ask: 146.8
52 week range    
143.13   
   175.97
Peers   
PFE / 
MRK / 
SNY / 
NVS / 
SYK / 
MDT / 
LLY / 
GSK / 
ABT / 
Last updated: Friday 26th April 2024
50
MarketXLS Rank
60
Value
30
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

JNJ Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-1,120 M-449 M-249 M581 M-644 M-277 M-265 M-1,248 M-2,527 M-1,323 M
(Increase) Decrease in other current assets442 M65 M18 M-411 M-275 M-1,054 M
(Increase) Decrease in other current liabilities-1,096 M2,159 M-586 M8,979 M-1,844 M1,425 M744 M-1,061 M-1,979 M5,588 M
(Increase) Decrease in other working capital442 M-529 M-1,054 M-3,704 M-1,964 M687 M-3,480 M
(Increase) Decrease in payables955 M287 M656 M2,725 M3,951 M4,060 M5,141 M2,437 M1,098 M2,346 M
(Increase) Decrease in receivables-247 M-433 M-1,065 M-633 M-1,185 M-289 M774 M-2,402 M-1,290 M-624 M
Acquisitions-2,129 M-954 M-4,509 M-35,200 M-900 M-5,800 M-7,323 M-60 M-17,652 M
AssetImpairmentCharge382 M624 M272 M795 M1,258 M1,076 M296 M941 M1,199 M1,295 M
CapitalExpenditureReported3,714 M3,463 M3,226 M3,279 M3,670 M3,498 M3,347 M3,652 M4,009 M4,543 M
Cash at beginning of period20,927 M14,523 M13,732 M18,972 M17,824 M18,107 M17,305 M13,985 M14,487 M14,127 M
Cash at end of period14,523 M13,732 M18,972 M17,775 M18,106 M17,315 M13,985 M14,487 M14,127 M21,859 M
Cash flow18,471 M19,569 M18,767 M21,056 M22,201 M23,416 M24,684 M23,410 M21,194 M43,292 M
CashFlowFromContinuingInvestingActivities-12,305 M-7,735 M-4,761 M-14,917 M-3,168 M-6,184 M-21,973 M-8,683 M-12,371 M878 M
CashFromDiscontinuedOperatingActivities-20,984 M
ChangeInAccountPayable955 M287 M656 M2,725 M3,951 M4,060 M5,141 M2,437 M1,098 M2,346 M
ChangeInPayablesAndAccruedExpense955 M287 M656 M2,725 M3,951 M4,060 M5,141 M2,437 M1,098 M2,346 M
ChangeInWorkingCapital-1,066 M1,629 M-1,773 M11,241 M3 M3,865 M2,690 M-4,238 M-4,011 M2,507 M
ChangesInAccountReceivables-247 M-433 M-1,065 M-633 M-1,185 M-289 M774 M-2,402 M-1,290 M-624 M
CommonStockDividendPaid-7,768 M-8,173 M-8,621 M-8,943 M-9,494 M-9,917 M-10,481 M-11,032 M-11,682 M-11,770 M
CommonStockPayments-7,124 M-5,290 M-8,979 M-6,358 M-5,868 M-6,746 M-3,221 M-3,456 M-6,035 M-5,054 M
Current deferred income taxes441 M-270 M-341 M2,406 M-1,016 M-2,476 M-1,141 M-2,079 M-1,663 M-4,194 M
Deferred income taxes441 M-270 M-341 M2,406 M-1,016 M-2,476 M-1,141 M-2,079 M-1,663 M-4,194 M
Depreciation3,895 M3,746 M3,754 M5,642 M6,929 M7,009 M7,231 M7,390 M6,970 M7,486 M
Depreciation unreconciled3,895 M3,746 M3,754 M5,642 M6,929 M7,009 M7,231 M7,390 M6,970 M7,486 M
DepreciationAndAmortization3,895 M3,746 M3,754 M5,642 M6,929 M7,009 M7,231 M7,390 M6,970 M7,486 M
Effect of exchange rate changes-310 M-1,489 M-215 M337 M-241 M-9 M89 M-178 M-312 M-112 M
FinancingCashFlow-12,260 M-11,136 M-8,551 M-7,673 M-18,510 M-18,015 M-6,120 M-14,047 M-8,871 M-15,825 M
Free cash flow19,388 M19,570 M16,808 M19,609 M21,734 M23,183 M20,494 M20,469 M17,728 M18,606 M
GainLossOnSaleOfPPE-2,383 M-2,583 M-563 M-1,307 M-1,217 M-2,154 M-111 M-617 M-380 M-117 M
IncomeTaxPaidSupplementalData3,536 M2,865 M2,843 M3,312 M4,570 M4,191 M4,619 M4,768 M5,223 M8,574 M
InterestPaidSupplementalData1,091 M1,132 M1,358 M1,826 M2,012 M1,920 M1,745 M1,931 M1,915 M3,602 M
Issuance of capital stock4,241 M
Issuance of debt596 M1,372 M-1,906 M-461 M-2,399 M-61 M728 M807 M9,584 M-9,230 M
IssuanceOfCapitalStock4,241 M
IssuanceOfDebt850 M1,379 M7,875 M6,754 M-3,949 M-2,881 M7,095 M-990 M7,452 M-10,781 M
Net cash from financing activities-12,260 M-11,136 M-8,551 M-7,673 M-18,510 M-18,015 M-6,120 M-14,047 M-8,871 M-15,342 M
Net cash from investing activities-12,305 M-7,735 M-4,761 M-14,917 M-3,168 M-6,184 M-20,825 M-8,683 M-12,371 M878 M
Net cash from operating activities18,471 M19,569 M18,767 M21,056 M22,201 M23,416 M23,536 M23,410 M21,194 M22,791 M
Net change in cash & cash equivalents-6,404 M-791 M5,240 M-1,197 M282 M-792 M-3,409 M680 M-48 M7,844 M
Net income from continuing operations16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M17,941 M35,153 M
NetBusinessPurchaseAndSale-2,129 M-954 M-4,509 M-35,200 M-900 M-5,800 M-8,471 M-60 M-17,652 M
NetCommonStockIssuance-7,124 M-5,290 M-8,979 M-6,358 M-5,868 M-6,746 M-3,221 M-3,456 M-6,035 M-813 M
NetInvestmentPropertiesPurchaseAndSale-11,093 M-6,782 M1,707 M21,730 M-1,801 M-151 M-10,460 M-5,682 M8,747 M5,063 M
NetInvestmentPurchaseAndSale-11,093 M-6,782 M1,707 M21,730 M-1,801 M-151 M-10,460 M-5,682 M8,747 M5,063 M
NetIssuancePaymentsOfDebt850 M1,379 M7,875 M6,754 M-3,949 M-2,881 M7,095 M-990 M7,452 M-10,781 M
NetLongTermDebtIssuance254 M7 M9,781 M7,215 M-1,550 M-2,820 M6,367 M-1,797 M-2,132 M-1,551 M
NetPPEPurchaseAndSale917 M1000000.0-1,959 M-1,447 M-467 M-233 M-3,042 M-2,941 M-3,466 M-4,185 M
Operating (gains) losses-2,383 M-2,583 M-563 M-1,307 M-1,217 M-2,154 M-111 M-617 M-380 M-117 M
Other financing charges net-57 M-15 M-188 M-148 M575 M-627 M395 M65 M6,928 M
Other investing changes net-299 M-103 M-123 M-234 M-464 M382 M-1,508 M-294 M-478 M-3,421 M
Other non-cash items1,261 M1,638 M1,150 M1,774 M2,205 M2,053 M1,301 M2,076 M2,337 M2,457 M
Payment of cash dividends7,768 M8,173 M8,621 M8,943 M9,494 M9,917 M10,481 M11,032 M11,682 M11,770 M
ProceedsFromStockOptionExercised1,782 M1,005 M1,189 M1,062 M949 M954 M1,114 M1,036 M1,329 M1,094 M
Purchase of Float term investments-34,913 M-40,828 M-33,950 M-6,153 M-5,626 M-3,920 M-21,089 M-30,394 M-32,384 M-10,906 M
Purchase of property plant & equipment917 M1000000.0-1,959 M-1,447 M-467 M-233 M-3,042 M-2,941 M-3,466 M-4,185 M
Purchase of short term investments2,098 M75 M12,004 M8,992 M5 M3 M7,431 M5 M2 M
PurchaseOfInvestment-34,913 M-40,828 M-33,950 M-6,153 M-5,626 M-3,920 M-21,089 M-30,394 M-32,384 M-10,906 M
PurchaseOfPPE-3,714 M-3,463 M-3,226 M-3,279 M-3,670 M-3,498 M-3,347 M-3,652 M-4,009 M-4,543 M
Repayment of debt-1,844 M-68 M-2,223 M-1,777 M-1,555 M-2,823 M-1,064 M-1,802 M-2,134 M-1,551 M
RepaymentOfDebt-3,111 M-1,112 M-4,240 M-3,107 M-4,034 M-2,923 M-3,727 M-2,992 M-8,684 M-24,524 M
Repurchase of capital stock-7,124 M-5,290 M-8,979 M-6,358 M-5,868 M-6,746 M-3,221 M-3,456 M-6,035 M-5,054 M
Sale of short term investments24,119 M34,149 M35,780 M28,117 M4,289 M3,387 M12,137 M25,006 M41,609 M19,390 M
SaleOfBusiness-1,148 M
SaleOfInvestment24,119 M34,149 M35,780 M28,117 M4,289 M3,387 M12,137 M25,006 M41,609 M19,390 M
SaleOfPPE4,631 M3,464 M1,267 M1,832 M3,203 M3,265 M305 M711 M543 M358 M
ShortTermDebtIssuance1,863 M2,416 M111 M869 M80 M39 M3,391 M1,997 M16,134 M13,743 M
ShortTermDebtPayments-1,267 M-1,044 M-2,017 M-1,330 M-2,479 M-100 M-2,663 M-1,190 M-6,550 M-22,973 M
StockBasedCompensation792 M874 M878 M962 M978 M977 M1,005 M1,135 M1,138 M1,162 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