Ending Inventory Formula

Ending Inventory Formula (Table of Contents)

• Ending Inventory Formula
• Examples of Ending Inventory Formula (With Excel Template)
• Ending Inventory Formula Calculator

Ending Inventory Formula

Ending inventory is the inventory account balance at the end of an accounting period which reflects the balance after the purchase of additional inventory along with the sale of finished inventory during the period. The formula for ending inventory is derived by adding inventory at the beginning of the year to inventory purchased during the year and deducting the cost of goods sold incurred during the manufacturing process. Mathematically, ending inventory formula can be expressed as below,

Examples of Ending Inventory Formula (With Excel Template)

Let’s take an example to understand the calculation of Ending Inventory formula in a better manner.

Ending Inventory Formula – Example #1

Let us take the example of a manufacturing company ABC Ltd where the inventory at the beginning of the year is $2,500, additional inventory purchased during the year is $3,000 and the cost of goods sold consumed in the manufacturing of the product is $4,000. Calculate the ending inventory of the company.

Solution:

Ending Inventory is calculated using the formula given below

Ending Inventory = Beginning Inventory + Inventory Purchased During the Year – Cost of Goods Sold

• Ending Inventory = $2,500 + $3,000 – $4,000
• Ending Inventory = $1,500

Therefore, ABC Ltd has an inventory of $1,500 at the end of the year.

Ending Inventory Formula – Example #2

Let us take the example of another manufacturing company XYZ Ltd. The company has clocked revenue of $100,000 with a gross margin of 80%. The company had a raw material inventory of 3,000 pieces at the beginning of the year priced at $10 per piece and purchased additional inventory worth $40,000 during the year. Calculate the ending inventory of the company.

Solution:

Beginning Inventory is calculated using the formula given below

Beginning Inventory = Price per piece * No. of pieces

• Beginning Inventory = $10 * 3,000
• Beginning Inventory = $30,000

Cost of Goods Sold is calculated using the formula given below

Cost of Goods Sold = Revenue * (1 – Gross margin)

• Cost of Goods Sold = $100,000 * (1 – 80%)
• Cost of Goods Sold = $20,000

Ending Inventory is calculated using the formula given below

Ending Inventory = Beginning Inventory + Inventory Purchased During the Year – Cost of Goods Sold

• Ending Inventory = $30,00 + $40,000 – $20,000
• Ending Inventory = $50,000

Therefore, XYZ Ltd has an inventory of $50,000 at the end of the year.

You can download this Ending Inventory Template here – Ending Inventory Formula Excel Template

Explanation

The formula for ending inventory can be simply calculated by using the following four steps:

Step 1: First, determine the inventory of the company at the beginning of the year from the stock book and confirm with the accounts department. It will consist of finished, semi-finished and raw material inventory.

Step 2: Next, figure out the inventory purchased during the year from the purchase department of the company. It will be basically raw material inventory.

Step 3: Next, figure out the cost of goods sold during the year from the production department of the company. It will be semi-finished and raw material inventory.

Step 4: Finally, the inventory at the end of the accounting period can be derived by adding inventory at the beginning of the year to inventory purchased during the year and deducting the cost of goods sold as shown below.

Ending Inventory = Beginning Inventory + Inventory purchased during the year – Cost of Goods Sold

Relevance and Uses of Ending Inventory Formula

It is very important to understand the formula for ending inventory because it includes the cost of all the products that have been manufactured and is currently available for sale at the end of the accounting period. The ending inventory also includes the raw material and other work-in-progress which will be eventually converted into end products. In simple words, the stock at the end of the accounting period that has been stored either in the warehouse or at other stock keeping units is known as ending inventory and it includes raw material, partially manufactured products and finished products which are ready for sale.

There are many companies and firms who believe in taking a physical count of inventory at the end of an accounting period to check if the inventory recorded in the automated systems matches the inventory maintained at the stock keeping unit. The auditors at times require this type of validation. If there is a huge variation in the tally of the actual inventory and what is there in the automated system, then there may be an issue of shrinkage etc. On the other hand, if the ending inventory balance is understated, then, as a result, the net income for the same period may also become understated. From a manufacturer’s point of view, the computation of ending inventory is instrumental in determining whether the company has abided to their budget and in case some production inefficiencies problem come to surface, then that should be taken up for further investigation.

If ending inventory is greater than beginning inventory, then it can be inferred that one has sold a lesser value of products than purchased during the period or simply speaking the current manufacturing has used raw material lower than that has been purchased in the current year resulting in addition to the existing inventory. On the other hand, if ending inventory is lower than beginning inventory, then it can be inferred that one has sold a greater value of products than purchased during the period or in other words the current manufacturing has used the existing inventory over and above the raw material purchase in the current year.

Ending Inventory Formula Calculator

You can use the following Ending Inventory Calculator.

Recommended Articles

This has been a guide to Ending Inventory formula. Here we discuss How to Calculate Ending Inventory along with practical examples. We also provide Ending Inventory Calculator with downloadable excel template. You may also look at the following articles to learn more –

1. Formula for Sharpe Ratio
2. Calculate Straight Line Depreciation
3. Calculator for Variable Costing Formula
4. Guide to Cost of Capital Formula