Skip to main content

Limited time: save up to 25% on spreadsheet models and templates.

Explore templates
10XSheets

Free calculator

Dividend yield calculator

Find dividend yield % on a stock: annual cash dividend per share divided by price per share in the same currency. Enter total dividend per year directly, or one per-payment amount and how often the company pays (monthly, quarterly, semi-annual, annual). Pick whether your price is a current quote or your cost basisyield on cost uses the same math with a different label. Not live tickers, not tax or DRIP—illustration only.

Educational illustration only. Not investment, tax, or brokerage advice. We do not fetch live prices or fund data; you type dividends and price yourself. Savings accounts that call earnings a “dividend” are not the same as stock dividends—see FAQ.

When to use this calculator

Back-of-the-envelope yield % before you build a dividend or Dividend Aristocrat view in a workbook.

  • Convert quarterly or monthly cash dividends into an annual run-rate, then see yield against a price you choose.
  • Compare spot yield vs yield on cost by toggling the price label—math is identical; the question is which price you mean.
  • Copy a simple = annual ÷ price style into Google Sheets or Excel next to a watchlist you maintain yourself.
  • Jump to the stock calculator when you need P&L on a round-trip trade, not a dividend %.
How do you calculate dividend yield here?

We use the usual cash definition for common stock: yield % = (annual dividend per share) ÷ (price per share) × 100, with both in the same currency.

From per-payment to annual (mode B only)

Annual dividend = dividend for one payment × payments per year (12, 4, 2, or 1 from the frequency you pick). Irregular or special dividends are not modeled here—treat the tool as a pattern for recurring cash policy.

Yield percentage

Yield (decimal) = annual dividend per share ÷ price per share; on-screen we show the same as a percent. If dividend = 0, yield = 0% (you still need a positive price).

Price field: spot vs cost

Spot uses a current or last price you type; cost labels the same field as your basis for a yield on cost read—no second formula.

What we do not model

Live or ticker quotes, ex-dividend timing, withholding tax, return of capital adjustments, scrip vs cash, FX across listings, or dividend growth / reinvestment (DRIP)—use a full model or your broker statement when you need that depth.

For CAGR over years or compound reinvestment, see the CAGR and compound interest tools—not the same as a one-line yield snapshot. For annualized return between two prices over time, open the CAGR calculator. For P&L on a single buy and sell with commissions, use the stock calculator.

Google Sheets & Excel

English function names. Put annual dividend / share in D2 and price / share in P2.

Dividend yield (decimal, format as %)
=D2/P2

Then pick Percent number format, or use =D2/P2 in a ratio column.

Annual from quarterly per-share dividend (Q in A2, pays per year = 4)
=A2*4

For other cadences, multiply by 2 (semi-annual) or 12 (monthly) instead.

More tools in Unit economics

Browse all tools

Frequently asked questions

What does this dividend yield calculator do?

It shows dividend yield % = (annual cash dividend per share) ÷ (price per share) in the same currency. You can type the full year of dividends or one per-period amount plus how often the company pays. We do not pull live prices or tickers.

What is the exact formula?

Yield (decimal) = annual dividend per share ÷ price per share; we display × 100 for %. If you enter per-payment D with k payments per year, annual = D × k first, then the same line.

What is the difference between “spot” and “cost” here?

The math is the same: annual dividend ÷ a price you choose. Spot means you treat the bottom field as a market or list price; cost means you treat it as your average cost per share to read yield on cost. We label the price; we do not fetch either number.

Is this the same as “dividend” on my credit union statement?

Often no in the U.S.: some savings products label earnings a “dividend”; this page is for per-share cash dividends on common stock (or similar listed equity) that you type yourself.

Does this use trailing (TTM) or forward yield?

Neither automatically—you enter what you consider your annual (or annualized) cash dividend per share. In practice people compare TTM cash paid, indicated rates, or their own forecast. We do not look up a statement date for you.

Is a very high yield always “good”?

Not by itself. An unusually high yield can come from a crashing price or a payout that the market does not think is sustainable. This tool only does arithmetic—it does not score a stock or fund.

How do I match this in Google Sheets or Excel?

For one year of cash dividend per share in D2 and your price in P2: =D2/P2 and format as %. For quarterly $1 in A2 with 4 payments: =A2*4/P2 (see the spreadsheet block above).

Is this investment or tax advice?

No. It is a free educational calculator; not a recommendation, not a research report, and not a substitute for a pro or your tax rules.