Blog · Finance metrics and formulas · Finance and FP&A teams
Working capital requirement estimates the operating balances a business needs to fund before customer cash arrives. Build a timing-based estimate from sales, inventory and purchases, then separate the total requirement from the additional funding caused by growth or slower collection.
Working capital requirement estimates the operating balances a business must fund while it waits for customer cash. Start with projected trade receivables plus inventory minus trade payables, then add other operating accounts that matter to your business. The additional funding need is the change from the opening requirement, rather than the entire projected balance.
Trade working capital requirement = Projected trade receivables + Projected inventory − Projected trade payables
Additional trade funding requirement = Projected requirement − Opening requirement
This is a planning definition. Balance-sheet working capital includes all current assets and current liabilities. The SEC's financial-statement guide defines that balance-sheet measure and distinguishes balances at a date from cash flows over a period.
For this estimate, exclude cash and borrowing so the amount describes the operating investment to be financed. If prepayments, accrued operating expenses or customer advances are material, include them in a separately labeled wider operating requirement. Keep financing, capital spending and the minimum cash reserve in the broader cash forecast.
Bring the opening receivables aging, inventory valuation and accounts payable aging. Add the finance-approved monthly sales forecast, cost forecast and purchasing budget. Use the same entity, currency and account definitions throughout.
Estimate collection timing from actual receipts and customer terms, inventory holding time from stock movements, and supplier payment timing from credit purchases and payments. The Small Business Administration's finance guidance recommends financial tracking and projections, with responsibility for receivables, payables and available cash. Give each assumption an owner who can explain a change.
For a stable run rate, the approximations are:
Receivables = Credit sales / Period days × Collection days
Inventory = Cost of goods sold / Period days × Inventory days
Trade payables = Credit purchases / Period days × Supplier payment days
Use credit sales because cash sales do not create receivables. Use credit purchases for payables; when inventory is building, purchases can exceed cost of goods sold. The days sales outstanding and days payable outstanding guides cover those timing measures in detail.
An illustrative US distributor plans using standardized 30-day run-rate periods. All sales and purchases are on credit. Each scenario assumes a stable daily rate and stable inventory within that scenario, so credit purchases equal cost of goods sold. These are separate steady-state comparisons, not a month-by-month transition schedule.
Place labels in column A, the baseline in B, growth in C and collection delay in D. The row numbers below make the formulas reproducible. Dollar amounts are exact; no rounding is needed for these inputs.
| Row | Input or calculation | Baseline: B | Growth: C | Collection delay: D |
|---|---|---|---|---|
| 2 | Credit sales (USD) | 900,000 | 1,080,000 | 1,080,000 |
| 3 | Cost of goods sold (USD) | 540,000 | 648,000 | 648,000 |
| 4 | Credit purchases (USD) | 540,000 | 648,000 | 648,000 |
| 5 | Period days | 30 | 30 | 30 |
| 6 | Collection days | 40 | 40 | 50 |
| 7 | Inventory days | 50 | 50 | 50 |
| 8 | Supplier payment days | 30 | 30 | 30 |
| 9 | Projected receivables (USD) | 1,200,000 | 1,440,000 | 1,800,000 |
| 10 | Projected inventory (USD) | 900,000 | 1,080,000 | 1,080,000 |
| 11 | Projected trade payables (USD) | 540,000 | 648,000 | 648,000 |
| 12 | Trade requirement (USD) | 1,560,000 | 1,872,000 | 2,232,000 |
| 13 | Additional requirement vs baseline (USD) | 0 | 312,000 | 672,000 |
Enter these formulas in column B and copy them across:
B9: =B2/B5*B6
B10: =B3/B5*B7
B11: =B4/B5*B8
B12: =B9+B10-B11
B13: =B12-$B$12
The baseline is $1,200,000 + $900,000 − $540,000 = $1,560,000. Growth raises it to $1,872,000, an additional $312,000 even with unchanged timing. Collecting in 50 rather than 40 days raises the requirement to $2,232,000.
The collection delay adds $360,000 beyond the growth case: daily credit sales of $1,080,000 / 30 = $36,000, multiplied by 50 − 40 = 10 extra days. The total additional requirement is therefore $312,000 + $360,000 = $672,000.
Check the identity in a spare cell and copy across:
=B12+B11-B9-B10
It must return zero. For growth, $1,872,000 + $648,000 equals $1,440,000 + $1,080,000. Also reconcile the baseline to actual opening balances before treating its difference from a forecast as new funding.
For seasonal or rapidly changing sales, replace the run-rate approximation with scheduled invoices, receipts, purchases and payments. Reconcile closing receivables to opening receivables plus credit sales minus collections and other reductions. Do the equivalent inventory and payable roll-forwards, including the actual stock build.
Repeat the calculation by planning period and inspect the largest cumulative increase from opening balances. Then put that change into the cash forecast alongside operating cash generation, taxes, capital spending and financing payments. The cash conversion cycle explains the timing; it cannot replace this dollar forecast.
Upload the balance exports and your finance-approved projection workbook with its timing assumptions. Covirage maps the columns, and its tools compute and check the supplied figures; the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting in Covirage for the wider planning context.
Balance-sheet working capital is current assets minus current liabilities at a date. Working capital requirement is a planning estimate of the operating balances that need funding. Its scope commonly excludes cash and borrowing, so name the accounts included before comparing the two.
No. It estimates funding tied up in defined operating balances. Existing cash, operating cash generation, capital spending, taxes and financing payments also affect borrowing needs. Put the change in the requirement into the broader cash forecast before deciding how to fund it.
Yes. Trade payables and other operating liabilities can exceed receivables and inventory, particularly when customers pay before suppliers must be paid. Check settlement dates and customer obligations rather than treating a negative balance as cash that can always be spent.
Use credit purchases when estimating trade payables from supplier payment days. Purchases and cost of goods sold can differ when inventory changes. If only cost of goods sold is available, disclose that it is a proxy and check whether stock building makes it unsuitable.