The Complete List of FTSE 100 Stocks - Sure Dividend Sure Dividend

Sure Dividend

The Complete List of FTSE 100 Stocks

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:

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.

FTSE 100 Stocks Excel Tutorial 1

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.

FTSE 100 Stocks Excel Tutorial 2

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.

FTSE 100 Stocks Excel Tutorial 3

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.

FTSE 100 Stocks Excel Tutorial 4

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.

FTSE 100 Stocks Excel Tutorial 5

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%.

FTSE 100 Stocks Excel Tutorial 6

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.

FTSE 100 Stocks Excel Tutorial 7

Step 3: Change the filter setting to “Less Than” and input 15 into the field beside it, as shown below.

FTSE 100 Stocks Excel Tutorial 8

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.

FTSE 100 Stocks Excel Tutorial 9

Step 5: Change the filter setting to “Greater Than” and input 2 into the field beside it, as shown below.

FTSE 100 Stocks Excel Tutorial 10

Step 6: Change the secondary filter setting to “Less Than” and input 10 into the field beside it, as shown below.

FTSE 100 Stocks Excel Tutorial 11

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:

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:

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: