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

JNJ Stock Forecast, Price Targets, Chart, Dividends & Analysis

Johnson & Johnson logo

Johnson & Johnson

Sector: Healthcare   

Industry: Drug Manufacturers - Major

143.58
 
USD
  
-1.17
  
(-0.81%)
Previous close: 144.75  Open: 144.14  Bid: 143.53  Ask: 143.7
52 week range    
143.13   
   168.85
Mkt Cap: 352,500 M  Avg Vol (90 Days): 6,931,146
Peers   
PFE / 
MRK / 
SNY / 
NVS / 
SYK / 
MDT / 
LLY / 
GSK / 
ABT / 
Last updated: Friday 20th December 2024

Stock Rankings

61
MarketXLS Rank
95
Value
30
Technical
60
Quality
How are these ranks calculated?
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ABT

0.0195196 B34.23112.42

GILD

0.0335116 B1022.7891.09

GSK

LLY

0.0077739 B85.26757.54

MDT

0.0339104 B24.879.99

MRK

0.0324253 B20.9899.52

NVS

PFE

0.0657150 B33.6925.77

SNY

SYK

0.009141 B39.95357.14
Financials

JNJ Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquisitionExpense300 M
Amortization of intangibles-741 M-75 M-3,000 M-4,400 M47,643 M53,402 M-9 M
Basic EPS from continuing operations5.86.045.725.597.936.835.26
Basic EPS total5.85.566.040.485.75.725.597.936.8313.88
Basic weighted shares outstanding2,815 M2,772 M2,737 M2,692 M2,682 M2,645 M2,633 M2,632 M2,625 M2,534 M
BasicDiscontinuousOperations8.62
Cost of sales22,746 M21,536 M21,685 M25,439 M27,091 M27,556 M28,427 M23,402 M24,596 M26,553 M
Depreciation3,895 M3,754 M-5,642 M-6,929 M7,009 M7,231 M7,390 M6,970 M7,486 M
DepreciationAndAmortization3,895 M3,754 M-5,642 M-6,929 M7,009 M7,231 M7,390 M6,970 M7,486 M
Diluted EPS total5.75.485.930.475.615.635.517.816.7313.72
Diluted normalized net income/share5.75.935.635.517.816.735.2
Diluted weighted shares outstanding2,864 M2,813 M2,789 M2,745 M2,729 M2,684 M2,671 M2,674 M2,664 M2,560 M
DilutedDiscontinuousOperations8.52
Dividends paid per share2.762.953.153.323.543.753.984.194.454.7
GainOnSaleOfPPE2,400 M600 M1,300 M1,200 M2,154 M
GainOnSaleOfSecurity-5 M-400 M
GainsLossOnDisposalOfDiscontinuedOperations8,459 M20,984 M
GeneralAndAdministrativeExpense21,954 M19,945 M-372 M-332 M22,178 M22,084 M24,659 M20,246 M21,512 M
Gross operating profit51,585 M48,538 M50,205 M51,011 M54,490 M54,503 M54,157 M55,338 M55,394 M58,606 M
ImpairmentOfCapitalAssets410 M283 M-1,307 M-1,258 M1,096 M989 M1,216 M
Income before tax20,563 M19,196 M19,803 M17,673 M17,999 M17,328 M16,497 M22,776 M19,359 M15,062 M
Income restructuring and M&A509 M491 M309 M251 M266 M247 M252 M275 M489 M
Income taxes4,240 M3,787 M3,263 M16,373 M2,702 M2,209 M1,783 M1,377 M2,989 M1,736 M
Interest income67 M128 M368 M385 M611 M357 M111 M53 M490 M1,261 M
InterestExpenseNonOperating533 M552 M726 M934 M1,005 M318 M201 M183 M276 M772 M
InterestIncomeOperating1000000.01000000.0
MinorityInterests69,752 M70,418 M59,471 M63,278 M-1,571 M-21,827 M
MiscOtherSpecialCharges70 M2,064 M-484 M42 M-1,405 M-2,525 M-2,899 M-489 M-810 M-6,634 M
Net income from total operations16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M17,941 M35,153 M
NetIncomeCommonStockholders16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M17,941 M35,153 M
NetIncomeContinuousOperations16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M16,370 M13,326 M
NetIncomeDiscontinuousOperations-4,519 M-3,085 M
NetNonOperatingInterestIncomeExpense-466 M-424 M-358 M-549 M-394 M39 M-90 M-130 M214 M489 M
NonRecurringOperationExpense1,253 M-645 M-1,288 M-100 M
Normalized income12,629 M13,046 M
Operating income20,959 M18,065 M21,136 M18,489 M20,049 M20,080 M19,733 M23,647 M21,013 M22,009 M
Operating income before depreciation (EBITDA)24,991 M23,494 M24,283 M24,249 M25,933 M24,655 M23,929 M26,751 M26,605 M23,320 M
OperatingExpense30,626 M30,473 M29,069 M32,522 M34,441 M34,423 M34,424 M40,273 M33,181 M35,197 M
Other income net-70 M-2,064 M484 M-42 M1,405 M2,525 M2,899 M489 M-3,058 M-8,802 M
OtherGainLossFromDispositionOfDiscontinuedOperations14,953 M22,134 M
OtherGandA21,954 M19,945 M-372 M-332 M22,178 M22,084 M24,659 M20,246 M21,512 M
OtherOperatingExpenses-281 M-348 M-332 M-332 M-249 M-265 M-242 M-523 M-239 M
PromotionAndAdvertising2,600 M2,400 M-2,500 M-2,600 M2,200 M2,100 M2,700 M700 M500 M
RentAndLandingFees341 M330 M-372 M-332 M
Research & development expense8,672 M9,270 M9,124 M11,002 M11,901 M12,245 M12,340 M15,614 M14,135 M15,085 M
ResearchExpense8,672 M9,270 M9,124 M11,002 M11,901 M12,245 M12,340 M15,614 M14,135 M15,085 M
RestructringAndMnAIncome509 M491 M309 M251 M266 M247 M252 M275 M489 M
Revenue per share-741 M-75 M-3,000 M-4,400 M47,643 M53,402 M-9 M
SalariesAndWages-259 M-256 M-962 M-978 M-227 M-210 M-218 M-177 M-221 M
Selling Gen & administrative expense21,954 M21,203 M19,945 M21,520 M22,540 M22,178 M22,084 M24,659 M20,246 M21,512 M
SellingAndMarketingExpense2,600 M21,203 M2,400 M21,520 M22,540 M2,200 M2,100 M2,700 M700 M500 M
SellingExpense21,203 M21,520 M22,540 M
Special income/charges-1,663 M-509 M-491 M-309 M-251 M-266 M-247 M-252 M-275 M-489 M
Total Income available for interest expense (EBIT)21,096 M19,748 M20,529 M18,607 M19,004 M17,646 M16,698 M19,361 M19,635 M15,834 M
Total common shares outstanding2,780 M2,759 M2,713 M2,683 M2,663 M2,635 M2,629 M2,629 M2,604 M2,409 M
Total net income16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M17,941 M35,153 M
Total ordinary shares2,408 M2,408 M2,408 M2,408 M2,408 M2,408 M2,408 M2,408 M2,408 M2,408 M
Total revenues74,331 M70,074 M71,890 M76,450 M81,581 M82,059 M82,584 M93,775 M79,990 M85,159 M
TotalExpenses53,372 M52,009 M50,754 M57,961 M61,532 M61,979 M62,851 M70,128 M57,777 M61,750 M
TotalRevenue74,331 M70,074 M71,890 M76,450 M81,581 M82,059 M82,584 M93,775 M79,990 M85,159 M
WriteDown-177 M-1,348 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