Inventory Turnover Calculator — Ratio & Days Outstanding
This free Inventory Turnover Calculator works out your stock turnover ratio (COGS ÷ average inventory) and days inventory outstanding (365 ÷ turnover) in seconds. You can enter opening and closing stock or a known average, switch between rupees, lakh and crore, and instantly see how your result compares with common Indian industry benchmarks. A higher ratio means faster-moving stock and healthier working capital; the tool flags whether yours looks efficient, average or slow for its sector. All maths runs in your browser.
Calculate Inventory Turnover
How to Use This Inventory Turnover Calculator
- Pick your unit — enter figures in rupees, lakh or crore. The toggle scales everything for you.
- Choose an inventory method — enter opening and closing stock (the tool averages them), or switch to "Known Average" if you already have it.
- Enter cost of goods sold — the cost of stock sold during the period, taken from your profit & loss account.
- Set the period — 365 days for annual, 90 for a quarter, 30 for a month. This drives the days inventory calculation.
- Select your industry — so the tool benchmarks your ratio against the right sector range.
- Click Calculate Turnover — you instantly get the turnover ratio, days inventory outstanding, the average inventory used, and a benchmark rating.
CA Tip: Use cost of goods sold, not sales, in the numerator. Inventory is carried at cost, so a COGS-based ratio keeps both sides on the same basis and matches what auditors and lenders expect. Pair this with our cash conversion cycle calculator for the full working-capital picture.
What Is Inventory Turnover Ratio?
The inventory turnover ratio — also called the stock turnover ratio — measures how many times a business sells and replaces its inventory during a period, usually a financial year. It is one of the most useful efficiency metrics for any product business, because it shows whether stock is moving, whether cash is needlessly tied up, and whether you are holding the right scale of inventory for actual demand.
For brands selling physical goods, inventory turnover links directly to cash flow, storage costs and operational efficiency. Stock that sits too long in a warehouse ties up working capital and risks becoming obsolete; stock that moves too fast risks stockouts and lost sales. The ratio helps you find the right balance.
Days Inventory Outstanding (DIO)
Turnover is closely tied to days inventory outstanding (DIO), also known as days sales of inventory. DIO converts the ratio into a number of days: 365 divided by the turnover ratio. A turnover of 5 means roughly 73 days of stock on hand. The lower your DIO, the faster you convert inventory into cash.
Note: A single year-end snapshot can be misleading for seasonal businesses. Average several months or quarters where you can, so peaks and troughs don't distort the ratio.
Inventory Turnover Formula
The standard formula uses cost of goods sold over average inventory. Days inventory is then derived from the ratio.
Turnover Ratio = COGS ÷ Average Inventory
Days Inventory (DIO) = 365 ÷ Turnover Ratio
Worked Example
Suppose a trading business has COGS of ₹10,00,000. Opening stock was ₹3,00,000 and closing stock ₹1,00,000, so average inventory is ₹2,00,000.
Turnover Ratio = ₹10,00,000 ÷ ₹2,00,000 = 5 times
Days Inventory = 365 ÷ 5 = 73 days
This business turned its entire stock five times in the year and held inventory for about 73 days on average before selling it. Whether that is good depends entirely on its industry, as the benchmarks below show.
COGS vs Sales Method
Some businesses divide net sales by average inventory instead of COGS. This inflates the ratio because sales include a profit margin, making inventory look more efficient than it is. For comparability with peers and with figures drawn from accounts prepared under standards issued by the ICAI, the COGS method is preferred.
Inventory Turnover Benchmarks by Industry
A "good" ratio is entirely industry-dependent. FMCG goods are cheap, perishable and consumed quickly, so they turn over many times a year; big-ticket items like furniture or heavy machinery turn slowly. Indian quick-commerce players such as Blinkit and Zepto have pushed FMCG benchmarks higher, forcing traditional retailers to catch up. Use the table below as a starting point and always compare against your own sector average.
| Industry | Typical Turnover | Approx. Days Inventory |
|---|---|---|
| FMCG / Grocery | 12–25× | 15–30 days |
| General Retail / E-commerce | 5–10× | 37–73 days |
| Electronics | 6–10× | 37–61 days |
| Apparel / Fashion | 5–8× | 46–73 days |
| Furniture / Big-ticket | 3–5× | 73–122 days |
| Manufacturing | 3–6× | 61–122 days |
Context matters: a turnover of 4 might be poor for a convenience store but excellent for a luxury furniture retailer. A new product line often starts slow and accelerates as it gains traction, and growing companies may temporarily accept lower turnover while building up stock to meet rising demand.
Need Help with Inventory Accounting & Stock Valuation?
Patron Accounting LLP supports trading, retail and manufacturing businesses managing inventory — for Pune, Mumbai, Delhi, Gurugram and pan-India clients.
How to Improve Inventory Turnover
If your turnover lags your industry, the fix usually lies in better alignment between purchasing and actual sales velocity. Practical levers include:
- Demand-based forecasting — use sales data to set reorder points instead of buying in bulk for volume discounts that encourage overstocking.
- Clear slow-moving SKUs — discount or bundle dead stock to release cash and warehouse space.
- Smaller, more frequent deliveries — negotiate with suppliers to hold less stock without risking stockouts.
- Tiered stocking policies — stock fast-movers deeply and slow, specialised items lightly.
- Inventory software — real-time tracking reduces both stockouts and overstocking and improves reorder timing.
- Align incentives — reward teams on inventory efficiency, not just purchasing volume.
CA Tip: Improving turnover shortens your cash conversion cycle and cuts working-capital finance costs. Model the impact alongside our working capital calculator before committing to a stocking change.
Inventory, Compliance & Audit Notes for Indian Businesses
For Indian companies, inventory is not just an operational metric — it carries accounting and audit obligations that make accurate, regularly verified records essential.
AS-2 / Ind AS 2 valuation
Inventory must be valued at the lower of cost and net realisable value under the applicable accounting standard. How you value stock directly affects both COGS and the inventory balance, and therefore the turnover ratio. Consistent valuation is what makes the ratio comparable year on year and against audited peers.
CARO 2020 inventory reporting
Under the Companies (Auditor's Report) Order 2020, auditors of eligible companies must comment on physical verification of inventory and on whether the quarterly stock statements filed with banks against working-capital limits agree with the books. Our note on CARO 2020 Clause (ii) explains this in detail. Discrepancies here are a common audit and lender concern.
GST and tax records
Stock records also feed into GST reconciliations and income tax assessments. Auditors and the Income Tax Department may scrutinise large swings in inventory, while accurate records support input tax credit claims handled through the GST portal. Companies must also maintain proper books under the Companies Act administered by the Ministry of Corporate Affairs.
Note: This tool gives an estimate for analysis only. It is not accounting, tax or investment advice. Consult a qualified Chartered Accountant for inventory valuation and audit matters specific to your business.