Dividend Yield Formula — How to Calculate & Examples
Learn the dividend yield formula, see step-by-step examples, and calculate yield in Excel or Google Sheets. Includes a free mini-calculator.
The Dividend Yield Formula
Dividend yield measures the annual return an investor receives from dividends relative to the stock's current price. It is expressed as a percentage.
The total dividends paid per share over one year. If a company pays $0.50 quarterly, the annual dividend is $2.00.
The current market price of one share. This changes daily, so dividend yield fluctuates with the stock price.
Dividend Yield Formula Example
Let's walk through a real-world example using a stock that pays quarterly dividends.
$1.25 per quarter × 4 quarters = $5.00 annual dividend per share
$5.00 ÷ $150.00 = 0.0333
0.0333 × 100 = 3.33% dividend yield
Dividend Yield Formula Variations
There are several ways to calculate dividend yield depending on your needs. Each variation uses slightly different inputs.
Trailing Dividend Yield
Uses actual dividends paid over the last 12 months. This is the most commonly reported yield and reflects what the company has actually paid.
Forward Dividend Yield
Uses the most recently declared dividend, annualized. If a company just raised its quarterly dividend to $0.60, the forward annual dividend would be $2.40. This is forward-looking and reflects expected payments.
Yield on Cost (YOC)
Uses your original purchase price instead of the current market price. This shows your personal yield based on what you paid. If you bought a stock at $50 and it now pays $4.00 annually, your YOC is 8% even if the current yield is only 3%.
Dividend Yield Formula in Excel & Google Sheets
You can easily calculate dividend yield in any spreadsheet application. Here is the setup:
| Cell | Label | Example Value |
|---|---|---|
| A1 | Header: Stock Price | Stock Price |
| A2 | Price value | 150 |
| B1 | Header: Annual Dividend | Annual Dividend |
| B2 | Dividend value | 5.00 |
| C1 | Header: Dividend Yield | Dividend Yield |
| C2 | Formula | =((B2)/A2)*100 |
=B2/A2 and format the cell as a percentage (Ctrl+Shift+5) instead of multiplying by 100.
Google Sheets with Live Data
Google Sheets can pull live stock prices using the GOOGLEFINANCE function:
=GOOGLEFINANCE("JNJ","price")
=GOOGLEFINANCE("JNJ","eps") — (Note: dividend data requires manual entry)
Quick Dividend Yield Calculator
Enter a stock price and annual dividend to instantly calculate the dividend yield.
Common Dividend Yield Calculation Mistakes
These are the most frequent errors investors make when calculating dividend yield:
Using Quarterly Dividend Instead of Annual
If a company pays $0.50 per quarter, the annual dividend is $2.00 (not $0.50). Always multiply by the number of payments per year. Most US companies pay quarterly, but some pay monthly or semi-annually.
Including Special (One-Time) Dividends
Special dividends are one-time payments and should not be included in regular yield calculations. Including them inflates the yield and gives a misleading picture of ongoing income.
Using Outdated Dividend Data
Companies change their dividends periodically. Always verify the most recent dividend announcement rather than relying on historical data that may be several quarters old.
Confusing Yield with Total Return
Dividend yield only measures income from dividends. Total return includes both dividends and capital appreciation (or depreciation). A high yield stock with a falling price may have negative total returns.
What Is a Good Dividend Yield?
A "good" dividend yield depends on the sector, your investment goals, and current market conditions. Here are typical yield ranges by sector:
| Sector | Typical Yield Range | Notes |
|---|---|---|
| Utilities | 3.0% - 5.0% | Stable, regulated earnings |
| REITs | 4.0% - 8.0% | Required to distribute 90% of income |
| Consumer Staples | 2.5% - 4.0% | Steady demand, reliable growers |
| Financials | 2.0% - 4.5% | Banks, insurance companies |
| Energy | 3.0% - 6.0% | Cyclical, tied to commodity prices |
| Technology | 0.5% - 2.0% | Lower yields, higher growth |
| Healthcare | 1.5% - 3.5% | Pharma tends to yield higher |
| S&P 500 Average | 1.3% - 1.5% | Market benchmark |
Frequently Asked Questions
What is the dividend yield formula?
The dividend yield formula is: Dividend Yield = (Annual Dividends Per Share / Price Per Share) x 100. It expresses the annual dividend income as a percentage of the stock's current market price. For example, a stock priced at $100 paying $3 in annual dividends has a 3% yield.
How do you calculate dividend yield in Excel?
In Excel, enter the stock price in cell A2 and the annual dividend in cell B2. Then in cell C2, enter the formula =((B2)/A2)*100 to get the yield as a number. Alternatively, use =B2/A2 and format the cell as a percentage.
What is the difference between trailing yield and forward yield?
Trailing yield uses the actual dividends paid over the past 12 months, while forward yield uses the most recently declared dividend annualized. Forward yield is more current if a company just raised its dividend, but trailing yield reflects what was actually paid.
Why does dividend yield change every day?
Dividend yield changes because the stock price (the denominator in the formula) fluctuates with the market. When the stock price goes up, the yield goes down (and vice versa), even if the dividend payment stays the same. The yield also changes when companies announce dividend increases or decreases.
Is a higher dividend yield always better?
Not necessarily. A very high yield can be a warning sign. It might mean the stock price has dropped significantly (which increases the yield mathematically) or that the dividend is unsustainable. A moderate yield from a company with a history of growing dividends is often a better long-term investment than an extremely high yield from a struggling company.
How do I calculate yield on cost?
Yield on cost (YOC) uses your original purchase price instead of the current price: YOC = (Current Annual Dividend / Original Purchase Price) x 100. This shows your personal yield based on what you paid. Long-term holders of dividend growth stocks often have YOC well above the current market yield.
Sources
- Investopedia — Dividend Yield Definition
Comprehensive reference on dividend yield calculation and interpretation.
- SEC — Investor Bulletin on Dividends
Official SEC guidance on understanding dividend payments.
- S&P Global — Dividend Aristocrats Index
Source for S&P 500 average yield and dividend growth benchmarks.