Inventory Turnover Calculator
CU-69Inventory turnover is cost of goods sold divided by average inventory. The tool also gives the days it takes to sell the average stock.
Runs in your browser. Nothing is uploaded.
Inputs
Result
| Inventory turnover | 6 times |
|---|---|
| Average inventory | 100,000.00 |
| Days to sell the inventory | 60.8 days |
How to use it
- Type cost of goods sold for the period.
- Type the inventory at the start and at the end of the period.
- Set the days in the period, 365 for a year or 90 for a quarter.
- Read the turnover, the average inventory and the days to sell.
The formulas
Average inventory = (beginning inventory + ending inventory) / 2. Inventory turnover = cost of goods sold / average inventory. Days to sell the inventory = days in the period / turnover. The tool uses cost of goods sold rather than sales, because inventory is valued at cost. If cost of goods sold is 0, the turnover is 0 and the days figure is not defined.
Worked example
Cost of goods sold for the year is 600,000. Inventory was 90,000 at the start and 110,000 at the end, so the average is 100,000. Turnover is 600,000 / 100,000 = 6.00 times. Over 365 days, selling the average stock takes 365 / 6 = 60.8 days.
Limits of a two-point average
Averaging only the first and last balance can hide swings during the year, such as a build-up before a busy season. If you have monthly or quarterly balances, average those yourself and enter the result as both the beginning and ending inventory. What counts as a high or low turnover also depends on the kind of goods, so compare with similar businesses.
Error messages and what to do
| Message | What it means | Fix |
|---|---|---|
Average inventory is zero, so turnover is not defined. Enter a beginning or ending inventory above zero. | Both inventory figures are 0. | Enter a beginning or ending inventory above zero. |
Questions people ask
How do I calculate inventory turnover?
Divide cost of goods sold by average inventory. Average inventory is the beginning and ending balances added and halved. For 600,000 and an average of 100,000, the turnover is 6.
Should I use sales or cost of goods sold?
Use cost of goods sold. Sales include a profit markup, but inventory is recorded at cost, so using sales would overstate the turnover. Take the cost figure from the same income statement period as your inventory balances.
What is days sales of inventory?
It is the days in the period divided by the turnover, which tells you how many days the average stock lasts. It appears here as days to sell the inventory.
Is a higher inventory turnover better?
Not always. A high turnover can mean efficient selling, or stock that is too thin and causes missed sales. The tool reports the ratio and does not judge it.
Can I use a period other than a year?
Yes. Use cost of goods sold for the same period, and set the days to match, for example 91 for a quarter. The turnover is then for that quarter, not annualized.
What does an error about zero inventory mean?
If both inventory balances are 0, the average is 0 and the ratio cannot be calculated. Enter a balance above zero for at least one of them.
About this tool
Inventory turnover is cost of goods sold divided by average inventory, where average inventory is the beginning inventory plus the ending inventory, divided by 2. Days to sell the inventory is the days in the period divided by the turnover. The tool uses cost of goods sold, not sales, so enter the cost figure from the income statement. A two-point average ignores swings inside the period, such as a seasonal peak. If average inventory is zero the ratio is not defined and you get an error. Amounts have no currency symbol.