Work & small business · 353

Inventory turnover calculator

How many times does this cost of goods sold turn the average inventory?

Your numbers

$
$
$
days

Explore the numbers

Examples, chart, and saved snapshots

Start with a realistic example, adjust the inputs, or save your numbers before experimenting.

Example 1

Four turns on a 90,000 average

Start the year with 80,000 of inventory and end with 100,000. Cost of goods sold for the year is 360,000. Leave the period at 365 days. Average inventory is 90,000. 360,000 ÷ 90,000 is 4 turns.

4×inventory turns in the period
Example 2

Beginning inventory: 25% lower

Change beginning inventory to 60,000 while keeping the other example values the same.

4.5×inventory turns in the period
Example 3

Beginning inventory: 25% higher

Change beginning inventory to 100,000 while keeping the other example values the same.

3.6×inventory turns in the period

Interactive chart

See what changes the result

Result—

The chart changes one input while holding all other current values steady. It is a sensitivity view, not a forecast.

Browser snapshots

Freeze these values

Save the current calculation, experiment freely, and restore it later.

No saved snapshots for this calculator yet.

Saved only in this browser. Nothing is uploaded, and clearing browser data removes the snapshots.

Quick answer

What does the Inventory turnover calculate?

How many times does this cost of goods sold turn the average inventory? This calculator uses beginning inventory, ending inventory, cost of goods sold, and days in the period to estimate how often stock turns at cost immediately in your browser.

With the values currently entered, the result is 4× — inventory turns in the period. It also shows average inventory, days of inventory on hand, and cost of goods sold.

How to use the Inventory turnover

  1. Replace the example values with your own numbers.
  2. Review the result and supporting figures as they update automatically.
  3. Check the formula and assumptions before using the estimate for a decision.

Inputs used

  • Beginning inventory
  • Ending inventory
  • Cost of goods sold
  • Days in the period — entered in days

Inventory turnover formula

Average inventory = (beginning + ending) ÷ 2. Turnover = cost of goods sold ÷ average inventory. Days on hand = days in the period ÷ turnover.

Assumptions

  • An SEC computation of ratios exhibit writes inventory turnover as total cost of sales divided by average inventory, and average inventory as beginning plus ending, divided by two.
  • Cost of goods sold and inventory stay on the same cost basis. The period length is the day count you type, often 365 for a year.

Verify the inputs

Authoritative sources

These sources explain the definitions, factors, or rules behind this tool. Their geographic scope is shown because an official source for one country is not automatically valid somewhere else.

Sources do not endorse Calculum. Check the source date, scope, and your own documents before making a financial, tax, insurance, or reporting decision.

Practical guide

Inventory turnover example and edge cases

Inventory turnover asks how many times cost of goods sold replaces the stock you carry. An SEC ratios exhibit writes it as cost of sales divided by average inventory. Average inventory is the beginning balance plus the ending balance, then divided by two.

Example: Four turns on a 90,000 average

Start the year with 80,000 of inventory and end with 100,000. Cost of goods sold for the year is 360,000. Leave the period at 365 days. Average inventory is 90,000. 360,000 ÷ 90,000 is 4 turns.

Beginning inventory
80,000
Ending inventory
100,000
Cost of goods sold
360,000
Days in the period
365 days

Calculated result4×inventory turns in the period

Four turns means a batch of stock sits about 91 days. If you want days of cover from today’s unit count, open the inventory days of supply calculator.

Example results use the default display profile. The calculator above follows your selected country and units.

How to read the result

  • Read the turn count first. Then check days on hand. A higher turn with the same sales usually means less cash sitting on a shelf.
  • Keep cost of goods sold and inventory on the same cost basis. Selling price does not belong in this ratio.

Edge cases worth checking

The shop is seasonal

A year-end snapshot can hide a busy season. If stock peaked in July, use a mid-year count as well, or shorten the day count to that season.

You typed retail value as inventory

Stop and switch to cost. The SEC line uses cost of sales. A retail inventory number inflates the denominator and understates turns.

What changes the result most

Beginning inventory

Use a current amount for beginning inventory. Include fees or recurring costs that belong in the same figure.

Ending inventory

Use a current amount for ending inventory. Include fees or recurring costs that belong in the same figure.

Cost of goods sold

Use a current amount for cost of goods sold. Include fees or recurring costs that belong in the same figure.

Try a different scenario

Small changes show whether the answer is stable or sensitive.

Beginning inventory: 25% lower

60,000

4.5×inventory turns in the period

Beginning inventory: 25% higher

100,000

3.6×inventory turns in the period

Ending inventory: 25% higher

125,000

3.51×inventory turns in the period

Common mistakes

Check beginning inventory

An SEC computation of ratios exhibit writes inventory turnover as total cost of sales divided by average inventory, and average inventory as beginning plus ending, divided by two. Make sure this matches the number you enter.

Keep days in the period consistent

Cost of goods sold and inventory stay on the same cost basis. The period length is the day count you type, often 365 for a year. Use the same units and time period throughout the calculation.

Do not rely on one inventory turnover scenario

Run a cautious case and an optimistic case. The range is often more useful than one exact-looking number.

Use this result well

Use it for

How many times does this cost of goods sold turn the average inventory?

Do not use it as

It does not replace a quote, contract, accountant, or local employment guidance.