Calculator and uniform annuity payments

How much do we overpay banks?
Loans and interest rates, as in this deal for yourself?

Often we hear about the loans and interest rates, in one case, they somehow more in other small. How to find out how many will have to pay on the loan, a loan is beneficial to us, and what not .. Banks something about this not tell ..
The rate of 20-25% typical of loans a year or two, is seen as very, well, very much ..
At the same time, the rate on the "long" mortgage 13.5% of 10-15 years seems quite normal, a little same rate ..

But we'll see another moment, as we eventually overpay for a loan?.

In the first case it would be the same 25%, but in the second .. total amount of payments on a mortgage loan can be two or even three times the amount of the loan. These are devious "little" interest on long term .. Banks about it, of course, keep silent. In addition, banks have resorted to various stratagems aimed at all in your favor. Apply several forms of payment:

- Equal installments (in equal parts)
The loan amount is divided into equal shares on terms of lending, they added interest on the loan. The amount each month turns out different. The first payments gets more, but then gradually reduced (by reducing interest).

- Annuity payment.
The client pays the same amount each month. It sounds so good and comfortable.
But how much of this amount will go to repay the loan?
First - just crumbs, the main bank to leave interest. That is, the first two or three years, you just feed your bank.

Do not believe me?
Look at the pictures below, the comparison charts and uniform annuity payment.

Let's try to calculate the credit on 4500000 for a period of 180 months by 13.5%
Here is an example for uniform payment (equal installments)


The amount of debt 4500 000,00 rub.
Amount% 4581 562,50r.

Total 9081 562,50r.




But what happens when you press the "Annuity payment"

The amount of debt 4500 000,00 rub.
Amount% 6006 582,25r.

Total 10,506 582,25r.




As you can see, the total amount for the same input parameters differs by half a million

If you are seriously thinking about a loan, think for at their figures, how much it will cost.

For this is precisely designed programm "Uniform and annuity payments"

You are right on the sheet EXCEL enter the loan amount, the number of periods (months), annual interest rate.

After completing these three parameters, the program will calculate the monthly amount of repayment in the uniform pay and the amount of annuity payments

The buttons on the right are for the formation of the payment schedule and calculate the amount of interest and the total amount of payments depending on the payment plan.

The field "Date of contract" is expected to be filled, this field is used in the formation of the schedule of payments.

You can experiment with their own figures and already armed with this information, please contact the bank.

Programm interested?
Buy.