Inventory Turnover and DSI
Turnover ratio, days sales of inventory, comparison against bundled industry median (Census ARTS / SBA).
Example
You enter
- COGS (USD) 2000000
- Beginning inventory (USD) 250000
- Ending inventory (USD) 270000
- Period days 365
You get
- Turnover 7.69x
- Days sales of inventory 47.45
- Average inventory 260000
Details, formula, and sources
Average inventory = (BI + EI) / 2. Turnover = COGS / avg_inventory. Days sales of inventory = period_days / turnover.
Standard inventory-management identity. Industry medians bundled from U.S. Census Annual Retail Trade Survey (ARTS) and SBA published medians.
Free at census.gov/retail/arts. SBA at sba.gov/data.
Estimate. Verify before sending to your bookkeeper, banker, or CPA.
Field names used by the API: cogs, beginning_inventory, ending_inventory, period_days, turnover, days_sales_of_inventory, average_inventory
- Average method simple average of beginning and ending inventoryconvention; some firms use 13-month rolling
- Period days 365 defaultcalendar year