Margin/price markup as %

[andycannon]

Hi all,

I have a dilemma that I hope someone will be able to help me with.

I need to work out the % profit margin from two prices: a cost price and selling price. The other threads I found have just confused me.

I.e. 16.87 selling price (Ex VAT) and cost price 12.9, expressesed as a % profit. I have three colums:

Selling price ex VAT'
Cost price
Profit Margin (%)

Please can someone help?

Many thanks for any assistance.

Andy

[DonkeyOte]

Profit on Cost %

= Selling Price / Cost Price - 1

Profit on Return %

= (Selling Price - Cost Price) / Selling Price

[andycannon]

Hi Donkey, thanks for that. So to just check I have got this right...

I am going for:

=(D10/F10)-1

= (16.87 / 12.9) -1 = 0.30775 which if you put cells as percentage is 30.76%

Is that right?

[DonkeyOte]

[removed.....]

[DonkeyOte]

Most I think would probably opt for: =(D10-F10)/D10

[andycannon]

OK thanks for your help, I think I have got it now!