Ending Inventory Calculator

Enter the total starting value of an inventory, the net purchases and the cost of goods sold to calculate the ending inventory and turnover.

Ending Inventory Formula

The following formula can be used to calculate the ending inventory value.

Ending Inventory = (BI+ NP) – (CG)

  • Where BI is the initial inventory amount ($)
  • NP is the net purchases ($)
  • CG is the cost of goods sold ($)

The inventory turnover can than further be calculated using the ending inventory, beginning inventory, and cost of goods sold.

How to calculate Ending Inventory

  1. First, determine the initial inventory value

    This will involve taking a count of every piece of inventory that is currently stored and multiplying it by the price of those goods. This will yield the initial inventory value.

  2. Next, determine the total net purchases

    This will be equal to the total number of items sold multiplied by the price of those items.

  3. Find the cost of the goods sold

    This is the cost, including operating and raw material costs of a good.

  4. Finally, calculate the ending inventory

    Enter the information from steps 1-3 into the formula or calculate above to determine the ending inventory value.

FAQ

What is ending inventory?

An ending inventory is a monetary value used to describe the total worth of a warehouse or storage of goods after a certain number of those goods have been sold.

What is inventory turnover?

Inventory turnover is a ratio that measures the change in value of an inventory over time. The higher the inventory turnover, the more product is being shipped or sold out.

What is a good ending inventory?

The lower the ending inventory the more goods are being sold. This will result in higher profits.

ending inventory calculator

Related Terms

ending inventory calculator
how to calculate ending inventory
ending inventory formula
ending inventory
how to find ending inventory
how to calculate closing inventory
ending work in process inventory
ending finished goods inventory
how to find closing inventory
how to compute ending inventory
how to calculate ending work in process inventory
desired ending inventory
how to work out closing inventory
ending inventory example
ending work in process inventory formula
ending merchandise inventory
ending inventory equation
cost of ending work in process inventory
calculate closing inventory
how to calculate ending finished goods inventory
beginning and ending inventory
how do you calculate ending inventory
ending inventory definition
less ending inventory
how to determine ending inventory
how to find desired ending inventory
how do you find ending inventory
ending raw materials inventory formula
ending raw materials inventory
how to calculate ending raw materials inventory
compute ending work in process inventory for a manufacturer
ending inventory balance sheet
how to calculate desired ending inventory
beginning inventory and ending inventory
how to find ending raw materials inventory
ending work in process
ending work in process formula
how is this month book inventory calculated
beginning inventory ending inventory
formula of ending inventory
finding ending inventory
ending inventory balance
formula for closing inventory
value of ending inventory
budgeted ending inventory
calculate ending work in process inventory
ending merchandise inventory formula
how to figure out ending inventory
estimated cost of ending inventory
how to solve ending inventory
desired ending inventory formula
how to find beginning finished goods inventory in a production budget
compute ending inventory
how do you calculate closing inventory
how to find merchandise inventory ending
ending inventory in balance sheet
how to calculate ending work in process
how to calculate ending wip
how to estimate ending inventory
formula of closing inventory
how to calculate cost of ending work in process inventory
ending inventory accounting
calculate ending finished goods inventory
estimating ending inventory
how to get ending merchandise inventory
how to calculate ending inventory under absorption costing
how is ending inventory calculated
how to calculate year end inventory
how to calculate the closing inventory
ending inventory of finished goods
calculate the ending work in process inventory
closing inventories formula
understating ending inventory
ending wip inventory
how to calculate end of year inventory
how to compute the number of units in ending inventory