Working Capital Formula: Calculator, Example, and Excel Workbook
The working capital formula is current assets minus current liabilities. If current assets are $110,000 and current liabilities are $65,000, working capital is $45,000. The subtraction takes seconds. Reading whether that $45,000 can actually support payroll, suppliers, tax, and debt takes more care.
This page gives you the formula, a worked example, and a free Excel calculator. The workbook adds current ratio, quick ratio, quality-adjusted working capital, a 12-month trend, and an action register because positive working capital can still hide old receivables, slow inventory, restricted cash, or a large payment due next week.
What is the working capital formula?
Working capital = current assets – current liabilities.
Current assets are resources expected to turn into cash, be sold, or be used within the operating cycle or about 12 months. Current liabilities are obligations due in the same short period. The exact classification follows the accounting basis used in the financial statements.
| Current assets | Amount | Current liabilities | Amount |
|---|---|---|---|
| Cash | $25,000 | Accounts payable | $30,000 |
| Accounts receivable | $45,000 | Short-term debt | $18,000 |
| Inventory | $35,000 | Accrued expenses | $12,000 |
| Other current assets | $5,000 | Other current liabilities | $5,000 |
| Total | $110,000 | Total | $65,000 |
The U.S. Securities and Exchange Commission financial-statement guide explains the balance sheet as a snapshot of assets, liabilities, and equity. Working capital takes the short-term parts of that snapshot and compares them.
Use the free working capital calculator
The workbook separates each current asset and liability, adds a realizable quality factor, and calculates both headline and adjusted results. It also gives you a 12-month trend and an action register.
Get the Excel calculator with working capital, current and quick ratios, asset-quality checks, a 12-month trend, and an action register. Enter your details and I’ll email the secure download link. The newsletter checkbox is optional and can be cleared if you only want the workbook.
| Output | Formula | What it tells you |
|---|---|---|
| Working capital | Current assets – current liabilities | Dollar cushion at the reporting date |
| Current ratio | Current assets / current liabilities | Relative short-term coverage |
| Quick ratio | Quick assets / current liabilities | Coverage without inventory |
| Quality-adjusted working capital | Adjusted current assets – current liabilities | A conservative operating view |
| Cash trapped by quality adjustment | Headline assets – adjusted assets | How much relies on uncertain realization |
Blue cells are inputs. Green cells are formulas. Replace the sample balances and document why each quality factor is reasonable before using the adjusted result.
What do current ratio and quick ratio add?
The working capital formula gives a dollar amount. Current ratio divides current assets by current liabilities. In the example, $110,000 divided by $65,000 gives a current ratio of 1.69. The quick ratio removes inventory from quick assets, producing 1.15 in the sample.
| Measure | Sample result | Useful for | Main weakness |
|---|---|---|---|
| Working capital | $45,000 | Absolute short-term cushion | Business size changes the meaning |
| Current ratio | 1.69x | Relative coverage and trend | Can overvalue old inventory and receivables |
| Quick ratio | 1.15x | More liquid coverage | Still assumes receivables will collect |
| Quality-adjusted ratio | 1.38x | Conservative operating review | Depends on judgment |
There is no universal good ratio. A prepaid software business, a construction contractor, and an inventory-heavy retailer collect and pay on different cycles. Compare the business with its own history, loan covenants, seasonal pattern, and genuinely similar operations.
Do not optimize a ratio for presentation. Paying a supplier late can improve the month-end snapshot and damage future supply. Cutting inventory can release cash and create stockouts. The operating consequence belongs beside the financial result.
Why positive working capital can still be weak
Two businesses can reach the same $45,000 result with the working capital formula and carry different risk. One may hold cash and current receivables. The other may hold slow inventory and invoices already 90 days overdue.
- Receivables: reduce the quality factor for old, disputed, or concentrated balances.
- Inventory: reduce it for obsolete, seasonal, or slow-moving stock.
- Cash: remove amounts restricted for tax, payroll, escrow, or another purpose.
- Other current assets: confirm they can become usable cash within the period.
- Current liabilities: include payroll, tax, accrued costs, short-term debt, and other near-term obligations completely.
The quality factor is not an accounting entry. It is a management stress test. Keep the published balance-sheet number intact and label the adjusted view for what it is.
For overdue receivables, use the accounts receivable aging workflow before assigning a high collection factor. For payment timing beyond the snapshot, use the cash flow forecast template. The published cash-flow killers guide explains why a healthy annual number can still fail in one week.
Review working capital as a trend, not a photo
The workbook includes a 12-month trend for cash, receivables, inventory, other current assets, payables, short debt, accrued costs, and other current liabilities. Update it on the same month-end basis.
- Compare with the prior month.
- Compare with the same seasonal month last year.
- Open the AR aging and inventory aging behind large changes.
- List material cash payments due before expected collections.
- Explain ratio improvement that came from delayed suppliers or missing liabilities.
A growing business can show falling cash and rising receivables because sales expanded faster than collections. That is not automatically bad. It becomes dangerous when the collection cycle, customer concentration, and payment calendar cannot support the growth.
How to improve working capital without breaking operations
Choose the component trapping the most cash and run one focused action. Broad instructions to ‘improve working capital’ produce broad activity and weak evidence.
| Component | Action | Guardrail |
|---|---|---|
| Receivables | Invoice promptly, resolve disputes, set dated collection actions | Protect creditworthy sales and relationships |
| Inventory | Remove obsolete stock, improve reorder points | Protect service levels and stock availability |
| Payables | Negotiate terms before the due date | Do not surprise or starve key suppliers |
| Cash | Protect a minimum operating floor | Do not hide restricted cash |
| Accrued obligations | Forecast tax, payroll, renewals, and debt | Keep the liability record complete |
The J.P. Morgan working-capital benchmark defines the cash conversion cycle as the time between inventory purchases and cash collected from sales. That operating link is why receivables, inventory, and payables often deserve the first review.
Where the working capital formula stops
Working capital is a balance-sheet measure at a point in time. It does not tell you whether the business is profitable, whether next week’s payroll is covered, whether a customer will pay, or whether the company meets a lender covenant.
- Use a cash flow forecast for payment timing.
- Use an income statement for profit over a period.
- Use AR and inventory aging for asset quality.
- Use the lender’s exact definitions for covenant testing.
- Use an accountant for classification and reporting decisions.
The calculator gives you a disciplined operating view. It does not turn a rough balance sheet into audited evidence.
Frequently asked questions
What is the working capital formula?
Working capital equals current assets minus current liabilities. It is a dollar measure of short-term resources after near-term obligations.
Is positive working capital always good?
No. Old receivables, obsolete inventory, restricted cash, missing liabilities, or a bad payment calendar can make positive working capital look safer than the operating position.
What is the difference between working capital and current ratio?
Working capital is a dollar amount. Current ratio divides current assets by current liabilities, so it provides relative coverage that is easier to compare over time.
What is net working capital?
Net working capital usually means current assets minus current liabilities. Some analysts use an operating definition that excludes cash or debt, so confirm the definition before comparing results.
Can the working capital calculator replace financial statements?
No. It is an operating analysis built from the balances you enter. It does not classify accounts, reconcile the ledger, audit the numbers, or test lender covenants.
What to do next
Enter the balances from one reporting date, then lower the quality factors for assets that cannot turn into usable cash on time. Read the adjusted result beside the headline number.
Choose one component and put it in the Action Register with an owner, due date, and guardrail. A ratio becomes useful when it changes an operating decision.