EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • 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
  • Login
Home Finance Finance Resources Finance Formula Gross Margin Formula

Gross Margin Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 25, 2023

Gross Margin Formula

Gross Margin Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Gross Margin Formula?

The term “Gross Margin” refers to the profitability measure that assesses whether or not a company can run its operation efficiently and generate enough profit. Basically, gross margin determines the profitability after adjusting the costs of production that can be directly assigned to the manufacturing process.

Such directly assignable costs primarily include raw material cost, direct labor expense, and manufacturing overhead, and are they collectively known as the cost of goods sold or cost of sales? Some companies report a gross profit as a line item in the income statement.

ADVERTISEMENT
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training

Start Your Free Investment Banking Course

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

The formula for gross margin is very simple and can be derived by dividing the difference between the net sales and the cost of goods sold by the net sales, which is then expressed in percentage by multiplying by 100%.

Mathematically, it represents as:

The formula for Gross Margin Formula:

Gross Margin = (Net Sales – Cost of Goods Sold) / Net Sales * 100

Example of Gross Margin Formula (With Excel Template)

Let’s take an example to see the calculation of Gross Margin better.

You can download this Gross Margin Formula Excel Template here – Gross Margin Formula Excel Template

Example #1

Let us take the example of ASD GmbH CO KG to illustrate the computation of gross margin. The company is based in Germany, and it manufactures corrugated boxes that are supplied to parts of the country. According to its annual report for the year 2018, the company successfully clocked net sales of €27.8 million during the year. Calculate the company’s gross margin if the following cost break-up is available.

 Example of Asd Gmb H Co Kg

Solution:

The Cost of Goods Sold is calculated using the formula given below

Cost of Goods Sold = Raw Materials Cost + Direct Labor Cost + Factory Rental Expense

Gross Margin Formula-1.2

  • Cost of Goods Sold = €9.50 million + €6.50 million + €1.20 million
  • Cost of Goods Sold = €17.20 million

Gross Margin calculates using the formula given below

Gross Margin = (Net Sales – Cost of Goods Sold) / Net Sales * 100

Gross Margin Formula-1.3

  • Gross Margin = (€27.80 million – €17.20 million) / €27.80 million * 100%
  • Gross Margin = 38.13%

Therefore, the Company’s Gross Margin was 38.13% in 2018.

Example #2

Let us take the example of Samsung to illustrate the computation of gross margin for a real-life company. The recent annual report states that the company achieved revenue of $221.57 billion in 2018 vis-à-vis $217.75 billion in 2017. On the other hand, the corresponding cost of sales was $120.34 billion in 2018 vis-à-vis $117.51 billion in 2017. Calculate the gross margin of the company for the years 2017 and 2018.

Example of Samsung to Illustrate

Solution:

Gross Margin calculates using the formula given below:

Gross Margin = (Revenue – Cost of Goods Sold) / Revenue * 100

Gross Margin Formula-2.2

For the Year 2017

  • Gross Margin = ($217.75 billion – $117.51 billion) / $217.75 billion * 100
  • Gross Margin = 46.03%

For the Year 2018

  • Gross Margin = ($221.57 billion – $120.34 billion) / $221.57 billion * 100
  • Gross Margin = 45.69%

Therefore, Samsung’s Gross Margin declined slightly from 46.03% in 2017 to 45.69% in 2018.

Example #3

Let us take the example of Walmart Inc. for the computation of gross margin. According to the annual report for the year 2018, the company achieved net sales of $495.76 billion and incurred the corresponding cost of sales of $373.40 billion. Calculate the gross margin of the company for the year 2018.

Example of Walmart Inc.

Solution:

Gross Margin calculates using the formula given below:

Gross Margin = (Revenue – Cost of Goods Sold) / Revenue * 100

Gross Margin Formula-3.2

  • Gross Margin = ($495.76 billion – $373.40 billion) / $495.76 billion * 100%
  • Gross Margin = 24.68%

Therefore, Walmart Inc.’s Gross Margin for the year 2018 was 24.68%.

Explanation

The formula for Gross Margin calculates by using the following steps:

Step 1: First, figure out the net sales, usually the first line item in a company’s income statement.

Step 2: Next, figure out the cost of goods sold or the cost of sales from the income statement. It is either available as a line item or has to compute by adding up all the costs of production that directly assigns to production.

Step 3: Next, calculate the gross profit by deducting the cost of goods sold (step 2) from the net sales (step 1).

Gross Profit = Net Sales – Cost of Goods Sold

Step 4: Finally, the formula for gross margin derives by dividing the gross profit (step 3) by the net sales (step 1) and multiplying by 100%, as shown below.

Gross Margin = (Net Sales – Cost of Goods Sold) / Net Sales * 100

Relevance and Use

It is important to understand the concept of gross margin because it helps a company’s management better assess its operational efficiency and profitability in a general sense. But judging what can be considered a healthy gross margin is very difficult. Inherently, analysts use the margins of industry peers as a benchmark to assess the gross margin, and they consider any company performing better than that benchmark as good.

Gross Margin Formula Calculator

You can use the following Gross Margin Formula Calculator

Net Sales
Cost of Goods Sold
Gross Margin
 

Gross Margin =
Net Sales - Cost of Goods Sold x 100
Net Sales
=
0 - 0 x100= 0
0

Recommended Articles

This is a guide to Gross Margin Formula. Here we discuss calculating the gross margin formula and practical examples. We also provide a gross margin calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Gross Income Formula
  2. Gross Profit Percentage
  3. How to Calculate Net Cash Flow
  4. Gross sales vs Net sales
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
IFRS Course Bundle - 30 Courses in 1 | 5 Mock Tests
42+ Hour of HD Videos
30 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
FINANCE for NON-FINANCE Managers Course Bundle - 19 Courses in 1 | 6 Mock Tests
47+ Hours of HD Videos
19 Courses
6 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Finance Professionals Course Bundle - 28 Courses in 1 | 14 Mock Tests
95+ Hours of HD Videos
28 Courses
14 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - 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

EDUCBA

Download Gross Margin Formula Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

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

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

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Gross Margin Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW