Ending Inventory Calculator
Test cases replayed : 2 of 2 match · Methodology · No outside source listed
Enter beginning inventory, purchases, net sales and your usual gross margin to estimate ending inventory without a physical count.
Result
Estimated ending inventory
Cost of goods available for sale ($)
- Estimated cost of goods sold ($)
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Beginning inventory, in dollars: enter 0 or more.
- Net purchases, in dollars: enter 0 or more.
- Net sales, in dollars: enter 0 or more.
- Gross margin (% of sales): enter a number from 0 to 100.
- Read the result: Estimated ending inventory; the panel also shows Cost of goods available for sale ($) and Estimated cost of goods sold ($).
How this calculator works
Ending inventory = beginning inventory + purchases − cost of goods sold. With the gross profit method, COGS is estimated as net sales × (1 − gross margin), using the margin from past periods.
The estimate suits interim reports and insurance claims after a loss. Year-end statements need a physical count or perpetual records. If you already know COGS, ending inventory = goods available for sale − COGS.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Beginning inventory | $ | |
| Net purchases | $ | |
| Net sales | $ | |
| Gross margin (% of sales) | ||
| Cost of goods available for sale | $ | |
| Estimated cost of goods sold | $ | |
| Estimated ending inventory | $ |
Worked example
| Beginning inventory | $50,000 |
|---|---|
| Net purchases | $120,000 |
| Net sales | $250,000 |
| Gross margin (% of sales) | 48 |
| Cost of goods available for sale ($) | $170,000 |
|---|---|
| Estimated cost of goods sold ($) | $130,000 |
Estimated ending inventory $40,000
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What is ending inventory with $50,000 opening stock, $120,000 purchases, $250,000 sales and a 48% margin?
Estimated COGS is $130,000, so ending inventory is about $40,000.
Why can the estimate be wrong?
It assumes this period's margin matches the past. Price changes, markdowns, theft or a different product mix make it drift.