Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
SIG logo

SIG

NYE
Signet Jewelers Limited
Consumer CyclicalLuxury Goods
Watchlists:
Last updated: Sunday 20th July 2025
81.82
+0.90 (1.11%)
Prev Close:80.92
Open:81.85
Bid:81.29
Ask:82.38
52 Week Range
45.55
106.28
Volume:1,086,395
Mkt Cap:3,248 M
Price Target
$94.09
+15.0%

Forward Annual Dividend Yield

Live
Returns the expected annual dividend yield of the stock for the next year.

How calculated

It is calculated by dividing Forward estimated annual dividend rate by Previous day's closing price

Example usage

=ForwardAnnualDividendYield("MSFT")

Notes

forward dividend/current price

Assets

Stocks,ETFs, Mutual Funds