EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Ending Inventory Formula
 

Ending Inventory Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 31, 2023

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,

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

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

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.

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

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.

Example 1-1

Solution:

Ending Inventory is calculated using the formula given below

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

Result of Example 1

  • 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.

Example 2-1

Solution:

Beginning Inventory is calculated using the formula given below

Beginning Inventory = Price per piece * No. of pieces

Ending Inventory Example 2-2

  • 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)

Ending Inventory Example 2-3

  • 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

Result of Example 2

  • 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.

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 purchasing 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 are 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 by their budget, and in case some production inefficiencies problems come to the 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.

Beginning Inventory
Inventory Purchased During a Year
Cost of Goods Sold
Ending Inventory Formula =
 

Ending Inventory Formula = (Beginning Inventory + Inventory Purchased During a Year) − Cost of Goods Sold
(0 + 0) − 0 = 0

Recommended Articles

This has been a guide to the Ending Inventory formula. Here we discuss How to Calculate Ending Inventory along with practical examples. We also provide Ending Inventory Calculator with a 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

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Ending Inventory Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Ending Inventory Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW