WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Assets Tutorials » Closing Stock

Closing Stock

What is Closing Stock?

Closing stock or inventory is the amount that a company still has on its hand at the end of a financial period. This inventory may include products that are getting processed or are produced but not sold. On a broad level, it includes raw material, work in progress, and finished goods—the units of closing stock help in determining the total amount.

However, for a larger business, this is often impossible. Improvement in the inventory management software and other technologies are helping curb this problem.

Closing Stock Formula

Closing Stock Formula

Below is the formula to calculate closing stock

Closing Stock Formula (Ending) = Opening Stock + Purchases – Cost of Goods Sold.

Top 4 Methods to Calculate Closing Stock

The method which company decides to use for pricing its closing stock will have a huge impact on its balance sheet and also on the income statement.

Methods to Calculate Closing Stock

The top 4 most common methods to calculate closing stock are as follows –

#1 First in first out (FIFO)

FIFO inventory method assumes inventory which is brought first will be sold first, and the latest and the newest inventory is kept unsold. It means that the cost of older inventory is assigned to the cost of goods sold and the cost of the newer inventory is assigned to ending inventory

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
FIFO Example
  • Beginning Inventory – 10 units @ $5 per unit
  • Purchase – 140 units @ $6 per unit
  • Sale – 100 units @ $5 per unit

Ending inventory – 10 + 140 – 100 = 50

Ending inventory amount ($) – 50 * $6 = $300

#2 Last in first out (LIFO)

LIFO Inventory Method assumes that the last item purchased will be sold off first. This method can be used for products which are not perishable or can be obsolete

LIFO Example
  • Beginning Inventory – 10 units @ $5 per unit
  • Purchase – 140 units @ $6 per unit
  • Sale – 100 units @ $5 per unit

Ending Inventory – 40 + 10 = 50

Ending inventory amount ($) – 40 * $6 + 10 * $5 = $240 + $50 = $290

#3 Average cost method

Under this method, the weighted average cost is calculated for the closing stock. It is calculated as – cost of goods in inventory/total units

Average Cost Example
  • Beginning Inventory – 10 units @ $5 per unit
  • Purchase – 140 units @ $6 per unit
  • Sale – 100 units @ $5 per unit

Weighted average cost per unit – (10 * 5 + 140 * 6)/150 = $5.9

Closing stock amount ($) – 50 * $5.9 = $295

#4 Gross profit method

Gross Profit method is also used to estimate the amount of closing stock.

  • Step 1 – Add the cost of beginning inventory. The cost of purchases we will arrive at the cost of goods available for sale.
  • Step 2 – Multiply (1 – expected gross profit) with sales to arrive at the cost of goods sold
  • Step 3 – Calculate Closing Stock – To arrive at this amount, we will have to subtract the estimated cost of goods in step two from the cost of goods available for sale in step one.
Gross Profit Method Example
  • Beginning Inventory – 10 units @ $5 per unit
  • Purchase – 140 units @ $6 per unit
  • Sale – 100 units @ $5 per unit
  • Cost of Goods Available for Sale = 10 x 50 + 140 x 6 = 940
  • Expected Profit margin = 40%

Sales = 100 x 5 = 500

Cost of Goods Sold = 500 x (1-40%) = 300

Closing Stock ($) = 940 – 300 = 640

The drawback of this method is that the estimation of gross profit in step 2, base on the historical estimate, which may not necessarily be the case in the future. Also, if there are any inventory losses in that period are higher or lower than the historical rates, it can lead to an inappropriate amount of closing inventory.

Impact of Pricing Method on Closing Stock

The method by which a company decides to price its inflation affects its financial position and profits. If the company decides to use LIFO, then the cost of goods sold will be higher (assuming inflation is increasing), which reduces the gross profit and thus reduces the taxes. It is one of the vital reasons company’s prefer LIFO accounting over FIFO. One more valid reason is that on using FIFO, the amount of closing stock in the balance sheet will be higher in comparison to FIFO.

Ratios are also affected by the method in which inventory is used. The current ratio calculated as current assets/ current liabilities will be higher when FIFO is used. Ending stock will increase the number of Current Assets. On the other hand, the inventory turnover ratio calculated as Sales / Average inventory will be lower if FIFO is used.

Recommended Articles

This article has been a guide to What is Closing Stock? Here we look at its formula, the top 4 methods to calculate closing stock (LIFO, FIFO, Average Cost, Profit Margin) along with its impact on the financial statements. You may learn more about accounting basics from the following articles –

  • Floating Stock
  • Opening Stock Types
  • Inventory vs. Stock
13 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

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

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More