Here's the information of the repayment schedule I received from the bank:
Interest Rate P.A.: 3.25
Instalment Effective Date: 1 Jan 2007
Each Instalment Amount: 4,712.10
Final Instalment Date: 1 Jan 2017
Number of Outstanding Instalments: 121
Final Instalment: 4709.26
Schedule Outstanding Balance on 4 Dec 2006: 485,604.50
Below is the repayment schedule of the next 48 instalment:
Date Due: 1 Jan 2007
Inst. No.: 120
Interest: 1,315.17
Principal: 3,396.93
Outstanding Balance: 482,207.57
I'd like to know the algebraic formula --and the necessary steps -- used to calculate the fixed monthly payment and loan balance. My objective is to
work out a mortgage table just in case the interest rate varies.
I shall appreciate your help.
peter