Coca-Cola dividends paid against earnings and operating cash flow, by 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.

WITH annuals AS
(
    SELECT
        toUInt16(fiscal_year)                                                 AS yr,
        argMax(abs(dividends), (filing_date, period_end))                     AS divs,
        argMax(net_cash_from_operating_activities, (filing_date, period_end)) AS ocf,
        argMax(net_income, (filing_date, period_end))                         AS ni
    FROM global_markets.stocks_cash_flow_statements
    WHERE has(tickers, 'KO')
      AND timeframe = 'annual'
      AND period_end >= toDate('2013-01-01')
    GROUP BY yr
)
SELECT
    yr                                               AS year,
    round(toFloat64(divs) / 1e9, 2)                  AS dividends_paid_bn,
    round(toFloat64(ocf) / 1e9, 2)                   AS operating_cash_flow_bn,
    round(100 * toFloat64(divs) / toFloat64(ni), 1)  AS payout_of_earnings_pct,
    round(100 * toFloat64(divs) / toFloat64(ocf), 1) AS payout_of_operating_cash_pct
FROM annuals
WHERE ni > 0 AND ocf > 0 AND divs > 0
ORDER BY year