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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top