Net Working Capital Calculator

Working capital is the cash your operating cycle swallows before a sale becomes money in the bank. This calculator builds it from the individual balance-sheet lines rather than a single subtotal, so it can report three figures a controller needs separately: net working capital, operating working capital with cash and short-term debt stripped out, and the change between periods that flows straight into operating cash flow. It also converts the result into days of sales and shows how much cash your next 30% of growth absorbs — or releases, if your working capital is negative.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Cash and equivalentsUnrestricted bank balances and short-term investments. Included in net working capital, excluded from operating working capital.120000 $
Accounts receivable, netTrade receivables after the allowance for doubtful accounts, plus unbilled contract assets if you carry them.190000 $
InventoryRaw materials, work in progress and finished goods at carrying value. Enter 0 for a service business.150000 $
Prepaid and other current assetsPrepaid rent and insurance, deposits, refundable taxes and any other current asset not listed above.30000 $
Accounts payableTrade payables owed to suppliers. Use the gross balance, not net of any early-payment discount you hope to take.145000 $
Accrued expensesWages, payroll taxes, interest, utilities and other costs incurred but not yet invoiced or paid.65000 $
Short-term debt and current portionRevolver draws, notes payable within a year and the current portion of long-term debt. Financing, not operating.90000 $
Unearned revenue and other current liabilitiesCustomer deposits, deferred revenue, current taxes payable and current lease liabilities.20000 $
Prior-period net working capitalThe same net figure from the comparative balance sheet. The difference is the cash effect for the period.265000 $
Annual revenueTrailing twelve months of net sales, used to express working capital as a percentage of sales and in days.2400000 $

It returns

  • Net working capital — Total current assets minus total current liabilities.
  • Operating working capital — Excludes cash and short-term debt, so it measures only the operating cycle.
  • Change since prior period
  • Cash released (+) or absorbed (−) — The sign as it appears in operating activities: a rise in working capital is a use of cash.
  • Working capital as a share of sales
  • Working capital in days of sales
  • Current ratio

The formula

NWC=current assetscurrent liabilities
OWC=(CAcash)(CLdebt)
WC days=NWCrevenue365

In plain text: Net working capital = Current assets − Current liabilities

  • NWCNet working capital — the whole current section netted ($)
  • OWCOperating working capital — net working capital excluding cash and short-term debt ($)
  • ΔNWCChange in net working capital between two balance sheet dates ($)
  • revenueTrailing twelve-month net sales, used to scale the result ($)

Operating working capital removes the two financing items from the current section: cash, which is a store of value rather than part of the operating cycle, and short-term debt, which is a funding choice.

Updated Category Liquidity & Working Capital Ratios Verified against published test cases Reading time 12 min

What working capital is, in cash terms

Working capital is the money permanently parked in the gap between paying for something and getting paid for it. You buy inventory, hold it, sell it on 45-day terms, and collect two months later; meanwhile your suppliers want paying in 30. The shortfall has to be funded, and that funding requirement is working capital. It is not idle money and it is not profit — it is a standing investment that grows every time the business grows.

The formal definition is the current section of the balance sheet, netted: current assets minus current liabilities. What belongs in that current section is not a matter of taste — ASC 210-10 under US GAAP and IAS 1 under IFRS both draw the line at what will be realised or settled within twelve months or within one normal operating cycle, whichever is longer, which is why a revolver due in eleven months sits in the calculation and a term loan due in eighteen does not. On the default figures, $490,000 minus $320,000 gives $170,000. That number matters in three separate decisions. A lender sizing a revolving facility wants to know the permanent portion. A buyer negotiating a purchase agreement wants a normalised target, because working capital delivered at closing is part of the price. And a finance team forecasting cash needs to know the change, because that is what hits the cash flow statement.

The change is where the sign confuses people. An increase in working capital is a use of cash: your money moved out of the bank and into receivables and inventory. A decrease releases cash. Growing companies almost always show working capital rising, which is why a business can post record profit and still not be able to make payroll.

Three definitions, and which one to use where

Net working capital is current assets minus current liabilities, exactly as the balance sheet presents them. Use it for covenant tests and for a first read on liquidity. Its weakness is that it mixes operating items with financing items: a company that draws its revolver reduces net working capital without changing anything about how it sells or collects.

Operating working capital, also called non-cash working capital, fixes that. Take cash out of the assets and short-term debt out of the liabilities: (CA − cash) − (CL − short-term debt). On the default figures that is $370,000 − $230,000 = $140,000. This is the figure to use in a valuation model, because free cash flow needs the change in the operating investment, not the change in the cash balance you are trying to value. It is also the figure to forecast, since it scales with revenue while cash and debt do not.

Trade working capital narrows further to receivables plus inventory minus payables — the three accounts an operations team can actually move. Use it for a working-capital improvement programme, because it maps directly onto days sales outstanding, days inventory outstanding and days payable outstanding, whose net is the cash conversion cycle.

Scaling matters as much as the definition. A $170,000 requirement means nothing until you divide by revenue: $170,000 on $2.4 million of sales is 7.08% of sales, or 25.9 days. Intensity in days is the only form in which the number is comparable across periods, across competitors, and across a growth plan.

Worked example: a $2.4 million distributor

A distributor closes the year with cash $120,000, receivables $190,000, inventory $150,000 and prepaid items $30,000. Current liabilities are payables $145,000, accrued payroll $65,000, a revolver draw of $90,000 and deferred customer deposits of $20,000. Last year net working capital was $265,000. Revenue was $2,400,000.

  1. Total the current assets. $120,000 + $190,000 + $150,000 + $30,000 = $490,000.
  2. Total the current liabilities. $145,000 + $65,000 + $90,000 + $20,000 = $320,000.
  3. Net them. $490,000 − $320,000 = $170,000 of net working capital.
  4. Strip the financing items. Assets excluding cash: $370,000. Liabilities excluding the revolver: $230,000. Operating working capital = $140,000.
  5. Find the change. $170,000 − $265,000 = −$95,000. Working capital fell, so it released $95,000 of cash, which appears as a positive adjustment in operating activities.
  6. Scale it. $170,000 ÷ $2,400,000 = 7.08% of sales. In days: 0.0708 × 365 = 25.9 days.
  7. Price the growth. At the same intensity, growing revenue 20% to $2,880,000 needs working capital of $170,000 × 1.20 = $204,000, so growth absorbs $34,000 before a single dollar of extra profit is banked.

The release of $95,000 is the number to interrogate. A fall in working capital is only good news if it came from faster collection or better inventory turns. If it came from stretching suppliers, from a revolver draw, or from customer deposits taken on orders not yet delivered, the cash is borrowed, not earned — and it reverses.

How to read the result: intensity, direction and the growth trap

Read the level first, then the intensity, then the direction. A positive net working capital means current assets fund current obligations with room to spare; negative means suppliers and customers are funding you. Neither is automatically better. Supermarkets, restaurants and airlines routinely run negative working capital because customers pay before or at delivery while suppliers wait 30 days. A machine shop or a specialty contractor cannot copy that: their cycle runs the other way and negative working capital there signals stress.

Intensity in days is the comparison metric. Under about 30 days of sales is lean. 30 to 75 days is normal for distribution and light manufacturing. Above 120 days, growth becomes self-limiting: every dollar of new revenue drags a third of a dollar into the cycle, so a business growing 30% a year needs external funding permanently.

The direction tells you what changed. Divide the movement between the three drivers before you explain it: receivables up means collection slipped or sales grew; inventory up means either a deliberate stock build or slowing sell-through; payables up means you are taking longer to pay, which flatters cash today and costs you supplier goodwill and early-payment discounts tomorrow.

The growth trap deserves its own reading. Working capital scales with revenue, so a company at 25% intensity growing 40% must fund an extra 10% of its opening revenue in the same year. Profit does not arrive fast enough to cover it. This is the mechanism behind most failures of profitable small businesses, and the reason a growth plan needs a working-capital line next to the revenue line.

