The amortization table, in the case of a private loan, is a very useful document that summarizes on one page the information related to the repayment of the credit: amounts to be paid, dates, etc. But how to read this table and what is it for? Here are some explanations.
What is an amortization table?
It is a document that summarizes the set of payments to be made to settle a private credit. Each line corresponds to a date on which the debtor will have to make a payment. Furthermore, the above table will include for example 12 lines (12 months) in the case of a loan repaid in 1 year, and 60 lines (60 months) in the case of a loan repaid in 5 years.
What are the elements indicated?
Each row of the document is divided into several columns based on the information you want to appear. In general, an amortization table includes at least, on each line:
- The number of monthly installments, or the date of payments: indicates which installment the line refers to. The first line corresponds to the date of the first payment to be made, the last one to the date of the end of the payment.
- The monthly installment: it is simply the invoice amount to be paid.
- Amortization: this is the amount used to repay the loan.
- Interest: the interest paid monthly.
- The balance: the remaining amount to be paid to ensure that the loan is fully amortized.
Depreciation, interest, monthly installments
One of the fundamental elements to understand in an amortization table, is that every month paid by the debtor includes on the one hand the amortization and on the other the interest paid. If, on the other hand, the installment is fixed for the entire duration of the repayment, the parts that concern the amortization and the payment of the interest vary with time. For example in a credit of USD 10,000 in 12 months with a rate of 8.9%.
- The fixed installment is 872.45 USD / month.
- In the first month, the depreciation will be USD 801.16 and the interest paid will be USD 71.30. The invoice total therefore returns to USD 872.45.
- On the 6th month, the depreciation will be 824.25 USD, and the interest paid will be 48.21 USD. The total invoice therefore remains at 872.45 USD.
Generally speaking, the portion of interest paid by the borrower is more important at the beginning of the repayment than at the end.
Credit balance and early repayment
The balance to be paid corresponds to the total amount of the credit, of which we deduct the amortization already made. This is an amount “which remains to be repaid”. Knowing how much remains to be paid is particularly useful if the debtor decides to make an early repayment. At any time, the latter can in fact decide to “settle” his credit by paying all the invoices that remain to be paid. Interest paid in addition will be returned to him, except for any deductions for early repayment fees.
How to get your own amortization table?
In general, it is always possible to claim this document (or its equivalent) with the bank where the credit was requested. But be careful, because this service could sometimes be billed up to 200 USD per bank! At the conclusion of the contract, some intermediaries provide this amortization table, tailored to each client.