Published on December 18th, 2017
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:
- Dividend yield
- Price-to-earnings ratio
- Price-to-book ratio
- Market Capitalization
- Beta
- Return on Equity
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:
- 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.
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.
Step 3: Change the filter setting to ‘Less Than’ and enter ’15’ into the field beside it, as shown below.
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.
Step 5: Change the filter setting to “Less Than” and enter 2 into the field beside it, as shown below.
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.
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.
Step 4: Change the secondary filter setting to “Less Than” and enter 0.03 into the field beside it, as shown below.
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.
Step 6: Change the filter to “Greater Than” and enter 0.15 into the field beside it, as shown below.
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:
- 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
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:
- The Blue Chip Stocks List: stocks with 3%+ dividend yields and 100+ year operating histories
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
- The Complete List Of All REITs
- The Complete List Of All MLPs
- The Complete List Of Dividend-Paying Financial Sector Stocks
- The Complete List Of Dividend-Paying Utility Sector Stocks
- The Complete List Of Dividend-Paying Healthcare Stocks
- The Complete List Of Dividend-Paying Consumer Staples Stocks
- The Complete List Of Dividend-Paying Energy Stocks
- The Complete List Of Dividend-Paying Consumer Cyclical Stocks
- The Complete List Of Dividend-Paying Technology Stocks
- The Complete List Of Dividend-Paying Industrial Stocks
- The Complete List Of Dividend-Paying Materials Stocks
- The Complete List Of Dividend-Paying Telecommunication Stocks
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:
