crwilson84
New Member
- Joined
- Oct 29, 2013
- Messages
- 11
Hi,
I'm looking for help regarding the file below which I use for calculating our profit margins when selling on marketplaces Amazon and Ebay.
At the moment, with the sample products i've given in the file, I can calculate a profit margin based on manual input of Ebay and Amazon selling prices. However, i'd like to know if it would be possible to set the profit margin to eg. 20% and work backwards from there; have excel calculate what my selling price should be to make the 20%?
The difficulty lies in the variables. The Amazon or Ebay (+PayPal) fees are a percentage of your final selling fee (eg. Amazon take £3.00, 15%, of an item selling at £20.00). Therefore you only know the Amazon fee after the selling price is present.
Please have a look at the following excel file: http://www.craigmarloch.co.uk/craig/SAMPLE-Profit-Calculator.xls
Any help would be most appreciated, thanks.
Craig.
EDIT: Forgot to point out, you can unhide columns I to R within the excel file to see all the costs i'm calculating.
I'm looking for help regarding the file below which I use for calculating our profit margins when selling on marketplaces Amazon and Ebay.
At the moment, with the sample products i've given in the file, I can calculate a profit margin based on manual input of Ebay and Amazon selling prices. However, i'd like to know if it would be possible to set the profit margin to eg. 20% and work backwards from there; have excel calculate what my selling price should be to make the 20%?
The difficulty lies in the variables. The Amazon or Ebay (+PayPal) fees are a percentage of your final selling fee (eg. Amazon take £3.00, 15%, of an item selling at £20.00). Therefore you only know the Amazon fee after the selling price is present.
Please have a look at the following excel file: http://www.craigmarloch.co.uk/craig/SAMPLE-Profit-Calculator.xls
Any help would be most appreciated, thanks.
Craig.
EDIT: Forgot to point out, you can unhide columns I to R within the excel file to see all the costs i'm calculating.
Last edited: