Calculate more precisely
To obtain amortization payments ( as ) of a loan with constant principal repayments you have to calculate the principal or capital repayments ( As ) firstly, dividing the principal ( C0 ) by the number of periods:
Once calculated the principal or capital repayments ( As ), which are equal at all periods, you have to calculate the rate of interest of each year. You have to take into account the index rate ( irs ) of each year has to be adjusted by the margin or spread ( d ), with the exception of the first year interest rate, which is not subject to this type of adjustment. The adjustment is calculated on the basis of the following formula:
With the above formula you can obtain the nominal rate of interest of this period ( j(m) ) and you need the Effective rate of interest per time unit ( i(m) ), this is why you have to do the following conversion:
Once calculated the rate of interest of eacj period, yo have to calculate the amortization payments ( as ) of each perido, with the following formula:
The principal or capital repayments ( As ) have been calculated before and we know that they are equal at all periods, so you have to calculate the interest payments ( Is ) of each period with the following formula:
Once obtained the interest payments ( Is ) you only have to add up the principal or capital repayments ( As ) in each period in order to obtain the amortization payments ( as ).
|