Universal loan calculator. Online consumer loan calculator with early repayments

With the help of a loan calculator, you can independently, online, calculate regular loan payments and determine which repayment system will be optimal. Simple formulas help you understand how much money you send to pay off debt, and how much you pay for using borrowed funds as interest. You can check your results with a simple calculator.

An online loan calculator allows you to calculate annuity and differentiated payments. Annuity payments are made every month in equal parts, consisting of the loan amount and interest on it. With differentiated payments, monthly payments are consistently reduced, since interest is charged only on the outstanding part of the loan. Most commercial banks practice annuity, and Sberbank of Russia offers a differentiated form.

Differentiated payment

At differentiated scheme the amount of payments at the beginning is much larger than the final ones. The difference is explained by the fact that payments consist of two parts:

• fixed - the amount of debt repayment;
• descending - percent of the remaining amount.

The ever-decreasing second part reduces the amount of monthly payments. The formula by which you can determine the size of the fixed part is extremely simple: you need to divide the loan amount by the number of months of the loan:

OD = SC / KP

(OD - principal debt; SC - loan amount; CP - number of periods)

Further calculations are somewhat more complicated, since two approaches are used. Some banks assume that there are 12 months in a year and calculate the loan interest using the formula:

NP = OK × PS / 12

(NP - accrued interest, OK - loan balance, PS - annual interest rate)

Other banks prefer taking into account that there are 365 days in a year, considering this approach more accurate. Calculation formula:

NP \u003d OK × PS × NIM / 365

