Audited 29 Jul 2026·Last updated 29 Jul 2026·6 citations·Tier 1·0 uses

Inventory Turnover Calculator

Free inventory turnover calculator. Cost of goods sold divided by average inventory, days inventory outstanding, and the stock level your target turns imply.

Inventory Turnover Calculator

Which basis?
The expense figure from your income statement for the same period the inventory balances cover. Used as the numerator on the cost basis; ignored on the retail basis.
$
Gross receipts less returns and allowances, for the same period. Used as the numerator on the retail basis; ignored on the cost basis.
$
The carrying amount on your opening balance sheet, valued the same way as the closing figure. To use a single-point inventory instead of a two-point average, enter the same number in both inventory fields.
$
The carrying amount on your closing balance sheet. Exclude anything that is not really yours to sell — goods on consignment from a supplier, or stock in transit you have not taken title to.
$
365 for a calendar year, 371 for a 53-week retail year, 91 for a quarter, 30 or 31 for a month. This only scales days inventory outstanding — it does not change the turns figure.
days
The turns figure you are managing towards, on the SAME basis you selected above. The calculator shows the average inventory that target implies and the working capital it would free or absorb.
×
Inventory turnover
8
How many times the average stock was sold through in the period. Read it together with the basis label below: a cost-basis figure and a retail-basis figure for the same business are different numbers, and neither is comparable to the other. Higher is not automatically better — turns rise when you stock out as surely as when you sell well.
Basis used
At cost — cost of goods sold ÷ average inventory
Days inventory outstanding
45.6 days
Average inventory
$300,000.00
Inventory at target turns
$240,000.00
Working capital released at target
$60,000.00

Background.

Inventory turnover answers one question: how many times did you sell through your average stock during the period? It is the single most revealing number on a stock-carrying balance sheet, because inventory is the one current asset that can quietly stop being worth what the ledger says. Cash is cash and a receivable is a promise, but a pallet of last season's stock is only worth what somebody will still pay for it.

There are two published conventions and they give different numbers, so the first thing this calculator asks is which one you want. At cost, turnover is cost of goods sold divided by average inventory — the definition used in SEC filings and in lender covenants, and the one that keeps numerator and denominator on the same measurement basis, since inventory sits on the balance sheet at cost. At retail, turnover is net sales divided by average inventory. That is the retail trade's "stock turn" and it is the basis of the most widely quoted public benchmark of all, the U.S. Census Bureau's inventories/sales ratio. For any business with a positive gross margin the retail figure is always the larger, by exactly the factor one divided by one minus the gross margin. On the worked example below, 8.0 turns at cost becomes 13.33 turns at retail purely because the margin is 40%. Comparing your cost-basis turns against a retail-basis benchmark is the most common way this metric gets read wrongly, and it makes a healthy business look sluggish.

One more comparability trap sits behind that benchmark. The Census Bureau's total business inventories/sales ratio was 1.28 at the end of May 2026, against 1.39 a year earlier. That is a monthly ratio — month-end inventories over that single month's sales — so it reads as "months of stock", not as annual turns. The example business here carries about 0.90 months of sales in stock, which is leaner than the national average, but you have to convert before that sentence means anything.

The denominator is a convention too. This page uses the two-point average of your opening and closing balances, which is what the filings that define the ratio actually specify. It is also its weakest link: for a seasonal business both dates may sit in the same post-peak trough, which understates the stock genuinely carried and flatters turns. If you have monthly balances, average those instead and enter the result in both inventory fields — the average of a number with itself is that number, so the calculator will use your figure unchanged.

Alongside the ratio you get days inventory outstanding, which is simply the period length divided by turnover and is the figure that feeds the cash conversion cycle. You also get a planning pair: the average inventory your target turns would imply at the same volume, and the working capital that moving to it would release or absorb. On the example, going from 8.0 to 10.0 turns implies holding $240,000 rather than $300,000 and would free $60,000 of cash — once, not every year.

Read the result with two limits in mind, because neither is visible in the number itself. First, high turnover is not automatically good. Turns rise when stock sells and they also rise when you run out, and a business that has cut inventory into a stockout is losing margin it will never see on this ratio. Second, this is an aggregate. A single blended turns figure hides the difference between the fast lines that pay for the warehouse and the dead stock that has not moved in two years, and the aggregate almost always looks healthier than the tail. Where the decision is about specific SKUs, run this at SKU or category level rather than on the company total. Finally, if you take title to nothing — a pure drop-ship, consignment or services business — you have no inventory flow and this ratio does not describe you.

