Days in Inventory Calculator

Inventory Days Outstanding Calculator

Days in Inventory Formula

Formula

\[ \text{Days in Inventory} = \frac{\text{Average Inventory}}{\text{Cost of Goods Sold}} \times D \] \[ \text{Days in Inventory} = \frac{D}{\text{Inventory Turnover Ratio}} \]

Where:

$ \text{Average Inventory} $ — the average value of inventory held during the period, usually computed as $ \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2} $
$ \text{COGS} $ — cost of goods sold over the same period
$ D $ — number of days in the period (365 for a year, 90 for a quarter)

The formula shows how many days, on average, a company needs to sell its entire inventory. Since the inventory turnover ratio is $ \frac{\text{COGS}}{\text{Average Inventory}} $, dividing the period length by that ratio gives the same result.

Days in Inventory – Calculation Example

Example: a company reports an average inventory of $20,000 and annual cost of goods sold of $100,000, analyzed over 365 days.

\[ \text{Days in Inventory} = \frac{20{,}000}{100{,}000} \times 365 = 0.20 \times 365 = 73 \text{ days} \]

Result: 73 days. The company holds its inventory for about two and a half months before selling it — a moderate turnover pace for many industries.

How to Use the Days in Inventory Calculator

Enter the Average inventory value. If you only know the beginning and ending inventory, add them together and divide by two.
Enter the Cost of goods sold (COGS) for the same period, taken from the income statement.
Enter the Number of days in the period — 365 for a full year or 90 for a quarter.
Read the Days in Inventory result in days, along with the interpretation of the turnover speed.

What Is Days in Inventory?

Days in Inventory (also called Days Inventory Outstanding, or DIO) measures the average number of days a company keeps its inventory in stock before selling it. It is one of the three components of the cash conversion cycle, alongside days sales outstanding and days payable outstanding. Together, these metrics show how long it takes to turn resource investments into cash.

The metric matters because inventory ties up working capital. Every day a product sits on a shelf or in a warehouse, the company has money locked in goods that produce no return and may lose value. A shorter inventory period frees cash faster, reduces storage and insurance costs, and lowers the risk of obsolescence — particularly important for perishable goods, electronics, and fashion items.

How to interpret the result: there is no single "good" number, because the answer depends heavily on the industry. Fresh food retailers often operate at 10–20 days, while machinery manufacturers or jewelry sellers may exceed 200 days. The number is most meaningful when compared with the company's own history, direct competitors, or industry benchmarks. A consistently rising figure usually signals overstocking, weakening demand, or purchasing problems; a falling figure generally means faster sales or leaner operations. The interpretation shown with the result (fast, moderate, or slow turnover) is a general guideline — always benchmark against your sector.

Assumptions, Limitations and Practical Tips

Use consistent periods. Average inventory and COGS must cover the same time frame, and the number of days must match that frame, or the result will be distorted.
COGS, not revenue. The calculation uses cost of goods sold, not sales. Inventory is recorded at cost in the balance sheet, so using revenue would understate the result.
Average smooths seasonality. The simple (beginning + ending) / 2 average can misrepresent seasonal businesses. For those, use monthly inventory balances averaged over the year.
A low number isn't always better. Very fast turnover may mean stockouts, lost sales, and rushed purchasing. Tools like the Economic Order Quantity calculator help find the balance between ordering costs and holding costs.
Compare like with like. Different accounting methods change the numbers. For example, the FIFO inventory cost method and the Ending Inventory calculator both affect the inventory value used in the formula.
Watch it alongside other metrics. Pair days in inventory with liquidity measures such as the Acid Test Ratio and efficiency measures like Total Asset Turnover for a fuller picture of operational health.

Frequently Asked Questions

How do I calculate days in inventory by hand?

Take your average inventory, divide it by cost of goods sold, then multiply by the number of days in the period. For example, average inventory of $ $50{,}000 $ and annual COGS of $ $250{,}000 $ give $ \frac{50{,}000}{250{,}000} \times 365 = 73 $ days. If you already know the inventory turnover ratio, simply divide the period length by it: $ 365 \div 5 = 73 $ days.

What is a good number of days in inventory?

There is no universal target — it depends on the industry. Grocery stores often run 10–20 days, general retailers 30–60 days, and heavy machinery or jewelry businesses can exceed 200 days. A useful rule of thumb: anything under 30 days is fast, 30–90 days is moderate, and above 90 days warrants investigation. The most reliable benchmark is the company's own trend over recent periods plus direct competitors in the same sector.

Should I use 365 or 360 days in the formula?

Both appear in practice. Analysts often use 365 for calendar accuracy, while some textbooks and financial models use a 360-day banker's year for simplicity. The choice slightly changes the result — a 360-day basis gives a value about 1.4% lower. Whichever you pick, stay consistent across periods and when comparing companies, otherwise the comparison is slightly distorted.

Is days in inventory the same as DIO and DSI?

Yes, mostly. Days in inventory, Days Inventory Outstanding (DIO), and Days Sales in Inventory (DSI) refer to the same concept. One technical difference: some analysts compute DSI using ending inventory rather than the average. Using the ending balance gives a snapshot of the final position, while the average smooths out changes during the period. Most financial analysis prefers the average-based version for consistency with the turnover ratio.

Why is my days in inventory result so high or zero?

A very high result usually means inventory is large relative to COGS — check that you used cost of goods sold, not revenue or gross profit, since revenue inflates the denominator. Also verify the period matches: annual COGS with a 90-day setting will distort the answer. A result of zero simply means no inventory was held. If COGS is zero, the metric is undefined because nothing was sold during the period.

How does days in inventory fit into the cash conversion cycle?

It is the first of three components. The cash conversion cycle equals days in inventory plus days sales outstanding minus days payable outstanding: $ CCC = DIO + DSO - DPO $. It measures how many days pass between paying suppliers for goods and collecting cash from customers. Lowering days in inventory shortens the cycle and frees working capital, which is why the two metrics are usually tracked together.

What can a company do to reduce its days in inventory?

Common levers include better demand forecasting, smaller and more frequent purchase orders, dropping slow-moving product lines, and clearing obsolete stock with promotions. Tools like Economic Order Quantity (EOQ) analysis help balance ordering costs against holding costs. Be careful not to over-optimize: pushing inventory too low risks stockouts, rush orders, and lost customers, so the goal is an efficient level, not the absolute minimum.