Help Needed with Sales Formula

[noobus]

Hello,

New to the forum but needed some help putting together a formula if possible.

I want to be able to input a cost price with the end result giving me a sales price that guarantees a £1.00 profit. The cost price would be the only figure I have. The gross sales fee should include a 15% Fee and VAT of 20%.

E.g Sales price £14.05

Cost Price £8.13

VAT at 20 % £2.81

Fee 15% £2.11

Profit £1.00

Many thanks in advance.

 

[Fluff]

Cross posted Help with sales pricing formula

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.