What is inventory turnover calculator?

Inventory turnover is a ratio measuring how many times a business sold and replaced its inventory during a period. Its standard form divides the cost of goods sold for the period by the average inventory carried over that period. AnnTaylor Stores Corporation's Form 10-K for the fiscal year ended 3 February 2001 states the definition in the form still used today: "Inventory turnover is determined by dividing cost of sales by the average of the cost of inventory at the beginning and end of the period." Cache, Inc.'s Exhibit 12.1 "Computation of Ratios" gives the identical rule independently: "Inventory turnover ratio = total cost of sales divided by average inventory (beginning and ending inventory, divided by two, at the balance sheet date)."

A second, equally published convention divides net sales rather than cost of sales by the same denominator. This is retail "stock turn", and it is the basis of the U.S. Census Bureau's monthly inventories/sales ratio, which is the most widely cited public benchmark of inventory efficiency in the United States. The two conventions are not interchangeable: because sales include gross margin and inventory is carried at cost, the sales-basis ratio is always the higher of the two for a profitable business.

The reciprocal of turnover, scaled by the length of the period, is days inventory outstanding — the average number of days a unit sits in stock. Days inventory outstanding is one of the three components of the cash conversion cycle, alongside days sales outstanding and days payables outstanding. What counts as inventory is set by the accounting standards rather than by this ratio: IAS 2 Inventories provides that "when inventories are sold, the carrying amount of those inventories is recognised as an expense in the period in which the related revenue is recognised", which is why the cost of goods sold in the numerator and the inventory in the denominator are two views of the same flow of goods.

How to use this calculator.

  1. Pick your basis first, because it changes the answer more than any other input. Choose 'at cost' if you are comparing against SEC filers, a loan covenant, or your own prior years computed the same way. Choose 'at retail' if your benchmark is a retail stock-turn figure or the Census Bureau's inventories/sales series.
  2. Enter the numerator for the basis you chose — cost of goods sold, or net sales — for exactly the same period your inventory balances cover. Mixing a full-year numerator with quarter-end balances is the most common error in this calculation.
  3. Enter the opening and closing inventory carrying amounts. Use the same valuation method on both dates, and exclude anything you do not own: consignment stock from a supplier and goods in transit to which you have not taken title are not yours to turn.
  4. If your business is seasonal, do not accept the two-point average blindly. Work out the average of your monthly balances instead, then enter that single figure in both inventory fields so the calculator uses it unchanged.
  5. Set days in the period to match the numerator: 365 for a calendar year, 371 for a 53-week retail year, 91 for a quarter. This scales days inventory outstanding only; the turns figure is unaffected.
  6. Enter the target turns you are managing towards, on the same basis you selected. The calculator returns the average inventory that target implies and the working capital that moving to it would free or absorb.
  7. Read the working-capital figure as a one-off. Cutting stock releases cash once, when the stock runs down; it does not repeat every year, and it raises your stockout risk unless lead times or order frequency move with it.

The formula.

Turns = N ⁄ [(I₀ + I₁) ⁄ 2] DIO = d ⁄ Turns
Turns · inventory turnover, times per periodN · numerator — cost of goods sold (cost basis) or net sales (retail basis)I₀ · inventory at the start of the periodI₁ · inventory at the end of the period(I₀ + I₁) ⁄ 2 · average inventoryDIO · days inventory outstandingd · days in the period (365, 371, 91 …)

The denominator is the two-point average of the opening and closing inventory balances: add them and halve. The numerator is whichever figure the selected basis calls for — cost of goods sold on the cost basis, net sales on the retail basis. Dividing gives turns per period. Dividing the period length by turns gives days inventory outstanding, which is the same quantity expressed as time rather than as frequency.

Rounding stage: nothing is rounded part-way through. Turnover, days, and every currency figure are carried at full decimal precision and rounded exactly once, at the point the result is returned, to ten decimal places. This matters for days inventory outstanding specifically, because it is derived from the unrounded turnover. On the retail-basis worked example turnover is 13.3333… and days come out at exactly 27.375. Had turnover been rounded to 13.33 first, days would have come out at 27.3818 — a small error, but one that breaks the identity that days multiplied by turns must return the period length.

Using the worked example: opening inventory of $260,000 and closing inventory of $340,000 average to $300,000. Cost of goods sold of $2,400,000 divided by $300,000 is 8.0 turns, and 365 days divided by 8.0 is 45.625 days. On the retail basis, net sales of $4,000,000 over the same $300,000 gives 13.3333 turns and 27.375 days. The gap between the two is not noise: gross margin on these figures is 40%, and 8.0 divided by 0.6 is 13.3333 exactly. That relationship holds for every business — the retail-basis ratio equals the cost-basis ratio divided by one minus the gross margin — which is why the two must never be compared with each other.

The target pair is the same equation solved for the denominator. Cost of goods sold of $2,400,000 at a target of 10.0 turns implies average inventory of $240,000, which is $60,000 below the $300,000 actually carried. On the retail basis the same target of 10.0 is a looser one: $4,000,000 at 10.0 turns implies $400,000 of stock, $100,000 more than the business holds, so the released figure comes back negative. That sign flip is the reason the target must be set on the same basis as the ratio.

Invalid states are rejected rather than returned. An average inventory of zero would make turnover infinite, so it is refused with a message rather than displayed. A zero or missing numerator on the selected basis, a negative inventory balance, a non-positive period length and a non-positive target are all refused the same way, each naming the field at fault. A numerator entered for the basis you did not select is simply ignored, so leaving it blank never blocks the answer.

A worked example.

Example

A specialty hardware distributor closes its calendar year. It opened January holding $260,000 of stock at cost and closed December holding $340,000, so its average inventory for the year was $300,000. Cost of goods sold for the year was $2,400,000 against net sales of $4,000,000 — a gross margin of 40%. On the cost basis, $2,400,000 divided by $300,000 gives 8.0 turns. Days inventory outstanding is 365 divided by 8.0, or 45.625 days: the average item sits on a shelf for a little over six weeks before it is sold. That is the number to put in a covenant schedule, to compare against last year, and to feed into the cash conversion cycle. Switch the basis to retail and the same business reports 13.33 turns and 27.375 days. Nothing about the warehouse changed. Net sales are simply larger than cost of sales by the gross margin, and 8.0 divided by 0.6 is 13.33. If the owner had pulled a stock-turn benchmark from a retail trade association — those are usually quoted at retail — and compared it against the 8.0 figure, the business would have looked half as efficient as it is. The Census Bureau benchmark needs one more conversion before it is usable. Its total business inventories/sales ratio was 1.28 at the end of May 2026, down from 1.39 a year earlier, but that is month-end inventories over one month's sales — months of stock, not annual turns. This distributor holds $300,000 against $4,000,000 of annual sales, which is $333,333 a month, so its own ratio on the Census convention is 0.90. Leaner than the national average, but you only learn that after putting both numbers on the same footing. Now the planning question. The owner wants to reach 10.0 turns at cost. At the same $2,400,000 of cost of goods sold, 10.0 turns implies average inventory of $240,000, which is $60,000 below the $300,000 currently carried. That $60,000 is real cash, and it is also a one-off: it appears once as the stock runs down, and it does not repeat next year. It is not free either. Holding a fifth less stock against unchanged demand means either ordering more often, shortening lead times, or accepting more stockouts — and the margin lost on a sale that never happened does not show up anywhere in this ratio. A final sanity check against a real filer. AnnTaylor Stores reported that inventory turned 4.9 times in fiscal 2000. Its own statements give cost of sales of $622,036 thousand and merchandise inventories of $140,026 thousand and $170,631 thousand at the two year-ends, including $22,959 thousand and $33,469 thousand of sourcing-division stock that its stated definition excludes. Backing that out leaves balances of $117,067 thousand and $137,162 thousand, an average of $127,114.5 thousand, and $622,036 ÷ $127,114.5 = 4.89 — the disclosed 4.9, reproduced from the filing's own definition. Fiscal 2000 was a 53-week year, so days inventory outstanding is 371 ÷ 4.89 = 75.8 days, not the 74.6 that assuming 365 days would have given.

days In Period365
target Turnover10
cogs2,400,000
net Sales4,000,000
ending Inventory340,000
beginning Inventory260,000
basiscogs

Frequently asked questions.

