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

Sure Dividend

High-Quality Dividend Stocks, Long-Term Plan
Click Here For Our Top 10 Retirement Stocks NowMember's Area

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


Updated on October 2nd, 2019 by Bob Ciura
Spreadsheet and table data updated daily

The S&P 500 Index is the most widely used gauge of performance for large-capitalization U.S. companies. The S&P 500 is often used as a proxy for the U.S. stock market.

The index contains the 500 largest stocks by market capitalization (that also meet other criteria).

 

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

You can view a preview of the spreadsheet below:

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 500 largest companies in the United States when measured by market capitalization.

The Index also has other criteria, including:

S&P 500 Companies by Weight

The S&P 500 constituent companies are listed below, along with their component weights in the Index:

 

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.9% from January of 1871 through September 2019.

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.

Interestingly, the 4 worst total return days for The S&P 500 since 1990 all occurred in 2008:

  1. October 15th, 2008 | 9.0% decline
  2. December 1st, 2008 | 8.9% decline
  3. September 29th, 2008 | 8.8% decline
  4. October 9th, 2008 | 7.6% 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 23rd, 2009 | 7.1% increase
  4. November 13th, 2008 | 6.9% 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.

The S&P 500 generated positive performance in October 2019. During the month, the S&P 500 ETF (SPY) generated total returns of 4.2%. This performance comes after a 1.9% gain in September.

For 2019 through October, the S&P 500 ETF has generated total returns of 23.9%. This is already well ahead of average annual returns for the S&P 500, and we are only 5/6 of the way through the year. 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.

SPY Constituents

Source: Standard & Poor’s

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

SPY Breakdown

Source: Standard & Poor’s

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
Click Here For Our Top 10 Retirement Stocks NowMember's Area