A working capital calculator works out the difference between what a business owns in the short term and what it owes in the short term. Enter your current assets, such as cash, receivables and inventory, and your current liabilities, such as payables and debt due within a year. The calculator gives the working capital, shows whether it is positive or negative, and can show how it changed since last period.
The working capital formula
Working capital = current assets − current liabilities
The OpenStax Principles of Finance text gives this formula: net working capital is current assets minus current liabilities. It describes current assets as resources that are cash, near cash or expected to be turned into cash within a year. It lists cash, accounts receivable and inventory as current assets and accounts payable as a current liability.
How to use the working capital calculator
- Enter the current assets: cash, receivables, inventory and any others.
- Enter the current liabilities: payables, the current portion of debt and any others.
- Optionally enter last period's working capital to see the change.
- Press Calculate.
Worked example
A business has cash of 20,000, receivables of 35,000 and inventory of 45,000, so its current assets are 100,000. It owes 30,000 to suppliers, has 10,000 of debt due within a year and 5,000 of other current liabilities, so its current liabilities are 45,000. Its working capital is 100,000 − 45,000 = 55,000. If last period's working capital was 40,000, it has risen by 15,000. The numbers are an illustration, not a real company.
What the result means
The article explains that positive working capital implies there are sufficient current assets to cover current liabilities, and that negative working capital means a company may be unable to meet its current obligations. The calculator shows which side of zero you are on. Positive working capital is the usual position of a business that is meeting its short-term bills, and a negative figure is a prompt to look at when cash will arrive and when payments fall due.
Gross working capital and trade working capital
The article distinguishes related measures. Gross working capital is simply the current assets. Trade working capital is a narrower measure that leaves out cash and focuses on the funds tied up in receivables, inventory and payables. If you want the trade figure, enter zero for cash and for any other cash-like items. The calculator's headline figure follows the main definition: current assets minus current liabilities.
Changes in working capital
The article notes that an increase in net working capital indicates either a rise in current assets or a fall in current liabilities. A rise tied up in inventory or receivables means cash has been used to fund them, while a rise because payables fell means debts were paid down. Entering last period's figure shows the size of the change, and comparing the pieces of the current and previous balance sheets shows which accounts caused it.
The working capital cycle
Working capital is closely tied to how long it takes a business to turn inventory into sales and sales into cash. The article describes this as the working capital cycle, which links to the cash conversion cycle. To measure that timing, the cash conversion cycle calculator and the accounts receivable days calculator are the natural next steps, and the operating cash flow calculator shows the cash generated by operations.
Preparing the inputs
Take the figures from the same balance sheet date, and check that each item is classed as current: due or collectable within twelve months. Long-term debt is not included except for the part due within the year, which is why the calculator asks for the current portion. If you have totals for current assets and current liabilities, enter the total of the assets in one of the asset boxes and the total of the liabilities in one of the liability boxes.
A second example with negative working capital
A business holds cash of 8,000 and inventory of 12,000, so its current assets are 20,000. It owes 18,000 to suppliers and has 7,000 of debt due within the year, so its current liabilities are 25,000. Its working capital is 20,000 − 25,000 = −5,000. The calculator reports the figure as negative, which the article describes as a risk of being unable to meet current obligations. It is worth checking when customers are due to pay and when the payments are due before drawing conclusions.
Using the figure over time
A single day's working capital can mislead, because it moves with the season and with the timing of payments. Calculate it at several balance sheet dates and compare the figures. A steady figure suggests a stable position, while one that falls over several periods deserves attention. Use the change box each period to track the movement, and look at the individual accounts to see what is driving it.
Common mistakes
- Including long-term debt. Only the part due within a year counts.
- Mixing dates. Use one balance sheet date.
- Forgetting other current items. Add accruals and prepayments where relevant.
- Reading it as cash on hand. It is a balance, not cash.
What next
Use this often? Add Working Capi to your Home screen.
Frequently asked questions
How does a working capital calculator work?
It adds up current assets and current liabilities and subtracts the second from the first.
What is the working capital formula?
Working capital = current assets − current liabilities, as the OpenStax Principles of Finance text gives it.
What does negative working capital mean?
Current liabilities exceed current assets, so the company may struggle to meet short-term obligations.
What is trade working capital?
A narrower measure that excludes cash.
What does a rise in working capital show?
Either current assets rose or current liabilities fell.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.