Working Capital Gap (opens a tool overlay)
What cash gap could your next quarter create?
Funding and finance
How many days is your cash tied up in trading?
Your business. Your figures.
Turn stock, customer balances and supplier balances into days. Use averages from the same twelve month period so that the components describe the same business cycle.
The time between paying for stock and collecting from customers can explain why a trading business needs cash even while reporting profit. The cash conversion cycle puts three parts of that timing into days: inventory holding, customer collection and supplier payment. It is useful for locating where money remains tied up. The aim is to understand operating behaviour, not to minimise every number without considering service, resilience or commercial relationships.
Use average balances from the same twelve month period as the revenue and cost of goods sold. A single year end balance can be misleading when trading is seasonal or a large payment falls immediately before the reporting date. Monthly averages are often a more informative starting point if the underlying records are reliable. Keep inventory valued consistently with the cost of goods sold, and use receivables and payables that correspond to the activity being measured.
Clarify what sits inside each balance. An old disputed customer debt behaves differently from an invoice still within agreed terms. Obsolete stock behaves differently from material deliberately held to protect a long supply lead time. A supplier balance may include overdue amounts that cannot safely be treated as continuing credit. The calculator turns values into comparable time measures, but those categories need investigation before the business chooses a response.
Inventory days equal average inventory divided by annual cost of goods sold, multiplied by 365. Receivable days use annual revenue as the denominator, while payable days use annual cost of goods sold. The cash cycle adds inventory and receivable days, then subtracts payable days. Different denominators are intentional because inventory and supplier balances are linked to cost, whereas customer balances are linked to selling value.
A positive result suggests that the entered operating cycle consumes funding for that number of days on average. A negative result suggests that supplier terms currently cover more days than inventory and receivables consume. Neither result is automatically good or bad. A negative cycle can be commercially strong when terms are sustainable, but it can also conceal overdue suppliers. A positive cycle may reflect a viable model that simply requires planned working capital.
The cash release illustration selects the larger of inventory days and receivable days and reduces it by up to fifteen days. It converts those days back into a money amount using the corresponding annual denominator. This is a simple scenario, not a forecast. Review the specific stock or collection process before assuming that the indicated days can be removed. Faster collection may require clearer invoices, while lower stock may require improved ordering and supply reliability.
This is a transparent planning calculation or self assessment, not a sector benchmark, professional valuation or a prediction of an outcome.
The cash release scenario changes the larger of inventory or receivable days by up to fifteen days. It is an illustration, not a forecast or an instruction to delay suppliers.
The model simplifies a varied year into averages. It does not identify the week of a cash shortfall, distinguish all credit sales from cash sales or model every purchasing pattern. Annual revenue and cost of goods sold must both be positive for the ratios to be meaningful. A business without inventory can enter zero inventory, but should still check whether the remaining measures fit its operating model.
Do not treat extending supplier payment as a free improvement. Changes to terms must be agreed and may affect pricing, availability or trust. Do not interpret a potential release as additional profit. Collecting an existing receivable changes the form of an asset into cash; it does not create a second sale. Check a dated cash forecast before using an estimated release to support a commitment.
Read the full limitations or explore how Ayodeji approaches this work.
Customers owe selling value, while stock and most trade suppliers are recorded on a cost basis. Using the relevant denominator helps keep each ratio consistent.
Inspect the largest component and its age profile. Separate healthy operating balances from disputed debts, obsolete inventory and overdue suppliers before choosing a corrective action.