EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Gross Profit Formula

Gross Profit Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated May 30, 2023

Gross Profit Formula

Gross Profit Formula (Table of Contents)

Start Your Free Investment Banking Course

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

  • Gross Profit Formula
  • Examples of Gross Profit Formula (With Excel Template)
  • Gross Profit Formula Calculator

Gross Profit Formula

The term “gross profit” refers to the profit of a company that is derived after subtracting all the costs that can be allocated to the production and sales (also known as the cost of goods sold or cost of sales) or the costs that can be assigned to the service provided. Some companies report a gross profit as a line item in the income statement. The formula for gross profit can be derived by subtracting the cost of goods sold (COGS) from the company’s net sales.

Mathematically, it is represented as:

Gross Profit = Net Sales – COGS

Examples of Gross Profit Formula (With Excel Template)

Let’s take an example to understand the calculation of the Gross Profit in a better manner.

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

Example #1

Let us take the example of a mechanic shop that has reported net sales of $150,000 for the year ended on March 31, 2019. As per the income statement, the COGS stood at $105,000 during the period. Calculate the gross profit of the machine shop for the year.

Example 1-1

Solution:

To calculate Gross Profit, you can use the formula provided below:

Gross Profit = Net Sales – COGS

Gross Profit Formula Example 1-2

  • Gross Profit = $150,000 – $105,000
  • Gross Profit = $45,000

Therefore, the machine shop booked a gross profit of $45,000 during the year ended on March 31, 2019.

Example #2

ABC Limited is in the business of manufacturing rigid and flexible packaging products in the US region. Recently the company published its financial performance, which showed that ABC Ltd clocked net sales of $500,000 during the year ended on December 31, 2018. Therefore, calculate the gross profit for ABC Ltd based on the given information.

Example 2-1

COGS is calculated using the formula given below:

COGS = Raw Materials Expense + Labour Wage + Factory Lease Rental

Gross Profit Formula Example 2-2

  • COGS = $185,000 + $135,000 + $50,000
  • COGS = $370,000
[Interest paid, depreciation expense, and taxes paid are not considered in the computation of COGS because these are not direct costs of production].

Gross Profit is calculated using the formula given below:

Gross Profit = Net Sales – COGS

Gross Profit Formula Example 2-3

  • Gross Profit = $500,000 – $370,000
  • Gross Profit = $130,000

Therefore, ABC Ltd secured a gross profit of $130,000 during the year ended on December 31, 2018.

Example #3

Let us take the example of Airbus SE to calculate the gross profit for the calendar years 2016, 2017, and 2018. The following information is available per the annual reports for the year ending on December 31, 2018.

Example 3-1

It is calculated using the formula given below:

Gross Profit = Net Sales – COGS

Gross Profit Formula Example 3-2

For 2016

  • Gross Profit = €66,581 Mn – €61,317 Mn
  • Gross Profit = €5,264 Mn

For 2017

  • Gross Profit = €59,022 Mn – €52,149 Mn
  • Gross Profit = €6,873 Mn

For 2018

  • Gross Profit = €63,707 Mn – €54,920 Mn
  • Gross Profit = €8,787 Mn

Therefore, we can observe that despite some volatility in net sales, Airbus SE’s gross profit has consistently improved from €5,264 Mn in 2016 to €8,787 Mn in 2018.

Explanation

You can derive the formula for gross profit by following the steps outlined below:

Step 1: First, determine the company’s net sales, which are readily available as a line item in the income statement.

Step 2: Next, you can determine the COGS from the income statement by adding all the costs of production that directly allocate to manufacturing. Such direct costs include raw material costs, factory rent, labor wages, etc.

Step 3: Finally, the formula for gross profit can be derived by subtracting the COGS (step 2) from the net sales (step 1) of the company, as shown below.

Gross profit = Net sales – COGS

Relevance and Uses

We know that gross profit is the difference between net sales and the direct cost of production and sales. As such, we must understand that we can impact a company’s bottom line by increasing gross profit. One of the ways to increase the gross profit is to either increase efficiency, which will apportion the direct cost of production to increased volume, which means that we can make more money without even increasing the sales. This can prove to be a critical strategy in a highly competitive market where the competitors are also manufacturing and selling the same product. Higher gross profit can be a tremendous competitive advantage.

Gross Profit Formula Calculator

You can use the following Gross Profit Calculator

Net Sales
COGS
Gross Profit Formula
 

Gross Profit Formula = Net Sales – COGS
= 0 – 0
= 0

Recommended Articles

This has been a guide to the Gross Profit formula. Here we discuss how to calculate Gross Profit along with practical examples. We also provide a Gross Profit calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Guide to Working Capital Turnover Ratio Formula
  2. Calculator For Degree of Operating Leverage
  3. Formula to Calculate Operating Income
  4. Calendar Year vs Fiscal Year
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
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
FINANCE for NON-FINANCE Managers Course Bundle - 19 Courses in 1 | 6 Mock Tests
48+ Hours of HD Videos
19 Courses
6 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
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
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training
 278+ Hours of HD Videos
51 Courses
30 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.6
Price

View Course
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

Download Gross Profit Formula Excel Template

Let’s Get Started

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

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

*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 Profit 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