Dead Stock Cost Calculator

The real cost of dead stock for Australian wholesalers and distributors

Dead stock - inventory that has not sold within a reasonable period and shows no realistic prospect of selling at normal margins - is one of the most significant drains on working capital for product-based businesses. The visible cost is the write-down from original purchase price to current realisable value. But the true cost includes warehouse rent, insurance, handling, and the opportunity cost of capital that could be deployed in faster-moving inventory or other investments.

Under Australian Accounting Standards (AASB 102 - Inventories), stock must be carried at the lower of cost and net realisable value. This means once the market value of inventory falls below its cost, the business is required to write it down in its financial statements. For tax purposes, the ATO allows businesses to value trading stock using cost, market selling value, or replacement value - whichever is lowest - at the end of each income year.

The general principle: if stock has been sitting for 12+ months with no sales, and the ongoing holding costs exceed the expected recovery from an eventual sale, it is almost always better to liquidate - even at a steep discount - and redeploy the capital and warehouse space. This calculator helps quantify that decision by comparing the cost of continuing to hold against various liquidation scenarios.

Worked example: obsolete fittings at a plumbing wholesaler

A Melbourne plumbing wholesaler holds 400 units of a superseded pump fitting bought at AU$25 per unit (AU$10,000 total). After 18 months without a sale, the realistic clearance value is AU$8 per unit. The stock sits on a pallet costing AU$45 per month, insured at 1.2% per annum, with an 8% opportunity cost on the capital tied up:

The stock also keeps costing roughly AU$122 every month it stays on the shelf. Liquidating now at 30 cents in the dollar returns AU$3,000. Holding for another 12 months in the hope of full recovery would add about AU$1,460 in holding and opportunity costs, netting AU$1,740 at best. Selling now is AU$1,260 better - which is exactly the comparison the liquidation analysis in the calculator runs for you.

How to use this dead stock cost calculator

1. Enter the item name or SKU, quantity on hand, original cost per unit, and current realisable value per unit.
2. Set the monthly warehouse cost (or pick a preset for cartons, pallets, or bulk materials), the insurance rate, and how many months the stock has been held.
3. Adjust the opportunity cost rate - the annual return the capital tied up in this stock could earn elsewhere.
4. Review the write-down, holding costs, and opportunity cost, plus the liquidation analysis comparing selling now against continuing to hold.

Frequently asked questions

What is dead stock?

Dead stock is inventory that has stopped selling and has no realistic prospect of selling at normal margins - typically items with no sales in the past 6-12 months. It differs from slow-moving stock, which still turns over but below target. Common causes include over-ordering, product obsolescence, seasonal misjudgement, and superseded models.

When should obsolete inventory be written off?

Under AASB 102, inventory must be carried at the lower of cost and net realisable value, so a write-down is required as soon as the expected selling price (less selling costs) falls below cost. For tax, trading stock can be valued at cost, market selling value, or replacement value at year end - your accountant can advise which treatment suits.

How do I calculate inventory holding cost?

Add three components: storage (monthly warehouse or pallet cost multiplied by months held), insurance (an annual percentage of stock value, pro-rated for the holding period), and opportunity cost (stock value multiplied by the annual return that capital could earn elsewhere). This calculator combines all three with the write-down to show the true cost of holding dead stock.

How does AP automation connect to inventory management?

Accurate inventory valuation depends on purchase invoices being processed correctly and on time. When supplier invoices are delayed or miscoded, your stock-on-hand figures and cost-of-goods-sold calculations become unreliable - making it harder to identify dead stock early. Automating accounts payable ensures every purchase invoice is captured, coded to the right inventory account, and posted promptly. Our complete guide to AP automation for Australian businesses sets out how prompt, accurate coding keeps inventory figures reliable.