growth_horizons

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
    annual AS
    (
        SELECT
            div_year,
            annual_dividend,
            max(div_year) OVER () AS latest_year
        FROM
        (
            SELECT
                toYear(ex_dividend_date) AS div_year,
                round(max(toFloat64(cash_amount)) * 4, 4) AS annual_dividend
            FROM global_markets.stocks_dividends
            WHERE ticker = 'JNJ'
              AND frequency = 4
              AND ex_dividend_date >= '2000-01-01'
              AND ex_dividend_date <  '2027-01-01'
            GROUP BY div_year
        )
    )
SELECT
    concat(toString(e.div_year - b.div_year), '-year') AS horizon,
    toString(b.div_year) AS measured_from,
    b.annual_dividend AS start_annual_dividend,
    e.annual_dividend AS latest_annual_dividend,
    round((pow(e.annual_dividend / b.annual_dividend, 1.0 / (e.div_year - b.div_year)) - 1) * 100, 2) AS growth_cagr_pct,
    round(e.annual_dividend / b.annual_dividend, 2) AS growth_multiple
FROM annual AS e
CROSS JOIN annual AS b
WHERE e.div_year = e.latest_year
  AND (e.div_year - b.div_year) IN (5, 10, 20)
ORDER BY e.div_year - b.div_year