A free cash flow yield screener ranks stocks by free cash flow divided by market capitalization, so the companies generating the most cash per dollar of market value sit at the top. In Excel, MarketXLS computes the yield as =1/PriceToFreeCash("VZ")*100, or as =LeveredFreeCashFlow("VZ")/MarketCapitalization("VZ")*100. This guide's free template screens 26 large-cap stocks this way; in the July 11, 2026 snapshot, Verizon (11.1%), AT&T (10.0%), and Altria (9.1%) had the highest FCF yields.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
Free cash flow yield is one of the most honest single numbers in equity analysis. Earnings can be shaped by accruals, depreciation schedules, and accounting choices. Free cash flow is the cash left after a business pays to keep its lights on and grow its asset base, and free cash flow yield tells you how much of that cash you are buying for each dollar you pay. This post walks through what the metric means, how to build the screener in Excel, what the current large-cap landscape looks like, and how the downloadable dashboard puts it all together.
Free cash flow yield screener at a glance
The table below is the headline output of the template: the highest free cash flow yields across a diversified large-cap universe, ranked from cheapest cash generation to most expensive. Values are illustrative snapshots as of July 11, 2026, and update live in the template version.
| Rank | Ticker | Sector | FCF Yield % | P/FCF | Div Yield % | Total Cash Yield % |
|---|---|---|---|---|---|---|
| 1 | VZ | Communications | 11.1% | 9.0x | 6.3% | 17.4% |
| 2 | T | Communications | 10.0% | 10.0x | 4.5% | 14.5% |
| 3 | MO | Consumer Staples | 9.1% | 11.0x | 7.0% | 16.1% |
| 4 | PFE | Health Care | 8.3% | 12.0x | 6.5% | 14.8% |
| 5 | QCOM | Technology | 6.7% | 15.0x | 2.0% | 8.7% |
| 6 | CSCO | Technology | 6.3% | 16.0x | 2.9% | 9.2% |
| 7 | MRK | Health Care | 5.9% | 17.0x | 3.3% | 9.2% |
| 8 | XOM | Energy | 5.6% | 18.0x | 3.4% | 9.0% |
| 9 | ABBV | Health Care | 5.6% | 18.0x | 3.2% | 8.8% |
| 10 | JNJ | Health Care | 5.3% | 19.0x | 3.1% | 8.4% |
Across the full 26-name universe, the average free cash flow yield sits near 5.2%, the median price-to-free-cash-flow multiple is roughly 21.5x, and 12 of the 26 companies clear a 5% FCF yield threshold. Together the group generates well over $600 billion in trailing free cash flow. Those are the kinds of aggregate numbers the dashboard surfaces automatically in its KPI tile row, so you never have to recompute them by hand.
What free cash flow yield actually measures
Free cash flow yield is defined as free cash flow divided by market capitalization, expressed as a percentage. It is the cash-based mirror image of the earnings yield. Where the earnings yield uses accounting net income, the FCF yield uses the cash a business actually produced after capital spending.
The formula is simple:
FCF Yield = Free Cash Flow / Market Capitalization
Equivalently, because the price-to-free-cash-flow multiple (P/FCF) is market cap divided by free cash flow, the FCF yield is just its inverse:
FCF Yield = 1 / (Price to Free Cash Flow)
A company trading at 10x free cash flow has a 10% FCF yield. A company trading at 40x has a 2.5% FCF yield. Lower multiples mean higher yields, and higher yields mean you are paying less for each dollar of cash the business throws off.
Why does this matter more than a headline P/E ratio? Because free cash flow is what funds dividends, buybacks, debt reduction, and reinvestment. A company can report strong earnings while burning cash, or report modest earnings while generating enormous cash. Free cash flow yield cuts through the accounting and asks a blunt question: how much cash am I getting for my money?
Where the cash is: reading the current landscape
The screener reveals a clear pattern in mid-2026. The highest free cash flow yields cluster in mature, capital-light-relative-to-cash businesses that the market prices conservatively.
- Telecom leads. Verizon and AT&T top the list at roughly 11.1% and 10.0% FCF yields. These are heavily capitalized businesses, but their free cash flow relative to a depressed market value produces the richest yields in the group. Layer on their dividends and the total cash yield exceeds 14%.
- Tobacco and pharma follow. Altria at about 9.1% and Pfizer at about 8.3% show how out-of-favor sectors can offer high cash yields when sentiment is weak.
- Quality tech sits in the middle to low end. Qualcomm and Cisco offer respectable mid-single-digit FCF yields, but the megacap growth names - Apple near 3.1%, Microsoft near 2.4%, Oracle near 2.6% - carry premium multiples that compress their yields even though their absolute free cash flow is enormous.
At the sector level, the pattern is just as instructive:
| Sector | Avg FCF Yield % | Avg P/FCF | Read |
|---|---|---|---|
| Communications | ~7.0% | ~14x | Telecom drags the average up |
| Health Care | ~6.3% | ~16x | Cheap cash across pharma |
| Consumer Staples | ~5.4% | ~19x | Steady, defensive cash |
| Energy | ~5.3% | ~19x | Cyclical but cash-rich |
| Industrials | ~4.8% | ~21x | Solid mid-tier yields |
| Consumer Disc. | ~3.9% | ~26x | Premium multiples |
| Technology | ~4.1% | ~26x | High growth, low yield |
The takeaway is not that telecom is a buy and technology is a sell. It is that free cash flow yield and growth expectations are usually in tension. The market pays up for expected growth (compressing FCF yield) and pays down for perceived stagnation (expanding it). A disciplined screener helps you see that trade-off clearly rather than reacting to a single headline number. As always, this is educational analysis and not a recommendation to buy or sell any security.
Building the free cash flow yield screener in Excel with MarketXLS
The reason this screener is worth building in Excel rather than reading off a website is that Excel lets you combine live data, your own thresholds, and your own scenario math in one place. MarketXLS provides the live data layer through native spreadsheet functions. Every formula below was verified against the MarketXLS function library before being used.
Core formulas
The heart of the screener is the price-to-free-cash-flow function and its inverse:
=PriceToFreeCash("VZ") → Price to free cash flow multiple (P/FCF)
=1/PriceToFreeCash("VZ")*100 → Free cash flow yield, in percent
Formula documentation: PriceToFreeCash
To show the underlying dollars and put the yield in context, the template also pulls:
=LeveredFreeCashFlow("VZ") → Levered free cash flow, in dollars
=MarketCapitalization("VZ") → Market capitalization, in dollars
=QM_Last("VZ") → Current share price
=PERatio("VZ") → Price-to-earnings ratio (TTM)
=ReturnOnEquity("VZ") → Return on equity (TTM)
=DividendYield("VZ") → Dividend yield (TTM)
=Sector("VZ") → GICS sector for grouping
Formula documentation: LeveredFreeCashFlow, MarketCapitalization, QM_Last, PERatio, ReturnOnEquity, DividendYield, Sector
With those functions, one row of the screener becomes fully live. Drop a ticker in column A, and the P/FCF, FCF yield, market cap, free cash flow, P/E, ROE, dividend yield, and sector all populate automatically. Copy the row down for your whole watchlist and you have a screener that refreshes whenever you open the file.
Turning raw functions into a ranked screener
A screener is more than a list of formulas - it is a ranked, sorted, color-coded view that tells you where to look first. In the template this is handled with:
- A FCF Yield column computed as
=1/PriceToFreeCash(ticker)*100, formatted as a percentage. - A three-color scale (red to amber to green) applied to the FCF yield column so the highest yields glow green and the lowest fade red.
- A reverse color scale on the P/FCF column, because there low is good.
- Data bars on the market cap column so you can see relative size at a glance.
- KPI tiles at the top that use
AVERAGE,MAX,MEDIAN, andCOUNTIFover the live screener range, so the summary statistics update the instant your data does.
That combination is what turns a plain grid into a dashboard.
A note on total cash yield
The template adds a second lens: total cash yield, defined as free cash flow yield plus dividend yield. The logic is that free cash flow funds both dividends and buybacks, so pairing the two gives a rough sense of total cash return relative to price. Verizon, for example, pairs an 11.1% FCF yield with a 6.3% dividend yield. That does not mean the two simply add to a guaranteed return - dividends are paid out of that same free cash flow - but as a screening heuristic it flags names where the market is pricing cash generation cheaply.
What is inside the premium template
This is not a bare spreadsheet. The download is a professional-grade, dashboard-style workbook with ten sheets, each designed to be presentation-ready. Here is the full walkthrough.
- Cover. A branded cover page with the title, 2026 edition tag, a one-line description, and a table of contents. Gridlines are hidden so it reads like the front of a product, not a worksheet.
- How To Use. A step-by-step tutorial that explains every input cell and every formula by name, so a first-time user can get value in minutes.
- Dashboard. The headline sheet. A KPI tile row across the top shows average FCF yield, top FCF yield, median P/FCF, and the count of names above a 5% yield. Below it sit two embedded charts - a top-ten FCF yield bar chart and an average-FCF-yield-by-sector chart - followed by the full screener table with the red-to-green conditional-formatting heatmap. Gridlines are hidden and a print area is set so it prints cleanly on one landscape page.
- Inputs / Controls. A dedicated control panel with yellow input cells and data-validation dropdowns: scenario (Conservative, Base, Aggressive), portfolio size, minimum FCF yield threshold, number of positions, watch tickers, and risk tolerance. Change one input and the downstream sheets respond.
- Scenario Analysis. A what-if matrix that flexes the assumed FCF yield from 3% to 10% and shows how annual cash captured, capital required per point of yield, and implied P/FCF change. Data bars and traffic-light icons make the outcomes obvious.
- Ranking & Signals. The full universe ranked by FCF yield, with a total-cash-yield column and a simple Strong / Watch / Hold signal driven by conditional formatting. Educational ranking only, not a recommendation.
- Portfolio / Allocation. A position-sizing calculator that turns your portfolio size and equal weights into dollar positions, projected annual free cash flow captured, and projected annual dividends, with a donut chart of the allocation.
- Sector Comparison. Sector-level averages for FCF yield, P/FCF, P/E, dividend yield, and total free cash flow, with a heatmap that shows where cash generation is cheapest.
- Methodology. A one-page explainer of how the model works, how FCF yield is calculated, the universe construction, the data sources, and the limitations.
- Glossary & Disclaimer. Plain-English definitions of every term used in the workbook, plus a clear educational-only disclaimer.
Every sheet carries MarketXLS branding, a footer with the book-a-demo link, and a "MarketXLS Functions Used in This Sheet" reference so you always know which formulas power the numbers.
The two versions: sample and live template
The download includes a free static sample and a live-formula workbook. Refreshing the live formulas requires a paid MarketXLS subscription.
Download the templates:
- - Pre-filled with static values as of July 11, 2026, with the exact MarketXLS formula shown in a comment on every data cell.
- - Live-updating formulas throughout, so every price, ratio, and yield refreshes with your MarketXLS data.
The sample file is the fastest way to see what the finished dashboard looks like and to learn which formula produces each number. The template file is the one you actually run: open it with MarketXLS installed, and the whole workbook comes alive.
How to use the screener day to day
Once you have the template open, a practical workflow looks like this.
- Set your universe. The default 26 names are large-cap cash generators across seven sectors, with financials excluded because reported free cash flow is not a clean metric for banks and insurers. Swap in your own tickers by editing column A of the screener.
- Set your threshold. On the Inputs sheet, set your minimum FCF yield. If you only want names yielding 6% or more, the dashboard and ranking sheets make the qualifiers obvious.
- Read the heatmap. Scan the FCF yield column for green. Cross-check the P/FCF column - green there (low multiple) confirms the cash is cheap.
- Sanity-check quality. A high FCF yield on its own is not enough. Glance at the ROE and P/E columns. A high yield paired with weak returns on equity may signal a value trap rather than a bargain.
- Run a scenario. Use the Scenario sheet to see how much annual cash a given portfolio size would capture at different assumed yields. This is arithmetic, not a forecast, but it frames the trade-off between yield and price.
- Size positions. The Portfolio sheet turns your choices into dollar allocations and projected cash. Adjust weights to match your own risk tolerance.
Why free cash flow yield belongs in your quality toolkit
Free cash flow yield pairs naturally with the other quality-factor screens investors run in Excel - return on invested capital, operating margin, interest coverage, and shareholder yield. Each looks at a different facet of business quality:
- ROIC asks how efficiently a company turns capital into profit.
- Operating margin asks how much of each sales dollar survives to operating income.
- Interest coverage asks whether the company can comfortably service its debt.
- Free cash flow yield asks how much cash you are buying for your money.
Used together, they help separate genuinely cheap, high-quality compounders from statistically cheap but structurally challenged businesses. The MarketXLS function library gives you a live formula for each, so you can build all of these screens in the same workbook and let them refresh side by side. For more on building live spreadsheets, see the MarketXLS formula library and the MarketXLS templates.
Frequently asked questions
What is a good free cash flow yield?
There is no universal cutoff, because free cash flow yield trades off against growth. Broadly, a yield above 5% on a stable large-cap is often considered attractive, and above 8% can signal either deep value or elevated risk. Fast-growing companies frequently carry FCF yields below 3% because the market prices their expected future cash rather than their current cash. The screener helps by showing each name relative to its sector and the universe average of roughly 5.2%, so you can judge yield in context rather than against a single magic number.
How is free cash flow yield calculated in Excel?
In this template it is calculated as =1/PriceToFreeCash(ticker)*100, which gives the yield as a percentage. Alternatively you can compute it directly as free cash flow divided by market cap: =LeveredFreeCashFlow(ticker)/MarketCapitalization(ticker)*100. Both approaches use live MarketXLS functions, so the result updates automatically as prices and fundamentals change.
What is the difference between free cash flow yield and dividend yield?
Dividend yield measures only the cash a company actually pays out to shareholders as dividends. Free cash flow yield measures all the free cash the business generates, whether it is paid as dividends, used for buybacks, applied to debt, or retained. Free cash flow yield is therefore usually higher than dividend yield, and the gap tells you how much cash is being reinvested or returned through channels other than the dividend. The template shows both, plus their sum as a total cash yield.
Why are financial stocks excluded from the screener?
For banks, insurers, and other financials, reported free cash flow is not a clean or comparable metric, because their business model is built on managing capital and float rather than generating operating cash the way an industrial or consumer company does. Including them would distort the rankings, so the default universe focuses on non-financial large caps. You can add financials manually if you understand the caveats, but the standard screen leaves them out.
Can I change the list of stocks in the template?
Yes. The screener is driven by the tickers in column A of the Dashboard sheet. Replace them with any symbols you follow, and the MarketXLS formulas will pull live P/FCF, free cash flow, market cap, P/E, ROE, dividend yield, and sector for each. The KPI tiles and charts recalculate automatically because they reference the live screener range.
Do I need MarketXLS for the template to work?
The live template version needs the MarketXLS add-in installed so its functions can pull data (prices are 15-minute delayed on the Standard plan and real-time on Advanced and Business; fundamentals such as free cash flow update as companies report). The sample version does not - it holds static values as of the stated date, with each formula shown in a cell comment, so you can explore the layout and logic without any add-in. Once you are ready for live data, the template version is the one to run.
The bottom line
A free cash flow yield screener measures how much cash each company generates relative to its market value, which is what funds dividends, buybacks, and debt reduction. An Excel screener turns that into a repeatable process rather than a one-off calculation. The template in this post is a ten-sheet workbook with a KPI overview, a color-coded screener, scenario analysis, position sizing, and a sector view, all driven by MarketXLS formulas so the numbers refresh when you recalculate.
Download both files above, open the live version with MarketXLS, and drop in your own watchlist. Then explore the rest of the MarketXLS function library to layer ROIC, margin, and coverage screens on top of your free cash flow yield view.
Ready to build live, professional-grade screeners in your own spreadsheets? Visit MarketXLS or book a demo to see the full function library in action.
