Blog · Finance metrics and formulas · Finance and FP&A teams
The retail method estimates ending inventory at cost from retail records and a cost-to-retail ratio. Follow a department example, reconcile estimated inventory and cost of goods sold, and distinguish retail cost from lower-of-cost-or-market treatment.
The retail method of inventory valuation estimates ending inventory at cost from its retail value and a cost-to-retail ratio. It works when the business maintains reliable cost and retail records for comparable goods. The calculation produces an estimate; it does not establish that the recorded stock exists or select the company's accounting policy.
For a basic retail cost calculation:
Cost-to-retail ratio = Goods available at cost / Adjusted goods available at retail
Ending inventory at retail = Adjusted goods available at retail − Net retail sales
Estimated ending inventory at cost = Ending inventory at retail × Cost-to-retail ratio
The ending-retail formula assumes other movements, including losses and transfers, have already been accounted for or are absent. A real workbook needs those movements as separate rows.
IRS Publication 538 describes converting retail inventory into approximate cost through the relationship between cost and selling values. The federal regulation, 26 CFR 1.471-8, calls the cost-to-retail ratio a cost complement and distinguishes the retail cost method from the retail lower-of-cost-or-market method.
Decide which method the workbook represents before inserting a ratio. The example below uses a simplified retail cost method with permanent price changes. It has no vendor allowances, interdepartmental transfers, shrinkage or LIFO adjustments. It demonstrates the mechanics, rather than determining an appropriate financial statement or tax policy for a particular company.
Start with opening inventory at both cost and retail, purchases at both values, net retail sales, and the retail price-change register. Retain department and item identifiers through the reconciliation.
| Export | Fields needed | What must match |
|---|---|---|
| Opening inventory | Department, opening cost, opening retail | Prior close and current department mapping |
| Receipts and purchases | Department, acquisition cost, retail value, returns | Received merchandise and purchase cutoff |
| Price changes | Department, permanent markup, permanent markdown, cancellations | Approved price register and effective dates |
| Sales | Department, retail sales, customer returns | Net sales for the same reporting period |
| Stock adjustments | Department, loss or transfer, retail value, reference | Count records and other departments where relevant |
Net purchase returns against purchases on both bases. Net customer returns against sales while confirming the returned stock was restored appropriately. Keep sales tax collected for taxing authorities out of merchandise selling values used in this example.
Where only some goods have reliable retail records, do not fill the gaps with a companywide markup assumption. Separate those items and resolve their valuation with finance.
An illustrative US retailer prepares a September 2026 estimate. Home goods and accessories have different cost relationships, so the controller calculates each department separately. All dollar amounts are USD.
| Input or step | Home goods cost (USD) | Home goods retail (USD) | Accessories cost (USD) | Accessories retail (USD) |
|---|---|---|---|---|
| Beginning inventory | 80,000 | 125,000 | 60,000 | 100,000 |
| Net purchases | 320,000 | 500,000 | 180,000 | 300,000 |
| Permanent markups | — | 25,000 | — | 0 |
| Permanent markdowns | — | (50,000) | — | 0 |
| Goods available | 400,000 | 600,000 | 240,000 | 400,000 |
| Less net sales at retail | — | (450,000) | — | (280,000) |
| Ending inventory at retail | — | 150,000 | — | 120,000 |
Home goods' adjusted retail value is $125,000 + $500,000 + $25,000 − $50,000 = $600,000. Accessories' value is $100,000 + $300,000 = $400,000. Apply each department's own ratio:
| Calculation | Home goods (USD except ratio) | Accessories (USD except ratio) |
|---|---|---|
| Cost-to-retail ratio | 400,000 / 600,000 = 66.6667% | 240,000 / 400,000 = 60.0000% |
| Estimated ending cost (USD) | 150,000 × 400,000 / 600,000 = 100,000 | 120,000 × 240,000 / 400,000 = 72,000 |
| Estimated COGS (USD) | 400,000 − 100,000 = 300,000 | 240,000 − 72,000 = 168,000 |
The ratios are displayed to four decimal places, but ending cost uses the unrounded fractions. Department estimates sum to $172,000 of ending inventory and $468,000 of estimated COGS.
Put one department per row. Use columns B through I for beginning cost, purchase cost, beginning retail, purchase retail, permanent markups, permanent markdowns as positive amounts, net sales and ending retail. Then use J for the ratio and K for estimated ending cost:
I2 =D2+E2+F2-G2-H2
J2 =IF(D2+E2+F2-G2>0,(B2+C2)/(D2+E2+F2-G2),NA())
K2 =I2*J2
L2 =B2+C2-K2
Column L is estimated COGS. These formulas match this example's retail cost method and exclusions; add explicit columns when other stock movements exist.
The cost identity must close: $400,000 + $240,000 = $172,000 + $468,000 = $640,000. The retail identity must also close: $600,000 + $400,000 = $450,000 + $280,000 + $150,000 + $120,000 = $1,000,000.
Do not calculate the final estimate by applying one pooled ratio. Here, total goods available at cost divided by retail is $640,000 / $1,000,000 = 64%. Applying that to $270,000 of ending retail inventory gives $172,800, which is $800 above the separate department estimates. The stock remaining has a different department mix from the goods originally available.
Tie the resulting estimate into inventory carrying value and keep the COGS reconciliation visible. FIFO, LIFO and weighted-average cost are a separate accounting-method discussion; the retail method converts retail records into a cost estimate.
Federal retail LCM rules generally exclude markdowns from the cost-complement denominator, with specific rules for cancellations, margin-protection payments and permitted alternatives. The regulation also requires actual permanent price changes in ending retail values. Temporary promotions are treated differently from permanent reductions.
For the home goods example, with no special adjustments, excluding the $50,000 markdown from the denominator produces $400,000 / $650,000 = 61.5385%. The same $150,000 ending retail balance then estimates $92,308 at cost, rounded to the nearest dollar. That is $7,692 below the retail cost estimate, also rounded to the nearest dollar.
This difference comes from method selection, without any change to units or sales. Have finance document the policy and have the tax owner confirm tax treatment. Do not switch methods merely because one gives a preferred closing balance.
Bring a department workbook with opening inventory, receipts, retail price changes, sales and the selected accounting assumptions. Covirage maps the columns, its tools compute and check the supplied valuation calculations, and the external AI model explains the department comparisons with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for analysis grounded in your own reporting files.
No. Retail records can estimate the dollar balance, but missing units still require investigation. Counts and shrinkage records check whether the implied ending stock exists. A correct cost-to-retail calculation cannot detect an unrecorded loss of merchandise on its own.
No. The retail method uses both cost and retail records for goods available and ending stock. The gross profit method generally applies an assumed gross profit rate to sales to estimate cost of goods sold. Their inputs and sensitivity to margin changes differ.
The answer depends on the selected method. Under the federal retail cost rules, permanent markdowns affect the retail denominator. The retail lower-of-cost-or-market rules generally exclude markdowns from that denominator, subject to specified adjustments and alternatives. Ending retail values also need the required price changes.
A combined percentage can distort the estimate when departments have different cost relationships or ending stock mixes. Use appropriate department or class groupings and add their estimated cost balances. A companywide ratio is a check, not automatically the correct valuation rate.