ƒx

Excel Inventory Turnover Formula

inventory Difficulty:

One-Click Copy

COGS / Average_Inventory

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Measures how many times inventory is sold or used in a given time period.

Understand how efficiently you cycle through inventory.

Calculate Inventory Turnover

Understand how efficiently you cycle through inventory.

Inputs

COGS Cost of Goods Sold.
Average_Inventory (Beginning Inventory + Ending Inventory) / 2.

Practical Example

=500000 / 100000

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.