Free cash flow (FCF) yield is free cash flow (operating cash flow minus capital expenditures) divided by market capitalization: the cash a business generates for each dollar of market value. It avoids some of the non-cash accounting items that distort P/E ratios, which makes it a useful valuation screen in 2026, when heavy AI-related capital spending separates reported earnings from cash.
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
This guide ships a complete, dashboard-style Excel template that puts FCF yield on a screener of 35 U.S. large caps with sector heatmaps, KPI tiles, scenario analysis, and a rank-weighted portfolio sizer. Every metric is a MarketXLS formula that refreshes when the workbook recalculates.
Free Cash Flow Yield at a Glance: 35 Large Caps, May 2026 Snapshot
| Rank | Ticker | Sector | FCF Yield | FCF / EV Yield | P/E | Notes |
|---|---|---|---|---|---|---|
| 1 | VZ | Communication Svcs | 10.89% | 5.91% | 14.0 | Highest gross yield, debt-heavy |
| 2 | COP | Energy | 7.85% | 7.03% | 11.5 | Cycle-sensitive cash king |
| 3 | IBM | Technology | 7.69% | 5.85% | 22.5 | Software transition mature |
| 4 | CSCO | Technology | 7.40% | 6.45% | 17.0 | Mature platform, big buybacks |
| 5 | XOM | Energy | 7.25% | 6.73% | 13.5 | Capital discipline working |
| 6 | CVX | Energy | 6.96% | 6.46% | 14.0 | Downstream + upstream cash |
| 7 | PFE | Healthcare | 6.77% | 4.77% | 12.0 | Patent cliff overhang |
| 8 | MRK | Healthcare | 6.36% | 5.83% | 22.4 | Keytruda cash machine |
| 9 | CAT | Industrials | 6.06% | 5.13% | 14.8 | Backlog supportive |
| 10 | UNH | Healthcare | 5.56% | 5.00% | 25.6 | Insurance + Optum cash |
The full screener inside the template covers 35 names across 11 sectors with conditional formatting (red-amber-green color scales), data bars on market cap, and dedicated KPI tiles for median yield, top yield, FCF/EV yield, and the count of cash-rich names above your threshold.
Why Free Cash Flow Yield Matters More in 2026
Earnings per share has been the default valuation anchor for most of the last two decades. It is also one of the most accounting-distorted numbers a company reports. Non-cash impairments, stock-based compensation treatment, and one-time gains routinely make headline earnings look dramatically different from the actual cash a business generated. Free cash flow yield bypasses all of that.
The 2026 backdrop sharpens the case. Rates have stayed higher than the consensus expected at the start of the cycle, which means cost of capital is no longer free. AI capex has exploded, with hyperscalers spending well over $300 billion annually on data center buildouts. That capex shows up as a drag on free cash flow, which is exactly why investors are paying more attention to who is generating real cash today versus who is promising it tomorrow.
In this environment, a 5% FCF yield is more interesting than a 3% earnings yield because:
- Cash is harder to fake - non-cash adjustments do not flow through FCF.
- Capex discipline shows up - reinvestment-heavy names get penalized appropriately.
- Buyback capacity is visible - high FCF yield is the precondition for sustained buybacks.
- Comparable across sectors - earnings yield is distorted by leverage and depreciation differences.
The dashboard inside this template is built around exactly that framing.
What is Free Cash Flow Yield?
Free Cash Flow Yield is calculated as:
FCF Yield = Levered Free Cash Flow / Market Capitalization
Levered free cash flow is the cash a company generates after operating expenses, taxes, working capital changes, and capital expenditures, net of interest payments. Market capitalization is share price times shares outstanding. The ratio is expressed as a percentage and is the mathematical inverse of the Price to Free Cash Flow ratio.
A complementary version is the FCF to Enterprise Value Yield:
FCF / EV Yield = Levered Free Cash Flow / Enterprise Value
Enterprise Value is Market Cap plus Total Debt minus Cash. Using EV in the denominator strips out capital structure differences, making it easier to compare a debt-heavy utility against a debt-light tech business on a level playing field. The dashboard surfaces both metrics side by side because each tells a different story.
What's Inside the Template (10-Sheet Walkthrough)
The template is designed to look like a finished product the moment you open it. Every sheet has a job, every color choice is intentional, and every formula references the Inputs sheet so you can drive the whole workbook from one place.
1. Cover
A branded landing page with the template title, version number, "Data as of" date, and a clickable table of contents. No data, no clutter - pure presentation. Hidden gridlines, deep navy background, yellow MarketXLS accent strip.
2. How To Use
A 10-step quick start that walks a new user from "open the file" to "first screen." Below it, a formula reference table lists every MarketXLS function used in the workbook so users can build their own variations. Links to marketxls.com and the demo booking page are included on this sheet.
3. Dashboard
The headline view. A KPI tile row across the top with seven tiles: median FCF yield, count of cash-rich stocks, top FCF yield ticker, median FCF/EV yield, sector spread, count of negative-FCF names, and median P/FCF. Below the tiles, two embedded charts: Median FCF Yield by Sector and Top 10 Stocks by FCF Yield. Below the charts, the full screener of 35 names with conditional formatting on yield (red-amber-green), data bars on market cap, color scales on P/E (lower better), ROE (higher better), and Debt/Equity (lower better). Frozen panes. Print area set to print cleanly on a single landscape page. Hidden gridlines.
4. Inputs / Controls
The control panel. Yellow input cells with bold navy borders for every parameter that drives the workbook: scenario mode dropdown (Conservative / Base / Aggressive), minimum FCF yield threshold, maximum P/E, maximum Debt/Equity, minimum ROE, sector filter dropdown, total portfolio size, max position size, holdings range, rebalance frequency, risk tolerance, and three custom ticker overrides. Below the inputs, a Scenario Discount Rates block shows the discount rate, FCF growth assumption, and terminal multiple applied for each scenario mode.
5. Scenario Analysis
A matrix showing how the portfolio changes as the FCF yield threshold moves from 2% to 8%. For each threshold row, the sheet computes the count of eligible names, blended FCF yield, median P/E, median ROE, payback period (1/yield), and the implied IRR under Conservative, Base, and Aggressive scenarios. Conditional formatting highlights the trade-off: tightening the threshold improves quality but shrinks the universe. Two embedded charts visualize the trade-off curve.
6. Sizing & Strategy
A rank-weighted portfolio sizer. Takes the top 15 names by FCF yield, applies linearly decreasing weights capped at the Max Position Size from Inputs, and computes dollar allocation, shares to buy, entry price, stop loss (-15%), and target (+25%) per name. Data bars on the weight column give a quick visual of concentration.
7. Portfolio / Allocation
Aggregates the rank-weighted basket by sector. Shows weight, dollar allocation, median FCF yield, and a risk note per sector. A donut chart visualizes the sector breakdown. Conditional formatting flags concentration risk.
8. Sector Comparison
A color-coded matrix comparing all 11 sectors on median FCF yield, median P/E, median ROE, median Debt/Equity, dispersion within the sector, and a composite Quality Rank score. Color scales make it instantly clear which sectors are attractive on cash and which are trading rich.
9. Methodology
A one-page explainer of how every metric is calculated, what assumptions sit behind the scenario rates, and how the rank weighting works. Limitations are called out explicitly - capital-intensive sectors look optically cheap on FCF Yield because they reinvest, and quarterly FCF can be lumpy.
10. Glossary & Disclaimer
Twelve term definitions covering FCF, FCF Yield, FCF/EV Yield, P/FCF, Enterprise Value, P/E, ROE, Debt/Equity, Dispersion, Rank Weighting, and Scenario Mode. Plus the educational-only disclaimer.
The Approach: How to Read FCF Yield
Free cash flow yield is most powerful when treated as one lens in a stack, not a single-factor verdict. The template enforces this discipline by combining FCF yield with quality screens (ROE, Debt/Equity, P/E) and by reporting both the gross FCF yield and the capital-structure-neutral FCF/EV yield.
A few framing principles that the dashboard makes easy to apply:
Compare within sectors first, then across. A 7% FCF yield in Energy is normal because the sector trades on commodity cycles. A 7% FCF yield in Technology is exceptional because the sector trades on growth multiples. The Sector Comparison sheet makes this explicit by ranking sectors against their own median.
Watch the gap between FCF yield and FCF/EV yield. When the two yields are close, the balance sheet is clean. When FCF yield is materially higher than FCF/EV yield, the company carries enough net debt that the equity is being "yielded up" by leverage. The dashboard surfaces both so this gap is immediately visible.
Treat negative FCF as information, not exclusion. Two names in the universe currently show negative FCF (utilities deep in their capex cycle). The dashboard keeps them visible rather than hiding them, because seeing the negatives helps calibrate the positives.
Use the scenario matrix to stress-test thresholds. The instinct is to set a high FCF yield threshold to ensure quality. The matrix shows the cost - moving from 4% to 6% might shrink the universe from 24 names to 9. Whether that trade-off is worth it depends on your conviction and risk tolerance.
This is analysis, not advice. The template is a structured way to organize the question, not a prescription for the answer.
Building It in Excel: MarketXLS Formulas
Every value in the live template flows from a verified MarketXLS function. The core block looks like this:
Price: =QM_Last("AAPL")
Market Cap: =MARKETCAPITALIZATION("AAPL")
Enterprise Val: =ENTERPRISEVALUE("AAPL")
Levered FCF: =LEVEREDFREECASHFLOW("AAPL")
FCF Yield: =LEVEREDFREECASHFLOW("AAPL")/MARKETCAPITALIZATION("AAPL")
FCF/EV Yield: =LEVEREDFREECASHFLOW("AAPL")/ENTERPRISEVALUE("AAPL")
P/FCF: =PRICETOFREECASH("AAPL")
P/E: =PERATIO("AAPL")
ROE: =RETURNONEQUITY("AAPL")
Debt/Equity: =TOTALDEBTTOEQUITY("AAPL")
Dividend Yield: =DIVIDENDYIELD("AAPL")
Operating Mgn: =OPERATINGMARGIN("AAPL")
Sector: =SECTOR("AAPL")
Industry: =INDUSTRY("AAPL")
Formula documentation: QM_Last, MARKETCAPITALIZATION, ENTERPRISEVALUE, LEVEREDFREECASHFLOW, PRICETOFREECASH, PERATIO, RETURNONEQUITY, TOTALDEBTTOEQUITY, DIVIDENDYIELD, OPERATINGMARGIN, SECTOR, INDUSTRY
Wrap the FCF yield calculations in IFERROR so blank cells or unavailable data do not break the screener:
=IFERROR(LEVEREDFREECASHFLOW("AAPL")/MARKETCAPITALIZATION("AAPL"), 0)
Formula documentation: LEVEREDFREECASHFLOW
To make the screener react to the Inputs sheet, the eligibility logic becomes a compound condition:
=IF(AND(
FCF_Yield >= Inputs!C8,
PE <= Inputs!C9,
Debt_Eq <= Inputs!C10,
ROE >= Inputs!C11
), "Pass", "Fail")
The Scenario Analysis matrix uses COUNTIFS and AVERAGEIFS over the screener output to compute eligible counts and blended yields per threshold. The rank-weighted sizer uses RANK against the FCF yield column, then converts each rank into a weight via MIN(rank_weight, Inputs!Max_Position_Size).
Download the Templates
The static sample workbook is free. Live MarketXLS formulas require a paid MarketXLS subscription. The sample has every data point pre-filled so you can see what the dashboard looks like before installing anything. The template has live MarketXLS formulas - install MarketXLS, sign in, refresh, and the entire workbook fills in.
- - Pre-filled with current data, every cell has a comment showing the underlying MarketXLS formula
- - Live-updating formulas, zero static data
Both files preserve the same design - branded cover page, KPI dashboard, conditional formatting, dropdowns, charts, and 10 sheets of structured analysis. Open them and the look is presentation-ready.
How the Dashboard Handles Edge Cases
Real screens break the moment you encounter a special case. The template handles three of them explicitly.
Negative FCF. Two names in the universe (NEE, SO) currently show negative levered FCF because they are deep in their capex cycle. The dashboard does not hide them. Negative-yield cells turn red in the conditional formatting, the count of negative-FCF names is a KPI tile on the Dashboard, and the Scenario Analysis sheet excludes them above each threshold automatically.
FCF lumpiness. FCF can swing meaningfully quarter-to-quarter on working capital changes. The template uses trailing-twelve-month values (the MarketXLS default for LEVEREDFREECASHFLOW). For names with notably volatile FCF, the Methodology sheet calls out that single-quarter snapshots can mislead, and the Comparison sheet's Dispersion column (max minus min FCF yield within a sector) flags where intra-sector variance is high.
Capital-intensive distortion. Utilities, telecoms, and pipelines look unattractive on FCF Yield because they reinvest aggressively. They often look much better on FCF/EV Yield once leverage is accounted for. The dashboard reports both side by side, and the Sector Comparison sheet adds context by showing how much of each sector's optical cheapness is leverage-driven.
When FCF Yield Disagrees with Earnings Yield
One of the most useful diagnostic moves is to look at FCF Yield and Earnings Yield side by side. When they agree, the business is converting accounting earnings to cash cleanly. When they diverge, there is something to investigate.
| Pattern | What It Often Means |
|---|---|
| FCF Yield > Earnings Yield | Depreciation > capex (e.g. legacy tech businesses), favorable working capital, or stock-based comp drag on GAAP earnings |
| FCF Yield < Earnings Yield | Heavy capex (utilities, AI infra, hyperscalers), unfavorable working capital, or non-cash gains lifting GAAP earnings |
| FCF Yield ~ Earnings Yield | Clean conversion, mature business |
The Methodology sheet has the formal explanation. The Dashboard surfaces both yields per ticker in adjacent columns so you can spot the gaps visually.
Sector-by-Sector Observations from the May 2026 Universe
Sector medians from the included universe (the Sector Comparison sheet ranks all 11):
- Energy carries the highest median FCF yield (about 7.4%). The integrated majors have entered a capital-discipline phase and are returning cash through dividends and buybacks rather than chasing volume.
- Healthcare sits comfortably in the middle (around 6%), supported by mature drug franchises and managed care cash flow. Patent cliffs remain the swing factor.
- Communication Services is dominated by VZ on the high end and the platform tech names lower. The dispersion is wide.
- Technology medians look low (under 3%) because the AI capex cycle is pulling cash flow out near term. But several mature platform names (CSCO, IBM, ORCL) trade at attractive FCF yields relative to their growth.
- Consumer Staples are predictably defensive and FCF-generative, but valuations have already pushed yields below long-term medians.
- Utilities show optically negative FCF yields right now because grid investment is running hot. FCF/EV yield is less negative, and the income story is dividend-yield-driven, not FCF-yield-driven.
These are observations, not recommendations. The template gives you the data to update them as new quarters print.
Common Mistakes When Using FCF Yield
A high FCF yield can be a value signal, a value trap, or a one-quarter anomaly. The dashboard surfaces the data, but the analyst still has to interpret it. Some traps to watch for:
One-time working capital benefits. A company that aggressively pulls forward receivables collections or stretches payables can post a great FCF quarter that does not repeat. Cross-check against the four-year trailing FCF before treating a single TTM number as a baseline.
Underinvestment masquerading as discipline. A company that cuts capex below maintenance levels will show better FCF temporarily but is mortgaging its competitive position. Compare capex-to-depreciation. If capex is consistently below depreciation for several years, that is a red flag.
Cyclical peak FCF. Energy, materials, and cyclicals can post extraordinary FCF yields at the top of their cycles. Use multi-year averages where possible. The Sector Comparison sheet helps by showing dispersion - high dispersion within a sector is often a cycle signal.
Buyback flattering EPS but not FCF. Aggressive buybacks shrink the share count and lift EPS but do not change FCF. If a company's earnings yield improves but FCF yield does not, the improvement is financial engineering, not operating performance.
The template flags these by combining FCF yield with quality screens (ROE, Debt/Equity) and a sector context. No screen replaces fundamental research, but this one organizes the question.
FAQ
What is a good free cash flow yield?
There is no single threshold that holds across sectors and time. As a rough heuristic, FCF yields above the 10-year Treasury yield are considered reasonably attractive for equities. With the 10-year hovering around 4-4.5% in mid-2026, FCF yields of 5% or higher generally clear that bar. But the more useful question is "good relative to what" - compare to the sector median, compare to the company's own historical range, and compare to the risk-free rate.
How is FCF yield different from dividend yield?
Dividend yield is what a company pays out to shareholders annually as a percent of share price. FCF yield is what a company could pay out - it represents the full pool of distributable cash. FCF yield is usually higher than dividend yield because companies retain cash for buybacks, debt paydown, M&A, or balance sheet building. When dividend yield is greater than FCF yield, the dividend is being funded by something other than current cash generation, which is unsustainable.
Why use levered free cash flow rather than unlevered?
Levered FCF is the cash available to equity holders after interest payments. Unlevered FCF (also called free cash flow to the firm) is the cash available to all capital providers before interest. For a yield calculation against market capitalization, levered FCF is the conceptually consistent numerator. For a yield against Enterprise Value, unlevered FCF is more consistent. The template includes both perspectives (FCF Yield uses Levered FCF over Market Cap; FCF/EV Yield uses the same Levered FCF over EV to keep the comparison consistent against one denominator at a time).
Can I customize the ticker universe?
Yes. The screener uses 35 large-cap names as a baseline, but you can replace any ticker in column A and the row's MarketXLS formulas will refresh. The Inputs sheet also includes three custom ticker slots that the Scenario Analysis sheet can reference. To expand the universe, copy a screener row, paste below the existing block, and update the ticker.
How often does FCF data update?
MarketXLS pulls fundamentals (including levered FCF, market cap, enterprise value, P/E, ROE, and debt metrics) from licensed fundamental data feeds. Updates typically follow company earnings releases. Price data (=QM_Last) updates intraday. For the screener, recalculate after the next quarterly earnings cycle to refresh the FCF figures.
Is this template suitable for international stocks?
The screener was designed for U.S. large caps but the MarketXLS formulas work for international tickers where coverage exists. Add the appropriate ticker suffix (e.g. ".LON" for London-listed shares, ".TO" for Toronto). FCF data availability varies by region and exchange - if a function returns blank or zero, the IFERROR wrapper will keep the screener intact.
What is FCF/EV Yield and when should I use it instead?
FCF/EV Yield is Levered FCF divided by Enterprise Value. It is the better metric when comparing companies with different capital structures. A debt-heavy company can show an attractive FCF Yield on Market Cap simply because debt is doing the heavy lifting. FCF/EV Yield levels the playing field by treating the company as if it were being acquired - the acquirer cares about cash generation relative to the full takeover price, debt and all. Use FCF/EV Yield when comparing across sectors (especially utilities, telecoms, and capital-intensive industries against tech). Use FCF Yield when focused purely on equity holders.
Does this work for small caps?
The template structure works for any cap, but data coverage for small caps is thinner and quarterly FCF can be much lumpier in absolute terms. For small-cap screens, consider extending the FCF averaging window (use multi-year averages instead of TTM) and tighten the quality filters (higher minimum ROE, lower max Debt/Equity).
The Bottom Line
Free cash flow yield is the most defensible single-number valuation lens for 2026. It bypasses accounting noise, exposes capex discipline, and rewards businesses that generate real cash today. This dashboard organizes the metric into a presentation-ready Excel workbook with KPI tiles, conditional formatting, scenario analysis, and a rank-weighted sizer that flows from a single Inputs sheet.
Download the sample to see the design. Download the live template to plug into MarketXLS and run your own screens. The template is free, the structure is professional-grade, and the formulas are real.
For more on MarketXLS, visit marketxls.com or book a demo. For related templates, explore the Forward Earnings Yield Dashboard, the Owner Earnings Calculator, and the EV/EBITDA Screener which cover adjacent valuation angles.