Skip to content

Dead Stock Calculator

See how much cash is tied up in unsold inventory, how long it could take to sell, and what you could recover at a different price.

Your inputs

View results

Count the unsold units available to sell from this batch.

Use your unit cost including allocated inbound freight and duties.

Enter the average units sold per month while the item was available.

Count the days since you received the batch.

Enter the price you charge per unit today before sales tax.

Enter the percentage you would take off the current price.

Example results

Cash tied up in inventory
$4,800

Remaining sellable units valued at landed cost.

Time to sell through
15 months

If the recent sales pace holds.

Sales at current price
$9,600

If all remaining units sell at today’s price.

Sales at markdown price
$7,200

If all remaining units sell at the reduced price.

Gross profit after markdown
$2,400

Markdown sales less landed inventory cost.

This batch is 180 days old. The proposed markdown brings the price to $60 per unit.

The two sales scenarios assume all remaining units sell. The estimates are in USD, before selling fees, returns, and sales tax.

Why use this calculator?

A slow-selling style can take up the space and cash you need for your next order. Multiply the remaining units by what they cost you to see how much of your inventory investment is sitting in that one batch. Then put the number next to the time it would take to sell through at the current pace. A batch with $4,800 tied up and fifteen months of cover calls for a different conversation from one on track to sell by the end of the season.

Use the pricing comparison to weigh how much a markdown gives up for a chance to clear stock sooner. The lower price may help, but time matters as much as the projected sales total. Set a date and a target for how many units need to move. If you need the space before a promotion has time to work, compare other ways to move unsold inventory, including a vendor return or a bulk sale.

How this calculator works

Start with one SKU or batch at one location. Enter sellable units, landed unit cost, a recent in-stock sales rate, and the age of the batch. Enter your current selling price and try a markdown percentage. The calculator uses these figures to compare the value of the stock with two selling scenarios.

  • Cash tied up = units remaining × landed cost per unit.
  • Months to sell through = units remaining ÷ recent average monthly sales. Inventory age helps you judge the urgency. The sales rate determines the clearance estimate.
  • Potential sales = units remaining × the unit price in each scenario. The markdown price is the current price × (1 − markdown percentage ÷ 100). Unit selling prices are rounded to cents.
  • Gross profit after markdown = potential markdown sales − inventory at cost. Use actual sales and product cost when reviewing your promotion afterward. Shopify’s profit report definitions show how discounts and refunds affect recorded profit.

Worked example

A running shop has 120 pairs of a prior-season trail shoe left after 180 days. It paid $40 per pair including inbound costs, so $4,800 is still tied up in that batch. At eight pairs per month, it would take 15 months to sell through if that pace held.

If every pair sells at $80, the shop takes in $9,600 in merchandise sales. A 25% markdown brings the price to $60, with $7,200 in potential sales and $2,400 in gross profit before selling costs. A shop that needs the space in six weeks would have to sell 20 pairs a week. Compare that target with what similar promotions have achieved before putting the whole batch on sale.

Who this calculator is for

Specialty retail buyers can use this tool at the end of a season to review leftover sizes, colors, and styles. Store managers can use it to build a case for moving an aging batch out of a crowded stockroom. For a retailer with several stores, running the same SKU at each location can reveal where it still sells well enough to justify a transfer.

It also helps ecommerce and finance teams agree on the cost of keeping slow stock available while a new assortment comes in. Start with the batches where the next receipt, a supplier deadline, or a drop in demand makes the decision urgent. For ongoing reviews by SKU and location, Sqquid Intelligence helps retail buyers see where stock is likely to sell and which slow sellers need attention.

Frequently asked questions

How old does inventory have to be to count as dead stock?

The threshold depends on the item’s selling window. A basic sock may still sell after six months, while a holiday print can lose most of its demand right after the holiday. Use age, sales pace, and the next realistic selling opportunity together.

Which units should I count?

Count the sellable units in the batch that are free to sell today. Set aside orders you’ve already committed to customers and count damaged stock separately. For online inventory, reconcile physical counts and available quantities before using the result to plan an offer.

How do I calculate average monthly sales?

Divide units sold by the number of months in a representative in-stock period. For example, 24 units over three months is eight per month. Use sales at a comparable price and account for promotions or season changes when choosing the period.

What counts toward landed cost?

Include the purchase price and your share of inbound freight, duties, and other costs you allocate to get the goods ready for sale. Use the cost of the batch you’re reviewing, or a quantity-weighted average for equivalent units from multiple receipts.

What if the item has had no recent sales?

Enter zero. You’ll still see cash tied up and the two pricing scenarios. The calculator can estimate time to sell through when it has a positive sales rate. Check whether the item was available, displayed, and findable before interpreting zero sales as weak demand.

How do I judge whether a markdown can clear the stock on time?

Divide the units you need to clear by the weeks left before your deadline. Compare that target with sales from similar promotions, then check your actual pace early in the offer. The time to sell through shown here uses the sales rate you enter.

How far can I mark down and still recover landed cost?

Use the landed cost per unit as your price floor for recovering merchandise cost. If your current price is $80 and your landed cost is $40, a 50% markdown brings the price to $40. Budget a higher floor if you want those sales to cover selling costs too.

How should I compare a markdown with a vendor return or liquidation?

Compare the number of units each option moves, when cash or credit becomes available, and what you recover after fees, freight, and handling. A buyer who takes the whole lot by Friday can be worth considering even if your potential sales through the store are higher.

Can I calculate dead stock across multiple stores?

Run a calculation per SKU and store when the pace, cost, or selling price differs. Add the inventory-at-cost results for an overall figure. A size sitting in one location may have demand somewhere else, so compare store-level results before planning the same markdown chainwide.

Important retail metrics

Track these alongside the calculator to see where excess stock is building and whether a clearance plan is working. Compare the same variant, location, and date range each time.

Inventory age

Days since a sellable batch was received.

Flag old receipts before a season or vendor return window closes.

Inventory at cost

Units remaining × landed cost per unit.

Find which aging batches are using the most working capital.

Sell-through rate

Units sold ÷ units available over a defined period, expressed as a percentage.

Compare how quickly a size, color, or location moves what it receives.

Gross margin

Gross profit ÷ net sales, expressed as a percentage.

See how much of the selling price is left after merchandise cost.

Net recovery

Cash or usable credit received, less the direct costs of moving the stock.

Compare clearance, vendor return, and bulk sale offers on the same basis.