Operating Margin Screener Excel: Find Q2 2026 Margin Expansion Winners (Dashboard)

Operating margin screener excel - if that phrase is what brought you here, you are trying to do something smarter than chase headline earnings beats: you want to find the companies whose core business is actually getting more efficient. Operating margin is the cleanest read on that. It strips out financing and one-off items and answers a single question - for every dollar of revenue, how much does the business keep after running its operations? This guide shows you how to build a dashboard-style operating margin screener in Excel, which MarketXLS formulas power it, and it hands you a free, professional-grade template you can download and open today.

The timing is not accidental. Q2 2026 earnings season is now underway, kicking off this week with the first wave of large-cap reports. FactSet's preview has S&P 500 earnings growing roughly 22% year over year, which would be the second straight quarter of growth above 20%. Here is the part most headlines skip: a large share of that growth is coming from margin expansion, not just higher revenue. When a company grows earnings faster than sales, it is squeezing more profit out of each dollar it brings in. An operating margin screener is how you find those companies before the crowd does, and this template is built to look and behave like a product rather than a plain grid.

Operating Margin Screener Excel: The Quick View

Before the deep dive, here is the at-a-glance picture of what a proper operating margin screener tracks. All figures below are illustrative sample values as of the data date in the template; the live version refreshes them automatically with MarketXLS formulas.

The table makes the core idea obvious at a glance: a high margin is good, but a high margin that is still expanding is what you are hunting for. Costco appears in the "Avoid" tier on margin alone, which is exactly why margin has to be read against the business model - more on that below.

What Operating Margin Actually Tells You

Operating margin is operating income divided by revenue. Operating income is what is left after the costs of actually running the business: cost of goods sold, plus selling, general and administrative expenses, plus research and development, plus depreciation. It sits between gross margin and net margin on the income statement, and each of the three tells you something different.

• Gross margin = (revenue - cost of goods sold) / revenue. This is pricing power and unit economics. A software company might run an 80%+ gross margin; a grocer runs in the teens.
• Operating margin = operating income / revenue. This adds the cost of running the whole operation - sales teams, R&D, overhead. It is the truest read on core operating efficiency.
• Net margin = net income / revenue. This is the bottom line after interest, taxes, and everything else. It is useful, but it can be distorted by debt loads, tax quirks, and one-time items.

Operating margin sits in the sweet spot. It is close enough to the core business to be meaningful, but broad enough to capture whether a company is running lean. That is why it is the anchor metric of this screener, with gross and net margin included alongside for context.

Why Margin Expansion Matters More Than the Level

A 30% operating margin is impressive. A margin that moved from 26% to 30% over the past year is a story. Rising operating margin usually signals one of a few good things:

1. Operating leverage - revenue is growing faster than fixed costs, so each new dollar of sales drops more profit to the operating line.
2. Pricing power - the company can raise prices without losing volume, lifting gross margin, which flows down.
3. Cost discipline - management is genuinely running the business more efficiently, whether through automation, scale, or mix shift toward higher-margin products.

The Q2 2026 setup is a textbook example. With earnings forecast to grow around 22% while revenue growth is far more modest, the gap is margin expansion. A screener that ranks by both margin level and margin trend puts you in front of that dynamic. This is an analytical framework for study, not a prediction that any particular stock will rise. Nothing here is investment advice.

The Approach: Scoring Margin Quality

Ranking a watchlist by a single column only gets you so far. The template builds a 0-100 Margin Quality Score on the Main Dashboard that blends the factors that actually matter for operating quality:

• Operating margin level - the largest weight, since it is the core signal.
• Net margin - rewards companies that keep their efficiency all the way to the bottom line.
• Revenue growth - a rising margin on a shrinking top line is far less interesting than a rising margin on a growing one.
• Valuation sanity - a light penalty as the P/E stretches, so a great business at an extreme price does not automatically top the list.

The score is deliberately transparent - you can open the cell and read exactly how it is built, then reweight it to match your own priorities. Alongside the score, a simple PASS/FAIL flag checks each name against your yellow input thresholds (minimum operating margin, minimum revenue growth, and a maximum P/E). Change one input cell and the whole board re-ranks.

This is the philosophical difference between a screener that hands you a black-box "buy" list and one that shows its work. The goal is not to tell you what to own. It is to let you encode your own definition of margin quality and apply it consistently across a watchlist.

MarketXLS Implementation: The Formulas

Every data point in this screener is a live MarketXLS formula, so the workbook refreshes itself instead of going stale the moment you save it. Each formula below was verified against the MarketXLS function documentation before it went into the template. Here are the core ones.

Pull the three margins directly:

=OperatingMargin("MSFT")     ' Operating income / revenue (TTM), returned as a decimal
=GrossMargin("MSFT")         ' Gross profit / revenue (TTM)
=NetProfitMargin("MSFT")     ' Net income / revenue (TTM)

A quick note that saves confusion: MarketXLS returns margins as decimals, so 0.452 means 45.2%. In the template those cells are formatted as percentages, which is why 0.452 displays as 45.2%.

Add revenue, growth, and the supporting metrics:

=Revenue("MSFT")             ' Total revenue (TTM)
=RevenueGrowth("MSFT")       ' Year-over-year revenue growth
=PriceToSales("MSFT")        ' Price-to-sales ratio
=PERatio("MSFT")             ' Price-to-earnings ratio (TTM)
=ReturnOnEquity("MSFT")      ' Return on equity, last 12 months
=QM_Last("MSFT")             ' Current / last traded price
=Sector("MSFT")              ' GICS sector, for the sector comparison sheet

From there, the Margin Quality Score is a plain Excel formula that combines those cells - no special function required. Here is the exact logic used in the template, referencing the operating margin in E, net margin in G, revenue growth in H, and P/E in I for a given row:

=ROUND(
   MIN(40, MAX(0, E12*100))            /* operating margin, up to 40 pts */
 + MIN(25, MAX(0, G12*80))             /* net margin, up to 25 pts */
 + MIN(20, MAX(0, H12*100))            /* revenue growth, up to 20 pts */
 + MIN(15, MAX(0, 15-(I12-15)*0.3))    /* valuation sanity, up to 15 pts */
 , 0)

And the PASS/FAIL flag against your input thresholds:

=IF(AND(E12>=$B$5, H12>=$B$6, I12<=$B$7), "PASS", "-")

Because everything keys off the yellow input cells and the live formulas, you never hand-edit a data point. You change a threshold, and the dashboard reconfigures itself.

Inside the Template: Six Sheets

The workbook is built as a six-sheet dashboard, not a single flat table. Here is what each sheet does.

1. How To Use. A plain-language walkthrough of every sheet, the input cells, and how the margin-as-a-decimal formatting works. This is where a new user starts.

2. Main Dashboard. The screener itself. Yellow input cells at the top set your minimum operating margin, minimum revenue growth, maximum P/E, and portfolio size. Below sits the full watchlist with operating, gross, and net margin, revenue growth, P/E, P/S, ROE, a color-scaled Margin Quality Score, and a PASS flag. A conditional color scale turns the score column into a heat map so the leaders jump out.

3. Scenario Analysis. A what-if grid that shows how a change in operating margin flows through to operating income across several revenue-growth scenarios. It makes the Q2 2026 lesson tangible: a 300 basis point margin gain can add more operating income than 10% revenue growth. You plug in a base revenue and current margin, and the grid recalculates.

4. Margin Quality Screen. Each name is sorted into a tier - Elite, Strong, Watch, or Avoid - based on operating margin, with the margin trend (expanding vs contracting) shown alongside. The tier thresholds are simple IF formulas you can adjust.

5. Position Sizing. A score-weighted allocation sheet. It takes your portfolio size and distributes it across the watchlist in proportion to each name's Margin Quality Score, then estimates share counts from the live price. This is an illustrative sizing method for study, not a recommendation.

6. Sector Margin Comparison. A color-coded matrix of average operating, gross, and net margins by sector. This is the sheet that keeps you honest: a 12% operating margin is strong for a retailer and weak for a software company, so you always compare a stock to its own sector.

The sample version is pre-filled with a static snapshot (with a clearly labeled "Data as of" date) and shows the exact MarketXLS formula behind each column, so you can see the logic even without the add-in. The formula version is entirely live - every data cell is a MarketXLS function that refreshes on open.

Download the templates:

• - Pre-filled with an illustrative snapshot
• - Live-updating formulas

How to Read Operating Margin the Right Way

A screener is only as good as the judgment behind it. A few principles keep this one useful.

Compare within a sector, never across. Consumer staples and energy names run structurally thin margins because they move enormous volumes; software and payments run fat margins on light asset bases. The Sector Margin Comparison sheet exists precisely so you benchmark a stock against its peers, not the whole market.

Watch the trend, not just the snapshot. A margin sliding from 20% to 16% is a warning even if 16% still looks respectable. A margin climbing from 12% to 15% can be more interesting than a static 30%. This is why the template surfaces margin trend directly.

Cross-check the gap between gross and operating margin. If gross margin is flat but operating margin is rising, the improvement is coming from operating leverage - fixed costs spread over more revenue. That is often the most durable kind of margin expansion.

Do not confuse margin with return. A high-margin business can still be a poor investment at the wrong price, and a thin-margin business can compound beautifully on volume and turns. That is why the score includes a light valuation check and why ROE sits on the dashboard next to margin. Pair this screener with a return on invested capital screener for a fuller quality picture.

Building It Yourself in Excel

If you would rather assemble your own version from scratch, the pattern is simple. Put your tickers down column A. In the adjacent columns, drop the MarketXLS formulas across the first row and fill down:

A2: MSFT
B2: =OperatingMargin(A2)
C2: =GrossMargin(A2)
D2: =NetProfitMargin(A2)
E2: =RevenueGrowth(A2)
F2: =PERatio(A2)
G2: =ReturnOnEquity(A2)

Passing the cell reference A2 into each function instead of a hard-coded ticker is the trick that lets one row of formulas serve an entire watchlist - just copy down. Add a scoring column and a SORT or filter, and you have the skeleton of the dashboard. The downloadable template simply takes this to its polished conclusion with formatting, scoring, scenario analysis, and sector context already built. You can learn more about the underlying data functions on the MarketXLS features page and the full functions reference.

Frequently Asked Questions

What is a good operating margin? It depends heavily on the industry. Broadly, an operating margin above 20% is considered strong across most sectors, above 15% is healthy, and single digits is typical for high-volume, low-margin businesses like retail and grocery. The right benchmark is always the company's own sector and its own history, which is exactly why this screener includes a sector comparison sheet and a margin-trend column.

What is the operating margin formula in Excel with MarketXLS? Use =OperatingMargin("TICKER"), for example =OperatingMargin("MSFT"). It returns operating income divided by revenue on a trailing-twelve-month basis, as a decimal (0.30 means 30%). You can also point it at a cell, such as =OperatingMargin(A2), to run it down a whole list of tickers.

What is the difference between gross margin and operating margin? Gross margin only subtracts the direct cost of goods sold, so it measures pricing power and unit economics. Operating margin also subtracts operating expenses like sales, R&D, and overhead, so it measures how efficiently the entire operation runs. Operating margin is always lower than gross margin, and the gap between them tells you how heavy a company's operating cost base is.

Why is margin expansion a big theme in Q2 2026? S&P 500 earnings are forecast to grow around 22% year over year in Q2 2026 while revenue growth is far more modest. When earnings grow faster than sales, the difference is margin expansion - companies keeping more profit from each dollar of revenue. A screener that ranks by margin level and margin trend helps you identify where that is happening. This is context for analysis, not a forecast for any individual stock.

Can I use this operating margin screener with my own watchlist? Yes. Replace the tickers in column A of the Main Dashboard with your own symbols and the MarketXLS formulas carry down automatically. Every downstream sheet - scoring, tiers, position sizing, and sector comparison - reacts to your list. You will need the MarketXLS add-in installed and signed in for the live version to pull data.

Does the template update automatically? The formula version does. Every data cell is a live MarketXLS function, so values refresh whenever the workbook recalculates. The sample version holds a static snapshot with a labeled "Data as of" date so you can study the layout without the add-in installed.

The Bottom Line

Operating margin is one of the most honest numbers on the income statement, and in a quarter where margin expansion is doing much of the heavy lifting behind 20%-plus earnings growth, an operating margin screener earns its place in your toolkit. The key is to read margin the right way: against a company's own sector, with an eye on the trend, and paired with valuation so a great business at an absurd price does not fool you. This template packages all of that into a six-sheet dashboard with live formulas, a transparent quality score, scenario analysis, and sector context - and it is yours to download and adapt.

If you want to see how MarketXLS turns live market data into dashboards like this one across your whole portfolio, explore MarketXLS or book a demo to see it in action.

This article is for educational purposes only and is not investment advice. Tickers are used solely to illustrate how the formulas and template work, not as recommendations. Always do your own research and consult a qualified financial professional before making investment decisions.