A business can report growing EBITDA every quarter while quietly running out of cash. The P&L will not warn you. The working capital trends will — if you know how to read them.

Working capital is where operational decisions show up as cash consequences — and it is the part of financial reporting that most P&L-focused finance teams consistently underread. The income statement tells you whether the business is profitable. The working capital position tells you whether that profit is real, whether it is collecting, and whether it has enough runway to keep operating while it waits. For a Finance Controller or Finance BP, it is one of the most diagnostic tools available — and one of the most consistently underused.

The Three Levers

Working capital is the difference between current assets and current liabilities. In practice, the analytical work centres on three components: receivables, payables, and inventory. Each has a ratio that measures its efficiency, and each ratio tells a different story about what is happening inside the business.

Days Sales Outstanding (DSO)

DSO measures how long, on average, it takes the business to collect cash after a sale is made.

\[\text{DSO} = \frac{\text{Trade Receivables}}{\text{Revenue}} \times \text{Number of Days}\]

A business with ₹120L in trade receivables and ₹600L in quarterly revenue has a DSO of 18 days. That means it is collecting, on average, 18 days after invoicing. Whether that is good or bad depends entirely on the payment terms the business offers. If standard terms are 30 days, a DSO of 18 is strong. If standard terms are 14 days, a DSO of 18 means collections are running late and cash is sitting uncollected in the receivables ledger.

The more useful analysis is not the absolute DSO figure but the direction and the composition. A DSO that has risen from 22 to 31 days over three quarters is a signal worth investigating regardless of what the terms say. And a DSO that looks healthy in aggregate can hide a concentration problem — three large customers paying on time masking a long tail of smaller customers who are not.

Days Payable Outstanding (DPO)

DPO measures how long the business takes to pay its suppliers.

\[\text{DPO} = \frac{\text{Trade Payables}}{\text{Cost of Goods Sold}} \times \text{Number of Days}\]

A business with ₹80L in trade payables and ₹400L in quarterly COGS has a DPO of 18 days. A higher DPO generally means the business is holding onto its cash longer before paying out — which improves the cash conversion cycle. But the direction of the change matters as much as the number, and for a reason I will come back to.

Days Inventory Outstanding (DIO)

DIO measures how long inventory sits before it is sold.

\[\text{DIO} = \frac{\text{Inventory}}{\text{Cost of Goods Sold}} \times \text{Number of Days}\]

For a manufacturing or retail business, DIO is often the single largest driver of working capital. Inventory that sits in a warehouse is cash that has been spent but not yet recovered. A rising DIO can signal demand problems, procurement inefficiency, or a product mix shift toward slower-moving SKUs — none of which shows up cleanly in the P&L until the write-downs hit.

The Cash Conversion Cycle

The three ratios combine into a single metric that tells you how long the business’s cash is tied up in its operating cycle.

\[\text{CCC} = \text{DSO} + \text{DIO} - \text{DPO}\]

A business with DSO of 30, DIO of 45, and DPO of 20 has a CCC of 55 days. That means, on average, cash leaves the business 55 days before it comes back. Every rupee of revenue requires 55 days of financing. The shorter the CCC, the less working capital the business needs to sustain the same level of revenue — which means more cash available for investment, debt repayment, or distribution.

A CCC of 55 days in a business growing at 30% annually is a meaningful constraint. As revenue scales, the working capital requirement scales with it. A business that does not model this will find itself profitable on paper and cash-constrained in practice — which is exactly the scenario the opening paragraph described.

The Dangerous Improvement

Here is the working capital signal that catches even experienced finance professionals off guard: a DPO that is rising rapidly is not always good news.

In a healthy business, DPO improves because the finance team has negotiated better payment terms with suppliers — longer windows, early payment discounts in reverse. That is structural improvement backed by commercial leverage.

In a stressed business, DPO improves because the business is simply paying its suppliers later than agreed. The invoices are overdue. The suppliers have started calling. The business is managing its cash by stretching its creditors rather than by improving its operations.

Both show up in the ratio as an improving DPO. Both improve the CCC. Only one is sustainable.

The way to distinguish them is not in the ratio itself but in the supporting information: whether supplier payment terms have actually been renegotiated, whether the payables ageing schedule shows a growing overdue balance, and whether supplier relationships are under strain. A DPO that is rising alongside an ageing report that is deteriorating is a warning sign, not a performance improvement.

I came across this dynamic repeatedly during credit analysis work — assessing lending proposals where a borrower’s working capital ratios looked reasonable in aggregate but the payables ageing told a different story. The ratio gave a false sense of stability. The ageing revealed the cash stress underneath. It is the same principle in FP&A: the ratio is the starting point of the analysis, not the conclusion.

How FP&A Teams Model Working Capital

Most three-statement financial models treat working capital as a simple percentage of revenue — receivables at x% of sales, payables at x% of COGS, inventory at x% of COGS. That assumption is defensible for a stable, mature business in a steady-state environment. It breaks down everywhere else.

A more rigorous approach builds each working capital component from its underlying driver.

Receivables are driven by revenue and DSO. If you know your revenue forecast and your expected DSO — which should come from the commercial team’s view of customer mix and payment behaviour — you can calculate the expected receivables balance for each forecast period directly. Any assumption that changes DSO (a new large customer with longer payment terms, a collections initiative, a shift toward prepaid contracts) flows through to the balance sheet and cash flow automatically.

Payables are driven by COGS and DPO. If your cost structure includes a planned supplier renegotiation, that shows up as a DPO assumption change and flows through to the payables balance. If you are modelling a scenario where the business comes under margin pressure, you can stress-test the DPO assumption to reflect the risk that payment timelines slip.

Inventory is driven by DIO and COGS. In a business with a complex product mix, DIO is best modelled by category rather than in aggregate — a single blended DIO assumption will miss the dynamics of fast-moving versus slow-moving inventory, and it will miss the working capital impact of a mix shift even when total revenue holds flat.

Building the model this way means that working capital is responsive to the operational assumptions in the forecast rather than being a passive percentage that moves mechanically with revenue. It also means that when you present the forecast to the CFO, you can explain why working capital is projected to absorb cash in a given quarter — or release it — in terms that connect to decisions the business is actually making.

Presenting Working Capital to the CFO

The working capital summary that earns attention in a CFO presentation is not a table of ratios. It is a narrative that connects the ratios to the decisions behind them and the implications ahead.

The structure that works: current position, direction of travel, root cause, and cash impact.

Current position: “DSO has risen from 28 to 36 days over the past two quarters, driven primarily by the enterprise segment where average collection has extended to 45 days against standard terms of 30.”

Direction of travel: “At the current trajectory, DSO reaches 40 days by Q3, which implies an additional ₹45L tied up in receivables relative to our budget assumption.”

Root cause: “The extension is concentrated in three accounts that have each requested extended terms as part of contract renewals — commercial has agreed to 45-day terms in exchange for multi-year commitments.”

Cash impact: “The working capital drag of ₹45L is partially offset by a ₹20L improvement in DPO following the renegotiated supplier terms agreed in February, leaving a net working capital headwind of ₹25L against the Q3 cash forecast.”

That is a complete picture. It tells the CFO what is happening, why, and what it means for the cash position — with enough specificity to make a decision and enough connection to the business context to make it credible.

The Working Capital Review in the Planning Cycle

Working capital rarely gets its own section in the annual budget. It should.

A budget that plans revenue and costs without explicitly planning the working capital implications will systematically underestimate the cash required to fund growth. A business budgeting for 40% revenue growth with a 55-day CCC needs to plan for the working capital investment that growth requires — and that investment is not optional, it is the cash that funds the gap between delivering and collecting.

The working capital review in the planning cycle should cover three things: the assumptions behind each ratio and who owns them, the cash flow impact of the working capital plan under the base, bull, and bear scenarios, and the initiatives — collections, supplier terms, inventory reduction — that are expected to move the ratios and the timeline and owner for each.

A working capital plan built this way is one of the most useful things the FP&A function produces. It connects the commercial decisions being made about customer terms and product mix to the cash position the treasury team is managing — and it gives the CFO a clear view of where the levers are before the cash constraint appears.

Working capital sits at the heart of the driver-based modelling approach I covered in Driver-Based Budgeting: Moving Beyond Line-Item Extrapolation — receivables, payables, and inventory are all driven by operational decisions, not accounting conventions. And when working capital moves unexpectedly, the variance shows up in the actuals review process covered in Variance Analysis: Making the Monthly Actuals Review Actually Useful as a cash flow variance that requires the same root cause rigour as any revenue or cost miss.

I would love to hear how your team approaches working capital in the planning cycle — whether it gets its own section or gets absorbed into the cash flow forecast without explicit ratio analysis. Let’s connect.