Shareholder Yield Dashboard Excel: Track Total Capital Returned by S&P 500 Names

Shareholder yield dashboard excel - if that is what brought you here, the short answer is yes, you can build a single Excel screener that captures every channel a company uses to return cash to its owners, and you can do it without writing macros, without pulling CSVs, and without a $20,000 terminal subscription. This guide walks through the concept, the math, and a free premium template that ranks 27 large-cap S&P 500 names by total shareholder yield, with KPI tiles, scenario analysis, sector breakdown charts, and conditional-formatted heatmaps built in.

Most income screeners stop at dividend yield. That is a problem. A 5 percent dividend yield from a company that buys back 0 percent of its stock and adds debt every year is a very different proposition from a 2 percent dividend yield paired with a 4 percent buyback yield and active deleveraging. Both look like income on the surface. Only one is actually returning cash. Total shareholder yield is the cleaner metric, and a dashboard is the natural way to compare it across a universe of names.

Quick reference: shareholder yield components

Three numbers. One composite. It cuts through the dividend-only narrative and the buyback-only narrative and gives you a single number to sort on.

What shareholder yield actually measures

Companies have four ways to do something useful with cash flow: reinvest in the business, return it to shareholders as dividends, return it to shareholders by repurchasing stock, or use it to pay down debt (which indirectly accrues to equity holders by reducing the senior claim on assets). The first option, reinvestment, shows up in the income statement as growth. The other three show up as some form of yield to existing shareholders.

Shareholder yield treats all three of those distribution channels as equivalent. The intuition is straightforward: a company that returns 100 dollars to you in dividends is doing roughly the same thing as a company that buys back 100 dollars worth of stock at a fair price (your stake increases) or pays down 100 dollars of debt (the equity claim grows). The composite catches all three.

This is why a pure dividend screener can mislead. Take a company that pays out 2 percent in dividends, buys back 4 percent of its float every year, and pays down debt equal to another 1 percent of market cap. Total shareholder yield: 7 percent. A 5 percent dividend payer with no buybacks and rising debt looks "higher yield" but is actually returning less. Worse, that 5 percent dividend may be unsustainable if it is funded by new debt rather than free cash flow. The composite metric forces you to look at the whole picture.

The academic backing for shareholder yield as an investing factor goes back at least to Mebane Faber's "Shareholder Yield" research, which extended Cooper, Gulen, and Schill's asset growth work into the capital-return domain. The empirical claim is that high total shareholder yield portfolios have, historically, outperformed both pure high-dividend and pure low-asset-growth portfolios on a risk-adjusted basis. Past performance, as always, is no guarantee of anything, and you should treat any backtest with healthy skepticism. But the conceptual case for measuring all three channels together is rock solid.

Why a dashboard is the right format

You cannot eyeball shareholder yield. Dividend yield is published. Buyback yield requires you to compute the change in share count and divide by something. Net debt paydown requires you to look at the balance sheet a year ago and today and divide by current market cap. Combining the three for a single name takes maybe 90 seconds in Excel. Doing it for 27 names takes 40 minutes by hand, every time you want to refresh.

A dashboard solves this. You write the formula once per ticker, the spreadsheet pulls the data live (with MarketXLS plugged in) or runs on a static snapshot (sample version), and conditional formatting flags the names worth your attention before you have read a single number. KPI tiles up top show the universe averages. Charts below rank the names. The screener at the bottom lets you sort by any column.

That is what this template delivers, and it is what made shareholder yield interesting to build into a premium spreadsheet rather than a six-line blog post.

What is inside the template

Both files in this download contain ten polished sheets, each with tab colors, frozen panes, branded headers, and a "MarketXLS Functions Used in This Sheet" reference box at the bottom. Here is the walkthrough.

1. Cover. A presentation-grade title page with the dashboard name, edition, data-as-of date, and a full table of contents. Hidden gridlines. Navy background with gold accent typography. Designed to look like the front of a fintech product, not the front of a spreadsheet.

2. How To Use. Step-by-step tutorial across eight numbered steps. Each step has a header in MarketXLS blue and a paragraph of instructions. Includes the master list of MarketXLS functions used across the entire workbook, with one-line descriptions of each.

3. Dashboard. The headline sheet. Six KPI tiles across the top showing universe averages: average dividend yield, average buyback yield, average debt paydown yield, average total shareholder yield, count of names yielding more than 5 percent, and the top single name. Below the tiles, two embedded native Excel charts: a horizontal bar chart of the top 10 names by total yield, and a pie chart of sector distribution. The screener table at the bottom holds 27 ranked names with 14 columns each, color-scale formatted on total yield, FCF yield, and payout ratio, and data-bar formatted on dividend yield, buyback yield, and debt paydown yield. Hidden gridlines. Print area set for clean landscape printing.

4. Inputs. All the cells you can edit, isolated to one sheet so you never have to hunt. Yellow backgrounds with bold borders mark the editable cells. Data validation dropdowns for risk tier (Conservative, Base, Aggressive), reinvestment toggle (Yes, No), and universe selector (S&P 500, Dividend Aristocrats, Buyback Achievers, Custom Tickers Only). Slots for three optional custom tickers that flow through to the Comparison sheet.

5. Scenario Analysis. A 5-by-3 matrix showing how dividend yield, buyback yield, and debt paydown yield shift across five market regimes: Recession, Slow Growth, Base Case, Above Trend, and Bull Run. Below the matrix, a row of projected annual cash returned to shareholders for each regime, computed against your portfolio size from the Inputs sheet. Color-scale conditional formatting on the totals row, data bars on the cash row.

6. Strategy. An optional covered call overlay table for the top 10 dividend payers in the universe. Each row shows ticker, current stock price, sample 30-DTE call strike, premium, days to expiration, annualized premium yield, combined yield (dividend plus buyback plus debt paydown plus premium), break-even, and max profit at strike. Useful for thinking about layering option income on top of an already income-focused screener. Educational only - the premium numbers are illustrative, not live.

7. Portfolio. Equal-weighted dollar allocation of your portfolio size across all 27 names. Each row shows weight percent, dollar allocation, approximate share count at current price, and projected annual dividend cash. Donut chart of sector allocation. Twelve-month dividend calendar at the bottom showing the expected payout pattern by month.

8. Comparison. Universe averages benchmarked against four ETFs: SPY (S&P 500), NOBL (Dividend Aristocrats), PKW (Buyback Achievers), and VYM (High Dividend Yield). Seven rows of metrics: each yield component, total shareholder yield, P/E, beta, payout ratio. Color-scale formatting across each row. Below, a section for the three custom tickers you set on the Inputs sheet, with live MarketXLS lookups for price, dividend yield, P/E, sector, ROE, and beta. A horizontal bar chart compares total shareholder yield across all five benchmarks plus the universe.

9. Methodology. A one-page explainer covering how each yield component is calculated, the universe construction logic, sector classification, P/E and payout interpretation, why shareholder yield matters as a composite, and the key limitations: M&A activity can distort share count changes, special dividends inflate trailing yields, the buyback and debt paydown components floor at zero, and equal-weighted scenarios assume mechanical reinvestment.

10. Glossary and Disclaimer. Twelve term definitions covering everything from "Dividend Yield" to "DTE" to "Break-even." A clearly worded educational disclaimer reminding the reader that this is not investment advice, that past payout history does not guarantee future returns, and that companies cut dividends, halt buybacks, and lever up for many reasons.

Every sheet has a navy footer with the MarketXLS branding line and a book-a-demo URL. Tab colors are set per sheet (navy on Cover, blue on Dashboard, yellow on Inputs, etc.). Frozen panes everywhere so headers stay visible while you scroll.

How shareholder yield is calculated in MarketXLS

The whole point of building this in Excel rather than in a Bloomberg terminal is that you can see and edit the math. Here are the formulas the template uses for each component.

Dividend yield

=DividendYield("XOM")

