Profit Margin and Price Markup Calculation and Formulas [Excel]

Scroll this

You want to calculate Profit Margin or Price Markup? Fair Game.
I’ve put the explanations and an Excel template together. I’m assuming you can read mathematical notation and understand some business terms.

I’ll try and explain some of the concepts and cover Selling Price, Mark-up Percentage, Gross Margin Percentage, and Selling Price Margin which are the sales formulas for businesses.

This isn’t the only Business Math out there, for the full bang check out the book.

Introduction to the uninitiated

In business, there is a vernacular that you need to understand. All business people, managers and owners of businesses understand these terms and how they apply. The terms and phrases convey concepts that are critical to the running and managing of the business without needing to explain it each time it is being talked about.

Examples of this are net, gross, cost of goods, markup, markdown, the margin. Learn them, love them and know what they refer to. A little off track, just as Management has a language, so does every other profession, if you are in sales, you would need to know the terms of the sales like a green field, low hanging fruit, bluebird, closed questions, gatekeeper, decision-maker, and sandbagging.

Skipping to the end

Some of you are only here for the Excel sheet, here you are freeloaders Excel template for Markup and Profit Margin.

Some Definitions if you need them

This paragraph isn’t detailed, I’m working on the assumption you know this. If you need more detail check out the book. Gross refers to the total (everything) and net refers to the part of the total that really matters (what you take home, or were left with). The revenue is what you make (income) from sales, minus discounts and rebates via the main operations of the business. Finally, the cost of goods sold (abbreviated COGS) is a combined value that takes into account numerous out-going money streams such as all the costs of purchase, transport, packaging, material, labour, allocated overhead to store (this is oversimplification it also uses LIFO or FIFO). The goods not sold is deferred as a cost of inventory until the inventory sells or gets written down in value.


We need to go through a very simplistic explanation of pricing. Keep in mind that there are more than 20 strategies to just pricing. Strap in.

An example everyone can connect with is psychological pricing is a strategy that says consumers assume odd or un-rounded prices are perceived lower than they actually are. An example of this would be $ 1.99 or $ 1.98 is perceived as $ 1.00 and not $ 2.00. An easy-ish (I suppose) rounding mistake, unless you are talking about $ 49,999 and the rounding mistakes is $1,000. Now you know why most prices aren’t round numbers.

If you suffer from this mental tick, just practice always rounding up. Psychological pricing is one type of strategy that you can follow. Others are price skimming, price discrimination and yield management, price points, bundle pricing, penetration pricing, price lining, value-based pricing, geo and premium pricing all of which are demand-driven strategies. Again I’m not going into details, I’ll cover these elsewhere.

For my calculation examples, I am going to use a psychological selling price of $1.99 my cost price/purchase price/buy price is going to be $ 1.40

Mark-up Percent

If we know our cost, and selling price, and we want to know the mark-up percentage.

Selling Price

If we don’t have the selling price, but we know the total cost or cost price and have a 42% mark up. For this step, we need to keep in mind that 42% can also be written as 0.42.

Gross Margin Percent

The difference between profit margin (this calculation) and markup (previous calculation) is that profit margin is sales minus the cost of goods sold; meanwhile, markup is the amount by which the cost is increased on a product to arrive at the selling price. Simple right?

To get to the Gross Margin Percent here is the calculation:

Selling Price Margin

If you have a margin requirement of 30% and you know your cost price and need to apply this to your pricing:

We’ve gone through the basic pricing calculations for Markup and Margin.

Here is an Excel template for Markup and Profit Margin to see the calculations. Click on the link.

If you want to learn more about business maths buy the book.


  1. When Do we use Markup Percent & Gross Profit calculation ? Which is the right calculation to be done.

    • Hi Rajesh,
      Thanks for the Question and sorry for taking so long to get back to you,
      If we are discussing Markup and Margin from a pricing and discounting perspective; Markup is the difference between your cost of goods and your selling price. So you are always discussing pricing in terms of the difference between your costs and selling price. This is a popular pricing and discounting method in Retail.
      Margin based pricing is more aligned to the costs. I know that high turnover, low margin (profit) business models prefer this pricing model. This ensures that they continually drive profit in their pricing and decision making.
      Which method to use is based on your business, what matters is that a single method is decided and used. IT can become confusing if both are used in the business.

    • Hi Lottie,
      50 ZMK (Zambian Kwachas) marked up by 50%.
      A percentage (50%) when expressed as a decimal is shown as 0.50, 20% is 0.20, 10% is 0.10 etc
      Selling Price = Total Cost x (1 + Mark-Up Percent)
      Selling Price = 50 ZMK x (1 + 0.50)
      Selling Price = 50 ZMK x (1.50)
      Rounded Selling Price = 75 ZMK
      Alternatively you could just say half (50%) of 50 ZMK (your cost) is 25 ZMK, and test a selling price of 75 ZMK (50 ZMK + 25 ZMK) as shown below,
      Mark-up Percent = (Selling Price – Cost Price) ÷ Cost Price
      Mark-up Percent = (75 ZMK – 50 ZMK) ÷ 50 ZMK
      Mark-up Percent = 25 ZMK ÷ 50 ZMK
      Mark-up Percent = 50%
      For interest a 50% mark-up is 33.3% gross margin in this case.

  2. I have a question regarding the formula you use in your Excel spreadsheet template included as a link in your post above.. In the “Know the Cost and have a Desired Selling Price?” section, why do you have the selling price column formula being divided by 1 (ie. formula in I18)?

    • Hi Kel,
      Looking at the formula again Selling Price = ( Cost Price * ( Desired Markup % + 1 ) ) would get you the answer you are looking for; in all honesty can’t remember why I put in the division.

  3. Thanks for the great article.
    I have some suggested edits:
    I explain some of the concepts and covers Selling Price, Mark-up Percentage, Gross Margin Percentage, and Selling Price Margin which is the sales formulas for businesses.
    change “covers” to “cover”
    change “which is” to “which are”
    I’ll also explain certain of the terminology…
    change “certain” to “some”
    …some other academic worthwhile things…
    change “academic” to “academically”
    …terms and phrases and word…
    change “word” to “words”
    The revenue is what you make (income) from sales, discounts, rebates…
    change to “The revenue is what you make (income) from sales, minus discounts and rebates…”
    “Psychological pricing is one type of strategy that you can follow others are…”
    change to “Psychological pricing is one type of strategy that you can follow. Others are…”

  4. Hi,
    If we are using the last method
    Selling Price Margin
    If you have a margin requirement of 70% and need to apply this to your pricing:
    Selling Price = Total Cost ÷ (1 – Gross Margin)
    Selling Price = $1.40 ÷ (1 – .70)
    Selling Price = $1.40 ÷ $0.30
    Rounded Selling Price = $4.67
    Now using first method:
    Selling Price = Total Cost x (1 + Mark-Up Percent)
    Selling Price = $1.40 x (1 + 0.7)
    Selling Price = $1.40 x (1.7)
    Rounded Selling Price = $2.38
    If you want to use 100% margin, there is no possibility for last method l as it will make divider ZERO.
    What do you suggest? As it is better practice to use last method when there is probable customer need for discount, but it doesnt give appropriate result in the actual figure.

    • Hi Hamzavi,
      I’m confused you want to sell at 10,000% markup? Just use 99.99% margin? You’d sell your $ 1,40 cost item for $ 14,000.00….
      Or am I not getting your point?

  5. Hi,
    I have a pricing mark-up of 1.45 in place long time, Now I was asked to break it down and see the composition of this 1.45 mark-up like, does it include freight cost and associated cost (landed cost). Is there are formula or way to go about knowing the break ups.

    • Hi Jebson,
      There is a way, you are looking to take your total costs (fixed and variable costs) and coming up with a contribution margin per unit for each product (look up CVP Analysis) where each sale adds a particular amount of dollars towards covering your overheads and then pricing accordingly to allow for profit margin (variable cost-plus pricing).
      Hope that helps.

  6. I am new on this I would like to learn more about pricing especially in relation to tendering in the construction industry.

    • Hi Vusi,
      Pricing or calculating pricing is simple across all industries, the calculations are standardised.
      If you don’t have first hand expertise or adequate experience within a given industry where you are seeking to price a good or service, this is where you will make mistakes in calculating your costs and either make losses or out price yourself against competition.
      Contract in a specialist to do this for you, on the basis that they will be able to give you guidance for a fee.

  7. Hi Deon,
    Thanks for your explanation and calculation examples. They have made my life a lot easier.
    I am nowhere near an expert in Excel or formulas and am having trouble quoting when I get into a competitive situation. Known factor is Cost. I have Formulas to determine Selling Price which includes the Dist Compensation %, Dist Sales Rep Compensation (fixed amount). The fields I can change is our Margin %, the Dist Compensation %, and Dist Sales Rep Compensation.
    What I need to be able to do is enter a Final Selling Price and realize the reduction in the Dist Compensation %, our Margin %. The Dist Sales Rep Compensation is always a fixed amount.

    • Hi Phil,
      What you want to be able to change the Selling Price and have as inputs to this formula the
      Partner Margin % (Variable) + Dist Comp % (Variable) + Dist Sales Rep Comp % (Fixed)
      What are the constraints to the variables?

      • I’m not sure what you mean by “restraints” but the Partner Margin is only ever as high as 10% because that is all we offer. When I have to change the selling price down I would like a formula which balances our Margin and the Dist Comp Margin maybe at a 2/3’s/1/3’s ratio. Bear with me here because this is like a 3rd grader (me) trying to communicate with the Professor.

        • Thanks Philip,
          I think I’m getting a better picture,
          What is the fixed amount you pay the Sales Rep?
          What is the Variable amount you pay the Dist Comp?
          Partner Margin % (Variable) = 10% 2/3
          Dist Comp % (Variable) = ? 1/3
          Dist Sales Rep Comp % (Fixed) = ?

          • Cost A207
            Margin B207 = i.e. 30%
            Net Price C207 = A207÷(1−B207)
            Company Profit D207 = C207−A207
            Dist Comp E207 = i.e. 10%
            Dist Comp Amount F207 = $$$
            Selling Price G207 = C207+F207+E209
            E209 is the Sls Rep Comp and is always a fixed amount, i.e. $250, which will not vary.
            When I have to lower the selling price I would like to make it so there is a 2/3 reduction from the company and 1/3 from the Dist Comp.

          • This compensation scheme if my understanding is correct, would only work if the cost price of deal size triple digit or larger. Minimum viable deal size $833.00 because of the fixed sales rep comp.
            If Sales Rep Comp was changed to a percentage, something like 30% of the Selling Price margin then this slides all the way to $1 deals.
            Selling Price is Cost + 30%
            Fixed Costs:
            Sales Rep Comp = $250
            Variable Costs:
            Company Profit = (Selling Price -(Cost +Fixed Cost ))*66.66%
            Dist Comp Amount = (Selling Price -(Cost +Fixed Cost ))*33.33%

          • Pricing ranges from $125k to $500k+

  8. I was racking my brain over this formula for a while now.
    Thank you so much for this!

  9. How do you calculate cost price if you have the gross margin percentage and selling price?

    • Hi Claire,
      Gross Margin could also refer to the difference between revenue and cost of goods sold divided by revenue. I’m assuming however mean unit margin and margin percent.
      Let’s assume Margin is 15%
      Selling Price is $150
      Selling Price ($) * Margin (%) = Margin Amount ($)
      $150 * 0.15 = $22.50
      Margin Amount ($) – Selling Price ($) = Cost Price ($)
      $150 – 22.50 = $127.50
      Checking that another way around:
      (Unit margin ($) / Selling price per unit ($)) * 100 = Margin (%)
      ( 22.50 / $150 ) * 100 = 15%
      Hope that helps.

  10. Hi Deon: Can u help with a little more challenging formula? I want to sell an item for a specific $ amount Profit. I have fixed formulated costs and want to know how much to sell an item for to make that specific $ amount.
    Example: Buy an item for $4.00, want to make $10 on that transaction. My shipping will cost $2.77 and my selling fees will be 15% of the final purchase price (sale price + shipping). Can you figure out a formula to be able to plug in $ amount (profit wanted) and plug in cost of item, to figure out what I would need to sell that item for in order to make that specific $ amount wanted after costs and expenses?

    • Hi John,
      Happy to Help out,
      Just so that I understand your query properly,
      Selling Price = ( ( Cost + Shipping ) x 1.15 ) + $ 10
      Selling Price = ( ( $4.00 + 2.77 ) X 1.15 ) + $10
      Selling Price = ( $6.77 X 1.15 ) + $10
      Selling Price = ( $7.78 ) + $10
      Selling Price = $17.78

  11. Hi Deon: Looking for a challenging profit formula for a specific $ amount wanted?
    Have fixed selling costs along with plug in expenses. Example: Purchase an item for $4.00, want to make $10.00 net profit after fees, costs & shipping. Plug in: cost, net profit ($ amt wanted) and shipping costs. Fixed seller fees= 15% of final sale price + shipping cost. Can you create a formula for this type of scenario?
    Example Expanded:
    Cost = $4.00
    Shipping = $2.77
    Selling Fees = 15% of Total Sale Price plus shipping
    Net Profit Wanted = $10.00
    What would be the formula to achieve $10.00 net? Always looking to plug in different $ amounts for cost, shipping and net profit wanted but seller fees will always be fixed but off of final sale price + shipping.
    Is this doable?
    Thank you in advance for your consideration!

  12. Hi,
    Can you please show a calculation to find selling price where gross margin percentage is 200% & cost price as 50 usd?

    • Hi Vinaya,
      Gross Margin Percentage = ( sales price – cost ) / selling price
      To make it easy, work out how to automate it in your spreadsheet of choice, and you can work out the price point you need to hit at 200% Gross Margin Percentage.
      In this case, it looks like this 200% = ( $150 – $50 ) / $50

  13. Hello Deon,
    Perhaps you can assist with converting markup to margin without knowing any other factors.
    A video I watched said:

    Margin = Markup
    ____________ (Divided by)
    (1 + Markup)

    I just can’t seem to make sense of it though.
    I am trying to convert our current Markup Percent records to Margin. I understand and know the formulas to get each from having the sell and cost. But the records only have the Markup percent. It would be a struggle to inquire for each customer/product to get both the sell and cost do convert them manually.

    Any assistance would be greatly appreciated.

    • Hi Jeffery,

      Interesting question, ideally you should costs and selling prices in records.

      Your formula is correct, it’s the one used to convert markup into margin. You should be able to get what you need from it if you only know the margin percentage.

      What can’t you make sense of on the formula? You plug in the values and solve for markup?

      The problem you will have with relying on a single point of failure and no verification to this data is that if there was any error at any time you are just carrying that error forward now blindly.

  14. Hello again Deon,
    I think I might have it 🙂


    This should be a straight conversion not needing anything but the Markup percent.
    This formula should convert a 20% Markup to a 16.6667% Margin which would still keep the same gross profit dollar.

Submit a comment

Your email address will not be published. Required fields are marked *