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
Syntax
=DividendPerShare(Symbol)Returns
Annual dividend per share in USD
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
Why does DividendPerShare return 0 or NA?
The company may:
- Not pay dividends (growth companies like AMZN, GOOG)
- Have suspended dividends
- Be a new listing without dividend history
Is this quarterly or annual dividend?
This is the annual (TTM) dividend. For quarterly dividend, divide by 4 (for most US stocks):
=DividendPerShare("AAPL")/4
How do I calculate dividend yield?
=DividendPerShare("SYMBOL") / Last("SYMBOL")
Or use dividend_yield() directly.
Why might the dividend amount change?
Companies can increase, decrease, or suspend dividends based on earnings, cash flow, and management decisions.
Excel Templates Using Dividend Per Share (TTM)
These ready-made MarketXLS templates call DividendPerShare() 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:
- Dividend Per Share 5 Year CAGR
- Dividend Rate (Forward)
- Dividend Yield (TTM)
- Ex-Dividend Date
- Ex-Dividend Date
- Forward Annual Dividend Rate
- Total Dividends Between Two Dates
- Consecutive Period of Increasing Dividend Payout
See DividendPerShare used in a complete workbook: Monthly Dividend Yield: Calculate and Track Your Income Using Excel in 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today