Shareholder Yield Screener Excel: Rank Buybacks, Dividends, and Debt Paydown (Q2 2026 Dashboard)

Shareholder yield screener Excel searches usually start with the same frustration: dividend yield alone tells you only part of how a company returns cash. If you are trying to find the businesses handing the most money back to owners this quarter, dividend yield quietly ignores two of the three levers management actually pulls, buybacks and debt reduction. This guide walks through a professional-grade, dashboard-style Excel template that ranks any watchlist by total shareholder yield, and it uses live MarketXLS formulas so the numbers refresh after every earnings report.

Q2 2026 is a useful moment to look at this. Buyback authorizations climbed through the first half of the year as management teams put strong balance sheets to work, and higher-for-longer rates made debt paydown a more visible use of cash than it was a few years ago. A screener that only sorts on dividend yield would miss the companies quietly retiring 4 to 6 percent of their shares a year. The template below fixes that by putting all three cash-return levers in one ranked, color-coded view.

Shareholder yield screener Excel: the three-lever ranking at a glance

Here is the core comparison the template is built around. Two companies can post an identical dividend yield yet return wildly different amounts of total cash. Shareholder yield captures the full picture.

The idea traces back to research popularized by Meb Faber and others: total shareholder yield has historically been a more complete signal of capital return than dividend yield in isolation, because it does not penalize companies that prefer buybacks over dividends for tax or flexibility reasons. This template is an educational tool for organizing that data in Excel, not a promise of returns.

Why dividend yield alone leaves money on the table

Picture two consumer-staples names. Both pay a 2.5 percent dividend. On a dividend screen they look identical, so a yield-only ranking would treat them as twins. But suppose the first company is also repurchasing 3 percent of its shares each year and trimming debt, while the second is issuing stock to fund executive compensation and acquisitions. The first is returning something close to 6 percent of its market cap to owners; the second is closer to 2 percent net once dilution is counted. Same dividend, very different reality.

That gap is exactly what a shareholder yield screener is designed to expose. By adding buyback yield and debt-paydown yield to the dividend, you rank companies on the total cash they return rather than just the slice that happens to be labeled a dividend. In practice, the buyback leg is frequently the largest of the three for large-cap technology and financial names, which is why they rarely top a pure dividend screen despite being some of the most aggressive capital returners in the market.

There is a quality dimension too. A high shareholder yield funded by free cash flow is very different from one funded by fresh borrowing. That is why the template pairs every yield column with an FCF-yield column, so you can see at a glance whether the cash coming back to you is actually being generated by the business.

The approach: a rules-based capital-return screen

The template is organized around a simple, transparent, educational framework. This is a hypothesis for how to structure the data, not financial advice, and nothing here is a recommendation to buy or sell any security.

1. Rank by total shareholder yield. Sum dividend yield, buyback yield, and debt-paydown yield for every name in your watchlist, then sort descending.
2. Screen for affordability. Prefer names where free cash flow yield comfortably covers the cash being returned. A payout funded by borrowing is fragile.
3. Guard for quality. Look at return on equity, return on invested capital, and leverage so that a high yield is not just a symptom of a shrinking, over-levered business.
4. Diversify. Cap any single sector so the basket is not simply a bet on one corner of the market.
5. Re-run each quarter. Trailing-twelve-month cash-flow figures roll forward after earnings, so the ranking should be refreshed, not set once and forgotten.

Every one of those steps is wired into the workbook so you can change your assumptions in one place and watch the whole model update.

MarketXLS implementation: the exact formulas

The template is powered end to end by MarketXLS functions, which pull live market and fundamental data straight into Excel cells. Every formula below was verified against the MarketXLS function library before it went into the workbook. Here is how each column is built.

Price and market capitalization anchor the yield denominators:

=QM_Last("AAPL")
=MarketCapitalization("AAPL")

Dividend yield is a single trailing-twelve-month call:

=DividendYield("AAPL")

Buyback yield takes the cash a company spent repurchasing stock over the trailing twelve months and divides it by market cap. The HF_REPURCHASE_OF_CAPITAL_STOCK function accepts a symbol, a fiscal year, an optional quarter, and a TTM flag:

