2020 List of All S&P 500 Stocks & Companies | Free Excel List Download Sure Dividend

Sure Dividend

High-Quality Dividend Stocks, Long-Term Plan
The Sure Dividend Investing MethodMember's Area

2020 List of All S&P 500 Stocks & Companies | Free Excel List Download

Updated on May 5th, 2020 by Bob Ciura
Spreadsheet data updated daily

The S&P 500 Index is the most widely-used stock market index of large-capitalization U.S. companies. Because of this, the S&P 500 is often used as a proxy for the entire U.S. stock market. The index contains the ~500 largest U.S. stocks by market capitalization (that also meet other criteria).

You can download our full Excel list of all S&P 500 Index stocks (along with other important metrics like dividend yields and price-to-earnings ratios) by clicking on the link below:


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

This article discusses how the S&P 500 Index downloadable spreadsheet can be used to find investment ideas, why the S&P 500 is widely known as the best gauge of the U.S. stock market, and the composition of the index today.

Table of Contents

While we advise reading this article in its entirety, you can skip to any particular section using the table of contents below:

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 a useful screen for finding reasonably priced S&P 500 securities with above-average dividend yields. We will specifically screen for S&P 500 securities with:

  1. Price-to-earnings ratios of 15 or lower
  2. Dividend yields of 3.0% or higher

For reference, the dividend yield of the S&P 500 is currently below 2%. This screen will find securities with solid dividend yields trading at relatively inexpensive P/E ratios. The steps below provide a quick walkthrough of how to implement this screen using the Excel Spreadsheet download at the beginning of this article.

Step 1: Download the S&P 500 Stocks List near the beginning of this article.

Step 2: Filter the columns.

Step 3: Filter for stocks with yields of 3%+ and P/E ratios of 15 or less.

The tutorial below walks through steps 2 and 3 for reference.

Yield And PE Screen

The remaining stocks in this spreadsheet are S&P 500 stocks with price-to-earnings ratios below 15 and dividend yields above 3%. You now have a solid fundamental understanding of how to use the S&P 500 Stocks List to find compelling investment ideas.

If you are looking for other investment ideas from the S&P 500 components, take a look at the following articles:

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.

Video: Why the S&P 500 is the Best Benchmark for Large Cap U.S. Equities

In the following video, we discuss why the S&P 500 is our favorite benchmark for large cap U.S. equities.

Index Methodology

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

The Index also has other criteria, including:


Return to the Table of Contents

The Historical Performance of the S&P 500

The S&P 500’s historical performance over the long-term is often cited as anywhere between 7% and 10% on an annualized basis. The S&P 500 has generated total inflation-adjusted returns (including reinvested dividends) of 6.8% from January of 1871 through April 2020.

Source: DQYDJ

And, the S&P 500’s Sharpe ratio has averaged around 0.33 over the long run. You can see the Sharpe ratios of individual S&P 500 components here.

The 4 worst total return days for the S&P 500 since 1990 are shown below:

  1. March 16th, 2020 | 12.0% decline
  2. March 12th, 2020 | 9.5% decline
  3. October 15th, 2008 | 9.0% decline
  4. December 1st, 2008 | 8.9% decline

The 4 best total return days for the S&P 500 since 1990 are shown below as well for balance:

  1. October 13th, 2008 | 11.6% increase
  2. October 28th, 2008 | 10.8% increase
  3. March 24th, 2020 | 9.4% increase
  4. March 13th, 2020 | 9.3% increase

The data above shows just how volatile the market was during the last half of 2008 and the first quarter of 2009. The Great Recession was an especially chaotic market period. Extreme volatility has returned in 2020 due to the coronavirus crisis.

The S&P 500 generated positive returns in April 2020, of 12.7%. We will update this article monthly to continue tracking the S&P 500’s performance.

Index Composition & Characteristics

Understanding the characteristics of the S&P 500 is useful because it allows investors to know the traits of the “average” large capitalization company in the United States. According to the index provider (Standard & Poor’s), the S&P 500 currently has the following characteristics:

The top 10 S&P 500 Index constituents by index weight are shown below.

Source: Standard & Poor’s

A sector breakdown of the S&P 500 Index is shown below.

Source: Standard & Poor’s

As you can see from the above image, the S&P 500 Index is heavily overweight the technology sector, as five of the top 10 constituents–Microsoft, Apple, Amazon, Facebook, and Alphabet–are all tech stocks. By contrast, investors can see the relatively low exposure to the energy sector, which has seen its relevance diminish greatly due to the steep decline in commodity prices over the past several years.

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 investment ideas. With that said, it is not the only resource that investors can use to find high quality dividend growth stocks.

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:

You can also find investment opportunities by looking at our other lists, which include:

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

More from sure dividend
The Sure Dividend Investing MethodMember's Area