Shareholder Yield Screener Excel: Total Cash Return Dashboard for June 2026

Shareholder yield screener excel - if you care about how much cash a company actually hands back to its owners, and not just the headline dividend yield, this is the template for that. Dividend yield only tells one third of the story. A company can return cash to shareholders three ways: by paying dividends, by buying back its own shares, and by paying down debt that sits ahead of equity in the capital structure. Add those three legs together and you get shareholder yield, sometimes called total cash return or net payout yield. This guide ships a premium, dashboard-style Excel template that screens 24 large-cap names on all three legs at once, scores them, and surfaces the leaders with KPI tiles, embedded charts, and a conditional-formatted heatmap.

The template is built to look like a professional-grade product, not a plain spreadsheet. Eleven sheets, a branded cover page, frozen panes, color-scaled conditional formatting, dropdown form controls, an allocation donut, and live MarketXLS formulas wired through every metric. Download both the static sample (with formula references shown as cell comments) and the live MarketXLS formula version at the end of this post.

Shareholder yield at a glance - the quick reference

Before going deeper, here is the single most useful view in the whole toolkit: a ranking of the watchlist by total shareholder yield, broken into its three component legs. These figures are illustrative values captured for the sample file as of June 25, 2026, to show what the dashboard surfaces. In the live template every cell is a MarketXLS formula that refreshes on its own.

Notice how different the picture looks once you stop fixating on dividend yield alone. Apple pays a tiny 0.45% dividend, which would never show up on a high-yield screen, yet it returns close to 3.8% of its market value to shareholders every year once buybacks are included. Wells Fargo returns more cash through repurchases than dividends. Verizon and AT&T lean almost entirely on dividends and debt reduction. A shareholder yield screener excel model is the only way to see all three legs side by side and rank on the total.

Why shareholder yield matters more in 2026

Shareholder yield has quietly become one of the most watched factors heading into the second half of 2026, and the reason is structural. After two years of elevated valuations in the largest index names, investors are paying more attention to companies that convert profit into cash returns rather than promises of future growth. Buyback authorizations across the S&P 500 have stayed near record levels, which means the repurchase leg of shareholder yield is doing real work, not just window dressing.

There are three reasons the factor is having a moment:

1. Buybacks are a bigger slice of total return than they used to be. For many mature technology and financial names, repurchases now dwarf dividends. A pure dividend screen misses them entirely, which is why a dividend-only view understates how shareholder-friendly a company actually is.

2. Total cash return is harder to fake than earnings. Accounting earnings can be massaged. Cash that leaves the building as dividends, buybacks, and debt repayment is real and verifiable from the cash flow statement. Shareholder yield is grounded in cash that already moved.

3. It is a built-in valuation discipline. Because every leg of shareholder yield is divided by market capitalization, a stock that runs up in price mechanically shows a lower yield. The factor naturally cools on names that have gotten expensive and warms on names the market has left behind.

None of this is a recommendation to buy any particular stock. It is an analytical lens. The job of the template is to make that lens easy to point at any watchlist you like.

What shareholder yield actually measures

Shareholder yield is the sum of three yields, each expressed as a percentage of market capitalization:

• Dividend yield is the most familiar leg: trailing twelve-month dividends per share divided by price. It is the most committed form of cash return because management is reluctant to cut it.
• Buyback yield is the value of net share repurchases over the last year divided by market cap. Repurchases shrink the share count, which lifts every remaining shareholder's claim on future earnings.
• Debt paydown yield is net debt reduction over the last year divided by market cap. When a company repays more debt than it issues, enterprise value shifts from lenders to equity holders. This leg can be negative when a firm is adding leverage.

Total shareholder yield is simply the three added together. A company paying a 3% dividend, buying back 2% of its shares, and reducing net debt by 1% of market cap has a roughly 6% shareholder yield. That is the number the screener ranks on.

Crucially, the template also shows free cash flow yield next to shareholder yield, so you can immediately see whether the cash returns are funded by genuine free cash flow or by borrowing. A high shareholder yield backed by a low free-cash-flow yield is a warning sign, not a green light.

The MarketXLS implementation - real formulas, verified

Every number in the live template is a MarketXLS function, and every function below was verified against the MarketXLS function library before it went into the workbook. Nothing here is invented. You can drop any of these into a cell in Excel with MarketXLS installed and get a live value.

The dividend leg is the simplest:

=DIVIDENDYIELD("VZ")

This returns the trailing twelve-month dividend yield. To see the cash amount per share, use:

=DIVIDENDPERSHARE("VZ")

The buyback leg is built from the cash flow statement. MarketXLS exposes the repurchase line directly, and because repurchases are a cash outflow they come through as a negative number, so the formula negates it and divides by market cap:

=-HF_REPURCHASE_OF_CAPITAL_STOCK("WFC", 2025, , TRUE) / MARKETCAPITALIZATION("WFC")

The fourth argument set to TRUE pulls the trailing-twelve-month figure. The debt paydown leg follows the same pattern, using the net issuance or repayment of debt securities:

=-HF_ISSUANCE_REPAYMENT_OF_DEBT_SECURITIES("T", 2025, , TRUE) / MARKETCAPITALIZATION("T")

Total shareholder yield is then just the sum of the three cells. To sanity check whether those returns are affordable, the template pulls free cash flow yield:

=HF_FREECASHFLOW("CVX", 2025, , TRUE) / MARKETCAPITALIZATION("CVX")

The supporting quality and valuation columns use familiar MarketXLS functions:

=QM_Last("XOM")            Live last price
=PAYOUTRATIO("XOM")        Share of earnings paid as dividends
=PERATIO("XOM")            Trailing price-to-earnings ratio
=RETURNONEQUITY("XOM")     Return on equity
=BETA("XOM")               Sensitivity to the broad market
=SECTOR("XOM")             Sector classification

Because the buyback, debt, and free-cash-flow formulas all reference the fiscal-year cell on the Inputs sheet, you can roll the entire model forward to a new reporting year by changing one cell. That is the difference between a screener and a static list.

What's inside the template - all eleven sheets

This is a premium, dashboard-style workbook, and it is built like a product. Here is the full walkthrough of every sheet, in order.

1. Cover. A branded title page with the edition, a clear "Data as of" date, a credit line, and a full table of contents. Gridlines are hidden so it reads like a cover, not a grid. This is the first thing you see when the file opens.

2. How To Use. A step-by-step tutorial that explains every sheet and, more importantly, every yellow input cell. If you only read one sheet before diving in, read this one.

3. Dashboard. The headline sheet. A row of seven KPI tiles runs across the top: holdings count, average shareholder yield, average dividend yield, average buyback yield, the top yielder, average free-cash-flow yield, and average price-to-earnings. Below the tiles sit two embedded charts: a column chart of shareholder yield by holding, and a stacked column chart that breaks the leaders into their dividend, buyback, and debt legs. At the bottom is the full screener: 24 names with fifteen columns, color-scaled so the highest shareholder yields glow green and the lowest fade to red, with data bars on buyback yield and market cap and a traffic-light icon set on the composite score.

4. Inputs / Controls. Every yellow cell lives here. Portfolio size, reinvestment rate, scenario toggle, minimum shareholder yield filter, holding period, the fiscal-year reference used by the trailing-twelve-month formulas, risk tolerance, and three custom ticker slots. Two of the cells are dropdown form controls. Change an input here and the rest of the workbook responds.

5. Scenario Analysis. A what-if matrix that projects one year of cash returned on your portfolio across five assumptions, from bear to aggressive. Conditional formatting data bars make the spread obvious at a glance, and an embedded chart shows total cash returned by scenario.

6. Income and DRIP. A ten-year compounding projection that reinvests dividends at the rate you set on the Inputs sheet. It shows start value, dividend income, the reinvested portion, the withdrawn portion, and the ending value each year, with a line chart of the growing balance.

7. Portfolio / Allocation. Turns your portfolio size into equal-weight dollar allocations, share counts at live prices, dividend income, and total cash return per position, with an allocation donut chart.

8. Yield Comparison. A focused component breakdown: dividend, buyback, debt paydown, total, and free-cash-flow yield for all 24 names, with a small in-cell bar that shows how much of each company's cash return comes from dividends versus the rest.

9. Sector Heatmap. Rolls the watchlist up to the sector level and ranks sectors by average shareholder yield, with a color heatmap and a horizontal bar chart. This is where sector rotation ideas start.

10. Methodology. A one-page explainer covering what each leg means, how the composite score is built, the data source, the assumptions, and the limitations. This is what lifts the workbook from a spreadsheet to a model you can trust.

11. Glossary and Disclaimer. Plain-language definitions of every term, plus an 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 exactly which formulas power what you are looking at.

How to read the screener

The screener is designed to be read top to bottom in about thirty seconds. Start with the Shareholder Yld column, which is the color-scaled heart of the table. Green names are returning the most cash relative to their size. Then glance one column right to the FCF Yld column. If a green shareholder yield is sitting next to an even greener free-cash-flow yield, the cash returns are comfortably funded. If the free-cash-flow yield is thin or red, the company may be funding buybacks or dividends with borrowing, and the high shareholder yield deserves more scrutiny.

The Payout column is the third checkpoint. A payout ratio near the middle of the range usually signals a sustainable dividend with room to grow. A payout ratio pushing past 70% or 80% says most of the earnings are already committed, which limits how much the dividend leg can expand. The composite Score column blends all of this into a single 0 to 100 number, weighting total shareholder yield most heavily, then free-cash-flow coverage, then payout discipline. The traffic-light icons make the top and bottom of the list jump out.