(NP - accrued interest; OK - loan balance; PS - interest rate for the year; NIM - number of days in a month (ranges from 28 to 31).

Calculation example

With a loan of 100,000 rubles taken for a year, the payment schedule according to the formula, taking into account 12 months and 20% per annum, is as follows:

Annuity payment

The amounts of payments under the classical system are repeated monthly, and can only be changed in case of early repayment of the loan or by agreement with the bank. As in the previous case, the installments consist of the principal repayment and interest on the loan. The ratio of these components changes over time: percentage decreases and the loan amount increases. Thus, the interest on annuity payments is higher than on differentiated payments. This is explained by the fact that interest is charged on the balance of the amount, and it decreases slowly. The difference is especially noticeable if the loan is repaid ahead of schedule, because in the first installments a significant part of the amount falls on interest.

Formula for calculating payment:

AP = SC × PS / 1 − (1 + PS) - CP = SC × PS / 1 / (1 + PS) CP = SC (PS × (PS + PS / (1 + PS) CP - 1

(AP - annuity payment; PS - interest rate; SC - loan amount; KP - the number of periods).

With monthly payments, the KP in this formula is the number of months for which the loan is scheduled, PS is 1/12 of the annual interest rate.

This formula is a classic, most banks use this particular scheme.

Calculation example

Consider the payment schedule for a loan taken for 12 months in the amount of 1,000 rubles. In some banks, the first loan payment is not an annuity, in this case the formula for calculating looks like this:

AP = SC × PS / 1 − (1 + PS) 1 − CP = SC × PS / 1 − 1 / (1 + PS) CP-1 = SC × (PS + PS / (1 + PS) CP-1 − one)

(AP - annuity payment; PS - interest rate; SC - initial loan amount; CP - number of periods).

The first period of payment of the loan may be full or incomplete, and in this case it is not an incremental one. If the period is incomplete, the down payment may be less than the annuity, but with high interest rates, a full period of 31 days and a long-term loan, it is quite possible that it will exceed the established amount.

Sometimes banks apply the formula with the first and last non-annuity payments:

AP = SC × PS/1 − (1 + PS) 2 − CP = SC × PS / 1 − 1 / (1 + PS) CP-2 = SC (PS + PS / (1 + PS) CP-2 − 1 )

When calculating according to this formula, the first and last installments are not annuity, that is, only interest must be paid in the first month, and balances in the last. Thus, banks try to adjust the amount of payments to an integer, as a result, there is a “tail” that goes to the last payment. In case of early repayment, the reduced amount of the balance also changes the size of the "tail", which can increase or decrease.

According to the last formula, the payment is the largest, and according to the classical first formula, the smallest. The difference becomes especially noticeable if the amount of payment remains minimal by the final settlement. This is important when repaying a loan early.

Which scheme is more profitable?

• With an annuity, the amount of payments does not change, and with a differentiated scheme it constantly decreases.
• A differentiated system involves larger payments at the beginning of loan repayment.
• For borrowers, an annuity is usually more convenient, since the amount of payments is clear and defined for the entire term of the loan.
• With a differentiated scheme, income should be 25% higher than with an annuity.
• The principal debt with an annuity decreases slowly, and the interest on the loan is high. Early repayment of the loan results in the loss of interest already paid.
• The differentiated system is not associated with the loss of interest, even if the loan is repaid ahead of schedule.
• Getting a loan under a differentiated scheme is much more difficult, as banks are trying to make sure that the borrower is solvent. Big income It is necessary that the borrower has the opportunity to make increased payments at the beginning of the loan repayment.

This calculator is designed to calculate consumer loans and mortgages at Sberbank, VTB, Deltacreditbank, Zenith Bank, Alfabank, Promsvyazbank, Rosselkhozbank, Raiffeisenbank, HomeCredit Bank, SKB Bank and other Russian banks.

To calculate the loan refinancing, you can save your calculation and use it in the refinancing calculator

Ability to save credit

In case you want to save your calculations, click " Save calculation«.
You will have access to a unique link that you can bookmark. When you open this link, the previously entered credit data will be automatically loaded.
If you have changed the data - click " Update Calculation". In this case, the changed data from the loan will be saved at the current link.

If you need to compare early repayment options

If you are in doubt about how to repay early - to pay off the amount or term, to pay earlier or later, then you can open 2 calculators on 2 browser tabs and compare. But it's not very convenient. Now we have made a special calculator for comparing early repayment schemes
See also: .
There you can enter the same loan parameters on the left and right. But early repayments can be made of different types. By clicking calculate, the most profitable option will be shown first

Entering various calculation parameters

For different banks, when calculating early repayment, you need to set different flags in the block additionally. This will make the calculation of early repayment more accurate.

If you have a loan from Sberbank

When calculating early repayment in Sberbank, you need to check the boxes:

• Accounting for early repayment on the payment date
• Payment of only interest after early maturity (Sberbank)

The amount of early repayment is entered taking into account the fact that part of this amount will be used to repay interest in the case when the date of early repayment does not coincide with the date of the next payment.

If you have a loan from VTB Bank

• Check the box:
• Check the box: Annuity on the original debt with a change in%

For Raiffeisenbank

• Check the box: Accounting for early repayment on the payment date
• Check the box: Calculation of interest per month as in Raiffeisenbank
• Check the box: Include weekends

For other banks

If you see on the bank schedule that you need to pay the last day of each month, then put

• Set the flag - First payment only interest and enter the date of issue
• Payment on the last day of the month

It should also be understood that some calculation modes are not combined. For example: Account for early repayment on the payment date and account for weekends. With these parameters, the calculation may be incorrect.

An asterisk (*) on the payment schedule indicates dates that fall on a weekend - Saturday or Sunday. Usually, in this case, you must pay the loan before the weekend or on the first business day.

It is also a fairly accurate and versatile Home Credit Bank loan calculator. This calculator is used by many who want to take a loan at Home. Credit calculator online allows them to estimate how much they will pay on the loan per month, as well as how much their payment will change if the loan is repaid ahead of schedule.

Attention! Early repayment made on the date of the next payment is taken into account in the next payment period. Those. if your next payment date is February 14 and you made an early repayment on February 14, then the new annuity payment amount will be only on April 14. if you make an early repayment on February 13, then new payment will be March 14th. If you want to account for payments exactly on the early date, set the checkbox - Accounting for early due on the payment date on the "Additional" tab
The most accurate calculation of early repayment at the moment is implemented in the loan calculator for Android.

Some terms and definitions when using the mortgage calculator.

Credit amount- the amount you want to borrow, which is indicated in your loan agreement
Interest rate- the rate specified in your contract
Term- an integer number of months for which the mortgage loan is taken.
Annuity- with this type of payment, you pay in equal installments. Initially interest payment more, but over time it decreases
Differentiated payments- with this type of payment, the amount of principal repayment is always constant. Interest is charged on the amount of the principal debt. At the same time, the next payment decreases over time. This online loan calculator implements the calculation for the above types of payments
Early repayment to reduce the amount- in this case, the amount of your early payment goes to repay the amount of the principal debt. If the amount of the principal debt decreases, then the amount of the monthly payment decreases. This is due to a reduction in the percentage of the payment.

Early repayment to reduce the term- with this early repayment, the next payment remains the same, but the loan term decreases. You will pay off the loan earlier.

First payment- interest. This flag must be set if you have the first loan payment in the mortgage payment schedule that is not equal to the others. This is a payment to the bank in the form of interest if your date of issue and the date of the first payment are different. Do not set this flag unnecessarily. In details .

Rate change– this type of early payment is suitable if, for example, after receiving an apartment in your ownership, there has been a change in interest on mortgage loan. This is written into the mortgage agreement. To change the rate, you need to submit a package of documents to the bank.

Commissions and insurance— these types of payments do not affect the calculation of the loan and mortgage payment schedule, but they are used when calculating the total overpayment on the loan.

Popular calculator questions

Is it possible to change the loan rate in the calculator?

A consumer loan is a loan that you take out for various consumption needs. For example, you want to buy a TV in a store or a washing machine, or go on vacation.
Buying a tour from an operator is a purchase of a service. Those. you consume a service and take out a consumer loan.
Calculator consumer credit designed to calculate cash loans, taking into account commissions and insurance. Here you can choose a suitable loan and apply online

Calculation options

The calculator allows you to simply calculate the loan - enter the amount, rate, term and click calculation.
The second option is the calculation of early repayment. You set the loan details and the dates and amounts of the early repayments. If you want to understand how much you will repay when depositing each month a certain amount on a loan, we recommend using a forecast calculator
See same:
It will allow you to understand how quickly you will close the loan.

How to compare two loans

Before receiving bank loan It will not be superfluous to calculate the overpayment on the loan. It is best to compare the offers of several banks and choose the best one. The calculator on this page can be used for this. However, you will have to open another page with a calculator to compare 2 different loans. Especially for comparing loans and early repayment schemes, we have made a loan comparison calculator
See also:
It will allow you to understand which early repayment scheme to choose - to reduce the term or the amount of the payment. It will also help you choose the best loan option.

How to calculate a loan using a calculator

There are 2 loan options
The first is a preliminary calculation when you want to borrow cash. For this calculation, the date of the first payment is not needed. It can be left as default. It does not affect the monthly payment.
Loan amount - it is written in the loan agreement and is taken without taking into account down payment for a product or service.
Interest rate - the nominal rate on the loan, excluding commissions and insurance. Taken from the loan agreement. You can enter 3 decimal places.
Expressed without dividing by one hundred.
Term - an integer number of months for which the loan is taken. If you have 2 years, for example, then you need to enter 24 months
The second option is the calculation of the existing loan
The next field is the date of the first payment. This parameter is already important when you took out a loan
For a loan taken, the calculation by date is important. That is, when plotting the schedule, the date of the next payment is indicated - the number of the day in the month.
Date-based calculation is important for early repayments. The date of early payment of funds determines in which month the new reduced payment will be.

How to use the calculator?

After entering the required data above, you need to click on the calculation button.
After pressing it, the following options are possible

• Data entry errors. Please note that dates must be entered through a dot in the format dd.mm.yyyy. Amounts are entered in through a dot, the rate can have 3 decimal places
• There was a successful settlement of the loan. Set up a payment schedule. Loan overpayment calculated

Read also:
If the calculation is successful, you can start adding early repayments. In the form on the right - adding early repayment - you need to enter the date, type and amount and click add. There will be an automatic recalculation of the loan schedule and other parameters. The total overpayment will change.
In the case of full early repayment, after this payment, there will be zeros in the schedule, regardless of whether the amount or term was reduced.
If you added a repayment with a change in the term, there will be fewer lines in the chart compared to the initial version.
Repayment with a change in the amount will reduce the annuity payment on the loan. The number of lines in the payment schedule will remain the same.
If you added a change in the interest rate, the payment schedule for the new interest will be recalculated from the moment when this change took place. The payment may increase or decrease depending on whether the rate was reduced or increased.

Export data to Excel

After the calculation, you can save the results on your computer. To do this, click on the link "Get Excel file". An Excel 2003 file will be generated and a "Download File" link will appear. You need to click on this link and the file will be saved to you. You can print the file and return to it at any time.
When calculating the loan, the link to this file disappears and you will need to generate the Excel file again.
I recommend bookmarking the calculator for ease of use in the future.

Popular questions and answers

Our bank calculator will calculate the loan in one click. Just specify the parameters of the required you are interested in. loan and the program will make a preliminary calculation in an automated mode. The monthly payment schedule will be generated under the form and will contain a table of payments divided into principal and interest.

Bank calculator for calculating a consumer loan in cash

Before registering a consumer, many citizens are interested in the conditions under which lending takes place. How much will I have to pay per month? How much will I pay for the entire term? What is the percentage of overpayment on a future cash loan? These are common questions people are looking for answers online in 2019 and will be looking for in 2020, 2021 and beyond. Our experts have developed a universal loan calculator that works completely online, which will help you answer them.

We will describe in detail how to independently work correctly with this calculation program.

What can this calculator calculate?

Correctly calculating a loan does not require special knowledge. Our program is designed in such a way that it will be easy to use as an average individuals as well as pensioners. Previously, you can set 4 parameters in the form:

• Amount of money loan(200000, 500000, 800000 or whatever). By moving the slider maximum amount will be 15,000,000 rubles, but you can enter any arbitrary number.
• Loan terms, which can also be absolutely anything - a year, 2 years, 3 years, 4 years, 5 years, 7 years, but the slider is set within 6-180 months.
• Interest rate loans. We set 8.9% as the minimum value, and 49.9% as the maximum. But you can also put the number that is convenient for you - 15 per annum, 18 per annum, 16 per annum or 20 per annum.
• And the last - payment type. If you plan to pay the loan in equal payments (annuity), then select the "Equal" tab. If you want the amount of the monthly payment to become smaller over time, then set the active tab "Reducing" (differentiated).

Having set these conditions, you just have to click on the "Calculate" button. Mathematical formulas in online mode will instantly provide you with data on the following parameters:

• The amount of the monthly payment, in rubles.
• The amount of the original loan.
• Full cost (initial + interest).
• Total overpayment (interest in rubles).
• Overpayment ratio, in percent.

Usually, after a preliminary calculation, visitors talk about the calculator on social networks, and also put a rating. According to it, other people see how convenient and useful our program is to use. And reviews help to form a common opinion about the functionality and convenience of the calculator.

Drawing up a payment schedule or how to calculate loan payments

For solutions this issue You also don't need to have specialized skills. After receiving the initial data, a table will open under the form, which will reflect the approximate payment schedule for the future short-term or long-term loan. The following data will be presented on a monthly basis:

• month number;
• exact date of payment;
• the amount of the monthly payment (principal debt together with interest);
• the amount of the principal debt in the payment;
• the amount of interest in the payment;
• balance on the loan after payment of the payment.

Under the payout table there will be a final line in which total cost and loan repayment. You will understand how much to pay for a loan according to the selected borrowing conditions Money. The data presented will also be sufficient to evaluate prepayments.

Choosing the right cash loan

After you calculate the amount of the debt yourself, you will have access to a block with the most popular loan offers. The site team tried to collect in one place the products of many banks in Russia. The convenient arrangement of information will help you to leave applications in several banking institutions and after receiving approval, take the money at any branch of the bank.

We hope you found our bank calculator useful!

Today online loan calculators are placed not only on the websites of banks, but also on most specialized Internet resources devoted to financial topics. The reason for this situation is obvious and lies in the convenience and ease of use of such tools.

Literally within a few seconds, anyone can calculate the approximate parameters of an available loan using an online loan calculator. Examples of such calculations are given in the table.

The ability to pre-calculate a loan allows you to determine its most important parameters, which include: the amount of regular payment, the amount of overpayment and overall size overall loan payments. A comparison of several payment options clearly shows which cash lending option is most beneficial for a potential borrower.

Loan interest calculation

The key parameter for comparing different loans is the amount of interest paid or, as this indicator is often called, the amount of overpayment. It is she who, along with the effective interest rate, demonstrates the real profitability of one or another banking product for client. Below are examples of calculations for various loans, sorted by this parameter.

Calculation of the monthly loan payment

No less important in the process of choosing a loan is the value monthly payment by him. The value of this parameter determines how serious the financial burden will fall on the borrower. Below are examples of calculating the terms of a cash loan with the allocation of this indicator