I currently have an issue where i would like to find what % margin i am making from selling a product on ebay. I would like a column where i can type 20 which will then show me the price i need to sell at in another column to make a 20% margin. The issue comes when i add in the formula to calculate the % which ebay will take. Here are some example costs below

Unit price Ex VAT = £10

Shipping Ex VAT = £1

I would like to make 20% on the above calculations however, ebay will take 12.5% & £0.20 of the final value including VAT.

So when i calculate 10 + 1 = 11. 11 *1.2 = £13.2. This would usually give me 20%, however ebay now take 12.5% + £0.20 of the final value fee including vat so:

13.2*1.2 = £15.84.

(15.84 / 100 *12.5) +0.2 = £2.18

11 - 13.2 = £2.2

£2.18 - £2.2 = £0.02

As a result once the ebay fee is taken i would be left with £0.02 profit which is a margin of 0.0015%

I know this is tricky to understand but any help would be greatly appreciate,

Kind Regards Dan