None of these readings are buy or sell signals. They are a structured way to compare how shareholder-friendly different companies are, using cash that has already left the building.

Building it yourself versus downloading it

You could build a basic version of this in an afternoon. List your tickers down column A, put =DIVIDENDYIELD() next to each, add the buyback and debt formulas, sum them, and you have a working shareholder yield screen. The MarketXLS functions library gives you every input you need, and the formulas above are the entire engine.

What takes the afternoon and then some is the presentation layer: the KPI tiles, the conditional formatting rules, the charts, the scenario matrix, the donut, the dropdowns, and the cross-sheet wiring so one input cell drives the whole model. That is what the premium template does for you. It is designed to be presentation-ready the moment it opens, whether you are reviewing your own watchlist or putting a screen in front of a client. If you want to see how the same live-formula approach extends to other factors, the dividend aristocrats dashboard and the sector valuation dashboard use the same design language.

A note on the three legs and their quirks

Each leg of shareholder yield has a personality worth understanding before you lean on the screen.

Dividends are sticky. Boards hate cutting them, so a dividend yield is the most reliable leg. The flip side is that a very high dividend yield can be the market's way of pricing in a future cut, so always read it alongside the payout ratio and free-cash-flow yield.

Buybacks are flexible. Repurchases can be ramped up or quietly switched off with no announcement, which makes the buyback leg more variable year to year. A single large repurchase can also overstate the run-rate, which is exactly why the template shows free-cash-flow yield right next to it. Sustained buybacks funded by free cash flow are a genuinely different thing from a one-off buyback funded by a bond issue.

Debt paydown is situational. A high debt-paydown yield often just means a company over-borrowed in the past and is now repairing its balance sheet. That can be healthy, but it is not the same as a company that generates so much cash it can both return it and stay lightly levered. Treat the debt leg as context, not as the headline.

The screener does not hide any of these quirks. It puts all three legs in separate columns precisely so you can see where a company's shareholder yield is coming from, rather than trusting a single blended number.

Frequently asked questions

What is a shareholder yield screener in Excel? A shareholder yield screener excel model ranks stocks by the total cash they return to shareholders, measured as dividend yield plus buyback yield plus debt-paydown yield, all as a percentage of market capitalization. This template does that for 24 large-cap names and scores them, using live MarketXLS formulas so the values stay current.

How is shareholder yield different from dividend yield? Dividend yield only counts cash paid as dividends. Shareholder yield adds two more legs: the value of share buybacks and the value of net debt reduction. A company with a small dividend but large buybacks can have a high shareholder yield even though a dividend screen would overlook it entirely.

Which MarketXLS formulas calculate buyback yield? Buyback yield uses HF_REPURCHASE_OF_CAPITAL_STOCK("TICKER", year, , TRUE) for the trailing-twelve-month repurchase figure, negated because it is a cash outflow, divided by MARKETCAPITALIZATION("TICKER"). The debt-paydown leg uses HF_ISSUANCE_REPAYMENT_OF_DEBT_SECURITIES the same way, and the dividend leg uses DIVIDENDYIELD.

Can I screen my own tickers? Yes. The Inputs sheet has custom ticker slots, and because every formula references the ticker in its row, you can replace any symbol in the screener and the entire row, including the score and the conditional formatting, recalculates. You can extend the list well beyond 24 names by copying the formula rows down.

Does a high shareholder yield mean a stock is a good buy? No. Shareholder yield is a backward-looking measure of cash that has already been returned. Buybacks can be cut, dividends can be reduced, and a high debt-paydown yield can simply reflect past over-leverage. The template is an educational screening tool, not investment advice, and it shows free-cash-flow coverage precisely so you can judge whether the returns are sustainable.

Do I need MarketXLS for the formulas to work? The live template needs MarketXLS installed in Excel for the functions to pull data. The sample file is pre-filled with static illustrative values and shows each formula as a cell comment, so you can study the structure without the add-in. You can see what MarketXLS covers on the features page or compare options on the pricing page.

Download the templates

Download the full premium template free:

• - pre-filled with illustrative data, every cell annotated with the formula that produces it
• - live, self-updating formulas across all eleven sheets

Both files are free. The design quality is meant to stand on its own, whether you keep the workbook for personal research or adapt it into a client-facing screen.

The bottom line

Dividend yield answers one narrow question: how much is the company paying me in cash right now. Shareholder yield answers the bigger one: how much total cash is this company returning to its owners through every channel it has. In a market where buybacks rival dividends and balance-sheet repair is rewarded, that broader question is the one worth asking. A shareholder yield screener excel model puts the answer on one screen, ranks it, scores it, and keeps it current.

Build it from the formulas above, or download the premium template and start with a dashboard that already looks the part. Either way, you will see your watchlist the way capital-allocation-focused investors do: by the cash, not just the headline.

To explore everything MarketXLS can do inside Excel, visit marketxls.com or book a free demo.