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

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.

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

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.