Dividend Kings screener Excel is the kind of tool you build once and keep for life. With Father's Day landing on Sunday, June 15, 2026, this week is the natural moment for advisors and self-directed investors to re-examine the longest-running dividend growth franchises on the US market. These are the companies that have paid a higher dividend in 50 or more consecutive years - through every recession, inflation regime, oil shock, banking crisis, and pandemic since the 1970s. This guide gives you a working Excel screener for all 28 of the most liquid Dividend Kings, a quality scoring system, a scenario engine that models 30 years of reinvested dividend compounding, and a portfolio builder that respects sector caps. Every metric in the workbook is wired to a verified MarketXLS formula, so the moment a name raises (or cuts) its payout, your dashboard updates in real time.
Key Data Table: 2026 Dividend Kings at a Glance
The table below shows the 28 Dividend Kings included in the workbook, ordered by the length of their consecutive dividend increase streak. This is the single most important field on the dashboard - it is the gating filter that separates a King from a Dividend Aristocrat or a Dividend Champion.
| Ticker | Company | Sector | Streak (Yrs) | Fwd Yield |
|---|---|---|---|---|
| AWR | American States Water | Utilities | 71 | 2.4% |
| DOV | Dover | Industrials | 70 | 1.1% |
| GPC | Genuine Parts | Consumer Disc. | 70 | 3.0% |
| EMR | Emerson Electric | Industrials | 69 | 1.6% |
| PH | Parker-Hannifin | Industrials | 69 | 0.9% |
| PG | Procter & Gamble | Consumer Staples | 69 | 2.5% |
| MMM | 3M | Industrials | 67 | 2.0% |
| JNJ | Johnson & Johnson | Healthcare | 64 | 3.1% |
| KO | Coca-Cola | Consumer Staples | 63 | 2.9% |
| CL | Colgate-Palmolive | Consumer Staples | 63 | 2.2% |
| LANC | Lancaster Colony | Consumer Staples | 63 | 2.3% |
| LOW | Lowe's | Consumer Disc. | 63 | 1.8% |
| NDSN | Nordson | Industrials | 62 | 1.2% |
| HRL | Hormel Foods | Consumer Staples | 60 | 3.6% |
| SWK | Stanley Black & Decker | Industrials | 58 | 4.0% |
| FRT | Federal Realty | Real Estate | 58 | 4.3% |
| MO | Altria | Consumer Staples | 56 | 7.8% |
| TGT | Target | Consumer Disc. | 56 | 3.2% |
| SYY | Sysco | Consumer Staples | 55 | 2.5% |
| BKH | Black Hills | Utilities | 55 | 4.6% |
| ABT | Abbott Laboratories | Healthcare | 54 | 1.9% |
| BDX | Becton Dickinson | Healthcare | 54 | 1.9% |
| PEP | PepsiCo | Consumer Staples | 54 | 4.1% |
| NUE | Nucor | Materials | 53 | 1.4% |
| PPG | PPG Industries | Materials | 53 | 2.4% |
| KMB | Kimberly-Clark | Consumer Staples | 53 | 3.6% |
| WMT | Walmart | Consumer Staples | 52 | 0.9% |
| RPM | RPM International | Materials | 52 | 1.6% |
| ADP | Automatic Data Processing | Industrials | 51 | 2.0% |
This is the universe powering every other sheet in the screener.
Why Build a Dividend Kings Screener Excel in June 2026?
Dividend Kings screener Excel templates rise in interest every Father's Day for a reason: legacy. The Kings are the stocks investors hand down to children. The thinking goes that any company able to raise its dividend through five decades of macro turbulence has institutional muscle memory most other businesses cannot replicate. But the list shifts more than the headlines suggest. In 2026 the Kings list lost AT&T after the WarnerMedia spin-off reset its streak, and added Walmart (52 years) and RPM International (52 years) as fresh entrants. Building the screener in Excel - rather than relying on a static online list - lets you re-screen each quarter without paying for another data subscription.
Three current market conditions make June 2026 a useful moment to refresh the screener:
- The Father's Day gifting window. Many advisors fund custodial accounts for children and grandchildren in June. A Dividend King basket has historically been a popular vehicle for that gift.
- Mid-year portfolio rebalancing. With Q2 closing soon and Q2 earnings just three weeks away, June is the natural pause for income-focused investors to check that sector weights have not drifted.
- Yield compression in the long bond market. With longer-dated Treasuries trading in a tight range, the spread between Dividend King forward yields and the 10-year benchmark has compressed. That changes the conversation from "yield-seeking" to "quality-seeking".
What Defines a Dividend King vs. an Aristocrat
A Dividend King is a publicly traded US company that has raised its dividend per share in 50 or more consecutive years. A Dividend Aristocrat needs only 25 years, and a Dividend Champion follows the same 25-year bar but does not require S&P 500 membership. Walking up the list:
| List | Years of Increases | Index Requirement |
|---|---|---|
| Dividend Achievers | 10+ | NASDAQ US Dividend Achievers Index |
| Dividend Champions | 25+ | No index requirement |
| Dividend Aristocrats | 25+ | S&P 500 member |
| Dividend Kings | 50+ | No index requirement |
| Dividend Emperors (unofficial) | 60+ | No index requirement |
The 50-year bar is brutal. The list contained only about 30 companies as of mid-2026, and the average new addition takes nearly six decades from IPO before qualifying. That scarcity is exactly what makes the Kings useful as a screening base - your starting universe is already a quality filter.
The Single MarketXLS Formula That Builds the List
The reason this screener is possible in Excel without external data feeds is one specific MarketXLS function:
=ConsecutivePeriodOfIncreasingDividendPayout("KO")
This returns the number of consecutive periods of increasing dividend payout for a given ticker. To screen for Kings, you simply wrap it in an IF or a filter:
=IF(ConsecutivePeriodOfIncreasingDividendPayout("KO")>=50,"King","Not a King")
That one formula gives you a self-updating membership flag. If a company cuts or freezes its dividend, the streak resets and the cell flips to "Not a King" the next quarter. No more relying on a third-party list that may be three months out of date.
How the Screener Works: Sheet by Sheet
The downloadable Dividend Kings screener Excel workbook contains six sheets. Each one is wired to MarketXLS live formulas so the dashboard refreshes whenever you open it.
Sheet 1: How To Use
A tutorial introduction with the full list of MarketXLS functions referenced across the workbook. Useful as a copy-paste reference when you want to build your own variants.
Sheet 2: Main Dashboard
The core screener. All 28 Kings listed with live formulas pulling current price, yield, forward dividend rate, payout ratio, P/E, beta, market cap, percent vs. 200-day SMA, and a composite Quality Score from 0 to 100. The Quality Score is a weighted blend:
=ROUND(MIN(100,MAX(0,
50
+ (DividendYield(ticker)*100)*4
- (DividendPayoutRatio(ticker)-0.6)*40
- MAX(0,Beta(ticker)-1)*15
+ MIN(20,ConsecutivePeriodOfIncreasingDividendPayout(ticker)/4))),0)
The score rewards yield and long streaks, penalises payout ratios above 60%, and penalises beta above 1.0. Color-scale conditional formatting on the score column lets you eyeball winners instantly.
Sheet 3: Scenario Analysis
A 30-year dividend reinvestment simulator. You set six yellow input cells - starting capital, starting yield, dividend growth rate, price appreciation rate, time horizon, and tax rate - and the sheet projects portfolio value, cumulative dividends, yield on cost, and total return multiple for each year. This is the sheet that tells a parent funding a Father's Day gift account whether $5,000 today plus annual contributions can realistically hit a six-figure target by the time the child finishes college.
Sheet 4: Strategy Builder
Two distinct strategies side by side. Strategy A is High Yield Income for retirees and income mandates: 3.5% minimum yield, payout ratio ceiling of 90%, sector cap of 30%. Strategy B is Quality Compounder for long-horizon investors: 15% minimum ROE, payout ceiling of 60%, debt-to-equity ceiling of 1.5, beta ceiling of 1.2. Both have explicit entry, sizing, and exit rules using MarketXLS formula references.
Sheet 5: Portfolio Builder
A 15-name sample portfolio with input cells for portfolio size, sector caps, and target yield. Each position has live price and forward dividend rate formulas that flow through to share counts and annual income. The total income, effective portfolio yield, and monthly average income calculate automatically from a single $250,000 input that you can override.
Sheet 6: Sector Heatmap
Sector-level aggregations of yield, payout ratio, P/E, beta, and average streak using AVERAGEIF against the Main Dashboard table. Six narrative insights summarise where the concentration sits.
Real MarketXLS Formula Examples Used in the Workbook
Every cell in the template (the non-static version) is one of these live formulas:
=QM_Last("KO") (current price)
=DividendYield("KO") (TTM dividend yield)
=ForwardAnnualDividendRate("KO") (forward annual dividend $)
=ForwardAnnualDividendYield("KO") (forward dividend yield)
=DividendPayoutRatio("KO") (dividend payout ratio)
=PayoutRatio("KO") (total payout ratio)
=FiveYearAverageDividendYield("KO") (5-year average yield)
=DividendPerShare("KO") (TTM DPS)
=ConsecutivePeriodOfIncreasingDividendPayout("KO") (streak in years)
=Ex_DividendDate("KO") (most recent ex-div date)
=DividendPayDate("KO") (next pay date)
=DividendBetweenTwoDates("KO",DATE(2020,1,1),TODAY()) (back-test cash flow)
=PERatio("KO") (P/E ratio)
=EarningsPerShare("KO") (TTM EPS)
=MarketCapitalization("KO") (market cap)
=Beta("KO") (beta vs. market)
=TotalDebtToEquity("KO") (leverage)
=ReturnOnEquity("KO") (ROE)
=OperatingMargin("KO") (operating margin)
=Sector("KO") (sector classification)
=SimpleMovingAverage("KO",50) (50-day SMA)
=SimpleMovingAverage("KO",200) (200-day SMA)
=FiftyTwoWeekHigh("KO") (52-week high)
=FiftyTwoWeekLow("KO") (52-week low)
You do not need to memorise these - the workbook drops them in for you. But knowing the function names lets you extend the screener with any additional metric you want.
The Approach: Building a Dividend King Portfolio That Lasts
The hypothesis behind a Dividend King strategy is that survivor bias works in your favor. A company that has raised its dividend for 50 consecutive years has demonstrated:
- Resilient free cash flow through multiple recessions
- A capital allocation framework that prioritises shareholder returns
- A management culture that treats the dividend as a contract, not a discretionary item
- A board that is willing to defer buybacks before cutting the payout
That track record is not a guarantee. AT&T, 3M, and Walgreens have all proven that long streaks can break when balance sheet stress meets capital allocation mistakes. The job of the screener is not to identify "safe" stocks, but to surface the names where the streak is currently backed by healthy payout coverage and conservative leverage. The Quality Score on the dashboard does that work.
A few educational principles inform how investors use the workbook (this is not investment advice):
- Diversify across sectors. Consumer staples dominate the Kings list, but a portfolio concentrated only in staples will lag during cyclical recoveries. The portfolio builder caps any single sector at 30% by default.
- Watch the payout ratio more than the yield. A 5% yield with a 95% payout is more fragile than a 2.5% yield with a 35% payout. Sheet 2 conditional formatting flags the danger zone in red.
- Reinvest while compounding, switch to cash flow at drawdown. The Scenario Analysis sheet has a binary reinvestment toggle (1 or 0). The math shows that the difference between reinvested and non-reinvested compounding over 30 years is enormous.
- Re-screen each quarter. The whole point of a live-formula spreadsheet is that you do not need to rebuild it. Open it once a quarter, force a recalc (Ctrl+Alt+F9), and you have a fresh view.
Download the Templates
Download the templates:
- - Pre-filled with snapshot values as of June 11, 2026. Each cell shows the MarketXLS formula that powers it, even though the values are static. Useful for previewing the design before installing the MarketXLS add-in.
- - Every data cell is a live MarketXLS formula. Open in Excel with the MarketXLS add-in installed and the entire dashboard refreshes automatically.
Both files contain the six-sheet structure: How To Use, Main Dashboard, Scenario Analysis, Strategy Builder, Portfolio Builder, and Sector Heatmap. The MarketXLS branding and links to https://marketxls.com and https://marketxls.com/book-demo are embedded throughout.
Putting the Screener to Work: A June 2026 Walkthrough
Let's walk through a practical use case. Suppose you are setting up a $10,000 Roth IRA contribution today, target date a 25-year horizon, and you want a Dividend King core with reinvested dividends.
Step 1. Open the Main Dashboard. Sort by Quality Score (column M) descending. Note the top 10 names. Today's snapshot puts JNJ, ABT, PG, EMR, PEP, KO, and AWR near the top of the quality leaderboard.
Step 2. Filter for payout ratio below 70% (column H). This cuts a few high-payout names like FRT and MO, both of which carry elevated dividend risk despite long streaks.
Step 3. Move to the Scenario Analysis sheet. Set Starting Investment = $10,000, Starting Yield = 3.0% (a realistic blended yield for the top names), Dividend Growth Rate = 7.0% (the historical median for Kings), Price Appreciation = 5.0%, Time Horizon = 25, Reinvest = 1. The sheet projects a portfolio value approaching $55,000 at year 25 with cumulative dividends of around $22,000, and yield on cost rising above 15%.
Step 4. Open the Portfolio Builder. Set Portfolio Size = $10,000 and Number of Positions = 8 (manageable for a small account). Either accept the default sample portfolio or replace ticker symbols with your filtered top eight. The sheet computes share counts and projected annual income.
Step 5. Check the Sector Heatmap. Ensure no single sector exceeds 30% weight. If it does, swap one position out and re-balance.
This is the kind of analysis that used to require a $1,000/year data subscription or an analyst's afternoon. The combination of MarketXLS plus this screener compresses it into about 10 minutes.
Dividend Kings vs. Dividend Aristocrats: When to Use Which
The Aristocrats list is larger (about 65 names as of mid-2026 vs. about 30 Kings), so it provides better sector diversification and lower idiosyncratic risk. The Kings list is more concentrated in Consumer Staples and Industrials, and it skews toward smaller-cap names like AWR, LANC, and BKH that have demonstrated extreme persistence but trade at thin volumes.
| Consideration | Aristocrats Edge | Kings Edge |
|---|---|---|
| Sector diversity | Better | More concentrated |
| Liquidity | Better (S&P 500 only) | Mixed - some small caps |
| Survivor bias | 25 years | 50 years (stronger filter) |
| Yield range | Wider | Narrower, biased to lower yields |
| Number of names | Roughly 65 | Roughly 30 |
| Use case | Core diversified income | Concentrated quality, multi-decade horizon |
A common pattern: hold an Aristocrats ETF for breadth, then overweight 5 to 10 Kings as concentrated high-conviction names. The screener you just downloaded supports either choice.
FAQ: Dividend Kings Screener Excel
What is a Dividend King and how many are there?
A Dividend King is a US-listed company that has raised its dividend per share in 50 or more consecutive years. As of mid-2026 the list contains roughly 30 companies. The exact count shifts as new entrants cross the 50-year line and existing members occasionally lose their status through dividend freezes or cuts. The screener uses 28 of the most liquid names with market caps above $2 billion.
What MarketXLS formula identifies a Dividend King?
The key formula is =ConsecutivePeriodOfIncreasingDividendPayout("ticker"), which returns the integer count of consecutive years of dividend increases. Combine it with an IF: =IF(ConsecutivePeriodOfIncreasingDividendPayout("KO")>=50,"King","Not a King"). This auto-updates as streaks extend or reset.
Is a Dividend Kings screener Excel template better than a static online list?
For most investors yes, because static lists go stale within weeks. A live Excel screener built on MarketXLS formulas refreshes every metric the moment you open the workbook - price, yield, payout ratio, streak, and quality score. You can sort, filter, and stress-test scenarios that a static webpage cannot support.
How is the Quality Score in the dashboard calculated?
The Quality Score is a 0-to-100 composite. It rewards higher dividend yields and longer streaks, and penalises payout ratios above 60% and betas above 1.0. The full formula sits inside the Main Dashboard tab. You can adjust the weights inside the workbook to fit your own preferences.
Can I add or remove Dividend Kings from the template?
Yes. The template is fully editable. To add a name, copy any row in the Main Dashboard, paste it into a new row, and change the ticker. Every formula references the ticker in column A so the rest of the row will update automatically.
Do I need a MarketXLS subscription to use the template?
The static sample workbook opens in any version of Excel with no add-in required - it shows the design and pre-filled values. The formula version requires the MarketXLS Excel add-in for the QM_Last, DividendYield, ConsecutivePeriodOfIncreasingDividendPayout, and related functions to refresh data. Visit https://marketxls.com to learn more or https://marketxls.com/book-demo to see the formulas working in a guided session.
Are Dividend Kings safer than other dividend stocks?
A 50-year track record reflects historical resilience but does not guarantee future safety. The screener is built specifically to surface where current payout ratios, leverage, and momentum suggest the streak is still well-supported. Always treat the output as a starting point for further research, not a buy recommendation.
The Bottom Line
A Dividend Kings screener Excel workbook is one of the most durable tools an income-focused investor can build. The Kings list itself is a survivor-bias filter that has already done much of the hard work, and the MarketXLS add-in makes it trivial to keep your dashboard, scenarios, and portfolio builder live without ever touching a webpage. June and Father's Day 2026 are a natural moment to refresh that workflow, whether you are funding a child's custodial account, planning a retirement income ladder, or simply running a mid-year rebalance.
Two final notes. First, do not let the long streaks lull you into ignoring the payout ratio, leverage, and momentum filters - those are the early warning indicators of streak risk. Second, the screener is fully editable. Add formulas, change weights, change tickers, layer in your own factor filters. The template is meant as a starting point, not a black box.
Download the workbook above, install the MarketXLS add-in if you do not already use it, and explore the live formulas at https://marketxls.com. For a guided walkthrough with a MarketXLS specialist, book a demo at https://marketxls.com/book-demo.
