26 Nisan 2011 Salı

loan interest formula

I am mourning. "Do not make me go all calculations, formulas Lady! "Tienes load of money here, there is an Excel workbook. (Forms EC none is known to heaven by the archangel of the United Nations. really not difficult to obtain derivatives of the children, then I want his son to see this page.)




       payments, please contact the appropriate child outcomes, including relevant, it would be kind of at the end of each semester, do not, son. Service names are easy enough, but the next to explain the variables deben

(1) Loan balance after n payments have been made derivation



(For a savings account or other investment, just change the first minus sign to a plus.)

(2) Payment amount on a loan derivation


(3) Number of payments on a loan derivation


(4) Original loan amount derivation


(The original loan amount is also called the present value of an annuity or present value of a stream of payments.)

(5) Payment amount to reach an investment goal derivation


(6) Number of payments to reach an investment goal derivation


(7) Interest rate derivation

where
But this problem is normally solved by iterative methods