Annual Inventory Turnover Formula
Learn how annual inventory turnover, average inventory, and days inventory outstanding are calculated from COGS and inventory balances.
Annual inventory turnover estimates how many times a business sold and replenished its average inventory over a year. The ratio helps put inventory levels in context with the cost of goods sold, while days inventory outstanding expresses the result as an estimated holding period.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Annual Inventory Turnover
Where:
First calculate the average inventory balance for the year. Then divide annual cost of goods sold by that average to estimate how many times inventory turned over.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| costOfGoodsSold - Annual Cost of Goods Sold | The total cost of inventory sold during the accounting year, excluding the sales markup. | currency |
| beginningInventory - Beginning Inventory | The inventory balance recorded at the start of the accounting year. | currency |
| endingInventory - Ending Inventory | The inventory balance recorded at the end of the accounting year. | currency |
| averageInventory - Average Inventory | The mean of the beginning and ending inventory balances. | currency |
| inventoryTurnover - Annual Inventory Turnover | The estimated number of times average inventory was sold and replenished during the year. | number |
| daysInventoryOutstanding - Days Inventory Outstanding | The estimated average number of days inventory was held before sale. | days |
Step-by-Step Calculation
Record annual cost of goods sold
Use annual COGS from the income statement rather than sales revenue, because inventory is generally measured at cost.
costOfGoodsSold
Calculate average inventory
Add the opening and closing inventory balances and divide by two.
(beginningInventory + endingInventory) / 2
Calculate annual inventory turnover
Divide annual COGS by average inventory to estimate annual stock turns.
costOfGoodsSold / averageInventory
Calculate days inventory outstanding
Divide 365 by the turnover ratio to translate annual turns into an estimated average number of days held.
365 / inventoryTurnover
Annual inventory turnover calculation example
Calculate average inventory
($100,000 + $150,000) / 2
$125,000
Calculate inventory turnover
$500,000 / $125,000
4.00 times
Calculate days inventory outstanding
365 / 4.00
91.25 days
Final Result
Annual inventory turnover is 4.00 times, with average inventory of $125,000 and estimated days inventory outstanding of 91.3 days.
Assumptions
- ✓COGS, beginning inventory, and ending inventory relate to the same annual accounting period.
- ✓Beginning and ending inventory are valued consistently at cost.
- ✓Average inventory is represented by the simple average of two balance points.
- ✓The year is treated as 365 days for the days inventory outstanding estimate.
Limitations
- !A two-point average may not represent typical inventory levels in a highly seasonal business.
- !The calculation does not separately identify obsolete, damaged, consigned, or slow-moving stock.
- !Changes in costing methods, product mix, or accounting classifications can reduce comparability between periods.
- !A ratio alone does not show whether inventory levels are sufficient to meet demand.
Common Mistakes to Avoid
Using sales revenue instead of cost of goods sold in the turnover formula.
Using ending inventory alone when the calculation calls for average inventory.
Combining COGS from one period with inventory balances from another period.
Comparing turnover ratios across businesses with substantially different product types or inventory methods.
Treating a higher turnover ratio as automatically better without considering stock availability and margins.
Related Formulas
Frequently Asked Questions
What is the formula for annual inventory turnover?
Annual inventory turnover equals annual cost of goods sold divided by average inventory. Average inventory is commonly calculated as beginning inventory plus ending inventory, divided by two.
How do you calculate average inventory?
Add beginning inventory and ending inventory, then divide by two. For businesses with large seasonal changes, monthly or more frequent balances may provide a more representative average.
Why is COGS used instead of sales revenue?
Inventory is ordinarily recorded at cost, so COGS uses a comparable cost-based measure. Sales revenue includes markup and can overstate the ratio.
How are days inventory outstanding calculated?
Days inventory outstanding equals 365 divided by annual inventory turnover. It estimates the average number of days inventory remains on hand before sale.
Can inventory turnover be less than 1?
Yes. A result below 1 means annual COGS was lower than average inventory. This may occur with slow-moving stock, long production cycles, or inventory accumulated for future demand.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.