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

162.00
 
USD
  
-6.23
  
(-3.70%)
Optionable: Yes  Market Cap: 440,044 M  90-day average vol: 6,805,902

Previous close: 168.23  Open: 167.93  Bid: 162.1  Ask: 162.1
52 week range    
155.72   
   186.69
Peers   
PFE / 
MRK / 
SNY / 
NVS / 
SYK / 
MDT / 
LLY / 
GSK / 
ABT / 
Last updated: Tuesday 31st January 2023
57
MarketXLS Rank marketxls
75
Value marketxls
30
Technical marketxls
68
Quality marketxls

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
Are you?
twitterstocktwits
Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ABT

0.0147225 B32.4128.05

GILD

0.044486 B11.763.76

GSK

LLY

0.0161238 B37.4243.55

MDT

0.0245139 B29.8101.99

MRK

0.0356207 B28.877.58

NVS

PFE

0.0302298 B15.153.21

SNY

SYK

0.011294 B47.6248.19
News
Financials

JNJ Income Statement

Annual
Save
Dec-12Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21
Total revenues67,224 M71,312 M74,331 M70,074 M71,890 M76,450 M81,581 M82,059 M82,584 M93,775 M
Cost of sales17,992 M18,238 M18,851 M17,790 M18,035 M19,797 M20,162 M20,547 M21,196 M22,465 M
Gross operating profit45,566 M48,970 M51,585 M48,538 M50,101 M51,011 M54,490 M54,503 M54,157 M63,920 M
Selling Gen & administrative expense20,869 M21,830 M21,954 M21,203 M20,067 M21,520 M22,540 M22,178 M22,084 M24,659 M
Research & development expense8,828 M8,763 M8,672 M9,270 M9,172 M11,002 M11,901 M12,245 M12,159 M14,714 M
Operating income15,869 M18,377 M20,959 M18,065 M20,862 M18,489 M20,049 M20,080 M19,914 M24,547 M
floaterest income0000000000
floaterest expense0000000000
Other income net-1,626 M-2,498 M70 M1,555 M-701 M-267 M-1,656 M-2,791 M-3,327 M-1,641 M
Pre-tax Income (EBT)13,775 M15,471 M20,563 M19,196 M19,803 M17,673 M17,999 M17,328 M16,497 M22,776 M
Income taxes3,261 M1,640 M4,240 M3,787 M3,263 M16,373 M2,702 M2,209 M1,783 M1,898 M
Net income from total operations10,514 M13,831 M16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M
Minority floaterest0000000000
Total net income10,853 M13,831 M16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common10,514 M13,831 M16,323 M15,409 M16,540 M1,300 M15,297 M15,119 M14,714 M20,878 M
Depreciation3,666 M4,104 M3,895 M3,746 M3,754 M5,642 M6,929 M7,009 M7,231 M7,390 M
Amortization0000000000
Operating income before depreciation (EBITDA)17,973 M20,057 M24,991 M23,494 M24,283 M24,249 M25,933 M24,655 M23,929 M30,349 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total3.944.925.85.566.040.485.75.725.597.93
Diluted EPS total3.864.815.75.485.930.475.615.635.517.81
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today