Inventory Turnover Calculator: Formula & Worked Example

Cost of goods sold divided by average inventory. Calculate instantly in your browser with editable inputs, a worked example and clear assumptions. No account required.

How it is calculated

Cost of goods sold ÷ Average inventory

Uses the supplied average inventory, in the same cost basis and period as COGS.

Worked example

COGS

2000000

Average inventory

500000

Example result: 4.00x

The interactive tool lets you edit every input and reset to this example. Calculations run in your browser.

Questions and answers

Are my calculator inputs sent to a server?

These calculations run in your browser. The calculator does not send your entered values to a calculation server or save them to your learning account.

Why can the result differ from a full spreadsheet model?

Each calculator uses the equation and assumptions shown on this page. Displayed values may be rounded. A workbook with different timing, fees, filters or source data can produce a different result.

Can I use the calculator without an account?

Yes. All 73 calculators are available to guest learners. The worked example shows the default inputs, and Reset restores them.

Related calculators

• Percentage Change — Measure increase or decrease from an old value to a new value.
• Weighted Average — Calculate an average where values have different weights.
• Markup — Calculate selling price from cost and markup percentage.

All 73 calculators · Practise in the Excel Simulator

Interactive practice runs in your browser.