That is it. MarketXLS pulls the trailing twelve-month dividends per share, divides by current price, returns the percentage. No assembly required.

Net buyback yield

This one needs two pulls: current shares outstanding and shares outstanding from one year ago. The formula:

=MAX(0, (hf_Total_common_shares_outstanding("XOM","ly") - Shares_Outstanding("XOM"))
       / hf_Total_common_shares_outstanding("XOM","ly") * 100)

The hf_ prefix denotes a historical fundamentals function. "ly" means "last fiscal year." The MAX(0, ...) floor prevents negative buyback yields from showing up in the screener - if a company issued more stock than it bought back over the year, the cell shows 0 rather than a misleading negative number. The methodology sheet calls this out explicitly so users do not confuse a 0 with a "no data" reading.

Net debt paydown yield

Same logic as buyback yield, but on the debt side of the balance sheet, normalized by market cap.

=MAX(0, (hf_Total_Debt("XOM","ly") - TotalDebt("XOM"))
       / MarketCapitalization("XOM") * 100)

If total debt fell from 50 billion last year to 47 billion today, and market cap is 525 billion, the debt paydown yield is roughly 0.57 percent. Floor at zero so net new borrowing does not show up as a "negative yield."

Total shareholder yield

Sum of the three. A simple addition.

=F12+G12+H12

That is the column the screener sorts on.

Quality and valuation columns

The screener also pulls supporting metrics so you can sanity-check the yield numbers:

=PERatio("XOM")              ' Trailing P/E ratio
=PayoutRatio("XOM")          ' Dividends as percent of earnings
=FreeCashFlowPerShare("XOM") / QM_Last("XOM") * 100   ' FCF yield
=Beta("XOM")                  ' Sensitivity to broad market
=ReturnOnEquity("XOM")       ' ROE
=Sector("XOM")                ' GICS sector
=MarketCapitalization("XOM") ' Market cap

These give you the context you need to flag risk. A 10 percent total shareholder yield with a 110 percent payout ratio and a 4 percent FCF yield is not a buy signal - it is a warning that the dividend and buyback program may be funded by something other than recurring cash flow.

Reading the dashboard: a worked example

Open the Dashboard sheet. The KPI tile row shows you, at a glance, that the average total shareholder yield across the 27 names is roughly in the high single digits. Below the tiles, the Top 10 bar chart highlights the names doing the most in absolute terms.

Sort the screener by Total Shareholder Yield descending. You will see a tobacco name and a couple of energy majors near the top. That makes sense: these are mature, cash-generative businesses that return most of their cash to shareholders rather than reinvesting, because the runway for high-return reinvestment is limited.

Now sort by FCF Yield. Compare the top of that list to the top of the Total Shareholder Yield list. Names that show up high on both are returning a lot of cash and are generating enough free cash flow to back it. Names that show up high on Total Yield but low on FCF Yield are the ones to be skeptical about - they might be funding the payout with debt or asset sales.

Now look at the Payout Ratio column, which is conditionally formatted with a reverse color scale (green for low, red for high). A name with a 95 percent payout ratio is paying out almost everything it earns. Any earnings stumble forces a dividend cut. A name with a 40 percent payout ratio has cushion.

This is the kind of cross-checking that conditional formatting makes effortless. You are not crunching the numbers; you are reading the colors.

Scenario analysis: what happens in different regimes

Open the Scenario Analysis sheet. The matrix shows how each yield component reacts to a different macro regime. The assumptions are spelled out in the box below the matrix:

• Recession: Dividends trim 15 percent, buybacks slashed 70 percent, debt paydown accelerates 40 percent.
• Slow Growth: Dividends down 5 percent, buybacks down 30 percent, debt paydown up 10 percent.
• Base Case: Yields stay at trailing 12-month average.
• Above Trend: Dividends up 2 percent, buybacks up 30 percent, debt paydown down 15 percent.
• Bull Run: Dividends down 2 percent, buybacks up 55 percent, debt paydown down 50 percent.

