cagr

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 quarterly AS
(
    SELECT
        ex_dividend_date            AS ex_date,
        toFloat64(max(cash_amount)) AS rate
    FROM global_markets.stocks_dividends
    WHERE ticker = 'XOM'
      AND frequency = 4
      AND ex_dividend_date >= '2000-01-01'
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
),
series AS
(
    SELECT
        groupArray(ex_date) AS ds,
        groupArray(rate)    AS rs
    FROM
    (
        SELECT ex_date, rate
        FROM quarterly
        ORDER BY ex_date ASC
    )
),
spans AS
(
    SELECT
        ds,
        rs,
        yrs,
        rs[length(rs)] AS end_rate,
        greatest(arrayFirstIndex(d -> d >= addYears(ds[length(ds)], -1 * toInt32(yrs)), ds), 1) AS idx
    FROM series
    ARRAY JOIN [5, 10, 20] AS yrs
)
SELECT
    concat(toString(yrs), '-year span')                            AS horizon,
    formatDateTime(ds[idx], '%b %Y')                               AS start_ex_label,
    round(rs[idx], 4)                                              AS start_quarterly_usd,
    round(end_rate, 4)                                             AS latest_quarterly_usd,
    round((pow(end_rate / rs[idx], 1.0 / yrs) - 1) * 100, 2)       AS cagr_pct,
    round(end_rate / rs[idx], 2)                                   AS growth_multiple
FROM spans
ORDER BY yrs ASC