Skip to content
FiftyCalc Free calculators for all 50 states

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

Sample figures

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.

Ending Inventory Calculator

Beginning inventory, in dollars: enter 0 or more. Prefilled example: 50,000.

Net purchases, in dollars: enter 0 or more. Prefilled example: 120,000.

Net sales, in dollars: enter 0 or more. Prefilled example: 250,000.

Gross margin (% of sales): enter a number from 0 to 100. Prefilled example: 48.

How to use this calculator

Fill in the fields in this order; each step takes you to its field.

  1. Beginning inventory, in dollars: enter 0 or more.
  2. Net purchases, in dollars: enter 0 or more.
  3. Net sales, in dollars: enter 0 or more.
  4. Gross margin (% of sales): enter a number from 0 to 100.
  5. 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

  1. A=beg+pur
  2. C=s×(1−gm100)
  3. End=A−C
Symbols used in the formula
SymbolMeaningUnit
begBeginning inventory$
purNet purchases$
sNet sales$
gmGross margin (% of sales)
ACost of goods available for sale$
CEstimated cost of goods sold$
EndEstimated 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
  1. A=50,000+120,000=170,000
  2. C=250,000×(1−48100)=130,000
  3. End=170,000−130,000=40,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.

Related calculators