Sign in

Blog · Finance metrics and formulas · Finance and FP&A teams

Working capital days: formula and interpretation

Working capital days divides average net working capital by daily revenue. Build the measure from monthly statements, reconcile changes across periods, and distinguish it from the cash conversion cycle and invoice payment timing.

The short answerWorking capital days equals average net working capital divided by average daily revenue. Net working capital is current assets less current liabilities, and daily revenue is period revenue divided by calendar days in that period. The result expresses a balance in revenue-equivalent days. It is different from the cash conversion cycle and does not measure actual customer payment delays.

Working capital days is average net working capital divided by daily revenue for the same period. It expresses the net balance of current assets and current liabilities as an equivalent number of revenue days. It does not tell you how long any invoice took to be paid.

The formula and its meaning

Net working capital = Current assets - Current liabilities

Daily revenue = Net revenue for the period / Calendar days in the period

Working capital days = Average net working capital / Daily revenue

Equivalently, multiply average net working capital by days in the period and divide by period revenue. The SEC's financial statements guide defines working capital as current assets less current liabilities. Use that full net definition here, including cash and current borrowings, rather than quietly substituting a narrower operating balance.

The existing working capital guide covers the underlying accounts. This measure adds a revenue denominator so finance can compare the balance's size with the activity of the business.

Think of the result as capital intensity stated in days. If daily revenue rises while net working capital stays constant, days falls. That arithmetic alone does not prove the business collected cash sooner or negotiated longer supplier terms.

Start with the statements you already have

Use monthly balance-sheet exports and the income statement for the comparison period. The balance export needs reporting date, entity or unit, account, currency, current classification and closing balance. The revenue export needs recognized period, the same entity scope, currency and net revenue.

Check the current account mapping against the financial statements before calculating. Do not infer current status from an account's name alone: a borrowing may have both current and long-term portions. Normalize credit-balance signs so current liabilities are subtracted once.

Choose an averaging method that the available data can support. This example uses equally weighted month-end observations. More frequent observations may be useful when balances fluctuate within a month. Do not compare a daily average for one period with a month-end average for another without making the difference visible.

A worked example across two quarters

A US distributor compares the quarters ending March 31 and June 30, 2026. The following balances are already reconciled to its monthly statements. All amounts are USD.

Observation date Current assets (USD) Current liabilities (USD) Net working capital (USD)
January 31, 2026 1,350,000 750,000 600,000
February 28, 2026 1,500,000 780,000 720,000
March 31, 2026 1,640,000 800,000 840,000
April 30, 2026 1,500,000 800,000 700,000
May 31, 2026 1,550,000 800,000 750,000
June 30, 2026 1,600,000 800,000 800,000

The first quarter has 90 calendar days; the second has 91. Revenue is taken from the income statement for each full quarter, not from a closing receivables balance.

Step First quarter Second quarter
Sum of monthly net working capital (USD) 600,000 + 720,000 + 840,000 = 2,160,000 700,000 + 750,000 + 800,000 = 2,250,000
Average net working capital (USD) 2,160,000 / 3 = 720,000 2,250,000 / 3 = 750,000
Net revenue (USD) 3,600,000 4,550,000
Calendar days 90 91
Daily revenue (USD) 3,600,000 / 90 = 40,000 4,550,000 / 91 = 50,000
Working capital days 720,000 / 40,000 = 18.0 750,000 / 50,000 = 15.0

Average net working capital increased by $30,000, yet the reported days fell by 3.0 because daily revenue increased from $40,000 to $50,000. There is more capital in dollars and less capital relative to the sales rate. Both statements matter when finance prepares a funding discussion.

Days are presented to one decimal; these example results are exact at that precision. Keep the unrounded amounts for calculations in a real workbook.

Prove the result and reproduce it in a spreadsheet

Multiply the reported days by daily revenue. For the first quarter, 18.0 × $40,000 = $720,000. For the second, 15.0 × $50,000 = $750,000. Each product must return its average net working capital before rounding.

There is also an identity with working capital turnover: working capital days equals period days divided by net working capital turnover, provided both use the same sales, period and average balance. In the first quarter, turnover is $3,600,000 / $720,000 = 5.00 times, and 90 / 5.00 = 18.0 days.

For a spreadsheet layout, put monthly net working capital observations in B2:B4, total period revenue in E2 and calendar days in F2:

=AVERAGE(B2:B4)/(E2/F2)

The reconciliation cell below should return zero before rounding:

=AVERAGE(B2:B4)-(AVERAGE(B2:B4)/(E2/F2))*(E2/F2)

That identity checks arithmetic, not data quality. Tie every monthly balance to its statement and total revenue to the ledger. The month-end close checklist covers the reconciliations that make those inputs dependable. A missing observation should remain an exception to resolve, rather than becoming zero.

Keep it separate from cash timing

The cash conversion cycle combines days sales outstanding, inventory days and days payable outstanding. The CFA Institute's financial analysis reading treats that cycle as a liquidity measure alongside financial ratios. Its component balances and denominators differ from this article's full net working capital calculation; the cash conversion cycle guide owns that separate method.

Cash illustrates the distinction. Add $100,000 of cash to every first-quarter observation, funded by long-term debt, and average net working capital becomes $820,000. At unchanged daily revenue of $40,000, working capital days becomes 20.5. Nothing in that change says customers or suppliers altered their payment behavior.

Nor does a fall in days establish cash released. Revenue can increase while capital remains tied up. Review movements in cash, receivables, inventory, payables and borrowings in dollars. If the decision concerns the financing charge on that investment, use the separate working capital cost analysis.

Where it goes wrong

  • Calling the figure collection time. Current assets include more than receivables, and current liabilities include more than supplier balances. Actual payment delays need invoice and payment dates.
  • Using the closing balance instead of the average. The first quarter's closing $840,000 divided by $40,000 gives 21.0 days, rather than the 18.0 based on the stated monthly average.
  • Mixing period lengths. A quarter's revenue divided by annual days distorts daily revenue. Use the exact calendar span covered by the sales total.
  • Reading negative days as faster operations. Negative net working capital makes the ratio negative. Inspect the funding structure, and do not rank it mechanically against positive balances.

Calculate working capital days on your own file in Covirage

Bring monthly statement balances and matching revenue, with the calendar period and current account mapping identified. Covirage maps the columns; its tools compute and check the averages, daily revenue and reconciliation, and the external AI model explains the changes with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See FP&A reporting for the supporting finance workflow.

Questions people ask

Is working capital days the same as the cash conversion cycle?

No. This measure divides average net working capital by daily revenue. The cash conversion cycle combines receivables days, inventory days and payables days. Those components use different sales or cost denominators and exclude many balances contained in net working capital.

Are lower working capital days always better?

No. Lower days can reflect stronger sales or less capital tied up, but they can also reflect smaller cash reserves or long-term debt reclassified as current. Inspect the accounts behind the movement before deciding whether it represents an operational improvement or a funding change.

Can working capital days be negative?

Yes. With positive revenue, negative average net working capital produces negative days because average current liabilities exceed average current assets. Report the sign and the underlying balances clearly. A negative result is not an estimate that customers pay before an invoice is issued.

Should the formula use calendar days or business days?

Use calendar days for a statement-based measure and match them to the revenue period. Record the convention and apply it consistently. Business-day calculations may serve a separate operating question, but mixing them with calendar-day figures makes period comparisons misleading.