The Complete List of S&P 500 Stocks [Free Excel Download + Metrics] Sure Dividend

Sure Dividend

High Quality Dividend Stocks, Long-Term Plan
Newsletters & CoursesMember's Area

The Complete List Of S&P 500 Stocks


Updated on February 23rd, 2018

The S&P 500 is widely-known as the best broad gauge of performance for large-capitalization U.S. equities. Containing the 500 largest companies by market capitalization (that also meet other criteria), the S&P 500 is a fantastic place to look for investment opportunities.
 

The spreadsheet available for download above contains numerous important investing metrics, including:

Index Methodology

The S&P 500 is most well-known for containing the 500 largest companies in the United States when measured by market capitalization.

The Index also has other criteria, including:

Now that you understand what is contained within the S&P 500, the next section of this article will describe how to use the S&P 500 Stocks List to find compelling investment ideas.

How To Use The S&P 500 Stocks List To Find Investment Ideas

Having an Excel document containing the financial metrics of every stock within the S&P 500 is very powerful.

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

With that in mind, this section will provide a tutorial of how to implement two useful financial screens to the S&P 500 Stocks List. The first screen we’ll implement is for stocks with price-to-earnings ratios below 15 and price-to-book ratios below 2.

Screen 1: Value Stocks

Step 1: Download the S&P 500 Stocks List at the link above.

Step 2: Click on the filter icon at the top of the price-to-earnings ratio column, as shown below.

S&P 500 Stocks Excel Tutorial 1

Step 3: Change the filter setting to ‘Less Than’ and enter ’15’ into the field beside it, as shown below.

S&P 500 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. Then, click on the filter icon at the top of the price-to-book column, as shown below.

S&P 500 Stocks Excel Tutorial 3

Step 5: Change the filter setting to “Less Than” and enter 2 into the field beside it, as shown below.

S&P 500 Stocks Excel tutorial 4

The remaining stocks in this spreadsheet are S&P 500 stocks with price-to-earnings ratios below 15 and price-to-book ratios below 2.

The next filter that we’ll implement is for stocks with dividend yields between 2% and 3% and returns on equity exceeding 15%.

Screen 2: Moderate Dividend Yields and Above-Average Returns on Equity

Step 1: Download the S&P 500 Stocks List at the link above.

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

S&P 500 Stocks Excel Tutorial 5

Step 3: Change the filter setting to “Greater Than” and enter 0.02 into the field beside it. We must enter 0.02 and not 2% because dividend yield is measured in percentage points.

S&P 500 Stocks Excel Tutorial 6

Step 4: Change the secondary filter setting to “Less Than” and enter 0.03 into the field beside it, as shown below.

S&P 500 Stocks Excel Tutorial 7

Step 5: Exit the filter window (by clicking the exit button, not the “Clear Filter” button in the bottom right). Then, click on the filter icon at the top of the return on equity column, as shown below.

S&P 500 Stocks Excel Tutorial 9

Step 6: Change the filter to “Greater Than” and enter 0.15 into the field beside it, as shown below.

S&P 500 Stocks Excel Tutorial 10

The remaining stocks in this Excel spreadsheet are S&P 500 stocks with dividend yields between 2% and 3% that also have returns on equity exceeding 15% over the trailing twelve-month period.

You now have a solid fundamental understanding of how to use the S&P 500 Stocks List to find compelling investment ideas.

The remainder of this article will explain how to use the S&P 500 Index as a benchmark for investment performance before directing you to other useful investing resources.

How To Use The S&P 500 As A Benchmark

Investors can gain passive access to a broad basket of S&P 500 stocks by investing in index ETFs that track the benchmark. Accordingly, it is useful to ensure that your portfolio’s performance is comparable to the S&P 500, especially on a risk-adjusted basis.

The easiest way to measure the performance of the S&P 500 Index is by using a free financial tool like Google Finance or Yahoo! Finance. Download historical data of S&P 500 Index levels from these resources, and compare its performance to the performance of your portfolio. If it turns out that the index is trouncing your performance over long periods of time, then changing to a passive investment strategy might be a wise decision.

Final Thoughts

The S&P 500 Stocks List is an excellent place to look for high-quality investment ideas. With that said, it is not the only resource that investors should be using.

If you’re looking for dividend stocks with long histories of steadily increasing dividend payments, the following databases contain some of the most high-quality dividend stocks around:

Alternatively, you might be looking to invest in blue-chip stocks with above-average dividend yields and long histories of successful business operations. If that is indeed the case, the following database will be useful:

Another way to find investment opportunities is by looking through specific sectors of the stock market. With that in mind, the following databases will prove useful

A last method for finding high-quality investment opportunities is by looking inside the portfolios of the world’s best investors. Warren Buffett is likely the best investor of our time, and we provide detailed analysis on his portfolio which you can access below:

Thanks for reading this article. Please send any feedback, corrections, or questions to support@suredividend.com.


More from sure dividend
Newsletters & CoursesMember's Area