Inventory turnover calculator
Calculate stock turns and days in inventory for your reporting period.
Inventory turnover
2.8 turns
For the entered period, without annualising.
Stock and holding time
Average inventory
$49,500
Days in inventory
32.14 days
2.8 turns over 90 days. Days in inventory: 32.14 days.
Match stock cost and the reporting period
Inventory turnover divides cost of goods sold by average inventory for the same reporting period. Both amounts use a consistent cost basis.
Cost of goods sold is the cost recognised for the goods sold during that period. Opening and closing inventory are the cost of the stock held at each boundary.
AASB 102 Inventories explains which purchase and other costs belong in inventory. It requires inventory measurement at the lower of cost and net realisable value.
This calculator uses cost-valued stock. Where accounts contain write-downs, keep the valuation basis consistent and review their effect before comparing periods.
Incorrect cost-basis comparison: $231,000 of sales divided by $49,500 of cost-valued stock gives 4.67. Correct cost-basis comparison: $138,600 of cost of goods sold divided by that stock gives 2.8 turns.
Sales include the store’s markup. Using sales as the numerator therefore produces a different ratio, even when the same products move through the store.
Calculate average inventory and turnover
Average inventory equals opening inventory plus closing inventory, divided by two. Stats NZ’s stock turnover definition uses this averaging method.
Choose Enter average if you have already calculated an average from more frequent stock balances. The calculator then ignores the opening and closing fields.
Inventory turnover equals cost of goods sold divided by average inventory. Days in inventory equals reporting-period days divided by turnover, using unrounded values.
Business Victoria’s stock-days formula uses 365 days for a year. This calculator substitutes your chosen period length, so a quarter uses its own number of days.
Days in inventory is a period-average measure. It does not tell you how long an individual item has sat on the shelf.
Amounts display as whole dollars. Turns and days display to two decimal places with trailing zeros removed. The calculation keeps the full precision.
Work through a seasonal store example
A hypothetical seasonal store records $138,600 of cost of goods sold across a 90-day quarter. Opening inventory costs $46,200 and closing inventory costs $52,800.
The two balances average $49,500. Dividing $138,600 by $49,500 gives 2.8 turns during the quarter. Dividing 90 by 2.8 gives 32.14 days in inventory.
These are the calculator’s starting values. Reset example restores them, including the opening-and-closing inventory method.
Suppose the store builds stock for a seasonal peak between those two balances. Opening and closing values alone miss that build-up.
An average of regularly spaced monthly balances may capture it better. Use the same sampling method each period, or weight balances by time when the intervals differ.
If those records give an average of $61,600, the same cost of goods sold produces 2.25 turns and 40 days in inventory.
Compare turnover without assuming a target
A higher turnover ratio means more cost of goods sold for each dollar of average inventory. It can also accompany low stock levels and missed sales.
A lower ratio can reflect slower sales or a deliberate seasonal build-up. Compare similar product categories and review stockouts alongside gross margin before changing stock levels.
Keep the cost basis and period length consistent. Compare a quarter with a comparable quarter, rather than treating its turns as an annual result.
Annualising 2.8 turns from 90 days gives 11.36 turns on a 365-day basis. That extrapolation assumes the quarter’s sales pace and stock level continue through the year.
Seasonal trading can break that assumption. The calculator reports period turns only and applies no target or industry benchmark.
Zero average inventory leaves turnover undefined, so the calculator marks the stock fields and shows no result. With positive inventory and zero cost of goods sold, turnover is zero and days in inventory is undefined.
Use your stock records to investigate the categories driving a change. Keep replenishment decisions separate from this measure of past stock movement.