Loan calculator quarterly calculation. Loan calculator with early repayments online. Exporting data to Excel

The loan calculator calculates monthly payments, interest on a loan, payments on commissions and insurance. A payment schedule is drawn up with an indication of the amounts of payments taken into account. The loan calculator can calculate annuity or graded payments. The totals on the right display the amount of the monthly payment, interest overpayment, overpayment including commissions, and the total cost of the loan.

Pay special attention to the Effective interest rate, which, taking into account additional commissions and insurance, can be significantly higher than the one offered in the loan agreement.

Loan calculator settings

Calculation method
It is possible to calculate the loan and payments, both by the Loan Amount and by the Purchase Price and the down payment. When calculating a loan at the Purchase Price, the loan amount is first calculated, while interest and commissions are not charged on the initial installment.

Loan currency selection
The loan calculator can calculate a loan online in one of 3 currencies: rubles, dollars or euros.

Credit term
By default, the loan term must be entered in months. The term can also be entered in years, but the type of loan term must be changed.

Interest rate
Traditionally, the interest rate is calculated on the basis of interest / year. By changing the settings of the loan calculator, you can calculate payments based on the monthly interest rate.

Payment type
Usually, banks use the annuity method of calculating loan payments (equal monthly payments) to calculate a loan. However, the second option is also possible - differentiated payments (accrual of interest on the balance). Using the drop-down menu, select the type of payment calculation you need. For more information on the types and methods of calculation, see the sections annuity calculator or differential payments calculator.

Additional settings

Issuance commission
One of the conditions for issuing a loan by many banks is the payment of the Commission when issuing or issuing a loan. The loan calculator can take this commission into account in the total cost of the loan and, if necessary, split the commission into monthly installments.

Monthly commission
It is taken into account in the total cost of the loan and in monthly payments

Insurance
Loan insurance is an additional option for a monthly commission. As a rule, banks do not take insurance into account in the monthly payment schedule and charge a similar commission on the basis of an additional agreement. However, the total cost of the loan received can increase dramatically. The online loan calculator takes into account the monthly insurance in the total cost of the loan and in the amount of the monthly payment.

Last installment
One of the loan options is a last installment loan. When calculating such a loan, the amount of the monthly payment is lower due to the decrease in payments on the principal debt. However, interest on the last installment is also calculated and taken into account in monthly payments.

date of issue
By default, the current date is used, but you can choose any convenient one. The function is convenient when working with a payment schedule.

First payment date
Initially, the current date is used, for the convenience of working with the payment schedule, select the required one.

Loan calculator with early repayment

In the early repayment section, you can plan such repayments. Some banks often impose penalties associated with the payment of such a payment. In the commission section, you can set the appropriate parameters and thereby determine exactly how much the early repayment will actually be beneficial.

Loan calculator report in Excel

The loan calculator will calculate the total cost of the loan - the amount calculated as a percentage, which takes into account commissions, related payments and the time of their payment. This makes it possible to compare loans with different commission fees.

Accounting for inflation in loan payments

Having set the parameters of the expected inflation of the credit calculator, it is possible to estimate the costs, taking into account the real purchasing power of money over time.

Dependence of the overpayment, the amount of the monthly payment on the parameters of the loan

Analysis of the graphs of the dependence of the parameters of the loan allows you to choose the most comfortable conditions for the loan. By clicking on the point of interest on the diagram, you can start a more detailed calculation for the parameter selected on the diagram.

Annuity or differentiated payment

With annuity payments throughout the entire repayment period, the amount of monthly payments is the same, while in the initial period, debt repayment is slower, since you have to pay the accrued interest on the loan. This type of loans is the most common in Russia. The differentiated payment scheme assumes at the initial stage the payment of large monthly amounts, which will decrease with each subsequent time. The debt is repaid in equal installments throughout the entire period, but the amount of accrued interest changes. The total amount of overpayments in absolute terms is higher with an annuity scheme, however, it is important not to forget about inflation, especially for long-term loans. In conditions of high inflation, this scheme becomes significantly more profitable in the context of the purchasing power of money. Those. You will be able to purchase more goods and services for the entire period of loan payments.

The credit system involves the monthly payment of a certain amount to the bank account of the lender. To find out the interest, it is enough to use the "calculating interest on a loan online calculator". These applications contain standard formulas to obtain an accurate calculated value. However, it will not be superfluous for payers to be able to independently calculate the rate.

How to calculate interest on a loan?

To begin with, you should understand that the amount of funds that you will overpay to the bank (interest) depends on the rate of loan repayment. That is, the larger the monthly payment, the lower the percentage premium.

The number of loans issued.
Interest rate for the year.
Debt repayment method (differentiated and annuity options are distinguished).
The number of days for which the loan was issued.

All of these factors are taken into account in free online calculators that allow you to quickly and accurately calculate payments. If you want to calculate the interest on your own, the choice of the formula will depend on the way in which the debt is repaid.

We calculate the amount of loan interest on a monthly differentiated payment

If you decide to calculate the interest on a loan, we recommend using an online loan calculator with interest, in which it is enough to indicate all the requested data. It will be a little more difficult to calculate the rate and interest on your own. So, the calculated payments include the following components:

Exactly calculated amount, set by the bank, charged to repay the loan in equal installments (funds are transferred every month).
The interest amount accrued on the loan balance, that is, a constantly decreasing (in a favorable scenario) part.

To establish the exact amount of the standing order, bank officers divide the borrowed funds by the number of months during which the repayment must occur. A fairly simple formula allows you to calculate the interest on a loan. It looks like this:

Percentage amount = (OOZxPShKDM) / (100x365)

Let's decipher the components of the formula:

OOZ - the remainder of the main loan.

PS - interest rate.

KDM is the number of days in a month.

The second part of the formula is the product of one hundred percent by the number of days in a year.

In principle, it is not difficult to calculate the level of overpayment using a differentiated formula. But if you want to save your own time, it is more rational to use an online loan calculator. The program calculates everything using an identical formula, while the final value will be more accurate.

How to calculate the amount of loan interest on a monthly annuity payment?

If the concept of differentiated credit is recognized by everyone, then the term "annuity" is not so common. Such a loan implies the repayment of the debt in equal installments. That is, you don't have to re-calculate how much money should be deposited into the account every month. Throughout the entire loan period, payments do not change. However, the rate itself and the interest are calculated in a slightly different way, more complicated. Again, to simplify the task, it is more rational to calculate the interest on the loan through the calculator.

Monthly payment = (PSZxGPS / 12) / (1- (1 / (1 + GPS / 12) ^ (KP-1))

Now we will decipher the values necessary for calculating (by the way, a calculator will be needed here anyway, otherwise you risk calculating the amount incorrectly):

PSZ is the initial loan amount.
APR is the annual percentage.
KP is the planned number of loan payments.

Calculating the amount of interest on a loan using a loan calculator online

To calculate the amount of interest on a loan, you need to completely fill in the main fields of the loan calculator: loan amount, interest rate, loan period. At the moment, we include fixed and non-fixed percentages.

We refer to the fixed interest rate. Yes, some banks provide the option of using variable lending rates, but we talked about this in another article. We include commissions as non-fixed interest rates: “for early repayment of a loan”, “for issuing cash”, “for an overdue loan payment” and others. Use the block early repayment if you have already made it. Add monthly and one-time commissions, this will allow you to calculate the entire amount of interest on the loan.

Click the “ Calculate”And you will receive a full payment schedule, including the interest rate, the previously indicated commissions and early repayment of the loan. Pay attention to the block “ common data", It has a column" Interest charges”- this will be the amount of interest on the loan. If you want to consider in more detail in which of the months and how much you will pay interest on the loan, click on the button “ Load more ... number of lines”.

Print, save or email the payment schedule. This will allow you to compare the resulting chart with the chart provided by the bank. So you can easily understand about hidden commissions and possible overpayments, which the bank was silent about earlier.

Which repayment method is more profitable: annuity or differentiated?

So, you can calculate interest and the size of rates in two ways: using a special loan calculator or calculate it yourself using a formula. But one question still remains unsolved: which payment will be more profitable - differentiated or annuity?

The annuity loan is designed for payments in the same amounts every month. First, the interest on the loan is repaid, and then the “body” of the loan. A differentiated loan is calculated on the condition of faster repayment, but with higher payments at the beginning of the loan period and with a constant decrease in monthly payments. It makes no sense to take a differentiated loan if the loan period is 1 year, but if you take a loan for 10 years or more, then this type of loan will help significantly save the family budget.

In fact, both systems have advantages and disadvantages of counting. You should choose on your own, starting from the real possibilities of payment. It is recommended to pre-calculate the amount of interest rates and interest for both options (using the "calculation of interest on a loan online calculator" or calculate it yourself using the formulas given) and, based on the calculated information obtained, select a suitable method of loan repayment.

To calculate the loan, you must enter the loan amount, indicate the term of the agreement and the amount of your interest rate. This calculator can calculate both fixed annuity payments and downgraded differentiated monthly payments (go to "advanced options").

The rate indicator can be selected fixed or variable. To select the second option, you need to enter the number from which the new percentage will be entered.

Thanks to our calculator, you no longer need to go to the bank to calculate early loan repayment. And this can be done within just 2 minutes! To do this, just enter some additional data in the program form:

What date the funds were deposited early (in the case of a one-time payment) or the time period (if you plan to make regular payments several times a month);
Early payment amount;
Specify the option for recalculating the loan;
You can enter an unlimited number of early payments.

The nuances of partially early repayment of debt

Early repayment loan calculator

There can be 2 types of write-offs with partial early repayment:

On the day when the next payment is made. With this method, the amount of debt is reduced by the amount of the extraordinary payment made.
Between next payments. This option is somewhat more complicated in calculations. Interest, depending on the size of the debt, is calculated daily, and repayment occurs once a month. On the day when the early payment is made, a certain amount of interest is accumulated, which are canceled thanks to the funds intended for the early payment. With this option, only the rest of the amount will go to pay off the debt. The next month, the percentage of the next installment will decrease, since some of this interest has already been paid. There is no reason to worry about this moment and to postpone early repayment at the time of the next installment. If the payment is made earlier, it will be more profitable.

After payment of the extraordinary installment, changes are made to the schedule of subsequent loan payments. The size of the principal debt decreases and, as a result, one of the parameters changes: the loan term, or the amount of the monthly payment. A client of a banking institution can always choose a more convenient option for himself. This choice determines how the bank will recalculate the loan, and what the next payment schedule will be formed. The updated schedule can be obtained at the bank's office, or by going to the Internet bank, if you have access to it. Our online calculator will give you the opportunity to choose any option and calculate the loan depending on your choice. A detailed payment schedule will become available to you, in which early repayments have already been taken into account and indicated.
Reducing the loan term is beneficial because it significantly reduces the overall overpayment. It follows from this that if you can manage the monthly payment, then it is the loan term that should be reduced.

You can try different options of parameters in order to choose the most optimal payment scheme for yourself. The loan calculator stores the results of calculations, and you do not have to remember all the numbers entered and received earlier.

Variable interest rate

In the course of the loan, the interest rate is often subject to changes. Such cases arise when, at the request of the borrower or under the terms of the agreement, the bank revises the loan rate. Our calculator has its own function especially for such cases. You can specify as many changes in the interest rate as you like over the course of the loan. For each separate time interval, it is necessary to set the start of the rate and its size. In the payment schedule, all changes will be highlighted in color.

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

Bank calculator for calculating a consumer loan in cash

Before registering a consumer loan, 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 overpay for the entire period? What is the percentage of overpayment on a future cash loan? These are common questions people are looking for on the internet in 2019 and will be looking for 2020, 2021 and beyond. Our specialists have developed a universal loan calculator that works completely online, which will help you answer them.

Let us describe in detail how to independently work correctly with this calculation program.

What can this calculator calculate?

Calculating a loan correctly does not require any special knowledge. Our program is designed in such a way that it will be easy for both average individuals and retirees to use it. Previously, you can set 4 parameters in the form:

Cash loan amount(200000, 500000, 800000 or any other). By moving the slider, the 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 figure that is convenient for you - 15 per annum, 18 per annum, 16 per annum or 20 per annum.
And the last one - type of payments... 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 less over time, then put the active tab "Reduced" (differentiated).

Having configured these conditions, you just have to click on the "Calculate" button. Online math formulas will instantly provide you with data on the following parameters:

The amount of the monthly payment, in rubles.
Initial loan amount.
Full cost (initial + interest).
Total overpayment (interest in rubles).
Overpayment ratio, as a percentage.

Usually, after a preliminary calculation, visitors talk about the calculator on social networks, and also rate it. Other people use it to see how convenient and useful our program is to use. And the reviews help to form a consensus about the functionality and usability of the calculator.

Scheduling payments or how to calculate loan payments

To solve this issue, you also do not need to have specialized skills. After receiving the initial data, a table will open under the form, which will reflect an approximate payment schedule for a future short-term or long-term loan. It will present the following data on a monthly basis:

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

Below the table of payments there will be a total row, which accumulates the full cost and overpayment of the loan. You will understand how much to pay for a loan under the selected conditions of borrowing funds. The presented data will also be sufficient to estimate the preliminary early repayment.

Selection of a profitable cash loan

After you calculate the amount of 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 location of the information will help you submit applications to several banking institutions and, after receiving approval, take money from any branch of the bank.

We hope you found our bank calculator useful!