![]() |
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. |
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. |
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