# Inventory Turnover Ratio Calculator

The inventory turnover ratio calculator works out the number of times the inventory of the business was converted into sales or used during an accounting period.

The value of the inventory turnover ratio will depend on the industry the business operates in. A low inventory turnover ratio can indicate inefficiency in managing inventory leading to obsolete inventory, write offs and increased stock holding costs to the business.

However, if the inventory ratio is high, it may indicate that inventory levels are being maintained at too low a level in comparison to the sales leading to stock shortages and lost revenue.

The inventory turnover calculation is carried out using the inventory turnover formula by dividing the cost of goods sold by the average inventory for the period.

Inventory turnover ratio = Cost of goods sold / Average inventory

Cost of goods sold is found on the income statement. The cost of goods sold is used instead of sales as the inventory value used in the turnover formula is stated at cost.

Inventory is found on the balance sheet of the business. The average of the opening and closing inventory levels is used to avoid distorting the result.

## Using the Inventory Turnover Ratio Calculator

The Excel inventory turnover ratio calculator, available for download below, is used to compute inventory turnover by entering details relating to the cost of goods sold and the opening and closing inventory levels. The calculator is used as follows:

• The cost of goods sold is entered. Cost of goods sold is found on the income statement of the business. It is sometimes referred to as cost of sales.
• The opening and closing inventory levels are entered. The opening and closing inventory levels are found on the balance sheet of the business. The inventory turnover ratio calculator calculates the average value of inventory during the accounting period, and the inventory turnover ratio.

There is no correct value for the inventory turnover ratio as it depends on the industry in which the business operates. It is useful to compare the calculated figure with other businesses in your industry using figures available from published financial statements.