Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Cost of Sales Formula

Cost of Sales Formula

Cost of Sales Formula (Table of Contents)

  • Formula
  • Examples

What is the Cost of Sales Formula?

Cost of Sales can be referred to as those costs which are directly attributable to the production of the goods that shall be sold in the firm or in an organization. The formula for Cost of Sales is represented as below

Cost of Sales = Beginning Stock + Purchases made During the Period – Closing Stock
  • Inventory which is sold by the company will appear in the profit and loss statement under the Cost Of Goods Sold account. The beginning stock for the year is the stock which is leftover from the prior year—that is, the merchandise or the product which was not sold in the prior year.
  • Any new or additional purchases or productions that are made by a retail or a manufacturing firm shall be added to the beginning stock.
  • At the end of the current reporting period, the products or the merchandise that was not sold those shall be subtracted from the total of the beginning stock and any new or additional procurements or purchases.
  • The resultant or the final number which is derived from the above calculation will be the cost of sales or in other words, it will be the cost of goods sold for the reporting period.

Examples of Cost of Sales Formula

Let’s see some simple to advanced practical examples of the cost of the Sales Formula to understand it better.

You can download this Cost of Sales Formula Excel Template here – Cost of Sales Formula Excel Template

Example #1

Inventory limited reported goods sales numbers this quarter. The Gross profit was reported better than in the previous quarter. The company reported 230,000 as of the opening stock, 450,000 as closing stock and 10,50,000 as net purchases. You are required to compute the cost of sales for inventory limited.

Solution:

We are given opening Stock, Closing Stock and purchases, therefore we can use the below formula to calculate the cost of sales.

Use the following data for calculation of the cost of sales

Cost of Sales Formula Example 1

Calculation of Cost of Sales can be done as follows:

 Example 1.1png

= 230,000 + 10,50,000 – 450,000

Cost of Sales will be –

Example 1.2png

  • Cost of Sales = 8,30,000

Therefore, the cost of sales will be 830,000.

Example #2

AMC limited recently reported its numbers. The shareholders have asked for an internal audit as they believe the management has conceded certain facts. Mr. J & Co. were appointed as the internal auditors of the company. He wanted first to calculate the gross profit of the company via production records. He first wanted to calculate the cost of sales based on available information. You are required to compute the cost of sales. He was given the following details:

Cost of Sales Formula Example 2

Solution

Here, we are not given directly closing stock which we will first need to calculate.

Average Inventory 

Cost of Sales Formula Example 2.1png

Inventory Turnover Ratio = Sales /Average inventory

5 =100,000,000 /Average inventory

Average Inventory   = 100,000,000 / 5

  • Average Inventory   = 20,000,000

Now, we can calculate closing stock using below formula

Closing Stock

Example 2.2png

Average Inventory =Opening stock + Closing stock/  2

20,000,000 = 15,000,000 + Closing stock /  2

Closing stock= 40,000,000 – 15,000,000

  • Closing Stock=25,000,000

Calculation of Cost of Sales can be done as follows:

Cost of Sales Formula Example 2.3png

=15,000,000 + 75,000,000 – 25,000,000

Cost of Sales will be –

Cost of Sales Formula Example 2.4png

  • Cost of Sales =65,000,000

Therefore, the cost of sales will be 65,000,000.

Example #3

XYZ a newly listed company in the stock exchange has reported below income statement. From the below statement, you are required to compute the cost of sales.

Cost of Sales Formula Example 3

Solution:

We are given here, opening stock and closing stock, but we are not given net purchases figure directly. First, we shall calculate the purchase cost.

Purchase Cost 

Example 3.1png

Purchases =51,22,220

Total of raw material and labor cost for raw material we shall take it as purchase cost which is 32,33,230 + 18,88,990 which equals to 51,22,220.

Calculation of Cost of Sales can be done as follows:

Cost of Sales Formula Example 3.2png

= 11,88,990 + 51,22,220 – 12,12,887

Cost of Sales formula will be –

 Example 3.3png

Cost of Sales = 50,98,32

Therefore, the cost of sales will be  50,98,323.

Relevance and Uses

The Cost of Goods Sold or the Cost of Sales is a vital metric on the financial statements of the company as this figure is subtracted from the firm’s sales to determine its gross profit. The gross profit is a type of profitability measure which evaluates how efficient the firm or an organization is in managing its supplies and labor in the process of production.

Because Cost Of Goods Sold or Cost of sales is a cost of conducting the business, this can be recorded at the expense of the business on the face of profit and loss statement. Having knowledge of the cost of goods sold or cost of sales shall help the investors, analysts, and managers to estimate the firm’s bottom-line figure. If the Cost Of Goods Sold increases, the net profit of the company will decrease. While this movement can be considered as beneficial for purposes of income tax, the company or the firm will have low profit for its investors or the shareholders. Businesses or the companies at the end of the day try to keep their Cost of sales low so that the net income can be reported higher.

Recommended Articles

This has been a guide to the Cost of Sales Formula. Here we discuss the formula to calculate the cost of sales along with practical examples and downloadable excel template. You can learn more about financial analysis from the following articles –

  • Journal Entries of COGS
  • Calculate Cost of Goods Manufactured
  • COGS Formula
  • Examples of COGS

The post Cost of Sales Formula appeared first on .



This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

Cost of Sales Formula

×

Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription

×