The inventory turnover ratio tells you how many times a business sells through its average stock in a year. It is one of the first ratios a banker checks before renewing a cash credit limit and one of the most useful numbers an owner can watch, because every rupee sitting in slow stock is a rupee not available for paying suppliers, salaries or growth. This guide explains the inventory turnover ratio formula, how to calculate it correctly from Indian financial statements, how to convert it into days of inventory, what typical ranges look like, and what to do when the number is poor.
Inventory turnover ratio formula
The standard formula is:
Inventory turnover ratio = Cost of goods sold / Average inventory
Where average inventory = (Opening inventory + Closing inventory) / 2.
Some analysts use sales instead of cost of goods sold (COGS). That inflates the ratio because sales include your margin while inventory is valued at cost. Use COGS for internal analysis, and be consistent when comparing periods.
Calculating COGS from an Indian P&L
Schedule III does not show a single COGS line. You build it from the statement of profit and loss:
- For a trader: Purchases of stock-in-trade + Changes in inventories of stock-in-trade (+ direct freight inward, if you include it in cost).
- For a manufacturer: Cost of materials consumed + Changes in inventories of finished goods and work in progress + direct manufacturing expenses (power, direct labour, factory overheads) as appropriate.
Worked example: a trading company
Suppose a hypothetical Indore electrical goods distributor has these figures for the year:
| Item | Amount (₹) |
|---|---|
| Opening inventory (1 April) | 1,20,00,000 |
| Purchases during the year | 7,80,00,000 |
| Closing inventory (31 March) | 1,60,00,000 |
| Cost of goods sold (1.2 cr + 7.8 cr minus 1.6 cr) | 7,40,00,000 |
| Average inventory ((1.2 cr + 1.6 cr) / 2) | 1,40,00,000 |
Inventory turnover = ₹7.40 crore / ₹1.40 crore = 5.29 times.
Converting turnover to days inventory outstanding
Owners usually find days easier to act on than ratios:
Days inventory outstanding (DIO) = 365 / Inventory turnover ratio
For the distributor: 365 / 5.29 = 69 days. On average, an item sits in the warehouse for about 69 days before being sold.
Now connect it to cash. If the distributor could bring DIO down to 50 days with the same COGS, average inventory would fall to about ₹7.40 crore x 50 / 365 = ₹1.01 crore. That frees roughly ₹39 lakh of working capital. At a cash credit interest rate of, say, 10 percent, that is around ₹3.9 lakh a year of interest saved, before counting lower storage, damage and obsolescence.
Why average inventory from two points can mislead
Using only opening and closing stock assumes inventory moves smoothly through the year. Many Indian businesses are seasonal: a fan and cooler distributor stocks heavily from January to April, while a garment wholesaler peaks before Diwali. If year-end happens to fall at a low point, the ratio looks better than reality.
Better options:
- Monthly average: sum the 12 month-end inventory values and divide by 12.
- Rolling 12-month: compute COGS and average inventory for the trailing 12 months, every month, to see trends.
An ERP that keeps a perpetual inventory record makes monthly values available without a physical count, which is one practical reason businesses move from periodic stock-taking to system-driven inventory.
Item-level turnover: where the real insight is
A company-wide ratio of 5 can hide a mix of items turning 20 times and items that have not moved in a year. Always break it down.
| Item group | Annual COGS (₹) | Average stock (₹) | Turnover | Days |
|---|---|---|---|---|
| LED bulbs | 2,40,00,000 | 16,00,000 | 15.0 | 24 |
| Switches and sockets | 2,10,00,000 | 30,00,000 | 7.0 | 52 |
| Cables and wires | 2,20,00,000 | 44,00,000 | 5.0 | 73 |
| Decorative fittings | 70,00,000 | 50,00,000 | 1.4 | 261 |
| Total | 7,40,00,000 | 1,40,00,000 | 5.3 | 69 |
In this hypothetical case, decorative fittings hold over a third of the stock value while contributing under a tenth of COGS. That one category is the working capital problem.
Typical inventory turnover ranges by business type
There is no universal "good" number; compare against your own history and similar businesses. As a rough orientation only:
| Business type | Typical turnover | Why |
|---|---|---|
| FMCG distribution | Higher (often 10 or more) | Fast-moving, short shelf life, frequent replenishment |
| Pharma distribution | Moderate to high | Expiry pressure, many SKUs |
| Electrical and hardware trading | Moderate | Wide range, some slow items held for availability |
| Engineering manufacturing | Lower | Raw material buffers, long production cycles, WIP |
| Jewellery | Low | High-value display stock |
These are directional, not benchmarks to quote. Your banker and your CA can often share sector ranges from their own client base.
How to improve inventory turnover
- Run ABC and FSN analysis. Classify items by value (A, B, C) and by movement (fast, slow, non-moving). Focus attention on A items and act on non-moving stock.
- Set reorder levels from data. Replace instinct-based ordering with reorder points based on lead time and demand. Our guide on reorder level and safety stock shows the calculation.
- Reduce order sizes for slow items. Volume discounts on slow movers often cost more in carrying cost than they save.
- Liquidate dead stock deliberately. Offer schemes, return to principals where agreements allow, or sell at a discount. Holding it costs money every month.
- Negotiate shorter supplier lead times. Shorter lead times mean lower safety stock.
- Improve forecast accuracy. Use sales history by season, not last month's sales alone.
- Clean up master data. Duplicate items with different names make stock look higher than demand needs.
Inventory turnover for manufacturers: three ratios, not one
A manufacturer holds raw materials, work in progress (WIP) and finished goods, and each behaves differently. A single blended ratio hides where the money is stuck. Calculate them separately:
| Stage | Formula | What a poor number usually means |
|---|---|---|
| Raw material | Cost of materials consumed / Average raw material stock | Bulk buying, poor planning, materials for discontinued products |
| Work in progress | Cost of production / Average WIP | Long production cycles, bottlenecks, partly finished jobs on hold |
| Finished goods | Cost of goods sold / Average finished goods stock | Producing ahead of demand, slow dispatch, rejected or unsaleable output |
Suppose a hypothetical Rajkot pump manufacturer finds its raw material holding period is 45 days, WIP 30 days and finished goods 20 days. The conventional instinct is to squeeze suppliers, but the data says WIP is unusually long for its process. Investigating, the team finds castings waiting for machining because one CNC machine is overloaded. Fixing a capacity bottleneck releases more cash than any purchase negotiation would.
Inventory turnover in bank and CMA discussions
When you apply for or renew working capital limits, banks assess your holding levels through the credit monitoring arrangement (CMA) data and stock statements. They compare projected holding periods for raw material, WIP, finished goods and receivables against your past performance and against what is normal for the sector. Three practical points:
- Consistency matters. Stock values in monthly stock statements to the bank should reconcile with your books. Large gaps between the stock statement and the audited balance sheet attract questions at renewal.
- Explain improvements with evidence. If you claim holding periods will fall next year, show the actions: reorder levels, supplier lead time changes, liquidation of slow stock.
- Ageing helps. Banks often exclude stock older than a certain age from drawing power. An item-wise ageing report lets you see in advance how much of your stock may not count.
Drawing power is typically calculated on eligible stock and receivables minus creditors and a margin. Slow and old stock therefore costs you twice: it ties up cash and it may not support borrowing either.
Building a monthly inventory turnover review
A ratio only helps if someone acts on it. A simple monthly routine that takes under an hour:
- Pull rolling 12-month COGS and average inventory by item group and by warehouse.
- Flag groups whose days of inventory rose by more than 10 days versus the previous quarter.
- List items with no sale in 90, 180 and 365 days, with their stock value.
- Agree actions with purchase and sales: stop reorders, plan schemes, return to supplier, or write down.
- Record the actions and check next month whether the value of non-moving stock actually fell.
The review works best when one person owns it and the same report is used every month, so trends are visible rather than argued about.
Mistakes to avoid when using this ratio
- Using sales instead of COGS and then comparing with a source that used COGS.
- Chasing a high ratio blindly. Very high turnover with frequent stock-outs loses sales. The goal is the right stock, not the least stock.
- Ignoring inventory quality. A ratio built on book values that include damaged or expired items is meaningless. Write down obsolete stock first.
- Mixing valuation methods across periods. A change from FIFO to weighted average alters inventory values and the ratio.
Frequently Asked Questions
What is a good inventory turnover ratio?
It depends on the industry. Fast-moving consumer goods businesses turn stock many times a year, while engineering manufacturers turn it far less. Compare with your own trend and with similar businesses rather than a universal figure.
Is a high inventory turnover always good?
Not always. Very high turnover can indicate too little stock and lost sales from stock-outs. Look at turnover alongside fill rate or service level.
Should I use sales or cost of goods sold?
Use cost of goods sold, because inventory is valued at cost. Using sales overstates the ratio by your margin.
How is inventory turnover different from days inventory outstanding?
They express the same thing differently. Turnover is the number of times stock is sold through in a year; DIO is the average number of days stock is held, calculated as 365 divided by turnover.
How often should I track inventory turnover?
Monthly on a rolling 12-month basis, at company and item-group level. Annual calculation alone is too late to act on.
How Fininvo Helps
Fininvo ERP's inventory module includes multi-warehouse stock, reorder points and alerts and inventory valuation, and its analytics provide inventory reports for item-level review. Check pricing for plan details.
Share this article
Ready to automate your business?
Start your 14-day free trial and experience the power of unified ERP, HR, and Payroll.
Start Free Trial