Retail inventory method calculator
Estimate what your stock is worth at cost without a full count. Use the same period for every number.
Cost-to-retail ratio
Ending inventory at retail
Ending inventory at cost
Worked out in your browser. Nothing is saved or sent.
The math
- Cost-to-retail ratio = (beginning inventory at cost + purchases at cost) ÷ (beginning inventory at retail + purchases at retail).
- Ending inventory at retail = beginning inventory at retail + purchases at retail − sales.
- Ending inventory at cost = ending inventory at retail × cost-to-retail ratio.
Read next
Article
The retail inventory method explained simply, with a worked example
The retail inventory method estimates what your inventory cost without looking up the cost of every item. How it works, a worked example with simple numbers, and the mistakes that throw it off.
Product
Inventory
Counts, stock on hand, dead stock and order lists.
Other calculators
Fuel margin calculator
Work out your fuel margin in cents per gallon after the card fee, and the gross profit on what you sold.
Markup and margin calculator
See the margin and the markup on any item from its cost and its price.
Lottery commission calculator
Estimate what lottery sales and cashing pay your store at your state's rates.