| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate backwards from agreed upon purchase price to SP inc tax
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate backwards from agreed upon purchase price to SP inc
or more ...
=ROUND((A1/(1+D1))-(B1+C1),2) "Toppers" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula working backwards from finished price | Excel Discussion (Misc queries) | |||
| HOW DO CALCULATE STOCK PRICE | Excel Discussion (Misc queries) | |||
| Indices - Agreed Standards? | New Users to Excel | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| How do I calculate dates backwards from a project end date | Excel Worksheet Functions | |||
Linear Mode