The pattern in the matrix is the interesting part: in a recession, buybacks collapse but debt paydown ramps. In a bull run, the opposite. Total shareholder yield does not move as much as any single component because the components are negatively correlated across regimes. That diversification across return channels is part of why a composite metric is more stable than any single piece of it.

The bottom row of the sheet multiplies each scenario's total yield by your portfolio size from the Inputs sheet, giving you projected annual cash returned to you as an owner under each regime. A 100,000 dollar portfolio at the universe average yield is generating something on the order of mid-thousands of dollars per year of cash returned. The scenario row shows how that flexes from recession to bull.

This is not a forecast. It is a sensitivity table - it tells you how much cash you should expect under different conditions, given today's universe.

Comparing to benchmarks

Open the Comparison sheet. The universe is benchmarked against four ETFs:

• SPY - S&P 500. The market.
• NOBL - ProShares S&P 500 Dividend Aristocrats ETF. Names with at least 25 consecutive years of dividend increases.
• PKW - Invesco BuyBack Achievers ETF. Names with significant net buybacks over the trailing 12 months.
• VYM - Vanguard High Dividend Yield ETF. Higher dividend names.

The takeaway: the universe in this dashboard is a hand-selected blend of names that score well across multiple capital-return channels, so it tends to outshine SPY on every yield metric and competes with the more specialized buyback and dividend ETFs. Of course, that is partly a function of how the universe was constructed - if you swap in different tickers via the universe selector on the Inputs sheet, the comparison shifts.

The custom ticker block lets you drop in three tickers of your own and see them benchmarked side by side against the universe. Useful for "how does the name I am thinking about adding compare to my existing list" questions.

MarketXLS implementation walkthrough

Building this in Excel from scratch takes about an hour if you are starting cold. Here is the rough sequence.

Step 1: Build the ticker list. Start with a column of tickers in column B. Then the supporting columns: Company name, Sector (=Sector(B12)), Price (=QM_Last(B12)), Market Cap (=MarketCapitalization(B12)).

Step 2: Add the three yield components. Dividend yield is one cell. Buyback yield needs the prior-year shares pull and the math. Debt paydown yield needs the prior-year debt pull, the current debt pull, and the market cap normalization. Wrap each in IFERROR() so missing data shows as 0 rather than a #N/A that breaks downstream sums.

Step 3: Add the total column. Just sum the three yield components.

Step 4: Add quality and valuation columns. P/E, payout ratio, FCF yield, beta, ROE.

Step 5: Apply conditional formatting. Color scales on Total Yield, FCF Yield, and Payout Ratio. Data bars on the three individual yield components.

Step 6: Add the KPI tiles. AVERAGE, COUNTIF, INDEX/MATCH formulas pulling from the screener.

Step 7: Embed the charts. Bar chart for the top 10 by total yield. Pie chart for sector distribution.

Step 8: Build the Inputs sheet. Yellow input cells, data validation dropdowns, descriptions.

Step 9: Reference Inputs from downstream sheets. Portfolio sheet uses the portfolio size cell. Scenario sheet uses portfolio size for the cash projection row. Comparison sheet uses the custom ticker cells.

Step 10: Polish. Tab colors, frozen panes, hidden gridlines on Cover and Dashboard, branded footers, MarketXLS functions reference at the bottom of every sheet.

The premium template you can download below already has all 10 steps done. The point of the walkthrough is to show that everything in it is buildable yourself - nothing is hand-coded data, nothing requires VBA, nothing is hidden behind a closed-source plugin layer. Every cell is a formula or a value you can see and change.

Download the templates

Download the templates:

• - Pre-filled with researched values. Every data cell has a comment showing the MarketXLS formula that would produce the live number. Open it without MarketXLS installed and the dashboard still works.
• - Live formulas throughout. Open with MarketXLS installed and every yield, every quality metric, every comparison row refreshes against current data.

Both files are free for now. Designed to look like a 49 dollar product on Gumroad - cover page, KPI tiles, embedded charts, conditional formatting heatmaps, scenario matrix, sector pie chart, dividend calendar, branded footers. If you only download one, the live-formula version is the one that keeps paying you back over time.

FAQ: shareholder yield dashboard excel

What is shareholder yield in simple terms? Shareholder yield is a single number that combines dividend yield, net buyback yield, and net debt paydown yield. It captures every channel a company uses to return cash to its owners. A pure dividend yield can mislead because it ignores buybacks (which are equivalent to a dividend in cash terms) and debt paydown (which accrues to equity holders by reducing senior claims).

Why use a dashboard instead of a regular screener? A dashboard adds visual hierarchy: KPI tiles for at-a-glance summaries, embedded charts for ranking, conditional formatting heatmaps that flag risk before you read the numbers. A flat screener is just a table; a dashboard turns the same data into something you can read in 30 seconds.

Can I customize the universe of tickers? Yes. The Inputs sheet has a universe selector dropdown (S&P 500 default, Dividend Aristocrats, Buyback Achievers, Custom Tickers Only). The Comparison sheet has three slots for custom tickers that pull live MarketXLS data for side-by-side benchmarking. To swap the entire screener universe, you can edit the ticker column on the Dashboard sheet and the formulas re-rank automatically.

What MarketXLS formulas are required? The core ones are DividendYield, Shares_Outstanding, hf_Total_common_shares_outstanding, TotalDebt, hf_Total_Debt, MarketCapitalization, PERatio, PayoutRatio, FreeCashFlowPerShare, QM_Last, Beta, ReturnOnEquity, and Sector. The full list is documented on the How To Use sheet of the template, and on the MarketXLS function reference. Each function is a single-cell call returning the metric.

Is shareholder yield investing actually a thing? Yes. Mebane Faber's research on "shareholder yield" as an investing factor is the most-cited starting point. The empirical claim is that high total shareholder yield portfolios have historically outperformed both pure high-dividend and pure low-asset-growth portfolios on a risk-adjusted basis. Past performance is no guarantee, and the standard disclaimers apply. But the conceptual case for measuring all three return channels together is well established.

Does the dashboard auto-refresh with live prices? The premium template version (the second download link) uses live MarketXLS formulas, so when you open the file in Excel with MarketXLS installed and authenticated, every cell pulls fresh data on calculation. The sample version is static, with formula references in cell comments so you can see what the live formula would have been.

What if a company shows a negative buyback yield? The template floors negative buyback yields at zero. Net dilution (more shares issued than repurchased) is a meaningful signal, but folding it into the total yield as a negative would distort the composite by mixing capital-return information with capital-raising information. The methodology sheet documents this design choice. If you want to see the raw signed buyback yield, edit the formula and remove the MAX(0, ...) wrapper.

How is this different from a buyback-only or dividend-only screener? A buyback-only screener catches companies returning cash via repurchases but misses dividend payers. A dividend-only screener does the reverse. This dashboard does both, plus debt paydown, in one composite, so a company that returns cash through any combination of the three channels gets full credit. That is the whole point of measuring shareholder yield as a composite rather than as one of its components.

The bottom line

Shareholder yield is the cleanest single number for measuring how much cash a company returns to its owners. Dividend yield alone misses buybacks and debt paydown. Buyback yield alone misses dividends. The composite catches all three, and a dashboard is the natural format because conditional formatting and KPI tiles make the patterns obvious without forcing you to crunch the numbers manually.

The template above ranks 27 large-cap S&P 500 names by total shareholder yield, with a Dashboard, an Inputs sheet, scenario analysis across five market regimes, a covered call strategy overlay, equal-weighted portfolio allocation, benchmark comparison against four ETFs, methodology, and a glossary. Ten sheets, premium typography, embedded charts, color-scaled heatmaps, frozen panes, branded footers. Designed to look like a paid product on Gumroad.

If you build your own version from the formulas in this guide, you will end up with something close. If you download the template, you can be running it in Excel in 30 seconds.

For the full MarketXLS Excel add-in (which powers the live-formula version of the template), see MarketXLS. To see how it fits into a broader investing workflow, book a live demo and we will walk through it together.