Formula to Calculate Margin

January 6, 2014

Just because I see this so often in spreadsheets:

Costs * 1.Margin = Resale

The proper way to apply a margin to your cost is:

Cost / ( 1 - Margin) = Resale

It makes a big difference on the final number:

100 * 1.3 = 130100 / ( 1 - .3) = 142.86

If you do it the first way at some point you are going to be wondering why you are short 7%.

Transform your business without wasting money.

We help you identify, audit and implement technology changes within your business to create leverage points to scale your company faster.