Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Fundamental analysisValuation Models

Free Cash Flow Yield Screener S&P

Written by admin
Mon Jun 05 2017
Free Cash Flow Yield Screener
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Free Cash Flow Yield Screener
 

Investors use many valuation metrics while screening stocks for possible investments. This includes valuation ratios such as Price to Earnings ratio, price to book value, price to sales, price to cash flow and many others. While all these valuations metrics are good, one that has been attracting many investors is the Free Cash Flow Yield. In this article we will look at why free Cash Flow Yield is a good measure and we will also build a Free Cash Flow Yield Screener on S&P500 stocks using MarketXLS.

What is Free Cash Flow?

Free cash flow (FCF) refers to the cash generated by the firm’s operation that is available to shareholders after the company has paid for all its expenses.

Free Cash Flow = Cash Flow from Operations – Net Capital Expenditure

This includes having paid for o laying out cash for expenses, taxes, interest as well as long-term investments.

The company can use free cash flow for many purposes such as for developing new products, buy-back shares, issue dividends, or make acquisitions. Without free cash flow, the company will have to borrow to pay for these things.

A positive free cash flow indicates that the company is generating more cash flow than what is required to run the business which allows it to pursue other growth opportunities.

What is Free Cash Flow Yield?

Once we have the free cash flow, we can calculate the free cash flow yield by dividing free cash flow with the enterprise value.

Free Cash Flow Yield = Free cash FLow / Enterprise Value

The Enterprise Value is equal to the firm’s Market Capitalization + Debt – Cash.

A higher free cash flow yield means that the company generates more cash with the same market valuation which is good for investors. It is a good indicator to determine the investor’s payback period. The higher the free cash flow yield, the lower will be the investor payback period. For example, if the yield is 1%, the payback period will be 100 years. However with a yield of 5 years, the investor payback period will reduce to just 20 years.

Why investors like Free Cash Flow Yield?

There are many reasons why investors prefer Free Cash Flow yield over other valuation metrics:

  1. Strong balance sheet and cash flow generation capability
  2. The company is generating more cash flow than it needs to spend, thereby less dependency on external funding
  3. Free cash flow is a more reliable indicator of the firm’s profitability compared to its earnings. This is because free cash flow is more difficult to manipulate than the net income.
  4. It is based on market value, not book value of the firm.
  5. Negative free cash flow also is not bad. If a company has negative free cash flow it might mean that the company is making larger investments.

Free Cash Flow Yield Screener

In order to identify and invest in high free cash flow yield, investors can use a screener based on free cash flow yield. There are many ways to do it. One is to take all the S&P500 stocks, calculate their Free Cash Flow Yield and either pick the top 10-20 stocks or take stocks having a yield above certain percentage (suhas >10% yield). You can also combine other metrics such as dividend yield to further shortlist the stocks. For example you can use high free cash flow yield to screen for sustainable dividend yield. This combination indicates continuous income stream along with long-term capital appreciation.

Free Cash Flow Yield Screener for S&P500 in Excel using MarketXLS

We have created a Free Cash Flow Yield screener template that downloads the latest list of the S&P500 stocks, calculates the Free Cash Flow Yield for each stock and then filters the stocks with the top yield. The yield is calculated using the MarketXLS historical fundamentals functions. You will need a licensed copy of MarketXLS to use the template.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Invest with confidence with billions of data points and thousands of pre-built functions and templates.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

NACCO Industries Inc. logo

NACCO Industries Inc.

51.74
 
USD
 
1.76
 
(3.52%)
81
Rank
Optionable: No
Market Cap: 367 M
Industry: Coal
52 week range    
28.32   
   63.19
Cintas Corporation logo

Cintas Corporation

411.94
 
USD
 
0.92
 
(0.22%)
81
Rank
Optionable: Yes
Market Cap: 39,137 M
Industry: Business Services
52 week range    
343.86   
   461.44
Hibbett Sports Inc. logo

Hibbett Sports Inc.

54.84
 
USD
 
2.01
 
(3.80%)
80
Rank
Optionable: Yes
Market Cap: 677 M
Industry: Specialty Retail
52 week range    
39.58   
   101.65
EOG Resources Inc. logo

EOG Resources Inc.

126.08
 
USD
 
0.91
 
(0.73%)
79
Rank
Optionable: Yes
Market Cap: 61,798 M
Industry: Oil & Gas E&P
52 week range    
80.67   
   147.99
Darden Restaurants Inc. logo

Darden Restaurants Inc.

133.10
 
USD
 
0.88
 
(0.67%)
79
Rank
Optionable: Yes
Market Cap: 16,207 M
Industry: Restaurants
52 week range    
110.96   
   157.85
Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

111.67
 
USD
 
1.61
 
(1.46%)
79
Rank
Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
63.45   
   142.78
Waste Connections Inc. logo

Waste Connections Inc.

141.81
 
USD
 
-0.86
 
(-0.60%)
78
Rank
Optionable: Yes
Market Cap: 35,409 M
Industry: Waste Management
52 week range    
113.50   
   148.20
STORE Capital Corporation logo

STORE Capital Corporation

31.48
 
USD
 
0.11
 
(0.35%)
77
Rank
Optionable: Yes
Market Cap: 8,868 M
Industry: REIT - Diversified
52 week range    
24.48   
   36.13
Buckle Inc. (The) logo

Buckle Inc. (The)

34.87
 
USD
 
0.54
 
(1.57%)
77
Rank
Optionable: Yes
Market Cap: 1,720 M
Industry: Apparel Stores
52 week range    
26.50   
   57.10
ICF International Inc. logo

ICF International Inc.

114.55
 
USD
 
0.52
 
(0.46%)
76
Rank
Optionable: Yes
Market Cap: 1,994 M
Industry: Business Services
52 week range    
84.68   
   114.79

More Features