Skip to content
Finance Calc Kit
Business

Inventory Turnover Calculator

Calculate inventory turnover ratio and Days Sales of Inventory (DSI) to evaluate supply chain efficiency and stock management.

Inventory & Sales Input

$
$
$
Target Benchmark & Holding CostOptional▼
turns/yr
%

Inventory Turnover Ratio

5.00x

Moderate Velocity (3.0x - 5.9x)

Velocity HealthModerate

Typical for wholesale, specialty retail, or manufactured durables. Monitor holding costs and slow-moving SKUs.

Days Sales of Inventory (DSI)

73.0 Days

Approximately 10.4 weeks (2.4 months) of stock on hand

Average Inventory Balance

$200,000.00

Operating capital tied up in stock
Annual Carrying Cost

$40,000.00

$109.59/day holding cost at 20%

Working Capital Composition

Avg Stock$200,000.00
  • Target Operating Stock$125,000.0062.5%
  • Excess Trapped Capital$75,000.0037.5%

Working Capital Optimization vs 8.0x Target

Target Average Inventory

$125,000.00

Inventory required at target rate
Potential Cash Released

$75,000.00

Saves $15,000.00/yr in holding costs

Industry Turnover & DSI Benchmarks

Typical annual turnover velocity across common operating sectors.

Industry SectorTypical TurnoverDSI Range
Grocery & Supermarkets
15x - 30x12 - 24 days
Consumer Electronics
6x - 10x36 - 60 days
Apparel & Department StoresYour Range
4x - 7x52 - 90 days
Automotive & PartsYour Range
3x - 6x60 - 120 days
Industrial Machinery & Equipment
2x - 4x90 - 180 days
Wholesale & B2B DistributionYour Range
5x - 9x40 - 73 days

How we calculated this

Open to see each step from your inputs to the result.

  1. 1. Calculate Average Inventory

    Average Inventory=Beginning Inventory+Ending Inventory2\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2}

    Average Inventory = ($180,000.00 + $220,000.00) / 2 = $200,000.00

  2. 2. Compute Inventory Turnover Ratio

    Inventory Turnover=Cost of Goods Sold (COGS)Average Inventory\text{Inventory Turnover} = \frac{\text{Cost of Goods Sold (COGS)}}{\text{Average Inventory}}

    Turnover = $1,000,000.00 / $200,000.00 = 5.00x per period

  3. 3. Calculate Days Sales of Inventory (DSI)

    DSI=(Average InventoryCOGS)×Period Days=Period DaysPeriod Turnover\text{DSI} = \left( \frac{\text{Average Inventory}}{\text{COGS}} \right) \times \text{Period Days} = \frac{\text{Period Days}}{\text{Period Turnover}}

    DSI = ($200,000.00 / $1,000,000.00) × 365 days = 73.0 days (10.4 weeks, or ~2.4 months of stock).

  4. 4. Estimate Annual Inventory Carrying Cost

    Carrying Cost=Average Inventory×Holding Rate\text{Carrying Cost} = \text{Average Inventory} \times \text{Holding Rate}

    Annual Holding Cost = $200,000.00 × 20.0% = $40,000.00/year ($109.59/day).

  5. 5. Evaluate Working Capital Optimization

    Target Inventory=Annualized COGSTarget Turnover\text{Target Inventory} = \frac{\text{Annualized COGS}}{\text{Target Turnover}}

    Reaching 8.0x turnover requires an average inventory of $125,000.00, freeing up $75,000.00 in cash and saving $15,000.00 annually in carrying expenses.

Report tool

How the Inventory Turnover Calculator works

The inventory turnover ratio measures how many times a business sells and replaces its entire stock of goods over an accounting period. It is a cornerstone financial metric that reveals how efficiently working capital is deployed, how quickly products move through warehouses, and whether a company carries excess or obsolete stock. All calculations run instantly in your browser without transmitting your data.

By pairing your turnover ratio with Days Sales of Inventory (DSI), this tool quantifies holding periods and estimates annual carrying costs. If you need a granular analysis of holding duration across your operating cycle, our days inventory outstanding calculator evaluates cash conversion cycle velocity alongside receivables and payables. To verify physical stock valuations at period close, use our ending inventory calculator. If you operate under cost-flow assumptions where older inventory batches are recorded as sold first, our FIFO inventory calculator computes cost of goods sold and remaining valuation. To assess the minimum sales volume required to cover fixed operating overhead, visit our break-even calculator.

Inventory turnover and DSI formulas

Standard corporate finance and accounting standards (GAAP and IFRS) compute inventory turnover using Cost of Goods Sold (COGS) rather than net revenue. Because inventory on the balance sheet is recorded at cost, dividing COGS by average inventory matches cost-basis numerator to cost-basis denominator:

Inventory Turnover Ratio=Cost of Goods Sold (COGS)Average Inventory\text{Inventory Turnover Ratio} = \frac{\text{Cost of Goods Sold (COGS)}}{\text{Average Inventory}}

Average inventory balances out seasonal build-ups and year-end drawdown anomalies. It is computed as the arithmetic mean of beginning and ending inventory:

Average Inventory=Beginning Inventory+Ending Inventory2\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2}

Days Sales of Inventory (DSI), also known as Days Inventory Outstanding (DIO), converts that turnover frequency into the average number of calendar days inventory sits in stock before being sold:

DSI=(Average InventoryCOGS)×Period Days=Period DaysInventory Turnover\text{DSI} = \left( \frac{\text{Average Inventory}}{\text{COGS}} \right) \times \text{Period Days} = \frac{\text{Period Days}}{\text{Inventory Turnover}}

Step-by-step worked example

Consider a retail distributor with annual financial results documented as follows:

  • Beginning Inventory: $180,000
  • Ending Inventory: $220,000
  • Annual COGS: $1,000,000
  • Holding Cost Rate: 20% per year

First, determine the average inventory held throughout the 365-day year:

Average Inventory=$180,000+$220,0002=$200,000\text{Average Inventory} = \frac{\$180{,}000 + \$220{,}000}{2} = \$200{,}000

Next, calculate the inventory turnover ratio:

Inventory Turnover=$1,000,000$200,000=5.00x\text{Inventory Turnover} = \frac{\$1{,}000{,}000}{\$200{,}000} = 5.00\text{x}

Finally, calculate the Days Sales of Inventory (DSI) and annual carrying cost:

DSI=3655.00=73.0 days\text{DSI} = \frac{365}{5.00} = 73.0\text{ days}
Carrying Cost=$200,000×20%=$40,000 per year\text{Carrying Cost} = \$200{,}000 \times 20\% = \$40{,}000\text{ per year}

On average, the company takes 73 days (approximately 10.4 weeks) to cycle through its stock, incurring $40,000 annually in warehouse fees, insurance, capital costs, and depreciation.

Interpreting high versus low inventory turnover

Neither an excessively high nor an excessively low ratio is automatically ideal. Context and industry dynamics dictate what constitutes a healthy benchmark:

Low turnover risks (under 3.0x in general merchandise)

A low ratio signals that products linger on shelves. This ties up operating cash in unsold goods, increases warehouse rental expenses, and elevates the danger of obsolescence or forced markdowns. For electronics, fashion, or perishables, low velocity directly destroys gross margins.

High turnover benefits and pitfalls (over 10.0x)

High turnover reflects strong sales execution, lean supply chain management, and rapid working capital redeployment. However, if turnover is pushed too high by inadequate safety stock, businesses encounter frequent stockouts, lost sales, expensive rush shipping, and dissatisfied customers.

Strategies to optimize inventory velocity

  1. Implement ABC Inventory Stratification: Categorize SKUs by revenue contribution. Prioritize tight reorder cycles for top-earning Class A items while minimizing holding buffers for slow Class C goods.
  2. Improve Demand Forecasting: Integrate point-of-sale lead times and seasonal trends into procurement schedules to prevent bullwhip ordering spikes.
  3. Liquidate Aged and Dead Stock: Bundle or discount products stagnant for more than 120 days to convert trapped balance sheet capital back into liquid cash.
  4. Negotiate Smaller, Frequent Supplier Deliveries: Transition toward vendor-managed inventory or staged delivery contracts to minimize on-site bulk storage.

Frequently asked questions

Why does this calculator use COGS instead of net sales revenue?
Inventory balances are recorded on financial balance sheets at cost, not retail selling price. Dividing retail sales by inventory cost artificially inflates the turnover ratio because it incorporates the gross profit markup. Using Cost of Goods Sold provides an apples-to-apples cost-basis measurement.
What is a good inventory turnover ratio?
A good ratio depends on the industry. Fast-moving consumer goods and grocery stores typically achieve 15x to 30x (12 to 24 days DSI). In contrast, consumer electronics target 6x to 10x, fashion retail targets 4x to 7x, and heavy industrial machinery typically operates between 2x and 4x due to longer build cycles.
How do I convert monthly or quarterly turnover to an annual rate?
Multiply the periodic turnover by (365 / Period Days). For example, a quarterly turnover of 1.5x over 90 days scales to an annualized rate of 1.5 × (365 / 90) = 6.08x per year. This calculator handles that conversion automatically when you select Quarterly or Monthly.
What expenses comprise annual inventory carrying cost?
Carrying costs typically range from 15% to 30% of average inventory value per year. This includes the cost of capital (interest or opportunity cost of tied-up cash), storage facility lease, handling labor, property taxes, insurance, shrinkage (theft/breakage), and product obsolescence.
What is the relationship between inventory turnover and DSI?
They are reciprocal measures of the same operational reality. Inventory turnover tells you how many cycles occur in a year, whereas Days Sales of Inventory (DSI) tells you how many days each cycle takes. Dividing 365 by the annual turnover ratio yields DSI.
Are my financial figures stored or transmitted?
No. All calculations take place entirely client-side in your web browser. Nothing is saved on our servers or transmitted across the network.

Resources and references

The formulas and methods in this calculator were checked against these independent sources.