Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Free Cash Flow Yield Screener S&P

Written by  MarketXLS Team on 
Mon Jun 05 2017
 about Fundamental analysisValuation Models
Free Cash Flow Yield Screener S&P - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
Free Cash Flow Yield Screener S&P - MarketXLS

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.

Ad slot not ready
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

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

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord