|Year||Opening Balance||Yearly Principal||Yearly Interest||Closing Balance|
The amortization calculator or loan amortization calculator is a handy tool that not only helps you to compute the payment of any amortized loan, but also gives you a detailed picture of the loan in question through its amortization schedule. The main strength of this calculator is its high functionality, that is, you can choose between different compounding frequencies (including continuous compounding), and payment frequencies You can even set an extra payment.
You can also study the loan amortization schedule on a monthly and yearly bases, and follow the progression of the balances of the loan in a dynamic amortization chart. If you read on, you can learn what the amortization definition is, as well as the amortization formula, with relevant details on this topic. For these reasons, if you would like to get familiar with the mechanism of loan amortization or would like to analyze a loan offer in different scenarios, this tool will be of excellent help.
If you are more interested in other types of repayment schedule, you may check out our loan repayment calculator, where you can choose balloon payment or an even principal repayment options as well. In case you would like to compare different loans, you may make good use of the APR calculator as well. If you are not short of money, you may like to have a look at the investment or savings calculators.
What is amortized loan? - the amortization definition
The repayment of most loans is realized by a series of even payments made on a regular basis. The popular term in finance to describe loans with such a repayment schedule is an amortized loan. Accordingly, we may phrase the amortization definition as "a loan paid off by equal periodic installments over a specified term". Typically, the details of the repayment schedule are summarized in the amortization schedule, which shows how the payment is divided between the interest (computed on the outstanding balance) and the principal. The amortization chart might also represent the unpaid balance at the end of each period. A few examples of loan amortization are automobile loans, home mortgage loans, student loans, and many business loans.
As in general the core concept that governs financial instruments is the time value of money, the loan amortization is similarly strongly connected to the present value and future value of money. More specifically, there is a concept called the present value of annuity that conforms the most to the loan amortization framework.
To see why, let's consider the following simple example. Suppose you borrow $1,000, which you need to repay in five equal parts due at the end of every year (the amortization term is five years with a yearly payment frequency). The lender charges you 12 percent interest, that is calculated on the outstanding balance at the beginning of each year (therefore, the compounding frequency is yearly).
The illustration below represents the timeline of this example, where PMT is the yearly payment or installment. To find PMT, we need to find a value such that the sum of their present values equals the loan amount: $1,000.
The solution of this equation involves complex mathematics (you may check out the IRR calculator for more on its background); so, it's easier to rely on our amortization calculator. After setting the parameters according to the above example, we get the result for the periodic payment, which is $277.41.
Loan amortization schedule - the amortization table
The specific feature of amortized loans is that each payment is the combination of two parts: the repayment of principal and the interest on the remaining principle . The amortization chart below, which appears in the calculator as well, represents the payment schedule of the previous example. As you can see, the interest payments are typically high in early periods and decrease over time, while the reverse is true for the principal payments. The lowering interest amount is matched by the increasing amount of principal so that the total loan payment remains the same over the loan term.
The large unpaid principal balance at the beginning of the loan term means that most of the total payment is interest, with a smaller portion of the principal being paid. Since the principal amount being paid off is comparably low at the beginning of the loan term, the unpaid balance of the loan decreases slowly. As the loan payoff proceeds, the unpaid balance declines, which gradually reduces the interest obligations, making more room for a higher principal repayment. Logically, the higher the weight of the principal part in the periodic payment, the higher the rate of decline in the unpaid balance.
It may be easier to understand this concept if it is displayed as a graph of the relevant balances, which is why this option is also displayed in the calculator.
An amortized loan is a form of credit where the loan is paid off with equal, consecutive payments over a specified period. An amortization schedule shows the structure of these consecutive payments: the interest paid, the principal repaid, and the unpaid balance at the end of each period, which must reach zero during the amortization term.
What is the amortization formula?
As you have now gained some insight into the logic behind the amortized loan structure, in this section you can learn two basic formulas employed in our amortization calculator:
- Monthly repayment formula
P = (A * i * (1 + i)t)) / ((1 + i)t - 1)
- Unpaid balance formula
B = A * ((1 + i)t) - P / i * ((1 + i)t - 1)
P- monthly payment amount
A- loan repayment amount
i- periodic interest rate
t- number of periods
B- unpaid balance
For more details and formulas, you may check BrownMath.com, where you can also check the precise derivation of the related equations.
Amortization calculator with extra payments
It is worth knowing that the amortization term doesn't necessarily equal to the original loan term; that is, you may pay off the principal faster than the time estimated with the periodic payments based on the initial amortization term. An obvious way to shorten the amortization term is to decrease the unpaid principal balance faster than set out in the original repayment plan. You may do so by a lump sum advance payment, or by increasing the periodic installments.
In this calculator, you can set an extra payment, which raises the regular payment amount. The power of such an extra payment is that its amount is directly allocated to the repayment of the loan amount. In this way, the principal balance decreases in an accelerating fashion, resulting in a shorter amortization term and a considerably lower total interest burden.
The beneficial effect of extra payments is especially profound when the initial loan term is relatively long, such as most mortgage loans. When you set the extra payment in this calculator, you can follow and compare the progress of new balances with the original plan on the dynamic chart, and the amortization schedule with extra payment.
Since the shorter repayment period with advance payments mean lower interest earnings to the banks, lenders often try to avert such action with additional fees or penalties. For this reason, it is always advisable to negotiate with the lender when altering the contractual payment amount.
The results of this calculator, due to rounding, should be considered as just a close approximation financially. For this reason, and also because of possible shortcomings, the calculator is created for instructional purposes only.