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

149.12
 
USD
  
1.21
  
(0.82%)
Optionable: Yes  Market Cap: 347,946 M  90-day average vol: 7,484,328

Previous close: 147.91  Open: 148.51  Bid: 148.81  Ask: 149.12
52 week range    
143.13   
   175.97
Peers   
PFE / 
MRK / 
SNY / 
NVS / 
SYK / 
MDT / 
LLY / 
GSK / 
ABT / 
Last updated: Tuesday 23rd April 2024
55
MarketXLS Rank
60
Value
46
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 Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""3,638 M7,004 M4,684 M3,906 M2,796 M1,202 M2,631 M3,766 M12,756 M3,451 M
Accounts payable7,633 M6,668 M6,918 M7,310 M7,537 M8,544 M9,505 M11,055 M9,889 M9,632 M
Accounts receivable10,985 M10,734 M11,699 M13,490 M14,098 M14,481 M13,576 M15,283 M14,039 M14,873 M
Accrued expenses14,632 M15,303 M13,524 M19,421 M19,054 M20,525 M24,865 M25,779 M22,828 M22,837 M
Accumulated depreciation & depletion-20,559 M-20,743 M-21,861 M-24,461 M-24,816 M-25,674 M-28,038 M-28,717 M-25,552 M-27,878 M
Building & improvements10,046 M9,829 M10,112 M11,240 M11,176 M11,877 M12,502 M
Cash and equivalents14,523 M13,732 M18,972 M17,824 M18,107 M17,305 M13,985 M14,487 M12,889 M21,859 M
CashCashEquivalentsAndShortTermInvestments33,089 M38,376 M41,907 M18,296 M19,687 M19,287 M25,185 M31,608 M22,281 M22,927 M
CashEquivalents14,523 M13,732 M18,972 M17,824 M18,107 M
Common par3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M
Common stock equity109,534 M116,518 M127,122 M123,268 M128,476 M136,305 M140,258 M152,221 M160,192 M220,098 M
CommonStock3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M3,120 M
Construction in progress3,600 M3,354 M3,637 M4,316 M
Cost in excess21,832 M21,629 M22,805 M31,906 M30,453 M33,639 M36,393 M35,246 M36,047 M36,558 M
CurrentAccruedExpenses6,553 M7,885 M5,635 M10,257 M10,699 M9,715 M13,968 M13,612 M10,719 M10,212 M
CurrentCapitalLeaseObligation200 M224 M216 M227 M223 M269 M
CurrentDeferredAssets3,567 M
CurrentDeferredTaxesAssets11,295 M10,087 M10,144 M9,902 M11,405 M12,031 M12,477 M12,640 M12,836 M12,670 M
CurrentDeferredTaxesLiabilities-7,540 M7,159 M-6,906 M11,166 M11,271 M-10,170 M-11,157 M-9,904 M-7,880 M-6,584 M
DefinedPensionBenefit22,575 M3,857 M4,710 M5,343 M5,327 M5,538 M5,761 M4,436 M4,581 M4,992 M
DerivativeProductLiabilities1,860 M3,289 M5,962 M
DividendsPayable-7,768 M2.0-8,621 M3.09,494 M-9,917 M-10,481 M-11,032 M-11,682 M-11,770 M
EmployeeBenefits9,972 M8,854 M9,615 M10,074 M9,951 M10,663 M10,771 M8,898 M6,542 M7,149 M
Finished goods4,509 M4,876 M5,007 M5,308 M5,376 M6,071 M5,894 M6,508 M6,972 M6,874 M
Float term debt15,122 M12,857 M22,442 M30,675 M27,684 M26,494 M32,635 M29,985 M26,886 M25,881 M
GoodwillAndOtherIntangibleAssets49,054 M47,393 M49,681 M85,134 M78,064 M81,282 M89,795 M81,638 M74,536 M70,733 M
Gross fixed assets (Plant Property & Equipment)36,685 M36,648 M37,773 M41,466 M41,851 M43,332 M46,804 M47,679 M43,534 M47,776 M
IncomeTaxPayable446 M750 M971 M1,854 M818 M2,266 M1,392 M1,112 M2,220 M2,993 M
Intangibles27,222 M25,764 M26,876 M53,228 M47,611 M47,643 M53,402 M46,392 M38,489 M34,175 M
Inventories8,184 M8,053 M8,144 M8,765 M8,599 M9,020 M9,344 M10,387 M10,268 M11,181 M
Invested capital139,778 M129,375 M172,006 M153,943 M156,160 M189,293 M205,528 M212,191 M213,964 M271,860 M
Land & improvements833 M780 M753 M829 M807 M854 M882 M
LongTermCapitalLeaseObligation1,000 M1,100 M1,000 M1,300 M1,100 M
LongTermDebtAndCapitalLeaseObligation15,122 M12,857 M22,442 M30,675 M27,684 M26,494 M32,635 M29,985 M26,886 M25,881 M
Machinery furniture & equipment22,206 M22,511 M23,554 M25,949 M25,992 M26,964 M29,104 M
Net fixed assets (net PP&E)16,126 M15,905 M15,912 M17,005 M17,035 M17,658 M18,766 M18,962 M17,982 M19,898 M
NetOtherUnrealizedGainLoss2,400 M2,600 M600 M1,300 M1,200 M295 M-652 M336 M-230 M-377 M
NetUnrealizedGainLossForeignCurrency-4,803 M
NetUnrealizedGainLossInvestments257 M
Non-current deferred income taxes2,447 M2,562 M2,910 M8,368 M7,506 M5,958 M7,214 M7,487 M3,991 M3,193 M
NonCurrentAccruedExpenses8,472 M8,242 M7,444 M6,559 M5,713 M4,306 M2,881 M
NonCurrentDeferredAssets6,202 M5,490 M6,148 M7,105 M7,640 M7,819 M8,534 M10,223 M8,947 M9,279 M
NonCurrentDeferredLiabilities2,447 M2,562 M2,910 M8,368 M7,506 M5,958 M7,214 M7,487 M3,991 M3,193 M
NonCurrentDeferredTaxesAssets6,202 M5,490 M6,148 M7,105 M7,640 M7,819 M8,534 M10,223 M8,947 M9,279 M
NonCurrentPensionAndOtherPostretirementBenefitPlans9,972 M8,854 M9,615 M10,074 M9,951 M10,663 M10,771 M8,898 M6,542 M7,149 M
Number of employees144300.0144300.0144300.0144300.0144300.0144300.0144300.0144300.0144300.0144300.0
Other current assets2,465 M3,080 M3,041 M3,151 M950 M94 M3,373 M3,323 M5,830 M2,500 M
Other equity adjustments-10,722 M-13,165 M-14,901 M-13,199 M-15,222 M-15,891 M
Other fixed assets16,126 M15,912 M17,658 M18,766 M18,962 M17,982 M19,898 M
Other non-current assets3,232 M4,413 M4,435 M4,971 M4,182 M5,695 M6,562 M10,216 M30,619 M14,153 M
Other non-current liabilities12,044 M10,241 M9,536 M9,017 M17,969 M11,734 M23,457 M22,781 M23,725 M29,399 M
Other receivable76,450 M81,581 M82,059 M82,584 M93,775 M79,990 M85,159 M
OtherCurrentBorrowings3,638 M7,004 M4,684 M3,906 M2,796 M1,202 M2,631 M3,766 M12,756 M3,451 M
OtherCurrentLiabilities2,751 M5,440 M8,079 M7,210 M397 M14,237 M3,484 M3,586 M6,639 M3,993 M
OtherEquityInterest257 M604 M-285 M70 M195 M
OtherInventories8,184 M8,144 M9,020 M9,344 M10,387 M10,268 M11,181 M
OtherPayable2,129 M954 M4,509 M35,151 M899 M5,810 M7,323 M60 M17,652 M
Payables8,079 M7,418 M7,889 M9,164 M8,355 M10,810 M10,897 M12,167 M12,109 M12,625 M
Preferred securities of subsidiary trust2 M2 M
PreferredStock2 M2 M
Prepaid expenses3,486 M3,047 M3,282 M2,537 M2,699 M2,392 M3,132 M3,701 M2,876 M4,514 M
Raw materials1,214 M936 M952 M1,140 M1,114 M1,117 M1,410 M1,592 M1,719 M2,355 M
RecievablesAdjustmentsAllowances-275 M-252 M-248 M-226 M-293 M-230 M-169 M-166 M
Retained earnings86,523 M103,879 M95,650 M101,793 M106,216 M94,768 M98,648 M110,002 M115,378 M141,316 M
SecuritySoldNotYetRepurchased7,124 M5,290 M8,979 M6,358 M5,868 M6,746 M
Short term debt3,638 M7,004 M4,684 M3,906 M2,796 M1,202 M2,631 M3,766 M12,756 M3,451 M
Total assets130,358 M133,411 M141,208 M157,303 M152,954 M157,728 M174,894 M182,018 M187,378 M167,558 M
Total current assets55,744 M60,210 M65,032 M43,088 M46,033 M45,274 M51,237 M60,979 M55,294 M53,495 M
Total current liabilities21,021 M27,747 M26,287 M30,537 M31,230 M35,964 M30,980 M45,226 M55,802 M46,282 M
Total equity109,534 M116,518 M127,122 M123,268 M128,476 M136,305 M140,258 M152,221 M160,192 M220,098 M
Total liabilities60,606 M62,261 M70,790 M97,143 M93,202 M98,257 M111,616 M107,995 M110,574 M98,784 M
Total non-current assets74,614 M73,201 M76,176 M114,215 M106,921 M112,454 M123,657 M121,039 M132,084 M114,063 M
Total non-current liabilities39,585 M34,514 M44,503 M66,606 M71,352 M62,293 M80,636 M74,864 M68,351 M68,503 M
TotalEquityGrossMinority109,534 M71,150 M127,122 M60,160 M59,752 M136,305 M140,258 M74,023 M76,804 M68,774 M
TotalEquityGrossMinorityInterest109,534 M71,150 M127,122 M60,160 M59,752 M136,305 M140,258 M74,023 M76,804 M68,774 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest170,140 M133,411 M197,912 M157,303 M152,954 M234,562 M174,894 M182,018 M187,378 M167,558 M
TotalNonCurrentLiabilitiesNetMinorityInteres39,585 M34,514 M44,503 M66,606 M71,352 M62,293 M80,636 M74,864 M68,351 M68,503 M
TotalTaxPayable446 M750 M971 M1,854 M818 M2,266 M1,392 M1,112 M2,220 M2,993 M
Treasury stock19,891 M22,684 M28,352 M31,554 M34,362 M38,417 M38,490 M39,099 M41,694 M75,662 M
Work in progress2,461 M2,241 M2,185 M2,317 M2,109 M1,832 M2,040 M2,287 M1,577 M1,952 M
Working capital34,723 M32,463 M38,745 M12,551 M14,803 M9,310 M20,257 M15,753 M-508 M7,213 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