Retail Inventory Method CalculatorConventional and Average Cost Ratios

Is this entity in good shape, or are there warning signs?

Ending inventory at retail and at cost under the conventional (lower of cost or market) and average cost-to-retail ratios.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Ending inventory at cost (conventional)
$202,632
Lower of cost or market approximation
Ending inventory at retail
$350,000
Cost-to-retail ratio, conventional (excludes markdowns)
57.89%
Drawn to one scale
Ending inventory at cost (conventional)$202,632
Ending inventory at retail$350,000
Ending inventory at cost (average cost)$213,889
Cost of goods sold (conventional)$897,368
All results
MeasureResult
Ending inventory at cost (conventional)$202,632
Ending inventory at retail$350,000
Cost-to-retail ratio, conventional (excludes markdowns)57.89%
Cost-to-retail ratio, average cost (includes markdowns)61.11%
Ending inventory at cost (average cost)$213,889
Cost of goods sold (conventional)$897,368
How this was worked out
Work shownrecomputed as you type
Goods available at retail = beginning retail + purchases retail + net markups
Ending retail = available - net markdowns - net sales
Conventional ratio = (beginning cost + purchases cost) / available at retail
Ending cost = ending retail x ratio

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Goods available at retail = beginning retail + purchases retail + net markups
  • Ending retail = available - net markdowns - net sales
  • Conventional ratio = (beginning cost + purchases cost) / available at retail
  • Ending cost = ending retail x ratio

How it works

The retail inventory method converts ending inventory at retail to cost with a cost-to-retail ratio. Leaving markdowns out of the ratio (the conventional method) gives a lower ratio and approximates lower of cost or market.

ASU 2015-11 left inventory measured with the retail inventory method on the lower of cost or market test (ASC 330-10-35-1C), which the conventional ratio is designed to approximate.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

Why exclude markdowns from the ratio?

Including them raises the ratio and values inventory closer to average cost. Excluding them writes inventory down for the markdowns.

Where do employee discounts and shrink go?

Deduct them from goods available at retail, like sales, after the ratio is computed.

Is the method allowed for tax?

Yes, under the Treasury regulations on inventories, with its own rules. This tool computes the book figure.

Sources

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required