Amortization of a loan means dividing the it in such a way, that you make equal payments of the interest as well as principal amount of any pending loan. It is basically a monthly structure, following which the borrower pays back the amount along with interest to the lender. Learning how to amortize a loan will help you make more payments towards your principal amount to finish it off early so that you are liable to pay only interest amount later. It helps you in preparing an effective pay-back strategy which suits your financial position.Amortization Calculations
- Step 1
To begin with, convert the monthly installments you are paying in a decimal format. To do this, divide your monthly interest by 1200, and the mark the figure you arrive at as J. You will require this for further calculations, so note it down. Step 2
You will then have to calculate for how many months you want your amount to be amortized over. To do this, multiply 12 to the number of years the money is spread over (N). You will require this value for further calculations so note it down. Step 3
Now, you will need to figure out the denominator for your monthly payment amount. For this, add 1 to the value you got in the first step (J). Raise the (J +
1) figure to the negative N power (-N), and subtract it from 1. This is your denominator. Step 4
After the above step when you have your denominator, divide the value from Step 1 (J) by it. This whole thing needs to be multiplied with your principal amount (the initial amount). The quotient you arrive at is your monthly payment amount. Step 5
The monthly interest at present (H) can be calculated by multiplying the principal amount (P) with your monthly interest, which you have converted to decimals (J). Step 6
When you subtract the amount you got in the previous step (H) from your monthly payment amount (M), it will give you the amount you will pay each month towards your principal amount (C). Step 7 The new balance of the principal can be obtained by reducing your monthly principal payment amount (C) from the principal amount (P).
Now, you will need to prepare the amortized schedule for making your payments. For this, you will have to equalize the new balance of the principal amount (Q), to the initial principal amount (P). Then follow steps 5, 6, and 7 again and again till you get the value as 0 (zero).
The steps mentioned above can be easily represented in the way of a mathematical formula. This formula is given below: