The five judgement calls behind the number.

The formula is inventory turnover = COGS / average inventory. Every other page on the internet stops there. The decisions below are why two finance teams can run the same formula on the same business and report different ratios.

Decision 1. Average inventory or ending inventory?

Use average inventory. It is the auditor-preferred denominator because it absorbs the seasonality that a single point-in-time balance misses. Average is the default in this calculator.

Use ending inventory only when (a) the business is genuinely steady-state with negligible seasonal swing, (b) you are matching an existing internal flash report that uses ending, or (c) you only have one balance point (a brand-new accounting period). Toggle is in the calculator and the trade-off is unpacked on the average vs ending page.

Use a 12-month rolling average when the business is seasonal enough that the two-point average misleads. December and June inventory in a Christmas-driven retailer bear no resemblance to each other; a 12-month average is the only defensible denominator. The calculator supports this on request.

Decision 2. What do you do about LIFO reserves?

US GAAP businesses on LIFO often carry a LIFO reserve that understates inventory by billions in extreme cases (oil majors, heavy industrial). Two ways to handle it:

• Report turnover on FIFO equivalents. Add the LIFO reserve back to inventory and reduce COGS by the change in the LIFO reserve. This is what the Damodaran NYU Stern dataset does, which is why our industry medians are LIFO-adjusted. If you are benchmarking against our medians, you must adjust.
• Report turnover on as-reported LIFO. Defensible internally if your covenant is computed on as-reported figures; never defensible for cross-company comparison.

The calculator does not auto-adjust because the LIFO reserve is not on the trial balance in a single line for most systems. Pull the reserve from the inventory footnote, do the adjustment in the calculator inputs, and document it.

Decision 3. Why do we annualise, and what does it cost you?

Inventory turnover is meaningless if numerator and denominator are measured over different windows. The denominator (inventory) is a balance sheet item, always point-in-time. The numerator (COGS) is a flow, always period-bound. To make the ratio comparable across reporting cadences, we annualise the numerator: a 90-day window with $600,000 of COGS becomes $2.43M annualised, and the ratio is then $2.43M / average inventory.

What this costs you: a Q4-heavy retailer that annualises Q4 alone will overstate turnover by 30 to 50 percent, because Q4 COGS is multiplied by four. The calculator warns when the window is under a full year. For a covenant or board read-out, use a trailing twelve months. For an operational read-out, use the actual period, but do not compare it to an annual median without saying so.

Decision 4. When should you ignore the industry median entirely?

The 16 industry medians on this site are signals, not targets. Ignore them when:

• Your business model has changed in the last 12 months (acquisition, channel shift, new product line). The median is a benchmark for a steady-state company; you are not one.
• You operate in a hybrid category (a manufacturer that also direct-to-consumer ships, a wholesaler with a retail arm). The median for either pure category will mislead.
• Your inventory mix is dominated by a single item with abnormal cycle behaviour (a custom-build SKU with a six-month lead time inside an otherwise three-week business). Compute turnover separately for the abnormal item and the rest, then weight.
• You are below $5M in revenue. Median behaviour at that scale is noise-dominated. The NYU Stern dataset is built on listed companies; small-business turnover is not in the sample.

Decision 5. Should you use sales or COGS in the numerator?

Use COGS. Sales-to-inventory (sales in the numerator) is a holdover from pre-1980s retail practice and inflates the ratio by the gross margin. A 40 percent gross margin business will look 1.67 times more turnover-efficient on sales than on COGS, which is not a real efficiency gain. It is the markup. Auditors, lenders, and the Damodaran dataset all use COGS.

Use sales only when the business has no cost data (a distributor reselling someone else’s product at a fixed margin) or when matching a legacy internal report. The sales-to-inventory ratio page walks the conversion.

Where our medians come from

Primary anchor is the NYU Stern working-capital dataset maintained by Aswath Damodaran. Cross-check sources include the U.S. Census Annual Retail Trade Survey, the U.S. Census Monthly Wholesale Trade and M3 series, and the RMA Annual Statement Studies bands. Per-industry source identifiers are listed inline on each atlas page and consolidated at sources.

NYU-STERN 2026 FASB 2026 RMA 2026

Not legal, tax, or investment advice

The calculator and the atlas are reference tools. Apply them with a CPA, an asset-based-lending adviser, or the audit team before using outputs in covenant negotiation or external filings.