Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculate interest rate
Message
De
23/02/2004 12:46:23
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
 
 
À
23/02/2004 12:05:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00879962
Message ID:
00879996
Vues:
23
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform