ROIC Screener Excel: Rank Quality Compounders by Return on Invested Capital (2026 Dashboard)

ROIC screener excel - if that is the search that brought you here, you are almost certainly trying to separate genuine quality compounders from businesses that only look good on the surface. Return on invested capital is the single number that professional analysts lean on most when they want to know whether a company actually creates value with the money it deploys. This guide walks through how to build a dashboard-style ROIC screener in Excel, which MarketXLS formulas power it, and it gives you a free, professional-grade template you can download and open today.

Q2 2026 earnings season is now underway, and with it comes the usual flood of headline beats and misses. The problem with headline numbers is that they say very little about business quality. A company can grow revenue, beat on earnings per share, and still be quietly destroying capital. ROIC cuts through that noise. It tells you, for every dollar of debt and equity put to work, how much profit the business generates. That is why an ROIC screener belongs in every serious investor's Excel toolkit, and why we built this one to look and feel like a product rather than a plain grid.

ROIC Screener Excel: The Quick Comparison

Before the deep dive, here is the at-a-glance view of what a proper ROIC screener tracks, and how the illustrative universe in this template stacks up. All figures below are sample values as of the data date in the template; the live version refreshes them automatically.

The table hints at something the full screener makes obvious: the highest-ROIC names are not always the highest-ROE names, and margin profiles differ wildly across business models. That is exactly the kind of nuance a good dashboard surfaces at a glance.

What ROIC Actually Measures (And Why It Beats ROE Alone)

Return on invested capital is after-tax operating profit divided by the capital actually invested in the business, meaning debt plus equity. In plain terms, it answers a deceptively simple question: when this company reinvests a dollar, what does it earn back?

The reason ROIC is prized above return on equity is that ROE can be flattered by leverage. A company that borrows heavily can post a spectacular ROE while its underlying business economics are only average. Because ROIC includes debt in the denominator, it strips that illusion away. When you see a business with high ROIC and high ROE together, you are usually looking at a genuine compounder with a durable competitive advantage. When you see high ROE but middling ROIC, leverage is often doing the heavy lifting.

This is why the template dedicates an entire Comparison Matrix sheet to plotting ROIC against ROE. It sorts every name into one of four buckets:

• Compounder - high ROIC and high ROE. The business earns strong returns without relying on debt.
• Capital-efficient - high ROIC, lower ROE. Often a conservatively financed, high-quality operator.
• Leverage-driven - lower ROIC, high ROE. Returns are partly a function of borrowing.
• Watch - neither metric clears the bar. Needs deeper work before it earns a place on a shortlist.

That framing turns a wall of numbers into an investing insight in seconds, which is the whole point of a dashboard.

Why an ROIC Screener Matters Right Now

Three things make ROIC screening especially relevant in the current market.

First, the cost of capital has stayed elevated relative to the near-zero years. When money is cheap, almost any project clears the hurdle and low-quality growth gets rewarded. When capital costs more, the gap between businesses that earn above their cost of capital and those that do not becomes the whole ballgame. ROIC is the cleanest way to measure that gap.

Second, we are in the thick of Q2 2026 earnings. Reports will move prices on revenue and EPS surprises, but the durable question for a long-term holder is whether reported profits are being generated on a shrinking or an expanding base of invested capital. A screener lets you re-rank your universe the moment new fundamentals post.

Third, quality has re-emerged as a factor investors care about after several rotations. A repeatable, transparent way to rank quality, rather than relying on vague labels, is exactly what a spreadsheet does best. You define the criteria, the formulas do the work, and the ranking is honest.

Nothing here is a recommendation to buy or sell any security. The tickers in the template exist to show how the formulas behave. The value is in the process, not in any single name.

The Approach: A Transparent Quality Score

The heart of this template is a Quality Score that blends the metrics that matter into a single, sortable number. The hypothesis, and it is only an educational hypothesis, is that businesses scoring well across ROIC, ROE, operating margin, revenue growth, and balance-sheet strength tend to share the characteristics investors associate with quality. The score is a ranking aid, not a rating, and certainly not a prediction.

The default weighting is:

• ROIC: 40 percent
• ROE: 20 percent
• Operating margin: 20 percent
• Revenue growth: 10 percent
• Low debt (inverse of debt-to-equity): 10 percent

Every one of those weights lives in a yellow input cell on the Inputs sheet. If you care more about growth than balance-sheet safety, nudge the weights and the entire Dashboard re-ranks instantly. That is the difference between a static list someone hands you and a tool you actually control.

MarketXLS Implementation: The Formulas That Power It

The template is built entirely on verified MarketXLS functions, so the live version refreshes without any manual data entry. Here are the exact formulas the screener uses, each taking a single ticker symbol.

=ReturnOnInvestedCapitalOneYear("MSFT")   Return on invested capital, trailing 12 months
=ReturnOnEquity("MSFT")                    Return on equity, trailing 12 months
=ReturnOnAssets("MSFT")                    Return on assets
=OperatingMargin("MSFT")                   Operating margin
=GrossMargin("MSFT")                       Gross margin
=RevenueGrowth("MSFT")                     Year-over-year revenue growth
=PERatio("MSFT")                           Price-to-earnings ratio, trailing
=TotalDebtToEquity("MSFT")                 Total debt to equity ratio
=Beta("MSFT")                              Beta versus the market
=MarketCapitalization("MSFT")             Market capitalization
=QM_Last("MSFT")                           Live last price
=Sector("MSFT")                            Sector classification

To build the core of the screener yourself, you would drop your tickers down column A and then, in the ROIC column, use a formula like this so the whole column fills by dragging:

=ReturnOnInvestedCapitalOneYear(A2)*100

Multiplying by 100 converts the decimal into a clean percentage for display. The same pattern applies to ROE, ROA, and the margin columns. Because every cell references the ticker in column A, swapping in a new watchlist is as simple as editing that one column. That is the beauty of building on MarketXLS instead of pasting values from a website: the sheet stays alive.

For the economic-profit view on the Strategy sheet, the calculation subtracts an assumed cost of capital from ROIC:

Economic Spread = ROIC - Cost of Capital

A positive spread means the business earns more than it costs to fund, which is the textbook definition of value creation. The cost of capital in the template is a single user input rather than a company-specific WACC, so treat it as a teaching tool, not a precise valuation input.

What's Inside the Template

This is a premium, dashboard-style workbook with ten sheets, each designed to be presentation-ready. Here is the full walkthrough.

1. Cover - A branded cover page with the title, edition, data-as-of date, and a full table of contents. Gridlines are hidden so it reads like a product cover, not a spreadsheet.

2. How To Use - A numbered, step-by-step tutorial that takes you from download to a ranked watchlist in about five minutes. It explains every input cell and names the key formulas.

3. Dashboard - The headline sheet. A row of KPI tiles across the top shows universe size, median ROIC, the count of names above your threshold, the top ROIC name, and average operating margin. Below the tiles sit two embedded charts: a bar chart ranking ROIC by company and a scatter plot of ROIC against operating margin. At the bottom is the full screener table with conditional-formatting heatmaps, data bars for market cap, and directional icons for revenue growth. Green means strong, red means weak, and you can read the whole universe in one glance.

4. Inputs & Controls - Every yellow cell you are meant to touch lives here. Data-validation dropdowns let you pick a scenario (Conservative, Base, or Aggressive), a risk tolerance, and a focus ticker. You also set portfolio size, minimum ROIC threshold, maximum positions, and the five Quality Score weights. Change one input and the workbook recalculates everywhere.

5. Scenario Analysis - A what-if matrix showing how many names pass as you tighten the ROIC bar from very loose to elite. It reports the count passing, the percent of the universe, the median ROIC and margin of the survivors, and their average debt load. Conditional formatting with data bars and traffic-light color scales makes the trade-off between selectivity and universe size obvious.

6. Strategy - The ROIC-versus-cost-of-capital view. It computes each company's economic spread, assigns a quality tier, and adds a plain-English interpretation. A color scale flags where the spread turns from red to green, and data bars rank raw ROIC.

7. Portfolio & Allocation - A quality-weighted position sizer. It pulls your portfolio size from the Inputs sheet, weights the top names by ROIC, and computes target weights and dollar position sizes. A donut chart visualizes the resulting mix.

8. Comparison Matrix - The ROIC-versus-ROE quadrant analysis described earlier, complete with a scatter chart so you can literally see which names sit in the compounder corner.

9. Methodology - A one-page explainer covering what ROIC measures, where the data comes from, how the Quality Score is constructed, and the limitations you should keep in mind. This is the sheet that turns a spreadsheet into something you can defend in a meeting.

10. Glossary & Disclaimer - Definitions for every term in the workbook, from ROIC and WACC to economic spread, 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" box so you always know which formulas to reference when you extend the model.

Two Versions: Sample and Live

You get two files, and it is worth understanding the difference.

The sample file is fully populated with static illustrative values captured on the data date. Every data cell carries a comment showing the exact MarketXLS formula that would produce it, so you can see how the sheet is wired even without the add-in installed. This is the version to open first if you want to explore the layout and logic.