=ABS(HF_REPURCHASE_OF_CAPITAL_STOCK("AAPL",2025,,"TTM"))/MarketCapitalization("AAPL")

Debt-paydown yield uses net debt issued or repaid. A net repayment returns value to owners by de-risking the balance sheet, so the sign is flipped to make paydown a positive contribution:

=-HF_ISSUANCE_REPAYMENT_OF_DEBT_SECURITIES("AAPL",2025,,"TTM")/MarketCapitalization("AAPL")

Total shareholder yield is simply the sum of the three legs:

=SUM(G11:I11)

Free cash flow yield shows whether the payout is self-funded:

=HF_FREE_CASH_FLOW("AAPL",2025,,"TTM")/MarketCapitalization("AAPL")

The quality columns round out each row with functions that also come straight from the MarketXLS library:

=ReturnOnEquity("AAPL")
=ReturnOnInvestedCapitalOneYear("AAPL")
=TotalDebtToEquity("AAPL")
=PERatio("AAPL")
=Beta("AAPL")
=Sector("AAPL")

Because every cell references the ticker in column B, you can swap in your own symbols and the entire row recalculates. There are no hidden static values in the template file, only live formulas.

What's inside the template

This is a premium, dashboard-style workbook with ten fully designed sheets, not a plain grid. Here is the full walkthrough, treated like a product tour.

1. Cover. A branded title page with the edition and version, a data-as-of date, a full table of contents, and links to marketxls.com. Gridlines are hidden so it reads as a designed cover, not a spreadsheet.
2. How To Use. A seven-step tutorial that explains every input cell and every formula by name, so you are never guessing what a column does or where to change an assumption.
3. Dashboard. The headline sheet. A row of KPI tiles across the top summarizes the universe: names screened, average shareholder yield, top yield, average dividend and buyback yields, and how many names clear a 5 percent total-yield bar. Below that sit two embedded charts, a top-ten ranking and a stacked view of yield composition, and then the full screener table with a red-to-green heatmap on the shareholder-yield column, data bars on market cap and buyback yield, and a three-arrow icon set on free cash flow.
4. Inputs and Controls. Every yellow cell in one place. Dropdown menus let you pick a scenario (Conservative, Base, or Aggressive), a minimum yield threshold, a sector filter, portfolio size, the number of holdings, a weighting method, and whether to switch on the income overlay. Change these once and every other sheet responds.
5. Scenario Analysis. A what-if matrix that scales buyback pace from a full halt to double the current rate and shows how the universe average total yield shifts, with data bars and a color scale so the sensitivity jumps out. It answers a practical question: how much of a name's yield depends on repurchases continuing?
6. Strategy and Income. A rules-based capital-return basket laid out step by step, plus an optional covered-call income overlay you can toggle from the Inputs sheet. The overlay figures are illustrative and clearly disclaimed.
7. Portfolio and Allocation. Turns your portfolio size and top-N choice into capital per name, share counts, projected annual dividend income, and a per-name shareholder yield, topped off with an allocation donut chart and a portfolio total row.
8. Comparison and Sector. Contrasts total shareholder yield against dividend-only yield for the leaders, shows what share of each name's yield comes from buybacks and debt, and rolls everything up into a sector heatmap so you can see where capital return is concentrated this quarter.
9. Methodology. A one-page explainer of how shareholder yield is defined, where the data comes from, and the assumptions and limitations you should keep in mind before leaning on the output.
10. Glossary and Disclaimer. Plain-language definitions of every term used in the workbook, 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 that lists the exact formulas on that sheet with one-line descriptions, so you always know how to rebuild any column yourself.

The workbook is designed to be presentation-ready. Tab colors are set per sheet, panes are frozen so headers stay put as you scroll, the Dashboard has a defined print area for a clean landscape page, and the whole thing follows a consistent navy-and-blue palette with a single yellow accent reserved for input cells.

Reading the dashboard: a worked example

