Ending Inventory Calculator
Ending Inventory is equal to Beginning Inventory (INR) added net purchases (INR) less than cost of goods sold (INR) . The product in stock at the end of the accounting period.
Ending Inventory = (Beginning Inventory + Net Purchases) – (Cost of goods sold)
Let us Consider,
- Beginning inventory is the monetary value of the inventory at the beginning of the accounting period;
- Net purchases is the value of new items in the inventory that were purchased during the accounting period;
- Cost of goods sold, or COGS, is the direct cost of production of goods that you sell out of the materials from the inventory.
Inventory turnover
Inventory Turnover is equal to Cost Of Goods Sold divided Beginning Inventory added Ending Inventory divided number of value 2.
Inventory Turnover = Cost of Goods Sold / ((Beginning Inventory + Ending Inventory) / 2)
Calculate the Ending Inventory
Beginning Inventory (20,000) , Net purchases (30,000) , Cost of goods sold (30,000)
Ending Inventory = (Beginning Inventory + Net Purchases) – (Cost of goods sold)
Ending Inventory = ($20,000 + $30,000) – ($30,000)
Ending Inventory = ($50,000 – $30,000) = $20,000
Calculate the Inventory Turn Over
Inventory Turnover = Cost of Goods Sold / ((Beginning Inventory + Ending Inventory) / 2)
Inventory Turnover = $30,000 / (($20,000 + $20,000) / 2) = 1.5
The answer is Inventory Turn Over = 1.5