Ending Inventory Calculator

Ending Inventory Calculator

Growing AI Skill PRO

Enter Calculation

Formula

Ending Inventory=Beginning Inventory+Net Purchases−COGS\text{Ending Inventory} = \text{Beginning Inventory} + \text{Net Purchases} - \text{COGS}

Example

Ending Inventory=10000+5000−8000=7,000\text{Ending Inventory} = 10000 + 5000 - 8000 = 7{,}000
Usage stats

Advertisement

Results

Ending Inventory
$7,000
value of stock remaining
Beginning Inventory $10,000
Net Purchases $5,000
Goods Available for Sale $15,000
Cost of Goods Sold $8,000

Report an error on this page

What Is Ending Inventory?

Ending inventory is the total value of goods a business still has on hand at the close of an accounting period. It appears as a current asset on the balance sheet and directly affects reported profit. This calculator finds ending inventory using the standard accounting identity: beginning inventory plus purchases minus the cost of goods sold (COGS).

How to Use the Calculator

Enter three figures: your beginning inventory (the value carried over from the prior period), your net purchases made during the period, and your cost of goods sold. The tool instantly returns your ending inventory along with the goods available for sale. All values should be entered in the same currency and cost basis.

The Formula Explained

The relationship is straightforward: Ending Inventory = Beginning Inventory + Purchases − COGS.

$$\text{Ending Inventory} = \text{Beginning Inventory} + \text{Net Purchases} - \text{COGS}$$

Beginning inventory and purchases together form the goods available for sale. Whatever you did not sell (i.e., goods available minus COGS) remains as ending inventory. This identity underlies periodic inventory systems and the calculation of COGS itself.

Advertisement
Diagram showing beginning inventory plus purchases minus COGS equals ending inventory
Ending inventory equals beginning inventory plus purchases minus cost of goods sold.

Worked Example

Suppose a retailer starts the quarter with $10,000 of inventory, buys $5,000 more, and records $8,000 in cost of goods sold. Goods available for sale = \(\$10{,}000 + \$5{,}000 = \$15{,}000\). Ending inventory:

$$\$15{,}000 - \$8{,}000 = \mathbf{\$7{,}000}$$

That $7,000 carries forward as next period's beginning inventory.

Horizontal bar showing inventory components stacking and reducing to ending inventory value
Worked example: starting stock plus purchases, less goods sold, yields the remaining stock value.

Interpreting Your Ending Inventory Result

Ending inventory is the cost of goods still on hand at the end of an accounting period. It is reported as a current asset on the balance sheet. The calculator uses the identity \(\text{Ending Inventory} = \text{Beginning Inventory} + \text{Net Purchases} - \text{COGS}\), which is the standard cost-of-goods-sold equation rearranged.

Effect on profit. Ending inventory is subtracted from goods available for sale to arrive at COGS. All else equal, a higher ending inventory means lower COGS and therefore higher gross profit; a lower ending inventory means higher COGS and lower gross profit. This is why inventory errors flow directly into reported income.

Carry-forward. This period's ending inventory becomes the next period's beginning inventory. An error in one period therefore affects the following period in the opposite direction, even though the total over both periods may offset.

Negative or unusually large results. A negative result is not possible in reality, because you cannot hold less than zero units. It usually signals that COGS was overstated, purchases were left out, or the inputs use different cost bases. An unusually large result compared with prior periods or with sales volume may point to counting mistakes, purchases recorded in the wrong period (cutoff errors), unrecorded sales or COGS, obsolete or slow-moving stock, or data-entry errors. Check these before relying on the figure.

Cost-flow method. The value depends on the method used to assign costs: FIFO, LIFO (permitted under US GAAP but not under IFRS), or weighted average. When prices change, the same physical stock can produce different ending inventory values under each method. This calculator does not apply a method itself; it relies on the COGS figure you provide.

Reconcile with a physical count. A calculated figure reflects what the records say should be on hand. Comparing it with a physical count helps identify shrinkage, theft, damage, or recording errors.

Related metric. Inventory turnover, commonly calculated as COGS divided by average inventory, shows how many times stock is sold and replaced during a period. Ending inventory is often used when computing average inventory. This is general information, not financial or accounting advice.

Advertisement

Key Inventory Terms

Beginning inventory
The cost of goods on hand at the start of the period; equal to the prior period's ending inventory.
Net purchases
Purchases during the period, less purchase returns, allowances, and discounts, plus freight-in where applicable.
Goods available for sale
Beginning inventory plus net purchases: the total cost of stock that could have been sold during the period.
Cost of goods sold (COGS)
The cost of the goods that were actually sold during the period.
Ending inventory
The cost of goods still unsold at the end of the period: goods available for sale minus COGS.
Periodic inventory system
Inventory is updated only at set intervals, based on a physical count; COGS is then calculated using the cost-of-goods-sold equation.
Perpetual inventory system
Inventory and COGS records are updated continuously with each purchase and sale, usually through software or barcode scanning.
FIFO (first-in, first-out)
Assumes the oldest costs are sold first, so ending inventory carries the most recent costs.
LIFO (last-in, first-out)
Assumes the newest costs are sold first, so ending inventory carries older costs. It is allowed under US GAAP but not under IFRS.
Weighted-average cost
Assigns an average cost per unit, calculated from total cost of goods available divided by total units available, to both COGS and ending inventory.

Make sure that beginning inventory, purchases, and COGS are all stated on the same cost basis (the same cost-flow method and the same currency), so the result is consistent.

FAQ

Can ending inventory be negative? Mathematically yes if COGS exceeds goods available, but in practice a negative result signals a data or counting error.

What counts as net purchases? Gross purchases minus purchase returns, allowances, and discounts, plus freight-in.

How does this relate to COGS? The same equation rearranges to \(\text{COGS} = \text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory}\), so a physical count of ending inventory lets you derive COGS.

Last updated:

Most popular in Financial

View all Financial calculators