Say your Inputs sheet is set to the Base scenario with a 4 percent minimum shareholder yield and an equal-weighted top-ten basket on a 100,000 unit portfolio. The Dashboard ranks your watchlist, and the KPI tiles immediately tell you how rich the opportunity set is: if the average shareholder yield tile reads around 5 percent and a dozen names clear the 5 percent bar, capital return is broad this quarter. If only two or three names clear it, the market is concentrating cash return in a narrow group.

Drop to the screener and the heatmap does the sorting work for your eye. Deep green cells in the shareholder-yield column are the heaviest total returners; the stacked composition chart next to it shows whether that yield is coming mostly from dividends, buybacks, or debt reduction. A name whose green is almost entirely buyback-driven behaves very differently from one whose yield is mostly dividend, and the Scenario Analysis sheet lets you stress exactly that: cut buyback pace in half and watch which names hold their total yield and which deflate.

Finally, the Portfolio sheet converts the ranking into a concrete, equal-weighted allocation with share counts and projected income, and the donut chart shows how the capital is spread. Because everything chains back to the Inputs sheet, bumping the portfolio size or changing the number of holdings reflows the entire allocation in one step.

Sample vs template: which file to use

The download includes two files, and they serve different purposes.

The Sample file is pre-filled with illustrative values as of the data date so you can see the finished dashboard immediately, even without the MarketXLS add-in installed. Every data cell carries a comment showing the exact MarketXLS formula that would generate it, so it doubles as a formula reference you can learn from.

The Template file contains zero static data. Every price, ratio, yield, and comparison is a live MarketXLS formula. Open it with the MarketXLS add-in and signed in, and the entire workbook populates with current numbers and refreshes as you go. This is the file to use for real, ongoing screening.

A quick note on the illustrative values: the tickers in the Sample exist only to demonstrate how the formulas work. They are not quotes, not recommendations, and not a claim about any company's current capital-return program.

Where a shareholder yield screen needs care

No single metric is a complete answer, and this one has specific edge cases worth respecting.

Buyback yield built on gross repurchases can overstate the net reduction in share count when a company simultaneously issues stock for compensation. The template pairs buyback yield with quality columns partly for this reason, but if you want strict net figures you can extend the model with issuance data. Debt-paydown yield is genuinely lumpy: a company might repay a large maturity in one year and issue in the next, so a single trailing-twelve-month reading can flatter or penalize a name. And financials and REITs deserve special handling, because leverage and buybacks mean something different for a bank than for an industrial. The template flags sector on every row so you can keep those comparisons honest.

The point of the workbook is to organize and rank the data, not to make the decision for you. Treat a high total yield as the start of research, not the end of it.

Reading the sector heatmap in Q2 2026

The Comparison and Sector sheet is where the screener stops being a list of tickers and starts telling a story about the market. By rolling every name up into its GICS sector and averaging the three yield legs, the heatmap shows where capital return is concentrated right now rather than name by name.

The pattern that tends to emerge in a quarter like this one is instructive. Energy and financials frequently sit near the top of a total-shareholder-yield ranking, because both combine meaningful dividends with heavy buyback programs, and banks in particular lean on repurchases once capital returns are approved. Older technology and communication-services names often screen higher than investors expect, not because their dividends are large but because their buyback yield is, which is precisely the signal a dividend-only screen throws away. Defensive staples usually show a high dividend leg but a thinner buyback leg, so their total yield is steadier but rarely tops the table.

None of that is a recommendation, and sector leadership shifts from quarter to quarter as authorizations are announced and completed. The value of the heatmap is that it lets you form a view about where cash return is flowing and then drill into the individual names driving it, all without leaving the workbook. Pair the sector rollup with the affordability check on the Dashboard and you can quickly separate sectors returning cash out of genuine free cash flow from those leaning on the balance sheet to do it.

Customizing and extending the template

Because the workbook is built entirely from MarketXLS formulas keyed to a ticker cell, it is straightforward to adapt to your own process. A few common extensions:

