How Working Capital Affects Cash Flow: Days Into Rupees

A sale becomes revenue on delivery and money only on collection, so working capital reaches cash long before it reaches profit. Every day the cycle lengthens is another day of trading the business funds out of its own pocket, and days convert into rupees at roughly one day of revenue. Growth multiplies the effect, and a shortening cycle hands the money back the same way.

Here is what sits underneath that. Profit records the transaction and cash records the settlement. Working capital is the distance between those two events measured in balances, and the cycle is the same distance measured in days. Neither measurement is more correct than the other, and neither is trying to describe the other. A rupee figure on the days lets a number that usually gets discussed as a ratio be discussed as money instead.

The cycle, the cash flow statement and each of the balances that make up working capital are set out in full under their own subjects. Anjani Stationers Private Limited, an invented stationer supplying schools, closed year two with Rs 17,20,000 between its earnings and its operating cash, and attributing that gap to the lines that caused it takes four steps: a change in cycle days converted into rupees, growth making the same cycle cost more every year, working capital giving cash back rather than taking it, and the exact place on the cash flow statement where the movement lands.

Why does working capital show up in cash before it shows up in profit?

Because the two statements are watching two different moments. Ask a tailor who makes wedding clothes. The cloth is bought in March and paid for in March. The clothes are delivered in April, and that is when the tailor has earned the money. The customer settles the bill in July. The tailor's April was a good month by every measure a profit statement uses, and the tailor's April bank account was still paying for cloth. Three months later the money finally lands. Nothing in that story is unusual and nothing in it is anybody's fault.

Profit is recorded on delivery and cash is recorded on collection, so the money is always the later of the two events, and the stretch between them is funded by the business out of its own bank account. The mechanism ends there, and everything else is arithmetic laid on top of it. Anjani Stationers recognises revenue when notebooks reach a school. The invoice may go out days later and the money may arrive four months later, and neither of those delays touches the revenue figure by a rupee. On accrualRecording something in the period it actually happened rather than the period it was paid for. Revenue goes in when the goods are delivered, cost goes in when it is incurred, whatever the bank is doing that month. measurement the year is finished the moment the delivery is made. On cash measurement the year has not started.

How are cycle days turned into rupees?

A year's revenue divided by 365 gives the value of one day. That is it. The conversion that makes the cycle feel like money rather than like a ratio is one division, and everybody who works with this figure in a real business does it in their head before they have finished reading the ratio.

Anjani Stationers turned over Rs 2,70,00,000 in year two, Rs 73,973 of trading a day, so the 13.5 days the cycle lengthened cost roughly Rs 9,98,636 of cash the business had to find from somewhere. Follow the arithmetic. Rs 2,70,00,000 divided by 365 is Rs 73,972.60, rounded to Rs 73,973 a day. The cycle ran at 129.6 days in year one and 143.1 days in year two, an extension of 13.5 days. Rs 73,973 multiplied by 13.5 is Rs 9,98,636, or roughly Rs 10,00,000. The Rs 9,98,636 is not a fee anyone charged and not a loss anyone reported. Money went into balances and stayed there, and the business had to have that money before it could carry on trading at the same size.

A figure this useful gets quoted long after the caution attached to it has been forgotten. The per-day conversion is a rule of thumb. The rule is close enough to size a problem in a meeting and not close enough to reconcile a statement, and the reason is that the three components of the cycle are not all measured against the same base. Receivable days are measured against revenue. Revenue is what customers were billed, so that base is right. Inventory days and payable days are measured against the cost of materials consumed, for Anjani Stationers Rs 1,48,50,000, or Rs 40,685 a day. Valuing all 13.5 days at the revenue rate gives Rs 9,98,636. Valuing each component at its own base gives Rs 8,75,000.

The rule of thumb overstates the extension here by about Rs 1,20,000, roughly fourteen per cent, and both answers give the same instruction to the person who has to find the money. That is why it survives as a rule of thumb. Nobody planning a year needs to know whether the number is Rs 8,75,000 or Rs 9,98,636. The planner needs to know it is about ten lakh rather than about one lakh, and one division tells them that in five seconds. The quick version settles whether the problem is worth working on; the component version belongs in an actual explanation of a set of accounts.

Why does growth make the drag larger?

Picture a street vendor with one cart. Every morning the vegetables are bought with money from yesterday's takings, and every evening the takings come back. The cycle is a day, so the vendor needs one day of stock money and never thinks about it. Now put a second cart on the road. Nothing about the cycle changed, and yet the vendor needs twice as much money before dawn. The second cart is the whole of the growth multiplier, and the multiplier works exactly the same way at Rs 2,70,00,000 of revenue as it does at one cart.

A cycle length is a rate, so the rupees it consumes scale with the volume put through it, and a business that grows without shortening its cycle must find more money every single year just to trade at the new size. Anjani Stationers carried Rs 97,00,000 of working capital at the end of year two: Rs 95,00,000 of gross receivablesWhat customers still owe before any allowance is taken off for the part the business expects never to collect. The allowance is deducted separately. plus Rs 28,00,000 of inventory, less Rs 22,00,000 of trade payablesWhat a business still owes its suppliers for goods and services it has already received. Until it is settled, the supplier is funding the business. and Rs 4,00,000 of school advances. Hold that cycle exactly where it is and put twenty per cent more trading through it, and the balances grow twenty per cent too: another Rs 19,40,000 of funding, needed before a single rupee of the extra profit arrives. At last year's margin, twenty per cent more revenue is roughly Rs 6,00,000 of extra profit after tax. The funding is more than three times the prize, and it turns up first.

When does working capital release cash instead of consuming it?

Whenever the cycle gets shorter, and it is the same arithmetic run backwards. The language around working capital is almost always negative, as though the balances were a leak rather than a dial, and a reader who only ever meets the consuming case will misread a good year as easily as a bad one. Go back to the tailor. Move from payment on collection to half the money on order, and the tailor's cycle drops by weeks. No extra clothes were sold and no price went up. Money simply arrives earlier than it used to, and for one year the tailor receives both the old pattern of payments and the new one.

A cycle can only be shortened once from any given length, so a release is not extra profit and it never repeats. The money it hands back is the funding that was previously tied up in the balances. Hold Anjani Stationers' revenue exactly where it is at Rs 2,70,00,000 and pull the cycle back from 143.1 days to the 129.6 days it ran at the year before, and roughly Rs 9,98,636 comes back into the bank. Operating cash for that year would read far better than the trading alone justified. The next year, at the shorter cycle, would get no such help. The one-year help is exactly why an experienced reader treats a large positive working capital movement with the same care as a large negative one. Both establish that something moved, and neither on its own establishes that the trading improved.

Where does all of this appear on the cash flow statement?

In one place, on one line, with its workings shown just above it. For a reader who has ever wondered which line of a statement carried the year's collection problem, this is it, and it is easy to walk past because it sits in the middle of a section rather than at the end of one.

The working capital movement sits inside operating activities, below the add-back of charges that never moved money and above the tax actually paid, and it is presented as one net figure built from the change in each balance. Anjani Stationers' operating section adds back Rs 12,00,000 of depreciation and amortisation, Rs 6,00,000 of provision against doubtful school invoices, which is a non-cash chargeA cost that reduced the reported profit without any money leaving the bank during the period. The charge is removed again when a statement works from profit back to cash. like any other, and Rs 3,50,000 of finance cost that belongs with the lenders. Then come the four working capital lines. Receivables rose Rs 17,00,000 and inventory rose Rs 9,00,000, both money out. Trade payables rose Rs 7,00,000 and the schools' contract liabilityMoney a customer has paid for something not yet delivered. The money sits on the balance sheet as an obligation to deliver until the goods go out, and only then does it become revenue. rose Rs 2,00,000, both money in. Net, minus Rs 17,00,000. Income tax paid of Rs 6,20,000 follows, and the section closes at Rs 36,30,000.

How much of Anjani Stationers' cash gap was working capital?

Almost all of it, and the arithmetic closes to the rupee. The arithmetic turns mechanism into a diagnosis that could be handed to somebody who runs a business.

Anjani Stationers reported earnings before interest, tax, depreciation and amortisation (EBITDAEarnings before interest, tax, depreciation and amortisation. A profit figure taken before the cost of borrowing, the tax bill and the charges for using up long lived things.) of Rs 53,50,000 and produced operating cash of Rs 36,30,000, a gap of Rs 17,20,000, and the working capital movement of minus Rs 17,00,000 is very nearly the whole of it. The three steps in between show why. The provision added back is plus Rs 6,00,000 and the tax actually paid is minus Rs 6,20,000, and those two almost cancel: net minus Rs 20,000. Everything else is working capital. Rs 53,50,000 plus Rs 6,00,000 less Rs 17,00,000 less Rs 6,20,000 is Rs 36,30,000, exactly as published.

Two very different things are inside the Rs 17,00,000 and only one of them is a problem. Split the figure. Working capital stood at Rs 80,00,000 at the end of year one and Rs 97,00,000 at the end of year two. Revenue grew 12.5 per cent and the cost of materials consumed grew 12.5 per cent as well. Had every balance simply grown with the trading, working capital would have closed at Rs 90,00,000, and that first Rs 10,00,000 is the price of being 12.5 per cent bigger. That Rs 10,00,000 bought something. The balances went past Rs 90,00,000 anyway. The extra Rs 8,75,000 is the cycle running longer, and a longer cycle bought nothing at all. Against those two, the schools' advances grew faster than the trading and handed Rs 1,75,000 back.

Two readings come out of that table, and they point in opposite directions. Opposite is the honest answer rather than the comfortable one. Rs 10,00,000 of the outflow is what growing costs, and a business that wants to be bigger has to fund it. Rs 8,75,000 is the cycle deteriorating, and no amount of extra trading was bought with it. The second figure is the one to work on, and it is the one a profit statement will never show.

With the cycle unchanged, operating cash reads Rs 46,28,636. At 13.5 days longer, the year as published, the cycle consumes Rs 9,98,636 and operating cash reads Rs 36,30,000. At 30 days longer, the cycle consumes Rs 22,19,190 and operating cash falls to Rs 24,09,446. Go the other way: at 10 days shorter the cycle releases Rs 7,39,730 and operating cash reads Rs 53,68,366, and at 30 days shorter it releases Rs 22,19,190 and operating cash reads Rs 68,47,826. Somewhere around 9 days shorter, operating cash passes above EBITDA of Rs 53,50,000. The crossing looks impossible until the release is recognised as money coming out of balances rather than money earned in the period.

Who actually uses this, and what do they do with it?

Three people open Anjani Stationers' accounts with three different jobs to do, and all three go to the same handful of lines. Watching what each of them does with the figure is the fastest way to understand why anyone bothers converting days into rupees at all.

A lender sizes the borrowing limit from the cycle, an analyst measures how much of the reported earnings turned into money, and the person running the business finds out which of the four balances is actually costing them. Take the lender first. A working capital facilityA borrowing arrangement a business draws on and repays as its everyday balances rise and fall, rather than a fixed loan repaid to a schedule. The limit is usually set against those balances. is sized against the balances it is there to fund, so a business carrying Rs 97,00,000 of working capital needs a materially larger limit than one carrying Rs 60,00,000 at the same revenue. When the cycle lengthens, the drawn balance rises even in a year when sales are growing, and that is exactly the pattern that puts pressure on a covenantA condition written into a loan agreement that the borrower has to keep meeting for the loan to stay on its original terms, such as a ceiling on borrowings measured against a profit figure. tied to borrowings against earnings. The lender is not reading the cycle out of curiosity. The cycle sets the size of the exposure.

The analyst does something simpler and quicker. Rs 36,30,000 of operating cash against Rs 53,50,000 of EBITDA is a conversion of about 67.9 per cent, and the immediate question is whether that is one year or a direction. One year of poor conversion caused by a genuine expansion is unremarkable. Three years of it, with receivables growing faster than revenue each time, is a different conversation entirely, and it is the conversation these figures are pointing towards. Written fairly, that is a reason to ask questions and never on its own a finding of anything.

And Meera Rao, running operations, gets the most actionable version of all. She cannot change the fact that the business grew, and the Rs 10,00,000 that growth consumed was money well spent. She can look at the Rs 8,75,000: the receivables that stretched 9.8 days and the inventory that stretched 16.3 days, against Rs 5,12,500 of extra supplier credit that partly paid for both. Receivables, inventory and supplier credit are three separate conversations with three separate sets of people, and one line on a cash flow statement has just told her which one to have first. Knowing which conversation to have first is the practical value of the whole exercise. A ratio says the cycle got worse. A rupee figure says by how much, and against which balance, and therefore what it is worth spending a month fixing.

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.