Re: profit margins & markups

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Nikos Yannacopoulos (nyannacoREMOVETHISBIT_at_in.gr)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 15:42:07 +0200

Lance,

The difference between the two is the basis. Markup is calculated on Cost,
Margin is calculated on Selling Price. Assuming you have Cost in A1 and
Selling Price in B1, the formulae would be:
Markup: =(B1-A1)/A1
Margin: =(B1-A1)/B1

HTH,
Nikos

"Lance" <Lance@discussions.microsoft.com> wrote in message
news:2357D18B-0DB8-4672-86BB-2A44BE20B5B6@microsoft.com...
> Hi there,
>
> I need to calculate profit margins as well as markups in Excel.
> Would anyone know the formulae for both?
>
> Thanks.

Relevant Pages

  • Re: Math Equation Help!
    ... spreadsheet to calculate Profit Margins vs. Markup. ... the percentage added to cost to arrive at a selling price, ... 20% of the item's cost to the cost. ... Lets say we want to reverse the above "Margin" ...
    (sci.logic)
  • Math Equation Help!
    ... spreadsheet to calculate Profit Margins vs. Markup. ... the percentage added to cost to arrive at a selling price, ... 20% of the item's cost to the cost. ... The actual margin on this item is less than 20% however. ...
    (sci.logic)
  • RE: how do i set up a profit margin formula
    ... In your example the margin is 50% not 40% the formula to use is ... other way is to simple deduct the cost from the Selling price divided by 100 ... ex -- cost divided by retail= markup, ...
    (microsoft.public.excel.misc)
  • Re: Math Equation Help!
    ... spreadsheet to calculate Profit Margins vs. Markup. ... the percentage added to cost to arrive at a selling price, ... 20% of the item's cost to the cost. ... The actual margin on this item is less than 20% however. ...
    (sci.logic)
  • Ising Formula
    ... Sometimes you will have a cost and selling price, and need to know what margin that results in. ... How can I put this formula in a spreadsheet to find the margin between the cost and selling price of an item? ...
    (microsoft.public.excel.programming)