Amortization Table Definition

Characteristics

An amortization tables work best for the following kind of loans.

  • The loan disbursement is done as a lump-sum-amount.The loan has to be repaid over a while in monthly installments.The installment that is paid each month is of equal amount, known as equated installment.The rate of interest that is being applied to the loan is fixed.

How does Amortization Table Work?

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Amortization Table (wallstreetmojo.com)

How to Calculate Interest on the Amortization Table?

The interest portion reflected in the amortization table is calculated by multiplying the outstanding opening principal by the monthly rate of interest. The monthly rate of interest can be calculated by dividing the yearly rate of interest by twelve. The outstanding principal is always mentioned in the amortization schedule. As the exceptional principal keeps on decreasing with each monthly repayment, the interest portion will also fall.

Example of the Amortization Table

The details of the loan as follows:

  • Loan Amount = $1,00,000Interest Rate = 12% P.A.Tenure = 24 MonthsLoan Date = 01.01.2019

The amortization for the above loans looks like below.

The amount of EMI payable per month is $4,614, and the tenure of the loan is 24 months.

What does the Amortization Table Show?

A table, as presented above, shows the following particulars.

  • Installment Number: It reflects the wise serial number of installments. The last installment number represents the tenure of the loan.Payment Date: It means the date on which the payments are due each month.Opening Balance: It reflects the opening balance of the outstanding principal of the loan.EMI: It means the fixed amount of payment that is to be done each month.Principal: In this column, the principal amount out of the EMI amount due is being reflected.Interest: This represents the interest portion out of the EMI amount due.Closing Balance: Closing balance means the closing balance of the principal amount of loanPrincipal Amount Of LoanLoan Principal Amount refers to the amount which is actually given as the loan from the lender of the money to its borrower and it is the amount on which the interest is charged by the lender of the money from the borrower for the use of its money.read more after the repayment of the current month.Cumulative Interest: It reflects the total amount of interest that has been incurred on loan at each installment level.

How to Use the Amortization Table?

This table is used to calculate certain factors such as the EMI amount and the total interest cost involved in forgiven loan amount at the given rate of interest for a fixed tenure. The table will provide exact details of the same, and the borrower can ascertain the effect of the same on his financials. The same is also helpful in keeping track of the upcoming loan repayments.

Amortization Table vs. Payment Schedule

The amortization table and payment schedule may sound similar terms; however, they differ.

The main difference is that the amortization table contains the breakup of the principal and interest portion, along with the same. However, a payment schedule will only reflect the total payment and not include the division of principal and interest amounts. Thus, while the amortization table is a detailed table of loan repayment, the payment schedule is as good as a calendar showing the due dates for the repayment of the loan at periodic intervals.

Conclusion

An amortization table is useful to the borrowers as well as the lenders. The same reflects the detailed data of the repayments of the loan, the interest involved, and the tenure of the said loan. It also works as a reminder for loan repayments, which is an added benefit.

This has been a guide to Amortization Table and its definition. Here we discuss characteristics, working, and use of amortization table and an example and its differences from payment schedule. You can learn more about financing from the following articles –

  • What is the Amortization of Bond Premium?Mortgage Amortization ScheduleDebt ConsolidationPrepayment Penalty MeaningPresent Value vs Future Value