Articles

How do you calculate liquor store inventory turnover and GMROI?

Turns are the year's cost of sales divided by the average stock at cost; GMROI is gross profit divided by stock at cost. Compute both by category.

In the worked store, cost of sales of $2,202,925 over an average stock of $396,000 gives 5.56 turns, about 66 days on hand. By category, wine earns $1.56 of gross profit a year per dollar of stock, beer $3.89.

The two formulas

Turns = cost of goods sold ÷ average inventory at cost. GMROI = gross profit ÷ inventory at cost.

Use counts by an outside inventory service for the stock, and the point-of-sale cost for the sales. The worked store's counts were $382,000 and $410,000, a year apart.

Fictional store of the book, stock on the latest count; teaching assumptions, not market norms.
CategoryStock at costTurnsGMROI
Spirits$205,0005.101.66
Wine$150,0003.391.56
Beer, hard seltzer and ready-to-drink$38,00014.213.89
Mixers, snacks, ice, cigars and accessories$17,0006.413.30

Worked in full in The Liquor Store Owner by Julian R. Sterling.Get the DRM-free PDF, $19.99 →or the paperback

Free: the liquor store acquisition model in Excel, from net income to SDE, the offer, the inventory price and the SBA 7(a) loan with its checks.

Reading the table

Wine has the highest margin of the three drinks categories and the lowest return on its stock, because it sits on the shelf longest. Beer keeps the least of each sale and earns the most on each dollar of stock, because it sells in under four weeks. Inventory discipline pays most in the slowest category.

Dead stock and the price of the inventory

Inside the worked store's $410,000 count sit $31,000 of items with no sale in twelve months and $3,400 of beer past its code date. A buyer pays for the stock separately from the business: saleable stock at cost, dead stock at half of cost, out-of-code beer at nothing. On these terms the count is worth $391,100, not $410,000.

The trap: books that charge every purchase as cost. A rise in stock then looks like a cost. Only two counts, a year apart, show how much the year really earned.

Figures checked on 18 November 2026. The store in the examples is fictional and its figures are teaching assumptions, not market norms. Not legal, tax or lending advice.

Questions readers ask

What is a good inventory turnover for a liquor store?

It depends on the mix: beer turns far faster than wine. Compare each category with its own history, and watch GMROI as well as turns.

How do you value inventory when buying a liquor store?

By a count at cost the night before closing, with agreed terms for dead stock and out-of-code beer; it is added to the price of the business.

What is GMROI?

Gross margin return on inventory: a year's gross profit divided by the average stock at cost, the dollars of gross profit each dollar on the shelf earns.

Read the whole book

This article is one calculation from The Liquor Store Owner, a practitioner’s guide to buying and running an independent liquor store by the numbers: margin by category, inventory turns, shrink, the purchases and sales test, the license, the lease, SDE, the price and SBA financing.

Also on this site