In this article:

May 8, 2024

Calculating dividend yield in Google Sheets helps investors evaluate the income from stock investments relative to stock price. By dividing annual dividends per share by the stock price per share and multiplying by 100, users can compute the yield percentage and reveal the stock's income potential.

The dividend yield formula in Google Sheets is:

**= (Annual Dividends Per Share / Stock Price Per Share) * 100**

This formula calculates the dividend yield as a percentage, where "Annual Dividends Per Share" represents the total dividends paid out per share over a year, and "Stock Price Per Share" is the current price of the stock.

Follow the steps below to get dividend yield in Google Sheets.

In cells A1:C1, enter the headers: "Stock Symbol", "Annual Dividend Per Share (USD)", and "Current Stock Price (USD)". Fill in the data for each stock as shown in the example dataset.

In cell D1, type "Dividend Yield (%)" to create a header for your calculated dividend yields.

In cell D2, input the formula =B2 / C2 * 100 to calculate the dividend yield as a percentage for the first stock listed. This formula divides the annual dividend per share by the current stock price and then multiplies by 100 to convert it to a percentage.

Press Enter to apply the formula. This will give you the dividend yield for the first stock (AAPL).

Copy the formula in cell D2 down to the other cells in column D to calculate the dividend yield for each stock. Use the fill handle (small square at the bottom right of the cell) to drag the formula.

Adjust decimal places as desired.

Update the "Current Stock Price (USD)" column regularly to ensure your dividend yield calculations remain accurate. Financial markets fluctuate, affecting stock prices and, consequently, dividend yield percentages.

We hope that you now have a better understanding of how to get dividend yield in Google Sheets. If you enjoyed this article, you might also like our article on how to set up dot products in Google Sheets or our article on how to set up Google Sheets dynamic cell reference.

Get Google Sheets productivity and automation tips delivered straight to your inbox

We'll email you 1-3 times a week — and never share your information.

Get your copy of our free Google Sheets automation guide!

- 27 pages of Google Sheets tips and tricks to save time
- Covers pivot tables and other advanced topics
- 100% free

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->