Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Algorithm for PAYMENT function
Message
De
24/10/2001 16:53:34
Charles Richard
Nvo Management Systems
Boisbriand, Québec, Canada
 
 
À
24/10/2001 16:06:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00572876
Message ID:
00572908
Vues:
23
Claude: The payment should be 160.70 (you divide the interest by 12, not 24 as the rate is based on annual calculation, not the duration of the loan.)

Here is the algorithm:
inv = 3500.00
i = .095/12
n = 24
pmt = ROUND(inv /((1-((1+i)^-n))/i), 2)
HTH

>We have an old FoxPro for Dos program that uses the Payment function, The original Developers are long gone. The user would to know how the calculation is done. Syntax is
>
> payment = PAYMENT(loanamount,interest/payment, numberofpayments)
>
>For example if loanamount is 3500, interest is 9.5, and number of payments of payments is 24 then interest is .095/24 and payment is 153.16.
>
>Home is this caluclated?
>
>Any help appreciated.
Charles Richard
NVO Management Systems
crichard@nvo.ca
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform