excel pricing template

  • Thread starter Thread starter Clint
  • Start date Start date
C

Clint

I would like to set up or obtain a excel template or function to work out
sell price as in cost plus 17% gross profit etc
 
I would like to set up a template where i can enter a cost price and enter a
gp% to get a sell price
 
Hi Martin,
This adds on or marks up 17%, what i am after is the sell price if i wanted
17% GP margin?
Clint
 
Hi Clint,

Try this,
With your cost price in A1
Your GP margin in B1
Put this in C1 =A1/(100-B1)*100

This assumes that your input in B1 is a whole number,
if it is a percentage then take out the zeroes like this
=A1/(1-B1)

HTH
Martin
 
That's it!
cheers Martin
Clint

MartinW said:
Hi Clint,

Try this,
With your cost price in A1
Your GP margin in B1
Put this in C1 =A1/(100-B1)*100

This assumes that your input in B1 is a whole number,
if it is a percentage then take out the zeroes like this
=A1/(1-B1)

HTH
Martin
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL TEMPLATE THAT CALCULATES PRODUCT PRICES 1
GP Formula Needed 5
Calculate Margins 3
Help with formulae 3
How do i set up a cost - plus pricing method template on excel? 1
how to work out gross profit on items 1
excel formula for markup and profit margin 3
looking for a price book template 1

Back
Top