Loan Payment Calculator
Table of contents
How can the loan payment calculator be useful to you?The loan payment formulaHow to calculate monthly payment on a loanHow to calculate loan amount from the paymentsLoan payment schedule - Amortization tableThe loan payment calculator is a handy tool to compute the required monthly (or any other frequency) payments after taking a loan requiring equal payments. For example, you can estimate your car payment or mortgage installments. We also introduce the loan payment formula and present a practical guide that helps you to understand how to calculate the monthly payments on a loan.
Besides, you can read about what is a loan payment schedule so you can see in detail how loan payments are constructed.
If you are shopping around for loans, you may check our loan comparison calculator, which can give you excellent support in choosing the most favorable option. Or, if you are considering suspending your repayment, you may apply our deferred payment calculator to see how loan deferment would affect your costs and schedule.
How can the loan payment calculator be useful to you?
When you are planning a purchase, but you realize that you cannot afford it from your savings or income (alternatively, you are about to take an investment decision requiring financial support), the most straightforward way to obtain the necessary money is to turn to a bank for a loan. If you are in such a situation, probably one of the first things that comes to your mind is whether you will be able to make the required payments (or installments) from your income. To solve this puzzle, you must answer the crucial question: what will my loan payment be?
With our loan payment calculator, you can quickly compute the amount of money you need to devote for loan repayment over a payment period. This device will also give you the total amount you need to pay back during the whole loan term. Alternatively, you can use it to compute the loan amount from the loan payments.
The loan payment formula
Before we go any further, it is essential to discuss a few specific terms you may encounter when you are considering taking a loan. In the following, you can get familiar with these phrases so you will have more of an understanding of the concept of loans.
-
Loan amount: this is the amount of money (also known as the principal) that a bank (or any other financial institution) lends or, conversely, that an individual borrows. In other words, this is the amount that the borrower agrees to pay the lender when the loan becomes due, not including interest. If you would like to learn more about calculating interest, visit our simple interest calculator.
-
Annual rate: this is the interest rate (also called nominal rate or quoted rate) that is quoted by banks (or other parties). It is also important to take into account the expected inflation rate when you inspect a quoted rate: the higher the inflation rate, the lower the real interest rate; thus, the real burden generated by the interest rate lessens. To learn more about inflation, visit our inflation calculator.
-
Payment term: in our context, refers to the time frame the loan will last if you only make the required minimum payments each month. For example, a 20-year fixed-rate mortgage has a term of 20 years mortgage calculator. Auto loans often have 5 or 6-year terms.
-
Payment period: it refers to the specific period over which the borrower is obliged to make the loan payments.
-
Periodic rate: this is the interest rate charged by a lender or paid by a borrower in each payment period. It can be annual (in this case, it equals the annual rate), semiannual, per quarter, per month, per day, or per any other time interval. For example, a bank might charge 2% per month on its credit card loans, or it might charge 1% quarterly on loans. To get the periodic interest rate, you need to divide the annual rate by the number of payments in a year. For example, in the case of a monthly payment with a 6% annual rate, the periodic interest rate is equal to
6% / 12 = 0.5%
. -
Loan payment: this is the amount of money which is required to be repaid by the borrower for every payment period. In most cases the borrowed money is refunded in loan payments (installments) in equal amounts through the payment term. This kind of loan construction is called an amortized loan.
-
Loan payment schedule/Amortization schedule: each loan payment consists of two parts: part interest and part of the repayment of the principal. The share of interest is higher at the beginning of the loan term, but it declines as the loan balance decreases. In other words, the more loan has been paid back, the higher the share of the principal in an installment.
After taking a quick journey through financial terminology, we can construct the loan payment formula applied in our loan calculator.
Periodic loan payment = Loan amount / (((1 + Periodic rate) ^ Number of payments) - 1) / (Periodic rate × ((1 + Periodic rate) ^ Number of payments))
.
It is important to note that the loan payment formula above is based on amortized loan construction with equal payments where the interest amounts are computed after the unpaid principal. The other type of loan construction is based on compound interest, where the interest amounts are added to the principal balance after every specific period corresponding to the compound frequency.
How to calculate monthly payment on a loan
Now, as you get familiar with the financial jargon used in loan constructions and with the loan payment formula, let's see how to calculate loan payments through a simple example. Let's assume you are about to buy a new car, and your savings are not enough to pay the full price. To obtain the missing amount, you decide to turn to a bank that offers you a personal loan of 10,000 dollars with 6% interest, repaid monthly in 5 years. You can easily insert this data into our calculator:
- Loan amount: $10,000
- Annual rate: 6%
- Number of years: 5
- Frequency: monthly (Number of payments in a year = 12)
Periodic rate = Annual rate / Number of payments in a year = 0.06 / 12 = 0.005 = 0.5%
.
Number of payments = Number of years × Number of payments in a year = 5 × 12 = 60
.
We can employ the previously stated loan payment formula using the above values.
Periodic loan payment = Loan amount / (((1 + Periodic rate) ^ Number of payments) - 1) / (Periodic rate × ((1 + Periodic rate) ^ Number of payments)) = 10,000 / (((1 + 0.005) ^ 60) - 1) / (0.005 × ((1 + 0.005) ^ 60)) = $193.33
After computing the periodic loan payment, you can have a much better view of your future obligations that help you to decide whether you can handle the repayment of the loan.
How to calculate loan amount from the payments
Additionally, you can use our loan calculator to compute the loan amount or total loan payment from the periodic installments.
Let's presume that your monthly loan payment is 100 dollars with a 9 percent annual rate with two years payment term.
- Periodic loan payment: $500
- Annual rate: 9%
- Number of years: 2
- Frequency: monthly
Periodic rate = Annual rate / Number of payments in a year = 0.09 / 12 = 0.0075 = 0.75%
.
Number of payments = Number of years × Number of payments in a year = 2 × 12 = 24
.
Loan amount = Periodic loan payment × (((1 + Periodic rate) ^ Number of payments) - 1) / (Periodic rate × ((1 + Periodic rate) ^ Number of payments)) = 500 × (((1 + 0.0075) ^ 24) - 1) / (0.0075 × ((1 + 0.0075) ^ 24)) = $10,944.5
.
Total loan payment = Number of payment × Periodic loan payment = 24 × 500 = $12,000
.
Loan payment schedule - Amortization table
As we discussed, most loans are repaid in equal payments (installments) over a specific time: loans constructed like this are called amortized loans. Each periodic payment consists of an altering proportion of interest and principal where the interest payment is decreasing and the principal payment increases over the payment term. The decreasing trend in the interest portion corresponds to the reduction in the loan's unpaid balance (opening balance). The loan payment schedules (or amortization schedule) represents a detailed table of the periodic loan payments, displaying the amount of principal and the amount of interest that constitutes each payment until the loan is paid off at the end of its term.
The best way to have a better insight into this subject is to take a practical example. The below table represents a loan payment schedule for a 500,000 dollars 20-year mortgage loan repaid yearly with an annual rate of 5 percent. In this case, the yearly loan payment is 40,121.29 dollars.
Payment Period | Opening balance | ||||
---|---|---|---|---|---|
(1) | Periodic payment | ||||
(2) | Interest | ||||
(3) | Repayment of Principal | ||||
(4) = (2) - (3) | Ending Balance | ||||
(5) = (1) - (4) | |||||
1 | $500,000 | $40,121 | $25,000 | $15,121 | $484,879 |
2 | $484,879 | $40,121 | $24,244 | $15,877 | $469,001 |
3 | $469,001 | $40,121 | $23,450 | $16,671 | $452,330 |
4 | $452,330 | $40,121 | $22,617 | $17,505 | $434,825 |
5 | $434,825 | $40,121 | $21,741 | $18,380 | $416,445 |
6 | $416,445 | $40,121 | $20,822 | $19,299 | $397,146 |
7 | $397,146 | $40,121 | $19,857 | $20,264 | $376,882 |
8 | $376,882 | $40,121 | $18,844 | $21,277 | $355,605 |
9 | $355,605 | $40,121 | $17,780 | $22,341 | $333,264 |
10 | $333,264 | $40,121 | $16,663 | $23,458 | $309,806 |
11 | $309,806 | $40,121 | $15,490 | $24,631 | $285,175 |
12 | $285,175 | $40,121 | $14,259 | $25,863 | $259,313 |
13 | $259,313 | $40,121 | $12,966 | $27,156 | $232,157 |
14 | $232,157 | $40,121 | $11,608 | $28,513 | $203,643 |
15 | $203,643 | $40,121 | $10,182 | $29,939 | $173,704 |
16 | $173,704 | $40,121 | $8,685 | $31,436 | $142,268 |
17 | $142,268 | $40,121 | $7,113 | $33,008 | $109,260 |
18 | $109,260 | $40,121 | $5,463 | $34,658 | $74,602 |
19 | $74,602 | $40,121 | $3,730 | $36,391 | $38,211 |
20 | $38,211 | $40,121 | $1,911 | $38,211 | $0 |
Hopefully, by noticing the trends in the below graph, you will have more understanding of what amortization is.
Each year's opening balance represents the unpaid balance (the amount of the loan to be paid). As the interest payments are relatively high at the beginning of the loan term, the part of the principal is small during the early periods; thus, the unpaid balance decreases slowly. However, as the opening balances decline, the interest payments gradually lessen as well, resulting in a growing portion of principal repayments. The larger principals, in turn, increase the rate of reduction in each period's opening balance.