Is it 100/15 times original cost?
This is a discussion on Calculating Sale price from cost and Margin within the Excel Questions forums, part of the Question Forums category; Hi all, I need to calculate some sale prices based on original cost 24.9 and margin 85%. I know this ...
Hi all,
I need to calculate some sale prices based on original cost 24.9 and margin 85%. I know this is really simple but i am having a monday mental block
Is it 100/15 times original cost?
Thank you this seems to be correct
Formula is Cost/(1-Pecent Margin).
In your example, 24.9/(1-.85) will give you a selling price of 166.
=D11*(1+F11)
D11 = Cost Price
F11 = %
This is the correct answer above:
Formula is:
Sell Price = Cost / (1- Margin %).
In your example, 24.9/(1-.85) will give you a selling price of 166.
Here is the excel function: =A2/(1-B2) where A2=cost and B2=margin% (in decimal form)
(isn't that a high margin Mr. T? you're lucky to be able to do that)
100/15 * cost is the same as 24.9 * 100/(100-85) which works but is complicated.
Sell Price = Cost * (1+ Margin %) does not work.
Like this thread? Share it with others