Published on December 27th, 2017
The FTSE 100 Index – usually pronounced “footsie 100” – is a market capitalization weighted index of the 100 largest companies that trade on the London Stock Exchange. This international stock market index is a great place to find non-U.S. investment ideas.
You can download an Excel document containing useful investment metrics for each member of the FTSE 100 Index below:
The FTSE 100 Stocks List available for download above contains the following investing metrics for each index constituent:
- Dividend Yield
- Price-to-Earnings Ratio
- Market Capitalization
- Return on Equity
The rest of this article will provide a step-by-step walk through of how to use the FTSE 100 Stocks List to find unique international investment opportunities.
How To Use The FTSE 100 Stocks List To Find Investment Ideas
Having a database of all the stocks in the FTSE 100 Index along with relevant investing metrics can be very useful.
This resource becomes even more powerful when combined with a working knowledge of how to use Microsoft Excel.
With that in mind, this section will demonstrate how to implement three actionable investing screens to the FTSE 100 Stocks List.
The first screen that we’ll implement is for dividend-paying constituents of the FTSE 100 Index.
Screen 1: Dividend-Paying FTSE 100 Constituents
Step 1: Download the FTSE 100 Stocks List by clicking here.
Step 2: Click the filter icon at the top of the dividend yield column, as shown below.
Step 3: Change the filter setting to “Greater Than” and input 0 into the field beside it. This will filter for FTSE 100 stocks with dividend yields above 0% – in other words, the members of the FTSE 100 Index that actually pay dividends to their shareholders.
The remaining stocks in this spreadsheet are members of the FTSE 100 Index that pay dividends. The next screen that we’ll demonstrate how to implement is for stocks with market capitalization above $10 billion and returns on equity above 15%.
Screen 2: Large Market Capitalization, High Returns on Equity
Step 1: Download the FTSE 100 Stocks List by clicking here.
Step 2: Click on the filter icon at the top of the market capitalization column, as shown below.
Step 3: Change the filter setting to “Greater Than” and input 10 into the field beside it, as shown below. This will filter for FTSE 100 stocks with market capitalizations greater than $10 billion.
Step 4: Exit out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Then, click the filter icon at the top of the return on equity column, as shown below.
Step 5: Change the filter setting to “Greater Than” and input 0.15 into the field beside it. This will filter for FTSE 100 stocks with returns on equity exceeding 15%.
Close out of this final filter window. The remaining stocks in this Excel sheet are FTSE 100 stocks with market capitalizations above $10 billion and returns on equities above 15%.
The next screen that we’ll demonstrate how to implement is for FTSE 100 stocks with price-to-earnings ratios below 15 and market capitalizations between $2 billion and $10 billion.
Screen 3: Mid-Capitalization Value Stocks
Step 1: Download the FTSE 100 Stocks List by clicking here.
Step 2: Click the filter icon at the top of the price-to-earnings column, as shown below.
Step 3: Change the filter setting to “Less Than” and input 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 corner). Then, click the filter button at the top of the market capitalization column, as shown below.
Step 5: Change the filter setting to “Greater Than” and input 2 into the field beside it, as shown below.
Step 6: Change the secondary filter setting to “Less Than” and input 10 into the field beside it, as shown below.
The remaining stocks in this Excel sheet are members of the FTSE 100 Index with market capitalizations between $2 billion and $10 billion that have price-to-earnings ratios no higher than 15.
You now have a solid understanding of how to use the FTSE 100 Stocks List to find compelling investment opportunities on the London Stock Exchange.
The next section of this article will present some other useful investing resources that you can leverage in the hunt for your next great investment.
Other Useful Investing Resources
The FTSE 100 Stocks List is an excellent place to find investment opportunities on the London Stock Exchange.
With that said, it is not the only resource that you can use to find investment ideas.
With that is mind, the purpose of this final section of this article is to present some additional resources that you can use to find investment opportunities.
If you’re looking for high-quality dividend growth stocks suitable for long-term investment, the following databases will be useful:
- 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 stocks, the Dividend Kings are an ultra-exclusive group of dividend stocks with 50+ years of consecutive dividend increases.
Another good place to look for investment ideas is among the “blue chip stocks,” high-quality businesses that we loosely characterize as having 100+ year operating histories and 3%+ dividend yields. You can access our database of blue chip stocks below:
Alternatively, you may be interested in finding attractive investment opportunities within a particular sector of the stock market. If that is indeed the case, the following databases will be useful:
- The Complete List Of All Dividend-Paying Financial Stocks
- The Complete List Of All Dividend-Paying Consumer Cyclical Stocks
- The Complete List Of All Dividend-Paying Consumer Staples Stocks
- The Complete List Of All Dividend-Paying Energy Stocks
- The Complete List Of All Dividend-Paying Industrial Stocks
- The Complete List Of All Dividend-Paying Materials Stocks
- The Complete List Of All Dividend-Paying Healthcare Stocks
- The Complete List Of All Dividend-Paying Technology Stocks
- The Complete List Of All Dividend-Paying Telecommunications Stocks
- The Complete List Of All Dividend-Paying Utility Stocks
A last place to find investment ideas is by looking within the portfolio of the world’s best investor. With that in mind, the following Sure Dividend database will prove useful:
