Data updated daily
Components updated annually

To create a low-volatile dividend income stream from month to month, retirees (and other income-seeking investors) need to be able to determine which stocks pay dividends each month of the calendar year.

This is where Sure Dividend comes in. We maintain a free database of stocks that pay dividends in June (along with key metrics like price / earnings ratio and dividend yield) that you can download by clicking below:

The list of stocks paying dividends in June, available for download above, contains the following information for each stock in the database:

  • Last dividend payment date in June
  • Dividend yield
  • Payout Rate
  • Price / earnings ratio
  • Price-to-book ratio
  • Market capitalization
  • Return on equity
  • 3 year beta

Keep reading this article to learn more about how you can maximize the usefulness of our database of stocks paying dividends in June.

Note: The components of the table and table above are taken from the Wilshire 5000 index, with data provided by Ycharts and updated annually. Securities outside of the Wilshire 5000 index are not included in the table and table.

So use our list of stocks that pay dividends in June to find investment ideas

It can be very useful to have an Excel document that includes the name, ticker, and financial information of every stock that pays dividends in June.

This document will even stronger in combination with in-depth knowledge of Microsoft Excel.

With that in mind, this tutorial shows how to add two additional investment screens to our list of stocks paying dividends in June.

The first screen we are implementing is for stocks that distribute the majority of their profits to shareholders and also trade at a reasonable multiple of those profits. More precisely, we filter for stocks with a payout ratio between 50% and 100% and a price / earnings ratio below 15.

Screen 1: Stocks with payout percentages between 50% and 100% and price-to-earnings ratios below 15

Step 1: Download your list of stocks paying dividends in June by clicking on. click Here.

Step 2: Click the filter icon at the top of the Payout Percentage column as shown below.

June Dividend Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Greater than” and enter 0.5 in the field next to it, as shown below. Since the payout ratio is measured in percentage points, the filter is based on stocks that pay dividends in June with a payout ratio of over 50%.

June Dividend Stocks Excel Tutorial 2

Step 4: Change that secondary Set the filter to Less Than and enter 1 in the field next to it as shown below. Since the payout ratio is measured in percentage points, the filter here is based on stocks that pay dividends in June and whose payout ratio is below 100%.

June Dividend Stocks Excel Tutorial 3

Step 5: Close the filter window (by clicking the exit button, Not by clicking the “Clear filter” button at the bottom right). Next, click the filter icon at the top of the Price / Earnings Ratio column as shown below.

June Dividend Stocks Excel Tutorial 4

Step 6: Change the filter setting to Less Than and enter 15 in the field next to it, as shown below. This will filter for stocks that pay dividends in June with a P / E ratio below 15.

June Dividend Stocks Excel Tutorial 5

The remaining stocks in the table are stocks that will pay dividends in June with a payout ratio of between 50% and 100% and a price / earnings ratio of less than 15.

The next screen we’re implementing concerns stocks with a price-to-book ratio of less than 2 and large-cap stocks with a market capitalization of over $ 10 billion.

Screen 2: Price-to-book ratio below 2, market capitalization above $ 10 billion

Step 1: Download your list of stocks paying dividends in June by clicking on. click Here.

Step 2: Click the filter icon at the top of the Price-to-Book Ratio column as shown below.

June Dividend Stocks Excel Tutorial 6

Step 3: Change the filter setting to “Less than” and enter 2 in the field next to it. This filters for stocks that pay dividends in June with a price-to-book ratio of less than 2.

June Dividend Stocks Excel Tutorial 7

Step 4: Close the filter window (by clicking the exit button, Not by clicking the “Clear filter” button at the bottom right). Then click the filter button at the top of the Market Cap column as shown below.

June Dividend Stocks Excel Tutorial 8

Step 5: Change the filter setting to “Greater than” and enter 10000 in the field next to it. Note that since market capitalization is measured in millions of dollars, filtering for stocks with a market capitalization greater than “10,000 million” is the same as screening for stocks with a capitalization greater than $ 10 billion.

June Dividend Stocks Excel Tutorial 9

The remaining stocks in this spreadsheet database are stocks that pay dividends in June, have a price-to-book ratio of less than 2 and a market capitalization of over $ 10 billion.

You now have a working understanding of using Microsoft Excel to implement additional financial screens into our list of stocks paying dividends in June.

The remainder of this article introduces other investment resources that can help you make better decisions about your investment journey.

Final Thoughts: Other Useful Investment Resources

Having an Excel sheet that contains the name and financial dates of stocks that pay dividends in June is very powerful, but limited in its usefulness unless it can be combined with similar financial information for the other 11 calendar months.

Fortunately, Sure Dividend develops and maintains databases for every calendar month. You can access the other databases below:

These landing pages are designed to help retirees diversify their dividend income by calendar month.

Another important part of diversification is investing appropriate amounts in each sector of the stock market. With this in mind, Sure Dividend maintains databases (updated monthly) for the following stock exchange sectors:

Diversification aside, our research suggests that some of the best returns in the stock market come from companies that have a habit of continually increasing their dividend payments over time.

With that in mind, the following Sure Dividend databases are great places to look for investment opportunities:

  • The Dividend Aristocrats: S&P 500 stocks with 25+ years of consecutive dividend increases
  • The Dividend Achievers: Dividend stocks with more than 10 years of consecutive dividend increases
  • The Dividend Kings: The Dividend Kings are considered the best of the best when it comes to dividend growth stocks. They are an exclusive group of dividend stocks with over 50 years of consecutive dividend increases

Thanks for reading this article. Please send feedback, corrections, or questions to [email protected]



LEAVE A REPLY

Please enter your comment!
Please enter your name here