Calculation of amortization plan for constant installment of a loan

Utility calculates the amortization of the installments of the online loans proceed to the calculation of the amortization plan for the constant installment of the French loan plus excel file xls

Calculation of loan amortization plan

Calculation of loan amortization plan

Always to stay on the subject of calculations this time it’s up to this beautiful utility that manages to make the calculation of a loan amortization plan with the fixed and constant installment online as well as the excel spreadsheet. In practice, loan amortization plans are developed on the basis of the usual French system or the amortization calculation mechanism universally used by Italian banking institutions to amortize the installments of any loan. The calculation of the French loan amortization plan we are talking about provides for interest to be reduced, that is to say as the installments expire, the interest falls in quantity, that is, the methodology that calculates the loan amortization plan essentially “spreads” the interest expense on all the installments that make up the loan. In this way, the installment is constant and fixed except for the intervention of a change in rates which affects the amortization plan as identified. More info on how to amortize c / o: French loan amortization plan calculation

Loan called for the French amortization plan

Loan called for the French amortization plan

At the end of the calculation of the loan amortization plan, a grid with many cells will be created in which the divisions of all the components forming a loan called for the French amortization plan will be evident to indicate that some values ​​have a decreasing trend others instead growing. Before the depreciation plan table, the items specified here and the macro data obtained from the online depreciation calculation plan will be summarized. A curiosity that those who calculate the amortization plans will notice is the clear disproportion between the share of interest compared to that of the capital during the beginning of the first installments. Unfortunately, this method of amortizing loans is typical of the calculation formula contained in the French method which strongly penalizes the initial repayment phase, in particular the longer periods (see calculation of loan amortization for loans up to 50 years).

New: We have made available the download of a sheet or calculation file of the amortization plan constant installment excel xls for free . The amortization of the installment with excel xls usable off-line on your PC is identical to that online of the underlying form as the mathematical formula applied is identical: in French. However, the potential for amortization in xls excel is to calculate various forms of annual installments , that is, in addition to the usual monthly installments, it is possible to make amortization with quarterly and half-yearly installments, etc. as there is still someone who wishes to proceed with the amortization of the six-monthly or quarterly installment . However, the half-yearly installment is very rare in loans but much more used in mortgages. In any case, the amortization of the installments in excel xls also allows the annual installment, that is, amortization with a constant annual installment.

Instructions for the excel xls file: you can change all the calculation data (rate, amount, date, duration, installments, etc.) in order to customize your amortization plan in xls excel .

 

Leave a Reply

Your email address will not be published. Required fields are marked *