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:
- Dividend yield
- Price-to-earnings ratio
- Market Capitalization
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
- Video: Why the S&P 500 is the Best Benchmark for Large Cap U.S. Equities
- Index Methodology
- The Historical Performance of the S&P 500
- Index Composition & Characteristics
- How To Use The S&P 500 As A Benchmark
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:
- Price-to-earnings ratios of 15 or lower
- 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.
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 Top 10 Highest Yielding S&P 500 Stocks
- The 100 Highest Beta Stocks In The S&P 500
- The 100 Lowest Beta Stocks In The S&P 500
- The Highest Sharpe Ratio Stocks Within The S&P 500
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.
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:
- Universe: All constituents must be U.S. companies.
- Eligibility Market Cap: Companies with a market capitalization of US$6.1 billion or greater.
- Public Float: At least 50% of shares outstanding must be available for trading.
- Financial Viability: Companies must have positive as-reported earnings over the most recent quarter, as well as over the most recent four quarters (summed together).
- Adequate Liquidity and Reasonable Price: Consists of highly tradable common stocks, with active and deep markets.
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.
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:
- March 16th, 2020 | 12.0% decline
- March 12th, 2020 | 9.5% decline
- October 15th, 2008 | 9.0% decline
- 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:
- October 13th, 2008 | 11.6% increase
- October 28th, 2008 | 10.8% increase
- March 24th, 2020 | 9.4% increase
- 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:
- Number of constituents: 506
- Mean total market cap: $50.4 billion
- Largest total market cap: $1.37 trillion [Microsoft (MSFT)]
- Smallest total market cap: $1.96 billion
- Median total market cap: $19.8 billion
- Weight of top 10 constituents: 26.1%
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.
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:
- The Dividend Aristocrats: dividend stocks with 25+ years of consecutive dividend increases
- The Dividend Achievers: dividend stocks with 10+ years of consecutive dividend increases
- The Dividend Kings: considered the “best-of-the-best” when it comes to dividend growth, the exclusive Dividend Kings list contains stocks that have 50+ years of consecutive dividend increases
- The Blue Chip Stocks List: The combination of our Kings, Achievers, and Aristocrats lists
You can also find investment opportunities by looking at our other lists, which include: