PEG Ratio Screener Excel: June 2026 Growth-Value Dashboard for Mid-Year Stock Selection

PEG Ratio Screener Excel - if mid-year stock selection is the reason you searched this, the dashboard linked below is built for exactly that decision. PEG (price-to-earnings divided by earnings growth) is the rare valuation lens that respects both sides of a stock's story: how much you pay, and how fast the earnings under that price are compounding. A 30 P/E on a 40 percent grower is cheaper, in Peter Lynch's framing, than a 12 P/E on a stagnant business. This guide ships a professional-grade Excel template that quantifies that idea across a curated 25-name large-cap universe, classifies each ticker into Buy / Hold / Watch / Avoid action zones, and stress-tests the screen rules across nine growth-versus-P/E scenarios. The workbook follows a dashboard-style design (KPI tile row, embedded charts, conditional-formatted heatmap, scenario grid, sector breakdown), not the flat single-sheet feel most free Excel templates settle for. The template is built on live MarketXLS formulas, so when you open it with the MarketXLS Excel add-in, every value refreshes against the latest fundamentals.

What you get inside the PEG Ratio Screener Excel dashboard

Above-the-fold summary of what the workbook delivers - read this before deciding whether to download both files.

PEG Ratio Screener Excel: why a dashboard, not a list

The standard mistake with PEG ratio is treating it as a single-number filter: sort the universe by PEG ascending, take the top 20, call it a screen. That misses three things a real GARP investor cares about.

First, PEG breaks down when growth is negative or near zero. A 5 percent grower at a 10 P/E has a PEG of 2.0, which looks expensive next to a 25 percent grower at a 30 P/E (PEG of 1.2). The 5 percent grower might still be the higher-conviction position because the growth is durable. A flat-list PEG screen rewards momentum stocks at the top of their cycle and punishes steady compounders.

Second, PEG is highly sensitive to which growth measure you use. Trailing twelve-month EPS growth, forward analyst estimates, three-year CAGR, and last-quarter year-over-year all produce different PEG values. The dashboard exposes both the trailing PEG (via MarketXLS =PEGRatio) and the forward P/E plus next-year EPS estimate, so you can sanity-check that you're not making a decision off a one-quarter anomaly.

Third, PEG by itself ignores quality. Two stocks with identical PEG ratios can have wildly different return-on-equity profiles. A high-ROE business reinvests earnings at strong incremental returns, compounding intrinsic value; a low-ROE business needs new capital to grow at all. The screener uses a configurable ROE floor (default 15 percent, tightened to 18 percent in the Conservative preset) as a quality overlay on top of the raw PEG cut.

A dashboard solves these three problems at once. KPI tiles surface the universe-level distribution. Conditional formatting flags the negative-PEG rows visually instead of letting them rank well. Scenario analysis lets you see how many names survive when you toughen or relax the thresholds.

June 2026 market context for GARP screening

Six months into 2026, the equity market sits at an interesting intersection for Growth-At-Reasonable-Price investing. Earnings yield on the S&P 500 has compressed as multiples have re-rated higher on the back of stabilising rate expectations, but breadth in the underlying earnings growth has widened. Where mega-cap tech carried the index in 2023-2024, mid-year 2026 has seen growth contribution broaden across healthcare, financials, and selective industrials. That's a textbook GARP setup: the cheap-on-PE corner of the market is also the corner where earnings revisions have turned positive.

The screener universe in this template captures that breadth. Tech mega-caps (AAPL, MSFT, NVDA, GOOGL, META) are represented for completeness, but so are healthcare quality compounders (LLY, UNH, JNJ), financial workhorses (JPM, V, MA), and consumer staples (COST, MCD). When the PEG heatmap on the Dashboard sheet renders, you can immediately see which corners of the market are pricing in growth fully versus which still offer a discount. That visual contrast is the value the dashboard format adds over a flat ranked list.

What's inside the template: 10-sheet walkthrough

The workbook ships with ten purpose-built sheets, each colour-tabbed and frozen-paned for clean navigation. Here's the full breakdown.

1. Cover sheet

