Calculate Ending Inventory: Formula & Explanation

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:01 Ending Inventory
  • 0:42 What Is a Balance Sheet?
  • 1:37 Ending Inventory Calculation
  • 3:21 Sarah's Data
  • 3:47 Lesson Summary
Create an account to start this course today
Try it free for 5 days!
Create An Account

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: JC Wright
This lesson will outline the concept of ending inventory and how it is used in business. Also, we will take a look at a balance sheet and how investors use it as tool to gain a high-level view of the status of their company.

Ending Inventory Defined

Sarah, a recent MBA graduate, just received her first real job since graduating from business school. She got a job at a manufacturing company called ACME Lumber Yard, where they sell timber to various real estate development firms. Her first assignment is to calculate the ending inventory for all the lumber that is in stock. Ending inventory is the value of goods available for sale at the end of the accounting period.

Being a very eager and productive member of the workforce, Sarah knows in order to successfully report ending inventory, she'll need to look at the previous balance sheet for ACME Lumber Yard.

What Is a Balance Sheet?

But what exactly is a balance sheet? A balance sheet is a summary of a company's assets, liabilities, and shareholders' equity for a given accounting period. The owners (also known as the investors) use the data as a measure of how the company stands in regards to current assets (or items owned by the company) and liabilities (or items that are in accounts payable status). Here are a few examples of assets and liabilities:

Assets (on the positive side of the balance sheet)

  • Inventory
  • Cash
  • Office equipment
  • Computers
  • Company vehicle

Liabilities (on the negative side of the balance sheet)

  • Notes payable
  • Accounts payable
  • Taxes
  • Unearned revenue

This is where the term 'balance sheet' is derived. These transactions account for all of the pluses and minuses that occur within a specified accounting period.

Ending Inventory Calculation

Sarah recalls that calculating ending inventory is pretty straightforward but can be tricky if you are not careful. There are other components that make up this simple equation.

Beginning Inventory + Net Purchases - Cost of Goods Sold (or COGS) = Ending Inventory

Beginning inventory is monetary values that a company assigns to their current inventory. This total will equal the ending inventory of the previous accounting period. Beginning inventory is found on the balance sheet.

Net Purchases are new inventory that was purchased during the current accounting period. A company will need to maintain accurate bookkeeping to maintain records of purchases obtained. This is the gross purchase amount minus any discounts, returns, and allowance.

For example, let's say for the previous accounting period, ACME made a purchase for $4,500 on terms of 2/10 net 30 and there is a return of $150. This means the full amount has to be paid within 30 days (net 30), but ACME has the option take a 2% discount if the full amount is paid within 10 days (2/10):

Gross Purchase: $4,500

Less purchase return: $150

Less purchase discount: $90

Net Purchase: $4,260

To unlock this lesson you must be a Study.com Member.
Create your account

Register for a free trial

Are you a student or a teacher?
I am a teacher
What is your educational goal?

Unlock Your Education

See for yourself why 10 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back

Earning College Credit

Did you know… We have over 49 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Click "next lesson" whenever you finish a lesson and quiz. Got It
You now have full access to our lessons and courses. Watch the lesson now or keep exploring. Got It
You're 25% of the way through this course! Keep going at this rate,and you'll be done before you know it.
The first step is always the hardest! Congrats on finishing your first lesson. Go to Next Lesson Take Quiz
Way to go! If you watch at least 30 minutes of lessons each day you'll master your goals before you know it. Go to Next Lesson Take Quiz
Congratulations on earning a badge for watching 10 videos but you've only scratched the surface. Keep it up! Go to Next Lesson Take Quiz
You've just watched 20 videos and earned a badge for your accomplishment! Go to Next Lesson Take Quiz
You've just earned a badge for watching 50 different lessons. Keep it up, you're making great progress! Go to Next Lesson Take Quiz
You just watched your 100th video lesson. You have earned a badge for this achievement! Go to Next Lesson Take Quiz
Congratulations! You just finished watching your 200th lesson and earned a badge! Go to Next Lesson Take Quiz
Congratulations! You just finished watching your 300th lesson and earned a badge! Go to Next Lesson Take Quiz
You are a superstar! You have earned the prestigious 500 video lessons watched badge. Go to Next Lesson Take Quiz
Incredible. You have just entered the exclusive club and earned the 1000 videos watched badge. Go to Next Lesson Take Quiz
You have earned a badge for watching 20 minutes of lessons.
You have earned a badge for watching 50 minutes of lessons.
You have earned a badge for watching 100 minutes of lessons.
You have earned a badge for watching 250 minutes of lessons.
You have earned a badge for watching 500 minutes of lessons.
You have earned a badge for watching 1000 minutes of lessons.