Dividend Per Share (TTM)
Returns the total dividends paid per share over the trailing twelve months (TTM). This is the sum of all dividends paid in the last year.
Calculating Dividend Yield
To calculate dividend yield manually:
Dividend Yield = DividendPerShare / Stock Price
=DividendPerShare("AAPL") / Last("AAPL")
Payment Frequency
| Frequency | Typical Companies |
|---|---|
| Quarterly | Most US companies |
| Monthly | REITs, some income funds |
| Semi-Annual | European companies |
| Annual | Some European companies |
Dividend Aristocrats
Companies that have increased dividends for 25+ consecutive years are called "Dividend Aristocrats". Examples: JNJ, KO, PG, MMM
Examples
=DividendPerShare("AAPL")=DividendPerShare("JNJ")=DividendPerShare("KO")=DividendPerShare(A1)=DividendPerShare("AAPL")/Last("AAPL")When to Use
- Income investing analysis
- Calculating dividend yield
- Building dividend portfolios
- Income projection calculations
- Dividend stock screening
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need dividend yield directly | dividend_yield() |
| Need forward/expected dividend | ForwardAnnualDividendYield() |
| Need ex-dividend date | ex_dividend_date() |
| Need dividend history | hf_DividendPerShare() |
Common Issues & FAQ
Q: Why does DividendPerShare return 0 or NA? A: The company may:
- Not pay dividends (growth companies like AMZN, GOOG)
- Have suspended dividends
- Be a new listing without dividend history
Q: Is this quarterly or annual dividend?
A: This is the annual (TTM) dividend. For quarterly dividend, divide by 4 (for most US stocks):
=DividendPerShare("AAPL")/4
Q: How do I calculate dividend yield?
A: =DividendPerShare("SYMBOL") / Last("SYMBOL")
Or use dividend_yield() directly.
Q: Why might the dividend amount change? A: Companies can increase, decrease, or suspend dividends based on earnings, cash flow, and management decisions.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today