The Complete List of Stocks That Pay Dividends in July [Excel Download] Sure Dividend

Sure Dividend

The Complete List of Stocks That Pay Dividends in July

Published on June 21st, 2018

One of the challenges that self-directed retired investors face is constructing an investment portfolio that generates a similar amount of dividend income each month.

This challenge becomes much more manageable if investors have access to a database of stocks that pay dividends in each calendar month.

That’s where Sure Dividend comes in. We maintain a list of stocks that pay dividends in July, available for download below:

 

The database of stocks that pay dividends in July available for download above contains the following information for each stock in the database:

Keep reading this article to learn more about how you can use our list of stock that pay dividends in July to help make better portfolio management decisions.

How To Use The List of Stocks That Pay Dividends in July to Find Investment Ideas

Having an Excel document that contains the name, ticker, and financial information for every stock that pays dividends in July can be quite useful.

This document becomes even more powerful when combined with a working knowledge of Microsoft Excel.

With that in mind, this tutorial will demonstrate how you can apply two useful investing screens to our database of stocks that pay dividends in July.

The first screen that we’ll implement will search for stocks with high dividend yields and large market capitalizations. More specifically, we’ll screen for stocks with yields above 3% and market capitalizations above $10 billion.

Screen 1: Dividend Yields Above 3%, Market Capitalizations Above $10 Billion

Step 1: Download your free list of stocks that pay dividends in July by clicking here.

Step 2: Click the filter icon at the top of the dividend yield column, as shown below.

July Dividend Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Greater Than” and input 0.03 into the field beside it, as shown below. This will filter for stocks that pay dividends in July with dividend yields above 3%.

July Dividend Stocks Excel Tutorial 2

Step 4: Close out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Next, click the filter icon at the top of the market capitalization column, as shown below.

July Dividend Stocks Excel Tutorial 3

Step 5: Change the filter setting to “Greater Than” and input 10000 into the field beside it. Since market capitalization is measured in millions of dollars in this spreadsheet, this is equivalent to filtering for stocks with market capitalizations above $10 billion.

July Dividend Stocks Excel Tutorial 4

The remaining stocks in this spreadsheet are stocks that pay dividends in July with dividend yields above 3% and market capitalizations above $10 billion.

The next screen that we’ll demonstrate is for stocks with dividend yields above 4% and payout ratios below 100%. This screen is useful for investors who need dividend yield now but do not want to risk investing in companies with payout ratios above 100%.

Screen 2: Dividend Yields Above 4%, Payout Ratios Below 100%

Step 1: Download your free list of stocks that pay dividends in July by clicking here.

Step 2: Click on the filter icon at the top of the dividend yield column, as shown below.

July Dividend Stocks Excel Tutorial 5

Step 3: Change the filter setting to “Greater Than” and input 0.04 into the field beside it. This will filter for stocks that pay dividends in July with dividend yields above 4%.

July Dividend Stocks Excel Tutorial 6

Step 4: Close out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Next, click on the filter icon at the top of the payout ratio column, as shown below.

July Dividend Stocks Excel Tutorial 7

Step 5: Chance the primary filter setting to “Less Than” and input 1 into the field beside it. This will filter for stocks that pay dividends in July with payout ratios below 100%.

Additionally, change the secondary filter setting to “Greater Than” and input 0 into the field beside it. This will filter out stocks that have negative payout ratios – which is even worse than stocks with payout ratios above 100%.

July Dividend Stocks Excel Tutorial 8

The remaining stocks in this spreadsheet are stocks that pay dividends in July with dividend yields above 4% and payout ratios between 0% and 100%.

You now have a solid understanding of how to use our database of stocks that pay dividends in July to find investment ideas.

To conclude this article, we will introduce several other useful investing databases that you can use to improve your long-term investing outcomes.

Final Thoughts: Other Useful Investing Resources

July is not a particularly special month of the year when it comes to dividend income. This article (and the associated database) is part of a comprehensive suite of dividend calendar solutions. You can access similar databases for the other 11 calendar months below:

Diversifying your dividend income by calendar month is very important for retirees and other income-oriented investors.

Another important component of diversification is having investments in every major sector of the stock market.

With that in mind, Sure Dividend maintains databases of the following stock market industries, which are available for download below:

Diversification aside, our research suggests that the best place to find compelling investment opportunities is among stocks with long histories of steadily increasing their dividend payments.

The following databases are useful resources if this approach sounds appealing to you: