Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate interest rate
Message
From
23/02/2004 12:46:23
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
23/02/2004 12:05:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00879962
Message ID:
00879996
Views:
25
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.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Previous
Reply
Map
View

Click here to load this message in the networking platform