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)
IR logo

IR

NYE
Ingersoll Rand Inc.
IndustrialsDiversified Industrials
Watchlists:
Last updated: Monday 21st July 2025
85.55
-2.20 (-2.51%)
Prev Close:87.75
Open:86.33
Bid:84.99
Ask:86.15
52 Week Range
65.61
106.03
Volume:2,950,949
Mkt Cap:34,819 M
Price Target
$98.38
+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