nisa — 4 answered market questions

Trailing 12-month dividend yield, gross and net of US withholding

most recentas of 2026-10-04 ranking 8×4read in context →

Trailing 12-month dividend yield, gross and net of US withholding — 8 rows by 4 columns, computed 2026-10-04 from US exchange, SIP and OPRA data.
ticker	gross_yield_pct	after_treaty_yield_pct	no_w8ben_yield_pct
PEP	4.61	4.15	3.23
CVX	3.41	3.07	2.39
PG	2.96	2.66	2.07
XOM	2.51	2.26	1.76
KO	2.45	2.21	1.72
JNJ	2.06	1.86	1.44
MSFT	0.7	0.63	0.49
AAPL	0.32	0.29	0.22

the exact SQL behind every number

SELECT
    d.ticker                                        AS ticker,
    round(d.ttm_usd / p.last_close * 100, 2)        AS gross_yield_pct,
    round(d.ttm_usd * 0.90 / p.last_close * 100, 2) AS after_treaty_yield_pct,
    round(d.ttm_usd * 0.70 / p.last_close * 100, 2) AS no_w8ben_yield_pct
FROM
(
    SELECT
        ticker,
        sum(cash_amount) AS ttm_usd
    FROM
    (
        SELECT
            ticker,
            ex_dividend_date,
            max(toFloat64(cash_amount)) AS cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'PEP')
          AND ticker NOT IN ('SPCX')
          AND ex_dividend_date > today() - 365
          AND ex_dividend_date <= today()
        GROUP BY ticker, ex_dividend_date
    )
    GROUP BY ticker
) AS d
INNER JOIN
(
    SELECT
        ticker,
        argMax(toFloat64(close), date) AS last_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'PEP')
      AND date >= today() - 15
    GROUP BY ticker
) AS p ON d.ticker = p.ticker
ORDER BY gross_yield_pct DESC

More from this analysisUS Dividend Tax for Japanese Investors

Apple's quarterly dividend, gross and net of US withholding series 15×5 → What 10% and 30% remove from one quarterly dividend, per share series 8×5 → One Apple dividend per share, in yen, across four account setups table 4×6 → Coca-Cola quarterly dividend since 2021: gross, net at 15%, net at 30% series 23×6 → See all 3,022 queries →