calculate backwards from agreed upon purchase price to SP inc tax

R

rookie

I am trying to calculate from an agreed upon purchase price to the actual
sale price.

Assuming we agree on $16,500 Total Price (OTD)
less 2 fee's and sales tax to come up with the purchase price.

Thanks in advance for the help
 
T

Toppers

A1=OTD
B1=Fee1
C1=Fee2
D1=Purchase tax (%)

then assumming OTD=(Purchase Price (PP) + Fees)* (1+tax%) i.e tax is
applied to PP +Fees

then purchase price :

=(A1/(1+D1))-(B1+C1)

HTH
 
T

Toppers

or more ...

=ROUND((A1/(1+D1))-(B1+C1),2)


Toppers said:
A1=OTD
B1=Fee1
C1=Fee2
D1=Purchase tax (%)

then assumming OTD=(Purchase Price (PP) + Fees)* (1+tax%) i.e tax is
applied to PP +Fees

then purchase price :

=(A1/(1+D1))-(B1+C1)

HTH
Click to expand...
 
Top