Thanks Chuck. Been a while since I resolved a problem that complex. I'll see what I can do.
>>I'm doing a data conversion, and I need to determine the interest rate on each customer's account. The source data does not provide this, but it does provide amount financed, number of payments, the monthly payment, and the total interest expected. Assuming the same rules as VFP's Payment() function, is there any easy way to determine the interest rate from this information?
>>
>>Thanks.
>
>From doing a search on Google this should be the math that Payment uses. I did a couple of checks and the two seems to match
>
>
>Payment = nPrincipal/12*((nInterestRate * 12)-(nInterestRate * 12)/(1-(1+nInterestRate)^nPayments))
>
>
>Now you would have to resolve the math problem until nInterestRate is on the left side. Good luck.