learn-finance-with-phoebe / Practitioner session 3 of 10
Learn Finance with Phoebe · Practitioner session 3 of 10

Working capital

Three dials convert trading into a cash position, and only one of them turns in your favour. Marchmont pays its suppliers 30 days after buying materials, holds the finished instrument for 60 days before it sells, and waits 75 days after that to be paid. DSO 75, DIO 60, DPO 30. Over twelve months receivables grow from £1,000,000 to £1,539,454 and inventory from £464,000 to £714,307, while payables only reach £357,153. The build is £664,607, it is the largest single reason the bank balance and the profit line disagree, and not one pound of it is a cost.

🟢 Hands on Analysts who build the model Anyone who sets customer terms 45 min
0-4 · Welcome 4-28 · Three dials and the cycle 28-54 · Build-along: turn the dials 54-60 · Q&A
Part 0

Where this sits in the model

Session 2 walked the income statement down to net income and finished on a pair: £63,370 earned in month 12 against minus £47,261 in the bank. Today accounts for the largest part of that distance. Receivables are sales already made and not yet paid for. Inventory is money already spent on instruments that have not sold. Payables are the one that works the other way, because a supplier who has not been paid is funding the business for free. Session 4 assembles these into the cash flow statement proper. Session 7 measures all eight levers side by side. The company is Marchmont Instruments and the engine is assets/fin-live.js, loaded on this page.

Live = run together in the session Self-study = the full depth, after class 🔍 Every diagram zooms

★ What you walk out with today. The three dials and what each one is physically holding. Marchmont's cash conversion cycle, 105 days, and where that number comes from. The twelve month build of £664,607 and the monthly path underneath it. The three levers measured, all of which leave twelve month net income at exactly £445,631. And the part that matters more than any of it: what those levers cost, which the model does not price and nobody should pretend it does.

LiveWhy timing becomes a balance5 min▶

An income statement records a sale when it is earned. A bank account records it when the money lands. Between those two events the sale has to exist somewhere, and it exists as a balance on the balance sheet. That is all working capital is: the accumulated difference between when things are recorded and when they are paid for.

Three balances carry it. Receivables hold sales made and not collected. Inventory holds goods paid for and not sold. Payables hold purchases received and not paid, which is the same mechanism running in the business's favour. Add the first two, subtract the third, and the total is money that is in the business and not available.

Real world

A laboratory orders an instrument in March. Marchmont ships it, books the revenue in March, and is paid in June. The March income statement is complete and correct. The March bank statement has nothing in it from that order, and June's payroll has to be met from somewhere else.

Self-studyThe three balances in the engine4 min▶

Each balance is one multiplication, driven by the month's own activity. Receivables scale with revenue because that is what customers owe against. Inventory and payables scale with cost of sales because that is what was bought.

fin-live.jsvar arNew = revenue * a.dso / 30; var invNew = cogs * a.dio / 30; var apNew = cogs * a.dpo / 30; var dWC = (arNew - ar) + (invNew - inv) - (apNew - ap);

The last line is the one that reaches the cash flow statement. It is the change in the three balances, not the balances themselves, because a business with a large but stable receivables book is not consuming cash. It is only growth in the balances that takes money out.

consoleconst m = MARCHMONT.run({}, 12); const r = m.rows[0]; r.ar r.inventory r.ap r.workingCapital // ar + inventory - ap r.deltaWC // the movement that hits cash r.operatingCF // netIncome + depreciation - deltaWC

No credentials of any kind are involved. If an example ever needs one, the string is the word placeholder.

Part 1 · covers the three dials

Three dials, and only one of them is on your side

12 min live

Follow one instrument from raw materials to collected payment and the whole subject is a timeline. The money goes out on one date and comes back on another, and the distance between them is a number with a name.

One instrument, from materials in to money back. buy materials day 0 pay the supplier day 30 ship and invoice day 60 customer pays day 135 DIO 60 - stock on the shelf DSO 75 - invoice raised, not paid DPO 30 - supplier waits Cash conversion cycle: 105 days Marchmont has paid for the goods and has not been paid for them. 105 = DIO 60 + DSO 75 - DPO 30 Only payables works in Marchmont's favour, and it is the shortest of the three dials by a wide margin.
🔍 Click to zoom - the cycle is the gap between the two cash events, not between the two paper events.
LiveReceivables: sales you have made and not been paid for4 min▶

Days sales outstanding is how long the average pound of revenue sits as an invoice before it becomes money. Marchmont's is 75, so the balance is revenue x 75 / 30, two and a half months of sales held as paper. In month 1 that is £1,000,000, which is already larger than the opening cash balance.

What it decides. Credit terms, how hard collections are chased, and which customers get a credit limit at all. Where judgement enters. DSO is an average and averages hide the shape. Ninety-nine laboratories paying on the nail and one large teaching hospital nine months late produce the same DSO as everybody paying moderately late, and those are entirely different problems with entirely different fixes. A single figure should always be followed by an ageing profile.

LiveInventory: money spent and not yet sold4 min▶

Days inventory on hand is how long stock sits before it becomes a sale. Marchmont's is 60, computed on cost of sales rather than revenue because stock is carried at what it cost, not what it will fetch. In month 1 that balance is £464,000.

What it decides. Whether a laboratory that orders on Tuesday gets an instrument this month or next. Two months of finished stock is a promise of availability, and availability is part of what a B2B buyer is paying for. Where judgement enters. The right level is a bet about demand nobody can settle in advance. Hold too much and the money is idle and the instruments may be superseded. Hold too little and the order goes to a competitor who had one on the shelf. Neither error appears in the accounts as an error.

LivePayables: the dial that works in your favour4 min▶

Days payable is how long the business holds its own suppliers' money before handing it over. Marchmont's is 30, against a balance of £232,000 in month 1. Every pound sitting in payables is a pound of the business's operations that a supplier is currently financing at no charge.

What it decides. How much of the cycle somebody else pays for. At 30 days against a 135 day journey, Marchmont's suppliers cover less than a quarter of it. Where judgement enters. Goodwill has no ledger account. Terms are extended by negotiation or by simply paying later and waiting to see what happens, and the second route works until the month a supplier is deciding who gets the last shipment of a scarce component.

Self-studyThe cash conversion cycle, and the businesses that run it backwards4 min▶

The cycle is DSO plus DIO less DPO. For Marchmont that is 75 plus 60 less 30, which is 105 days. It is the number of days between the business's money leaving and the same trade's money returning, and it is the single most compact description of how much cash a business needs simply to operate at its current size.

The arithmetic runs in both directions. A retailer who sells for cash, holds stock briefly and pays suppliers on long terms has a negative cycle: the customer's money arrives before the supplier's invoice falls due, so growth generates cash instead of consuming it. A subscription business billed annually in advance is in the same position. Marchmont is the opposite case, and the sign of the cycle is most of what determines whether growth needs funding.

The practical use is that the cycle multiplied by daily sales gives a rough size for the working capital a business must carry. Cut the cycle and that requirement falls, in proportion, without a single sale being added.

Part 2 · covers the build

Twelve months of build, and what it does to the bank

10 min live

Each balance is proportional to the month's activity, and activity grows 4% a month, so each balance grows too. The two on the left grow by more, in pounds, than the one on the right, and the difference is what leaves the bank.

The same three balances, twelve months apart. Receivables month 1 month 12 £1,000,000 £1,539,454 Sales already made and not yet paid for. Receivables alone grow by £539,454 over the year. Inventory month 1 month 12 £464,000 £714,307 Money already spent on instruments that have not been sold. Carried at cost, not at what they will fetch. Payables month 1 month 12 £232,000 £357,153 Suppliers Marchmont has not yet paid. The only one of the three that holds cash inside the business. Receivables plus inventory, less payables: the twelve month build is £664,607. Every pound of it is money Marchmont has earned or spent and cannot use, and not one pound of it appears as a cost anywhere.
🔍 Click to zoom - the payables bar is drawn on the same scale as the other two, which is the fastest way to see how little of the cycle a supplier is funding.
LiveWhy the build tracks growth rather than size4 min▶

Only the change in the three balances touches cash. A business selling the same amount every month has a large receivables book that does not move, and a balance that does not move takes nothing out of the bank: the collections coming in match the invoices going out. Marchmont grows 4% a month, so each month's balances are larger than the last, and the difference is funded out of the bank balance.

That is the mechanism behind the whole course. Growth does not consume cash because growing is expensive. It consumes cash because a larger business needs a larger amount of money permanently parked in invoices and stock, and the increase has to be found before the extra profit arrives.

LiveReading the monthly operating cash flow4 min▶

Operating cash flow is net income plus depreciation less the working capital movement. Marchmont's is negative in every month from month 2, and it climbs steadily back towards zero without ever reaching it: minus £23,481 in month 2, minus £5,796 in month 10, minus £427 in month 12.

It climbs because the two terms grow at different speeds. Net income rises from £17,732 in month 2 to £63,370 in month 12. The working capital movement rises from £49,280 to £72,946 over the same stretch. Profit is catching up. On this trajectory it eventually overtakes, which is session 9 and is the reason a twelve month window is not long enough to judge the business.

Operating cash flow, month by month. zero £22,062 in month 1 -£23,481 -£427 Negative in every month from month 2 onward and climbing back towards zero, reaching -£427 in month 12. month 1 month 12 Month 1 records no working capital movement at all, and that is a modelling choice. The opening balances were set consistent with month 1 activity, so the build starts in month 2. It is not a finding about the business.
🔍 Click to zoom - the line never crosses back above zero inside the twelve months, which is why the cash balance keeps falling even as the shape improves.
Self-studyWorking capital as a stock, the movement as a flow3 min▶

Two fields on every row, and confusing them is the commonest mistake in this subject. workingCapital is a level: receivables plus inventory less payables, at a moment. deltaWC is a flow: how much that level moved this month, and it is the only one of the two that appears in a cash flow statement.

A business can carry an enormous working capital level and generate perfectly healthy cash, provided the level is stable. It can also carry a small level and haemorrhage cash, if the level is doubling. The question is never how much working capital there is. It is which direction it is moving and how fast.

Part 3 · covers the levers

Three levers that move no profit, and are not free

8 min live

Turn any one of the three dials and the cash position changes completely while the income statement does not move by a single pound. That is the clearest demonstration in the whole course that profit and cash are different questions. It is also the point at which a model becomes dangerous, because the thing it cannot see is the thing each lever costs.

Each lever changes one dial and nothing else. Base case: cash turns negative in month 10, cash at month 12 is -£47,261, twelve month net income £445,631. Collect in 45 days dso: 45, everything else as base Cash at month 12: £168,521 Never goes negative. The customers agreed 75 days. Asking for 45 is a renegotiation, not a memo. Pay suppliers in 60 days dpo: 60, everything else as base Cash at month 12: £77,892 Never goes negative. Suppliers notice. Paying later spends goodwill you may need in a shortage. Hold 30 days of stock dio: 30, everything else as base Cash at month 12: £77,892 Never goes negative. Half the buffer. A stockout costs an order that no row in the model sees. All three leave twelve month net income at exactly £445,631. Not one pound of profit moved. The model prices the cash and prices none of the costs above. Those costs are real, somebody pays them, and they are not on any row.
🔍 Click to zoom - the two right hand levers land on the same figure, which is a coincidence of these particular settings and not a rule.
LiveWhy no profit moves4 min▶

None of the three dials touches a line on the income statement. Collecting sooner changes when a recorded sale becomes money, not whether it was earned. Paying a supplier later changes when a recorded cost is settled, not what it cost. Holding less stock changes how much is sitting in the warehouse, not what was sold or at what margin. So revenue, cost of sales, gross profit, operating expenses, EBITDA, EBIT, interest, tax and net income are all identical across the base case and all three levers.

That is the demonstration to keep. Cash at month 12 moves from minus £47,261 to £168,521 on the first lever, a swing of more than two hundred thousand pounds, and the twelve month profit figure is £445,631 in both runs. Anyone who believes profit and cash are broadly the same thing can be talked out of it in one console command.

LiveWhat the model does not price4 min▶

Every lever on that diagram is a change somebody else has to accept, and the model has no opinion about whether they will.

  • Collecting in 45 days rather than 75. Those terms are in signed contracts. Changing them means going back to laboratories that agreed 75 days and asking for something worse, in a market where a competitor is still offering 75. Some will agree. Some will use it as an opening to renegotiate price. Some will buy elsewhere next time.
  • Paying suppliers in 60 rather than 30. This is spending goodwill that has no balance. It works until the quarter a component is scarce and a supplier is choosing which customer gets the allocation, and that cost arrives long after the cash benefit was banked and is never attributed to it.
  • Holding 30 days of stock rather than 60. Half the buffer means half the protection against a demand spike or a late delivery. A stockout costs an order, and possibly the customer. The order that was never placed does not appear in any row of any model, which is exactly what makes this lever look free.

The model prices the cash precisely and the costs not at all. A recommendation built on the cash figure alone is a recommendation with one side of the ledger missing, and saying so out loud is part of presenting the number.

Self-studyThe argument about terms, which does not settle4 min▶

One position. An unpaid invoice is an interest-free loan the supplier never agreed to make. A business that does not manage its terms is financing its customers' balance sheets out of its own, and the cost is real: it is the interest on the debt drawn to cover the gap, or the growth foregone because the cash was not there. Terms should be set by whoever owns the balance sheet and enforced, and a sales team that hands out 90 days to close a quarter has spent money it does not control.

The other position. Terms are part of the price. A laboratory comparing two instrument suppliers is comparing total cost including when it has to pay, and 75 days is part of what Marchmont is selling. Pull it to 45 and some customers pay the same, some demand a discount that gives back the benefit, and some quietly go elsewhere. The ones who go elsewhere never appear as a working capital line. They appear as revenue that was never booked, which no model can distinguish from a market that simply did not buy.

Both sides are arguing about a quantity nobody in the room has measured, which is how much business the terms are buying. The useful discipline is to say which position you hold, say what evidence would change your mind, and notice that the £168,521 on the diagram is the upper bound of the benefit rather than the benefit.

Part 4 · build-along

Turn each dial and watch what does not move

26 min hands on

Six steps in the browser console on this page. MARCHMONT is already loaded. The last step needs no code at all and is the one worth the most.

Read the three balances off month 1

Call MARCHMONT.run({}, 12) and read rows[0].ar, rows[0].inventory and rows[0].ap against £1,000,000, £464,000 and £232,000. Then check that workingCapital is the first plus the second less the third.

Explain the zero in month 1

rows[0].deltaWC is zero while every later month is a large positive number. Work out why from the opening balances before reading on, then confirm: the opening balances were set consistent with month 1 activity, so nothing moved. It is a modelling choice and not a fact about Marchmont.

Reproduce the twelve month build

Use MARCHMONT.cumulative(m, "deltaWC", 12) and check it against £664,607. Then add up operatingCF over the same twelve months and confirm it comes to minus £116,951, which is net income of £445,631 plus depreciation of £102,025 less the build.

Turn each dial once

Run { dso: 45 }, then { dpo: 60 }, then { dio: 30 }, out to 24 months. Read MARCHMONT.cashOutMonth on each, which should return 0 every time, and rows[11].cash, which should give £168,521, £77,892 and £77,892 against a base of minus £47,261.

Prove the income statement did not notice

Run MARCHMONT.cumulative(r, "netIncome", 12) on all four runs including the base. All four should return £445,631. Then pick any single row and check revenue, cogs, opex and tax across the four runs; every one of them should be identical to the penny.

Write the cost line for each lever

No code. For each of the three, write one sentence naming who pays for it and what they would want in return. If a lever has no cost sentence, the sentence has not been found yet, because a change that costs nobody anything would already have been made.

The habit to keep. A working capital number never travels alone. Quote the cash benefit and the cost in the same breath, and name who bears the cost. The model gives you the first half to four decimal places and the second half not at all, and only one of those halves is on your slide by default.

Check yourself

Three questions

Marchmont runs DSO 75, DIO 60 and DPO 30. What is the cash conversion cycle?

Follow one instrument. The money leaves on day 30 when the supplier is paid and returns on day 135 when the customer pays, 60 days of stock plus 75 days of invoice after the purchase. The gap is 105 days, and payables is the only term that shortens it.

Collecting in 45 days instead of 75 takes cash at month 12 from minus £47,261 to £168,521. What happens to twelve month net income?

The dial does not touch a single line of the income statement. Revenue, cost of sales, operating expenses and tax are identical to the penny across both runs. A swing of more than two hundred thousand pounds in the bank against no change at all in profit is the sharpest version of the point.

Someone presents the three working capital levers as free money, on the grounds that they cost no profit. What is wrong with that?

The net income figures are right and the levers are not free. Each one is a change somebody else has to accept, and the model prices the cash while pricing none of the costs. The lost order in particular never appears in any row, which is precisely what makes the lever look costless.

Before session 4

Homework

Thirty minutes, half on a real set of accounts and half on a conversation you have actually had.

Compute a real cycle

Take any published set of accounts and work out DSO, DIO and DPO from the balances and the annual revenue and cost of sales. Then compute the cycle and say whether it is positive or negative, and what that implies about whether growth would fund itself.

Price one lever properly

Pick one customer or supplier term in your own organisation that could be changed. Write down the cash it would release, then write down what the other side would want in exchange and who would have to ask them. Session 7 puts all eight levers side by side and this is the column it cannot fill in for you.

Covered today

What this session covers

✓Receivables, inventory and payablesWhat each balance physically holds, and which one runs in your favour.
✓DSO 75, DIO 60, DPO 30 as multiplicationsReceivables on revenue, inventory and payables on cost of sales.
✓The cash conversion cycle105 days: DIO 60 plus DSO 75 less DPO 30, traced along one instrument.
✓The twelve month build£664,607, from £1,000,000 of receivables to £1,539,454 and the rest.
✓The level against the movementOnly deltaWC reaches cash; a large stable balance consumes nothing.
✓The monthly operating cash flow pathNegative from month 2, climbing to minus £427 by month 12.
✓Three levers measured, and the profit that never moves£445,631 in every run, against a cash swing of over two hundred thousand.
✓What the levers costCustomer terms, supplier goodwill, stockout risk. None of it priced by the model.
◐The full cash flow statementSession 4, by the indirect method, line by line.
◐The other five levers, and growth itselfSession 7.
○Valuation and what a business is worthA different subject with different tools.
○Unit economics, customer acquisition cost and lifetime valueCovered in the strategy and OKR courses.
Take this with you

Cheat sheet

The three dials. ar = revenue x dso / 30. inventory = cogs x dio / 30. ap = cogs x dpo / 30.
Marchmont's settings. DSO 75, DIO 60, DPO 30. Only the last one holds cash in.
The cycle. DSO plus DIO less DPO. For Marchmont, 105 days between money out and money back.
Level or movement. workingCapital is a level. deltaWC is the flow, and only the flow reaches cash.
The build. £664,607 over twelve months, and none of it is a cost.
Month 12 balances. Receivables £1,539,454, inventory £714,307, payables £357,153.
The levers. dso 45 gives £168,521 at month 12. dpo 60 and dio 30 each give £77,892. Base is minus £47,261.
The honest line. Profit is £445,631 in all four runs, and no lever is free. Name who pays.