How to Get Dividend Yield in Google Sheets (Easiest Way in 2024)

May 8, 2024

Google Sheets Dividend Yield

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.

Dividend Yield Formula in Google Sheets

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.

How to Get Dividend Yield in Google Sheets

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

1. Input Stock Symbols, Annual Dividends, and Current Prices

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.

2. Create a Header for Dividend Yield Calculations

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

3. Enter Formula to Calculate Dividend Yield for the First Stock

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).

4. Drag Formula Down to Calculate Dividend Yield for All Listed Stocks

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.

5. Regularly Update Current Stock Prices for Accurate Yield Calculations

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

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

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

Work less, automate more!

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 ->