Calculate eBay BIN price

[MarkKiss]

Is possible count by formulas eBay Buy It Now price ?

My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90

Where is PayPal 3.4% + 20p
Ebay 40p listing
Ebay 10% Fee
Postage £0.9

I need formula where I

set my cost price + my profit 40-50% and formula count for me BIN price to get this Profit include shipping ebay and paypal fees

Thank you for help

 

[njimack]

Like this?

Excel Workbook
	A	B	C
1	Cost		10.00
2	Paypal %	3.4%	0.34
3	Paypal fixed fee		0.20
4	Ebay listing		0.40
5	Ebay fee	10.0%	1.00
6	Postage		0.90
7	Total Cost		12.84
8	Profit	40.0%	5.14
9	Sale Price		17.98
Sheet1

 

[MarkKiss]

No this and something like that I already try and all counting bad

From this I will get 17.98 what mean my profit is 40.7%

Lets said my cost price is 50 and I want 40% (20 profit) = selling price 82.56 by this formula I will get 81.80 and profit is £19.34 = profit 38.68%

I don't knot how to do it because ebay and paypal fees are count from final price, but I don't know final price I want count it.

 

[joeu2004]

My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90
[....]
PayPal 3.4% + 20p
Ebay 40p listing
Ebay 10% Fee
Postage £0.9

I need formula where I set my cost price + my profit 40-50% and formula count for me BIN price to get this Profit include shipping ebay and paypal fees

IMHO, you are wise to calculate profit based only your cost of goods, not including cost of services (EBay, PayPal, shipping).

The formula you seek is:

=ROUND((B1*(1+B2) + B4 + B6 + B7) / (1-B3-B5), 2)

where:

[TABLE="class: grid, width: 175"]
<tbody>[TR]
[TD]
[/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Cost
[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Profit
[/TD]
[TD="align: right"]40.00%
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]EBay rate[/TD]
[TD="align: right"]10.00%[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]EBay fixed[/TD]
[TD="align: right"]0.40[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]PayPal rate[/TD]
[TD="align: right"]3.40%[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]PayPal fixed[/TD]
[TD="align: right"]0.20[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Shipping[/TD]
[TD="align: right"]0.90[/TD]
[/TR]
</tbody>[/TABLE]

[EDIT] I had meant to explain the derivation of the Excel formula.

The BIN formula is:

BIN = cost*(1+profitPct) + BIN*ebayRate + ebayFixed + BIN*paypalRate + paypalFixed + shipping

So:

BIN - BIN*ebayRate - BIN*paypalRate = cost*(1+profitPct) + ebayFixed + paypalFixed + shipping

BIN*(1-ebayRate-paypalRate) = cost*(1+profitPct) + ebayFixed + paypalFixed + shipping

BIN = (cost*(1+profitPct) + ebayFixed + paypalFixed + shipping) / (1-ebayRate-paypalRate)

Algebraically, that becomes

 

[MarkKiss]

=ROUND((B1*(1+B2) + B4 + B6 + B7) / (1-B3-B5), 2)

This will return 15.64 ? what is wrong ?

 

[MarkKiss]

=ROUND((B1*(1+B2) + B4 + B6 + B7) / (1-B3-B5), 2)

Great this is exactly what I looking for many many many Thanks

First time i put wrong input :D

I am very grateful