Altria free cash flow versus dividends paid, 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.

SELECT
    fiscal_year_label,
    round(ocf / 1e9, 2)             AS operating_cash_flow_bn,
    round((ocf - capex) / 1e9, 2)   AS free_cash_flow_bn,
    round(divs / 1e9, 2)            AS dividends_paid_bn,
    round((ocf - capex) / divs, 2)  AS fcf_coverage_ratio
FROM
(
    SELECT
        toString(fiscal_year)                                                   AS fiscal_year_label,
        toFloat64(ifNull(any(net_cash_from_operating_activities), 0))           AS ocf,
        abs(toFloat64(ifNull(any(purchase_of_property_plant_and_equipment), 0))) AS capex,
        abs(toFloat64(ifNull(any(dividends), 0)))                               AS divs
    FROM global_markets.stocks_cash_flow_statements
    WHERE has(tickers, 'MO')
      AND timeframe = 'annual'
      AND toInt32OrZero(toString(fiscal_year)) >= 2020
    GROUP BY fiscal_year_label
    HAVING divs > 0
       AND ocf > 0
)
ORDER BY fiscal_year_label