Inventory Turnover Calculator – How Fast Stock Sells, Free

Why slow stock ties up cash a business needs

A shop can look busy and still run out of cash, because the cash is sitting on the shelves as stock. Every box that does not sell is money that cannot pay rent, wages or the next order. Inventory turnover measures how fast that money comes back: cost of goods sold divided by average inventory. A ratio of 4 means the shop sells and replaces its whole stock four times a year.

A low ratio means stock sits for months, and the business pays for storage, insurance and the risk that the stock goes out of date. A high ratio means stock sells fast, but it can also mean the shop runs out of popular lines and loses sales. The healthy range for most small shops is 2 to 6 times a year.

How to use the calculator

Type the cost of goods sold for the year in the first box. That is the cost of the products you actually sold, not your sales revenue. You can find it in your accounts or your tax return. Then type the average inventory value: the stock at the start of the year plus the stock at the end, divided by two.

Press the button, or keep typing, and the tool gives your turnover ratio and the days stock sits on the shelf at once. The bar shows where your ratio sits, from slow to fast, with a healthy middle zone. The next step tells you what to do with slow or fast stock.

Worked example

Take a shop with a cost of goods sold of 120,000 dollars in the year and an average inventory of 30,000 dollars. Divide 120,000 by 30,000 to get a turnover ratio of 4 times a year. Divide 365 by 4 to get about 91 days: on average, a product sits on the shelf for three months before it sells.

Take a shop with the same cost of goods sold but an average inventory of only 10,000 dollars. The ratio is 6 times a year, and stock sits for about 61 days. Take a shop with an average inventory of 50,000 dollars and a cost of goods sold of 50,000 dollars: the ratio is 1, and stock sits for a full year. That shop has a cash problem, because its money is stuck in stock.

Who uses this calculator

Shop owners use it most, when they review the year and plan the next order. It shows in one number whether their money is working or sitting in boxes. A shop with slow stock can discount the slow lines and order less of them next time.

Accountants use turnover in year-end reviews, and lenders look at it when a business asks for a loan. Warehouse managers use it to decide which lines get shelf space and which lines go. Any business that holds stock can use the same number.

Honest limitations

This tool gives one ratio for the whole business, but a shop is made of many lines. Fast lines can hide slow ones, so a healthy overall ratio can still hide a shelf of stock that never sells. Run the same calculation by product line to find the real problem.

It also uses one year of data. A seasonal shop, like a toy shop before Christmas, turns stock fast in December and slowly in February, so the yearly average hides the pattern. The healthy range also differs by industry: a food shop turns stock many times a year, while a furniture shop turns it once or twice. Compare your number with shops like yours, not with every business.

Frequently asked questions

What is cost of goods sold? It is what you paid for the products you sold in the year, not the price you sold them for. If you bought stock for 120,000 dollars and sold it all, your cost of goods sold is 120,000 dollars. Your accounts show it as a separate line.

How do I work out average inventory? Add the stock value at the start of the year to the stock value at the end of the year, then divide by two. If you count stock every month, average all twelve months for a better number.

What is a good turnover ratio? For most small shops, 2 to 6 times a year is healthy. Below 2 is slow, and above 6 is fast. Food shops and fashion shops are often faster, and furniture and machinery shops are often slower.

Is a very fast turnover always good? No. A ratio of 12 means stock sells in a month, but it can also mean the shop runs out of popular products and loses sales. Fast turnover needs good ordering, so the shelves stay full.

También disponible en español: Rotación de Inventario – Calculadora de Rapidez de Venta

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top