The GMROI calculator measures how much gross profit you generate for each dollar invested in average inventory. Enter your starting inventory, ending inventory, and gross profit for the same period to calculate gross margin return on inventory investment.
The calculator displays GMROI as a percentage. For example, 250% means $2.50 in gross profit for every $1 of average inventory held at cost during the period—not $2.50 in net profit.
How to use the GMROI calculator
- Enter Starting Inventory Value: the cost value of inventory on hand at the beginning of your reporting period.
- Enter Ending Inventory Value: the cost value of inventory remaining at the end of that period.
- Enter Gross Profit: net sales minus cost of goods sold for the same period. Enter a dollar amount, not a gross margin percentage.
- Read the results: Average Inventory shows the midpoint of your starting and ending inventory values. GMROI shows gross profit divided by that average, expressed as a percentage.
Use inventory values at cost, not at retail selling prices, and apply a consistent inventory valuation method. You can analyze a whole store, a department, or a product category, but all three inputs must cover the same products and dates.
Gross profit is not net income or contribution margin. Cost of goods sold is also not interchangeable with all variable costs: for example, sales commissions may vary with sales but are generally treated as selling expenses rather than inventory costs.
GMROI formula and worked example
The calculator uses these formulas:
Average inventory = (Starting inventory + Ending inventory) ÷ 2
GMROI (%) = (Gross profit ÷ Average inventory) × 100
GMROI is also commonly reported as a ratio or multiple. A result of 250% is equivalent to 2.5 or 2.5×. The underlying calculation is the same; only the display format differs.
Example: calculating a retailer’s annual GMROI
Suppose a retailer reports the following figures for one year:
| Item | Value |
|---|---|
| Starting inventory at cost | $60,000 |
| Ending inventory at cost | $40,000 |
| Annual gross profit | $125,000 |
| Average inventory: ($60,000 + $40,000) ÷ 2 | $50,000 |
| GMROI: ($125,000 ÷ $50,000) × 100 | 250% |
The retailer generated $2.50 in annual gross profit per $1 of average inventory investment. This does not mean it earned a 250% margin on sales: GMROI uses average inventory as its denominator, not revenue.
What is a good GMROI?
There is no universal target. An appropriate GMROI depends on product margins, replenishment speed, seasonality, and the costs of running the business. Compare results with your own targets, prior comparable periods, and similar product categories rather than treating one number as an industry-wide standard.
- Above 100%: gross profit exceeds the average inventory value for the period.
- Exactly 100%: gross profit equals the average inventory value.
- Between 0% and 100%: gross profit is positive but lower than the average inventory value.
- Below 0%: gross profit is negative, assuming average inventory is positive.
A higher GMROI generally indicates more gross profit per dollar tied up in stock. However, 100% is not a business break-even threshold. Gross profit still has to cover operating expenses, financing costs, taxes, and other costs not included in cost of goods sold.
GMROI is related to return on investment (ROI), but it is not a comprehensive investment return or a direct measure of cash flow.
Keep the period and inventory average in perspective
This calculator does not annualize your result. A monthly GMROI of 30% and an annual GMROI of 250% cover different lengths of time and should not be compared directly. Use matching periods, especially when sales are seasonal.
The calculator averages only the opening and closing inventory balances. If stock levels fluctuate substantially between those dates, the result may not represent the inventory actually carried throughout the period. For a separate, more detailed analysis, consider an average based on regular monthly or weekly inventory snapshots.
Average inventory must be positive for a meaningful GMROI calculation. A zero average makes the division undefined; negative inventory values usually call for a review of the underlying records.
How to use GMROI to improve inventory decisions
Retailers and wholesalers can use GMROI to identify where inventory investment is producing stronger or weaker gross returns. Review it alongside total gross profit, sales volume, stock availability, and customer demand.
- Compare product categories: identify categories that tie up substantial inventory while contributing relatively little gross profit. Investigate pricing, markdowns, and slow-selling stock before changing purchasing plans.
- Test pricing and purchasing changes: better supplier terms or fewer unnecessary discounts can improve gross profit. Higher prices help only if the effect on sales volume does not outweigh the margin gain.
- Reduce excess stock carefully: smaller orders and better replenishment timing can lower average inventory. Avoid cuts that create stockouts and lost gross profit.
- Plan seasonal buying: review comparable seasons and expected demand rather than using an unusually low year-end balance as evidence of efficient inventory management.
A higher percentage is not always the best outcome in isolation. A category with lower GMROI may still contribute substantial gross profit or carry products customers expect you to stock.
Related inventory and profitability calculators
- Ending Inventory Calculator: helps establish the closing inventory value needed for your analysis.
- Inventory Turnover Calculator: measures how often average inventory is sold and replaced. Turnover measures movement; GMROI measures gross profit relative to inventory investment.
- Days Inventory Outstanding Calculator: expresses inventory holding time in days. A lower value generally means inventory moves faster, but does not by itself establish profitability.
- Return on Assets Calculator: provides a broader view of profitability relative to the company’s total assets, rather than inventory alone.
You can find additional financial and business tools at Calcopolis.
Build an inventory return calculator for your website
Retail consultants and inventory software providers can use the Calcopolis ROI calculator builder to create a customized tool that lets prospects compare inventory scenarios before requesting a consultation.