ƒx

Excel Days Sales Inventory (DSI)

inventory Difficulty:

One-Click Copy

(Average_Inventory / COGS) * 365

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

Calculates the average number of days it takes to turn inventory into sales.

Determine how long cash is tied up in inventory.

Calculate DSI

Determine how long cash is tied up in inventory.

Inputs

Average_Inventory Average value of inventory during the period.
COGS Cost of Goods Sold.

Practical Example

=(100000 / 500000) * 365

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