Hello All,
I am trying to calculate the selling price of a product using an excel template.
I will try to explain first the template, but the cell I need automating would be H2 (Selling Price)
The first 3 red columns are expenses,
A: the price I pay for the product at the distributor
B: The fee I pay to the selling platform, which is 15% of the selling price
C: A fixed 21% tax I have to pay to the tax office based on the selling price
E: is the Profit % which should always be 10%
F: is the tax on the purchasing price A, which I can claim fully back from the tax office
H: is the manual field I type to calculate the selling price. I keep modifying this until E=10%
I tried myself but I get errors because of every time H change B also changes.
If I need to add a column or two, it's no problem, my ultimate goal is that I should only enter the buying price in A and H will need to be calculated automatically.
Any help would be much appreciated.
Regards
Nic
Bookmarks