Dividends per share for 2026: calendar year vs Microsoft's July-to-June fiscal year

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.

SELECT
    tupleElement(slice, 1) AS basis,
    tupleElement(slice, 2) AS payments,
    tupleElement(slice, 3) AS dividends_per_share,
    tupleElement(slice, 4) AS ex_dates_counted
FROM
(
    SELECT arrayJoin([
        ('Calendar 2026',
         countIf(in_calendar_2026),
         round(sumIf(dividend, in_calendar_2026), 2),
         'ex-dates Jan 1 to Dec 31, 2026'),
        ('Fiscal 2026',
         countIf(in_fiscal_2026),
         round(sumIf(dividend, in_fiscal_2026), 2),
         'ex-dates Jul 1, 2025 to Jun 30, 2026')
    ]) AS slice
    FROM
    (
        SELECT
            ex_dividend_date,
            toFloat64(any(cash_amount))                                                              AS dividend,
            ex_dividend_date >= toDate('2026-01-01') AND ex_dividend_date < toDate('2027-01-01')     AS in_calendar_2026,
            ex_dividend_date >= toDate('2025-07-01') AND ex_dividend_date < toDate('2026-07-01')     AS in_fiscal_2026
        FROM global_markets.stocks_dividends
        WHERE ticker = 'MSFT'
          AND ex_dividend_date >= toDate('2025-07-01')
          AND ex_dividend_date <  toDate('2027-01-01')
        GROUP BY ex_dividend_date
    )
)
ORDER BY basis