Stock and purchases · free tool
Inventory Turnover and Retained Capital Calculator
A voluminous inventory can hide idle cash even with frequent sales. Compare the cost of goods sold in the year with the average stock and see what average value would be compatible with a turnover chosen by you.
Free, no sign-up required
In action
See an example
In the year, the cost of goods sold was R$12,000. Stock started at R$3,000 and ended at R$5,000, an average of R$4,000. That gives 3 turns a year, about 122 days per turn. With 6 turns, average stock would drop to R$2,000, R$2,000 less.
Use “Fill in example” to try these fictional values.
How we calculate
- Estoque médio aproximado = (estoque inicial + estoque final)/2. Todos os valores usam custo.
- Giro observado = CMV anual ÷ estoque médio. Dividimos 365 pelo giro para ter a duração aproximada. Sem base positiva, essa duração não é calculada.
- Estoque médio do cenário = CMV/giro desejado. A diferença para o estoque médio observado compara o capital retido nas duas hipóteses.
Everything at cost
Use cost for all three values of the year.
The cost of goods sold (COGS) is what left stock through sales during the year. It is not revenue, and it cannot be compared with stock valued at selling price.
Opening and closing stock also go in at cost.
The average of the two ends is a practical approximation. It poorly represents a business that makes one big seasonal purchase and then quickly reduces the balance.
Desired turnover
Changing the turnover does not free up money by itself.
The calculation divides the same COGS by the desired turnover and shows the average stock that matches it.
Reducing stock without losing sales requires planning restocking and relying on the supplier. Simply stopping purchases can cause shortages.
The difference shown compares average levels. It is not an order to remove goods or a cash forecast. If sales also change, update the scenario's COGS.
Questions when filling out
What does turning stock over 3 times a year mean?
The cost sold in the year equals 3 average stocks. Dividing 365 by 3 gives about 122 days per turn, a way to read that rotation without tracking each item.
Is there an ideal turnover for any business?
We do not use a universal goal. Expiry date, variety, supplier deadline and demand pattern change the need for stock. Enter your own hypothesis and test its consequences.
Sources and further reading
- Sebrae Atende · Inventory management (opens in new tab)
Pages 7–13: inventory planning, turnover, coverage, and economic order quantity.
Organize everyday life with Focca
Compare planned purchase reduction with actual cash. See how Focca helps record business income and expenses.
Conheça o controle financeiro pelo WhatsApp and the secretária virtual no WhatsApp.