Credit calculator uses standard formulas, and taking a regular calculator you can easily check the result using the formulas below.
Loan calculator - helps to calculate the monthly amount of payments to repay the loan, the effective interest rate using the formula Central Bank RF, you can also find out what part of the payments goes to repay the main credit amount, and what part is for repaying interest on the loan.

The calculator on the website allows you to calculate two types of payments: - this is an equal monthly loan payment, which includes the amount of accrued interest on the loan and the amount of the principal debt, used in most commercial banks; differentiated payment- this is a monthly payment that decreases towards the end of the loan term, and consists of a paid constant share of the principal debt and interest on the unpaid balance of the loan, often used in SberBank. Credit calculator - applied , to compare different types of loans and obtain the necessary information without resorting to the help of banking specialists.

Calculation of differentiated payment

At the beginning of the loan period, there are more loans, and then they gradually decrease, i.e. Regular loan payments are not equal. The structure of the differentiated payment consists of two parts: a fixed amount for the entire period, used to repay the debt, and a decreasing part - interest on the loan, which is calculated from the amount of the remaining pledge on the loan. Due to the constant decrease in the amount of debt, the amount of interest payments decreases, and with them the monthly payment.
In order to calculate the amount of repayment of the principal debt, it is necessary to divide the initial loan amount by the loan term (number of periods):
Formula 1., Where
OD- return of the principal debt; SK- initial loan amount; KP- number of periods.

This is where the similarities in the approaches of banks end, and the differences begin. They consist of approaches to calculating the amount of interest due. There are two main approaches, the difference is in the time base used. Some banks assume that “there are 12 months in a year” and then the amount of monthly interest payments is determined by the formula:
Formula 2., Where
NP - interest charges; OK PS- annual interest rate.

Some banks assume that “there are 365 days in a year” and this approach is called calculating exact interest with the exact number of days of loan. The amount of monthly interest payments in in this case determined by the formula:
Formula 3. , Where
NP - interest charges; OK- loan balance in a given month; PS- annual interest rate; CHDM- the number of days in a month (it is clear that this number varies from 28 to 31).

Example 1.
As an example, the payment schedule is given for a loan of 1,000 conventional units for a period of 12 months, with a monthly repayment of 1/12 of the loan and payment of interest. In this example, like on the website, when calculating accrued interest, formula No. 2 is used (“there are 12 months in a year”).

Table 1.

!

Calculation of annuity payment

Annuity , i.e. Equal payments are payments that are made throughout the entire loan term and are equal to each other. With this type of payment, the borrower regularly makes payments of the same amount. This amount can only be changed by agreement of the parties or, in some cases, partial early repayment. The structure of the annuity payment also consists of two parts: interest for using the loan and the amount used to repay the loan. Over time, the ratio of these values ​​changes and interest gradually begins to amount to a smaller amount; accordingly, the amount to repay the principal debt within the annuity payment increases. Since, with annuity payments at the beginning, the amount used to repay the principal debt decreases slowly, and interest is always charged on the remainder of this amount, then the total amount of interest paid on such a loan is greater. This is especially noticeable with early repayments. In the first periods of lending, the main payments fall precisely on the repayment of interest on the loan.
The amount of the annuity payment is determined by the formula:

Formula 4.
, Where
AP PSSK - initial loan amount ; KP - number of periods.
! Those. if payments are monthly, then KP is the term in months, and PS is the monthly interest rate (1/12 annual)

Formula 4 can be called “classical”, because it is used in calculations where all payments are annuity, it is used in most banks, loan calculators, and spreadsheets. It is also used in calculations on the website
Calculation of annuity payments using this formula can be done using MS Excel and the built-in PMT worksheet function (in Russian versions PPLAT or PLT)

Example 2.
As an example, a schedule of annuity payments is given for a loan in the amount of 1,000 conventional units for a period of 12 months.

Table 2.

! When calculating, rounding errors must be taken into account.

Other formulas for calculating annuity payment

Some credit organizations apply formula where the first payment is not an annuity:

Formula 5.
, Where
AP PS- interest rate for the accrual period; SK - initial loan amount ; KP - number of periods.

The first payment is preliminary - not an annuity. He is always, supposedly, less than AP, because includes only interest for the first period, which may be full or partial. But with a full period of 31 days, with high PS and long-term lending, the preliminary payment may be more than AP! Remaining ( KP-1) payments – annuity. This formula is used in AHML.

Also in practice there is an application formulas where the first and last payments are not annuity:

Formula 6.
, Where
AP PS- interest rate for the accrual period; SK - initial loan amount ; KP - number of periods.

The first and last payments are not annuity, the first is only interest for the first period, and the last is the balances, “tails,” etc.
Remaining ( KP- 2) payments - annuity. Apparently, banks adjust the AP to an integer number of rubles or dollars. Therefore, a “tail” is formed, which goes to the last non-Annuity Payment. Then, after each early repayment, banks adjust a new reduced AP to an integer monetary units. Those. the "tail" can decrease or increase.

Lowest Annuity Payment obtained from calculations according to formula 4, the largest - according to formula 6. Moreover, the less AP remains until the final calculation, the more significant this difference becomes. What is especially important when early repayment. That's why it is necessary to be interested not only interest rate, but also by the formula by which AP is calculated.

What is more profitable: annuity or differentiated payment scheme?

Questions about choosing a payment plan mortgage loan frequently asked by potential borrowers. If we compare the annuity and differentiated schemes, the most obvious differences will be the following:

• Constancy of size regular payment at annuity scheme And constant decrease such payment with differentiated.
• Larger payment amount, compared to the annuity scheme, at the beginning of the loan term with a differentiated scheme.
• Annuity payment scheme is more accessible for borrowers, because payments are evenly distributed for the entire loan term. When choosing differentiated payments, the confirmed income of the borrower or co-borrowers must be about a quarter more than with annuity payments.
• With annuity payments at the beginning, the amount of the principal debt decreases slowly, and the total amount of accrued interest is greater. If the borrower decides to repay the loan in full early, the interest paid in advance will be forfeited. With an annuity scheme, a significant portion of the interest is paid from the beginning, ensuring payments for the entire term of the loan. Therefore, with differentiated payments, early repayment will occur without such financial losses even at the beginning of the mortgage loan term.
• A loan with differentiated payment is more difficult to obtain, because When receiving a loan, the borrower's solvency is assessed. A differentiated scheme at the beginning of the loan term offers significantly larger payments than an annuity scheme. This means that the borrower needs to have more income. On average, it is believed that the borrower’s income under a differentiated scheme should be 20% higher than under an annuity scheme.

To summarize, we can say that the type of payment is one of the main parameters of the loan, but it must be considered in conjunction with other parameters.

If you take out a loan, you agree to repay the loan amount and interest for using it over a certain period. To make it clear to the client how and when payments should be made, repayment schedules are drawn up.

The most common option is making annuity payments, that is, repaying the loan in equal amounts.

How to calculate the amount of annuity payment?

There is a special formula that allows you to calculate the amount that should be deposited monthly to repay the debt to the bank and interest on it.

A = K x S

In this formula:

A- payment amount

K- annuity coefficient

S- amount of loan received

There is one unknown element of the formula - the annuity coefficient. It must be calculated separately using the appropriate formula.

Here i- this is the monthly interest rate for using the loan, which is calculated by dividing the annual rate by 12 months

n - the number of months over which the loan must be repaid.

This formula will help you independently calculate the amount that should be deposited each month in favor of the bank.

How to calculate annuity payments in Excel

To avoid the hassle of manual calculations, try doing it using Excel tables. There is a special function called PMT. To make calculations, create a new table and enter a row in any cell. If you were given a loan in the amount of 30,000 rubles, at 18% per annum for 36 months, you need to enter the following expression in the cell.

PLT(18%/12; 36; -30000)

In parentheses, you enter the data in this order: the interest rate, the number of months of payments, the amount borrowed. The minus before 30,000 just means promissory note, in principle, it is not necessary to set it, unless you are using the formula for more complex calculations and the sign is fundamentally important.

You can also enter the entry in this form:

PMT(0.015; 36; -30000)

It turns out 1084.57 rubles.

If you are too lazy to enter a formula, just download a ready-made file with an annuity formula or refer to a loan calculator.

The calculations made will help you make sure that bank employees have correctly calculated the amount by which your budget will decrease each month.

Help: annuity and differentiated payments

According to the annuity scheme, the client pays the same amount monthly to repay the loan and interest on it. This happens throughout the duration of the contract with the financial institution.

There is also a way to repay the loan through differentiated payments. By choosing this repayment option, the monthly amount deposited in favor of the bank will be different every month and will constantly decrease, as the amount of interest on the remaining debt is reduced. See also the article about the differentiated repayment method.

It is more profitable for banks to offer clients a scheme with annuity payments, since in this case they earn more due to a larger amount of interest. And this scheme is more convenient for clients, since they need to pay the same amount every month. This does not require unnecessary time spent on clarifying how much you need to deposit.

In order to successfully apply for a loan, you need to calculate everything! It is also important to know that loan payments can be annuity and differentiated. Great assistance in choosing, including an annuity or differentiated payment, is provided by a loan calculator, which helps calculate the features of a particular loan.

Applying for almost any loan requires the borrower to know the details of the contract - from basic terms to repayment methods (annuity or differentiated). Russian financial institutions offer almost the same basic conditions on loans. Sometimes the borrower has the right to choose a repayment method between differentiated and annuity payments.

It is the type of payment (differentiated or annuity) that determines what is repaid first: the “body” (differentiated) or interest (annuity). You can use a calculator. Our calculator will help you calculate your loan, feel the difference and make a choice between annuity and differentiated payments:

What is an annuity payment?

Annuity payments are equal monthly payments. In order to calculate the amount of annuity payments, banks use the following formula (we strongly recommend that you use a calculator to calculate the overpayment on the loan):

x=S∗ (P+ P(1+P)N−1), where:

X – monthly annuity,
S – amount of debt,
P – interest rate divided by 12 months,
N – term.

Important! What is the essence of the annuity repayment scheme? The fact is that the same amount is paid every month. Initially (in the first months), the borrower repays the accrued interest, and after that - the “body”.

Financial institutions The annuity repayment option brings obvious benefits - they immediately receive interest on the loan provided. The borrower benefits from the fact that with a small budget he can take part in a serious program, since with an annuity repayment scheme the bank is more confident in the borrower. To compare the difference in annuity payments, you can calculate it using a calculator.

Advantages of the annuity repayment method:

The annuity payment is fixed throughout the entire term. This allows you to calculate your budget;

According to Art. 220 Tax Code Russian Federation, within the framework of a mortgage, with an annuity payment, the borrower receives tax deduction in more large size;

Citizens of the Russian Federation with little financial resources can apply for almost any loan using the annuity type. And the bank may not require a guarantee when applying for a loan.

Disadvantages of annuity monthly payments:

With annuity payments, there is a high overpayment in the form of interest. It is possible to reduce the financial burden of annuity payments by participating in the restructuring program;

With annuity payments, there are no clearly defined proportions between the “body” of the loan and interest; they cannot be accurately calculated;

Early repayment of a loan with annuity payments is pointless, because both the “body” of the loan and the interest are subject to repayment.

What formula can banks use to calculate annuity payments on a loan?

For example, a client of RosselkhozBank, even before applying for a loan, can independently calculate the size of the annuity monthly payment using a calculator. In order to calculate the annuity payment, you need to know three components: the total loan size, the loan period, and the annuity payment coefficient (use the calculator to calculate the annuity payments on the loan).

The annuity payment coefficient can be calculated using a calculator using the formula:

K=i∗ ((1+i)n(1+i)n−1), where:

K – annuity payment coefficient,
n – number of periods under the contract,
i – annual interest rate divided by 12 months.

P = K*S, where:

P – monthly payment amount,
S – amount of debt,
K – coefficient.

Total amount The loan that will have to be repaid to the bank can be calculated using a calculator or using the formula:

S1 = n*K*S, where:

N – number of return periods,
S – loan size,
K – annuity payment coefficient,
S1 – final loan amount with interest.

Important! Some banks stipulate in the loan agreement a ban on early repayment of the loan, establishing fines and commissions. But the borrower can, having previously written an application, deposit the desired amount into the account and receive new scheme annuity payments on the loan.

You can familiarize yourself with the conditions for early repayment of an annuity loan even before applying for it on the bank’s website. An annuity calculator will help you calculate payments and show the feasibility of your choice of this loan.

Which payment is more profitable: annuity or differentiated?

The fundamental difference between annuity and differentiated payments lies in the method of loan repayment.

Important! With a differentiated repayment method, the “body” is repaid evenly throughout the entire period. Interest is calculated on the balance of the debt and decreases monthly. In case of early repayment, a recalculation is made, because the “body” is returned, and not the accrued interest. You can calculate them on a calculator and compare.

If you intend to repay the loan early, it is better to choose a program with a differentiated repayment method. An annuity loan implies monthly payments of a fixed amount.

At early termination Agreement, the borrower will have to repay the entire amount of the debt: the “body” and accrued interest. Therefore, the annuity method is preferable if you want to repay the loan within the allotted period.

