Calculating margins with two tax values

[coxy1983]

Hello,

Does anyone have a fromula where i can calculate my exact product margin based on two vat percentages ?

example

i buy apples for 1.50
i sell them for 10.00

I sold 10 at 17.5% vat and i also sold 5 based on 20% vat

How do i calculate the bang on margin based on two vat (tax) values ?

This is hurting my head ! Please help !

Gareth

[arthurbr]

Hi and welcome to the board

Is the Ex VAT apiece price the same for both quantities sold?

[coxy1983]

yes same price, always sell them for 10. always buy them for 1.50

now we have a new tax rate 20.0 and previously had 17.5 and want to calculate my exact margins by using a formula.

[shg]

Please Login or Register  to view this content.

The formula in D2 is =B2*C2/(1+C2)

In E2, =B2-A2-D2