szenarien

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH abbv_ttm AS
(
    SELECT sum(amount) AS gross_usd
    FROM
    (
        SELECT max(toFloat64(cash_amount)) AS amount
        FROM global_markets.stocks_dividends
        WHERE ticker = 'ABBV'
          AND currency = 'USD'
          AND ex_dividend_date >= '2025-10-01'
          AND ex_dividend_date <  '2026-10-01'
        GROUP BY ex_dividend_date
    )
)
SELECT
    s.1                                           AS label,
    round(gross_usd, 2)                           AS gross_usd,
    round(gross_usd * s.2, 2)                     AS us_tax_usd,
    round(gross_usd * s.3, 2)                     AS de_tax_usd,
    round(gross_usd * (1 - s.2 - s.3), 2)         AS net_usd,
    round(100 * (s.2 + s.3), 3)                   AS total_tax_pct
FROM
(
    SELECT
        gross_usd,
        arrayJoin([
            ('Mit W-8BEN: 15 % US, 10 % KapESt, 0,55 % Soli', 0.15, 0.1055),
            ('Mit Kirchensteuer 9 %: Sonderberechnung nach Anrechnung', 0.15, 0.112),
            ('Deutsche Dividende ohne Quellensteuer: 25 % plus Soli', 0.0, 0.26375),
            ('Ohne W-8BEN: 30 % US, Anrechnung auf 15 % begrenzt', 0.30, 0.1055),
            ('Der Irrtum: 15 % US plus volle 26,375 % deutsche Steuer', 0.15, 0.26375)
        ]) AS s
    FROM abbv_ttm
)
ORDER BY total_tax_pct