The Working Capital Cycle: DSO, DIO and DPO Read Together

The working capital cycle counts the days between paying a supplier and collecting from a customer. The cycle adds days sales outstanding (DSO), the days sales sit unpaid, to days inventory outstanding (DIO), the days stock sits unsold, then subtracts days payable outstanding (DPO), the days the business takes to pay its own suppliers. The result is the number of days the business funds itself, and a cycle that lengthens consumes cash whether or not profit is rising.

Here is what sits underneath that. Money leaves a business on the day it settles with a paper mill and comes back on the day a school settles with it, and those two days are usually months apart. Somebody has to hold the business up in between. Days, rather than rupees, make the gap comparable between businesses: a business twice the size will have twice the receivables and roughly the same number of days, so days strip out scale and leave behind the change itself.

Anjani Stationers, an invented notebook maker, shows the whole sequence. Its cycle went from 129.6 days in year one to 143.1 days in year two while its reported profit stayed comfortable, and the three day counts, each divided by its own base, explain where the extra days came from and what they cost in rupees.

What is the working capital cycle, in plain words?

Picture a stationery business the week before a school year starts. Paper arrives in the godown. The paper sits there while notebooks are cut, stitched and stacked. At some point the paper mill wants paying, and that payment goes out long before the last notebook has left the building. Eventually the notebooks are delivered to a school and an invoice is raised, and the school pays sixty, ninety, a hundred and twenty days later. Between the day the mill was paid and the day the school pays, the business has been carrying the whole cost of that trade out of its own pocket.

The working capital cycle is that carrying period expressed as a number of days, and it exists because the outflow and the inflow of a single trade almost never happen on the same day. A wedding caterer has an identical shape, at a scale small enough to hold in mind. The caterer buys vegetables, rice and gas on Monday. The vegetables sit until Saturday. The wedding happens on Saturday and the hosts settle the bill three weeks later. If the vendor gave the caterer a week's credit, the caterer paid on the following Monday and was paid on the twenty-eighth day. Twenty-one days of somebody else's dinner were financed by the caterer. Twenty-one days is the caterer's cash conversion cycle, and nothing about the caterer's profit reveals that it was there.

Two things follow immediately from that picture, and both are worth fixing before any arithmetic. The first is that the cycle is a measurement of timing, not of size or of quality. A twenty-one day cycle on a caterer and a twenty-one day cycle on a stationery business mean the same thing about timing and completely different things about the rupees involved. The second is that the cycle can be negative. If the paper mill gave a hundred and eighty days of credit and the schools paid on delivery, the business would be holding other people's money for the whole period rather than funding anything, and the number would come out below zero. A negative cycle is not a trick. Several kinds of business genuinely run that way.

What is days sales outstanding, and what base does it use?

Days sales outstandingThe average number of days between raising an invoice and being paid for it, worked out from the receivables balance rather than from individual invoices. answers one question: on average, how long does an invoice sit before the money for it arrives? The invoices themselves are not needed to work it out. The receivables balance, divided by revenue for the year and multiplied by 365, gives the answer. The division asks what fraction of a year's sales is still sitting unpaid, then expresses that fraction in days.

Days sales outstanding divides receivables by revenue, and revenue is the correct baseThe figure on the bottom of the fraction, the one the balance is divided by. Choosing it is not a matter of taste: it has to be measured in the same units as the balance on top, or the answer is not a number of days at all. here for a reason that is easy to state: a receivable is a claim for the selling price, so it is measured in revenue rupees and has to be divided by revenue rupees. This matters more than it sounds, and it is the hinge on which the whole subject turns. A receivable of Rs 95,00,000 is not a claim for what the paper cost. The receivable is a claim for what the school agreed to pay, gross margin included. Dividing it by anything other than revenue compares two quantities that are not measured the same way, and the answer stops being days.

Work Anjani Stationers through, one year at a time. In year zero, gross receivables of Rs 30,00,000 sat against revenue of Rs 1,95,00,000, so the fraction is 0.1538 and 0.1538 of 365 days is 56 days. In year one, Rs 78,00,000 against Rs 2,40,00,000 gives 0.325, and 0.325 of 365 days is 119 days. In year two, Rs 95,00,000 against Rs 2,70,00,000 gives 0.3519, and that is 128 days. Fifty-six, then a hundred and nineteen, then a hundred and twenty-eight. The number of days Anjani Stationers waits to be paid has more than doubled in two years, and it did that while revenue was growing. Rising revenue beside slowing collection is exactly the combination that is easy to miss.

One presentational point matters when the three are added together. Quoted on its own, days sales outstanding is normally stated to the nearest whole day, and 56, 119 and 128 are whole-day statements. Carried to one decimal place for the arithmetic that follows, year one is 118.6 days and year two is 128.4 days. Both statements are the same measurement. Only the rounding differs, and whenever day counts are added together the one-decimal version keeps the totals honest.

What is days inventory outstanding, and why is its base not revenue?

Days inventory outstandingThe average number of days a unit of stock sits in the building before it is sold, worked out from the closing inventory balance rather than from stock records. asks how long stock sits before it leaves. Same shape as before: take the inventory balance, divide it by a base, multiply by 365. The only question is which base, and this is the single most common error on the whole subject.

Days inventory outstanding divides inventory by the cost of materials consumedThe value of raw materials actually used up in production during the year, taken straight from the profit and loss statement. No gross margin sits inside a cost figure., never by revenue, because inventory is carried on the balance sheet at what it cost and not at what it will eventually sell for. Hold the two figures side by side and the reason becomes obvious rather than a rule to memorise. Anjani Stationers' godown holds Rs 28,00,000 of paper and part-finished notebooks. The Rs 28,00,000 is what the paper cost. A margin has not been added yet, and the balance is not what the notebooks will fetch from a school. Revenue for the year was Rs 2,70,00,000 and the cost of materials consumed was Rs 1,48,50,000, and the difference between those two is margin, wages, power, rent and everything else. Dividing a cost balance by a revenue figure quietly divides by the margin as well, and the answer comes out far too small.

Run both and look at what happens. Rs 28,00,000 divided by Rs 2,70,00,000 is 0.1037, and 0.1037 of 365 days is 37.9 days. Rs 28,00,000 divided by Rs 1,48,50,000 is 0.1886, and 0.1886 of 365 days is 68.8 days. The two answers differ by nearly a month of trading on exactly the same stock and exactly the same year. The second one is right. In year one the same calculation on Rs 19,00,000 of inventory and Rs 1,32,00,000 of cost of materials consumed gives 52.5 days, so Anjani Stationers' stock sat 16.3 days longer at the end of year two than it did a year earlier.

A fair question hides here. Why the cost of materials consumed rather than a fuller cost of goods sold figure that also includes wages and power? Because that is the line Anjani Stationers publishes and the stock in its godown is overwhelmingly raw paper and board rather than finished notebooks. A business with a large finished-goods holding would use a fuller cost figure and get a different, equally defensible answer. Switching between the two across years is not defensible, and nor is comparing a figure computed one way with somebody else's computed the other. The choice of cost base is a judgement; using the same base every time the ratio is computed is not.

What is days payable outstanding, and why does it subtract?

Days payable outstandingHow long, on average, a supplier waits to be paid after billing, read off the payables balance instead of bill by bill. is the mirror of days sales outstanding, taken from the other side of the table. Anjani Stationers is somebody's customer as well as the schools' supplier, and the paper mill is waiting for its money in exactly the way Anjani Stationers waits for the schools. Take trade payablesAmounts a business still owes its suppliers for goods and services already received. Payables sit as a liability on the balance sheet until they are settled., divide by the cost of materials consumed, multiply by 365. Year one: Rs 15,00,000 over Rs 1,32,00,000 times 365 is 41.5 days. Year two: Rs 22,00,000 over Rs 1,48,50,000 times 365 is 54.1 days.

The base is the cost of materials consumed for the same reason it was for inventory. A supplier's bill is for what the paper cost, with no margin of Anjani Stationers' own in it. Dividing by revenue would divide a cost by a selling price again.

Days payable outstanding is subtracted rather than added because those are days of the trade that a supplier is financing rather than the business, and every day a supplier waits is a day the business does not have to find the money itself. Go back to the timeline. The paper arrived on day zero and the mill was paid on day 54.1. For those 54.1 days the paper was in the godown, the notebooks were being made, and not one rupee of Anjani Stationers' money had gone anywhere. The mill was carrying it. Only from day 54.1 does the business start funding its own trade, and that is precisely why the payables days come off the top rather than adding to it.

Now the uncomfortable half of that. Anjani Stationers went from paying its suppliers in 41.5 days to paying them in 54.1 days, and on the cycle arithmetic that is worth 12.6 days of relief. StretchingTaking longer to pay suppliers than the agreed terms, or renegotiating those terms to be longer. Stretching improves the payer's own cash position and worsens the supplier's. a supplier is genuinely a source of funding, and it is also the cheapest funding to reach for and the easiest to overuse. Stretching costs nothing until it costs a great deal: an early payment discount forgone, a mill that quietly reprices, a mill that stops supplying in the week before the school year. So a falling cycle driven entirely by payables reads very differently from a falling cycle driven by faster collection, and this is exactly why the three components are never collapsed before they have been looked at individually.

How do the three combine into one number?

Working-Capital Cycle: the one number the three measures make

Add the two waits and subtract the one reprieve. Days sales outstanding plus days inventory outstanding less days payable outstanding gives the cash conversion cycleThe number of days between money leaving a business to pay for goods and money returning from the customer who bought them. The cycle is a single figure built from three day counts., and that single figure is the number of days of its own trading the business is financing at any moment.

Year one: 118.6 plus 52.5 less 41.5 is 129.6 days. Year two: 128.4 plus 68.8 less 54.1 is 143.1 days. The cycle lengthened by 13.5 days. Read that as a sentence rather than as arithmetic. In year one Anjani Stationers was funding about four and a third months of its own trading. In year two it was funding about four and three-quarter months of a larger volume of trading. Nothing on the profit statement is required to move for that to happen, and in Anjani Stationers' case nothing on the profit statement did move in an alarming way at all.

A reader who has only ever seen positive cycles will misread a negative one, so the sign of the number is worth naming explicitly. A positive cycle means the business funds the gap. A cycle of zero means the money out and the money in land on the same day on average. A negative cycle means suppliers and customers between them are funding the business. Customers pay on the spot and suppliers wait: a busy vegetable seller who buys on a week's credit and sells for cash every morning is running a negative cycle without ever having heard the term. Nothing about a negative cycle is superior in itself; it is a description of who is holding the money, not a verdict on how well the business is run.

How is a lengthening cycle analysed rather than just noticed?

How to Analyse Working Capital: four steps in order

A cycle figure on its own says almost nothing. One hundred and forty-three days is not good or bad; it is not even meaningful until it is set against something. A short procedure turns the number into a finding, and the order of its steps stops a reader from jumping to a conclusion the numbers do not support.

Compare the cycle with the same business's own prior year first, then split the change into its three components, then attribute each component to a specific balance and a specific decision, and only then ask what it cost in rupees. The steps are worth taking one at a time. Step one is the comparison, and the prior year of the same business is always the first comparison because it holds everything else still: same trade, same customers, same accounting policies. Two businesses that look alike can carry entirely different mixes of school work and retail work, so an outside benchmark comes second at best. Step two, decomposition, recomputes each of the three day counts for both years and takes the differences rather than staring at the total. Step three, attribution, names the balance and, where it is visible, the decision behind it. Step four, the money conversion, puts a rupee figure on the days. A rupee figure lands somewhere a person can act.

Step three is where the discipline actually bites, so it is worth a concrete pass. Anjani Stationers' collection days rose 9.8 days. The balance responsible is gross receivables. Receivables went from Rs 78,00,000 to Rs 95,00,000, a rise of 21.8 per cent against revenue growth of only 12.5 per cent. Attribute that carefully. Slower payment by the Sunrise Public School group, the largest customer, would produce it. Longer terms offered to win volume would produce it. A heavier weighting of deliveries into the last quarter would produce it too, dragging the year-end balance up without anything at all going wrong. Every one of those explanations produces the same 9.8 days, and only one of them is a problem. Attribution therefore ends in a question to ask rather than a verdict to record.

There is one more honest caution to build into the habit. Every one of these day counts uses a closing balance sheet figure against a full year's flow, so it is a photograph taken on the last day of March compared against twelve months of trading. For a business with a school year in it, that photograph is taken at a particular moment in the cycle every time. March against March is fair. March against September is not, and nor is treating one year's count as a description of every week inside it.

What happened to Anjani Stationers' cycle across two years?

Here is the whole build, both years, with the base for each row stated on the row itself so nothing has to be remembered. Read down the first two columns for the components, then across the last column for what moved.

Look at the last two rows before anything else: both bases grew 12.5 per cent, so not one of the three day counts moved because of the denominator, and every day of the 13.5 came from a balance growing faster than the trade that produced it. That is a genuinely useful check and it takes ten seconds. If a business's day counts move while its bases are flat, the balances did it. If the day counts move while the bases collapse, the ratio moved and the balances may not have. Here the bases rose exactly in step, and the finding is clean.

Step four converts the days to money. One day of the cycle is roughly one day of revenue: Rs 2,70,00,000 divided by 365 is about Rs 74,000. So 13.5 days is about Rs 10,00,000 of cash that Anjani Stationers had to find in year two and did not have to find in year one. The conversion is a shortcut. The collection days genuinely convert at a revenue-based rate, and the stock and payable days convert at the lower cost-based rate, so state the figure as approximate and mean it. The exact answer sits in the table above, where the net trading balances funded by the business went from Rs 82,00,000 to Rs 1,01,00,000, a rise of Rs 19,00,000 of which Rs 10,00,000 is attributable to the lengthening and the rest to the trade simply being bigger.

And this is where the cycle stops being an accounting curiosity. Anjani Stationers reported earnings before interest, tax, depreciation and amortisation of Rs 53,50,000 in year two and operating cash of Rs 36,30,000. The gap of Rs 17,20,000 is very nearly the Rs 17,00,000 that went into the trading balances across the year. A cycle that lengthens does not appear anywhere on the profit statement, and it appears in full on the cash flow statement. A reader who has only seen the profit statement is looking at a year they cannot yet explain.

Three readings matter. Hold stock and payments still and drag collection from 128.4 days down to 118.6, the year one figure, and the cycle falls to 133.3 days. Hold collection and payments still and drag stock from 68.8 back to 52.5 and the cycle falls to 126.8 days. The result sits below the year one cycle of 129.6 with collection still at its slower year two level. Stock is the driver with the most leverage on Anjani Stationers' cycle, and undoing the stock movement alone would have more than offset the collection movement. Push payments the other way, from 54.1 down to 41.5, and the cycle climbs to 155.7 days. The year would have looked like that if the paper mill had not been made to wait.

Who reads the cycle, and what do they do with it?

Three quite different people open these numbers in the same week, and none of them is admiring the arithmetic.

A lender reads the cycle to size a working capital limit, an analyst reads it to explain why operating cash sat below profit, and Anjani Kulkarni reads it to find out which of three balances is holding money she thought she had. Watch each of them work. The lender's question is how much short-term funding this trade actually requires, and the cycle answers it almost directly: 143.1 days of funding at roughly Rs 74,000 a day, cross-checked against the Rs 1,01,00,000 of net trading balances on the balance sheet itself. Then the lender asks the deciding question: is 143.1 where the number settles, or where it is passing through? The prior year answers that, not the current one. The analyst's use is different: operating cash of Rs 36,30,000 against earnings before interest, tax, depreciation and amortisation of Rs 53,50,000 needs explaining, and the 13.5 day lengthening explains most of it in one line. And Anjani Kulkarni's use is the most practical of the three. She cannot make the schools pay faster by wishing. She can look at 68.8 days of paper sitting in a godown, ask Meera Rao why the pre-season stocking went up by nine lakh, and get an answer this week.

The measure is most often pushed past what it can carry at one boundary. The cycle is a signal about timing, never a valuation input. It reports how many days of trading are being funded and says nothing whatever about the worth of the business, what its earnings will be next year, or whether the schools are good for the money. A lengthening cycle is a reason to open the receivables ageing and ask about the largest customer. A lengthening cycle is not a reason to mark anything up or down, and treating it as one is how a timing measurement gets quietly turned into a claim it was never built to make.

Anjani Stationers Private Limited, Anjani Kulkarni, Meera Rao and the Sunrise Public School group are invented.
Educational material. Not advice on any investment, tax, budget or market position.