A branded title page with the dashboard name, June 2026 edition tag, a "Sample" or "Live Template" indicator, and a full table of contents that links every sheet to its purpose. Gridlines are hidden on this sheet so the cover feels designed, not gridded. The navy header block uses the MarketXLS primary palette (#003366 background, white type), with the title set at 36 point. This isn't decoration for its own sake - a clear cover page is what separates a sellable product from a free Excel file.

2. How To Use

A seven-step walkthrough explaining exactly where to edit, what each yellow cell controls, and which downstream sheets update when you change inputs. The bottom of this sheet includes the full MarketXLS function reference: every formula used anywhere in the workbook, with one-line descriptions. New MarketXLS users can start here to see what live data looks like in Excel.

3. Dashboard (the headline sheet)

This is the sheet that opens when the workbook loads. Top of the sheet renders a row of seven KPI tiles:

• Median PEG (across the screening universe)
• Average forward P/E
• Stocks under PEG 1.0
• Quality GARP picks (PEG less than threshold, EPS growth greater than threshold, ROE greater than threshold - all three thresholds drive off the Inputs sheet)
• Average EPS growth
• Universe market cap (trillions)
• Breadth strength (percentage of names above their 50-day moving average)

Below the KPI row sits a 25-row screener table with twelve columns: Ticker, Company, Sector, Price, Market Cap, P/E (TTM), Forward P/E, PEG, EPS Growth (YOY), ROE, Dividend Yield, and an auto-classified Action column. The Action column applies a green / amber / red fill depending on the classification (BUY, HOLD, WATCH, AVOID). The PEG column uses a 3-color scale (green at 0.5, amber at 1.5, red at 4.0) so the cheapest-versus-growth names jump out instantly. The market cap column uses blue data bars so the biggest companies are visually obvious without you having to read the numbers.

Two embedded charts sit below the screener: a bar chart of the 12 cheapest GARP picks by PEG ratio, and a scatter plot of forward P/E (x-axis) against EPS growth (y-axis). The scatter is the high-leverage visual: anything in the top-left quadrant (high growth, low P/E) is your GARP target zone; anything top-right (high growth, high P/E) is paying-up-for-growth territory; bottom-left is value-trap territory unless growth turns around.

Gridlines are hidden on this sheet and the print area is set so the dashboard prints cleanly on one landscape page.

4. Inputs / Controls

This is the only sheet where you should edit cells. Yellow input cells with bold borders drive every calculation downstream. The inputs are split into two blocks:

Screening Rules: Scenario toggle (dropdown: Conservative / Base / Aggressive), max PEG threshold (default 1.50), minimum EPS growth (default 10 percent), minimum ROE (default 15 percent), max forward P/E (default 35), minimum market cap ($25B).

Portfolio Settings: Total portfolio size, max position weight, sizing method (dropdown: Equal-weight / Risk-parity / Conviction-weighted), cash reserve percentage, risk tolerance (dropdown), investing horizon in years.

A scenario preset reference table sits below the input blocks so you can see exactly what Conservative, Base, and Aggressive mean in terms of the underlying thresholds. The scenario toggle is a label only - the actual screen logic reads the four threshold cells, so you can mix and match (Aggressive label with Conservative PEG threshold, for example) without breaking anything.

5. Scenario Analysis

A 9x9 PEG sensitivity grid that shows how PEG changes as EPS growth (rows: 5 percent up to 35 percent) and trailing P/E (columns: 10 up to 50) move. The grid is conditionally formatted with the standard red-amber-green color scale so the GARP zone (PEG below 1.5) lights up green, the pay-up zone (PEG above 2) shows red, and the borderline area sits amber. A reading guide below the grid explains how to interpret each color band.

Below the grid, a universe-wide outcome table runs the three scenario presets through the sample data and reports: number of names passing the screen, median PEG of the passing set, and a one-line note for each scenario. This is your stress test - if your Conservative scenario produces zero passing names, you know the market is broadly expensive and you should consider widening the universe or relaxing thresholds.

6. Strategy & Watchlist

Every ticker in the universe with its PEG, EPS growth, ROE, an auto-classified Action label, and a one-line rationale. The action logic is:

• BUY: PEG between 0 and max PEG input AND EPS growth above min growth input AND ROE above min ROE input
• HOLD: PEG between 0 and 1.5x max PEG threshold AND EPS growth above half the min growth threshold
• AVOID: PEG less than or equal to zero OR PEG greater than 2.5 OR negative EPS growth
• WATCH: anything that doesn't meet the above (mixed signals)

The Action column applies conditional formatting (green BUY, amber HOLD, red AVOID, gray WATCH) so you can scan the column at a glance. Filter the table to Action = BUY and you have your watchlist ready to export.

7. Portfolio Allocation

This sheet turns the BUY list into a positioned portfolio. KPI tiles at the top show total portfolio, equity allocation (portfolio minus cash reserve), cash reserve, and number of positions. The holdings table below allocates equity equally across the BUY names (default sizing method), with columns for weight, position dollars, and current price.

A doughnut chart at the bottom shows allocation by sector so you can immediately see whether the screen is concentrated (e.g., heavy healthcare from low-PEG pharma) or diversified. If you change the sizing method dropdown on Inputs to Risk-parity or Conviction-weighted, the weights column would shift accordingly (currently both methods default to equal-weight in the template - extend them with your own logic if you want different behavior).

8. Sector Comparison

Eleven GICS sectors with median PEG, median forward P/E, average EPS growth, average ROE, and a one-line verdict (Sector trades cheap vs growth / Reasonable GARP zone / Pay-up needed for growth). Conditional formatting on the PEG, growth, and ROE columns lets you compare sectors at a glance. A horizontal bar chart visualises median PEG by sector below the table.

This sheet answers an underused question: is the stock cheap versus its own sector, or only cheap versus the broad market? A 20 P/E utility might look cheap next to a 35 P/E tech name, but if the median utility trades at 18 P/E, it's actually market-rate for its sector. The Sector Comparison sheet stops that mistake.

9. Methodology

A one-page explainer covering: PEG ratio definition, which growth measure the template uses, data sources, how the universe was constructed, action classification logic, the quality overlay (ROE), scenario logic, known limitations (negative-growth blowouts, cyclical distortion, buyback-inflated EPS growth, tax loss carry-forwards), and refresh cadence. Read this before using the screener for real money decisions.

10. Glossary & Disclaimer

Definitions of every term used in the workbook (PEG, GARP, forward P/E, EPS growth YOY, ROE, forward EPS, market cap, watchlist, conditional formatting, scenario toggle), plus an explicit educational-only disclaimer. The Disclaimer block is bordered and lives at the bottom of the sheet so it's impossible to miss.

The template version also includes a hidden Screener helper sheet that mirrors the Dashboard rows with pure MarketXLS formulas, so downstream sheets can reference clean live values without coupling tightly to Dashboard column positions.

MarketXLS formulas powering the screener

Every data cell in the template version is a live MarketXLS formula. Here are the twelve formulas that drive the screener, with what each one returns.

=QM_Last("AAPL")                       → Current stock price
=PERatio("AAPL")                       → Trailing twelve-month P/E
=ForwardPE("AAPL")                     → Forward P/E using next-year EPS estimate
=PEGRatio("AAPL")                      → MarketXLS native PEG (TTM)
=EarningsPerShare("AAPL")              → TTM EPS
=EPSEstimateNextYear("AAPL")           → Consensus next-fiscal-year EPS
=QuarterlyEarningsGrowthYOY("AAPL")    → Q/Q YOY earnings growth
=RevenueGrowth("AAPL")                 → YOY revenue growth
=ReturnOnEquity("AAPL")                → ROE (TTM)
=MarketCapitalization("AAPL")          → Market cap in USD
=DividendYield("AAPL")                 → Trailing dividend yield
=Sector("AAPL")                        → GICS sector
=NumberOfAnalysts("AAPL")              → Number of analysts covering the name
=Beta("AAPL")                          → Beta vs S&P 500
=Industry("AAPL")                      → GICS industry

A live PEG screen rebuilt from scratch in Excel without MarketXLS would require pulling each of these data points from separate sources, normalising the time periods, and refreshing manually. The =PEGRatio call collapses that whole chain into one cell.

If you want to build a forward PEG (using analyst-estimated next-year EPS instead of trailing earnings), the calculation is:

Forward PEG = =ForwardPE("AAPL") / (QuarterlyEarningsGrowthYOY("AAPL") * 100)

Note the multiplication by 100 because the growth function returns a decimal (0.12 for 12 percent), and PEG is conventionally expressed against percentage growth.

How the action classification works

Three thresholds drive the BUY classification: max PEG, minimum EPS growth, minimum ROE. All three come from the Inputs sheet, so changing your scenario reshapes the BUY list immediately.

The formula behind the Action column is:

=IF(AND(PEG>0, PEG<MaxPEG, EPSGrowth>MinGrowth, ROE>MinROE),
   "BUY",
   IF(AND(PEG>0, PEG<MaxPEG*1.5, EPSGrowth>MinGrowth/2),
      "HOLD",
      IF(OR(PEG<=0, PEG>2.5, EPSGrowth<0),
         "AVOID",
         "WATCH")))

In plain language: a name only earns BUY if it's cheap on PEG, growing earnings faster than your threshold, and earning a quality return on its equity. A HOLD is the relaxed cut - half the growth threshold, 50 percent more PEG room. AVOID catches the obvious disasters (negative PEG, runaway-expensive PEG, or shrinking earnings). Everything else is WATCH - mixed signals worth tracking but not buying.

This three-factor combination is the meaningful step up from a flat PEG screen. A naive "sort by PEG ascending" screen would happily put a shrinking-earnings, negative-PEG ticker at the top of the list. The Action logic flags it as AVOID before it can mislead you.

Why ROE is the quality gate

Of all the quality metrics you could overlay on a PEG screen (margins, free cash flow yield, debt-to-EBITDA, interest coverage), why ROE?

Two reasons. First, ROE measures the rate at which retained earnings compound. A 25 percent ROE business reinvesting 50 percent of earnings grows book value at roughly 12.5 percent per year intrinsically, even before considering external growth. That intrinsic compounding is what makes high-ROE businesses durable GARP candidates - their growth is not borrowed from share count expansion or one-time tax benefits.

Second, ROE catches a specific PEG trap: companies that hit growth targets by issuing debt or buying back shares aggressively. EPS growth can look strong on the surface, but if the underlying return on the capital base is mediocre, the growth is brittle. An ROE floor at 15 percent (default) or 18 percent (Conservative preset) filters out the financial engineering cases.

The trade-off: high ROE sometimes correlates with high beta and high P/E. Quality compounders rarely sit at PEG below 1.0. That's why the template separates the three controls (PEG, growth, ROE) instead of bundling them into a composite score - you can dial each one independently as the market environment changes.

Reading the PEG sensitivity grid

The Scenario Analysis sheet's 9x9 grid is the single most useful artifact in the workbook for stress-testing your screen rules. The columns step from P/E 10 (deep value) to P/E 50 (high growth premium), and the rows step from 5 percent growth (mature business) to 35 percent growth (high-growth tech).

A few rows worth memorising:

• 10 percent growth row: PEG hits 1.0 at P/E 10, 1.5 at P/E 15, 2.0 at P/E 20. If you're screening for PEG below 1.5 on a 10 percent grower, you're effectively requiring a sub-15 P/E.
• 20 percent growth row: PEG hits 1.0 at P/E 20, 1.5 at P/E 30. This is the sweet spot for most large-cap tech.
• 30 percent growth row: PEG hits 1.0 at P/E 30, 1.5 at P/E 45. Even quite expensive multiples look reasonable if growth holds.

The visual color shift across the grid teaches you the geometry of the PEG ratio better than any number can. Once the grid is internalized, you can eyeball a P/E and growth rate combo and estimate PEG without a calculator.

Strengths and limitations of the PEG screen

PEG is a powerful screen, but it has known failure modes. The Methodology sheet covers these in detail, but the short version:

Strength: PEG normalises across growth profiles. A flat P/E screen can't compare a 15 P/E utility to a 35 P/E software company because they're different categories. PEG can - both might be at 1.5x growth-adjusted, putting them on equal footing.

Strength: PEG embeds an implicit return target. A PEG of 1.0 broadly corresponds to a forward earnings yield equal to the growth rate, which historically maps to high-single-digit total returns over multi-year holding periods.

Limitation: PEG dies when growth is negative or near zero. Cyclical sectors at the top of their cycle show implausibly low PEG because trailing earnings just spiked; at the bottom of their cycle, PEG is undefined or wildly high. The Action logic forces an AVOID on negative-growth names to keep the workbook honest, but you should still cross-check cyclicals against multi-year average earnings.

Limitation: PEG can be gamed by buybacks. Heavy buyback companies inflate EPS without growing underlying earnings. The template surfaces RevenueGrowth as a sanity check column you can add to the Screener helper sheet.

Limitation: PEG is myopic on time horizon. A 25 percent grower might be a one-year story or a ten-year compounder. PEG doesn't distinguish. Use the Methodology sheet's note on the EPSEstimateNextYear function to cross-check that forward growth is also strong.

Comparison: PEG vs P/E vs forward P/E

Three valuation lenses, three different stories.

PEG is the screen of choice when you're trying to compare across growth profiles. P/E alone systematically penalises growth stocks; forward P/E gets directional but doesn't differentiate a 12 percent grower from a 30 percent grower. PEG is the only one that does.

The dashboard shows all three side by side in the Screener table so you can triangulate. A name with low trailing P/E, low forward P/E, AND low PEG is a robust GARP candidate. A name with low PEG but high forward P/E is probably riding a one-year earnings spike. Knowing which is which is the value of the multi-metric view.

Download the templates

Both files are free downloads. The Sample workbook has static values frozen at 2026-06-06 with formula comments on every data cell, useful for studying the structure without needing the MarketXLS add-in. The Template workbook is the live version, refreshing against current data whenever you open it with the MarketXLS Excel add-in.

Download the templates:

• - Pre-filled with June 2026 data and formula comments on every cell
• - Live-updating, refreshes against current MarketXLS data

Drop both files into the same folder so you can switch between them. The Sample is your reference for what good data looks like; the Template is what you'll actually run screens on.

Building your own PEG screener: the high-leverage steps

If you want to build a PEG-based watchlist outside this template, here's the minimum viable build:

1. Start with a clean universe. Don't try to screen the entire S&P 500 from one Excel workbook - load a curated 25 to 100 ticker list of names you'd actually consider owning.
2. Pull three columns first: PEGRatio, ForwardPE, ReturnOnEquity. Get the data flowing live via MarketXLS before adding anything else. Verify the values look reasonable before extending.
3. Build the Action column second. A simple IF formula that classifies BUY / HOLD / AVOID forces you to make the screen rules explicit instead of eyeballing them.
4. Add conditional formatting third. Visual cues are why dashboards beat lists. A red-amber-green color scale on PEG turns a 25-row table into a heatmap your eye can scan in two seconds.
5. Build the scenario grid last. The 9x9 grid in this template is arithmetic (PEG = P/E / (growth * 100)) - no MarketXLS needed. It teaches you the geometry of PEG and stress-tests your thresholds.

You don't need 10 sheets to start. You need PEG, growth, ROE, an action column, and a color scale. Everything else is polish that earns its keep as the workbook grows.

FAQ: PEG Ratio Screener Excel

What is a good PEG ratio for a stock?

A PEG of 1.0 is the classic Peter Lynch threshold: you're paying one unit of price for one unit of growth. Below 1.0 generally indicates the stock is cheap relative to its expected growth; between 1.0 and 2.0 is typically considered reasonably priced; above 2.0 suggests growth assumptions need to be very right to justify the multiple. That said, what counts as "good" depends on the sector. Consumer staples and utilities often trade at PEG above 2.0 because their growth is more stable; tech and biotech often trade at PEG below 1.0 because their growth carries more execution risk. The Sector Comparison sheet in this template shows median PEG by GICS sector so you have a contextual benchmark.

Why does the MarketXLS PEGRatio function use trailing instead of forward EPS?

The =PEGRatio() function computes PEG using trailing twelve-month EPS and trailing earnings growth, which is the standard convention used by most data providers. Trailing PEG has the advantage of using actual results rather than analyst estimates, so it's not subject to estimate revisions. The trade-off is that it lags the forward outlook. The template addresses this by showing trailing PEG alongside forward P/E and next-year EPS estimate columns, so you can construct a forward PEG manually when the forward outlook diverges materially from the trailing print.

How is PEG different from PEGY ratio?

PEGY (PEG plus Yield) adjusts PEG by adding the dividend yield to the growth rate in the denominator. The intuition is that a 4 percent dividend yield effectively boosts your total return regardless of price appreciation, so a high-yielding stock should be valued more leniently. PEGY = P/E divided by (growth percentage plus dividend yield percentage). For most large-cap dividend payers in this template (XOM, JNJ, CVX), PEGY would be 10 to 25 percent lower than PEG. The template focuses on PEG for simplicity, but you can compute PEGY directly in the Dashboard by adding a column with the formula =F11/(I11100+K11100).

Can I add or remove tickers from the screener?

Yes. Open the Dashboard sheet, find the screener table starting at row 11, and add or remove rows. For each new ticker, copy the formula structure: column 3 uses =Sector(), columns 4 through 11 use the relevant MarketXLS data formulas, and column 12 uses the Action classification IF. Also update the Strategy & Watchlist sheet and Sector Comparison sheet to keep the universe consistent across sheets.

What happens when EPS growth is negative?

The action classification flags negative-EPS-growth names as AVOID automatically. PEG is mathematically meaningless when growth is negative - it would produce a negative ratio that doesn't correspond to anything intuitive about valuation. The conditional formatting on the PEG column also handles negative values gracefully (they show as the deepest red), so visually they're obvious to skip. For deeper diagnosis on a negative-growth name, cross-check the RevenueGrowth function: declining earnings with growing revenue often signals margin compression that may be temporary; declining earnings with declining revenue is a structural problem.

Does the template work without the MarketXLS add-in?

The Sample workbook works without the add-in because every cell is a static value. You can open it in any version of Excel, study the structure, and use the formula comments on each data cell to see what the live formula would be. The Template workbook requires the MarketXLS add-in because every data cell is a live formula - without the add-in, the formulas will show as #NAME? errors. To use the live template, you need the add-in installed in Excel. Learn more at marketxls.com.

How often is the data refreshed?

The Template version refreshes every time you open the workbook with the MarketXLS add-in, and you can also force a refresh manually via the MarketXLS ribbon (Refresh All). Intraday refreshes pull the latest available QuoteMedia tick for price and the latest available fundamentals snapshot for ratios. Fundamentals (PEG, ROE, growth) update as new earnings reports are filed and analyst estimates are revised, typically with a 1 to 5 business day lag versus the underlying filing date. The Sample workbook does not refresh - it's frozen at the build date noted on the Cover sheet.

The bottom line

The PEG ratio is the rare valuation lens that lets you compare across growth profiles without systematically penalising growers or rewarding stagnant businesses. But raw PEG is a brittle filter: it breaks on negative growth, it ignores quality, and it's sensitive to which growth measure you use. A dashboard-style workbook with KPI tiles, conditional formatting, a quality (ROE) overlay, and a scenario sensitivity grid turns PEG from a single-number filter into a structured screen.

The PEG Ratio Screener Excel template above is the version of that screen I'd want on my own desk. It's free, it's built on live MarketXLS formulas, and the design follows a real dashboard-style aesthetic rather than the flat spreadsheet feel most free templates settle for.

If you want to see what live MarketXLS data looks like in Excel, head to marketxls.com and try the platform. To talk to the team about installing MarketXLS in your workflow, book a demo at marketxls.com/book-demo.

Educational use only. Not investment advice. All formulas verified via the MarketXLS Function Docs.