Dividend Stock Screener Excel: Find Safe Yield and Avoid Yield Traps with Live Data

Dividend stock screener guides: payout ratio, dividend growth and the Gordon model, high yield, monthly and preferred stocks, dividend safety, then live dividend data and a yield trap screen in Excel.

1. 1
   Dividend Payout Ratio (Top 10 Stocks with Highest Payout in 2017)

   The dividend payout ratio is dividends per share divided by earnings per share. How to calculate and read it, with MarketXLS Excel formulas.

2. 2
   Dividend Growth (Gordon Growth Model)

   The Gordon Growth Model values a stock as next year's dividend divided by the required return minus the dividend growth rate: D1 / (k - g).

3. 3
   Dividend Stock Screener

   How a dividend stock screener works, which criteria to use (yield, payout ratio, valuation), and how to build one in Excel with MarketXLS.

4. 4
   High Yield Dividend Stocks

   What to check before buying high yield dividend stocks (payout ratio, dividend growth, P/E, company size), plus a January 2019 list of high-yield large caps.

5. 5
   Monthly Dividend Stocks (3 Good Monthly Dividend Stocks)

   Monthly dividend stocks pay every month instead of quarterly. Three examples from 2017 (Realty Income, Main Street Capital, Gladstone Commercial) and how to check yields in Excel.

6. 6
   Preferred Stock Symbols: How to Find, Analyze, and Track Preferred Shares in Excel

   Preferred stock symbols use unique ticker conventions like .P and .PR suffixes. Learn how to identify, look up, and analyze preferred shares in Excel using MarketXLS functions for dividends, pricing, and fundamentals.

7. 7
   Dividend Safety: Analyzing with MarketXLS

   Judge dividend safety with payout ratio, free cash flow payout, dividend coverage, dividend growth history, and the Altman Z-Score, using MarketXLS in Excel.

8. 8
   Dividend Safety Screener Excel: Payout Coverage and Recession Risk in May 2026

   Dividend safety screener Excel template that ranks 24 dividend payers on payout ratio, free cash flow coverage, debt, and a composite Safety Score for May 2026.

9. 9
   Dividend Data in Excel: Live Yields, Payouts, and History for May 2026

   Dividend data in Excel, pulled live with MarketXLS formulas for yield, dividend per share, payout ratio, EPS, cash flow coverage, and dividend history across 25 payers.

10. 10
    Dividend Data in Excel: Late May 2026 Quality, Yield, and Payout Coverage Screen

    Dividend data in Excel for late May 2026, with a quality screen that blends trailing yield, payout coverage, and balance-sheet leverage across 20 dividend payers using live MarketXLS formulas.

11. 11
    Yield Trap Screener Excel June 2026: Spot Dangerous High-Dividend Stocks

    Yield trap screener excel template that flags dangerous high-dividend stocks using six red-flag tests and a composite Trap Risk Score (0-100).