What is the computer matching principal and interest formula for loans?
1. The calculation formula of monthly repayment amount is as follows: [Monthly interest rate of loan principal (1+ monthly interest rate) repayment months ][( 1+ monthly interest rate) repayment months-1].
2. Let's take an example: Suppose that the borrower obtains a personal housing loan of 200,000 yuan from the bank, with a loan term of 20 years and a monthly interest rate of 4.2, and pays the principal and interest every month. According to the above formula, the sum of monthly principal and interest payable is 1324.33 yuan. The above results only give the sum of the principal and interest payable each month, so it is necessary to decompose this sum of principal and interest.
3. On the basis of the above example, with one month as the first installment, the balance of the first installment loan is 200,000 yuan, and the interest payable is 840.00 yuan (2000,004.2). So only the principal is 484.33 yuan, and the bank loan is still 1995 15.67 yuan; The interest payable in the second phase is 837.97 yuan (1995 15.674.2), the principal is returned to 486.37 yuan, and the bank loan is still 199029.30 yuan, and so on.
What is the difference between equal principal and interest repayment and equal principal repayment?
1. In practice, the matching of principal and interest is more beneficial for customers to master and repay. In fact, many customers are still willing to choose the matching repayment method after comparison. This method has a fixed monthly repayment amount, which can control the expenditure of family income in a planned way and facilitate each family to determine the repayment ability according to their own income.
2. Because these customers also see that the use value of funds varies with time, simply speaking, the repayment method of equal principal and interest will naturally pay more interest because it takes up the bank principal for a long time; With the reduction of the principal, the repayment method of average capital occupies the principal of the bank for a short time, and the interest naturally decreases, so there is no problem that the bank earns more interest and suffers.
3. Compared with the repayment method in average capital, this repayment method has the disadvantage of more interest, which accounts for most of the monthly contributions at the initial stage of repayment. With the gradual return of the principal, the proportion of the principal in the contributions is also increasing.
If you have friends who need to buy a house, I suggest you pay attention to choosing the appropriate loan method and repayment method when applying for a loan. The above is about what is the computer matching principal and interest formula for loans, and what is the difference between matching principal and interest repayment and matching principal repayment. Before applying for a loan, you can learn about the repayment method and choose a repayment method according to your own needs.