Updated April 1st, 2021 by Bob Ciura

The spreadsheet data is updated daily

In order for retirees to achieve dividend income that remains relatively stable month-to-month, they need to understand which stocks are paying dividends in which months.

This is where Sure Dividend comes in. We have created a database of all the stocks that will pay dividends in April (plus key metrics that matter to investors) that you can download by clicking the link below:

The April dividend-paying database, available for download above, contains the following metrics for each security in the list:

  • Surname
  • ticker
  • Stock price
  • Dividend yield
  • Market capitalization
  • P / E ratio
  • Payout Rate
  • beta

Read on to learn more about how you can use our database of stocks that will pay dividends in April to find investment ideas.

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

Here’s How To Use The April Dividend Stock List To Find Investment Ideas

An Excel database containing the name, ticker, and price-to-earnings ratio of every stock that pays a dividend in April can be extremely useful.

This document will even more powerful in combination with basic knowledge of spreadsheet tools such as Microsoft Excel.

With that in mind, the following tutorial shows how additional investment screens can be applied to the stocks in the April dividend stocks database.

The first screen we’ll show is for stocks trading with market cap greater than $ 15 billion and betas less than 1.

Screen 1: Market Cap Above $ 15 Billion, Beta Below 1

Step 1: Download your free list of stocks that will pay off in April by clicking Here. Apply Excel’s filter function to each column in the table.

Step 2: At the top of the Market Capitalization column, click the filter icon (see screenshot below).

Step 3: Change the filter setting to “Greater than” and enter 15000 in the field next to it, as shown below. Since market capitalization is measured in millions, screening for market caps above “15,000” is the same as screening for market caps above $ 15 billion.

Step 4: Close the filter window (by clicking the “Exit” button). Not by clicking the “Clear Filters” button in the lower right corner). Next, click on the filter icon at the top of the Beta column as shown below.

Step 5: Change the filter setting to Less Than and enter 1 in the field next to it as shown below. This filters for dividend stocks in April with betas below 1.

The remaining stocks in this database are stocks that pay dividends in April with market capitalization over $ 15 billion and betas under $ 1 billion.

The next screen to be implemented concerns stocks paying dividends with P / E ratios below 10 and dividend yields above 5% in April.

Screen 2: Value for money below 10, dividend yield above 5%

Step 1: Download your free list of stocks that will pay off in April by clicking Here. Apply Excel’s filter function to each column in the table.

Step 2: Click the filter icon at the top of the Price / Earnings Ratio column (see below).

Step 3: Change the filter setting to Less Than and enter 10 in the field next to it as shown below. This will filter for stocks that pay dividends with a P / E ratio of less than 10 in April.

Step 4: Close the filter window (by clicking the exit button). Not by clicking the “Clear Filters” button in the lower right corner). Then click the filter icon at the top of the Dividend Yield column (see screenshot below).

Step 5: Change the filter setting to “Greater than” and enter 0.05 in the field next to it. This will filter for stocks paying dividends with dividend yields above 5% in April.

The remaining stocks in this table are stocks that paid dividends with a price-to-earnings ratio of less than 10 and dividend yields of over 5% in April.

You now have a full understanding of how to leverage the power of Microsoft Excel to find investment ideas in our database of stocks that will pay off in April.

To wrap up this article, we’re going to be sharing other investment databases that you can use to find compelling dividend investment opportunities.

Final thoughts: other useful investment resources

An Excel sheet of names, tickers, and financial information for all stocks that will pay dividends in April is very useful – but it will be much more useful in combination with other databases for the non-April months of the calendar year.

Fortunately, Sure Dividend maintains similar databases for the other 11 months of the year. You can access the following databases:

Our research at Sure Dividend suggests that stocks with steadily increasing dividend payments outperformed the broader, lower-volatility market. With this in mind, the following stock databases are useful resources for finding investment ideas:

  • The Dividend Aristocrats: A group of S&P 500 stocks with more than 25 years of consecutive dividend increases.
  • The Dividend Achievers: A group of 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 stocks with more than 50 years of consecutive dividend increases.

You may also be looking for stocks with certain dividend characteristics to create a very customized source of income. With this in mind, the following Sure Dividend databases are useful:

Individual stock exchange sectors can also be fertile ground for your search for new investment ideas. Sure Dividend offers 10 databases of the stocks in each sector of the stock market. You can access the following databases:

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