0
What is the Excel formula for the selling price if you have cost and margin?
Wiki User
∙ 9y ago
The selling price is the cost plus the margin. If you know the margin as a fixed value and the cost was in cell A2 and the margin in B2, in C2 you could put the following formulas:
=A2+B2
If the margin is a percentage of the cost and the margin is in B2, then the formula would be:
=A2+A2*B2
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
If I know the selling price and the margin I want to achieve what formula is used to calculate the price I need to buy the goods at?
Margin = (Selling Price - Cost) / Selling Price
Work out margin when you know the desired selling price and cost?
Margin = Selling Price - Cost
What is the Formula of mark up rate?
Margin = (1-[cost/selling price]) x 100
How do you calculate Direct Margin as a percentage?
(selling price - direct cost)/selling price = direct margin
What is the formula for profit margin?
Selling Price=Cost Price/((100-margin%)/100) e.g Cost = £100 Profit Margin needed is 40% Sell price=100/0.60 Sell Price = £166.67 So you make £66.67 when you sell it at £166.67 so the profit margin is 66.67/166.67 = 40%
Does profit enter into price?
Yes sales price already accounted for the percentage of profit as formula for selling price as follows: Sales price = Total Cost + Profit margin
How do you calculate the selling price if you know the cost price and margin percentage?
Convert the margin percentage increase (decrease) to the absolute increase (decrease). Add (subtract) to (from) the selling price.
What is the difference between a mark up and a margin?
A markup is what percentage of the cost price you add on to arrive at the selling price. Margin, on the other hand, is the percentage of the final selling price that is profit.
What is the gross margin percentage for a basketball if a store buys it for 2.50 and the retail price is marked 10.00 And the selling price is 7.50?
Gross Profit/Selling Price = Gross Margin (7.50 - 2.50)/7.50 = 66.6%
I was told that you should divide the cost of an item by .75 for a 25 perc. margin. However this result is different from a 25 markup. What is the difference between a percentage markup and a margin?
Margin is the percentage of profit based on sales price while mark-up is the percentage gain based on cost. A 25% mark-up results in a 20% margin. For example, an item costs $80. You mark it up 25% (80 x 1.25) and you selling price is $100. A profit of $20 is 20% of $100 so you have a 20% margin. Similarly, a 50% mark-up will result in a 33% margin. To calculate the selling price at a given margin, you have the correct formula. You divide the cost by 1 minus the margin percentage. So, if you want a 25% margin, your cost will be 75% of the selling price. So you take cost divided by .75 to arrive at the price. If you want a 30% margin, divide your cost by .7 which is (1 - .3).
What is the formula for cost price?
loss+selling price (S.P)
Formula of net profit in Excel?
The formula of net profit in MS Excel is:- =net profit(cost price+sell price/100*200*2)
