MarketXLS

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

Syntax

=ForwardAnnualDividendRate(Symbol)
Excel Desktop (Windows)

Returns

number

Forward annual dividend per share in dollars

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

Why is this different from DividendRate()?

ForwardAnnualDividendRate() is forward-looking (projected), while DividendRate() may use different calculation methods or trailing data.

Is this guaranteed?

No, it's a projection based on the most recent dividend. Companies can change their dividend at any time.

How do I calculate my annual income?

Multiply by your number of shares: =ForwardAnnualDividendRate("AAPL")*100 for 100 shares.

Excel Templates Using Forward Annual Dividend Rate

These ready-made MarketXLS templates call ForwardAnnualDividendRate() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Dividends formulas you can use in the same worksheet:

See ForwardAnnualDividendRate used in a complete workbook: VTSAX: Complete Guide to Vanguard's Total Stock Market Fund (2026)

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