← Back to Blog
Workflow · November 2026 · 8 min read

Is the Dividend Actually Covered? A Free-Cash-Flow Check in One Prompt

M
Michael · Builder & owner of Stocklake
It yields 6%. Is the dividend actually covered? FCF ÷ DIVIDENDS, LATEST FY 1.0x 1.71 1.56 0.93 0.91 0.60 VZ JNJ PFE NKE KO
Free cash flow divided by cash dividends paid, latest fiscal year, computed from each company's reported cash flow statement (Nike's fiscal year ends in May)

A dividend yield tells you what a company pays. It doesn't tell you whether the business generated the cash to pay it. Verizon and Pfizer both yield about 6%, and on that number alone they look the same. Over the last four years their cash flow tells two different stories.

The check that answers the question is simple: take free cash flow (operating cash flow minus capital expenditure) and divide it by the cash dividends actually paid. Above 1.0x, the dividend came out of that year's free cash flow. Below 1.0x, part of it came from somewhere else: cash on hand, asset sales or new debt. Do that for several years, add the most recent quarters and the debt trend, and you have a much better picture than the yield gives you.

By hand it's tedious. With Stocklake connected, your AI agent (Claude, ChatGPT or another) pulls the reported statement lines and does the arithmetic in one prompt. Below are three prompts I ran on September 27. Every figure is as of Sept 25 and comes from the companies' reported cash flow statements and balance sheets; the ratios are the agent's arithmetic on those lines, not a precomputed field.

What this is, and isn't. This post shows a research workflow: having an assistant read financial statements and compute a ratio for you. It is informational only, not investment advice, and not a recommendation to buy or sell any security. Stocklake doesn't generate trade calls. A coverage ratio below 1.0x for one year is a fact about that year, not a prediction about the dividend.

1. Verizon yields about 6%. Is that covered?

Start with one company and make the assistant show its work.

Prompt
Verizon yields about 6%. Is the dividend covered by free cash flow? Show me the lines you used.

What came back (as of Sept 25)

Illustration: an AI assistant showing Verizon's operating cash flow, capital expenditure, free cash flow and dividends paid for fiscal 2025, with a coverage ratio of 1.71x
Verizon's dividend coverage, with every line it used
What a good answer looks like
  • It shows operating cash flow, capex and dividends paid as separate, dated lines, so you can check the division yourself.
  • It uses cash dividends paid from the cash flow statement, not the yield times a share count.
  • It gives both the fiscal year and the most recent four quarters.

2. Which year slipped, and why?

One year is a snapshot. The useful version of the question is the trend, and when coverage drops, which line moved.

Prompt
Show Nike's dividend coverage for each of the last four fiscal years. Which year slipped, and what changed?
Follow-up
Coca-Cola also dipped below 1.0x in 2024 and 2025. Same story?

What came back (as of Sept 25)

Illustration: an AI assistant showing Nike's free cash flow, dividends paid and coverage for fiscal 2023 through 2026, naming the drop in operating cash flow
Four years of Nike's coverage, and the line that moved
What a good answer looks like
  • It names the year coverage fell below 1.0x and labels fiscal years correctly (Nike's end in May).
  • It separates the causes: falling operating cash flow, rising capex, or a rising dividend.
  • It spots a single line driving the change, like Coca-Cola's working capital, and says the statements show where the cash went while the company's filings explain why.

3. Five dividend payers, one table

Asking for a single table forces the same definition across every company.

Prompt
Put Pfizer, Verizon, Coca-Cola, Johnson & Johnson and Nike side by side: dividend yield, free cash flow ÷ dividends for each of the last four fiscal years and the last four quarters, and net debt then vs now. One table.

What came back (as of Sept 25)

As of Sept 25, 2026YieldFY 2022FY 2023FY 2024FY 2025Last 4 qtrsNet debt, 2022 → 2025
Pfizer6.0%2.90x0.52x1.03x0.93x1.12x$12.1B → $50.4B
Verizon6.0%0.96x1.17x1.68x1.71x1.73x$173.7B → $162.6B
Nike*4.6%2.42x3.05x1.42x0.91x0.91x$1.5B → $2.0B
Coca-Cola2.4%1.25x1.23x0.57x0.60x1.29x$27.5B → $29.7B
Johnson & Johnson2.0%1.47x1.51x1.53x1.56x1.76x$17.4B → $27.8B
*Nike's fiscal years end May 31, so its four columns are FY2023 - FY2026 and its latest fiscal year is also its last four quarters; net debt shown FY2023 → FY2026. Net debt = total debt minus cash and short-term investments. Computed from reported statements, as of Sept 25, 2026.
Illustration: an AI assistant's table comparing dividend yield, four years of free-cash-flow coverage and net debt for Pfizer, Verizon, Coca-Cola, Johnson & Johnson and Nike
Five payers, one definition, one table

A few things the table shows that the yields don't:

What a good answer looks like
  • One definition for every company: operating cash flow minus capex, over cash dividends paid.
  • Fiscal year ends labeled, so a May year isn't compared as if it were December.
  • No ranking by yield alone, and no “safe” or “unsafe” labels: the numbers, and where they came from.

If Pfizer is the one you hold, the Pfizer-vs-peers post runs the same coverage check against Bristol-Myers, Merck and Gilead, alongside margins and forensic scores.

What the ratio doesn't tell you

Free vs Pro for this question

On the free tier you can already ask about a dividend and get the headline numbers. The multi-year check itself runs on the statement lines.

Free
  • Price, dividend rate and yield
  • Ex-dividend and next earnings dates
  • A single trailing free cash flow figure
  • Debt-to-equity and margins
  • Analyst consensus and recent headlines
Pro adds
  • Five years of statements plus quarterlies (the lines this check uses)
  • Forensic scores (Altman Z, Piotroski F, Beneish M)
  • AI summary and news sentiment
  • The full insider transaction list
  • Technical rating and the full indicator breakdown
On free, the assistant can tell you Verizon yields 6.0%. On Pro, it can show you four years of the cash that paid for it.
$20/month
· 5,000 calls/day · every tool, including multi-year financials, insider activity and forensic scores
Free for 7 days, cancel anytime. The free tier stays free: 200 calls a day, and the key never expires.

Tips for better answers

Setting it up

Stocklake works in Claude, ChatGPT and other MCP clients. You add it once, as a custom connector with the URL https://api.stocklake.dev/mcp, and it's then available in every chat, including on web, desktop and mobile where your client supports connectors. You can start on the free tier without a card and add a Pro key later if you want the multi-year statements. The step-by-step setup for each client is in the docs.

Frequently asked questions

Is a coverage ratio below 1.0x a warning sign?

It's a fact about one period, not a verdict. Cash flow swings from year to year with working capital, investment cycles and one-off payments. What matters is the trend over several years, the most recent quarters, and how much debt the company carries while it bridges the gap.

Do I need Pro for this check?

The free tier gives the price, dividend yield and rate, a single trailing free cash flow figure and debt-to-equity. The multi-year check in this post uses the cash flow statement and balance sheet lines. Those lines come from five years of statements plus quarterlies, which is a Pro feature.

Is this investment advice?

No. Stocklake provides market data and research context, including the financial statements companies report. It doesn't generate trade calls, and nothing in this post is a recommendation to buy, sell or short any security.