Forward Annual Dividend Rate

Returns the forward annual dividend rate per share, expressed in dollars. This is the projected annual dividend based on the most recent dividend payment, annualized.

Calculation

Forward Annual Dividend = Most Recent Quarterly Dividend * 4

For monthly payers:

Forward Annual Dividend = Most Recent Monthly Dividend * 12

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT, JNJ
ETFs SYMBOL VYM, SCHD
REITs SYMBOL O, VICI

Notes

  • Returns the dollar amount per share
  • Forward-looking projection, not guaranteed
  • Based on most recent dividend payment

Examples

=ForwardAnnualDividendRate("AAPL")
Apple forward dividend (~$0.96)
=ForwardAnnualDividendRate("MSFT")
Microsoft forward dividend (~$3.00)
=ForwardAnnualDividendRate("JNJ")
J&J forward dividend (~$4.76)
=ForwardAnnualDividendRate("O")
Realty Income (monthly payer)
=ForwardAnnualDividendRate(A1)
Symbol from cell reference
=ForwardAnnualDividendRate("AAPL")*100
Annual income on 100 shares

When to Use

  • Calculating expected dividend income
  • Comparing dividend amounts across stocks
  • Portfolio income projection
  • Dividend growth analysis

When NOT to Use

Scenario Use Instead
Need yield percentage DividendYield()
Need trailing dividend DividendRate()
Need forward yield % ForwardAnnualDividendYield()
Need dividend dates Ex_DividendDate()

Common Issues & FAQ

Q: Why is this different from DividendRate()? A: ForwardAnnualDividendRate() is forward-looking (projected), while DividendRate() may use different calculation methods or trailing data.

Q: Is this guaranteed? A: No, it's a projection based on the most recent dividend. Companies can change their dividend at any time.

Q: How do I calculate my annual income? A: Multiply by your number of shares: =ForwardAnnualDividendRate("AAPL")*100 for 100 shares.

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 Forward Annual Dividend Rate and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions