GMROI Calculator — Gross Margin Return on Investment

Background.

Every item on a retailer's shelves or in its stockroom is money already spent, waiting to come back with a profit attached. Gross margin return on inventory investment, GMROI, measures how hard that money works: the gross margin a business earned over a period divided by the average amount it had tied up in inventory, valued at cost, across the same period.

A result of 2.4 says each dollar of stock carried through the period brought back $2.40 of gross margin, the money left after paying for the goods themselves, out of which rent, wages and everything else still have to be met. Buyers and merchandise planners use it to compare departments, categories or suppliers that sell in very different ways. A counter of slow, high-margin goods and an aisle of fast, thin-margin goods can land on the same GMROI, because the ratio rewards margin and speed of sale together.

That double reward is easiest to see by splitting the ratio in two. GMROI equals gross margin percentage multiplied by sales divided by average inventory at cost, so a line can raise it by pricing better, by buying better, or simply by carrying less stock for the same sales.

The arithmetic is one division, and it is only as good as the two figures fed into it. Both must cover the same period and the same currency, and the inventory must be valued at cost, not at its ticketed selling price. A quarter's margin divided by a full year's average stock produces a number that looks precise and means nothing. The ratio is also purely descriptive: financing costs, taxes, shrink, markdown timing and the moment cash actually arrives all sit outside it, and it is not investment advice.

What is gmroi calculator — gross margin return on investment?

GMROI, short for gross margin return on inventory investment and sometimes expanded as gross margin return on investment, is the ratio of gross margin earned to the average inventory held at cost during the same period. Gross margin is net sales minus the cost of the goods sold. Average inventory is the mean value of stock on hand at what the business paid for it, normally taken from several counts or month-end balances across the period. Both are money amounts in one currency, so the units cancel and the result is a plain number.

How to use this calculator.

1. 01Take the period's gross margin from your income statement or point-of-sale reports (net sales after returns and discounts, minus cost of goods sold) and enter it in Gross margin amount.
2. 02Work out average inventory for exactly the same period. The opening balance plus the closing balance, divided by two, is the minimum; averaging twelve month-end balances is better for any business with a busy season.
3. 03Check that the inventory figure is at cost. If your system values stock at retail, convert it back to cost before typing it into Average inventory at cost.
4. 04Read the result as margin earned per unit of currency held in stock, and compare it only with GMROI figures built on the same period length and accounting basis.

The formula.

GMROI = gross margin ÷ average inventory at cost. The numerator is what the period's sales earned over and above the cost of the goods sold; the denominator is the money that, on average, sat in stock to make those sales possible. Dividing one by the other gives margin earned per dollar invested in inventory. The same ratio can be rewritten as gross margin % × (net sales ÷ average inventory at cost), or, using inventory turnover on a cost basis (cost of goods sold ÷ average inventory), as gross margin % × turnover ÷ (1 − gross margin %). That last form shows why both levers matter: a higher margin raises the first factor and shrinks the divisor, while holding less stock for the same sales raises turnover directly. The page applies no annualizing, so the result covers whatever period the two inputs share.

A worked example.

Frequently asked questions.

References& sources.

1. [1]U.S. Census Bureau, Monthly Retail Trade Survey, inventory and gross-margin concepts.
2. [2]NRF Foundation, Retail Math concepts (BIBLIOGRAPHIC).
3. [3]BIPM, The International System of Units (SI Brochure), 9th ed., version 3.01, coherent derived units and quantity equations.