Markup Percentage Formula

Formula of Markup Percentage (Table of Contents)

• Formula
• Examples
• Calculator

What is Markup Percentage Formula?

Markup Percentage can be defined as the gross profit in terms of percentage which would be of the cost of the unit and the same can be calculated by using the below formula:

Hence, it can be stated that markup is a difference between the selling price and the cost of service or goods. And when this difference is taken as a percentage of the cost will be the markup percentage.

Explanation of the Markup Percentage Formula

The markup percentage formula is very useful for the business. The numerator part of the formula is the margin which is desired by the business in order to maximize its profit and also to stay with competitors’ margin otherwise the customer will switch to a competitor who charges less. Therefore, the first step is to calculate gross margin which is nothing but the difference between the sales revenue or the selling price and the cost of goods sold or the cost price of per unit. The second step is to divide the margin or the gross profit by the cost of goods sold which shall give us the markup percentage.

Examples of Markup Percentage Formula (with Excel Template)

Let’s see some simple to advanced examples of markup percentage formula to understand it better.

Example#1

Consider the selling price of a bike is 200,000 and the cost price of the bike is 150,000. You are required to calculate the markup on the bike and markup percentage as well that the dealer is trying to implement on same.

Solution:

Use the following data for the calculation of markup percentage

Calculation of markup can be done as follows –

Markup = 200000 – 150000

Markup = 50000

So, the calculation of markup percentage can be done as follows –

Markup percentage = 50,000 / 150,000 * 100

Markup Percentage will be –

Markup Percentage = 33.33%

Example#2

McDonalds one of the famous brands in the world to make hamburgers. Mr. Wyatt who eats a lot of these hamburgers is interested in knowing what markup they apply and hence decided to review their income statement. Reviewing its income statement for the quarter ended December 2018, one can observe that for that quarter ended December 2018, it has reported revenue of $5.163 billion and further, it has reported $2.697 billion as the gross profit. You are required to calculate the Markup Percentage that McDonald’s is applying to earn, and the cost of the goods sold.

Solution:

Use the following data for the calculation of markup percentage

Calculation of cost of goods sold can be done as follows –

Cost of Goods Sold = 5.163 – 2.697

Cost of Goods Sold = 2.466

So, the calculation of markup percentage can be done as follows –

Markup Percentage = 2.697 / 2.466 * 100

Markup Percentage will be –

Markup Percentage = 109.37%

Example#3

Ankit industries based out of Surat from Gujarat in India and are operating under the textile business. Simula and company have been appointed as the stock auditors for Ankit industries. Ankit industries are need of funds to expand the business and hence have applied for an overdraft facility with the State Bank. State Bank has gone through the application and was surprised to know that it reported 78% markup margin and hence ask Simual and company to investigate the number and if a found correct bank will fund the 80% of the loan requirement subject to fulfillment of other terms and conditions.

Solution:

Use the following data for the calculation of markup percentage

Calculation of cost of goods sold can be done as follows –

Cost of Goods Sold = 20000000 + 15000000 + 30000000 + 60000000 + 4000000

Cost of Goods Sold = 129000000

Calculation of gross profit can be done as follows –

Gross Profit = 229620000 – 129000000

Gross Profit = 100620000

So, the calculation of markup percentage can be done as follows –

Markup percentage = 100620000 / 129000000

Markup Percentage will be –

Markup Percentage = 78%

Markup Percentage Formula Calculator

You can use the following Markup Percentage Formula Calculator

Relevance and Uses

Understanding the markup is very crucial and important for the firm or the business. Take an example, establishing the strategy for pricing will be one of the key parts in terms of strategic pricing. The markup of a service or good should be enough to offset or say in order words to cover up all the business expenses and it should also be able to generate a profit for the firm or the business.

Markup can be different for various industries as the same cannot be static or normal. This would totally depend upon how good the reputation of the firm is, how loyal are their customers to their brand, switching cost for a customer from the company’s product to the supplement product. Further, the pricing power of the company also helps in determining the markup that they desire.

You can download this Markup Percentage Formula Excel Template here – Markup Percentage Formula Excel Template

Recommended Articles

This has been a guide to Markup Percentage Formula. Here we discuss how to calculate markup percentage using its formula along with examples and downloadable excel template. You can learn more about financial analysis from the following articles –

• Financial Analysis Types
• Formula of Markup
• Margin vs Markup – Compare
• What is Profit And Loss Statement?
• What is Gross Profit?