Google Sheets- Formula to Calc Sale Price when Fees are Based off Sale Price

[LBA]

Hi,

I'm trying to figure out how to build a formula in google sheets to calculate my sale price when there are selling fees applied to the sale price (and I want to calculate profit margin based on my costs AND selling fees).
I need a formula that will calculate my item price based on;
item cost (wholesale price+shipping)
selling fees (when selling on online channels such as amazon they take a % of every sale, this needs to be added to the cost)
profit margin (I'd like to do 20% profit on my costs- including the selling fees)

the algebraic formula is something like this
x= cost + (fee % * x) + .2(cost + (fee % * x))

if going with the example of
cost = 100
% fee= 10%
the formula would look like this
100+ .1x + .2(100+.1x)=x
or
100 + 20 + .1x + .02x = x


Do you know how I can simplify that so that I can put it into excel and drag down to apply to all my items?
Any help would be greatly appreciated!

 

[Rijnsent]

Like so? This is assuming the first row is headers, second row with data you can fill. The formulas you can drag down.

Whole sale price	Shipping	Item cost	selling fee	profit margin	selling price	selling fee amount	profit margin amount
100	10	=A2+B2 -> 110	15%	20%	=(C2/(1-D2)/(1-E2)) = 161.76	=F2*D2 = 24.26	=(F2-G2)*E2 = 27.5

 

[LBA]

thanks for your help!