I am trying to setup a spreadsheet that will help me see what my selling price should be based off of my cost, markup percent, and gross margin percent. Here is what I have setup on my spreadsheet now:
Cell Reference:
A1, is my wholesale cost
B1, is my markup percent
C1, selling price (this cell should auto populate)
D1, gross margin in dollars (this cell should auto populate)
E1, gross margin in percent
Basically, I want my Selling Price (in cell C1) and my Gross Margin in Dollars (in cell D1) to dynamically change.
What I want to do is to be able to enter in my cost and enter in assumptions for either my Markup Percent or my Gross Margin Percent. If I enter in an assumption for Gross Margin Percent then I would like to automatically see what my Markup Percent would be and visa versa. By entering in these two pieces of information (my cost and either my Markup Percent or my Gross Margin Percent) I would like to see what my selling price should be and what my gross margin would be in dollars.
I found exactly what I am trying to do on the following web site but it does not show me the formulas so that I can do this on my excel spreadsheet. The web site is: (note, you will need Java to view this)
http://www.dinkytown.net/java/ProfitMargin.html
If there is anyone out there that would be willing to help me, it would be so much appreciated and I thank you in advance!
Andy
Cell Reference:
A1, is my wholesale cost
B1, is my markup percent
C1, selling price (this cell should auto populate)
D1, gross margin in dollars (this cell should auto populate)
E1, gross margin in percent
Basically, I want my Selling Price (in cell C1) and my Gross Margin in Dollars (in cell D1) to dynamically change.
What I want to do is to be able to enter in my cost and enter in assumptions for either my Markup Percent or my Gross Margin Percent. If I enter in an assumption for Gross Margin Percent then I would like to automatically see what my Markup Percent would be and visa versa. By entering in these two pieces of information (my cost and either my Markup Percent or my Gross Margin Percent) I would like to see what my selling price should be and what my gross margin would be in dollars.
I found exactly what I am trying to do on the following web site but it does not show me the formulas so that I can do this on my excel spreadsheet. The web site is: (note, you will need Java to view this)
http://www.dinkytown.net/java/ProfitMargin.html
If there is anyone out there that would be willing to help me, it would be so much appreciated and I thank you in advance!
Andy