Stock value and turnover calculator
What your stock is worth, how many times a year you sell through it, and how long your cash is sitting on a shelf instead of in the bank.
What these numbers mean
Turnover is how many times you sell through your average stock in a year. Higher generally means cash moving rather than sitting.
Days of stock is the same figure said in a way most people find easier: how long the stock you hold would last at your current rate of selling. Ninety days means roughly three months of cash on the shelf.
Dead stock is the number people avoid looking at. Stock that has not moved is not an asset in any useful sense - it is cash you already spent, and every month it stays there it costs you the chance to spend it on something that sells.
Questions
What counts as cost of goods sold?
What the things you actually sold cost you - not what you sold them for. If you bought 1,000 units at £8 and sold 800 of them, your cost of goods sold is £6,400.
Is a high turnover always better?
No. Very high turnover often means you are running out of things, which costs you sales you never see. The useful signal is the direction it moves over time, and how it differs between your product lines.
What should I do about dead stock?
Decide, rather than let it decide by sitting there. Discount it, bundle it, return it if the supplier will take it, or write it off and get the tax relief. All three beat storing it for another year.
Get these figures without a spreadsheet
StockRoom keeps cost against every item and every movement, so stock value is live and you can see which lines have not moved for months.
Try StockRoom freeFree up to 50 products. £24/month after that.