Remember the LORD for it is he who gives you the ability to produce wealth and so confirms his covenant... Deut. 8:18

Monday, May 3, 2010

Repayment of Amortized Loan

Here's an amortization calculator formula for deriving the amount of monthly repayment taken against a loan/ mortgage.

A = P { i + i / [(( 1 + i ) pw. n) - 1]}

Where: A = periodic payment amount, P = principal amount, i = periodic decimal interest rate ( not percentage), pw. = to the power, n = total number of periodic payments.

eg. P = RM400000, i = 3.6% per annum ( 0.036 pa or 0.003 pm), n = 20 years ( 240 mths).
A= 400,000 {0.003 + 0.003 /[ ((1 + 0.003) pw. 240) - 1]} = 400,000 {0.003 + 0.003/[2.05222- 1]} = 2340.44
So annual repayment = RM2,340.44 x 240 months for RM400,000 loan at 3.6% mortgage rate

No comments: