Build a Working Capital Forecast

Define the balances before forecasting them

A working capital model projects the operating balances that separate recognizing a sale or cost from receiving or paying cash. Start with trade receivables, inventory and trade payables, then identify other material operating current positions. Exclude cash and financing debt from the operating cash bridge.

The working-capital guide explains the concept and broader current-assets-minus-current-liabilities definition. This forecast develops the balances through future periods. Document the perimeter: the preview sets other operating current assets and liabilities to zero, so operating NWC equals receivables + inventory − trade payables.

Connect each balance to the appropriate activity

Use forecast revenue to explain customer receivables, cost of goods sold to explain inventory, and purchasing or cost activity to explain supplier credit. A collection target, stock policy and payment assumption answer different operational questions. A single percentage applied to all three balances conceals those differences.

Develop the receivables forecast, inventory forecast and trade-payables forecast separately. BalanceCheat supports Amount and Days for these modeled lines. Its DPO model uses COGS; the standalone calculator can instead use purchases. Preserve that distinction when transferring assumptions.

Carry the opening position into the first forecast

The first projected balance must follow a coherent opening position. In the example, opening receivables are EUR 600,000, inventory EUR 560,000 and payables EUR 240,000. With annual revenue of EUR 3.65 million and COGS of EUR 2.92 million, targets of 40 DSO, 50 DIO and 30 DPO imply EUR 400,000, EUR 400,000 and EUR 240,000 on the 365-day basis.

Operating NWC falls from EUR 920,000 to EUR 560,000. Receivables release EUR 200,000, stock releases EUR 160,000 and unchanged payables contribute zero: a EUR 360,000 cash benefit from these three movements. It is a balance transition, not EUR 360,000 of additional revenue or recurring annual profit.

Explain growth as well as timing improvements

The next forecast increases revenue and COGS by 20% while retaining the same day assumptions. Closing receivables and stock become EUR 480,000 each; payables become EUR 288,000. Operating NWC rises to EUR 672,000, consuming EUR 112,000 of cash despite an unchanged cash conversion cycle.

The CCC guide explains the timing measure. The combined CCC calculator compares selected assumptions and balances. A continuing model also rolls the opening position forward and changes activity, so a shorter cycle does not guarantee cash release in every future period.

Reconcile movements with operating cash flow

Ordinary cash effects are −change in receivables −change in inventory +change in payables. Use successive balances, not the whole closing stock each year. Customer receipts and supplier payments offer a direct cross-check. Separate non-cash impairment, acquisitions and translation effects when the perimeter contains them.

The preview shows signed effects beside total CFO. CFO also includes earnings, non-cash items, interest, tax and other supported operating movements. Follow investment into free cash flow rather than treating the three-account cash bridge as total cash generation. The cash-flow statement reference documents presentation and reconciliation.

Choose periods that reveal the funding peak

Annual closing balances can hide stock built before a selling season or invoices collected after delivery. Use supported finer source periods where timing determines the decision, and align each flow with its source basis. BalanceCheat annualizes the relevant period flow for its 365-day working-capital convention; calculator day choices are separate supplied-input conventions.

The working-capital implementation reference explains available sources and flow constraints; the period reference explains granularity. Compare collection and stock cases before reviewing the cash and funding reference. A calculated funding requirement does not establish an available credit facility.

For an AI-assisted explanation of why a collection or payment assumption changes cash, follow the AI cash-flow workflow. Ask for the source balance and period, then inspect the direct edit and its cash effect in the connected model.