Working Capital: Formula, Example & Free Excel Template

You can have strong sales and still run short of money to pay bills. That often happens when cash gets tied up between inventory purchases, customer payments, and short-term obligations. Working capital helps you see that pressure before it becomes a bigger problem.

Working capital measures short-term liquidity. It is the difference between current assets and current liabilities: resources you expect to convert into cash or use within the short term, minus obligations you need to pay within the short term.

In practical terms, it helps you understand whether your business has enough short-term resources to keep operating without constantly struggling to meet payments. And it is important to remember that working capital is not the same as profit. A business can be profitable and still experience cash shortages.

At the end of this guide, you can download a free Excel working capital template to calculate the result with your own numbers. Go to the template ↓

Quick example:

An ecommerce business is selling well, but part of its sales are collected 30 days later. Meanwhile, it needs to pay for inventory, shipping, payroll, and advertising this week. If available cash is not enough, the business may delay payments even though its sales report looks healthy. This is a typical working capital problem: sales exist, but short-term liquidity is tight.

Table of Contents

What Is Working Capital and Why Does It Matter?

Working Capital in One Sentence

Working capital is the short-term financial cushion created by the difference between what your business can use or convert into cash soon and what it must pay soon.

More formally, working capital is the difference between current assets and current liabilities. It helps show whether a business has enough short-term resources to support operations and meet upcoming obligations.

Why Working Capital Matters for a Small Business

  • Business decisions: evaluate whether you can grow without creating unnecessary cash pressure, for example by buying more inventory, hiring staff, or expanding operations.
  • Management: monitor inventory turnover, customer collections, and payment terms with suppliers.
  • Daily operations: maintain enough short-term liquidity to restock, pay bills, and keep the business running without constant emergencies.

Working Capital Formula

The basic working capital formula is:

Working Capital = Current Assets − Current Liabilities

This formula helps answer an important question:

Does the business have enough short-term resources to cover its short-term obligations?

A positive result means current assets exceed current liabilities. A negative result means current liabilities are greater than current assets. But the number should always be interpreted together with the quality and timing of those assets and obligations.

Current Assets and Current Liabilities: What to Include

What Counts as a Current Asset?

Current assets are resources expected to be converted into cash, sold, or used within the normal operating cycle or generally within the next 12 months.

  • Cash and bank accounts: money available for normal business payments.
  • Accounts receivable: sales already made but not yet collected from customers.
  • Inventory: products held for sale or materials expected to be used in the business.
  • Prepaid expenses or recoverable advances: certain short-term amounts already paid that will provide future benefit or be recovered.
  • Other current assets: short-term resources that are reasonably expected to be converted into cash or used during the operating cycle.

Example: a small retailer has $2,000 in cash, $6,000 in bank accounts, $3,000 in accounts receivable, and $9,000 in inventory. Its total current assets are $20,000.

A machine, vehicle, building, or other long-term asset is generally not included in current assets simply because it has value. Working capital focuses on the short term.

What Counts as a Current Liability?

Current liabilities are obligations the business expects to pay within the short term, generally within the next 12 months or operating cycle.

  • Accounts payable: amounts owed to suppliers for products, inventory, or services already received.
  • Taxes payable: short-term tax obligations that have already been incurred.
  • Payroll payable: wages, commissions, or other payroll-related amounts earned but not yet paid.
  • Short-term debt: loans, credit balances, or the portion of debt due within the next year.
  • Utilities and operating bills payable: expenses already incurred but not yet paid.
  • Other current liabilities: short-term obligations expected to require payment soon.

Example: a restaurant owes $7,000 to suppliers and has $1,500 in short-term taxes payable. Its current liabilities total $8,500.

Quick Check: What Usually Belongs in Working Capital?

Usually included: cash, bank balances, accounts receivable, inventory, accounts payable, taxes payable, payroll payable, and short-term debt.

Usually excluded: long-term machinery, vehicles, buildings, long-term investments, and the portion of debt that is not due in the short term.

A common mistake is mixing short-term operating items with long-term assets and financing. Working capital is designed to evaluate the short-term operating position, not the total value of the business.

How to Calculate Working Capital Step by Step

  1. Add your current assets.
  2. Add your current liabilities.
  3. Subtract current liabilities from current assets:
    Working Capital = Current Assets − Current Liabilities

You can calculate working capital regularly, for example each month, to see whether the short-term financial position is improving, remaining stable, or becoming more constrained.

If you already track business transactions but need a clearer record of income and expenses, you can also use the small business income and expense spreadsheet.

Working Capital Example

Consider a small neighborhood store with the following balances:

ItemAmount
Cash and Bank Accounts$8,000
Accounts Receivable$4,000
Inventory$12,000
Total Current Assets$24,000
Accounts Payable$10,000
Taxes Payable$2,000
Short-Term Debt$3,000
Total Current Liabilities$15,000

Calculation:

  • Current Assets = $8,000 + $4,000 + $12,000 = $24,000
  • Current Liabilities = $10,000 + $2,000 + $3,000 = $15,000
  • Working Capital = $24,000 − $15,000 = $9,000

The business therefore has $9,000 in positive working capital.

That means current assets exceed current liabilities by $9,000. However, the business should still look at how quickly accounts receivable will be collected, how easily inventory can be sold, and when liabilities are due.

A positive working capital balance does not automatically mean the business has enough cash available every day.

If you want to calculate this with your own figures, the free Excel template later in this guide automatically totals current assets, current liabilities, and working capital. Go to the template ↓

How to Interpret the Result

Working capital should not be interpreted only as positive or negative. You also need to understand what is creating the result and whether the business can turn its current assets into usable cash quickly enough.

Positive Working Capital

What it means: current assets are greater than current liabilities.

This generally gives the business more short-term flexibility, but the composition matters. A large amount of slow-moving inventory or difficult-to-collect receivables may make the position less comfortable than the headline number suggests.

  • Monitor working capital regularly.
  • Review slow-moving or excess inventory.
  • Follow up on overdue customer balances.
  • Use available liquidity deliberately rather than allowing unnecessary cash or inventory to accumulate.

Low Working Capital

What it means: current assets may still exceed current liabilities, but the margin is relatively small.

A modest decline in sales, a delayed customer payment, an unexpected expense, or a large inventory purchase could create short-term pressure.

  • Collect faster: follow up on invoices, request deposits where appropriate, or review payment terms.
  • Control purchasing: buy according to realistic demand and inventory turnover.
  • Review supplier terms: where appropriate, negotiate payment schedules that better match your operating cycle.
  • Protect operating cash: avoid using short-term liquidity for investments that should be financed over a longer period.

Negative Working Capital

What it means: current liabilities are greater than current assets.

For many small businesses, this is a warning sign because more short-term obligations are coming due than the business currently has in short-term resources.

  • Prioritize critical obligations: identify payments that directly affect payroll, taxes, supply continuity, or essential operations.
  • Release cash from inventory: reduce slow-moving stock and postpone unnecessary purchases.
  • Accelerate collections: contact customers with overdue balances and review credit policies.
  • Review short-term debt: determine whether longer repayment terms would better match the underlying need.
  • Renegotiate payment terms: where possible, align supplier payment dates more closely with customer collection cycles.

Negative working capital does not have exactly the same meaning in every industry or business model, but for a small business it deserves careful analysis rather than being ignored.

7 Practical Ways to Improve Short-Term Liquidity

  1. Reduce slow-moving inventory.
    Identify products that tie up cash without generating enough sales and use promotions, bundles, or purchasing adjustments to reduce excess stock.
  2. Collect accounts receivable faster.
    Send invoices promptly, follow up on overdue accounts, review customer credit terms, and consider deposits when appropriate.
  3. Negotiate better supplier payment terms.
    Longer or better-aligned payment terms can reduce the gap between paying suppliers and receiving cash from customers.
  4. Purchase according to demand and turnover.
    A discount is not always valuable if it causes the business to hold unnecessary inventory for months.
  5. Separate operating cash from growth investments.
    Avoid using money needed for payroll, inventory, taxes, and routine operations to fund large long-term projects.
  6. Avoid using short-term financing for long-term needs.
    Equipment, major renovations, or other long-lived investments may require financing structures that match their useful life.
  7. Review recurring operating costs.
    Look for duplicate services, waste, unnecessary subscriptions, inefficient purchasing, and other costs that create persistent pressure on liquidity.

If recurring costs are putting pressure on liquidity, understanding your fixed and variable costs can help you identify which expenses are easier to adjust and which require longer-term changes.

Working Capital vs. Cash Flow

Working capital and cash flow are related, but they measure different things.

PointWorking CapitalCash Flow
What it isCurrent Assets − Current LiabilitiesCash moving into and out of the business
What it showsA short-term liquidity position at a point in timeHow cash changes over a period of time
Main useEvaluate whether short-term resources exceed short-term obligationsPlan future payments and cash shortages
Typical riskInventory or receivables may look liquid but take time to convert into cashPayments may be due before expected cash receipts arrive

For example, a business can have positive working capital because it owns a large amount of inventory and has substantial accounts receivable. But if that inventory sells slowly and customers pay late, the business can still experience a cash shortage.

Working capital gives you a snapshot. A cash flow forecast helps you see when money is expected to come in and go out.

Common Mistakes to Avoid

  • Including long-term assets. Machinery, vehicles, and buildings generally do not belong in current assets.
  • Forgetting short-term obligations. Taxes payable, payroll payable, and upcoming debt payments can materially change the result.
  • Overvaluing inventory. Obsolete, damaged, or extremely slow-moving stock may not be as liquid as the accounting balance suggests.
  • Treating all accounts receivable as cash. Customer balances that are overdue or difficult to collect may not convert into cash when needed.
  • Including all long-term debt. Working capital focuses on the portion due in the short term.
  • Looking only at the final number. Two businesses can have the same working capital but very different inventory, collection, and payment patterns.
  • Calculating it only once. Working capital changes as the business sells, buys inventory, collects customers, and pays obligations.

Download the Free Working Capital Excel Template

If you want to calculate working capital with your own business numbers, use the free Working Capital Excel Template.

The workbook includes a preloaded example so you can understand how the calculation works before replacing the figures with your own.

You only need to enter your current assets and current liabilities. The spreadsheet automatically calculates:

  • Total Current Assets
  • Total Current Liabilities
  • Working Capital
  • A simple interpretation of the result

The template includes dropdown categories such as Cash and Bank Accounts, Accounts Receivable, Inventory, Accounts Payable, Taxes Payable, Payroll Payable, and Short-Term Debt.

Working Capital = Current Assets − Current Liabilities

Important: This spreadsheet is a practical management tool. The working capital result should be interpreted together with cash flow, inventory quality, collection timing, and upcoming obligations.

Frequently Asked Questions About Working Capital

What is the working capital formula?

Working Capital = Current Assets − Current Liabilities.

How do I calculate working capital for my business?

Add your current assets, add your current liabilities, and subtract current liabilities from current assets.

Is working capital the same as net working capital?

The terms are often used interchangeably when referring to current assets minus current liabilities. However, some financial analyses use more specific versions of net working capital that exclude certain items, so always check how the term is being defined in the analysis you are using.

Is positive working capital always good?

Not automatically. Positive working capital means current assets exceed current liabilities, but the quality of those assets matters. Excess inventory, slow collections, or cash that is not being used efficiently can still create problems.

Is negative working capital always bad?

Not in every business model, but for many small businesses it is an important warning sign because short-term obligations exceed short-term assets. It should be analyzed together with collection speed, inventory turnover, supplier terms, and cash flow.

How much working capital should a small business have?

There is no single amount that is appropriate for every business. The right level depends on factors such as inventory needs, customer payment terms, supplier terms, seasonality, operating expenses, growth plans, and the reliability of incoming cash.

What is a simple working capital example?

If a business has $20,000 in current assets and $12,000 in current liabilities:

$20,000 − $12,000 = $8,000 in working capital.

Working Capital: Key Takeaways and Next Steps

Key Takeaways

  • Working capital measures short-term liquidity.
  • The formula is Current Assets − Current Liabilities.
  • A positive result provides more short-term flexibility, but it still needs interpretation.
  • A low or negative result may signal pressure from inventory, receivables, short-term debt, or payment timing.
  • Working capital can often be improved through better inventory management, faster collections, supplier terms, and tighter control of operating costs.
  • Working capital and cash flow should be reviewed together.

What to Do Next

  1. Calculate your current working capital using the latest available figures.
  2. Identify what is creating the most pressure: slow inventory, late customer payments, or short-term obligations.
  3. Choose one or two actions that can improve liquidity without disrupting operations.
  4. Review working capital regularly instead of treating it as a one-time calculation.
  5. Compare the result with your cash flow forecast to understand both your current position and future cash needs.

Discover more from

Subscribe to get the latest posts sent to your email.

Scroll to Top