View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default calculate backwards from agreed upon purchase price to SP inc tax

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

"rookie" wrote:

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