Tutorials › VEE Accounting and Finance › Inventory Turnover and Days in Inventory

VEE Accounting and Finance · Liquidity and Working Capital · Tutorial 232 of 996

Inventory Turnover and Days in Inventory

Calculate how quickly inventory is used and interpret turnover and days in inventory using consistent cost and time-period conventions.

Intermediate 10 min read

What You'll Learn

  • Calculate average inventory from beginning and ending balances.
  • Compute inventory turnover using cost of goods sold rather than sales.
  • Convert turnover into days in inventory using a stated day-count convention.
  • Understand why days in inventory is the reciprocal form of turnover.
  • Compare results over time while identifying common calculation errors.
  • Interpret turnover in context rather than treating a higher value as automatically better.

What Inventory Turnover Measures

Inventory turnover connects a period’s cost of goods sold with the inventory held to support those sales. It measures how many times, approximately, the average inventory balance was used up and replenished during the period. Days in inventory expresses the same relationship as an estimated number of days that inventory remains on hand before being sold.

These are efficiency ratios, but they also provide information relevant to working capital. Inventory represents funds tied up in goods not yet sold. A change in turnover can indicate a change in how quickly goods are moving, but the ratio alone does not explain why the change occurred or establish whether it is desirable.

Definition: For a period, inventory turnover is cost of goods sold divided by average inventory. Days in inventory is the number of days in the period divided by inventory turnover. For a full-year calculation using a 365-day convention: $$ \text{Inventory turnover}=\frac{\text{Cost of goods sold}}{\text{Average inventory}}, \qquad \text{Days in inventory}=\frac{365}{\text{Inventory turnover}}. $$

Cost of goods sold (COGS) is the expense recognized for the inventory sold during the period. Inventory is a balance-sheet amount measured at a point in time, while COGS is a flow accumulated over a period. To relate the flow to the inventory held throughout that period, the standard introductory calculation uses average inventory:

$$ \text{Average inventory} = \frac{\text{Beginning inventory}+\text{Ending inventory}}{2}. $$

Unless a problem specifies otherwise, use the arithmetic mean of the opening and closing balances and a 365-day year for annual days-in-inventory calculations. If the period is shorter or a different day-count convention is given, use that period’s days consistently. When inventory balances vary substantially during the period, an average based on more dated balances may better represent the inventory held; the two-point average is an approximation.

Why the Two Measures Are Reciprocals

The conversion from turnover to days follows directly from the definition. If annual COGS is spread evenly over 365 days, average daily COGS is annual COGS divided by 365. Dividing average inventory by average daily COGS estimates how many days of COGS the average inventory represents.

$$ \frac{\text{Average inventory}}{\text{Average daily COGS}} = \frac{\text{Average inventory}}{\text{COGS}/365} = 365\left(\frac{\text{Average inventory}}{\text{COGS}}\right) = \frac{365}{\text{COGS}/\text{Average inventory}}. $$

The final denominator is inventory turnover, so the result is \(365/\text{turnover}\). This justification also shows the underlying approximation: it treats the period’s COGS rate as representative across the period. The formula is not meaningful in the usual way if COGS or average inventory is zero, and a negative denominator does not yield an interpretable ordinary turnover measure.

1
Match the period.
Identify COGS for the period and the inventory balances corresponding to that same period.
2
Estimate average inventory.
For the standard two-point method, average beginning and ending inventory.
3
Calculate turnover.
Divide period COGS by average inventory; report the result as times per period.
4
Convert to days.
Divide the number of days in the period by turnover, or use days times average inventory divided by COGS.
5
Interpret in context.
Describe what the calculated pace suggests, while avoiding conclusions that the ratio alone cannot support.

Worked Calculations

Worked Example: Calculating Turnover and Days for One Year

A hypothetical outdoor-equipment retailer reports annual COGS of $1,200,000, beginning inventory of $180,000, and ending inventory of $220,000. Calculate average inventory, annual inventory turnover, and days in inventory using a 365-day year. State what the results measure.

Method. Use the two-point average, then divide COGS by that average. Convert turnover to days using 365 divided by turnover.

Average inventory. $$ \frac{\$180{,}000+\$220{,}000}{2} = \frac{\$400{,}000}{2} = \$200{,}000. $$

Inventory turnover. $$ \frac{\$1{,}200{,}000}{\$200{,}000} = 6.00\text{ times per year}. $$

Days in inventory. $$ \frac{365}{6.00} = 60.8333\ldots \approx 60.83\text{ days}. $$

The retailer’s COGS was six times its average inventory for the year. The corresponding days-in-inventory estimate is 60.83 days. The check \(6.00\times60.8333\ldots=365\) confirms that the two measures are reciprocal under the stated convention. The common mistake avoided here is dividing by ending inventory alone rather than by average inventory.

Worked Example: Interpreting a Change Across Years

A hypothetical home-goods distributor had COGS of $2,400,000 and average inventory of $300,000 last year. This year, its beginning inventory was $320,000, its ending inventory was $480,000, and COGS remained $2,400,000. Using 365 days for each year, calculate turnover and days in inventory for both years, then quantify the changes.

Last year’s turnover and days. $$ \text{Turnover}=\frac{\$2{,}400{,}000}{\$300{,}000}=8.00, \qquad \text{Days}=\frac{365}{8.00}=45.625\approx45.63. $$

This year’s average inventory. $$ \frac{\$320{,}000+\$480{,}000}{2} = \frac{\$800{,}000}{2} = \$400{,}000. $$

This year’s turnover and days. $$ \text{Turnover}=\frac{\$2{,}400{,}000}{\$400{,}000}=6.00, \qquad \text{Days}=\frac{365}{6.00}=60.8333\ldots\approx60.83. $$

Turnover fell by \(8.00-6.00=2.00\) turns, a decrease of \(2.00/8.00=25.00\%\). Days in inventory increased by \(60.8333\ldots-45.625=15.2083\ldots\), or 15.21 days. Relative to last year’s 45.625 days, the increase is \(15.2083\ldots/45.625=33.33\%\). The check is that this year’s unchanged COGS is being compared with a larger average inventory, so turnover must be lower and days must be higher. The calculation indicates slower turnover; it does not by itself establish the cause or whether the change is harmful.

A common mistake is to use this year’s $480,000 ending inventory as the denominator. That would give \( \$2{,}400{,}000/\$480{,}000=5.00\) turns and \(365/5.00=73.00\) days. Those figures use a single closing-date balance, not the specified two-point average, and therefore are not the standard calculation requested.

Worked Example: Why COGS, Not Sales, Is the Denominator

A hypothetical specialty-food wholesaler reports annual sales of $1,440,000, COGS of $960,000, beginning inventory of $110,000, and ending inventory of $130,000. Calculate turnover and days using the standard method. Then calculate the misleading result that would come from using sales instead of COGS, and explain the difference.

Average inventory. $$ \frac{\$110{,}000+\$130{,}000}{2} = \frac{\$240{,}000}{2} = \$120{,}000. $$

Correct turnover, using COGS. $$ \frac{\$960{,}000}{\$120{,}000} = 8.00\text{ times}. $$ Correct days in inventory. $$ \frac{365}{8.00} = 45.625 \approx45.63\text{ days}. $$

Incorrect sales-based calculation. Replacing COGS with sales would produce $$ \frac{\$1{,}440{,}000}{\$120{,}000}=12.00\text{ times}, \qquad \frac{365}{12.00}=30.4167\ldots\approx30.42\text{ days}. $$

The sales-based result overstates turnover and understates days in inventory. Sales include the selling-price margin, whereas inventory is carried at cost and COGS records the cost assigned to goods sold. Comparing inventory with COGS therefore uses a cost basis on both sides. The check is that \(8.00\times45.625=365\); the incorrect pair also multiplies to 365, but internal consistency does not make the wrong denominator appropriate. The common mistake avoided is treating sales and COGS as interchangeable.

Interpreting the Result Carefully

A higher turnover generally means more COGS was recorded relative to average inventory, corresponding to fewer days in inventory. A lower turnover generally means more inventory was held relative to the period’s COGS, corresponding to more days. Those are descriptions of the ratios, not automatic judgments about management quality.

The appropriate pace depends on the business model and the goods involved. Products with different storage requirements, production lead times, or selling patterns may naturally have different turnover. Comparisons are most useful when the businesses are reasonably comparable and the accounting policies and measurement periods are understood. Accounting choices that affect inventory or COGS can also affect the ratio, so apparent differences do not always represent operational differences.

A rise in days in inventory may prompt questions about slower sales, increased purchases, product mix, or a larger stock buffer. A fall may be consistent with faster movement, but could also warrant questions about whether stock is sufficient to meet demand. The ratio cannot distinguish among these explanations by itself. It summarizes a relationship between a period’s cost flow and an average balance; it does not report the age, condition, or composition of individual inventory items.

For a full-year calculation, use 365 days unless the question specifies another convention. If a 360-day convention is required, use 360 consistently in the days calculation. For an interim period, use the days in that period when calculating period-specific days. Do not compare a partial-period turnover directly with a full-year turnover without accounting for the differing period lengths.

Key takeaway: Calculate turnover as period COGS divided by average inventory, then calculate days in inventory as days in the period divided by turnover. Match the period, use the cost-based denominator, and interpret the result as a contextual operating measure rather than a verdict on its own.

Check Your Understanding

For each problem, use a 365-day year unless a different convention is stated. Round days in inventory to two decimal places.

  1. A hypothetical bicycle-parts retailer reports annual COGS of $1,080,000, beginning inventory of $150,000, and ending inventory of $210,000. Find average inventory, turnover, and days in inventory. (Answer: average inventory $180,000; turnover 6.00 times; 60.83 days.)
  2. A hypothetical printing-supplies distributor has beginning inventory of $275,000, ending inventory of $325,000, and annual COGS of $2,100,000. Calculate turnover and days in inventory. (Answer: average inventory $300,000; turnover 7.00 times; 52.14 days.)
  3. A hypothetical manufacturer has average inventory of $240,000 and annual COGS of $2,190,000. Calculate turnover and days in inventory, and verify that the two measures are consistent. (Answer: turnover 9.125 times; 40.00 days; \(9.125\times40=365\).)
  4. A hypothetical furniture seller has annual COGS of $3,600,000, beginning inventory of $400,000, and ending inventory of $500,000. Calculate turnover and days using average inventory. Then give the turnover and days that would result from incorrectly using ending inventory alone. (Answer: correct average inventory $450,000, turnover 8.00 times, and 45.63 days; ending-inventory calculation 7.20 times and 50.69 days.)
  5. Two hypothetical divisions each report annual sales of $2,000,000 and average inventory of $200,000. Division A has COGS of $1,200,000; Division B has COGS of $1,600,000. Calculate each division’s turnover and days, and identify which has the higher turnover. (Answer: A—6.00 times and 60.83 days; B—8.00 times and 45.63 days; Division B has the higher turnover.)
Clinical Biostats