Financial modelling8 min read
Normalised Working Capital in a Financial Model: Days Method
Normalised working capital is the level of working capital a company needs in steady state, expressed in days of receivables, inventory and payables. This article shows how to calculate it on the right base, adjust it for year-end effects and project it in a financial model, with an example where the balance sheet understates the need by €1.4m.

What normalised working capital is, and why the balance sheet is not enough
Working capital is the cash tied up in the operating cycle: inventory and trade receivables, minus trade payables and tax and social security liabilities. The balance sheet gives you a snapshot of it, taken on one closing evening. Normalised working capital is something else: it is the level the company needs on an ordinary day, for a given level of revenue, once calendar effects and year-end window dressing have been removed.
In a financial model, the normalised level is the one that matters. It is the base of the projection: future cash flows depend on the increase in working capital, and a base that is too low distorts every year that follows. It is also the benchmark in a sale: the buyer compares the working capital delivered on completion day with this normal level, and adjusts the price by the difference (a completion accounts price adjustment). The article on working capital and business valuation explains this mechanism from the seller's side. Here, we build it from the model's side.
Three ratios in days, each on its own base
Working capital as a percentage of revenue is convenient, but it hides what is happening. Each line of working capital follows its own driver, and each ratio is calculated on the base that matches that driver.
| Line | Ratio | Formula | Base |
|---|---|---|---|
| Trade receivables | Days sales outstanding (DSO) | Receivables incl. VAT / Revenue incl. VAT × 365 | Sales including VAT |
| Inventory | Days inventory outstanding (DIO) | Inventory / Cost of sales × 365 | Cost of goods consumed, excluding VAT |
| Trade payables | Days payable outstanding (DPO) | Payables incl. VAT / Purchases incl. VAT × 365 | Purchases including VAT |
| Other operating liabilities (VAT, social security charges) | Percentage of revenue | Liabilities / Revenue excl. VAT | Sales excluding VAT |
Trade receivables and trade payables are recorded on the balance sheet including VAT, because the invoice includes it. Revenue, on the other hand, is stated excluding VAT. If you divide receivables including VAT by sales excluding VAT, you inflate the number of days by 20% (VAT at 20%, as in France). Inventory is valued at cost, not at selling price: its base is cost of sales, not revenue.
Take Fournitures Girard, a fictitious distributor of industrial consumables: €24.0m of revenue excluding VAT, €16.8m of cost of sales (70%), €1.68m of EBITDA (7%), and VAT at 20% on everything. At 31 December, its balance sheet shows:
| Line | Balance sheet at 31 December | Base | Ratio |
|---|---|---|---|
| Trade receivables | €3.55m | €28.8m of sales incl. VAT | 45 days |
| Inventory | €2.76m | €16.8m of cost of sales | 60 days |
| Trade payables | €3.04m | €20.16m of purchases incl. VAT | 55 days |
| Other operating liabilities | €0.36m | €24.0m of sales excl. VAT | 1.5% |
| Working capital | €2.91m | 12.1% of revenue excl. VAT, or 44 days |
The same calculation on the wrong base gives 54 days of receivables (3.55 / 24.0 × 365) instead of 45. That is a nine-day gap before normalisation has even been discussed.
From the balance sheet to normalised working capital
31 December is not an ordinary day. At Girard, December sales are low, the finance director chased every customer before the year-end, and the company let a few supplier payments slip into January. The balance sheet therefore shows a company that collects quickly, holds little inventory and pays late. To get back to steady state, three corrections are needed.
1. Work on monthly balances, not on the closing date
Ask for month-end trial balances over 24 months and calculate each ratio on the average of the last twelve balances. At Girard, average trade receivables come out at €3.95m, or 50 days, against 45 on the balance sheet. Average inventory reaches €3.22m, or 70 days, because the company rebuilds its stock from January to October and runs it down before the year-end count.
2. Remove what will not happen again
A large customer that paid late on a single occasion, stock built up ahead of a supplier price increase, an exceptional deposit: these items come out of the average. Conversely, supplier payments pushed back from December to January are not normal, especially when they exceed the French legal maximum of 60 days. Girard pays its suppliers at 45 days eleven months out of twelve. The normalised payable period is 45 days, which gives €2.49m of payables, not the 55 days on the balance sheet.
3. Check that the days hold in the future
A normalised period describes the past. If the plan involves taking on export customers who pay at 90 days, or selling through a marketplace that settles within 15 days, DSO has to move with the mix. Document these assumptions on a dedicated tab: it is one of the checks in the article on reviewing a DCF model.
The result at Girard:
| Line | Normalised ratio | Normalised amount | Balance sheet |
|---|---|---|---|
| Trade receivables | 50 days | €3.95m | €3.55m |
| Inventory | 70 days | €3.22m | €2.76m |
| Trade payables | 45 days | − €2.49m | − €3.04m |
| Other operating liabilities | 1.5% of revenue | − €0.36m | − €0.36m |
| Normalised working capital | 18.0% of revenue excl. VAT | €4.32m | €2.91m |
The balance sheet understates the need by €1.41m. On an enterprise value of €8.4m (EBITDA of €1.68m × 5.0), that is one sixth of the value. Whether the buyer reasons in discounted cash flows or in a multiple, they will find this gap: in a DCF, the first-year cash flow falls by the same amount; in a sale with a completion accounts price adjustment, a reference working capital set at €4.32m reduces the price by €1.41m if the company delivers €2.91m on completion day.
Projecting normalised working capital in the model
Once the ratios are set, the projection takes four lines per year. The model calculates each line from its base, then working capital, then its change, which flows into the cash flow statement. In Excel, with one column per year:
- Trade receivables:
= Revenue × (1 + VAT) × DSO / 365 - Inventory:
= Cost_of_sales × DIO / 365 - Trade payables:
= Purchases × (1 + VAT) × DPO / 365 - Change in working capital:
= Working_capital_year − Working_capital_prior_year, an outflow when positive.
At Girard, with growth of 5% a year and stable ratios:
| Year 0 (balance sheet) | Year 1 | Year 2 | Year 3 | |
|---|---|---|---|---|
| Revenue excl. VAT | €24.00m | €25.20m | €26.46m | €27.78m |
| Working capital (18.0% of revenue) | €2.91m | €4.54m | €4.76m | €5.00m |
| Change in working capital | − €1.63m | − €0.23m | − €0.24m |
The year 1 change breaks down into €1.41m for the return to the normalised level and €0.22m linked to growth. A model that starts from the balance sheet without normalising shows a change of €0.15m in year 1: it overstates the available cash flow by €1.48m, then errs a little less in each following year.
This year 1 catch-up is a real cash outflow. Keep it in the model if the price includes no working capital adjustment. If the price is adjusted against a reference of €4.32m, the buyer is already compensated through the lower price: start from normalised working capital in year 0, otherwise you count the gap twice. The sequence of balance sheet, income statement and cash flow statement is described in the article on the three financial statements.
Normalised working capital and seasonality: the peak an annual model cannot see
An annual model reads one working capital figure per year. If the business is seasonal, the real need goes through a peak during the year, and it is this peak that sizes the cash and the credit lines. At Girard, inventory climbs to 90 days in September, ahead of its customers' maintenance season: working capital reaches €5.2m at its highest, against €4.32m on average. For a financing, the gap between the two is what counts. The article on the revolver in an LBO model shows how a credit facility absorbs this peak, and why a monthly model is needed in the first year.
In an annual model, add a "peak working capital" line equal to average working capital plus the seasonal gap measured on the monthly balances.
The most common mistakes
- Days on the wrong base. Receivables on sales excluding VAT, inventory on revenue: each mix-up shifts the number of days by 20% to 40%. Write the base next to each ratio in the model.
- A single date. The closing balance sheet is the day everyone tidies up. Use at least twelve monthly balances.
- Working capital that does not move with activity. Freezing working capital as an amount while revenue grows removes the increase in working capital from the cash flow statement and overstates the value. The days stay stable, not the amounts.
- Forgotten lines. Customer deposits received, VAT payable, the month's social security charges: they reduce working capital, sometimes by several points of revenue.
- The change in the wrong direction. An increase in working capital is an outflow. The sign error is a classic and hard to see, because the balance sheet still balances. Test it on a year when revenue falls: working capital should then release cash.
Project working capital in a complete model. Bridgesheet's three-statement model in Excel links the income statement, balance sheet and cash flow statement over 3 to 10 years, with working capital, capital expenditure and debt assumptions, and a balance sheet checked every year. It is an estimate, not a certified valuation or investment advice.


