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 AndrewPublished Updated

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.
The core ratios
| Metric | Formula (simplified) | What a worsening trend can mean |
|---|---|---|
| Inventory turns | COGS ÷ average inventory | Slower sell-through, over-ordering, obsolete stock |
| Days inventory outstanding (DIO) | 365 ÷ inventory turns | More cash tied up on shelves |
| Days sales outstanding (DSO) | Trade receivables ÷ revenue × 365 | Looser credit terms, slower collection, channel stuffing |
| Days payables outstanding (DPO) | Trade payables ÷ COGS × 365 | Stretching suppliers can flatter cash flow temporarily |
| Cash conversion cycle | DIO + DSO − DPO | Overall working-capital drag |
| Allowance ratio | Loss allowance ÷ gross receivables | Falling 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.
Receivables quality checklist
| Question | Where to look | Green / amber |
|---|---|---|
| Is AR growing faster than revenue? | Balance sheet + income statement | Matches 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 note | Stable buckets / growing 90+ day bucket |
| Customer concentration in AR? | Concentration disclosure | Diversified / one customer dominates |
| Factoring or receivable sales? | Notes, liquidity section of MD&A | None or stable / new programme flattering CFO |
| Contract assets or unbilled revenue rising? | Revenue note (IFRS 15) | Stable / growing faster than billings |
Inventory quality checklist
| Question | Where to look | Why it matters |
|---|---|---|
| Raw materials vs WIP vs finished goods mix | Inventory note | Finished-goods build-up is often the warning sign |
| Write-downs to net realizable value | Inventory note (IAS 2) | Recurring write-downs = recurring cost, not one-time |
| Reversals of prior write-downs | Inventory note | Can flatter margins in a recovery quarter |
| Inventory vs backlog or orders | MD&A, backlog post | Building for confirmed orders is healthier than building on hope |
| Management explanation | MD&A results discussion | “Strategic build ahead of season” should reverse next season |
Worked example (hypothetical)
A hypothetical distributor reports trailing revenue of $1,000M, COGS of $780M, average inventory of $158M and average receivables of $142M.
| Item | Calculation | Result |
|---|---|---|
| Inventory turns | 780 ÷ 158 | 4.9x |
| DIO | 365 ÷ 4.9 | ~74 days |
| DSO | 142 ÷ 1,000 × 365 | ~52 days |
| Prior-year DSO (given) | n/a | 41 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.
Related reading
- How to analyze working capital swings in quarterly results
- How to read cash flow from operations vs net income
- How to analyze revenue quality for Canadian issuers
- How to analyze customer concentration risk
- How to spot one-time items in Canadian financial statements
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 shelfRelated reading
- Investing guideHow to Analyze Banks Differently from Operating Companies
- Investing guideHow to Analyze Customer Concentration Risk
- Investing guideHow to Analyze Geographic Revenue Mix for Canadian Multinationals
- RCI.A summaryRogers Communications (RCI.A) — Completes C$4.35B MLSE buyout to 100% ownership
- CCO summaryCameco (CCO) — Westinghouse IPO windfall vs a 153x trailing P/E
- Sector deep diveCanadian retail stocks: Aritzia’s plan, Dollarama’s multiple, Metro’s year and which targets are CAD
- Investing guideHow to Research a TSX Stock from Scratch (Canadian DIY Framework)
- Investing guideHow to Read Quarterly Earnings for TSX Companies
- Investing guideHow to Compare Two TSX Peers Side by Side
Educational only — not financial advice. Do your own research. See our disclosures.