Working-capital intensity and what growth costs

Cash absorbed per $1,000,000 of new revenue at each level of working-capital intensity, derived directly from the definition.
Working capital as % of salesDays of salesCash absorbed per $1m of new revenueTypical profile
−5%−18.3−$50,000 releasedSupermarket, quick service, subscription prepaid
0%0.0$0Cash-on-delivery service business
5%18.3$50,000Lean distribution, tight collection
10%36.5$100,000Light manufacturing, professional services
15%54.8$150,000Wholesale with 60-day terms
20%73.0$200,000Specialty manufacturing, long lead times
25%91.3$250,000Capital equipment, project contracting

Days of sales is the percentage multiplied by 365. Cash absorbed is the percentage applied to the increment in revenue, not to total revenue — which is why the number is manageable at 5% and crippling at 25%.

The sign convention that trips up every cash flow statement

In the indirect-method cash flow statement, changes in working capital appear with their sign reversed relative to the balance sheet movement. Receivables rising $40,000 is shown as (40,000) in operating activities, because the sale was recognised in profit but the cash has not arrived. Payables rising $25,000 is shown as +25,000, because the expense hit profit but the cash has not left.

The rule that always works: an increase in an operating asset uses cash; an increase in an operating liability provides cash. This calculator reports the movement both ways — Change since prior period follows the balance sheet, and Cash released or absorbed follows the cash flow statement. Reconcile to the indirect-method operating cash flow figure if the two disagree.

Assumptions and pitfalls

  • Cash and debt distort net working capital. Drawing a revolver to hold cash leaves net working capital unchanged but tells you nothing. Use operating working capital when comparing periods or companies.
  • A single date is a snapshot. Seasonal businesses can swing sharply between quarter-ends. Use an average of four quarters, or measure the same month each year.
  • The change is not the whole cash story. Acquisitions, currency translation and reclassifications all move balance-sheet working capital without a matching cash flow, which is why the cash flow statement figure rarely equals the balance-sheet difference exactly.
  • Deferred revenue is not free money. It reduces working capital and looks like customer financing, but it carries an obligation to deliver, and the cost of delivering it is still to come.
  • Inventory at cost is not inventory at value. Obsolete stock inflates working capital and overstates the funding you can recover.
  • Purchase agreements use a normalised target. In an acquisition, working capital delivered at closing is compared against an agreed peg, usually a twelve-month average, with a dollar-for-dollar price adjustment. Never negotiate from a single month-end.
  • This calculator holds intensity constant. The growth table assumes the percentage of sales does not change. Real improvements in collection or turns break that assumption, in your favour.

Working capital in dollars answers how much funding the cycle needs. The ratios built on the same balances answer whether the funding is adequate. The current ratio expresses the same two subtotals as a quotient, which is what covenants use because it survives changes in company size. The quick ratio and cash ratio tighten the numerator progressively.

To act on the number rather than measure it, work in days. The cash conversion cycle decomposes the operating cycle into inventory days plus receivable days minus payable days, and each of those has a lever attached: pricing and credit terms, purchasing and safety stock, supplier negotiation. Cutting the cycle by ten days at $2.4 million of revenue frees roughly $66,000 permanently.

For valuation, the change in operating working capital is a line item in free cash flow, so the free cash flow calculator consumes the figure this page produces. For funding, compare the requirement against what operations generate using the operating cash flow ratio.

Key terms

Net working capital
Total current assets minus total current liabilities at one balance sheet date.
Operating working capital
Net working capital excluding cash, equivalents and short-term debt. Also called non-cash working capital. The figure used in free cash flow.
Working capital intensity
Working capital divided by revenue, expressed as a percentage or as days of sales. The comparable form of the measure.
Working capital peg
The normalised target level agreed in a purchase agreement, against which closing working capital is compared to adjust the price.
Permanent working capital
The minimum level the business needs at the low point of its cycle. Usually funded with long-term capital, leaving only the seasonal peak on a revolver.

Frequently asked questions

How much working capital does a business need?

Enough to fund the gap between paying suppliers and collecting from customers, plus a buffer for the seasonal peak. Expressed as intensity, the working rule of thumb for distributors and light manufacturers is 10% to 20% of annual sales, or 36 to 73 days. Service businesses that bill monthly and pay staff monthly need less, often under 10%. The right test is not a benchmark but a forecast: model your worst month of the year and make sure committed funding covers it.

Is negative working capital bad?

Not by itself. Negative working capital means customers and suppliers fund your operations, which is the deliberate model at supermarkets, restaurants, airlines and prepaid subscription businesses. It becomes dangerous when it is not by design: if your customers pay in 60 days and your suppliers demand 15, negative working capital means you are short of funding, not clever about it. Check whether the negative figure comes from fast cash collection or from stretched payables.

Why does an increase in working capital reduce cash flow?

Because the increase is cash that has moved out of the bank and into receivables or inventory. Recognising a $40,000 sale on credit adds $40,000 to profit and nothing to cash, so the indirect cash flow statement subtracts the receivable increase to get back to reality. The same logic runs in reverse for liabilities: an increase in payables means an expense hit profit without cash leaving, so it is added back.

What is the difference between working capital and operating working capital?

Operating working capital excludes cash and short-term debt. Those two items are financing rather than operating: holding more cash or drawing a revolver changes net working capital without altering how you sell, collect or pay. Valuation models and forecasts use the operating figure because it scales with revenue. Covenants usually use the net figure because it is easier to define from published statements.

How do I calculate the change in working capital for a DCF?

Use operating working capital at both dates and subtract: OWC this period minus OWC last period. Then reverse the sign to get the free cash flow adjustment, because an increase absorbs cash. Exclude cash, short-term debt and any non-recurring item such as an acquired balance. Most modellers forecast the change by holding operating working capital at a constant percentage of revenue, which is exactly the assumption in the growth table on this page.

Does working capital include short-term debt?

Net working capital does, because short-term borrowings and the current portion of long-term debt are current liabilities. Operating working capital does not. This is the single most common inconsistency between two analysts calculating the same company, so state which definition you used. If you are comparing against a covenant, read the credit agreement: many define working capital with debt excluded and specific receivables carved out.

How do I reduce working capital without hurting the business?

Work the three drivers in order of least customer impact. Inventory usually holds the most recoverable cash: cut safety stock on fast movers, liquidate slow-moving lines, and shorten replenishment cycles. Then collections: invoice the same day, enforce terms, and chase at 5 days past due rather than 30. Payables last, because stretching suppliers costs discounts and goodwill. A ten-day cut in the cash conversion cycle frees about 2.7% of annual revenue permanently.

What working capital figure is used in an acquisition?

A normalised target, called the peg, usually set as the average monthly working capital over the trailing twelve months and defined precisely in the purchase agreement — typically excluding cash, debt and transaction-related items. Actual working capital at closing is compared against the peg and the price adjusts dollar for dollar. Because the definition drives real money, the schedule of included accounts is negotiated line by line rather than taken from the balance sheet.

Can working capital be too high?

Yes. Every dollar in receivables and inventory is capital earning nothing, so excess working capital directly depresses return on invested capital. A business at 30% intensity where competitors run at 12% is carrying roughly 18% of revenue in unnecessary funding. The usual causes are slack collection, safety stock covering for poor forecasting, and paying suppliers earlier than terms require. Each has a fix that releases cash without any revenue impact.

References

  • Accounting Standards Codification Topic 210, Balance Sheet — Financial Accounting Standards Board
  • Accounting Standards Codification Topic 230, Statement of Cash Flows — Financial Accounting Standards Board
  • IAS 1, Presentation of Financial Statements — IFRS Foundation
  • IAS 7, Statement of Cash Flows — IFRS Foundation
  • Investment Valuation, 3rd ed. (treatment of non-cash working capital in free cash flow) — Wiley (Aswath Damodaran)
  • Principles of Corporate Finance, 13th ed. — McGraw-Hill (Brealey, Myers & Allen)