Calculating ending inventory is a crucial aspect of managing a business, as it helps in understanding the stock levels and making informed decisions for future purchases. Typically, ending inventory is computed using the cost of goods sold (COGS). However, there might be instances where you don’t have access to COGS data. In such cases, you can still estimate your ending inventory through alternative methods. This article will guide you through calculating ending inventory without relying on the cost of goods sold.

1. Using Gross Profit Margin

Step 1: Determine your gross profit margin (GPM) by dividing your gross profit by total sales revenue. Gross profit can be found on your income statement. Multiply GPM by 100 to get the percentage.

Gross Profit Margin = (Gross Profit / Total Sales Revenue) * 100

Step 2: Calculate your total cost of sales using the following formula:

Total Cost of Sales = Total Sales Revenue – Gross Profit

Step 3: Estimate the beginning inventory, which can be found in your financial records or balance sheet from the beginning of the accounting period.

Step 4: Determine total purchases made during the accounting period by reviewing invoices or recording all new purchased goods.

Step 5: Compute estimated ending inventory using this formula:

Estimated Ending Inventory = Beginning Inventory + Total Purchases – Total Cost of Sales

2. Retail Inventory Method

Step 1: Find out the retail price of every product in your starting inventory and note down the retail value.

Step 2: Add up the total retail value for every item purchased during the accounting period.

Step 3: Calculate total sales revenue for all items at their retail prices during the accounting period.

Step 4: Subtract total sales revenue from the sum of your starting inventory’s retail value and total purchases’ retail value:

Estimated Ending Inventory in Retail Value = Starting Inventory Retail Value + Total Purchases Retail Value – Total Sales Revenue

Step 5: Using your internal records, calculate the relationship between costs and retail prices, also known as the cost-to-retail ratio.

Cost-to-Retail Ratio = Total Cost of Inventory / Total Inventory Retail Value

Step 6: Multiply the ending inventory in retail value by the cost-to-retail ratio to arrive at your estimated ending inventory:

Estimated Ending Inventory = Ending Inventory Retail Value * Cost-to-Retail Ratio

Both these methods can help you calculate the ending inventory without relying on the cost of goods sold figure. It is essential to maintain accurate financial records to ensure proper calculations and make informed decisions for your business.