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.
Related tools
The inventory turnover calculator measures how fast stock sells, and the FIFO and LIFO calculator values inventory by cost-flow assumption.