help with working out sell price after taking into account all variables

Question

need a formular creating which will calculate the sell price after taking into account the following variables. We wont know the sale price, so the caluclation needs to automatically calculate this for us.

Cost price of product

Card fee of sale price 3.9% +.20p + 20%

Vat @ 20%

Postage £40

Profit 18%

Answer 1

Mustafaa,

Full disclaimer: I know nothing about Pounds, Pence or VAT so please double check my understanding and math before you rely on these calculations.

Also, I think I interpreted correctly how the credit card fees were calculated, but I am not 100% sure. Please double check that my math matches how the fee is actually calculated.

The user would adjust the amount in B2 until B13 is as close to 18% as you would like.

The formulas are shown so you can recreate this sheet on your own.

If this answered your question, I would appreciate an Upvote. If I didn't successfully answer your question, please leave a detailed comment and let me know where my understanding of your question missed the mark and I will do my best to make corrections.

John