WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Gross Profit Margin

Gross Profit Margin

What is the Gross Profit Margin?

Gross Profit Margin is the ratio that calculates the profitability of the company after deducting the direct cost of goods sold from the revenue and is expressed as a percentage of sales. It doesn’t include any other expenses into account except for the cost of goods sold.

Gross Profit Margin Formula

Here’s the formula –

Gross-Profit-Margin-Formula

In the gross profit margin formula, there are two components.

  • The first component is gross profit. To calculate gross profit, we need to start with the gross sales. Gross sales are the first item in an income statement. We deduct the sales returns/sales discounts from gross sales, and we get net sales. The next item in the income statement is the costs of goods sold. When we deduct the costs of goods sold from net sales, we get the gross profit of the company for the year.
  • The second component of the gross margin ratio is revenues. Here revenues mean the total sales value of goods sold. When we multiply the sales price for each of the numbers of goods sold, we get the total revenue. Since “sales returns” or “sales discounts” can’t be included in the total sales value, we need to deduct these items from the total sales value. And by deducting these, we get “net sales.” And here, we will consider “net sales” as the second component of the gross margin ratio.

Examples

Honey Chocolate Ltd. has the following information in its income statement –

  • Net Sales – $400,000
  • Cost of Goods Sold – $280,000

Find out the gross margin of the year.

First of all, we need to find out the gross profit of Honey Chocolate Ltd.

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

Here’s the calculation.

  • Gross Profit = (Net Sales – Cost of Goods Sold) = ($400,000 – $280,000) = $120,000.

Using the gross profit margin formula, we get –

  • Gross Margin = Gross Profit / Revenue * 100
  • Or, Gross Margin = $120,000 / $400,000 * 100 = 30%.
  • From the above calculation for the Gross margin, we can say that the gross margin of Honey Chocolate Ltd. is 30% for the year.

To interpret this percentage, we need to look at other similar companies in the same industry.

Gross Margin of Colgate

Let us calculate Colgate’s Gross Margin. Colgate’s Gross Margin = Gross Profit / Net Sales.
Gross Profit Margin - Colgate
Gross Profit margin - Ratio Analysis colgate
Cost of Operations include the Depreciation related to manufacturing operations (Colgate 10K 2015, pg 63)
Shipping and handling costs may be reported in the Cost of Sales or Selling General and Admin Expenses. Colgate reported these as a part of Selling General and Admin Expenses. If such expenses are included in the Cost of Sales, then the Gross margin of Colgate would have decreased by 770 bps from 58.6% to 50.9% and decreased by 770bps and 750 bps in 2014 and 2013, respectively.
Gross Margin - Colgate 10K
source: – Colgate 10K 2015, pg 46

Uses

Profitability is an important factor to consider for investors. Investors look at mainly net profit margin along with gross margin. The gross profit margin calculator is useful to investors because by calculating the percentage, they can easily compare it with other similar companies.

Comparing the gross profit percentage of all similar companies in the same industry provides the investors with the knowledge of whether the gross profit of the target company is healthy or not. Gross profit percentage, the better the company’s overall health and profitability. However, every investor should look at all the financial ratios before coming to any conclusion.

Gross Profit Margin Calculator

You can use the following calculator.

Gross Profit
Revenue
Gross Profit Margin Formula =
 

Gross Profit Margin Formula ==
Gross Profit
X100
Revenue
0
X100= 0
0

Calculate Gross Profit Margin in Excel

Let us now do the same example of a gross margin calculator.

This is very simple. You need to provide the two inputs of Gross Profit and Revenue.

You can easily calculate the Gross Margin in the template provided.

Gross Profit Margin in Excel

You can download this template here – Gross Profit Margin Excel Template.

Gross Profit Margin Video

Recommended Articles:

This has been a guide to Gross Profit Margin and its definition. Here we discuss the formula to calculate gross margin along with practical examples, its uses, and interpretation. Here are the other suggested articles –

  • Calculate Profit Percentage
  • Gross Profit Formula
  • Gross Profit
  • Net Profit Margin Calculator
2 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
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

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 Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

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