STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

REIT Payout Ratio: FFO vs EPS Explained
Dividend as a percent of EPS: large equity REITs against every other US dividend payerranking · 2026-08-22 · 2×4Preview: 2 ranked values, largest first. Large equity REITs: dividend as a percent of earnings per share, latest snapshotranking · 2026-08-22 · 11×3Preview: 11 ranked values, largest first. Year-end dividend rate against twelve months earlier: how many large REITs raised or loweredtable · 2026-08-22 · 9×5 Realty Income (O): monthly dividend per share, January 2021 to the latest declared paymentseries · 2026-08-22 · 64×3Preview: a 16-point series, ending higher.
Is a Dividend Safe? Free Cash Flow Test
Same year, two payout ratios: earnings basis against cash basis (illustrative, percent)ranking · 2026-08-07 · 2×2Preview: 2 ranked values, smallest first. Illustrative year: the reconciliation behind the coverage test (hypothetical manufacturer, $ millions)ranking · 2026-08-07 · 6×2Preview: 6 ranked values, largest first.
Dividend as a percent of EPS: large equity REITs against every other US dividend payer

Dividend as a percent of EPS: large equity REITs against every other US dividend payer

most recentas of ranking 2×4read in context →
Dividend as a percent of EPS: large equity REITs against every other US dividend payer — 2 rows by 4 columns, computed from US exchange, SIP and OPRA data.
categorycompany_countmedian_eps_payout_pctpct_paying_over_earnings
All other dividend payers113835.815.6
Equity REITs11126.481.8
the exact SQL behind every number 
SELECT multiIf(ticker IN ('O','SPG','PLD','PSA','AVB','EQR','VTR','WELL','KIM','FRT','NNN','MAA','ARE','IRM'),
               'Equity REITs',
               'All other dividend payers') AS category,
       count() AS company_count,
       round(quantileDeterministic(0.5)(toFloat64(dividend_yield * price / earnings_per_share) * 100,
                                        cityHash64(ticker)), 1) AS median_eps_payout_pct,
       round(100 * countIf(dividend_yield * price > earnings_per_share) / count(), 1) AS pct_paying_over_earnings
FROM global_markets.stocks_ratios
WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
  AND price >= 5
  AND market_cap >= 1000000000
  AND dividend_yield > 0
  AND earnings_per_share > 0
GROUP BY category
ORDER BY category
More from this analysisREIT Payout Ratio: FFO vs EPS Explained
Large equity REITs: dividend as a percent of earnings per share, latest snapshot ranking 11×3 → Realty Income (O): monthly dividend per share, January 2021 to the latest declared payment series 64×3 → Year-end dividend rate against twelve months earlier: how many large REITs raised or lowered table 9×5 → Monthly payers in the dividend record, by completed calendar year ranking 21×3 → See all 2,170 queries →
$