ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   margin formula (https://www.excelbanter.com/excel-discussion-misc-queries/205550-margin-formula.html)

baseballguy

margin formula
 
I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also like
to come up with a price if I only hve cost and desired margin all with in the
same formula.

Can you help me.



Sean Timmons

margin formula
 
Well, margin is purely % difference from cost to price, so...

for price =cost*1+margin where margin is an actual % .2,.5, etc.

margin would be =(price-cost)*cost

So, if price is $1, cost is $.50, margin would be 100%

Make sense? Or are you going for somethign else?

"baseballguy" wrote:

I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also like
to come up with a price if I only hve cost and desired margin all with in the
same formula.

Can you help me.



Fred Smith[_4_]

margin formula
 
Margin = Profit / Price
or, Margin = (Price - Cost) / Price

Markup = Profit / Cost
or, Margin = (Price - Cost) / Price

Margin shows what percentage of the Price is Profit. So a 30% margin means
that 30% of the price is profit. For example, selling price = $100, cost =
$70

Markup shows how much you are increasing the cost by to get the selling
price. A 30% markup on a $70 item gives a price of $91.

If the price is $1.00, and the cost is $0.50, the margin is 50% and the
markup is 100%.

Regards,
Fred


"Sean Timmons" wrote in message
...
Well, margin is purely % difference from cost to price, so...

for price =cost*1+margin where margin is an actual % .2,.5, etc.

margin would be =(price-cost)*cost

So, if price is $1, cost is $.50, margin would be 100%

Make sense? Or are you going for somethign else?

"baseballguy" wrote:

I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also
like
to come up with a price if I only hve cost and desired margin all with in
the
same formula.

Can you help me.





All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com