Skip to content
Omnikalc

Ending inventory calculator: estimate your stock without a physical count

Enter beginning inventory, purchases, sales and gross margin to estimate ending inventory, cost of goods sold and days of inventory.

Updated on
Your inputs
$

Value out of range

$

Value out of range

$

Value out of range

%

Value out of range

Results

Estimated ending inventory

$145,000

Goods available for sale
$600,000
Estimated cost of goods sold
$455,000
Estimated gross profit
$245,000
Days of inventory on hand
106.3 days

You do not always need a physical count to know your stock. The ending inventory calculator takes the beginning inventory, the purchases, the net sales and the expected gross margin, and gives the estimated ending inventory, the goods available for sale, the estimated cost of goods sold, the gross profit and the days of inventory on hand.

How the calculation works

  • Enter the beginning inventory and the purchases of the period, both at cost, and the net sales of the period.
  • Enter the expected gross margin, the share of sales left after the cost of goods. It is usually taken from past periods.
  • The method estimates the cost of goods sold as sales × (1 − gross margin). The ending inventory is the goods available for sale (beginning inventory + purchases) minus that cost.
  • The last result shows the days of inventory on hand, based on the average of the beginning and ending inventory.

Example

A store starts the quarter with $120,000 of inventory at cost and buys $480,000 more, so $600,000 of goods is available. Sales are $700,000 with a gross margin of 35 %. The estimated cost of goods sold is 700,000 × 0.65 = $455,000, so the ending inventory is 600,000 − 455,000 = $145,000. The gross profit is $245,000, and the stock covers about 106 days.

Why it matters

Retailers and accountants use the gross profit method for monthly statements, to estimate losses for an insurer and to spot gaps between the expected and the counted inventory. A large gap can point to theft, errors or an unexpected margin change.

Good to know

The estimate relies on a stable gross margin and on all purchases and sales being recorded in the same period. It does not replace a physical count, and accounting standards generally require a count or a perpetual system for the year-end accounts.

The inventory turnover calculator measures how fast stock sells, and the FIFO and LIFO calculator values inventory by cost-flow assumption.

Frequently asked questions

What is the gross profit method?

It is a way to estimate ending inventory without counting it. You estimate the cost of goods sold from sales and the usual gross margin, then subtract it from the goods available for sale. It is used for interim reports, insurance claims after a fire or theft, and to check a physical count.

How accurate is the estimate?

It is only as good as the gross margin. If prices, discounts or the product mix change, the margin differs from the one you assume. Shrinkage, theft and waste are not counted either. Use it for an estimate and not in place of a physical count for the annual accounts.

What are goods available for sale?

They are the beginning inventory plus the purchases made during the period, both at cost. The goods either are sold, which gives the cost of goods sold, or remain in stock, which is the ending inventory.

What do the days of inventory tell me?

They show how many days the stock would last at the current rate of sales, using the average inventory divided by the cost of goods sold, times 365. A rising number can warn of slow-moving stock, and a very low number of a risk of stock-outs.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.