When I can't remember the formula for something, I go to Excel and look it up. Once you see how it's done there, you can usually convert it to FoxPro.
Monthly Interest=Annual Interest divided by 12 times the loan balance before the payment
Monthly Principle amount=Payment minus Monthly Interest
Dale S.
>I have an application that now needs to work with various financial information and perform some calculations... such as, I know the principal amount, interest rate, number of payments and the amount of each payment... how do I calculate the interest charged as each payment is applied and thus find the amount to reduce the principal on an ongoing basis till the loan is complete... is there an fll/dll available or sample code available somewhere... thanx
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement