>>Hey All ;
>>Kinda stuck here..
>>Can anyone Help..
>>I'm looking for the calculationon how to determine the orignal purchase price og a vehicle.
>>
>>The givens are :
>>1) Term in months
>>2) Interest rate applied
>>3) Monthly payemnt Less Tax
>
>VFP has a built in future value function:
>
>FV(nPayment, nInterestRate, nPeriods)
I think you want to use PV()instead of FV. This will give the principal balance that was financed. Use that figure and then you can back out the down, taxes, etc. to get the selling price of the vehicle.