• Add a net-buyback column. If you want repurchases net of issuance rather than gross, combine HF_REPURCHASE_OF_CAPITAL_STOCK with an issuance figure so dilution from stock compensation is netted out. This tightens the buyback leg for companies with large equity-comp programs.
• Layer in a coverage ratio. Divide free cash flow by the total cash returned to get a single affordability multiple. A ratio comfortably above one means the payout is self-funded; a ratio below one means the company is dipping into the balance sheet.
• Introduce a valuation gate. The template already pulls PERatio; you can add a rule that only surfaces names whose total yield clears your threshold and whose valuation sits below a ceiling, so you are not paying up for the yield.
• Track it over time. Duplicate the Dashboard each quarter and keep a history tab so you can see whose shareholder yield is rising and whose is fading. A rising buyback yield funded by growing free cash flow is a different signal than one funded by falling share prices.

Everything you need to make these changes is documented on the How To Use and Methodology sheets, and every formula on every sheet is spelled out in the functions box at the bottom. Nothing is hidden, so the workbook is as much a learning tool for MarketXLS as it is a finished screener.

FAQ

What is a shareholder yield screener in Excel?

It is a spreadsheet that ranks stocks by the total cash a company returns to owners, combining dividend yield, buyback yield, and debt-paydown yield, rather than sorting on dividends alone. This template does it with live MarketXLS formulas and a dashboard-style layout with KPI tiles, charts, and a heatmap.

How is shareholder yield calculated?

Shareholder yield equals dividend yield plus buyback yield plus debt-paydown yield. In the template, dividend yield uses DividendYield, buyback yield divides HF_REPURCHASE_OF_CAPITAL_STOCK (TTM) by MarketCapitalization, and debt-paydown yield divides net debt repayment by market cap. The three legs are summed for the total.

Is shareholder yield better than dividend yield?

Neither is universally better, but shareholder yield is more complete because it counts buybacks and debt reduction, not just dividends. Two companies with the same dividend yield can return very different total amounts of cash once repurchases and deleveraging are included, which is the gap this screener is built to reveal.

Do I need MarketXLS to use the template?

The Template file needs the MarketXLS add-in because every cell is a live formula. The Sample file works in plain Excel because it is pre-filled with illustrative values, with the MarketXLS formula shown in a comment on each cell so you can see exactly what powers it.

Can I use my own stock list?

Yes. The universe lives in one column of the Dashboard, and every metric formula references that ticker cell. Replace the symbols with your own watchlist and each row recalculates automatically. You can also filter by sector and set a minimum yield threshold from the Inputs sheet.

How often should I refresh the screen?

Re-open the Template after each earnings season. The buyback, debt-paydown, and free-cash-flow legs use trailing-twelve-month data, so they roll forward as new filings arrive. Refreshing quarterly keeps the ranking current.

Does the template handle banks and REITs correctly?

It pulls the same fields for every name and labels each row with its sector, but leverage and buybacks mean something different for a bank than for an industrial, so read financials and REITs with extra care. Debt-paydown yield in particular is less meaningful for businesses that carry debt as part of their operating model, which is why the workbook keeps sector visible on every row.

Why use gross buybacks instead of net share-count change?

Gross repurchase cash is directly available and comparable across companies, which keeps the screen simple and transparent. The trade-off is that it can overstate net reduction when a company also issues stock. The Customizing section above shows how to add an issuance offset if you want a stricter net figure.

The bottom line

A dividend-only screen answers half the question. If you want to know which companies are actually returning the most cash to their owners, you have to add buybacks and debt reduction to the dividend, and you have to check that the payout is funded by real free cash flow. This Excel template does all of that in one professional-grade, dashboard-style workbook, powered by live MarketXLS formulas so it stays current as the numbers change. Download both files below, drop in your own watchlist, and rank your universe by total shareholder yield in a few minutes.

Download the templates:

• - Pre-filled illustrative values, with the MarketXLS formula shown on every data cell
• - Live, self-updating formulas, zero static data

To see how the MarketXLS functions behind this screener work across your own portfolio, explore MarketXLS or book a demo. Educational use only. This template is not investment advice and does not recommend any security.