Working Capital Calculator
This working capital calculator measures short-term liquidity from the balances you enter. It calculates current assets, current liabilities, net working capital, current ratio, quick ratio, cash ratio, net operating working capital, turnover, period change, target gap, and working capital as a percentage of revenue.
Net working capital (NWC) = Current assets (CA) − Current liabilities (CL). A positive result means current assets exceed obligations due within the operating cycle.
Working capital results
Working capital formulas and symbols
CL = Accounts payable + Accrued expenses + Short-term debt + Other current liabilities
NWC = CA − CL
Current ratio = CA ÷ CL
Quick ratio = (Cash + Cash equivalents + Accounts receivable) ÷ CL
Cash ratio = (Cash + Cash equivalents) ÷ CL
NOWC = Operating current assets − Operating current liabilities
Average NWC = (Beginning NWC + Ending NWC) ÷ 2
Working capital turnover = Revenue ÷ Average NWC
Target gap = CA − (Target current ratio × CL)
The working capital calculator separates liquidity measures because each answers a different question. NWC is an amount; ratios compare resources with obligations; turnover connects the amount of working capital to sales. Net operating working capital excludes cash, cash equivalents, and short-term debt so the result focuses on funds tied up in operations.
Worked working capital example
Suppose a company has $300,000 of current assets and $170,000 of current liabilities. Its net working capital is $300,000 − $170,000 = $130,000, and its current ratio is 300,000 ÷ 170,000 = 1.76.
If beginning working capital was $110,000, average working capital is $120,000. With $1,200,000 in revenue, turnover is 1,200,000 ÷ 120,000 = 10.00 times. A target ratio of 1.50 requires $255,000 in current assets, leaving a $45,000 buffer above that target.
How to interpret the results
| Measure | What it shows | Important caution |
|---|---|---|
| Net working capital | Dollar buffer after current obligations | Positive is not automatically efficient; excess inventory may be slow-moving. |
| Current ratio | All current assets relative to current liabilities | Appropriate levels vary by industry and season. |
| Quick ratio | Liquidity without inventory and other less-liquid assets | Receivables may still be hard to collect. |
| Cash ratio | Immediate cash coverage | A low value may be normal for businesses with predictable cash inflows. |
| Turnover | Revenue generated per unit of average working capital | Negative or near-zero average working capital makes the ratio misleading. |
There is no universal “good” working capital ratio. Retailers, manufacturers, subscription businesses, and professional services companies have very different cash cycles. Compare results with prior periods, forecasts, lender covenants, and companies with similar operations.
Working capital versus cash flow
Working capital is a balance-sheet snapshot, while cash flow measures movement during a period. A profitable company can face a cash shortage if customers pay slowly or inventory builds faster than sales. Likewise, working capital can improve temporarily when bills remain unpaid. Use this working capital calculator with the Cash Flow Calculator and Cash Conversion Cycle Calculator for a more complete view.
Ways to improve working capital
- Invoice promptly and follow up on overdue receivables.
- Forecast inventory from realistic sales demand and lead times.
- Negotiate supplier terms without harming important relationships.
- Refinance suitable short-term debt into longer maturities where appropriate.
- Maintain a cash buffer for payroll, tax, and seasonal needs.
- Track aging schedules instead of relying only on balance-sheet totals.
When to use this working capital calculator
Use the working capital calculator during monthly close, budgeting, lender reviews, acquisition screening, and cash planning. The working capital calculator is especially useful when you compare the same business across consistent reporting dates. For a forecast, enter projected balances and compare the result with your current-period output.
Practical working capital calculator checks
A working capital calculator result is most valuable when inputs are consistent. Reconcile the working capital calculator balances to one reporting date, review receivables for collectability, and check inventory for obsolete items. Rerun the working capital calculator with a realistic downside scenario, then compare that output with your target and prior period. This turns the working capital calculator into a repeatable planning tool rather than a one-time ratio check.
Data quality, assumptions, and limitations
Use figures from the same reporting date and accounting basis. The calculator assumes entered balances are non-negative and treats all current assets and current liabilities according to their labels. It does not test asset collectability, inventory obsolescence, restricted cash, covenant definitions, contingent liabilities, or tax consequences. Results are planning estimates, not accounting, lending, investment, or legal advice.
For formal analysis, reconcile inputs to your general ledger and financial statements. Classification rules may differ under applicable accounting standards and loan agreements. The working capital overview provides additional background on the concept.
Working capital calculator FAQs
What is net working capital?
Net working capital is current assets minus current liabilities. It expresses the short-term liquidity buffer as a currency amount.
Is a current ratio of 2 always good?
No. A higher ratio can indicate more liquidity, but it can also reflect excess inventory, slow collections, or idle cash. Industry context and balance quality matter.
Why does the quick ratio exclude inventory?
Inventory may take longer to sell and convert into cash. The quick ratio focuses on cash, cash equivalents, and receivables.
What is net operating working capital?
Here, NOWC equals receivables, inventory, and other operating current assets minus payables, accrued expenses, and other operating current liabilities. Cash and short-term debt are excluded.
Can working capital be negative?
Yes. Negative working capital means current liabilities exceed current assets. It can signal pressure, though some cash-generative business models operate sustainably with negative working capital.
How often should working capital be measured?
Monthly measurement is useful for many businesses, while highly seasonal or cash-sensitive operations may monitor it weekly. Always compare equivalent reporting dates.