eBay + Paypal Fees formula

InfoH

Board Regular
Joined
Nov 1, 2011
Messages
60
Hi guys,

Having a bit of a brain fart today and cannot get my head around this..

I want to be able input a COST (what it costs me) into lets say A2
I then want to be given a PRICE of what I should sell it for..

Fee's that are incurred are: 9% eBay Fee + 20% on top of that for VAT (so 10.8% total eBay fee)
3.4% + 0.20 Paypal Fee's

For example..
I would input £5.50 into A2, it would then calculate a PRICE of £6.67 (£0.72 ebay fees, £0.42 paypal fee) leaving: £0.03 profit..

I would really like to specify how much % profit I'd like to make also..
so Input COST and PROFIT %, then it gives me PRICE that i'd need to list it at to make that profit

any help would be appreciated, thanks :)
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
You can get the price for given profit % based on below logic

Price = (1+(eBay Fee%*(1+VAT%))+Profit%)*Cost

Please note that Profit % is calculated based on (Profit / Cost) and not based on (Profit/cost including charges and VAT)

Thanks
Swapnil Shah
 
Upvote 0
Thanks,

Still not quite there though.. I populated that to the following:
=(1+(9%*(1+20%))+5%)*A1
A1 being: £5.50
that's coming out at: £6.37

This doesn't take into account the 3.4% + 0.20 paypal fee's
these fee's are on top of the final cost (but then so is the ebay final value fee)

I hope I'm being clear? conscious I'm confusing myself let alone you!
Hopefully someone who understands the ebay and pp fee's etc will be able to decipher what I mean! lol
 
Upvote 0
If I follow you correctly and take it step by step I get Net Cost of £6.48 ? Not even trying to round numbers there.
Code:
Cost    Ebay    VAT    PayPal%    PayPal£    Net
    9.00%    20.00%    3.40%    £0.20    
£5.50    £0.50    £0.10    £0.19    £0.20    £6.48
Swapnail's formula shows £6.49
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top