Blog · Finance metrics and formulas · Finance and FP&A teams
The inventory to net working capital ratio compares inventory with current assets less current liabilities. Calculate it from a balance-sheet export, reconcile the denominator, and handle small, zero, and negative working-capital balances.
The inventory to net working capital ratio is inventory divided by current assets minus current liabilities at the same reporting date. With a positive denominator, it compares inventory with the company's net current-asset cushion. It is a balance-sheet composition measure, so a rising result can come from higher current liabilities even when inventory is unchanged.
Net working capital = Current assets − Current liabilities
Inventory to net working capital ratio = Inventory / Net working capital
Percentage form = Inventory / Net working capital × 100
The SEC's guide to financial statements defines working capital as current assets less current liabilities. Use that full balance-sheet definition here, including cash and current debt where they are classified as current. An internally defined operating-working-capital calculation can be useful, but it produces a different denominator and needs a different label.
Inventory is part of current assets. Net working capital, however, is a residual after subtracting current liabilities. The ratio is therefore not inventory's percentage of total current assets, and it is not a literal allocation of a separate pot of money.
Inventory also differs from immediately available cash. OpenStax's liquidity-ratio discussion explains that inventory is less liquid than receivables because it must be sold before generating cash. The inventory ratio is a reason to inspect liquidity and stock quality together, not evidence that every inventory dollar will fund a near-term payment.
The existing working-capital guide covers the underlying definition and operating cycle. This calculation asks a narrower question: how large is inventory relative to the net current-asset balance?
Keep one row per ledger account and reporting entity, with the reporting date, account name, current classification, and balance in USD. Use inventory after the valuation adjustments reflected in the reported balance sheet. A gross inventory subledger against a net balance-sheet denominator can overstate the ratio.
For consolidated reporting, use balances after intercompany eliminations. If the analysis is by legal entity, keep entity balances and related-party classifications explicit rather than adding standalone results into a supposed consolidated ratio.
| Export field | Why it matters |
|---|---|
| Reporting date | Aligns inventory and both denominator components |
| Entity | Keeps legal-entity and consolidated scopes separate |
| Ledger account and classification | Identifies current assets and current liabilities |
| Inventory category | Supports stock-quality follow-up |
| Reported balance in USD | Provides a common currency and valuation basis |
| Adjustment or elimination reference | Explains differences from the published reporting totals |
A net working capital schedule can document the included accounts and adjustments. Keep the account mapping stable month to month so a reclassification does not appear to be an inventory event.
An illustrative US distributor reports the following balances at September 30, 2026. The table shows liability balances as positive amounts to subtract; an accounting export with credit balances shown as negative needs its signs normalized first.
| Balance-sheet line | Current assets (USD) | Current liabilities (USD) |
|---|---|---|
| Cash | 300,000 | — |
| Trade receivables | 500,000 | — |
| Inventory, net | 600,000 | — |
| Prepaid expenses | 100,000 | — |
| Accounts payable | — | 450,000 |
| Accrued expenses | — | 200,000 |
| Current debt | — | 100,000 |
| Total | 1,500,000 | 750,000 |
Each step follows from those rows:
| Step | Calculation | Result (USD except ratios) |
|---|---|---|
| Current assets (USD) | 300,000 + 500,000 + 600,000 + 100,000 | 1,500,000 |
| Current liabilities (USD) | 450,000 + 200,000 + 100,000 | 750,000 |
| Net working capital (USD) | 1,500,000 − 750,000 | 750,000 |
| Inventory / net working capital | 600,000 / 750,000 | 0.80 |
| Percentage form | 0.80 × 100 | 80.0% |
Suppose the workbook places inventory in B2, total current assets in B3, and total current liabilities in B4. Calculate net working capital in B5 and the ratio in B6:
B5: =B3-B4
B6: =IF(B5>0,B2/B5,NA())
Format B6 as a percentage. Do not multiply by 100 again after using percentage formatting. The guard intentionally flags nonpositive denominators for separate review rather than presenting them as ordinary comparisons.
Subtract inventory from net working capital. That must equal all other current assets less current liabilities:
Net working capital − Inventory = Other current assets − Current liabilities
Other current assets are 300,000 + 500,000 + 100,000 = $900,000. The left side is 750,000 − 600,000 = $150,000, and the right side is 900,000 − 750,000 = $150,000. Both routes agree.
This identity helps detect a common error: subtracting inventory from current assets before calculating the denominator. That would calculate a different measure. Inventory remains within current assets for the ratio defined here.
Also tie each total to the same balance-sheet reporting package. The inventory amount must agree with the inventory ledger after applicable valuation adjustments, while current assets and current liabilities must include every account classified in those groups.
Keep current assets and inventory unchanged, but increase current liabilities. The following scenarios isolate the denominator effect; they are sensitivity calculations, not additional claims about the distributor's transactions.
| Scenario | Inventory (USD) | Current assets (USD) | Current liabilities (USD) | Net working capital (USD) | Reported ratio |
|---|---|---|---|---|---|
| Original balances | 600,000 | 1,500,000 | 750,000 | 750,000 | 80.0% |
| Higher current liabilities | 600,000 | 1,500,000 | 950,000 | 550,000 | 109.1% |
| Zero net working capital | 600,000 | 1,500,000 | 1,500,000 | 0 | Undefined |
| Negative net working capital | 600,000 | 1,500,000 | 1,600,000 | −100,000 | Flag separately |
Ratios are rounded to one decimal place. In the second row, 600,000 / 550,000 × 100 = 109.1%. Inventory did not grow; current liabilities rose by $200,000 and net working capital fell by the same amount.
For zero net working capital, division is undefined. For negative net working capital, arithmetic can return a negative ratio, but that sign does not mean inventory reliance improved. Present the underlying balances and investigate payment timing and funding needs instead.
Very small positive denominators deserve the same attention. A modest reclassification or accrual can move the percentage sharply without materially changing stock. Show denominator dollars beside the ratio, and avoid ranking entities solely by the percentage.
The cash to working capital ratio examines cash against the same residual, while the long-term debt to net working capital ratio asks a financing question. Both need the same denominator caution.
For outside comparisons, a working-capital ratio by industry usually addresses current assets divided by current liabilities. That is a different formula, so do not carry its benchmark across to inventory divided by net working capital. In an acquisition, the net working capital peg follows the transaction's agreed definitions rather than automatically using every balance-sheet current account.
Finance owns the account mapping and reconciliation. Operations and procurement should explain inventory composition, aging, replenishment commitments, and expected use before the ratio becomes a stock-reduction target.
Upload your dated balance-sheet export and inventory valuation; Covirage maps the columns, and its tools compute the ratio and check the supplied totals. The external AI model explains the changes with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for finance teams for the supporting business context.
Yes. Net working capital subtracts current liabilities from all current assets, so it can be smaller than inventory. A ratio above 100% means inventory exceeds the net current-asset cushion. It does not mean inventory exceeds total current assets or that the balance sheet fails to balance.
There is no universal target. The useful comparison depends on inventory saleability, payment timing, financing, and the company's operating cycle. Compare a consistent monthly series, then investigate changes in inventory and current liabilities separately before setting an internal range.
The usual balance-sheet version uses inventory and net working capital at the same reporting date. If you create an average-balance version for internal analysis, average the numerator and denominator consistently and label it clearly. Do not mix annual average inventory with an unexplained closing denominator.
Show inventory, current assets, current liabilities, and the negative working-capital amount, then flag the ratio as not meaningful for this comparison. A negative arithmetic result is possible, but reading it as a low inventory reliance measure would be misleading.