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)Returns
number
Forward dividend rate per share in dollars
Examples
=DividendRate("AAPL")=DividendRate("KO")=DividendRate("T")=DividendRate("VYM")=DividendRate(A1)=DividendRate("JNJ")*500When 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).
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Ex-Dividend Date
- Total Dividends Between Two Dates
- Consecutive Period of Increasing Dividend Payout
- Consecutive Period of Uninterrupted Dividend
- Dividend Date
- Dividend Frequency
- Dividend Per Share (TTM)
- Dividend Per Share 5 Year CAGR
See DividendRate used in a complete workbook: Bloomberg Alternative: The Best Excel-Native Financial Data Platform in 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?