Working Capital Analysis: Connecting Liquidity, Operations and Cash Conversion

Define the operating boundary before measuring the requirement

Accounting net working capital supports broad liquidity assessment, but combines operating timing with cash, financial investments, current debt, taxes, dividends and provisions. Operating working capital isolates balances associated with delivery and settlement. Neither perimeter is universally correct independently of purpose. A solvency review and an inventory-release programme answer different questions.

Keep cash and financing balances outside the operating cycle; assess restricted cash separately for availability. Analyse income tax separately from operating drivers, while reconciling VAT and other indirect-tax settlement timing explicitly. Exclude exceptional or non-operating balances unless the decision requires them. Eliminate intercompany items at consolidated level; retain them where an individual entity must fund its own settlement.

Contract assets can represent performed but unbilled work, not an invoice already due. Contract liabilities can provide customer funding. Include them when material to the business model, but do not fold them silently into trade DSO. Treat operating provisions according to their nature and cash settlement: a non-cash charge and its later payment must not enter the bridge twice.

For each account, retain financial-statement classification, operational role, counterparty type, timing behaviour, liquidity consequence and inclusion rationale. Reconcile the selected perimeter back to statements with exclusions visible. Unknown classifications remain exceptions. Do not calculate the working-capital requirement before defining which balances belong to the operating cycle.

Read the Balance Sheet as an operating timetable

Days sales outstanding estimates the collection interval; days inventory outstanding estimates holding time; days payable outstanding estimates supplier-funded time. The cash conversion cycle summarises the net interval requiring finance. This conventional relationship is also described in ACCA’s working-capital guidance. It is a timing approximation, not a verdict on liquidity.

Match receivables and revenue by entity, currency, period, tax basis and credit population. Gross receivables paired with net-of-VAT sales inflate DSO; net receivables after impairment can conceal collection deterioration. Disclose gross and net views and reconcile allowances. Total revenue is only a labelled approximation when credit revenue is unavailable, particularly where cash sales are material.

DIO uses cost rather than selling value. Raw materials, production flows and category-specific stock may need purchases or consumption denominators instead; state that adaptation and its limits. DPO should use relevant credit purchases. Cost of sales is a disclosed proxy only: inventory movements, labour, overhead absorption, depreciation, mix and receipt-versus-consumption timing can make it materially different.

CCC can hide concentrated arrears, impaired stock or seasonal distortions and says nothing directly about funding price or availability. Two equal cycles can contain different operational risks. A negative cycle may be resilient customer funding or dependence on fragile advance-payment and supplier terms. Inspect components before celebrating the aggregate.

Use balances that represent the interval

Closing balances describe a date; revenue and purchases describe an interval. A collection drive, delayed supplier payment, inventory clearance, invoice deferral or concentrated quarter-end shipment can improve the photograph without improving the cycle. Acquisitions and disposals also break endpoint comparability unless scope and flows are aligned.

Use monthly, weekly or daily time averages when available. Transaction-weighted exposure may support a specifically defined duration measure, but is not automatically interchangeable with average outstanding balances. Preserve the sampling convention, missing dates and coverage. More granular figures are not more reliable if their cut-offs or populations disagree.

Compare seasonal peaks with corresponding prior-year periods and use rolling twelve-month flows alongside monthly or weekly balances. Pre-season buying, agricultural and commodity cycles, promotions, year-end procurement, shutdowns and billing calendars all alter the funding profile. Match fiscal intervals rather than mixing monthly balances, year-to-date sales and annual purchases.

Separate the permanent requirement, recurrent seasonal peak and exceptional consumption. A seasonal build is justified only by a demand and depletion plan. Show peak and trough funding, not just the annual average, and test what happens if sales arrive late. The shorter and more volatile the cycle, the less representative a single closing balance becomes.

Balance size and balance quality are different findings

A large balance is not necessarily an opportunity. It may protect essential service, arise from agreed customer terms or finance a dependable supplier relationship. Conversely, a modest concentrated balance can threaten near-term liquidity. Rank cash that can realistically change within the decision horizon, not the largest accounting line.

DSO must lead to invoices and collection evidence

Age invoices against contractual due dates at a common cut-off. Separate not-yet-due, 1–30, 31–60, 61–90 and over-90-day balances, adapting boundaries to terms and purpose. Retain original due dates when renegotiation would otherwise erase deterioration. Reconcile invoices, unapplied receipts, credits and allowances to the ledger before analysing migration.

Disputed, blocked, promised-for-payment, credit-note-pending, factored, insured and related-party amounts are status overlays, not additional ageing buckets. Reconcile their overlaps. A promise is not a receipt; insurance does not establish payment timing; factoring may change funding, recourse and accounting presentation without repairing collection. Track customer concentration within each ageing bucket.

Equal DSO can describe recent, diversified invoices or a few old disputed claims. Test delivery acceptance, billing accuracy, contract terms, dispute ownership and subsequent cash receipts before estimating release. Distinguish unwillingness or inability to pay from a correctable invoice defect. Collection action should follow that mechanism, not an undifferentiated demand for faster payment.

Inventory days do not establish convertibility

Separate raw materials, work in progress, finished and resale goods, packaging, consumables and spares. Overlay strategic safety stock, slow-moving, blocked, obsolete and quality-hold status. Confirm ownership and cut-off for consignment inventory and goods in transit. Do not count the same stock twice because it has both a category and a quality flag.

Identical DIO can support healthy production, seasonal preparation or supply protection, or reveal poor forecasting, minimum-order excess and production imbalance. Define required stock from demand, lead times, service levels, batch sizes and disruption tolerance. The required level is a management assumption to test, not an objectively known subtraction.

Consumption releases cash only when it avoids replenishment; redeployment must avoid another purchase; disposal requires an actual buyer and net proceeds after costs. A write-down lowers carrying value without generating cash. Quality-hold stock needs technical clearance before any sale assumption. Protect essential spares and safety stock until operations approves the service consequence.

Supplier financing is an operating relationship

Compare contractual terms with invoice-weighted actual payment timing, overdue balances, disputes and approval delays. Review discounts, prepayments, related parties, financing arrangements and critical supplier concentration. Reverse factoring requires separate scrutiny of liability classification, settlement and withdrawal risk; its presence is not evidence of better operating discipline.

IASB supplier-finance disclosures address effects on liabilities, cash flows and liquidity risk. An operational review should likewise retain which balances depend on a financing provider and what happens if access disappears. Do not merge that dependence into ordinary negotiated supplier credit.

Higher DPO may preserve cash while sacrificing discounts, increasing prices, damaging trust or risking interruption. Negotiate selectively, compare the full commercial cost and document supplier consent. Paying late without agreement is not a sustainable funding strategy. Supplier financing is an operating relationship, not free capital.

A profitable company with a lengthening cash cycle

All figures below are fictional EUR millions for two comparable 365-day years. Revenue is entirely credit revenue; balances and flows use a consistent tax-exclusive basis, with no VAT in this simplified example. Entity scope and currency are unchanged. Prior EBITDA is exactly current EBITDA divided by 1.2, preserving an 11.81% margin at EUR 8.5m currently.

This simplified trading company has no production capitalisation, write-offs or non-cash stock movements. Current purchases total 54.4: credit purchases 52.4 plus cash purchases 2.0. Opening inventory 10.0 + purchases 54.4 − cost of sales 50.4 = closing inventory 14.0. Using credit purchases alone in that stock reconciliation would incorrectly imply a 2.0 increase.

Collection and stock holding both lengthen while supplier-funded time contracts. This establishes a funding concern, not its cause. Closing receivables of 13.0 would produce 65.90 DSO, rather than 57.79; closing inventory of 14.0 produces 101.39 DIO. Those endpoint measures answer a different question from annual time averages.

Overdue receivables are 6.0 / 13.0 = 46.15%, versus 31.58% previously. Over-60-day exposure is 16.92%, using that threshold for this case only. Two customers account for 4.0, or 30.77%, of receivables and 1.8 of the over-60 balance. The overlap with disputes needs invoice-level review; it is not an additional claim.

Slow-moving inventory is 11.43% of total stock. Operating and seasonal categories explain 2.5 of the 4.0 increase; slow-moving and held stock explain 1.5. The seasonal plan supports intent, not guaranteed depletion. Supplier terms average 60 days on a purchase-weighted basis, actual settled invoices average 64 days, and 0.6 of closing payables is overdue. These measures differ from balance-based DPO. One critical supplier represents 35% of credit purchases.

Separate expansion funding from excess intensity

Prior average trade working capital is 8.2 + 9.6 − 7.5 = 10.3, or 17.17% of revenue. At unchanged aggregate intensity, the 12.0 revenue increase requires 2.06 additional average funding. Current average trade working capital is 16.2, up 5.9; the remaining 3.84 exceeds that simple scale allowance.

A component check holds prior days constant against current flows: receivables become 9.84, inventory 11.52 and payables 9.357143. Expected average trade working capital is 12.002857; actual 16.2 exceeds it by 4.197143. The difference from the aggregate approximation reflects purchases growing faster than revenue. Neither residual proves inefficiency without operational evidence.

Closing trade working capital instead rises from 11.3 to 17.5, or 6.2. Do not substitute the 5.9 average-balance increase into the cash bridge. An illustrative closing decomposition is growth 2.26 + incremental seasonality 0.70 + remaining operating change 3.24 = 6.20. The growth allowance scales all opening trade balances by 20%, including 0.30 of seasonal stock; only the remaining 0.70 of its 1.00 increase is assigned to seasonality. Price/currency, scope and exceptional non-cash items are zero by assumption.

The remaining operating change requires investigation of collection, stock decisions and supplier timing; it is not automatically releasable. In practice, define each bridge component, order interactions once and reconcile the residual. Distinguish structural terms, deliberate protection and new channels from deteriorating execution. Growth becomes dangerous when its funding need is unmeasured, unfunded or increasing faster than activity.

Reconcile earnings to cash, then test availability

Current opening balances equal prior closing balances: receivables 9.5, inventory 10.0 and payables 8.2. Current closes are 13.0, 14.0 and 9.5. Other net operating assets rise from 0.6 to 1.0. No acquisition, translation, impairment or other non-cash movements affect these changes. EBITDA requires no additional non-cash adjustment in this example.

EBITDA is not cash. Here, operating cash before working-capital movements and after cash tax and interest is 7.1; net working-capital absorption of 6.6 leaves 0.5. This analytical convention includes interest in operating cash. Statutory classification and required starting subtotals depend on the applicable reporting requirements; IAS 7 distinguishes operating, investing and financing flows.

With capex of 1.2, the defined cash-after-capex measure is −0.7, not positive free cash generated for discretionary use. Opening cash 4.5 − 0.7 + net new financing 1.2 = closing cash 5.0. Of that balance, 1.5 is restricted, leaving 3.5 available before near-term obligations. Restriction changes availability; it is not another expense or a second cash outflow.

An eight-week forecast requires 4.4 net cash after scheduled receipts, with a 0.5 minimum reserve. Treasury therefore needs 1.4 beyond the unrestricted 3.5. An assumed undrawn committed facility of 2.0 can cover that gap only if draw conditions and covenants permit. Annual scenario savings must not be treated as cash arriving before those obligations.

Model release with timing and operating limits

Scenario A scales revenue, cost of sales and credit purchases by 10% while holding current days fixed: average receivables become 12.54, inventory 15.18 and payables 9.90. Trade working capital rises from 16.20 to 17.82. Other operating balances and seasonal peaks need separate forecasts. Positive earnings do not remove this additional funding requirement.

Scenario B gives DSO 52.79, DIO 91.94, DPO 64.69 and CCC 80.04 days. Its inventory opportunity is conditional on avoiding purchases or realising proceeds, not writing stock down. Selected suppliers must collectively support the portfolio-equivalent two-day extension. The critical supplier receives no assumed extension.

Scenario C produces CCC 53.04 days and a larger spreadsheet release, but may cut required stock, disrupt customers, lose sales, interrupt production, sacrifice discounts and damage supplier trust or reputation. Temporary balance compression is not sustainable improvement. Do not approve it simply because its cash total is larger.

These estimates use unrounded arithmetic and fixed flows, not guaranteed receipts. Invoice timing, VAT, disputes, inventory categories, purchasing changes and execution affect realised cash. Reducing inventory may also reduce purchases and payables; changed customer terms may alter revenue. Rebuild the integrated forecast before adding opportunities. Under the same simplified current-intensity convention, 10% growth with Scenario B days implies 15.204110 average trade funding: only 0.995890 below today, not a simultaneous 2.378082 release plus unfunded expansion.

Make every opportunity an owned decision

Use Balance → Timing → Quality → Cause → Cash impact → Actionability → Owner → Decision. Each finding retains period, average and close, classification, days movement, quality, growth and seasonality, concentration, cash consequence, timing, dependency, risk and required approval. Label observed evidence, deterministic calculation, supported inference, unresolved hypothesis and management judgement separately.

For the concentrated arrears finding, the 13.0 closing receivable balance and 2.2 over-60-day bucket are observed example evidence. The 16.92% ratio is deterministic. Increased dependence on a small set of receipts is a supported inference. Customer distress remains an unresolved hypothesis until payment capacity and dispute evidence are examined. Releasing five DSO days is management judgement about a feasible target, not a causal conclusion from the ratio. Credit control owns invoice validation; the commercial director owns disputed delivery acceptance and credit-note decisions.

The first decision is therefore to approve a targeted review and conditional collection plan, not to book the entire overdue balance as forecast cash. Preserve the original expected receipt dates, record revised dates with reasons, and compare subsequent receipts against both. Treasury should escalate slippage that would breach the approved reserve; it should not silently replace missed receipts with another optimistic customer promise.

Procurement separately tests order cadence and minimum-order quantities, while operations checks production or replenishment plans against actual demand. Finance reconciles their proposed changes to the same inventory population. Otherwise two owners can claim the same avoided purchase, or procurement can negotiate longer terms on orders that operations intends to cancel.

Prioritise invoice evidence and short-term funding first; inventory and supplier actions mature later. Management approves growth, service and resilience trade-offs and escalates missed milestones. Review weekly cash realisation against the baseline, with sales, service and supplier performance alongside it. Close actions on verified outcomes, not improved ratios caused by write-offs, denominator growth or shifted cut-offs.

Replace plausible shortcuts with explicit controls

Connect financial diagnosis to recurring operating action

Within Entimema Financial Intelligence’s end-to-end workflow, specify source-statement and schedule registration, period and currency harmonisation, operating-account mapping, P&L and Balance Sheet validation, comparable calculations, cash bridges and evidence-linked findings. Retain processing state, exceptions and lineage. This is the required control architecture, not a claim that statements alone reveal invoice disputes or stock usability.

Financial Intelligence diagnoses the operating cash constraint. Receivables Intelligence is the direction for operationalising recurring receivables action: invoice ageing, overdue migration, customer concentration, disputes, promises, collection actions, exceptions and prioritised follow-up. This describes a workflow extension, not a currently live product claim. It cannot replace inventory, supplier and treasury analysis.

Model intelligence may propose semantic classifications, detect ambiguity, prioritise exceptions, interpret operations and request clarification. Deterministic code owns balances, ageing, DSO, DIO, DPO, CCC, reconciliations, bridges, scenario arithmetic and fixed controls. Humans approve the perimeter, collectibility, inventory actionability, supplier trade-offs and final liquidity decision.

Comparative analysis identifies structural movement; working capital as a system connects operating drivers; driver forecasting tests future funding. Here the opening contradiction resolves into 6.6 of working-capital absorption, concentrated collection risk, partly justified stock and a time-sensitive funding gap. A controlled 2.378082 opportunity deserves execution testing; an aggressive 6.564384 does not deserve automatic approval.