How this inventory turnover calculator works
An inventory turnover calculator shows how many times stock was sold and replaced over a period. The headline is the inventory turnover ratio. Details show average inventory, days sales of inventory (DSI) when turnover is greater than 0, COGS, and the beginning and ending balances. Open Period length to change the days used for DSI (default 365). This is an accounting estimate, not a forecast.
Choose a currency, then enter COGS (0 or more), beginning inventory (0 or more), and ending inventory (0 or more). Empty any of those three is no result. Typed 0 is valid. Days in period start at 365. Empty or 0 days while Period length is open fall back to 365. Closing the section uses 365 even if a custom count stays typed.
How to use the inventory turnover calculator
- Choose a currency and enter cost of goods sold for the period. Typed 0 is valid; leaving COGS empty is no result.
- Enter beginning inventory and ending inventory. Typed 0 is valid; leaving either empty is no result.
- Read the turnover ratio and average inventory. When turnover is greater than 0, also read DSI.
- Open Period length only if you want DSI on a period other than 365 days (for example a quarter). Closing it uses 365 for DSI even if another count stays typed, and a share link saved then omits that count.
Period length, and closing it
This section is GPA-style. Days in period default to 365, and they feed DSI only while Period length is open. Empty or typed 0 days while it is open fall back to 365. Closing it uses 365 even if a custom count stays typed. Reopening uses that count again. A share link saved while the section is closed does not keep the custom days.
Turnover and DSI formulas
Average inventory is (beginning + ending) ÷ 2. Turnover is COGS ÷ average inventory when average inventory is greater than 0; otherwise turnover is 0. DSI is days in period ÷ turnover when turnover is greater than 0; otherwise the DSI row stays hidden. While Period length is closed, days in period are 365 even if another count stays typed.
Worked examples
Example: COGS USD 200,000, beginning USD 50,000, ending USD 30,000
Leave Period length closed (365 days). Average inventory is (50,000 + 30,000) ÷ 2 = USD 40,000.00. Turnover is 200,000 ÷ 40,000 = 5.00. DSI is 365 ÷ 5 = 73.0 days.
Example: the same stock over a 90-day quarter
Open Period length and enter 90 days. Turnover stays 5.00. DSI is 90 ÷ 5 = 18.0 days. Closing the section returns DSI to 365 ÷ 5 = 73.0 even if 90 stays typed. A share link saved while the section is closed does not keep the 90.
Example: beginning and ending inventory both USD 0
Average inventory is USD 0.00, so turnover is 0.00 (the widget does not divide by zero). The DSI row stays hidden because turnover is not greater than 0.
Things to keep in mind
Keep COGS and both inventory values on the same period. Benchmarks vary widely by industry; this page does not enforce one. Amounts are an ISO currency code, then the number (USD 40,000.00). Switching currency only changes formatting.
Inventory turnover calculator FAQ
Do I have to fill COGS, beginning inventory, and ending inventory?
Yes. Each must be filled at 0 or more. Empty any of those three is no result. Typed 0 is valid.
Why is DSI sometimes hidden?
DSI needs turnover greater than 0. If average inventory is 0, or COGS is 0 with a positive average, turnover is 0 and DSI stays hidden.
Does closing Period length reset days to 365?
For the result, yes. Closing treats the typed days as unused, so DSI uses 365. On a turnover of 5.00, DSI returns from 18.0 to 73.0. The number stays in the field; reopening uses it again. A share link saved while the section is closed does not keep the custom days.
What if I leave days empty while Period length is open?
Empty or typed 0 days fall back to 365, the same 365 a closed section uses.
Is this a yearly ratio even on a 90-day period?
Turnover is COGS ÷ average inventory for whatever period you entered. DSI then uses the days you set. A 90-day COGS with 90 days is a quarterly story, not an annualized one.
Does this inventory turnover calculator store my numbers?
Completed results can be saved in this browser’s local history so you can reopen them later. They stay on your device and are not sent to our servers or to analytics.