Calculate Sales price to achive orginal price required after fees

[etaf]

This maybe a maths Algebra question rather than excel - but i'm adding to excel

If i get changed a FEE of 13.22% plus a fixed price of 30p , i can work out the fee based on the sales price

Fee =((Sales price)*0.1322)+0.3 = FEES
so
Net Price = sales price - fee , is what i'm left with

now how do you calculated the sales price needed in order to achieve a net price required , since the fees increase when the sales price changes

so if i want to make £25 , what price must i sell the item at

you cant just add - sales price + fees together , as now the new fees are larger

Net Price = sales price - (((Sales price)*0.1322)+0.3)

must be algebra , but i cant see it , maybe to early in the morning

i want a Netprice of £25 , what do i need to sale at

Ebay Listing.xlsx
	A	B	C	D	E	F	G	H	I
1	ID	Name	Stock	Regular price	Fee	Price required to get back to regular price		Fees
2				$100.00	$13.52	$100.00
3				$200.00	$26.74	$200.00		Percent	13.22
4				$50.00	$6.91	$100.00		Fixed	$0.30
EBAY LIsting

Cell Formulas
Range	Formula
E2:E4	E2	=((D2)*0.1322)+0.3

 

[sxhall]

I think I've got it, but maybe not...

=SUM(SUM(SUM($H$5-$H$4)/$H$3)*100)

The above gives me a value in column D6 that results in me making $25.

 

[Snakehips]

@etaf
Because there is the dynamic relationship between Selling Price and Fee so, as a one-off, you will need to go to > Excel Preferences > Calculation and Tick the option for Iterative Calculation.
Then try like the below.

Book1
	A	B	C	D	E	F	G	H	I
1	ID	Name	Stock	Regular price	Fee	Price required to get back to regular price		Fees
2				100	15.58	115.58
3				200	30.81	230.81		Percent	13.22%
4				50	7.96	57.96		Fixed	0.3
5				25	4.15	29.15
6
7
Sheet1

Cell Formulas
Range	Formula
E2:E7	E2	=IF(D2="","",((F2)*I$3)+I$4)
F2:F7	F2	=IF(D2="","",D2+E2)

HTH

 

[kvsrinivasamurthy]

Try.
Saleprice=(Netprice+0.30)/(1-0.1322)

 

[Phuoc]

Try this:

Book1
	A	B	C	D	E	F	G	H	I
1	ID	Name	Stock	Regular price	Fee	Price required to get back to regular price		Fees
2				100	15.2796266	115.5796266
3				200	30.5135515	230.8135515		Percent	13.22%
4				50	7.66266421	57.96266421		Fixed	0.3
5				25	3.85418299	29.15418299
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=F2*$I$3
F2:F5	F2	=(D2+$I$4)/(1-$I$3)

 

[etaf]

thanks for all the answers

interesting that they all come back to 60P more then the net value , when calculating fee

 

[etaf]

thanks @sxhall
Sorry the £25 was just an example - not related to the spreadhseet
i wanted to for example if after fees etc , I want to have £25 for an item, how much do i sell the single item for .....

Sorry for confusion

 

[etaf]

as mentioned
60P difference

Ebay Listing.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	ID	Name	Stock	Regular price	Fee	Price required to get back to regular price		Fees		Reconcile	sales	fees
2				$100.00	15.27962664	115.5796266					115.579627	$100.60
3				$200.00	30.51355151	230.8135515		Percent	0.1322		230.813552	$200.60
4				$50.00	7.662664208	57.96266421		Fixed	0.3		57.9626642	$50.60
5				$25.00	3.854182991	29.15418299					29.154183	$25.60
6
Sheet2

Cell Formulas
Range	Formula
E2:E5	E2	=F2*$I$3
F2:F5	F2	=(D2+$I$4)/(1-$I$3)
K2:K5	K2	=F2
L2:L5	L2	=K2-((K2)*$I$3)+$I$4

 

[etaf]

@kvsrinivasamurthy​

Saleprice=(Netprice+0.30)/(1-0.1322)
not a problem i just take off the 60p
Saleprice=((Netprice+0.30)/(1-0.1322))-0.6
i roundup to nearest £5 any way
=ceiling(salesprice/5,1)*5

Thats seems to work without the need for turning off iteration - BUT still 60P out also

Ebay Listing.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	ID	Name	Stock	Regular price	Fee	Price required to get back to regular price		Fees		Reconcile	sales	fees		kvsrinivasamurthy
2				$100.00	15.27962664	115.5796266					115.579627	$100.60		$115.58	$100.60
3				$200.00	30.51355151	230.8135515		Percent	0.1322		230.813552	$200.60		$230.81	$200.60
4				$50.00	7.662664208	57.96266421		Fixed	0.3		57.9626642	$50.60		$57.96	$50.60
5				$25.00	3.854182991	29.15418299					29.154183	$25.60		$29.15	$25.60
Sheet2

Cell Formulas
Range	Formula
E2:E5	E2	=F2*$I$3
F2:F5	F2	=(D2+$I$4)/(1-$I$3)
K2:K5	K2	=F2
L2:L5,O2:O5	L2	=K2-((K2)*$I$3)+$I$4
N2:N5	N2	=(D2+$I$4)/(1-$I$3)