Dividend Aristocrats Spreadsheet (2020)

The Dividend Aristocrats Spreadsheet is a listing of stocks from the S&P 500 that have increased their annual dividend payments for at least 25 years. Additional key information is included to help kickstart your research.

As part of building your monthly dividend portfolio or dividend investing strategy, you need to sort through the stocks available in the market. One category of stocks to check out is the Dividend Aristocrats because they have a long history of consistently increasing their dividends.

What are the Dividend Aristocrats

The Dividend Aristocrats are companies on the S&P 500 with at least 25 years of continuous dividend increases. These are companies that pay dividends and annually increase their dividends.

There are no guarantees that the payments will continue forever. This spreadsheet can be a helpful place to start looking for ideas for your monthly dividend portfolio or for investing in the stock market in general.

What is the Dividend Aristocrat Spreadsheet

The official list of Dividend Aristocrats is defined by the S&P. This spreadsheet is a listing of those stocks along with a few additional pieces of information that are useful to dividend investors and those looking to build a monthly dividend portfolio.

If you decide to copy the spreadsheet or refer back to the current version, always make sure you do your own research prior to making a stock purchase. This list shouldn’t be taken as a recommendation of what to buy and while I am aiming to provide current information, it’s always possible the company announces a change that’s not reflected here.

What is included in the spreadsheet of Dividend Aristocrats?

The Dividend Aristocrat spreadsheet is a listing of the current stocks as defined by the S&P. It’s built on Google Sheets because Google provides a few helpful financial formulas to show recent prices and stats about the stocks.

Using these pieces of information you can easily calculate some of your favorite dividend investing stats such as dividend yield. A few pieces of information need to be updated manually as they’re not available from Google, including the current Annual Dividend Payment.

But with a little manual updating, you have a useful calculator to build your monthly dividend portfolio.

The Dividend Aristocrats Spreadsheet includes:

• Symbol
• Company Name
• Sector
• Industry
• Payment Pattern (The months the stock usually pays its dividends)
• Payout Increase (Month the increased dividend is usually started)
• Recent Price (Provided by Google)
• Annual Dividend Payment FWD (Future total dividend payment)
• Dividend Yield (Calculated from the Recent Price and Annual Dividend Payment FWD)

The list of Dividend Aristocrats will be updated as it’s something I’m using to build my dividend income strategy. The calculated columns and Google provided data columns are highlighted.

In your copy of the spreadsheet you can easily add your own columns to do your own research prior to making a stock purchase. This list shouldn’t be taken as a recommendation of what to buy and changes will occur throughout the year.

Wrapping up. Are you also creating your own Dividend Aristocrats Spreadsheet?

To help with filtering the list Dividend Aristocrats as a starting point to filter the stocks that have increased their dividend payments for at least 25 years.

What other data would you like to see on the spreadsheet to help you build your watchlist?

Pin for later