Dividend Yield (TTM)
Returns the trailing twelve month (TTM) dividend yield for a stock. The dividend yield represents the annual dividend income relative to the stock's current price.
Calculation
Dividend Yield = (Annual Dividends Per Share / Stock Price) * 100Return Value
The function returns a decimal value:
- 0.025 = 2.5% yield
- 0.05 = 5% yield
- 0.10 = 10% yield
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, T, VZ |
| ETFs | SYMBOL | VYM, SCHD |
| REITs | SYMBOL | O, VICI |
Notes
- Returns 0 or "NA" for non-dividend paying stocks
- TTM means it uses the last 12 months of actual dividend payments
- Does not predict future dividends
Syntax
=DividendYield(Symbol)Examples
=DividendYield("AAPL")=DividendYield("T")=DividendYield("O")=DividendYield("VYM")=DividendYield(A1)=DividendYield("AAPL")*100When to Use
- Screening for income-producing stocks
- Comparing dividend yields across stocks
- Building income-focused portfolios
- Evaluating REIT and dividend ETF yields
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need forward-looking yield | ForwardAnnualDividendYield() |
| Need dividend dollar amount | DividendRate() |
| Need 5-year average yield | FiveYearAverageDividendYield() |
| Need payout ratio | DividendPayoutRatio() |
Common Issues & FAQ
Why is the yield showing as a small decimal like 0.025?
The yield is expressed as a decimal, not a percentage. Multiply by 100 to get the percentage: =DividendYield("AAPL")*100
Why am I getting 0 or "NA"?
The company likely does not pay dividends (e.g., growth stocks like AMZN, TSLA).
Why is the yield different from what I see on financial websites?
This is TTM (trailing twelve months). Some sites show forward yield. Also, stock price changes affect yield in real-time.
Excel Templates Using Dividend Yield (TTM)
These ready-made MarketXLS templates call DividendYield() 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:
- 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 DividendYield used in a complete workbook: Bond ETFs: How They Work, Types, and How to Analyze Fixed Income Funds in Excel
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today