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

Dividend Yield (TTM)

Live
2.15%
The dividend yield is a financial ratio that tells you the percentage of a company's share price that it pays out in dividends each year

How calculated

It is calculated by dividing the ttm dividend (dividend per share) by previous day's closing price.

Example usage

=DividendYield("MSFT") - Returns the TTM dividend yield for MSFT.

Notes

TTM dividend/ Price

Assets

Stocks ETFs
Dividend Yield (TTM)
StockDividend Yield (TTM)

JNJ

2.15%

PFE

4.99%

MRK

2.06%

SYK

1.03%

MDT

2.55%

LLY

0.79%

ABT

2.04%

GILD

2.97%
Johnson & Johnson logo

Johnson & Johnson

Sector: Healthcare   

Industry: Drug Manufacturers - Major

160.50
 
USD
  
-1.16
  
(-0.72%)
Optionable: Yes  Market Cap: 421,553 M  90-day average vol: 21,980,271

Previous close: 161.66  Open: 161.3  Bid: 159.0  Ask: 160.5
52 week range    
150.11   
   181.04
Peers   
PFE / 
MRK / 
SNY / 
NVS / 
SYK / 
MDT / 
LLY / 
GSK / 
ABT / 
Last updated: Sunday 24th September 2023
45
MarketXLS Rank
60
Value
15
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

Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today