Working Capital Calculator

Money, not a ratio — and why that matters

Working capital and the current ratio are built from the identical two numbers. One subtracts, the other divides. They can never disagree: the ratio clears 1 at exactly the moment working capital clears zero.

So why keep both? Because a ratio is scale-free and money is not, and each is the right tool for a different question.

A current ratio of 2.0 means the same thing at every size, which makes it good for comparing companies. It also means it cannot tell you whether the cover is enough, because “enough” depends entirely on how much cash the business burns through in a month.

Working capital of 300,000 is a fact about a specific business. At 2m of annual cost of sales it is around eight weeks of trading — comfortable. At 20m it is under six days, which is not a buffer at all. The identical figure describes safety in one company and fragility in another, and only the money version exposes that.

The practical rule: use the ratio to compare, use the money to decide. And when the decision is about funding, use the requirement below rather than either.

What your cash cycle requires

The balance sheet says what you have. It does not say what you need. That second number comes from the cash conversion cycle, and it is a one-line calculation:

Requirement = cycle days × daily cost of sales. A business with a 40-day cycle and 1,825,000 of annual cost of sales consumes 5,000 a day, so 40 days of it is 200,000 tied up permanently in the gap between paying suppliers and being paid by customers.

Set that against the working capital actually held and you get the number that matters. Holding 300,000 against a 200,000 requirement is a genuine 100,000 of slack. Holding 150,000 against the same requirement is a 50,000 gap that has to be funded from somewhere — an overdraft, a facility, or an owner — even though the working capital is positive and the current ratio looks fine.

This is the failure mode the ratios cannot see. Every liquidity ratio on the balance sheet compares assets to liabilities. None of them knows how fast the business trades, and trading speed is precisely what determines how much capital the cycle swallows.

It also explains the most common cash surprise in a growing business. Growth increases the requirement in direct proportion — double the sales at the same cycle length and you need double the working capital — while the profit that funds it arrives later. A profitable company can run out of cash by growing, and this is the arithmetic of how.

There are only two levers: hold more capital, or shorten the cycle. Shortening it is usually cheaper, and the DSO, DIO and DPO pages each cover one of the three ways to do it.

What growth costs before it pays

Working capital scales with revenue. That single fact is why profitable companies run out of money, and it is invisible in every ratio built on this balance sheet.

The requirement above is a fraction of a year’s sales. Raise sales and the requirement rises in the same proportion, before any of the new revenue has been collected. A business operating on a sixty-day cash cycle ties up roughly two months of every increment the moment it grows — that money buys the inventory and funds the customer credit, and it comes back only after the cycle completes.

So growth is a cash outflow first and a cash inflow second, and the faster the growth the wider the gap between them. A company doubling revenue on a long cycle funds the entire increase up front, which is why the crunch usually arrives in the best year rather than the worst one.

The lever is the cycle, not the sales. Cutting days sales outstanding or days inventory outstanding reduces what every future increment requires, permanently. Growing without touching the cash conversion cycle buys the same problem at a larger size.

Negative working capital is a model

Negative working capital means current liabilities exceed current assets. For a manufacturer that is usually a funding gap. For a supermarket it is the business plan.

A grocer takes cash at the till, holds stock for a few weeks, and pays suppliers in 30 to 60 days. Money arrives before it leaves. Every new store is financed by the trade creditors it generates rather than by capital raised in advance, which is why such businesses can expand quickly without proportionate funding. Marketplaces and subscription businesses that bill up front share the shape.

The corresponding risk is specific and worth stating plainly: the mechanism reverses when growth stops. Payables only keep funding you while new ones keep arriving. If volume flattens or falls, the existing payables still fall due but fewer replace them, and the same structure that released cash on the way up demands it back on the way down. A business funded this way discovers its working-capital requirement at the worst possible moment.

So negative is not a verdict. It is a question about which model you are running, and whether the growth it depends on is durable.

The movement, not the level, is what hits cash flow

Everything above treats working capital as a balance. On the cash flow statement it appears as something else entirely: a change, and the sign of that change surprises people every time.

An increase in working capital is a cash OUTFLOW. It looks like the business got stronger — more stock, more customers owing money — and it is subtracted from profit in arriving at operating cash flow. Money went into inventory and receivables and has not come back yet.

A decrease is an inflow, which is why a business in trouble can post excellent operating cash flow for a quarter or two: it stops buying stock and chases its debtors hard, working capital falls, and the release shows up as cash generated. That is a one-off unwinding, not earnings, and it cannot repeat.

The same mechanism explains the most common cash surprise in a healthy company. Growth increases the requirement in direct proportion — double the sales at the same cycle length and you need double the working capital — while the profit that funds it arrives later. A profitable business can run out of cash purely by growing, and the arithmetic of it is the section above.

So read the level against the requirement, and read the movement against profit. A period where profit rose and operating cash flow fell is usually a working-capital story, and it is worth finding out which of the three components caused it — receivables, inventory, or payables.

What working capital cannot tell you

Three limits.

It inherits every weakness of the ratios. Same period-end snapshot, same twelve-month bucket with no sense of timing, same indifference to whether inventory will actually sell. Settling payables at period end changes the ratio but leaves working capital unchanged — which is one genuine advantage the money figure has.

More is not better. Working capital far above the requirement is capital doing nothing: stock that could be smaller, debtors who could pay sooner, cash that could be invested. The target is sufficiency plus a margin, not maximisation.

The requirement calculation assumes stable trading. Cycle days times daily cost is a steady-state figure. A seasonal business needs enough for its peak, not its average, and a business whose cycle is lengthening needs to fund the change as well as the level.

Sources and methodology

The classification rules behind both sides of the subtraction.

• IAS 1 Presentation of Financial Statements — the current/non-current split that defines both halves of working capital
• SEC Regulation S-X §210.5-02 — the prescribed balance-sheet captions this tool sums
• IRS Form 1125-A, Cost of Goods Sold — the cost figure the requirement calculation divides into days
• ACCA Financial Management technical articles — working-capital management and the funding gap
• How we calculate — methodology

Method. The requirement uses the same day-valuing function as the cash conversion cycle calculator, on a 365-day basis, so the two pages cannot report different figures for the same cycle. The equivalence between positive working capital and a current ratio above 1 is asserted as an identity rather than assumed, across five thousand generated balance sheets and at the boundary where both are exactly zero and one. The engine is verified on every change against 72 assertions shared with the rest of the liquidity cluster. The count and the per-case breakdown are published on the formula verification page.

Related calculators

The flow view, and the ratios this is the money version of:

More in Business, or browse all calculators.