Inventory Turnover
Learn more about Financial Manager business summary data
Learn how to design financial statements
In the Financial Manager, inventory turnover shows cost of sales in relation to average inventory. This ratio indicates the effectiveness of a company's inventory management.
The calculation for this ratio is
where:
Cost of Sales = the sum of all Cost of Sales account types
where:
Inventory Balance = the sum (dollar amount) of all Inventory account types
Beginning Inventory Balance (for the first available period) = the sum of all inventory beginning balance entries
Beginning Inventory Balance (for all other periods) = the inventory ending balance entry for the previous period
Ending Inventory Balance (for the current period) = the inventory balance for the current period as of the date specified in the Date field
Ending Inventory Balance (for all other periods) = the ending inventory balance for the period being reported
Example
If beginning inventory is $70,000 and ending inventory is $80,000, then average inventory is $75,000.
If cost of sales is $30,000 and average inventory is $75,000, then inventory turnover is 0.40.
The calculations for this example are
