View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SeeStation SeeStation is offline
external usenet poster
 
Posts: 10
Default Calculate Margins

I need to calculate gross margins and prices at different levels of GM:

Non-Excel Formula to calculate Selling price using gross margin
Selling Price = Cost / (1-GM%)

For example, if your product costs $100 and the required gross margin is
40%, then your Selling Price = $100/(1-0.4) = $100/0.6 = $166.6


So in my worksheet E16=cost E17=Current Selling Price
I want to put my current GM in F17,
I want to get a selling price for GM at:
15% in G16
20% in H16
25% in I16
30% in J16
35% in K16

Any ideas?