What is the inventory turnover formula?
Inventory turnover equals cost of goods sold for the period divided by average inventory over the same period, where average inventory is the opening balance plus the closing balance, divided by two. AnnTaylor Stores Corporation's Form 10-K for fiscal 2000 states it as "dividing cost of sales by the average of the cost of inventory at the beginning and end of the period", and Cache, Inc.'s Exhibit 12.1 gives the same rule independently as "total cost of sales divided by average inventory (beginning and ending inventory, divided by two, at the balance sheet date)". A second convention, used in retail and by the U.S. Census Bureau, divides net sales by the same denominator instead. Both are implemented here and labelled, because the two produce different numbers from identical books.
Should I use cost of goods sold or sales in the numerator?
Use cost of goods sold if you want the ratio as filers, lenders and analysts define it. Inventory sits on the balance sheet at cost, so a cost numerator keeps both halves of the ratio on the same measurement basis and the result is not distorted by your margin. Use net sales only when your benchmark is itself computed on sales — retail stock-turn figures and the Census Bureau's inventories/sales series both are. The relationship between them is exact: the sales-basis ratio equals the cost-basis ratio divided by one minus the gross margin. At a 40% margin that is a 67% difference, which is more than enough to turn a healthy comparison into a misleading one.
What is a good inventory turnover ratio?
There is no universal figure, and any single number offered as one is describing a specific industry rather than a rule. A grocer turning perishable stock and an aircraft-parts distributor holding decades-old spares are both operating correctly at turns that differ by two orders of magnitude. The useful comparisons are your own prior periods computed identically, and firms in your own line of business on the same basis. For a rough national anchor, the U.S. Census Bureau reported a total business inventories/sales ratio of 1.28 at the end of May 2026 against 1.39 a year earlier — but that is a monthly, sales-basis ratio, so convert your figure to the same footing before reading anything into the gap.
Is higher inventory turnover always better?
No, and treating it as a target on its own is how businesses cut their way into stockouts. Turns rise when stock sells well, and they rise just as reliably when you run out of it, because the denominator shrinks while sales you never made are invisible to the ratio. High turns also come with real costs elsewhere: more frequent ordering means more ordering cost and less purchasing leverage, and thin buffers mean any supply hiccup reaches the customer. The honest framing is that turnover measures how hard your working capital is working, and the right level is the one that holds your service level at the inventory cost you are willing to carry.
How do I convert inventory turns into days?
Divide the number of days in the period by the turns figure. At 8.0 turns over a 365-day year, days inventory outstanding is 365 ÷ 8.0 = 45.625 days. Match the period length to the numerator: a 53-week retail year is 371 days, a quarter is about 91, a month 30 or 31. The days figure is the same quantity as turns expressed as time, and it is the version that feeds the cash conversion cycle, where it sits alongside days sales outstanding and days payables outstanding. This page derives days from the unrounded turnover, so days multiplied by turns returns your period length exactly.
Why does the two-point average sometimes give the wrong answer?
Because two dates cannot describe a year of stock levels, and for a seasonal business they are usually the two least representative dates in it. Most retailers close their financial year just after the peak selling season, precisely when inventory is at its lowest, so both the opening and the closing balance sit in the trough. The average of two troughs understates the stock genuinely financed through the year and flatters turnover, sometimes substantially. If you have monthly balances, average all of them and enter that single figure in both inventory fields on this page; the average of a number with itself is that number, so the calculator will use it unchanged.
What inventory should I exclude from the calculation?
Anything you do not own and anything that is not going to be sold in the ordinary course. Consignment stock held for a supplier is on their balance sheet, not yours. Goods in transit you have not taken title to are not yours either — AnnTaylor's own definition explicitly excluded its sourcing division's finished goods in transit from factories, and reproducing its disclosed 4.9 turns requires backing that stock out. Also consider excluding stock already written down to nil or held for scrap: leaving it in the denominator depresses turns without telling you anything you did not already know from the write-down.
How much cash does raising my turns actually release?
The amount by which your average inventory falls, once. On the worked example, moving from 8.0 to 10.0 turns at unchanged cost of goods sold means holding $240,000 instead of $300,000, so $60,000 of working capital comes out of stock. That is a one-time balance-sheet movement, not an annual saving, and it is the figure this calculator reports. The recurring benefit is different and smaller: the carrying cost you no longer pay on the stock you no longer hold — warehousing, insurance, obsolescence and the financing cost of the capital. Against both, set the margin on the sales you will lose to the stockouts that a thinner buffer causes.
Does my inventory costing method change the turnover ratio?
Yes, on both sides of the fraction at once. The cost-flow assumption decides which units' costs are charged to cost of goods sold and which stay on the balance sheet. In a period of rising prices, last-in-first-out pushes the newest and dearest costs into the numerator and leaves the oldest and cheapest in the denominator, which raises turnover on both counts; first-in-first-out does the reverse. Neither answer is wrong, but a business that changed method mid-comparison has produced two figures that are not comparable. IAS 2 permits only first-in-first-out and weighted average cost for interchangeable items, while US tax rules also permit LIFO, so a group reporting under both regimes can legitimately publish two different turnover figures.
Can I calculate inventory turnover for a services or drop-ship business?
Not meaningfully, because there is no inventory flow to measure. A pure services business has no stock to turn, and its equivalent line under Regulation S-X is cost of services, which is a direct-cost total rather than a movement between two counts. A drop-ship or consignment retailer never takes title to the goods, so it holds no inventory even though it sells physical products — which is exactly why those models are attractive for working capital, and exactly why this ratio has nothing to say about them. If your closing stock is genuinely zero, this calculator will decline to divide by it rather than return an infinite turnover figure.

References& sources.

  1. [1]AnnTaylor Stores Corporation, Form 10-K for the fiscal year ended 3 February 2001, filed with the U.S. Securities and Exchange Commission (retrieved from EDGAR 2026-07-29). Primary source for the implemented definition, Selected Financial Data note (j): "Inventory turnover is determined by dividing cost of sales by the average of the cost of inventory at the beginning and end of the period (excluding inventory associated with the Company's sourcing division)." The same filing supplies the disclosed 4.9x for fiscal 2000, cost of sales of $622,036 thousand, and the merchandise inventory and sourcing-division balances used to reproduce it. Open access.
  2. [2]Cache, Inc., Form 10-K for fiscal 2011, Exhibit 12.1 "Computation of Ratios", filed with the U.S. Securities and Exchange Commission (retrieved from EDGAR 2026-07-29). Independent second authority, consulted to check whether the definition above is company-specific: "Inventory turnover ratio = total cost of sales divided by average inventory (beginning and ending inventory, divided by two, at the balance sheet date)." Agrees, including on the two-point average. Open access.
  3. [3]U.S. Census Bureau, Manufacturing and Trade Inventories and Sales, May 2026, Release Number CB26-114, issued 16 July 2026 (retrieved 2026-07-29). Source for the sales-basis benchmark and the figures quoted on this page: "The total business inventories/sales ratio based on seasonally adjusted data at the end of May was 1.28. The May 2025 ratio was 1.39." Sales of $2,135.0 billion and inventories of $2,736.2 billion in the same release confirm the ratio is monthly inventories over one month's sales. Open access.
  4. [4]IFRS Foundation, IAS 2 "Inventories" (retrieved 2026-07-29). Source for what the numerator and denominator are two views of: "when inventories are sold, the carrying amount of those inventories is recognised as an expense in the period in which the related revenue is recognised", and for the permitted cost formulas being first-in-first-out and weighted average cost for interchangeable items. The standard text itself is paywalled; the cited summary page is open.
  5. [5]Internal Revenue Service, Publication 334 "Tax Guide for Small Business" — Cost of Goods Sold / Schedule C Part III, lines 35–42 (retrieved 2026-07-29). Source for how the cost-of-goods-sold numerator is built from the inventory flow: beginning inventory plus purchases, labour, materials and other costs, less ending inventory. Open access.
  6. [6]17 CFR § 210.5-03 (Regulation S-X, Rule 5-03) "Income statements", line item 2 (retrieved 2026-07-29 via the Cornell Legal Information Institute). Basis for the distinction drawn on this page between "cost of tangible goods sold" and "cost of services", and therefore for the statement that a services business has no inventory flow to turn. Open access.
Related calculators
5
COGS CalculatoruniCash Conversion Cycle CalculatoruniProfit Margin CalculatorbusBreak-Even Point CalculatorbusEconomic Order Quantity Calculatoruni

In this category

Embed

Quanta Pro

Paid features are coming later.

  • All 762 calculators remain free
  • No billing is enabled
Coming soon