net_by_scenario
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-28, from us-dividend-taxes-for-ukrainian-investors.
| scenario | gross_100sh_usd | us_withheld_usd | ua_tax_usd | net_usd | net_pct |
|---|---|---|---|---|---|
| W-8BEN, залік підтверджено | 210 | 31.5 | 10.5 | 168 | 80 |
| W-8BEN, без довідки | 210 | 31.5 | 29.4 | 149.1 | 71 |
| Без W-8BEN, залік підтверджено | 210 | 63 | 10.5 | 136.5 | 65 |
| Без W-8BEN, без довідки | 210 | 63 | 29.4 | 117.6 | 56 |
- Rows × columns
- 4 × 6
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
scenario |
text | 4 distinct values | |
gross_100sh_usd |
number | every row is 210 | US dollars |
us_withheld_usd |
number | 31.5 to 63 | US dollars |
ua_tax_usd |
number | 10.5 to 29.4 | US dollars |
net_usd |
number | 117.6 to 168 | US dollars |
net_pct |
number | 56 to 80 | percent |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
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
(
SELECT round(sum(cash_amount) * 100, 2)
FROM
(
SELECT id, any(toFloat64(cash_amount)) AS cash_amount
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
AND currency = 'USD'
AND ex_dividend_date >= today() - 365
AND ex_dividend_date < today()
GROUP BY id
)
) AS gross_100sh_usd
SELECT
tupleElement(sc, 1) AS scenario,
gross_100sh_usd,
round(gross_100sh_usd * tupleElement(sc, 2), 2) AS us_withheld_usd,
round(gross_100sh_usd * tupleElement(sc, 3), 2) AS ua_tax_usd,
round(gross_100sh_usd * (1 - tupleElement(sc, 2) - tupleElement(sc, 3)), 2) AS net_usd,
round(100 * (1 - tupleElement(sc, 2) - tupleElement(sc, 3)), 1) AS net_pct
FROM
(
SELECT arrayJoin([
('W-8BEN, залік підтверджено', 0.15, 0.05),
('W-8BEN, без довідки', 0.15, 0.14),
('Без W-8BEN, залік підтверджено', 0.30, 0.05),
('Без W-8BEN, без довідки', 0.30, 0.14)
]) AS sc
)
ORDER BY net_usd DESC
Працюйте з цими даними у своєму ШІ-асистенті
Відкривається готовим до запитів, з даними цієї сторінки. Безкоштовно, без акаунта.