Skip to content
StockSummarizer
Menu
How to analyze stocks

How to Analyze Inventory Turns and Receivables Quality

Learn to analyze inventory turns, DSO and receivables quality: the formulas, note checklists, a hypothetical cash conversion cycle example, and red flags to log. Educational, not advice.

By Published Updated

Warehouse aisle with pallets of raw materials stacked on red racking
Warehouse photograph by Cjp24, CC BY-SA 3.0, via Wikimedia Commons. Cropped and resized.

Inventory and receivables are where accounting estimates meet real cash. A company can report rising revenue while inventory piles up in a warehouse or customers stretch their payments. Inventory turns and receivables quality are two of the quickest ways to tell whether reported earnings are turning into cash.

Educational only, not financial advice. Treat this as a literacy framework, not a forensic accounting course. It goes deeper on two lines covered by working capital swings and CFO vs net income. Pair it with revenue quality and gross margin trends.

Direct answer

Calculate inventory turns (COGS ÷ average inventory) and days sales outstanding (receivables ÷ revenue × 365) on a trailing basis, then compare them with the company’s own history and two or three close peers. Flag it when inventory or receivables grow meaningfully faster than revenue for several quarters, when the receivables allowance shrinks while receivables balloon, or when the notes show write-downs, longer payment terms or factoring. Then read the MD&A for management’s explanation and decide whether it fits your thesis.

Revenue & COGSIncome statement(trailing 4Q)Inventory & ARBalance sheet(avg of open/close)Turns & daysDIO, DSO,DPOCash cycleDIO + DSO− DPORead the notesAllowances, NRVwrite-downs, aging
Compute the ratios first, then read the notes that explain why they moved.

The core ratios

MetricFormula (simplified)What a worsening trend can mean
Inventory turnsCOGS ÷ average inventorySlower sell-through, over-ordering, obsolete stock
Days inventory outstanding (DIO)365 ÷ inventory turnsMore cash tied up on shelves
Days sales outstanding (DSO)Trade receivables ÷ revenue × 365Looser credit terms, slower collection, channel stuffing
Days payables outstanding (DPO)Trade payables ÷ COGS × 365Stretching suppliers can flatter cash flow temporarily
Cash conversion cycleDIO + DSO − DPOOverall working-capital drag
Allowance ratioLoss allowance ÷ gross receivablesFalling allowance plus rising AR deserves a question

Use averages (opening + closing ÷ 2) and trailing-twelve-month revenue and COGS so seasonality doesn’t fool you. Retailers, distributors, manufacturers and miners all carry inventory differently. Compare against the company’s own history and a fair peer set, as in peer tables without cherry-picking.

0%5%10%15%20%6%5%Q16%8%Q25%12%Q34%15%Q43%19%Q5Revenue growth %Receivables growth %
Hypothetical issuer. When receivables growth persistently outruns revenue growth, ask whether terms were loosened or collections are slipping.

Receivables quality checklist

QuestionWhere to lookGreen / amber
Is AR growing faster than revenue?Balance sheet + income statementMatches revenue / outruns it for 3+ quarters
Has the expected credit loss allowance moved sensibly?Financial instruments note (IFRS 9)Moves with AR and risk / shrinks as AR grows
Any aging schedule disclosed?Credit risk noteStable buckets / growing 90+ day bucket
Customer concentration in AR?Concentration disclosureDiversified / one customer dominates
Factoring or receivable sales?Notes, liquidity section of MD&ANone or stable / new programme flattering CFO
Contract assets or unbilled revenue rising?Revenue note (IFRS 15)Stable / growing faster than billings

Inventory quality checklist

QuestionWhere to lookWhy it matters
Raw materials vs WIP vs finished goods mixInventory noteFinished-goods build-up is often the warning sign
Write-downs to net realizable valueInventory note (IAS 2)Recurring write-downs = recurring cost, not one-time
Reversals of prior write-downsInventory noteCan flatter margins in a recovery quarter
Inventory vs backlog or ordersMD&A, backlog postBuilding for confirmed orders is healthier than building on hope
Management explanationMD&A results discussion“Strategic build ahead of season” should reverse next season
DIO (days inventory)74 dDSO (days sales outstanding)52 dDPO (days payables)41 dCash conversion cycle85 d
Hypothetical distributor: 74 + 52 − 41 = 85 days of cash tied up in working capital.

Worked example (hypothetical)

A hypothetical distributor reports trailing revenue of $1,000M, COGS of $780M, average inventory of $158M and average receivables of $142M.

ItemCalculationResult
Inventory turns780 ÷ 1584.9x
DIO365 ÷ 4.9~74 days
DSO142 ÷ 1,000 × 365~52 days
Prior-year DSO (given)n/a41 days
Cash tied up by the DSO change(52 − 41) ÷ 365 × 1,000~$30M

Eleven extra days of receivables is about $30M of cash that hasn’t arrived. Whether that matters depends on free cash flow and leverage. Cross-check with the FCF checklist and debt notes.

Common misreads

  • Every inventory build is bad. Not true. Companies sometimes build ahead of a launch or a known seasonal peak. The question is whether it unwinds on schedule.
  • Ignoring the business model. Subscription and software businesses carry little inventory, and banks and insurers don’t use these ratios at all.
  • One-quarter panic. Quarter-end timing can swing DSO. Look for a multi-quarter pattern and record it in your quarter-over-quarter thesis log.

Sources

  • IAS 2 Inventories (measurement at the lower of cost and net realizable value; write-downs and reversals).
  • IFRS 9 Financial Instruments (expected credit loss allowance for trade receivables) and IFRS 7 (credit risk disclosures).
  • IFRS 15 Revenue from Contracts with Customers (contract assets and receivables).
  • NI 51-102 and Form 51-102F1 (MD&A discussion of liquidity and working capital). Confirm the current text on the CSA website.

Media credits

  • Hero: “Warehouse-plastic industry.jpg” by Cjp24, CC BY-SA 3.0, via Wikimedia Commons. Cropped and resized to 1280x720. Real photograph, not AI-generated.

By Andrew · stocksummarizer.com

Guides · coming soon

Want the playbook in one place?

We are compiling free literacy hubs into paid ebook playbooks (Research, Valuation without fake precision, Dividend safety). Soft launch only for now — keep using these free guides, and browse ebooks when a guide ships.

Preview ebook shelf

Educational only — not financial advice. Do your own research. See our disclosures.