The live template file contains zero static data. Every price, ratio, margin, and metric is a live MarketXLS formula that refreshes when you open the workbook with the add-in signed in. This is the version you actually run week to week. Point it at your own tickers on the Inputs sheet and it becomes your personal quality screener.

How to Use the Screener in Practice

A sensible workflow looks like this. Start on the Inputs sheet and set your minimum ROIC threshold. Fifteen percent is a common quality floor, but you can move it. Set your Quality Score weights to reflect what you value. Then jump to the Dashboard and read the KPI tiles for the shape of the universe.

Next, sort the screener by Quality Score to build a shortlist. Cross-check the top names against the Comparison Matrix to make sure high scores are coming from genuine capital efficiency rather than leverage. Use the Scenario Analysis sheet to sanity-check how selective your bar is, then move to the Portfolio sheet to see how a quality-weighted allocation would size the shortlist against your capital.

Throughout, remember what the tool is and is not. It is a disciplined, transparent way to rank businesses by quality characteristics. It is not a crystal ball, and a high Quality Score is not a buy signal. Use it to generate ideas worth researching further, then do that research.

Reading ROIC Without Fooling Yourself

ROIC is powerful, but it has failure modes, and a good analyst respects them.

It is backward-looking. The figure reflects the trailing twelve months, not the future. A business at the top of its cycle can post a flattering ROIC that will not persist.

It can be distorted by accounting. Large acquisitions load the balance sheet with goodwill, which depresses ROIC even for good businesses. Heavy buybacks can shrink equity and lift returns without changing the underlying economics. Asset-light software companies can show enormous ROIC simply because they carry little invested capital.

It behaves oddly for financials. Banks and insurers have balance sheets structured so differently that ROIC is often not comparable to an industrial or a software firm. The template deliberately spans several sectors so you can see this in action rather than being told about it.

The takeaway is not to abandon ROIC. It is to read it in context, alongside growth, valuation, and the balance sheet, which is precisely why the screener puts all of those columns side by side.

Frequently Asked Questions

What is a good ROIC for a stock?

As a rough educational guideline, an ROIC consistently above a company's cost of capital indicates value creation, and figures above 15 percent are often cited as a marker of a high-quality business. Elite compounders can sustain ROIC well above 30 percent. What matters most is durability: a moderate ROIC held steadily for a decade can be more telling than a single spectacular year. Always compare within an industry, since capital intensity varies widely.

How do I calculate ROIC in Excel?

The fastest way is with the MarketXLS function =ReturnOnInvestedCapitalOneYear("TICKER"), which returns the trailing-twelve-month figure directly. If you prefer to build it from components, ROIC is after-tax operating profit divided by invested capital (debt plus equity), but the pre-built function saves you from assembling those line items by hand and keeps the number live.

What is the difference between ROIC and ROE?

ROE measures return on shareholder equity alone, while ROIC measures return on all invested capital, both debt and equity. Because ROE ignores leverage, a heavily indebted company can show a high ROE while its underlying business is only average. ROIC is the more honest gauge of business quality, which is why this template plots the two against each other.

Can I use this ROIC screener with my own list of stocks?

Yes. Open the live template, go to the Inputs sheet, and swap in your own tickers. Every formula references the ticker cells, so the entire dashboard, charts, and scores recalculate automatically for your watchlist. The screener is designed to be pointed at any universe you choose.

Does the template update automatically?

The live version does. It uses MarketXLS formulas, so when you open it with the add-in installed and signed in, prices and fundamentals refresh with current data. The sample version is a static snapshot with formula comments, meant for exploring the layout before you install the add-in.

Is a high Quality Score a signal to buy?

No. The Quality Score is a ranking aid built from historical fundamentals. It is meant to surface businesses with quality characteristics that may be worth further research. It is not investment advice, does not account for valuation timing, and does not predict returns. Treat it as the start of your analysis, not the end.

The Bottom Line

An ROIC screener in Excel gives you something most investors never build: a repeatable, transparent, and honest way to rank businesses by the quality of the returns they generate on capital. Instead of trusting a headline earnings beat, you get to see whether a company actually earns its keep, and you get to control exactly how quality is defined. Built on live MarketXLS formulas, the whole thing refreshes itself, so the work you do once keeps paying off every quarter.

Download both files, open the sample first to see the layout, then run the live template against your own watchlist as Q2 2026 results roll in. Quality tends to reveal itself over full cycles, and a good screener is how you keep track.

Download the templates:

• - Sample with formula references, pre-filled illustrative data
• - Live-updating formulas, point it at your own tickers

To see how MarketXLS brings 1,000-plus functions like these into your own spreadsheets, visit MarketXLS or book a demo to see the ROIC screener and the rest of the fundamentals library in action.