PEP Dividend 2026: Ex-Dates and the Raise

SELECT
    toString(ex_date)                                AS ex_dividend_date,
    formatDateTime(ex_date, '%b %e, %Y')             AS ex_date_label,
    if(min(src) = 0, 'confirmed', 'scheduled')       AS status,
    dateDiff('day', today(), ex_date)                AS days_away,
    formatDateTime(argMin(pay_dt, src), '%b %e, %Y') AS payment_date,
    round(argMin(amt, src), 4)                       AS cash_amount
FROM
(
    SELECT
        0                AS src,
        ex_dividend_date AS ex_date,
        pay_date         AS pay_dt,
        cash_amount      AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= today()
    UNION ALL
    SELECT
        1,
        addYears(ex_dividend_date, 1),
        addYears(pay_date, 1),
        (
            SELECT max(cash_amount)
            FROM global_markets.stocks_dividends
            WHERE ticker = 'PEP'
              AND ex_dividend_date >= today() - 400
        )
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= today() - 400
      AND addYears(ex_dividend_date, 1) >= today()
)
GROUP BY ex_date
ORDER BY ex_date
LIMIT 4

WITH
(
    SELECT toFloat64(max(cash_amount))
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND toYear(ex_dividend_date) = 2026
      AND toQuarter(ex_dividend_date) = 1
) AS q1_rate
SELECT
    toString(argMin(ex_date, src))                              AS ex_dividend_date,
    concat('Q', toString(q), ' 2026')                           AS quarter,
    if(min(src) = 0, 'confirmed', 'scheduled')                  AS status,
    if(min(src) = 0 AND argMin(decl_date, src) > toDate('2000-01-01'),
       formatDateTime(argMin(decl_date, src), '%b %e, %Y'),
       'not yet declared')                                      AS declared,
    formatDateTime(argMin(rec_date, src), '%b %e, %Y')          AS record_date,
    formatDateTime(argMin(pay_dt, src), '%b %e, %Y')            AS payment_date,
    round(argMin(amt, src), 4)                                  AS cash_amount,
    round(100 * (toFloat64(argMin(amt, src)) / q1_rate - 1), 1) AS change_vs_q1_pct
FROM
(
    SELECT
        0                                              AS src,
        toQuarter(ex_dividend_date)                    AS q,
        ex_dividend_date                               AS ex_date,
        ifNull(declaration_date, toDate('1970-01-01')) AS decl_date,
        record_date                                    AS rec_date,
        pay_date                                       AS pay_dt,
        cash_amount                                    AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2027-01-01'
    UNION ALL
    SELECT
        1,
        toQuarter(ex_dividend_date),
        addYears(ex_dividend_date, 1),
        toDate('1970-01-01'),
        addYears(record_date, 1),
        addYears(pay_date, 1),
        (
            SELECT max(cash_amount)
            FROM global_markets.stocks_dividends
            WHERE ticker = 'PEP'
              AND ex_dividend_date >= '2026-01-01'
              AND ex_dividend_date <  '2027-01-01'
        )
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= '2025-01-01'
      AND ex_dividend_date <  '2026-01-01'
)
GROUP BY q
ORDER BY q

WITH
(
    SELECT toFloat64(4 * max(cash_amount))
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2027-01-01'
) AS indicated_rate
SELECT
    countDistinct(date)                                             AS sessions,
    formatDateTime(max(date), '%b %e, %Y')                          AS latest_session,
    round(min(low), 2)                                              AS year_low,
    round(max(high), 2)                                             AS year_high,
    round(argMax(close, date), 2)                                   AS latest_close,
    round(indicated_rate, 4)                                        AS indicated_annual_rate,
    round(100 * indicated_rate / toFloat64(min(low)), 2)            AS yield_at_year_low_pct,
    round(100 * indicated_rate / toFloat64(max(high)), 2)           AS yield_at_year_high_pct,
    round(100 * indicated_rate / toFloat64(argMax(close, date)), 2) AS yield_at_latest_close_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'PEP'
  AND date >= '2026-01-01'
  AND date <  '2027-01-01'

WITH
(
    SELECT toFloat64(4 * max(cash_amount))
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2027-01-01'
) AS indicated_rate
SELECT
    formatDateTime(toStartOfMonth(date), '%Y-%m')          AS month,
    round(min(low), 2)                                     AS low_price,
    round(max(high), 2)                                    AS high_price,
    round(100 * indicated_rate / toFloat64(avg(close)), 2) AS yield_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'PEP'
  AND date >= '2026-01-01'
  AND date <  '2027-01-01'
GROUP BY month
ORDER BY month

SELECT
    toString(y)                                                    AS year,
    round(total, 4)                                                AS dividends_per_share,
    round(100 * (toFloat64(total) / toFloat64(prev_total) - 1), 1) AS yoy_growth_pct,
    basis
FROM
(
    SELECT
        y,
        total,
        basis,
        any(total) OVER (ORDER BY y ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prev_total
    FROM
    (
        SELECT
            y,
            sum(quarter_amount)                                     AS total,
            if(max(best_src) = 0, 'confirmed', 'includes scheduled') AS basis
        FROM
        (
            SELECT
                y,
                q,
                argMin(amt, src) AS quarter_amount,
                min(src)         AS best_src
            FROM
            (
                SELECT
                    0                           AS src,
                    toYear(ex_dividend_date)    AS y,
                    toQuarter(ex_dividend_date) AS q,
                    cash_amount                 AS amt
                FROM global_markets.stocks_dividends
                WHERE ticker = 'PEP'
                  AND ex_dividend_date >= '2016-01-01'
                  AND ex_dividend_date <  '2027-01-01'
                UNION ALL
                SELECT
                    1,
                    toYear(ex_dividend_date) + 1,
                    toQuarter(ex_dividend_date),
                    (
                        SELECT max(cash_amount)
                        FROM global_markets.stocks_dividends
                        WHERE ticker = 'PEP'
                          AND ex_dividend_date >= '2026-01-01'
                          AND ex_dividend_date <  '2027-01-01'
                    )
                FROM global_markets.stocks_dividends
                WHERE ticker = 'PEP'
                  AND ex_dividend_date >= '2025-01-01'
                  AND ex_dividend_date <  '2026-01-01'
            )
            GROUP BY y, q
        )
        GROUP BY y
    )
)
WHERE prev_total > 0
  AND y >= 2017
ORDER BY y