Ending Inventory Calculator
Calculate ending inventory value from starting inventory, net purchases, and COGS. Includes inventory turnover ratio with step-by-step breakdown.
What Is Ending Inventory?
Ending inventory is the dollar value of goods still on hand at the close of an accounting period. It appears on the balance sheet and directly affects cost of goods sold on the income statement.
Ending Inventory Formula
When COGS is known, ending inventory is calculated as:
$$\text{Ending Inventory} = (\text{Starting Inventory} + \text{Net Purchases}) - \text{COGS}$$
Inventory turnover measures how efficiently you sell stock:
$$\text{Inventory Turnover} = \frac{\text{COGS}}{\frac{\text{Starting Inventory} + \text{Ending Inventory}}{2}}$$
When to Use This Calculator
Use this tool when a physical count is impractical but you know starting inventory, purchases, and COGS. Pair it with our Cost of Goods Sold Calculator and Days Inventory Outstanding Calculator for a full inventory analysis.
Frequently Asked Questions
Why is ending inventory important?
It determines COGS on the income statement and asset value on the balance sheet. Incorrect ending inventory distorts both profit and tax reporting.
What is a good inventory turnover ratio?
It varies by industry. Higher turnover generally means faster sales, but extremely high turnover can signal stockout risk.
Can ending inventory be negative?
In practice, negative inventory signals a data error or timing mismatch. This calculator floors the result at zero when COGS exceeds available goods.
How does this differ from FIFO or LIFO?
This calculator uses the analytical method when COGS is known. FIFO and LIFO assign costs differently when individual unit costs vary over time.