Working capital, the working capital ratio, operating working capital, days of working capital and the cash conversion cycle, from the numbers on your balance sheet. Every formula is shown below the result.
Use any currency and keep it the same throughout. Only the first two boxes are required.
Working capital = current assets − current liabilities. Example: 1,250,000 − 830,000 = 420,000.
Working capital ratio (current ratio) = current assets ÷ current liabilities. Example: 1,250,000 ÷ 830,000 = 1.51.
Operating (trade) working capital = receivables + inventory − trade payables. Example: 480,000 + 310,000 − 390,000 = 400,000. This is the part of working capital that collections, stock and supplier terms can change; cash and borrowings are left out.
Days of working capital = working capital ÷ revenue × days in the period. Example: 420,000 ÷ 4,800,000 × 365 = 31.9 days of sales tied up.
Working capital as a percentage of revenue = working capital ÷ revenue × 100. Useful for comparing years or businesses of different sizes.
Cash conversion cycle = DSO + DIO − DPO, where DSO = receivables ÷ revenue × days, DIO = inventory ÷ cost of sales × days, and DPO = payables ÷ cost of sales × days. It is the number of days between paying suppliers and collecting from customers.
Average working capital = (opening working capital + closing working capital) ÷ 2. Use it when a ratio compares a balance-sheet figure with a full-period figure such as revenue.
What counts as "good" depends on the industry. A supermarket can run negative working capital because customers pay before suppliers are paid; a manufacturer usually cannot. Compare against your own prior periods first, then against businesses with the same cycle.
Ten habits that bring cash in sooner. Free. Unsubscribe any time — see our privacy policy.
The Cash Flow Forecasting & Liquidity Control System tests every forecast week against your minimum cash buffer and lending covenants, and flags a breach before it lands.
See the Cash Flow System