Deep-dive guide
Dead Stock Cash Trap: What Unsold Inventory Really Costs Every Month
Executive industry analysis
Unsold inventory feels safe because it sits on the balance sheet as an asset. In practice it is cash that has stopped working. Every unit that does not sell was bought with money you could have used for stock that sells, for advertising or to repay debt. Meanwhile it takes up space, ages and costs something to count and move. The longer a unit sits, the less it is worth, which is why dead stock gets worse the longer you wait, and why most owners clear it later than they should.
The problem has a clear structure. There is a pile of units, each bought at a cost. Holding it costs money every month: storage, the interest or opportunity cost of the cash, ageing as products go out of season, and shrink from damage and miscounts. Against that, you can sell it at a markdown. A deeper markdown clears the pile faster and brings cash back sooner, but each unit is sold at a smaller margin or even below cost. The decision is a trade between a loss you take now and a cost you keep paying.
The domino model follows the cash. The pile locks capital, and that capital produces a monthly holding cost. The markdown you offer sets the clearing speed, and the speed decides how many days the pile stays on the shelf. Finally, the profit of the month is the profit of your healthy stock less the holding cost of the pile and the result of what you cleared. One extra month of delay does not just add a month of cost, it moves the date at which the cash is free.
The iceberg shows what a simple stock count misses. Above the waterline are the costs that appear on invoices: storage and financing. Below it are four that rarely have their own line: the ageing loss as products go out of fashion or near expiry, shrink from damage and miscounts, handling and recounting time, and the loss on units sold below cost during the clearance itself. Use the simulator to compare waiting with clearing, and see how many months of holding cost a markdown really pays for.
Formula and methodology blueprint
The model works per month. Each month a share of the pile is cleared; that share rises with the markdown you offer, up to a cap. Cleared units sell at the full price minus the markdown, where full price is a fixed markup over cost. The units still on the shelf after clearing carry the month's holding cost: financing, storage, ageing, shrink and handling. Net is the profit from healthy stock plus the result of clearing minus holding cost.
- Clearing speed
- s = 2% + 0.4% × markdown points, capped at 60%
- Share of the pile sold each month; deeper discounts clear faster.
- Clearance price
- P = unit cost × 1.8 × (1 − markdown)
- The price at which cleared units sell, built from a standard markup over cost.
- Clearance result
- R = cleared units × (P − unit cost)
- Gain or loss on the units sold off this month; negative when the price is below cost.
- Holding cost
- C = remaining units × (cost × rate ÷ 12 + storage + cost × ageing + cost × shrink + handling)
- The monthly price of keeping the rest of the pile.
- Net profit
- Net = healthy profit + R − C
- The result for the month. The breaking point is where this reaches zero.
Cascading elasticity
Unit cost and the size of the pile are the most elastic inputs, because they multiply every holding cost at once. Cost of capital comes next and grows with the cash locked. Storage is linear. The markdown is different: a deeper cut speeds clearing but lowers the result per unit, so it has an optimum and is left out of the stress test.
Three real-world case studies
Bootstrapped starter
A small shop with a few slow lines
A young shop holds four hundred units that stopped selling after a season change. Cost per unit is low, storage is a spare shelf and the healthy lines make a steady profit. The pile is an annoyance, not a danger. Loading it shows how a small pile can be cleared while the business stays profitable.
Scaling mid-market
A large catalogue with a big pile
A scaled seller carries twelve thousand dead units across many SKUs but earns well from the rest. The pile ties up serious cash and storage, yet healthy profit covers it. Loading it shows why scale makes dead stock a monthly line item that should be managed rather than ignored.
Black-swan crisis
Overbuying before a demand drop
A seller bought heavily at high unit cost before demand fell. Twenty thousand units sit in expensive space, the money was borrowed at a high rate and the markdown on offer is too shy to clear anything. Loading it shows how holding cost alone drives the month negative.
Industry benchmark matrix
| Metric | Danger zone | Industry average | Top 10% elite |
|---|---|---|---|
| Stock with no sale in 180 days (share of inventory value) | Above 25% | 8–15% | Below 5% |
| Annual inventory carrying cost (share of stock value) | Above 35% | 20–28% | Below 15% |
| Months to clear a dead pile | More than 12 | 4–8 | Under 3 |
| Markdown needed to move aged stock | Above 60% | 25–45% | Under 20% |
| Holding cost as share of monthly profit | Above 40% | 10–20% | Below 8% |
Variables and levers
Profit from healthy stock
Monthly profit your selling products make before any dead stock cost is counted.
Lever: Protect the profit of the stock that sells; it is what pays for the pile, so do not starve it of cash.
Dead stock units
Units that have not sold for months and are unlikely to sell at full price.
Lever: Stop reordering the lines that stall, and count what is really sitting on the shelves before the next buying round.
Cost per unit
What you paid for each unit. This is the cash that is stuck on the shelf.
Lever: Price the next purchase on the cash it will lock, not only on the unit cost, and negotiate returns or swaps with suppliers.
Storage per unit per month
Rent, shelving and warehouse fees allocated to one unit for one month.
Lever: Move slow stock to cheaper space or consolidate it, because every shelf you free stops a monthly charge.
Cost of capital per year
Interest on a loan or the return you could earn on the cash if it were free.
Lever: Clear stock before borrowing to fund new orders, because expensive money makes holding cost climb every month.
Markdown to clear
Discount off full price you offer to move the pile. This is the lever you choose, not a risk.
Lever: Test a markdown in steps on part of the pile; the right discount is the smallest one that clears it in a reasonable time.
How to use this simulator
- 1Enter the number of dead units, their cost, storage cost and your cost of capital.
- 2Enter the monthly profit of your healthy stock so the pile is judged against what pays for it.
- 3Read the five domino boxes to see how cash locked turns into holding cost and time.
- 4Move the markdown slider to see how clearing speed and profit change.
- 5Compare waiting with the deep clearance plan in the Parallel universe tab over 24 months.
Mistakes to avoid
- Valuing the pile at cost. Ageing stock is worth less every month, so the book value hides a loss that has already happened.
- Waiting for full price to return. Each month of waiting adds holding cost and shrinks the price you can finally get.
- Counting only warehouse rent. Financing, ageing, shrink and handling often add more than the space itself.
- Clearing with a discount that is too small. A weak markdown sells a few units, signals nothing to shoppers and leaves the pile to keep costing money.
Frequently asked questions
Why is unsold stock a cost if I already paid for it?
The purchase cash is gone, but holding it still costs storage, interest or lost opportunity, ageing and handling every month. Those costs are real even though no single invoice shows them together.
Should I always mark down aggressively?
Not always. A markdown frees cash and stops the monthly charge, but it also gives up margin. The model helps you compare how many months of holding cost a given discount pays for.
Why is the markdown left out of the stress test?
Because it is a decision, not a risk. Deeper cuts clear faster but sell each unit for less, so there is a best value rather than a worse direction.
Does the model include tax treatment of write-offs?
No. Tax and accounting rules for writing off or donating stock vary, so check the current rules for your country with a qualified adviser.
How do I find my breaking point?
Press Find my breaking point. The tool pushes each input to its worse end and reports where monthly profit reaches zero, ranked by how near each one is.
How accurate is this?
It is an educational planning model, not accounting advice. Use your own stock ageing report and cost data, and check the results against your accounts.
This is an educational planning model with stated assumptions. It is not financial, tax or legal advice. Replace the inputs with your own figures and verify important decisions with a qualified professional.