See how many dollars of gross margin each dollar tied up in inventory earns. Enter net sales and cost of goods sold (or gross margin directly) and average inventory at cost to get GMROI, turnover, the sales-to-stock ratio and what it would take to reach a target.
Last updated:
I have
$
$
$
Net sales − COGS.
$
Adds gross margin %, turnover and sales-to-stock.
Shorter periods are annualized.
Inventory at cost
Average inventory
$
$
$
Shows the inventory or margin needed.
Enter your values to see the result.
Advertisement
Advertisement
How to use the GMROI Calculator
Enter net sales and COGS for the period, or switch to entering the gross margin amount.
Choose the period the figures cover so shorter periods are annualized.
Enter average inventory at cost, or beginning and ending inventory to average them.
Optionally set a target GMROI to see the inventory or margin you would need.
Read GMROI and compare it with the margin-and-turnover grid.
GMROI formula
Gross margin = net sales − cost of goods sold
Average inventory at cost = (beginning inventory + ending inventory) ÷ 2, or the average of several counts
GMROI = gross margin ÷ average inventory at cost
Equivalent form: GMROI = gross margin % × (net sales ÷ average inventory at cost)
Example (default values): $750,000 of net sales and $450,000 of COGS give $300,000 of gross margin (40%). With $100,000 of average inventory at cost, GMROI = 3.0: every dollar invested in stock produced three dollars of gross margin during the year. Inventory turned 4.5 times, about every 81 days.
How margin and turnover combine
The same GMROI can come from very different businesses. A 25% margin turning 9 times a year and a 60% margin turning 2 times a year both give a GMROI of 3.0. The grid in the results shows GMROI for common combinations so you can see whether margin or turnover is the better lever for a product.
Profile
Gross margin
Turnover
GMROI
Fast-moving, thin margin
25%
9×
3.00
Balanced
40%
4.5×
3.00
Slow-moving, high margin
60%
2×
3.00
Weak on both
30%
2×
0.86
Tips for using GMROI
Compare categories, not just the whole store. A strong overall GMROI can hide products that tie up cash and earn little.
Use a true average. Inventory at a single date, such as right after a big delivery or a clearance sale, can distort the result. Averaging monthly counts is more reliable.
Mind the markdowns. Use net sales after discounts and markdowns, or GMROI will look better than reality.
Pair it with carrying cost. A GMROI just above 1 may still lose money once storage, capital and shrinkage are counted.
Frequently asked questions
What is the GMROI formula?
GMROI = gross margin ÷ average inventory at cost. Gross margin is net sales minus cost of goods sold. A store with $750,000 sales, $450,000 COGS and $100,000 average inventory has $300,000 gross margin and a GMROI of 3.0.
What is a good GMROI?
A GMROI above 1 means inventory earns more gross margin than it costs. Many retailers aim for roughly 2 to 3 or more, but it varies by category: grocery runs on thin margins with fast turns, while jewelry has high margins and slow turns. Compare similar products and your own trend.
Should inventory be at cost or at retail?
At cost. GMROI measures the return on the money invested in stock, which is what you paid for it. Using retail value understates GMROI.
How do I calculate GMROI for a month or quarter?
Use gross margin for the period and the average inventory over that period, then annualize: multiply a monthly GMROI by 12 or a quarterly one by 4. This makes it comparable with yearly benchmarks.
How are GMROI and inventory turnover related?
GMROI = gross margin % × (net sales ÷ average inventory at cost). Because sales ÷ inventory equals turnover ÷ (1 − margin %), you can raise GMROI by improving either the margin or how fast stock sells.
Is GMROI the same as ROI?
No. ROI usually compares net profit with total investment. GMROI looks only at gross margin and the inventory investment, so it ignores rent, wages and other operating costs. It is a merchandising metric for comparing products and categories.
How can I improve GMROI?
Cut slow-moving stock, order smaller quantities more often, negotiate better purchase costs, reduce markdowns, and shift space and budget toward products with higher margin per dollar of inventory.
Are all the tools on FreeToolCabin tested for quality and accuracy?
Yes! Every tool on our site undergoes automated Q/A testing in real browser environments to ensure high precision, correct output, and zero errors. If you happen to spot a bug or have a suggestion, please contact us at [email protected] and our team will review it right away.