UseFreeTools

Inventory Turnover Calculator

Calculate inventory turns and inventory days from COGS, opening and closing stock, and period days.

Inputs stay on your device No sign-up Free to use
How this works

The tool runs in this browser. Your file or text is not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Privacy details

Showing an example. Edit to see your own.

Use the same period as the cost of goods sold. Must be greater than zero.

Processed in your browser. Your inputs stay on this device.

How to use Inventory Turnover Calculator

  1. Enter cost of goods sold for the period.
  2. Enter opening and closing inventory values at cost.
  3. Set the period’s day count and review turnover and inventory days.

Example: Inventory Turnover Calculator

COGS 120000, opening inventory 20000, closing inventory 30000, period 365 days.

You add
COGS 120000, opening inventory 20000, closing inventory 30000, period 365 days.
You get
Average inventory is 25,000.00, turnover is 4.8 and inventory days are approximately 76.041667.

Supported inputs and limits

Average inventory is the arithmetic mean of the two entered balances, which may differ from a more detailed period average. The average must be positive. Zero COGS produces zero turnover and undefined inventory days. Enter plain decimals with at most 64 characters, 25 digits and 12 fractional places. Monetary inputs are limited to 10^12. Very small or large nonzero amounts use scientific notation. Use one currency throughout; no exchange rates, taxes or fees are added unless you enter them.

Where your input is processed

This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Turns and period days

Turnover = COGS / average inventory. Inventory days = entered period days / turnover. The day count belongs to your reporting period, not an automatic annual assumption.

Questions about Inventory Turnover Calculator

Why does the tool use cost of goods sold?

The inventory balances are entered at cost. Using COGS keeps the numerator and denominator on the same cost basis.

Is the two-point average always representative?

No. Large seasonal changes can make opening and closing balances a poor estimate of the period’s average stock.

Is a higher turnover always better?

The ratio alone cannot establish that. Stockouts, margins, seasonality and operating needs require separate context.

Project manager: Tony Hines · Content updated 3 October 2026 · Report a problem

Related tools

All tools in Finance