Cash Flow Adequacy Ratio Calculator

A company can report a profit, pay its dividend, replace its equipment and repay its loans, and still be quietly funding part of that list from new borrowing. The giveaway is a simple coverage test: did operating cash flow, on its own, cover its fixed commitments for the period?

This cash flow adequacy ratio calculator runs that test. Enter operating cash flow and the three commitments it must cover, debt repaid, fixed assets purchased and dividends paid, and you get the ratio, a plain verdict, and the dollar surplus or shortfall that turns an abstract ratio into a funding decision.

Quick Answer

How to use the cash flow adequacy ratio calculator

Take all four figures from the same period of the same company's cash flow statement. Operating cash flow is the net cash provided by operating activities. Long-term debt repaid is principal only, not interest. Fixed assets purchased is the capex line in investing activities. Dividends paid sits in financing activities. Press Calculate Ratio and the tool returns the ratio, a plain verdict against the 1.0 and 1.5 bands, the dollar surplus or shortfall behind the ratio, and the mix of commitments, so you can see which outflow is doing the damage.

The card is pre-filled with the textbook worked example below, so every number in this article can be reproduced before you enter your own company. If one of the three outflows does not apply, enter 0 for it rather than leaving it blank; the tool needs a figure for each, and zero is a valid one. Only the total matters for the denominator, but the mix is reported because a ratio dragged down by growth capex is a different story from one dragged down by dividends.

The adequacy formula and the 1.0 line

A ratio of 1.0 means operating cash exactly covered the three commitments, with nothing left over. Between 1.0 and 1.5 the business self-funds with a modest cushion, which is where most analysts are comfortable. Above 1.5 coverage is strong, though a persistently very high ratio can hint at under-investment: a company that never buys assets or rewards shareholders will post beautiful adequacy and a shrinking future. Below 1.0 the period's commitments were part-funded from somewhere else: cash reserves, new borrowing or asset sales. One year of that is common around a big build. A habit of it is how leverage creeps up.

Worked example, checked line by line

A company reports $850,000 of operating cash flow. In the same year it repaid $225,000 of long-term debt, spent $250,000 on fixed assets and paid $125,000 of dividends. Commitments total $600,000, the ratio is 1.42, and the surplus after commitments is $250,000. The commitment mix is debt 37.5%, capex 41.7%, dividends 20.8%, so investment, not the dividend, is the largest claim on operating cash.

Now stress it. Hold the commitments at $600,000 and cut operating cash flow to $480,000. The ratio falls to 0.80 and the tool reports a shortfall of $120,000 to reach full coverage. That second line is the one a lender quotes back to you, because it names the exact amount that must come from reserves, new debt or deferred spending. The standard textbook presentation of this ratio, such as the one at Wall Street Prep's cash flow adequacy ratio guide, uses the same construction, operating cash flow over the sum of capex, mandatory debt repayment and dividends, which is why the inputs must be statement figures and not estimates.

Where each input lives on the cash flow statement

Half the wrong adequacy ratios in the wild are really wrong inputs. Operating cash flow is a cash flow statement figure, not net income: net income carries non-cash charges such as depreciation and ignores working capital movement, so a profitable company can post a weak adequacy ratio and a loss-making one can post a strong year on collections. The SEC's own teaching material makes the same distinction: as the SEC Beginners' Guide to Financial Statements puts it, an income statement tells you whether a company made a profit, while a cash flow statement tells you whether it generated cash, split into operating, investing and financing activities.

Debt repaid means principal on long-term borrowings, taken from financing activities; interest is an operating cost and stays out of this denominator. Capex is the purchases of property, plant and equipment line in investing activities; routine repairs expensed through the income statement are not capex. Dividends paid covers cash actually paid in the period, common and preferred, not dividends declared but unpaid. XPLAIND's long-running reference on the ratio, XPLAIND: Cash Flow Adequacy Ratio, shows with five years of General Electric data how violently the ratio can swing when debt repayment spikes, which is the practical case for averaging or trending several periods instead of judging one.

Three cash flow questions, three different tools

Readers arrive with three different questions that share two words. This calculator answers the coverage question: can operations pay for the commitments? If your question is what each share of the company generates in cash, with valuation and dividend checks attached, use the cash flow per share calculator. If your question is whether the cash result matched the plan, use the cash flow variance calculator, which compares actual cash flow with the forecast in dollars and percent. And if you need the operating cash flow figure itself built up from simpler parts, the base cash flow calculator is the starting point. A weakening adequacy trend often shows up first as a rising cash burn, which the burn rate calculator quantifies for younger companies.

What competing calculators miss

The striking fact about this ratio is how few working tools exist for it. The major finance education sites teach the formula in articles and stop there, leaving readers to build a spreadsheet. The dedicated tools that do exist tend to return the bare ratio and a one-line label.

Miss 1: no dollar gap. A ratio of 0.80 does not tell a finance manager what to do next. This tool converts the ratio back into money: the exact surplus when coverage holds, or the exact shortfall that must be funded when it does not. That figure is the agenda for the conversation with the bank.

Miss 2: no commitment mix. Two companies at 1.10 can be in opposite situations, one investing heavily, one paying out heavily. Reporting the debt, capex and dividend shares of the denominator, as this tool does, separates growth pressure from payout pressure at a glance.

Miss 3: no warning about single-period capex. Capex is lumpy: a factory year crushes the ratio, a quiet year flatters it. Competitor pages rarely say this out loud. Judge adequacy on a three to five year view, exactly as the worked example's stress case shows a single weak year in context.

Frequently Asked Questions

Add This Calculator to Your Website

References