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