# Calculate seller price in Excel

• I want to sell my product with 10 dollars profit. I know Amazon fee (12%). Cost of product from supplier is 5 dollars. So far so good. How can I simply calculate what price should I sell this product to profit 10 dollars? Or yet another question... How can I prepare an Excel sheet to calculate my selling price with a flexible profit cell so that I can put any price into it? Do you have any sample workbook? Thanks in advance.

Edit: Please consider that Fee price is being naturally changed when profit price changed!

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• Is this what you mean?

Yes, Roy That is exactly what I am looking for. Just one more question. How can I arrange my own profit? I mean, can we make a little tune up to this Excel Workbook in order to see whenever I can put my own profit manually into it?

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• Is this what you mean?

Hi again Roy, Thank you very much. I got it now. You already show the solution with the percentage. Thank you very much again.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• You can put the % rate profit in a separate column or if the same rate applies to all products then just in one cell. Then refer to formula to the cell(s)

I cannot thank you enough, Roy.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

• Formula is: Sell Price = Cost / (1- Margin %). In your example, 24.9/(1-. 85) will give you a selling price of 166.

• Formula is: Sell Price = Cost / (1- Margin %). In your example, 24.9/(1-. 85) will give you a selling price of 166.

Thank you Rareskyfive, this one is also what I was exactly looking for. You just made my day.

[SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
Sir Arthur C. Clarke
[/SIZE]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!