Calculation annuity and amortization schedule

Proportional or simple method

Proportional interest expense is ordinary. If we have an annual rate of 10% (10% of which are realized in 365 days), implies that it is in a single day 1/365 of the 10%, 10 days 10/365 10% ..., that is proportional to share.


Conformal or compound method.

In the conformal mode, the previously accrued interest is included in the basis for calculation, so the interest is increasing over the period. This method is also called interest rate method. Loans with conformal mode of calculation are slightly cheaper.


Amortization schedule

Amortization schedule shows us how to move our debt. You can prepare it with annuity payment calculator. Since at the beginning of the period of our long high, at the beginning of pay much interest. These are both of reduced down also reduced. It should be noted that when the pay back half of the meal, we have not yet paid off half the debt. What is the balance of the liability can be determined by an amortization schedule.


For both the calculation formula are quite complex. Let's meet for the first proportional manner. I copied this formula with Excel so that it will be useful to you as well.

= D6*((((1+(E6/(1200/E8)))^F6)*((1+(E6/(1200/E8)))-1))/(((1+(E6/(1200/E8)))^F6)-1))

And a formula similar way:

=D6*(1/((((1+(100*(((1+E6/100)^(E8/12))-1))/100)^F6)-1)/(((1+(100*(((1+E6/100)^(E8/12))-1))/100)^F6)*((1+(100*(((1+E6/100)^(E8/12))-1))/100)-1))))

Description of the contents of cells:

D6 - the principal loan

E6 - the annual interest rate

F6 - the number of installments

E8 - how much is the monthly annuity


 
Make a Free Website with Yola.