Inventory Turnover Calculator
Calculate stock turns and equivalent inventory days for your entered reporting period.
Stock and cost of sales
Use the stock cost for the same reporting period.
Reporting period
Enter 1 to 36,600 whole days.
6 times
Turns during the entered reporting period.
60.83 days
$73,000
Uses the opening and closing stock average. Entries stay on this device.
Turnover and Stock Days
This inventory turnover calculator divides period cost of goods sold by average inventory. The inventory turnover ratio estimates how many times the client sells and replaces that average stock during the entered period.
Average inventory is opening inventory plus closing inventory, divided by two. Equivalent inventory days equals the entered day count divided by the turnover multiple. The tool keeps the calculation unrounded until it displays the result.
Business Queensland’s financial ratios guide gives the stock turnover formula. Business Victoria’s stock-days formula uses 365 days for a year. This tool uses your entered period length instead.
The fictional example starts with $438,000 cost of goods sold, $62,000 opening inventory and $84,000 closing inventory over 365 days. Average inventory is $73,000. Dividing $438,000 by $73,000 gives 6 times, equivalent to 60.83 days.
For a 91-day period with the same stock balances and $109,500 cost of goods sold, turnover is 1.5 times. Equivalent inventory days is 60.67 days. The multiple covers those 91 days and is not annualised.
Correct input uses the cost of goods sold against stock held at a consistent cost basis. Incorrect input uses sales revenue against cost-valued stock, which adds the sales margin to the numerator. Employee turnover measures staff departures and uses different inputs.
When average inventory is zero, division has no denominator and the tool gives no turnover multiple. With positive stock and zero cost of goods sold, turnover is zero. Stock days has no finite result in that case.
Choose Comparable Inputs
Use cost of goods sold and stock balances for the same entity and reporting period. Opening inventory starts that period and closing inventory ends it. Enter the actual number of calendar days, including a leap day where relevant.
Use reconciled amounts with a consistent valuation basis. A changed stock-cost method or write-down can move the ratio without a matching change in physical stock movement. Keep the treatment of recoverable GST consistent between stock and cost of sales.
A two-date average can miss seasonal peaks or large purchases between stocktakes. Review monthly stock records when the opening and closing balances poorly describe the stock held through the period. This calculator uses only the two entered balances.
Compare like periods, product mixes and valuation methods. A quarter’s turnover multiple cannot be compared directly with a full year’s multiple. Stock days adjusts for period length, but seasonal trading can still make the comparison misleading.
Use the cost of goods sold calculator if you need to assemble the period’s trading-stock cost first. Decide closing-stock valuation separately before entering the reconciled balance here.
Read the Inventory Signal
A good inventory turnover ratio depends on the client’s products and stock requirements. Compare the result with the client’s earlier comparable periods and suitable businesses. A higher multiple alone does not establish better performance.
Fewer turns or more stock days gives you a reason to ask about slow-moving items. Check aged-stock records and recent purchases. An intentional seasonal build can explain the movement, while obsolete items can require a separate recoverability review.
More turns or fewer days can reflect stronger sales or lower stock holdings. Ask whether the client also experienced stockouts, missed orders or longer supplier lead times. The aggregate ratio cannot show whether each product remained available.
Investigate an unusual movement before drawing a conclusion. Reconcile purchase and sales cut-off, stocktake adjustments and write-downs. Record which change explains the ratio and what the client needs to do next.