Dividend Rate (Forward)

Returns the forward dividend rate per share, expressed in dollars. This represents the expected annual dividend payment based on declared dividends.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, KO, T
ETFs SYMBOL VYM, SCHD
REITs SYMBOL O, VICI

Notes

  • Returns the dollar amount per share
  • Returns 0 or "NA" for non-dividend paying stocks
  • Forward-looking based on most recent declarations

Syntax

=DividendRate(Symbol)
Excel Desktop (Windows)

Examples

=DividendRate("AAPL")
Apple dividend rate (~$0.96)
=DividendRate("KO")
Coca-Cola dividend rate (~$1.84)
=DividendRate("T")
AT&T dividend rate
=DividendRate("VYM")
High dividend ETF rate
=DividendRate(A1)
Symbol from cell reference
=DividendRate("JNJ")*500
Annual income on 500 shares

When to Use

  • Looking up dividend dollar amount
  • Calculating portfolio dividend income
  • Comparing dividend amounts
  • Income planning and projections

When NOT to Use

Scenario Use Instead
Need yield percentage DividendYield()
Need forward annual rate ForwardAnnualDividendRate()
Need payout ratio DividendPayoutRatio()
Need dividend dates Ex_DividendDate()

Common Issues & FAQ

What's the difference between DividendRate and ForwardAnnualDividendRate?

Both return forward dividend per share. They may use slightly different data sources or calculation methods. Try both if values differ.

Why am I getting 0?

The company does not pay dividends (e.g., AMZN, TSLA, META).

Is this per quarter or per year?

This is the annual rate. Divide by 4 for quarterly estimate (for typical quarterly payers).

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Dividend Rate (Forward) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions