Inventory Ratio Calculator

Inventory turnover tells you how many times a business sells and replaces its stock in a period, and days sales of inventory (DSI) states the same fact as shelf time. This calculator takes cost of goods sold (or net sales), beginning and ending inventory, and a period, then returns the turnover ratio, DSI, a verdict against an industry benchmark you pick, and an estimate of what holding that average inventory costs per year. The worked example is a fashion retailer turning its stock exactly five times a year.

Quick Answer

How to use the inventory turnover calculator

Take the numerator from the income statement and the two inventory values from the balance sheet, all at cost and all for the same period. Beginning and ending inventory are required in exactly this form because tax and accounting rules build COGS from opening and closing stock, the requirement set out in Treasury Regulation 1.471-1 on the need for inventories.

1. Choose the numerator basis. COGS is the standard and the pre-selected option. Switch to net sales only if COGS is genuinely unavailable; the tool relabels the input and appends a warning to the formula line when you do.
2. Pick the period your numerator covers: annual (365 days), quarterly (90) or monthly (30). The day count drives the DSI figure.
3. Enter COGS (or net sales), beginning inventory and ending inventory. Commas are accepted and stripped. The numerator must be above zero, inventory values cannot be negative, and the average of the two inventory values must be positive, or the tool shows its error line and no result.
4. Pick an industry benchmark and a carrying cost rate. The benchmark drives the verdict wording only; the rate (25% pre-filled) prices the holding cost. Leave the rate blank and it is treated as 0%, so the carrying cost reads $0.00.
5. Click Calculate (or press Enter in the ending inventory field). You get the ratio in large type, average inventory, DSI, the verdict sentence, the carrying cost, and the full formula with your numbers substituted in.

The formulas: turnover, DSI and carrying cost

Three formulas produce everything in the result box. Turnover counts how many times stock cycles in the period; DSI converts that count into days; the carrying-cost line multiplies average inventory by your holding-cost rate, prorated for shorter periods.

Why COGS and not sales? COGS and inventory are both measured at cost, so the ratio compares like with like. Sales revenue carries the markup, which is profit margin, not stock movement: the example retailer on $800,000 of net sales posts an 8.00x “turnover” and a flattering 45.6-day DSI without moving a single extra unit. The tool allows the sales basis, labels the option as inflating the ratio, and repeats the warning inside the formula line of the result.

Worked example: a fashion retailer at exactly 5.00x

A retailer reports $500,000 of annual COGS, $90,000 beginning inventory and $110,000 ending inventory. Every number below is the calculator’s own output for the pre-filled inputs.

• Average inventory = (90,000 + 110,000) ÷ 2 = $100,000.00
• Turnover = 500,000 ÷ 100,000 = 5.00x: the company sold and replaced its entire stock five times in the year
• Days sales of inventory = 365 ÷ 5.00 = 73.0 days
• Verdict against the fashion and apparel benchmark (~5.0x): on pace
• Estimated carrying cost at 25% = $25,000.00 for the year

Two variations worth running yourself. Switch the numerator to net sales and enter $800,000: the ratio jumps to 8.00x and DSI drops to 45.6 days, purely from markup, which is the cleanest demonstration of why the basis matters. Then switch the period to quarterly with a quarter’s COGS of $125,000: the tool returns 1.25x and 72.0 days, with the carrying cost prorated to $6,164.38 for the quarter. That quarterly figure needs the annualizing note in the limits section below before you judge it against any benchmark.

Turns vs days: the same fact, two dials

Turnover and days sales of inventory describe the same reality from opposite ends. Finance teams report days because days plug straight into the cash conversion cycle: days of inventory, plus the collection period from the days outstanding calculator, minus the payment period from the days payable calculator, equals how long cash is out of reach. Operations teams report turns because turns describe replenishment rhythm: how many times a year the buyer has to be right.

When the controller says 73 days and the planner says 5 turns, they are agreeing. The two views also feed the wider working capital picture: inventory is usually the largest single block of stock-funded cash in a trading business, which is why the same average inventory figure reappears inside the days working capital calculator and why turnover improvements show up so quickly in the sales to working capital ratio. A related but different measure, covered by the days of supply calculator, projects how long the stock physically on hand today will last at the current usage rate; DSI here is backward-looking, built from the period’s actual COGS.

What a good ratio looks like by industry

Good turnover is industry-specific, and the table below is the tool’s own built-in benchmark set, with the DSI each benchmark implies. Perishables cannot sit, so grocery runs hot; jewelry is high-value and slow by design.

The verdict logic is a band, not a pass/fail line: a ratio between 75% and 125% of the selected benchmark reads “on pace”; above the band it reads “faster” with a stockout warning; below it, “slower”, with cash tied up in slow-moving stock. With “No benchmark” selected, the tool falls back to generic bands: 6x and above is high, 3x to under 6x is moderate, below 3x is low. Treat all of these as orientation. Economy-wide, the U.S. Census Bureau’s Manufacturing and Trade Inventories and Sales release put the total business inventories-to-sales ratio at 1.37 for August 2025, a reminder that aggregate stock intensity moves slowly and that your own trend line is the benchmark that matters most.

Reading the carrying-cost line

The carrying-cost line converts the ratio into money: what it costs to keep the average stock sitting there. At the worked example’s $100,000 average inventory and a 25% rate, that is $25,000.00 a year, the figure that turns an abstract “5.00x” into a budget line.

The rate bundles several real costs: the capital tied up in stock (interest or foregone returns), warehousing and handling, insurance, shrinkage and theft, and obsolescence write-downs. The 20 to 30% planning range is a rule of thumb, not a measurement; a business with cheap storage and no perishables sits at the low end, a fashion or food business with markdown risk at the high end. Two behaviours of the tool to know: the estimate is prorated by period, so a quarterly run shows a quarter’s carrying cost ($6,164.38 on the example figures), not an annual one; and a blank or non-numeric rate is silently treated as 0%, which zeroes the line rather than raising an error. A negative rate, by contrast, fails validation like any other bad input.

Limits of a two-point average, stated plainly

Three limits are built into this tool’s method, and each one can move the answer. They are disclosed here rather than buried, because a ratio you plan purchasing on should come with its error bars.

• Beginning-plus-ending averaging smooths, and sometimes hides, seasonality. A retailer who stocks up in October and sells down in December can show a modest two-point average while carrying far more stock mid-period. Averaging monthly balances is more accurate for seasonal businesses; this tool’s two-point method is the standard textbook version, and it is the same simplification most rivals make silently.
• Period ratios are compared with annual benchmarks without annualizing. Run a quarter (COGS $125,000 on the example’s inventory) and the tool returns 1.25x with a “slower than benchmark” verdict against the annual 5.0x fashion figure, even though 1.25x a quarter is a 5.00x annual pace. Multiply a quarterly ratio by 4, or a monthly ratio by 12, before judging it against the annual table, and treat the tool’s verdict sentence on sub-annual runs as unadjusted.
• The ratio is only as honest as its inputs. Inventory valued at retail prices, a numerator from a different period than the inventory dates, or a year-end stock figure dressed up for the balance sheet date will all produce a precise, wrong number. The formula cannot detect any of these.

What competing calculators miss

The core division, COGS over average inventory, is identical everywhere. The differences are interpretation, periods and honesty about the numerator:

• ClearSpider and SourceDay: solid step-by-step teaching and, on SourceDay, a working mini calculator, but both stop at the ratio and days. No benchmark verdict, no carrying cost, no quarterly or monthly handling.
• Fulex and Narvar: good ecommerce framing and a correct warning that sales can substitute for COGS as a quick estimate, but neither quantifies how much the sales basis inflates the result, and neither benchmarks the reader’s number.
• Clear.co and DataWiz: strong on interpretation and product-level turnover, with DataWiz usefully separating the ratio and DSI formulas, but the tools and tables stay generic; there is no industry verdict tied to your inputs.
• The Rich Guy Math: the closest on method, including the monthly-average refinement for seasonal businesses, but it is an explainer with a static example rather than a full calculator with periods and benchmarks.
• The gap this page fills: turnover and DSI in one result, period-correct day counts (365/90/30), an industry benchmark verdict with its band logic stated, a carrying-cost dollar figure with prorating, an explicitly labelled sales-basis option with the inflation warning printed in the result, and the two method limits (two-point averaging, unannualized sub-annual verdicts) disclosed on the page.

Frequently asked questions

Add This Calculator to Your Website

References