Retail industry ratios: inventory, margins and cash

Retail industry ratios are most useful as a connected review of margin, inventory and liquidity for the same stores and selling season. Start with gross and operating margins, add inventory turnover and gross margin return on inventory, then reconcile the result to cash. A store can turn stock faster while earning less from the inventory it carries.

Build one comparable store view

Use net sales after returns and discounts, the cost of merchandise actually sold, store operating expenses and inventory balances valued at cost. The IRS explanation of gross profit describes subtracting returns and allowances from receipts, then deducting cost of goods sold. That supports the net-sales starting point; your controller should determine the company's accounting classifications.

Keep a store identifier, merchandise category and reporting dates on each export. Separate established stores from newly opened locations, and keep online returns assigned consistently. A change in the store population can move the company ratio without changing any established store's performance.

The comparison below covers January 1 through March 31, 2026, a 90-day period. It is an illustrative US specialty retailer, not an industry benchmark. All inventory amounts are at cost. Opening and closing averages keep the example rebuildable; use weekly or monthly balances when receipts and promotions cause large swings inside the quarter.

Work margin and stock productivity together

These are the source figures from the retailer's store P&L and inventory export:

Use the same steps for each store:

Gross profit = Net sales − COGS

Operating profit = Gross profit − Operating expenses

Average inventory = (Opening inventory + Closing inventory) / 2

Inventory turnover = COGS / Average inventory

Gross margin return on inventory, or GMROI = Gross profit / Average inventory at cost

The SEC's financial statement guide also defines inventory turnover using cost of sales and average inventory, and operating margin using operating income and net revenue. GMROI here is a management measure for this quarter, before store operating expenses.

South turns its stock faster, but North earns more gross profit per dollar of average inventory. Buyers should investigate South's realized prices, markdowns and product mix before copying its replenishment approach. North needs a different question: does its larger closing inventory represent deliberate seasonal preparation or stock that has stopped selling?

The combined figures divide combined dollars. They are not simple averages of store percentages. For definitions and alternative inventory averaging choices, see inventory turnover ratio; the separate gross profit margin guide explains the margin calculation in more depth.

Prove the inventory movement

Assume no inventory transfers, write-offs or other adjustments in this teaching example. The purchases required to reconcile the inventory are:

The identity is 160,000 + 720,000 − 640,000 = $240,000. Purchases exceed COGS because stock increased by 240,000 − 160,000 = $80,000. Charging every purchase to the quarter's P&L would therefore confuse inventory investment with the cost of sales already made.

Combined inventory days are 200,000 / 640,000 × 90 = 28.1 days. Round days and percentages to one decimal place, and turns and GMROI to two; retain full precision in the working file. Inventory days describe the period's cost flow relative to average stock, not the actual age of every item.

Reconcile operating profit to cash

Use customer receipts and supplier payments alongside the accrual accounts. This example has no depreciation or other noncash operating expenses, and the only operating timing differences are shown below.

Customer receipts are 1,000,000 − 20,000 = $980,000. Inventory supplier payments are 720,000 − 50,000 = $670,000. Other operating cash payments are 280,000 − 10,000 = $270,000. Assume cash taxes and interest of $20,000, with no other cash movements.

Cash generated after those payments is 980,000 − 670,000 − 270,000 − 20,000 = $20,000. The independent bridge gives the same result: operating profit of $80,000, less $80,000 of inventory growth and $20,000 of receivables growth, plus $50,000 of payables growth and $10,000 of expense accruals, less $20,000 of taxes and interest.

With opening cash of $40,000, closing cash is $60,000. For a timing measure rather than this dollar reconciliation, use the cash conversion cycle, keeping credit-sales denominators consistent with the customer receivables included.

Check liquidity without assuming inventory is cash

Suppose closing current assets comprise cash of $60,000, inventory of $240,000, receivables of $24,000 and prepayments of $16,000. Their sum is $340,000. With current liabilities of $200,000, the current ratio is 340,000 / 200,000 = 1.70.

Excluding inventory and prepayments gives a stricter cash-and-receivables ratio of (60,000 + 24,000) / 200,000 = 0.42. Neither ratio predicts the exact day a supplier payment can be made. Treasury still needs the due-date schedule and expected receipts.

The buyer owns stock productivity, store managers own controllable expenses, and finance owns the ledger tie and liquidity review. Connect those responsibilities in a broader retail financial analysis rather than asking one ratio to choose the action.

Where it goes wrong

• Different selling seasons. Holiday stock and clearance periods need matched comparisons, preferably with consistent fiscal weeks.
• Retail value in the inventory denominator. Turnover and GMROI here require inventory at cost; ticket prices change the measurement.
• An average of store ratios. Recompute company ratios from the summed dollars so small stores do not receive equal weight with large ones.
• Profit treated as available cash. Stock purchases, credit collections and supplier settlement can move cash without moving operating profit in the same period.

Review your retail exports in Covirage

Bring your store sales, merchandise costs, inventory balances and prepared finance exports; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See FP&A reporting in Covirage for the supporting finance workflow.