KPI calculator

Inventory Turnover Calculator

Enter your values to calculate Inventory Turnover. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Inventory Turnover books Books that help you understand Inventory Turnover and related business metrics more deeply. Explore resources → Inventory Turnover audiobooks Audiobook searches for learning Inventory Turnover while commuting, walking, or working. Explore resources → Accounting Excel resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Financial statement analysis Practical resources for turning Inventory Turnover into reports, dashboards, and business decisions. Explore resources →

Calculate Inventory Turnover

Cost of Goods Sold Average Inventory

Result—

Formula

Cost of Goods Sold / Average Inventory

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

Inventory Turnover =
DIVIDE(
    [Cost of Goods Sold],
    [Average Inventory]
)

Read the complete Inventory Turnover formula guide →