Inventory Turnover Ratio and Its Credit Risk Implications for UK Companies

What is the Inventory Turnover Ratio?

The inventory turnover ratio measures how many times a company sells and replaces its stock during a financial year. It is the most direct measure of how efficiently a business manages its physical goods: how quickly stock moves from warehouse to customer, and how much working capital is frozen in that process at any given time.

For credit controllers and finance directors, the ratio is a practical early-warning signal. A company cycling through its stock quickly converts its investment in goods into revenue without delay. A company where stock sits for months — whether from weak demand, poor planning, or obsolete product lines — has capital tied up in its supply chain, growing pressure on its overdraft, and increasing vulnerability to cashflow failure.

The Inventory Turnover Ratio Formula

There are two versions in common use:

Preferred formula (COGS-based):

Inventory Turnover = Cost of Goods Sold ÷ Average Inventory

Where:

• Cost of Goods Sold (COGS) = the direct cost of production or purchase, taken from the profit and loss account
• Average Inventory = (Opening Stock + Closing Stock) ÷ 2

Alternative formula (revenue-based, used when COGS is unavailable):

Inventory Turnover = Revenue ÷ Closing Inventory

The COGS-based version is more accurate because it excludes the profit margin embedded in revenue. Where full accounts are available, always use it. The revenue-based version is a directional fallback when cost of sales is not disclosed — which applies to the majority of UK private companies filing abridged accounts.

Days Inventory Outstanding (DIO)

The inverse of the turnover ratio — expressed in days — is often more intuitive for working capital analysis:

DIO = (Closing Inventory ÷ Cost of Goods Sold) × 365

DIO tells you exactly how long a company holds stock before it is sold. It is the inventory component of the cash conversion cycle — CCC = DSO + DIO − DPO. A rising DIO directly lengthens the cycle, increasing the cash the business must fund from its own reserves or borrowing before customer payments arrive.

Worked Example

A UK manufacturing SME reports:

• Opening stock: £78,000
• Closing stock: £102,000
• Cost of goods sold: £840,000

Average Inventory = (£78,000 + £102,000) ÷ 2 = £90,000

Inventory Turnover = £840,000 ÷ £90,000 = 9.3x

DIO = (£90,000 ÷ £840,000) × 365 = 39 days

This manufacturer turns its stock 9.3 times per year, holding each batch for an average of 39 days before selling it — a healthy result by UK manufacturing benchmarks.

UK Sector Benchmarks

Inventory turnover varies dramatically between sectors because the nature and velocity of stock differs fundamentally. A supermarket sells perishable goods within days; a manufacturer holds raw materials and work-in-progress for weeks or months before the finished product ships.

Typical inventory turnover and DIO ranges by UK sector:

• Food and grocery retail: 20–40x (DIO: 9–18 days — perishables must move quickly)
• Hospitality (food and beverage): 20–35x (DIO: 10–18 days)
• Non-food retail: 6–12x (DIO: 30–60 days)
• Wholesale and distribution: 6–10x (DIO: 36–60 days)
• Manufacturing: 5–12x (DIO: 30–75 days — varies significantly by product complexity)
• Construction: 3–8x (DIO: 45–120 days — materials held on project timelines)
• Pharmaceutical and healthcare: 3–6x (DIO: 60–120 days — regulatory requirements and batch sizes)

These are structural norms, not quality judgements. A construction business with a DIO of 90 days is managing a project-based supply chain, not failing to sell goods. Never assess inventory turnover without first confirming the appropriate sector benchmark. ONS business survey data provides granularity by SIC code for specific credit decisions where precise benchmarking matters.

Inventory Turnover as a Credit Risk Signal

A falling inventory turnover ratio — stock moving more slowly than in prior periods — is one of the earliest quantifiable signals of business deterioration in stock-carrying businesses.

Demand slowdown: If the business is selling less than planned, stock accumulates. Purchase cycles continue on prior momentum while sales orders decline. The result is an inventory balance growing relative to revenue — often appearing before revenue itself shows a clear decline in filed accounts.

Obsolete or slow-moving stock: In fast-moving markets — technology, fashion, food — stock can become unsaleable before it moves. Companies often carry obsolete inventory at cost rather than writing it down, overstating assets and understating the real financial position. When write-downs eventually occur, they hit the P&L directly and erode equity.

Overbuying or poor demand forecasting: Purchasing at volumes not supported by actual sales creates a cash drain with a delayed and uncertain payback. The company spends now, holds the risk for months, and may ultimately sell at a discount to clear stock that has lingered too long.

Watch for: A DIO rising by more than 15 days year-on-year, or stock growing by more than 20% relative to cost of goods sold, without a clear strategic explanation. Combined with a rising trade debtors balance and declining cash — all visible in balance sheet trends at Companies House — this combination commonly precedes acute cashflow stress by 12–18 months.

The Cash Consumption Effect

Every additional day of stock holding costs cash — funded from reserves, overdraft facilities, or by stretching supplier payment terms beyond what is sustainable. A business simultaneously experiencing rising DIO (slower stock movement) and rising DSO (slower customer collections) faces a compounding cash drain on its operating cycle. This dual deterioration is one of the most common financial patterns in the 18 months before insolvency in manufacturing, retail, and distribution.

According to R3, the insolvency and restructuring trade body, stock-related cashflow problems are frequently cited as contributing factors in UK company insolvencies — particularly following demand shocks, rapid market shifts, or disrupted supply chains.

When High Turnover Can Also Signal a Problem

Slow-moving stock is the primary concern, but an abnormally high turnover ratio can indicate a different kind of risk.

Stockouts and lost sales: A business turning inventory extremely rapidly may be running so lean that it cannot fulfil orders promptly. Customers who cannot get what they need will source elsewhere, eroding revenue over time without any immediate signal in the financial statements.

Supply chain fragility: Very fast inventory turnover typically requires a just-in-time supply chain that leaves almost no buffer for delivery delays, price spikes, or supplier disruption. A manufacturer or distributor operating at near-zero stock levels is highly vulnerable to a single supply chain failure.

For credit analysis, abnormally high turnover is less common as a distress signal than a falling ratio — but it is worth noting when assessing operational resilience for higher-value credit relationships.

Finding Inventory Turnover in Companies House Filings

Applying the COGS-based formula requires both balance sheet and P&L data — which creates a recurring practical constraint for UK credit analysis.

Inventory (stock) typically appears as a named line item on the balance sheet face even in abbreviated and micro-entity filings. Under the Companies Act 2006, all UK limited companies must file a balance sheet, and most stock-carrying companies show the inventory figure explicitly. The denominator is usually available from public filings.

Cost of Goods Sold appears in the profit and loss account, which most UK private companies do not file. Companies with turnover below £10.2m, assets below £5.1m, and fewer than 50 employees qualify to omit the P&L — meaning COGS is unavailable from Companies House filings for the majority of UK SMEs.

Where full accounts are available, the calculation is straightforward:

• Locate Stocks or Inventories under current assets on the balance sheet
• Locate Cost of sales on the P&L below turnover
• Compute: COGS ÷ Average Inventory (average of opening and closing stock)
• Or DIO: (Closing Inventory ÷ COGS) × 365

Where full accounts are absent, your practical options are:

1. 1Revenue-based fallback: Revenue ÷ Closing Inventory — directionally useful but overstated by the profit margin
2. 2Management accounts: Request a stock aging schedule from the counterparty, particularly for higher-value exposures
3. 3Trend monitoring: Track the stock balance relative to total assets across successive filings — a growing inventory proportion is a deterioration signal even without P&L context

Applying Inventory Turnover in Credit Decisions

New customer onboarding: Where full accounts are available, calculate DIO for the last two or three filing years. A DIO rising from 35 to 55 to 80 days over successive filings warrants investigation before extending credit — even if the absolute level appears sector-normal in the first year. Trend deterioration is the signal, not any single snapshot.

Setting credit limits: A customer with high or rising stock relative to cost of sales is likely under cashflow pressure from its own working capital cycle — which directly affects how quickly it can pay its suppliers, including you. Combine the inventory trend with the warning signals covered in 5 Red Flags in UK Company Accounts — declining equity, current ratio below 0.8, or overdue filings — to build a multi-signal risk view before setting a limit.

Ongoing portfolio monitoring: For customers in stock-carrying sectors, recheck inventory levels when each year's accounts are filed. A jump in the stock balance combined with rising trade debtors from the Days Sales Outstanding analysis is an early warning that should trigger a credit review before the next invoice cycle — not after a payment is missed.

FinancialInsight extracts inventory data from Companies House filings automatically. Where cost of sales is available, DIO is calculated and benchmarked against the company's SIC code sector. Where only the balance sheet stock figure is present, the trend in stock relative to total assets is tracked across three successive filing years — providing a meaningful deterioration signal even when full P&L data is absent.

Key Takeaways

• The inventory turnover formula is Cost of Goods Sold ÷ Average Inventory — expressed in days as DIO: (Closing Inventory ÷ COGS) × 365; where COGS is unavailable, Revenue ÷ Closing Inventory is an acceptable directional fallback
• UK sector benchmarks vary widely: food retail 20–40x (9–18 days DIO); manufacturing 5–12x (30–75 days); construction 3–8x (45–120 days) — always use sector-appropriate thresholds rather than a universal number
• A DIO rising by more than 15 days year-on-year is an early warning of demand deterioration or stock management problems, commonly visible in accounts 12–18 months before acute cashflow stress
• Rising DIO directly lengthens the cash conversion cycle, increasing the cash a business must fund before customer payments arrive — compounding any simultaneous deterioration in Days Sales Outstanding
• A simultaneous increase in DIO and DSO is one of the most common financial patterns in the 18 months before insolvency in manufacturing, retail, and distribution — look for this dual deterioration in balance sheet trends at Companies House
• COGS is required for the preferred formula and appears in the P&L — micro-entity and abridged accounts omit the P&L for the majority of UK private companies; use the revenue-based approximation or request management accounts for higher-value credit decisions
• FinancialInsight calculates DIO automatically and benchmarks it against sector norms where Companies House data permits, tracking the three-year inventory trend as part of the composite credit score