You can calculate the real differences by using a calculator with the “annuity and differentiated” tab.
When applying for a loan, you should first calculate your financial opportunities and choose the optimal repayment method, annuity or differentiated.

Remember that late loan payments ruin the credit history, lead to fines. People with stable monthly income You should pay attention to the annuity payment. Because the best way to repay the debt on time without burdening the budget is an annuity payment, and the calculator will help you calculate everything.

What is more beneficial directly for the recipient? borrowed money annuity or differentiated payment type? Small comparative analysis shows the main differences between the two schemes:

• annuity loan repayment scheme ends up expensive differentiated scheme and this is especially noticeable at high interest rates and long term loan;
• down payments with a differentiated scheme, compared to an annuity, you get more;
• in the lending market, they primarily offer an annuity loan repayment scheme, due to significantly reduced requirements for minimum size confirmed income of the borrower;
• at early repayment in the case of using an annuity payment scheme, the cost of the loan decreases, since a significant amount of interest is repaid during the first payments on the loan;
• When providing a loan with a differentiated repayment scheme, financial institutions check more carefully solvency potential borrower, since in the first stages of loan repayment he needs to repay a significant part of the funds received.

However, the final choice of the repayment schedule and scheme remains with the potential borrower.

Credit calculator

Credit calculator is a toolkit for calculating the main parameters of a loan, implemented through a web interface, usually the website of a banking institution. Online loan calculator is a quick way to plan repayments as the principal amount credit funds, and interest accrued on the balance of the used credit limit.

Using our loan calculator, you can make calculations using differentiated or annuity payments.

Annuity payment– monthly repayment of the received loan funds by making equal fixed payments. Annuity repayment is represented by two parts - a fee for using loan funds and the amount that is used to repay the loan itself.

Differentiated payment carried out on a monthly basis, the payment amount decreases in direct proportion to the period until the end loan agreement. The structure of the differentiated payment is also formed from two parts - a once established amount of debt repayment and a decreasing part of the loan cost, which is calculated from the balance of the loan body.

Today, most credit institutions use the annuity payment scheme in their practice.

Among other things, the loan calculator is an excellent comparative tool for various types of loans, which allows you to contact banking specialists only directly to issue borrowed funds. Calculate a more profitable and convenient loan payment scheme using our loan calculator.

Annuity payment- an option for monthly loan payments, when the amount of the monthly payment remains constant throughout the entire loan period.

The monthly payment with an annuity loan repayment scheme consists of two parts. The first part of the payment goes to pay off interest on the loan. The second part goes to pay off the debt. The annuity repayment scheme differs from the differentiated one in that at the beginning credit period interest makes up the majority of the payment. Thus, the amount of the principal debt decreases slowly, and accordingly, the overpayment of interest with such a loan repayment scheme is higher.

With an annuity loan payment scheme, monthly payment is calculated as the sum of interest accrued for the current period and the amount used to repay the loan amount.

To calculate the amount of the monthly payment, you can use. Using a loan calculator, you can determine the amount of accrued interest, as well as the amount used to repay the debt. In addition, you can pick up a regular calculator and calculate the payment schedule manually.

Calculation of annuity payment

The formula for determining which part of the payment went to repay the loan and which part to pay interest is quite complex and without special mathematical knowledge it will be difficult for an ordinary person to use it. Therefore, we will calculate these values in a simple way, giving the same result.

To calculate the percentage component of the annuity payment, you need the loan balance for specified period multiply by the annual interest rate and divide all this by 12 (the number of months in a year).

To determine the portion used to repay the debt, it is necessary to subtract the accrued interest from the monthly payment.

Since the part going to repay the principal debt depends on previous payments, therefore, the calculation of the schedule using this method is calculated sequentially, starting with the first payment.

An example of calculating a payment schedule for an annuity loan

For example, let’s calculate the payment schedule for a loan in the amount of 100,000 rubles. and an annual interest rate of 10%. Let's take the loan repayment period to be 6 months.

First, let's calculate the monthly payment.

Then we will calculate the interest and credit part of the annuity payment by month.

If you are interested in finding out the amount of overpayment on an annuity loan, you need to multiply the monthly payment by the number of periods and subtract the original loan amount from the resulting number. In our case, the overpayment will be as follows:

17156,14 * 6 – 100000 = 2936,84

The result of calculations according to our example on the site will look like this:

Which confirms the correctness of our calculations.