There’s a trap that catches even well-run businesses. The company is growing, revenues are up, the P&L looks fine and then one quarter, they’re scrambling to pay suppliers. Not because the business is broken. Just because cash is stuck somewhere in the system.

This is exactly the problem working capital forecasting tries to solve.

At its core, a working capital forecast answers one practical question: will the business have enough short-term money to keep things running? Not in theory, not on paper actually, operationally, in the bank.

First, What Is Working Capital?

Working capital is the difference between what a business owns in the short term and what it owes in the short term.

Working Capital = Current Assets − Current Liabilities

Current assets are things like cash, inventory, and money customers owe you. Current liabilities are what you owe to suppliers, lenders, or employees.

If current assets exceed current liabilities, you have positive working capital. If it’s the other way around, it’s negative.

But here’s where people get tripped up: positive working capital isn’t automatically good, and negative isn’t automatically bad. It depends entirely on the business. A retailer that collects cash from customers before paying suppliers might run with negative working capital by design and that’s a sign of strength, not stress.

Why Forecasting This Actually Matters

Sales growth doesn’t automatically translate to cash flow. This is probably the most misunderstood thing about working capital.

Say a company pushes hard on sales by extending 90-day credit terms to customers. Revenue goes up, everyone’s happy but the cash hasn’t arrived yet. Meanwhile, the company still needs to pay salaries, buy raw materials, and keep the lights on. That gap has to be funded from somewhere.

Same issue with inventory. If a manufacturer needs to stock up before a busy season, cash goes out months before any revenue comes in.

A working capital forecast makes these cash needs visible before they become emergencies. That’s the whole point.

The Three Numbers That Drive the Forecast

Most working capital forecasts come down to three line items: receivables, inventory, and payables. Everything else flows from these.

Receivables

This is money customers owe the company. If you sell on credit which most B2B businesses do you’re recording revenue before cash actually lands.

The standard way to forecast receivables is through Days Sales Outstanding (DSO), which tells you how long customers take to pay on average.

Receivables = Revenue × DSO ÷ 365

So if a company expects ₹120 crore in revenue and customers typically pay in 60 days: ₹120 crore × 60 ÷ 365 = ₹19.73 crore sitting in receivables at any given time.

That’s nearly ₹20 crore tied up not lost, but not usable either.

Inventory

Raw materials, work-in-progress, finished goods waiting to be sold all of this is cash that’s been spent but hasn’t come back yet.

Inventory is forecast using Days Inventory Outstanding (DIO).

Inventory = Cost of Goods Sold × DIO ÷ 365

If COGS is ₹80 crore and average inventory holding is 45 days: ₹80 crore × 45 ÷ 365 = ₹9.86 crore locked in inventory.

Payables

This one works the other way. If suppliers let you pay 30 days later, that’s effectively free short-term financing. You have the goods, but cash hasn’t gone out yet.

Payables = Cost of Goods Sold × DPO ÷ 365

At ₹80 crore COGS and 30 days payable terms: ₹80 crore × 30 ÷ 365 = ₹6.58 crore effectively funded by suppliers.

Putting It Together: A Simple Example

Take a company with:

Revenue: ₹120 crore
COGS: ₹80 crore
DSO: 60 days, DIO: 45 days, DPO: 30 days

Receivables = ₹19.73 crore Inventory = ₹9.86 crore Payables = ₹6.58 crore

Net Working Capital = ₹19.73 + ₹9.86 − ₹6.58 = ₹23.01 crore

That’s the cash the business needs to fund its operating cycle at this point in time.

What Matters More: The Change

In financial modelling, nobody obsesses over the level of working capital. What drives the analysis is the change.

Change in Working Capital = This year’s NWC − Last year’s NWC

If working capital goes up, that means more cash is being absorbed into the business less available for investors, debt repayment, or reinvestment.

If working capital goes down, cash is being released. The business is becoming more efficient, or collecting faster, or stretching payments.

If the company’s NWC was ₹18 crore last year and ₹23 crore this year, that ₹5 crore increase means ₹5 crore less in free cash flow. It gets deducted directly. This connection between working capital and cash flow is why it matters so much in DCF models.

Why an Increase in Working Capital Hurts Cash Flow

It seems counterintuitive at first. More assets, more receivables, more inventory shouldn’t that be good?

Think about what it actually represents. Higher receivables means customers haven’t paid yet revenue is on the books, but cash isn’t in hand. Higher inventory means the company bought goods and hasn’t sold them yet cash is out, revenue hasn’t come in.

Payables work the opposite way. If the company owes suppliers but hasn’t paid yet, cash is still in hand. So higher payables help short-term cash.

This is why fast-growing companies sometimes have terrible cash flow despite strong profits. Revenue scales. But so does the cash tied up in supporting that revenue.

Working Capital in a Financial Model

Typically, analysts forecast working capital by linking it to revenue and cost assumptions. The cleanest method uses the days-based approach (DSO, DIO, DPO) because it mirrors how the business actually operates.

If a company’s average collection period improves from 60 days to 45 days, receivables drop and cash flow improves the model captures that automatically.

Here’s how the numbers evolve when a business grows and becomes operationally tighter:

	Year 1	Year 2
Revenue	₹120 crore	₹150 crore
COGS	₹80 crore	₹100 crore
DSO	60 days	55 days
DIO	45 days	40 days
DPO	30 days	35 days
Receivables	₹19.73 crore	₹22.60 crore
Inventory	₹9.86 crore	₹10.96 crore
Payables	₹6.58 crore	₹9.59 crore
Net Working Capital	₹23.01 crore	₹23.97 crore

Revenue grew by ₹30 crore a 25% jump. But working capital only increased by ₹0.96 crore, because the company collected faster, cleared inventory quicker, and stretched supplier payments a little. That’s what good working capital management looks like from the outside.

The Cash Conversion Cycle

There’s a useful shorthand for all of this: the Cash Conversion Cycle (CCC).

CCC = DSO + DIO − DPO

Using the Year 1 numbers above: 60 + 45 − 30 = 75 days

This means the company takes 75 days to convert cash invested in operations back into actual cash. The lower this number, the better it means money is cycling through faster and less of it is tied up at any given time.

Some businesses manage to push this number negative they collect before they pay. That’s a genuinely powerful position to be in.

Working Capital in a DCF Valuation

Free Cash Flow = Operating Profit After Tax + Depreciation − Capex − Increase in Working Capital

It’s right there in the formula. A ₹5 crore improvement in working capital management, say, collecting 15 days faster flows directly into free cash flow. Over a multi-year DCF, that compounds.

Using the earlier example: if working capital increases by ₹3 crore instead of ₹8 crore, FCF goes from ₹32 crore to ₹37 crore. Same business, same operations just tighter capital management.

Negative Working Capital: When It’s a Feature, Not a Bug

Some business models are built around negative working capital. Certain retailers, subscription services, quick-service restaurants they receive customer payments before paying suppliers. Cash comes in, then goes out later.

When the business is stable, this is actually a competitive advantage. The company is essentially getting interest-free financing from customers.

The risk appears when things break down. If sales slow or suppliers tighten terms, that negative working capital can flip from being a cushion to a crisis very quickly.

Common Mistakes Worth Avoiding

The forecasts that go wrong are usually the ones that aren’t grounded in business logic. Using a flat percentage of revenue for all three line items, year after year, without checking whether credit terms or inventory policies have changed, that’s how models produce numbers that look clean but don’t reflect reality.

Another common error: assuming payables can keep growing indefinitely. That’s not how supplier relationships work. At some point, terms get squeezed back.

And then there’s the most fundamental mistake ignoring the gap between accounting profit and actual cash. A company can be profitable and cash-starved at the same time. Working capital is usually where that gap lives.

Key Takeaways (for CFA and Finance Students)

Working capital forecasting links receivables to revenue (via DSO), inventory to COGS (via DIO), and payables to COGS (via DPO). The change in net working capital feeds directly into free cash flow an increase is a cash outflow, a decrease is a cash inflow. The Cash Conversion Cycle (DSO + DIO − DPO) shows how efficiently a business converts operations into cash. All of this feeds into DCF models and valuation.

Financial Statement Analysis

Working Capital Forecast: What It Is, How It Works, and Why Analysts Care