Ending Inventory Calculator

Final Inventory Value Calculator

Ending Inventory Formula

Formula

\[ \text{Ending Inventory} = (\text{Beginning Inventory} + \text{Net Purchases}) - \text{Cost of Goods Sold} \]

Where:

$\text{Beginning Inventory}$ — the value of inventory at the start of the period ($)
$\text{Net Purchases}$ — total purchases made during the period, net of returns and discounts ($)
$\text{Cost of Goods Sold}$ (COGS) — the total cost of the goods sold during the period ($)

The formula expresses the accounting identity for goods available for sale: you start with what you had, add what you bought, and subtract what you sold. What remains is the ending inventory, which becomes the beginning inventory of the next period.

Ending Inventory – Calculation Example

Example: a retailer begins the quarter with $25,000 of inventory, purchases $40,000 of additional stock during the quarter, and records $50,000 in cost of goods sold.

\[ \text{Ending Inventory} = (25{,}000 + 40{,}000) - 50{,}000 = 15{,}000 \]

Result: the ending inventory is $15,000 — the value of stock remaining on hand at the end of the quarter.

How to Use the Ending Inventory Calculator

Enter your Beginning inventory — the dollar value of stock on hand at the start of the accounting period (this equals the prior period's ending inventory).
Enter your Net purchases — the total cost of goods purchased during the period, after subtracting purchase returns, allowances, and discounts.
Enter your Cost of goods sold (COGS) — the total cost of the merchandise actually sold during the period.
Read the result: the calculator instantly shows your Ending Inventory in dollars.

What Is Ending Inventory?

Ending inventory is the value of merchandise a business still holds at the close of an accounting period. It is a key line item on the balance sheet, classified as a current asset, and it plays a direct role in determining both gross profit and taxable income on the income statement.

The figure is derived from the flow of goods through the business. Everything available for sale during the period equals beginning inventory plus net purchases. Subtracting the cost of goods sold leaves the cost of whatever did not sell — the ending inventory. Because one period's ending inventory becomes the next period's beginning inventory, an error in this figure carries forward and distorts future financial statements.

How you interpret the result depends on context. A rising ending inventory relative to sales may signal overstocking or slowing demand, which ties up working capital and increases holding costs. An ending inventory that is shrinking too fast may indicate stockouts and lost sales. Comparing this figure across periods — or pairing it with our Days in Inventory Calculator to see how quickly stock turns over — helps you judge whether inventory levels are healthy.

Note that the formula measures inventory at cost, not at retail selling price. Depending on your accounting method (FIFO, LIFO, or weighted average cost), the same physical stock can produce different ending inventory values, because each method assigns different costs to the units sold and the units remaining.

Assumptions, Limitations, and Practical Tips

All inputs must be at cost, not retail price. Mixing a retail-valued inventory figure with cost-based COGS will overstate or understate the result.
Net purchases should be net. Subtract purchase returns, allowances, and early-payment discounts before entering this field; freight-in costs are typically included in net purchases.
The calculator does not adjust for shrinkage. Theft, damage, spoilage, and obsolescence reduce actual inventory but only appear in the numbers if you record a write-down or include it in COGS. Physical counts and cycle counts are still essential.
Costing method matters. Under FIFO, LIFO, or weighted average costing, the split between COGS and ending inventory differs. Use figures consistent with the method your business reports under.
The result should never be negative. If the calculator returns a negative number, one of your inputs is likely wrong — for example, COGS recorded before the related purchases, or a beginning inventory figure that is off.
Use it for planning, not just reporting. Projected ending inventory helps you decide when to reorder. For optimal order sizing, see our Economic Order Quantity Calculator.

For a broader view of inventory efficiency, combine this figure with the Inventory Stock Calculator to track stock levels over time, or use the Average Inventory Ending Cost Calculator when you need an average inventory value for turnover and performance ratios.

Frequently Asked Questions

How do I calculate ending inventory without a calculator?

Add your beginning inventory to your net purchases to get goods available for sale, then subtract cost of goods sold. For example, $ (10{,}000 + 5{,}000) - 8{,}000 = 7{,}000 $. Do the arithmetic in the same order to avoid mixing up the steps, and make sure all three figures are in dollars at cost, not retail price.

What is a good or normal ending inventory value?

There is no universal target — the right level depends on your industry and sales pace. A healthy ending inventory is large enough to avoid stockouts but small enough not to tie up cash. Compare it across periods and against sales: inventory growing faster than revenue often signals overstocking. Pair it with an inventory turnover or days-in-inventory ratio to judge whether your level is efficient for your business.

Why is my ending inventory negative, and what does it mean?

A negative result almost always means an input error, because you cannot sell more goods at cost than you had available. Common causes include COGS recorded in the wrong period, purchases entered gross instead of net, or a beginning inventory figure copied incorrectly. It can also indicate unrecorded shrinkage from theft or damage. Recheck your source figures before using the result.

How do FIFO, LIFO, and weighted average affect ending inventory?

These costing methods decide which costs stay in inventory and which go to COGS. FIFO assumes the oldest units sold first, so ending inventory reflects the newest, usually higher prices. LIFO does the opposite, leaving older costs in inventory. Weighted average spreads costs evenly across all units. The physical stock is identical in each case, but the dollar value of ending inventory will differ.

Does ending inventory include shipping, freight, and handling costs?

Freight-in — the cost of shipping goods to your warehouse — is generally included in net purchases and therefore becomes part of inventory cost. Outbound shipping to customers is a selling expense, not inventory cost. Handling and storage costs after goods arrive are usually expensed as incurred rather than capitalized, though practices vary; check the rules that apply to your business.

How is ending inventory used on financial statements and taxes?

Ending inventory appears as a current asset on the balance sheet and directly affects gross profit: an overstated inventory understates COGS, inflating profit and taxable income. Because each period's ending balance becomes the next period's beginning balance, errors compound over time. For tax reporting, the valuation method you use must generally stay consistent from year to year, so consult an accountant before changing it.

What's the difference between ending inventory and closing stock or cost of goods sold?

Ending inventory and closing stock mean the same thing — the value of unsold goods at period end. COGS is different: it's the cost of the goods you did sell during the period. The two figures move in opposite directions from the same pool of goods available for sale. If COGS goes up, ending inventory goes down, assuming beginning inventory and purchases stay fixed.