profit margins & markups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I need to calculate profit margins as well as markups in Excel.
Would anyone know the formulae for both?

Thanks.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula for markup and profit margin 3
how do i set up a profit margin formula 4
Gross margin 4
gross profit margin formula 2
Calculating value across multiple worksheets 5
How do I use a calculated constant in multiple cells? 2
Excel Assistance with Fomula 0
How do I create 2 formulas that faily more eloquently? 2

Back
Top