In February 2024, Macy’s CFO Adrian Mitchell told investors the company had fully converted from the retail inventory method to cost accounting. A month later, Nordstrom’s CFO Cathy Smith said her company would transition as of that fiscal year. Supply Chain Dive, reporting on the shift on 19 December 2024, listed the large retailers who stayed put: Dillard’s, Target, Walmart, Kohl’s, J.C. Penney and Dollar Tree. Citing PwC, the same report noted that nearly a third of the National Retail Federation’s top 100 still use the retail method to some extent, about a quarter of them using only the retail method and the rest running a hybrid. So the method is not obsolete and it is not unimpeachable. It is a working estimate with one known distortion, and that distortion lives almost entirely inside a single decision most operators make without noticing they have made it: whether net markdowns belong in the denominator of the cost-to-retail ratio. That one choice moved the answer by 6.1 percent in the worked example below, on identical inputs. In a heavy clearance quarter it moved it by nearly 17 percent. This calculator runs all three standard variants at once so the choice is visible rather than buried in a spreadsheet someone inherited.
The retail inventory method estimates ending inventory at cost by applying a cost-to-retail ratio to inventory valued at retail prices. Ending Inventory at Cost = Ending Inventory at Retail × (Cost of Goods Available for Sale ÷ Retail Value of Goods Available for Sale). The conventional variant excludes net markdowns from the ratio’s denominator, which produces a lower ratio and a more conservative, lower-of-cost-or-market valuation.
What you paid for the stock you started the period with.
The same stock, valued at its current ticket price.
Invoice cost of everything received during the period, net of vendor returns and discounts.
The original retail price you set on those receipts, before any markups or markdowns.
Optional. Inbound freight and duty. Cost side only. It raises your cost of goods available and never touches the retail column.
Optional. Price increases above the original ticket, net of markup cancellations. Retail side only.
Optional. Clearance and promotional reductions, net of markdown cancellations. Retail side only. Where you put this number is the whole argument, and the variant selector below decides it.
Sales at retail for the period, net of customer returns.
Optional. Retail value from your last physical or cycle count. Enter it to get the shrink lines. Leave blank and no shrink figures are shown.
Conventional excludes net markdowns from the ratio. Average cost includes them. FIFO retail includes them and excludes beginning inventory from both sides. Changing this changes the ratio, not the inputs.
Ending Inventory at Cost (Conventional (LCM))
$94,615
Cost-to-Retail Ratio (conventional, LCM)
59.13%
Ratio As A Fraction
615,000 ÷ 1,040,000
Ending Inventory at Retail
$160,000
Cost of Goods Sold
$520,385
Gross Margin % of Net Sales
36.5%
Implied Margin on Goods Available
40.87%
Cost of Goods Available
$615,000
Formula Used
Ending Inventory at Cost = Ending Inventory at Retail × Cost-to-Retail Ratio
Conventional (LCM) ratio = Cost of goods available at cost ÷ (Retail available including markups, excluding markdowns)
Interpretation & Recommendations
Ending Inventory at Cost = Ending Inventory at Retail × Cost-to-Retail Ratio
The cost-to-retail ratio, sometimes called the cost complement, is one minus the gross margin percentage on the goods you had available to sell. A 59.13 percent ratio and a 40.87 percent gross margin on goods available are the same fact stated twice. That equivalence is the fastest way to sanity-check a ratio you do not trust: if the gross margin calculator says the category runs a 41 percent margin and your cost complement comes back at 72 percent, the error is in the inputs, not in the method. The relationship also explains why the ratio is not the same thing as markup. Markup is calculated on cost, margin on retail, and the two diverge quickly at the top end. A 100 percent markup is a 50 percent margin. Operators who work in markup all day sometimes plug a markup percentage into a margin-shaped field and the whole valuation tilts. The markup calculator and the gross margin versus markup guide exist precisely because this conversion is the most common arithmetic error in retail finance, and it lands here with real balance-sheet consequences. The two columns answer different questions. The cost column asks what the goods cost you to have available for sale, so inbound freight, duty and any landed-cost adjustment belong there. The retail column asks what those goods are ticketed at, so it moves only when a price tag changes. Freight-in has no retail equivalent because paying more for shipping does not automatically raise the shelf price. Net markups have no cost equivalent for the mirror reason: raising the ticket does not change what you paid. This is why the two columns do not reconcile to each other and are not supposed to. Two input errors account for most bad ratios in practice. The first is vendor allowances and rebates posted against the retail column instead of reducing cost. The second is markdowns entered gross rather than net of cancellations, which inflates the markdown figure and distorts the average cost variant while leaving the conventional variant untouched, producing the confusing symptom of one variant drifting and the others holding still. Net markups always go into the retail denominator. Net markdowns are optional, and that option is the entire difference between the three variants. Exclude markdowns and the denominator is larger, so the ratio is smaller, so ending inventory at cost is lower. This is the conventional retail inventory method, and the lower valuation is not an accident. It is the point. By ignoring the price reductions you have already taken, the ratio behaves as though the goods still carry their full original margin, which produces a deliberately conservative figure that approximates lower of cost or market. Auditors like it for the same reason: it is difficult to overstate an asset with it. Include markdowns and the denominator shrinks toward what actually happened to your prices. The ratio rises, ending inventory at cost rises, and the valuation is a better description of economic reality but a worse description of prudence. This is the average cost variant. Exclude beginning inventory as well as including markdowns and you get FIFO retail, which values ending inventory using only the current period’s purchases. This is the right choice when acquisition costs have moved materially during the period, because a ratio blended with last year’s cost structure will misstate goods bought this quarter. The published guidance on this is thinner than it should be. Deputy’s article, which currently ranks first for the query "retail inventory method calculator", tells readers that "If you’re using the Retail Inventory Method to value inventories, you typically would not make adjustments to the denominator for markdowns." That is a correct description of the conventional variant and an incomplete description of the method, and a reader who takes it as the only option will never know that a different, equally standard variant would have handed them a materially different number. A single store-wide cost-to-retail ratio is valid only when the margin mix of your ending inventory resembles the margin mix of everything you had available. A blended ratio is a weighted average of your departments, weighted by what you bought. Applying it to ending inventory assumes the leftovers are distributed the same way, and leftovers never are, because the fast-selling departments are by definition the ones with the least inventory left at the end. Whatever did not sell is over-represented in the ending balance, and if that happens to be your low-margin, high-cost-complement department, a blended ratio will understate the value of your inventory by a wide margin. The fix is not clever mathematics. It is running the ratio at the department or class level and summing, which is why the companion Excel worksheet carries a departmental tab and why the one-page cheat sheet puts the three ratio constructions side by side. Because the method derives ending inventory at retail arithmetically, it produces a book figure that assumes every unit is either sold or still on the shelf. Reality subtracts theft, damage, misplacement and receiving errors from that assumption. The difference between the book figure and a physical count is your shrink, at retail, and multiplying it by the cost complement converts it to cost. That makes the retail method the most common way shrink actually gets quantified in retail, which the shrinkage guide covers in operational detail. It also means the method cannot replace a count. Without a count you have an unverified estimate, and one that drifts in a predictable direction: shrink accumulates silently inside ending inventory, overstating both the asset and the gross margin, until a count forces the correction into a single ugly period. Retailers running cycle counts catch it in smaller pieces, which is the difference between a variance and an incident. One last property is worth knowing before you pick a variant. Markdown timing moves reported inventory value. Under the conventional variant, taking a markdown does not reduce ending inventory at cost at all, because markdowns are excluded from the ratio, so the goods sitting in the store are worth less than the books say and the gap only surfaces when the price finally comes down. That weakness grows with markdown intensity, which is a reasonable reading of why Macy’s and Nordstrom moved when they did and why grocery and discount formats with light markdown activity did not. For how all of this interacts with the cost-flow assumption underneath it, see FIFO versus LIFO for retail inventory, and for the full decision between the three variants, the retail inventory method explained.
One store, one quarter. Beginning inventory is $180,000 at cost and $300,000 at retail. Purchases are $420,000 at cost and $700,000 at retail. Freight-in is $15,000, net markups are $40,000, net markdowns are $60,000 and net sales are $820,000. Cost of goods available at cost = 180,000 + 420,000 + 15,000 = $615,000. Retail available excluding markdowns = 300,000 + 700,000 + 40,000 = $1,040,000. Retail available including markdowns = 1,040,000 − 60,000 = $980,000. Ending inventory at retail = 980,000 − 820,000 = $160,000. Conventional (LCM) ratio = 615,000 ÷ 1,040,000 = 59.13 percent, so ending inventory at cost = 160,000 × 0.591346 = $94,615. Cost of goods sold = 615,000 − 94,615 = $520,385, and gross margin = 820,000 − 520,385 = $299,615, which is 36.5 percent of net sales. With $615,000 of goods available at cost, $1,040,000 at retail excluding markdowns, and $160,000 of ending inventory at retail, the conventional retail inventory method values ending inventory at $94,615. A note on precision: the ratios here are displayed rounded to two decimal places, but every result is computed from the unrounded ratio. Recomputing from the rounded display leaves you about $7 out. Note also that the 36.5 percent realised gross margin is lower than the 40.87 percent margin implied by the cost complement. That is not an error. The gap is the markdowns: the ratio was built on pre-markdown retail, the sales were rung at post-markdown prices, and the markdown calculator is the quickest way to check whether the difference matches the markdown dollars you actually took. What-if 1, the same quarter under all three variants. Conventional gives a 59.13 percent ratio and $94,615. Average cost gives 615,000 ÷ 980,000 = 62.76 percent and 160,000 × 0.627551 = $100,408. FIFO retail gives (615,000 − 180,000) ÷ (980,000 − 300,000) = 435,000 ÷ 680,000 = 63.97 percent and 160,000 × 0.639706 = $102,353. On identical inputs, the average cost variant values ending inventory $5,793 higher than the conventional variant, a difference of 6.1 percent. Nothing about the business changed between those three rows. Only the denominator did. What-if 2, a heavy markdown quarter. Markdowns rise to $150,000 and net sales fall to $730,000. Ending inventory at retail is still $160,000, because 1,040,000 − 150,000 − 730,000 = 160,000. The conventional ratio does not move. It is still 615,000 ÷ 1,040,000 = 59.13 percent, because markdowns never entered it, so ending inventory at cost stays at $94,615. The average cost ratio becomes 615,000 ÷ 890,000 = 69.10 percent, giving 160,000 × 0.691011 = $110,562. When markdowns rise from $60,000 to $150,000, the gap between the conventional and average cost valuations widens from $5,793 to $15,946 on the same ending inventory. The variants diverge most in exactly the quarters when a clearance event has everyone too busy to think about accounting policy. What-if 3, adding a physical count. A count values ending inventory at retail at $148,000 against the book figure of $160,000. Shrink at retail = 160,000 − 148,000 = $12,000, which is 1.46 percent of net sales. Shrink at cost = 12,000 × 0.591346 = $7,096. Ending inventory at cost falls to 148,000 × 0.591346 = $87,519. A $12,000 shrink at retail converts to $7,096 at cost when the cost-to-retail ratio is 59.13 percent. Shrink is always reported at cost in the P&L and always found at retail on the floor, so a wrong ratio produces a wrong shrink number, and shrink is one of the few figures here that people make staffing decisions about. What-if 4, the blended-ratio trap, quantified. Split the same $615,000 and $1,040,000 across two departments. Apparel holds $400,000 at cost against $800,000 at retail, a 50.00 percent ratio. Consumer electronics holds $215,000 against $240,000, an 89.58 percent ratio. Blended, that is the same 59.13 percent. Apparel cleared through the quarter and electronics did not, so the $160,000 of ending inventory at retail is $16,000 apparel and $144,000 electronics. Using the blended ratio: 160,000 × 0.591346 = $94,615. Using departmental ratios: (16,000 × 0.500000) + (144,000 × 0.895833) = 8,000 + 129,000 = $137,000. A single blended cost-to-retail ratio values this ending inventory at $94,615 against $137,000 from departmental ratios, understating the asset by $42,385, or 30.9 percent of the correct figure. The distortion is not caused by the departments having different margins. It is caused by the ending mix differing from the purchase mix, and the size of the error scales with both. A real store with fifteen classes and a bad electronics quarter can do considerably worse, and it will do it quietly, because a blended ratio always returns a plausible-looking number. Tracking the ratio period over period in an inventory tracker is the cheapest way to catch that drift, and the inventory turnover calculator and GMROI calculator are where the corrected cost figure has to land next.
It depends on which variant you are running, and that is a policy choice rather than a right answer. The conventional method excludes them, which lowers the ratio and produces a conservative valuation approximating lower of cost or market. The average cost and FIFO retail variants include them, which tracks what actually happened to your prices. Pick one, document it, and apply it consistently, because switching variants between periods makes your inventory trend meaningless.
Yes. It remains a recognised inventory estimation method and large public retailers still use it. Supply Chain Dive reported on 19 December 2024 that Dillard’s, Target, Walmart, Kohl’s, J.C. Penney and Dollar Tree were among those still using it, citing PwC for the finding that nearly a third of the NRF top 100 use it to some extent. Your auditor will care about which variant you use and whether you apply it consistently, not about whether the method itself is permitted.
They are the same measurement from opposite ends. Cost complement plus gross margin percentage equals 100 percent on the goods available. A 59.13 percent cost complement implies a 40.87 percent margin on goods available. What trips people up is that the realised gross margin on sales will normally be lower, because sales happen at post-markdown prices while the conventional ratio is built on pre-markdown retail. The gross margin calculator is the fastest cross-check.
Only if your departments run similar margins or your ending inventory mix closely matches your purchase mix. Neither is usually true. In the worked example above, a blended ratio understated ending inventory by $42,385 across just two departments. Run the ratio at department or class level and sum the results.
No, and treating it as though it does is how shrink hides. The method produces a book value that assumes everything not sold is still on the shelf. Only a count tells you the difference, and that difference is your shrink. Most retailers use the method between counts, not instead of them.
Macy’s CFO Adrian Mitchell said in February 2024 that the company had fully converted to cost accounting, and Nordstrom’s CFO Cathy Smith announced a transition in March 2024, both as reported by Supply Chain Dive in December 2024. Neither framed it as the method being broken. The general reading is that heavy, continuous markdown activity is where the retail method’s estimates drift furthest from cost reality, and department stores mark down more than almost anyone.
Both estimate ending inventory without a count, but they use different anchors. The gross profit method applies a historical gross margin percentage to current sales, so it is quick and rough and usually reserved for interim reporting or insurance claims. The retail method tracks cost and retail in parallel throughout the period, which makes it considerably more accurate but requires the discipline of maintaining both columns.
Yes, and the two stack rather than compete. The retail method is a technique for estimating inventory value without counting at cost. FIFO and LIFO are cost-flow assumptions about which costs move to COGS first. You can run LIFO retail or FIFO retail, and the ratio is constructed differently in each case. FIFO versus LIFO for retail inventory covers the cost-flow decision on its own terms.
On the cost side only, added to cost of goods available. It raises the numerator of the ratio and therefore raises ending inventory at cost. It never appears in the retail column, because paying more for inbound shipping does not change the ticket price. Vendor allowances work the other way and should reduce cost rather than increase retail.
Compare the implied margin against what you believe the category runs. If your cost complement says 72 percent and you know the department runs a 40 percent margin, you likely have a markup percentage entered where a margin belongs, or purchases at retail entered at cost. Both are common and both are visible in seconds once you look at the ratio rather than the ending value. Tracking the ratio period over period in an inventory tracker makes the drift obvious before it reaches the balance sheet.
Deep-dive guides that explain the math behind this calculator.
Measure how many times a year your average inventory sells through and gets replaced. The single most consequential operational KPI in retail. It connects buying decisions, warehouse cash, markdown risk, and finance targets into one number. The turn ratio arrives converted into days and weeks of supply, together with the working capital a one-turn improvement would release.
Open
The cleanest read on how much of every sales dollar you actually keep after paying for the goods. Gross margin drives every downstream financial decision in retail: what to price, what to promote, what to keep on the shelf. Margin percent, the markup equivalent, cost as a percent of revenue and the price-to-cost multiplier all appear together, which is what it takes to translate between the three lenses without reaching for a second tool.
Open
Set a selling price from cost or reverse-engineer the markup baked into an existing price. Markup is the buyer’s language of pricing (percent added on top of cost), while margin is the finance language (percent kept from revenue). Alongside markup percent come profit per unit, the margin equivalent and the price-to-cost multiplier. Buying and finance can then argue about the price rather than about the denominator.
Open
The pricing tool every buyer and merchandiser reaches for when inventory is running behind sell-through pace. Out comes the markdown amount, the markdown percent, the final selling price, and, once a cost is entered, the resulting gross profit and margin percent. It also flags whether the markdown depth is promotional, seasonal, aggressive or clearance-tier, and generates practical next-step recommendations tied to gross margin, GMROI, sell-through rate and inventory turnover.
Open
The single most honest cross-category profitability metric in retail. GMROI answers one question: for every dollar of inventory you funded, how many dollars of gross profit did you get back? A high gross margin on inventory that never sells produces zero return, which is why GMROI keeps margin and inventory turnover honest against each other. The output is the GMROI ratio with gross margin percent, inventory turnover, gross profit and a plain-English performance band, because the ratio on its own tells a buyer very little.
Open
Convert your inventory position into a number finance actually reads: the average days of cash sitting on the warehouse floor. DIO is the same measurement as inventory turnover in days instead of a ratio, and it maps directly onto working capital, cash conversion cycle and reorder cadence. Four numbers come out: DIO, weeks of supply, implied turnover, and the cash a 10-day improvement would release.
Open
Handpicked benchmarks, templates and guides to help you dig deeper.
Five core calculators every buyer, merchandiser and category manager reads together. Open the metric that is behind, and let the others sanity-check it.
Percent of revenue kept after paying for the goods. The anchor number on the retail P&L.
Open calculator
Percent added on top of cost to reach the selling price. The buyer’s pricing language.
Open calculator
Gross profit per dollar of average inventory. The honesty check on margin and turnover.
Open calculator
Units sold as a percent of units received. The leading indicator for markdown timing.
Open calculator
How many times average inventory sells through in a year. The core inventory KPI.
Open calculator