Buyback Yield Screener Excel: Track Q1 2026 Share Repurchase Leaders

Buyback yield screener excel - if that is what you searched for, you are likely trying to separate the companies that are quietly shrinking their share count from those that simply talk about it on earnings calls. With Q1 2026 results landing this week, the question is timely. Capital-return policy has rarely been more visible: rates are still elevated, the dividend tax conversation is simmering again, and several mega-caps have unveiled multi-year repurchase authorisations alongside earnings. A dedicated buyback yield screener built in Excel is the cleanest way to compare repurchasers across sectors and decide where the capital return is real.

This guide walks through what a buyback yield screener should measure, how to build one in Excel using MarketXLS formulas (no scraping, no hand-typed numbers), and ships a downloadable template you can plug your portfolio size into.

Buyback Yield Screener Excel: Q1 2026 Snapshot

“

The values above are illustrative ranges based on the trailing 12 months ending Q1 2026 for educational purposes. The downloadable Excel template pulls live numbers via MarketXLS, so the figures update with every close. This is analysis, not investment advice.

Why Buyback Yield Belongs in Your Q1 2026 Workflow

Q1 2026 is the first full earnings season after several capital-return policy changes that affected how the largest US listed companies plan repurchases. Three things make buyback yield especially relevant right now:

1. Cost-of-capital sensitivity: with policy rates still elevated, repurchases funded from internal cash flow look very different from debt-funded buybacks. The screener separates them.
2. Concentrated capital return: a handful of names contributed an outsized share of the S&P 500 buyback dollars in 2025. Following the leaders into 2026 is now a discrete strategy bucket inside many advisor models.
3. EPS arithmetic: when net income is flat, every percentage point of buyback yield mechanically lifts EPS. In a guidance-cautious quarter, that becomes the swing factor between beating and missing consensus.

Buyback yield is the metric that captures all three. It expresses dollar repurchases as a percentage of market cap, so it is directly comparable to dividend yield - and adding the two gives you total shareholder yield, the most honest read on how much cash a business is returning to owners.

What "Buyback Yield" Actually Measures

Buyback yield is defined as:

Buyback Yield = Trailing 12-Month Share Repurchases ($) / Market Capitalization ($)

A company with a $1 trillion market cap and $30 billion of repurchases over the past four quarters has a 3% buyback yield. Combine that with a 0.5% dividend yield and the total shareholder yield is 3.5%.

Three caveats to keep in mind:

• Gross vs net repurchases. The cash flow line HF_REPURCHASE_OF_CAPITAL_STOCK reports gross repurchases. If a company is also issuing shares for compensation, the share count may not actually fall. Always cross-check with HF_WEIGHTED_AVERAGE_SHARE_GROWTH. A negative number confirms a real share-count reduction.
• Buyback yield is point-in-time. It can spike for a single quarter on an opportunistic ASR (accelerated share repurchase) and then collapse the next quarter. Pair it with a multi-year share-count trend before drawing conclusions.
• Capital structure matters. A high buyback yield financed by new debt at high rates is a different animal from one funded by free cash flow. Always look at HF_FREE_CASH_FLOW, HF_NET_CASH_FLOW_FROM_FINANCING, and HF_TOTAL_DEBT alongside the headline yield.

A Reusable Buyback Yield Screener Excel Template

The template ships with six tabs and is designed to refresh every cell from MarketXLS so you do not have to maintain it manually. Below is what each sheet contains and the key formulas it uses.

Tab 1: How To Use

A short tutorial that explains every sheet, the formulas referenced, and the inputs. Includes links to the MarketXLS website and demo booking page.

Tab 2: Main Dashboard

This is the screener. Yellow input cells let you set:

• Portfolio size (dollars)
• Minimum buyback yield (percent)
• Minimum total shareholder yield (percent)
• Maximum P/E ratio
• Sector filter (or "All")

The table below the inputs ranks 15 well-known repurchasers by buyback yield, dividend yield, total shareholder yield, and a composite score. The score is built from total shareholder yield (50% weight), buyback yield (30%), and a P/E penalty (20%), giving more weight to capital return while still flagging extreme valuations.

Key formulas used on the dashboard:

=QM_Last("AAPL")
=MarketCapitalization("AAPL")
=ABS(HF_REPURCHASE_OF_CAPITAL_STOCK("AAPL", YEAR(TODAY())-1, , TRUE)) / MarketCapitalization("AAPL")
=DividendYield("AAPL")
=PERatio("AAPL")

The HF_REPURCHASE_OF_CAPITAL_STOCK function returns trailing 12-month dollars. Wrapping it in ABS() turns the negative cash-outflow figure (cash flow statements report repurchases as negative) into a positive yield.

Tab 3: Scenario Analysis

This tab stress-tests the EPS impact of different sustained buyback yields. With net income held flat, EPS scales as 1 / (1 - buyback yield) per period. The matrix shows what current EPS would look like under 1%, 3%, 5%, 7%, and 10% buyback yields. It is an educational lens, not a forecast: actual EPS depends on income growth, dilution from stock-based compensation, and tax effects.

=EarningsPerShare("AAPL")
=PERatio("AAPL")

A 5% buyback yield sustained for five years lifts EPS by roughly 28% on flat earnings, before any income growth. That is the magnitude of the lever, which is why repurchase intensity matters for advisors building EPS-growth driven portfolios.

Tab 4: Buyback Strategy

The Buyback Strategy tab applies a "Sustained" vs "Watch" filter. A ticker is tagged Sustained if buyback yield is at least 2% AND year-over-year weighted average share growth is negative. Anything else is tagged Watch.

=ABS(HF_REPURCHASE_OF_CAPITAL_STOCK("AAPL", YEAR(TODAY())-1, , TRUE)) / MarketCapitalization("AAPL")
=HF_WEIGHTED_AVERAGE_SHARE_GROWTH("AAPL", YEAR(TODAY())-1)
=StockReturnThreeMonths("AAPL")
=OperatingMargin("AAPL")

This is where many headline buyback stories fail the second filter. A multi-billion-dollar repurchase program funded almost entirely by stock-based compensation issuance produces a flat or rising share count, which is a Watch, not a Sustained signal.

Tab 5: Portfolio Allocation

The Portfolio Allocation tab translates the screener output into dollars across three weighting schemes:

• Equal-weight: portfolio size divided evenly across the screened tickers.
• Buyback-weighted: portfolio size allocated proportional to each ticker's buyback yield.
• Market-cap-weighted: traditional cap weighting for comparison.

The portfolio size cell is linked to the Main Dashboard input, so the allocations stay consistent across tabs.

=MarketCapitalization("AAPL")
=Sector("AAPL")
=ABS(HF_REPURCHASE_OF_CAPITAL_STOCK("AAPL", YEAR(TODAY())-1, , TRUE)) / MarketCapitalization("AAPL")

Tab 6: Yield Comparison

The Yield Comparison matrix puts buyback yield, dividend yield, and total shareholder yield side by side and tags each ticker as Buyback-Heavy, Dividend-Heavy, or Balanced based on the buyback share of total return:

• Buyback-Heavy: 70%+ of shareholder return is repurchases.
• Dividend-Heavy: 70%+ of shareholder return is cash dividends.
• Balanced: anything in between.

This view is useful for the after-tax conversation: investors in higher tax brackets often prefer a Buyback-Heavy mix because capital appreciation is taxed differently from cash dividends.

=DividendYield("AAPL")
=ABS(HF_REPURCHASE_OF_CAPITAL_STOCK("AAPL", YEAR(TODAY())-1, , TRUE)) / MarketCapitalization("AAPL")
=MarketCapitalization("AAPL")

Building the Screener Step by Step

If you would rather build the screener from scratch in your own spreadsheet, here is the sequence.

Step 1: Pull the Universe

Start with a list of tickers. The 50 largest companies by market cap is a reasonable universe for a US large-cap buyback screener, but you can use any list (Russell 1000 components, sector ETF holdings, your own watchlist). Put the tickers in column A.

Step 2: Pull the Headline Numbers

In adjacent columns, pull the four numbers needed for buyback yield and a sanity-check overlay:

The TTM flag in the third argument tells MarketXLS to return the trailing twelve months ending in the latest reported quarter, so the screener stays current as new earnings come in.

Step 3: Compute the Yields

Buyback yield, dividend yield, and total shareholder yield drop in next:

Buyback Yield  = ABS(TTM Repurchases) / Market Cap
Dividend Yield = DividendYield(Ticker)
Total Yield    = Buyback Yield + Dividend Yield

Wrap the repurchase figure in ABS() because cash flow statements record repurchases as a negative outflow.

Step 4: Apply the Sustainability Filter

Real buybacks reduce the share count. Add a column with =HF_WEIGHTED_AVERAGE_SHARE_GROWTH(A2, YEAR(TODAY())-1). A negative value confirms net buybacks. A positive value tells you the company is issuing more shares than it is repurchasing - usually a function of stock-based compensation - and the headline buyback yield is partly cosmetic.

Step 5: Add a Capital Structure Check

Two more columns help avoid the trap of debt-funded buybacks:

=HF_FREE_CASH_FLOW(A2, YEAR(TODAY())-1, , TRUE)
=HF_TOTAL_DEBT(A2, YEAR(TODAY())-1)

Compare the TTM free cash flow to the TTM repurchases. If repurchases significantly exceed free cash flow and debt has been climbing, the buyback program is being financed rather than funded, and the durability is lower.

Step 6: Score and Sort

A weighted score brings the columns together. The template uses a 50/30/20 mix of total shareholder yield, buyback yield, and a P/E penalty:

=ROUND( (TotalYield*100)*0.5 + (BuybackYield*100)*0.3 + IF(PE>0, 50/PE, 0)*0.2, 1 )

Sort by the score column to surface the most attractive capital-return profiles given current valuation.

Capital Return: Dividends vs Buybacks vs Hybrid

Once you have the screener running, you will see three behavioural archetypes:

Buyback-Heavy

These companies retain almost all earnings and return capital primarily through repurchases. AAPL, META, GOOGL, BKNG, and V tend to land here. They suit investors who prefer EPS growth driven returns and capital appreciation tax treatment. The risk is that repurchase pace is policy-dependent: a downturn or a regulatory shift can pause the program quickly.

Dividend-Heavy

These companies return a higher share of cash via dividends. Within mega-caps the population is smaller (a few utilities and consumer staples names), but it is the dominant style across regulated utilities and many non-US markets. Suitable for income mandates that need predictable cash distributions.

Balanced

The financials cohort (JPM, BAC, V, MA, HD) usually clusters here, returning capital roughly evenly through both channels. Balanced names tend to be the most stable in absolute total shareholder yield, because dividend policy provides a floor and buybacks provide upside in years where capital exceeds dividend commitments.

For deeper context on the dividend side, the Excel tracker for dividend portfolio monitoring and dividend tracker excel real-time income portfolio walk through complementary cash-flow tracking workflows.

Q1 2026 Read-Through: Capital Return Themes

A few patterns are visible from the early Q1 2026 prints when filtered through this screener:

• Mega-cap technology continues to lead absolute repurchase dollars. Apple's program remains the largest in the index by dollar value, although the buyback yield is moderated by the size of the market cap.
• Banks normalising. After a soft 2024 and 2025 capital-return cycle, several of the largest US banks have re-accelerated repurchases following the latest stress test outcomes. Wells Fargo's TTM buyback yield is among the highest in the cohort.
• Subscription services consolidation. Companies like Booking Holdings and Visa have continued to compound through repurchases at multi-percent yields with negative share-growth confirmation.
• Some defensives remain quiet. Costco and a number of consumer staples names continue to favour dividends and growth investment over repurchases, which is reflected in the Dividend-Heavy classification on Tab 6.

These patterns are educational observations, not buy or sell recommendations. The screener is built so you can substitute any universe of tickers and see whether the same patterns hold in your investable list.

Common Pitfalls When Using a Buyback Screener

Even with a clean template, two mistakes are easy to make.

Mistake 1: Treating gross repurchases as net buybacks.

A reported $20 billion repurchase program is a gross number. If the company also issued $15 billion in stock-based compensation shares, the net change in share count is much smaller. Always confirm with HF_WEIGHTED_AVERAGE_SHARE_GROWTH.

Mistake 2: Ignoring the financing source.

Buybacks funded by debt at high rates can be value-destructive even if the headline yield looks attractive. Run a quick sanity check by comparing TTM repurchases to TTM free cash flow:

=ABS(HF_REPURCHASE_OF_CAPITAL_STOCK("AAPL", YEAR(TODAY())-1, , TRUE)) / HF_FREE_CASH_FLOW("AAPL", YEAR(TODAY())-1, , TRUE)

A ratio above ~1 over a sustained period, combined with rising HF_TOTAL_DEBT, suggests the program is being financed externally.

Mistake 3: Static analysis.

Buyback yield is point-in-time. The screener tab in the template uses live formulas precisely so that next quarter's prints flow through automatically when MarketXLS refreshes. Treat it as a rolling rather than one-time view.

Download the Templates

Download the templates:

• - Pre-filled with current data and a formula-reference column so you can see what each cell is calling.
• - Live-updating formulas. Requires the MarketXLS Excel add-in.

Both files contain six sheets (How To Use, Main Dashboard, Scenario Analysis, Buyback Strategy, Portfolio Allocation, Yield Comparison) and a "MarketXLS Functions Used" reference at the bottom of every sheet.

If you are new to building Excel screeners with MarketXLS, the marketxls screener release post gives a quick overview of the screener engine, and the free cash flow yield screener shows the same screener pattern applied to a different cash-return metric.

MarketXLS Functions Used in This Template

The screener leans on a small, focused set of functions that you can verify in the MarketXLS function reference.

Each of these functions can be called directly inside any Excel cell once the MarketXLS add-in is loaded.

FAQ: Buyback Yield Screener Excel

What is a good buyback yield in 2026?

There is no universal threshold, but in current market conditions a TTM buyback yield above ~3% combined with a negative weighted-average-share-growth is meaningfully above the S&P 500 average. The Main Dashboard input lets you set whatever minimum threshold makes sense for your strategy.

Is buyback yield better than dividend yield?

They serve different purposes. Buyback yield is more flexible (companies can pause repurchases without breaking an implicit contract, the way dividend cuts do) and can be more tax-efficient because returns come through capital appreciation. Dividend yield is more predictable. Total shareholder yield (the sum of the two) is usually the most complete picture of capital return.

How does the screener handle stock-based compensation?

The template includes HF_WEIGHTED_AVERAGE_SHARE_GROWTH precisely to surface this. A reported buyback that is fully offset by stock-based compensation will show a positive or flat weighted-average-share-growth, which the Buyback Strategy tab tags as "Watch" rather than "Sustained".

Can I add my own tickers?

Yes. Replace the tickers in column A of the Main Dashboard with any tickers MarketXLS supports. The formulas will refresh and re-rank automatically. The Portfolio Allocation tab uses the same symbol references, so a change in the dashboard flows through.

Does this screener work for non-US stocks?

Most of the formulas (HF_REPURCHASE_OF_CAPITAL_STOCK, HF_WEIGHTED_AVERAGE_SHARE_GROWTH, MarketCapitalization) work for any ticker MarketXLS covers, including major non-US listings. Capital-return data is most complete for US-listed names; coverage in international markets varies by data vendor reporting practices.

How often does the data refresh?

The live template uses point-in-time MarketXLS functions, so the values refresh whenever Excel recalculates (default: every workbook open, and on demand via F9). The TTM fundamental fields update as new earnings filings are released. There is no scraping involved - the data flows through licensed vendor feeds inside MarketXLS.

The Bottom Line

Buyback yield is the single cleanest way to compare repurchasers across sectors, and total shareholder yield is the most honest measure of how much cash a company is actually returning to owners. With Q1 2026 earnings reshaping capital-return policy in real time, having a screener that updates automatically is more useful than a static report.

The template attached to this post packages the workflow into six sheets, reuses a small set of verified MarketXLS formulas, and lets you plug in any portfolio size or ticker universe. Use it as a starting point for capital-return research, not as a buy or sell list.

For more on MarketXLS and how the Excel-native data layer works, visit marketxls.com or book a demo to walk through the full function library with the team.