To use this tool, start by entering the initial amount, which is the amount of money you are going to borrow.
In the second box, enter the length of the loan, whether it is 1, 2, 10, or 20 years.
In the last box, indicate the annual rate that the lender will apply to the loan, then click “Calculate interest”, and the calculator will give you the result.
To calculate compound interest, select “Compound” under Interest type and fill in the 3 additional fields.
In this type of calculation, it is essential to fully understand the details of the loan in question, because they have a crucial influence on the result.
If you want to know more about what interest is, what types exist, and how it can be calculated, keep reading.
What is interest
Interest is the amount added to a loan or a deposit that must be paid.
To calculate interest, you need to know what type of loan you have and what rules the lender sets.
For example, credit cards charge you interest every day, although they normally have a monthly billing period, if you owe money because of an overdraft on the account.
Lenders can offer loans with variable interest rates and different payment periods, for example, monthly or annually.
Most lenders tend to set annual rates, but you may have taken out a loan whose interest is due monthly. If this is your case, to convert the annual interest rate into monthly you must divide it by 12.
Types of interest
Before continuing with the calculation, it is important to know how to tell apart the types of interest. There are two main types: simple and compound.
Simple interest
This is the simplest calculation and is generally used for short-term loans.
The capital tends to remain constant over the years and therefore the interest rate never increases.
An example would be a loan of €1,000 with a 5% annual interest rate.
Compound interest
In this case, the interest is calculated periodically and added to the principal amount.
In some loans, this may occur once a year, while in others it may happen every month or quarter. You will need to know how many times a year the interest is compounded.
If, for example, you take out a loan with a capital of €1,000 and an annual interest of 10%, at the end of the first year you would have to pay back €1,100.
However, at the end of the second year, the €1,100 would accrue an additional 10% interest, reaching €1,210, and so on.
How to manually calculate the interest
The amortization table
For the most common loans, which are usually those taken out for a house, a car, or an education, the most effective way is to build an amortization table.
This table will detail all payments, monthly interest, and capital amounts, as well as the remaining loan balance at any given time.
But to build your amortization table, you will need the following information:
- The type of interest, whether it is simple or compound.
- The period of time the loan lasts.
- The monthly payment, if there is one.
- And the initial amount on which you are paying this interest.
Once you have this data, you can apply the relevant formula.
Simple interest formula
If your loan has simple interest, is for €100, lasts one year, and has an annual interest rate of 6%, the formula you must apply is:
- Interest = Principal Amount x Interest Rate x Time in years; €100 x 0.06 x 1 = €6
- Total amount = Initial Amount + Interest; €100 + €6 = €106
Compound interest formula
Most loans are not so simple to calculate. It is likely that you have loans that last several years, and it is also possible that over these years your debt will grow.
This means that it is a compound interest loan, which is a bit more complex to calculate, but don't worry, because we are going to explain how to do it.
We continue with the same figures as above: a loan of €100 with an annual interest of 2%, but this time for three years instead of one.
We will have to do more than one calculation.
The first operation is practically identical to the previous one:
- Interest = Principal x Interest Rate; €100 x 0.06 = €6
- Total amount = Initial Amount + Interest; €100 + €6 = €106
But when it comes to calculating the second year, things change:
- Year 2 Interest = Total amount year 1 + (Total amount year 1 x Interest Rate)
- Total amount to pay year 2 = €106 + (€106 x 0.06) = €112.36
The third year has a formula quite similar to the one we used for year 2:
- Year 3 Interest = Total amount year 2 + (Total amount year 2 x Interest Rate)
- Total amount to pay year 3 = €112.36 + (€112.36 x 0.06) = €119.10
Once you have learned all these formulas to calculate interest by hand, you can also put them into an Excel spreadsheet, working with the columns, to semi-automate the process and share it with your clients or friends, depending on what you need it for.
In today's article, you have learned how to use the online interest calculator to find out the total amount to pay on your loan automatically, and we have also shown you how to do it step by step with all the possible variables, whether the interest is simple or compound.
We hope this has been useful to you. If you have reached this point and enjoyed the article, do not forget to share this tool on social media; that way, your contacts can also get to know this community.