Monthly Working Capital Formula
Learn how monthly net working capital, liquidity ratios, and month-to-month changes are calculated from current balances.
Monthly working capital estimates the short-term funds remaining after current liabilities are deducted from current assets at month-end. Reviewing it alongside current and quick ratios can help describe changes in short-term liquidity.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Net Working Capital
Where:
Add cash, receivables, inventory, and other current assets. Then subtract accounts payable and other current liabilities.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| cashBalance - Cash and cash equivalents | Readily available cash and bank balances at month-end. | currency |
| accountsReceivable - Accounts receivable | Customer amounts expected to be collected within one year. | currency |
| inventory - Inventory | Month-end value of stock held for sale or production. | currency |
| otherCurrentAssets - Other current assets | Other assets expected to be used, sold, or converted within one year. | currency |
| accountsPayable - Accounts payable | Unpaid supplier bills and trade payables due within one year. | currency |
| otherCurrentLiabilities - Other current liabilities | Other obligations expected to be settled within one year. | currency |
| previousWorkingCapital - Previous month working capital | Net working capital recorded at the prior month-end. | currency |
| totalCurrentLiabilities - Total current liabilities | Accounts payable plus other current liabilities. | currency |
Step-by-Step Calculation
Calculate total current assets
Combine the short-term asset balances included in the calculator.
totalCurrentAssets = cashBalance + accountsReceivable + inventory + otherCurrentAssets
Calculate total current liabilities
Combine short-term supplier obligations and other current obligations.
totalCurrentLiabilities = accountsPayable + otherCurrentLiabilities
Calculate net working capital
Subtract total current liabilities from total current assets.
netWorkingCapital = totalCurrentAssets - totalCurrentLiabilities
Calculate quick assets
Quick assets include cash and receivables, but exclude inventory and other current assets.
quickAssets = cashBalance + accountsReceivable
Calculate the current ratio
This expresses all current assets available per unit of current liabilities.
currentRatio = totalCurrentAssets / max(totalCurrentLiabilities, 1)
Calculate the quick ratio and monthly change
The quick ratio focuses on more readily available assets, while the change compares this month with the prior month.
quickRatio = quickAssets / max(totalCurrentLiabilities, 1); workingCapitalChange = netWorkingCapital - previousWorkingCapital
Example: Month-end working capital calculation
Total current assets
$25,000 + $42,000 + $33,000 + $5,000
$105,000
Total current liabilities
$28,000 + $17,000
$45,000
Net working capital
$105,000 − $45,000
$60,000
Current ratio
$105,000 ÷ $45,000
2.33x
Quick ratio
($25,000 + $42,000) ÷ $45,000
1.49x
Monthly working capital change
$60,000 − $54,000
+$6,000
Final Result
Net working capital is $60,000, up $6,000 from the prior month. The current ratio is 2.33x and the quick ratio is 1.49x.
Assumptions
- ✓All balances are measured consistently at the selected month-end.
- ✓Included assets and liabilities are expected to be realized or settled within one year or the normal operating cycle.
- ✓Accounts receivable are entered at a balance that reasonably represents expected collection.
- ✓The quick ratio includes only cash and accounts receivable.
- ✓The prior-month figure uses the same working-capital definition as the current month.
Limitations
- !A positive working capital balance does not guarantee that obligations can be paid exactly when due.
- !The calculation does not assess receivable aging, inventory salability, restricted cash, or payment due dates.
- !Classification of balances as current can vary with the business and accounting framework.
- !The ratios are descriptive measures and do not establish an appropriate liquidity level for every business.
Common Mistakes to Avoid
Including long-term assets, such as equipment or property, in current assets.
Omitting accrued expenses, short-term debt, taxes payable, or other current liabilities.
Using an accounts receivable amount that includes doubtful or uncollectible invoices without adjustment.
Including inventory in the quick ratio.
Comparing this month's result with a prior-month figure prepared using different account classifications.
Related Formulas
Frequently Asked Questions
What is the formula for monthly working capital?
Monthly net working capital equals total current assets minus total current liabilities at month-end.
How do you calculate the current ratio?
Divide total current assets by total current liabilities.
How do you calculate the quick ratio?
Divide cash plus accounts receivable by total current liabilities in this calculator.
Why can net working capital rise while the quick ratio falls?
An increase in inventory or other current assets can raise net working capital without increasing quick assets.
Can monthly working capital be negative?
Yes. It is negative when included current liabilities are greater than included current assets.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.