What is inventory to sales?
Inventory to sales is average inventory divided by net sales. It tells you how much stock the business holds for every dollar it sells. A ratio of 0.20 means 20 cents of inventory for every dollar of net sales. Below 0.10 is lean, above 0.30 is heavy.
A lower ratio is usually better: the less stock the business holds for each dollar it sells, the less cash sits on shelves gathering dust. Try the numbers on the inventory to sales ratio calculator and it does the dividing for you.
The inventory to sales formula
The formula is inventory to sales ratio = average inventory ÷ net sales. The average inventory is the stock on hand averaged across the year — (opening stock + closing stock) ÷ 2 — not the stock on the last day of the year, because a single day’s stock can be flattered by a delivery or emptied by a sale. The net sales are the sales after returns, discounts and allowances — the money the business actually kept, not the gross till total. Divide the first by the second and you have the ratio. The answer is a plain number, not a percentage — write it as 0.20, and read it as 20.00% when you want the percent form.
Step 1: work out the average inventory
Start with the stock on hand averaged across the year. The average inventory is (opening stock + closing stock) ÷ 2 — add what the business held at the start of the year to what it held at the end, and halve the total. Here is the worked example: opening stock of $180,000 and closing stock of $220,000 give ($180,000 + $220,000) ÷ 2 = $200,000 of average inventory. That is the stock the business held, on average, through the year — not the stock on the last day, which a delivery or a big sale can move by thousands in a day.
Step 2: work out the net sales
Take the sales the business actually kept. The net sales are the gross sales minus returns, discounts and allowances — the money that stayed in the till, not the money that came back. Here is the worked example: net sales of $1,000,000. That is the sales the business kept after the returns went back and the discounts came off.
Step 3: divide the average inventory by the net sales
Divide the average inventory by the net sales. Here is the worked example: $200,000 ÷ $1,000,000 = 0.20 (20.00%). So the inventory to sales ratio is 0.20 — the business holds 20 cents of inventory for every dollar of net sales. The inventory to sales ratio calculator runs the division for you.
Three worked examples
Example one — the headline numbers. A business has average inventory of $200,000 and net sales of $1,000,000. The ratio is $200,000 ÷ $1,000,000 = 0.20 (20.00%).
Example two — a leaner shop. A business has average inventory of $150,000 and net sales of $1,000,000. The ratio is $150,000 ÷ $1,000,000 = 0.15 (15.00%) — a leaner shelf.
Example three — working to a target. A business wants a ratio of 0.25 and it sells $1,000,000. The average inventory it needs is 0.25 × $1,000,000 = $250,000. The inventory to sales ratio calculator runs the target check for you.
One reverse to check your answer
Work the numbers backwards. A business wants a ratio of 0.25, and it sells $1,000,000. The smallest average inventory that reaches the target is $250,000. A dollar less, and the ratio falls short of the 0.25 target. If the average inventory rose to $300,000 against the same $1,000,000 of net sales, the ratio would rise — try it on the calculator and see by how much. The inventory to sales ratio calculator runs the reverses for you.
What a 20.00% ratio means
A 20.00% ratio means the business holds 20 cents of inventory for every dollar of net sales. The business sells five dollars for every dollar of stock on its shelves. Compare the ratio within one industry, not across them — a car dealer holds far more stock per dollar of sales than a software firm.
High ratio vs low ratio
Below 0.10 (10%) the shelves are lean, above 0.30 the shelves are heavy, and above 1.00 the business holds more stock than a whole year of sales. A high ratio means money sits in boxes instead of the bank, gathering dust and going out of date. A low ratio means the shelves are lean — but a ratio that is too low can hide empty shelves and lost sales, so lean is good only while the shelves stay full enough to sell from.
Why the ratio is read year over year
A ratio that climbs year after year while sales stay flat is the classic early warning — the business is buying stock faster than it sells it. Read the ratio year over year, and the pattern tells you whether the business is selling its stock down or piling it up.
What a negative ratio means
A negative ratio means net sales went negative. Here is the worked example: average inventory of $12,500 and net sales of −$50,000 give a ratio of −0.25 (−25.00%). A negative ratio means returns outran sales — the ratio says nothing about stock levels — and a negative ratio is not a bargain signal, it is a warning sign. The calculator shows the negative figure with a note, never hides it and never shows “—” for it.
What if net sales are zero?
At $0 of net sales the ratio is undefined — the business holds stock against no sales, so there is nothing to compare against. The calculator shows the ratio as undefined with that note, never a crash and never a made-up number.
The mistakes to avoid
Four mistakes catch almost everyone. First, using ending inventory instead of average inventory: a single day’s closing stock can be flattered by a delivery that landed that morning or emptied by a big sale that afternoon, so the average across the year is the honest figure — use (opening stock + closing stock) ÷ 2. Second, mixing up inventory to sales and inventory turnover: turnover divides cost of goods sold by average inventory, so it counts how many times the stock sells through, while inventory to sales divides the stock by the sales — the two are related but they answer different questions. Third, using gross sales instead of net sales: returns, discounts and allowances come off first, because the ratio is about the money the business kept. Fourth, reading one year as the whole story: a ratio that climbs year after year while sales stay flat is the classic early warning, so read the ratio year over year. Read the guide to inventory turnover and the guide to days inventory outstanding for the other side of the same shelves.