Suppose it is the repayment method of "equal principal and interest"
Assuming that the loan execution interest rate is 5%, the annual interest rate is 5%, and the monthly interest rate is = annual interest rate/12=0.4 1667%.
Suppose a one-time repayment of 200,000 yuan (i.e. 12) is made after one year.
First, calculate the monthly repayment amount.
Formula Monthly repayment amount = loan amount * monthly interest rate /[ 1-( 1+ monthly interest rate)-repayment months]
Monthly repayment amount = 900000 * 0.41667%/[1-(1.41667%)-360]
= 483 1.39 yuan
2. After 12 installment, 200,000 yuan will be repaid in one lump sum, and the monthly repayment amount will be calculated later.
Sum of the present value of monthly repayment in step 1 before 12 = monthly repayment *[ 1-( 1+ monthly interest rate)-(number of months paid+1)]/ monthly interest rate.
The sum of the present value of the previous 12 monthly repayment = 4831.39 * [1-(1+0.41667%)-13]/0.4/kloc.
=6 1, 0 13.76 yuan
Step 2: Present value of lump sum repayment after 12 = lump sum repayment after12 *( 1+ monthly interest rate)-(paid months+1)
The present value of one-time repayment after 12 period = 200,000 * (1+0.41667%)-13.
= 189476.6438+06 yuan
Sum of monthly repayment present value after step 3 12 = (sum of monthly repayment present value before loan amount -65438+02-/lump sum repayment present value after kloc-0/2) *( 1+ monthly interest rate)-(number of months paid+1)
The sum of the present value of monthly repayment after 12 = (900000-61013.76-189476.16) * (1+0.4/kloc)
= 685,584.99 yuan
Step 4: Monthly repayment amount after 12 = sum of the present value of monthly repayment amount after12 /{[ 1-( 1+ monthly interest rate)-(repayment months-paid months-1)]/ monthly interest rate}
Monthly repayment amount after 12 = 685,584.99/{[1-(1.41667%)-347]/0.41667%}
= 3740.28 yuan
Results:
Under the assumed conditions, the loan will be repaid in one lump sum of 200,000.00 yuan, and the monthly repayment amount in the later period will be 3,740.28 yuan. In this way, prepayment can save interest of RMB 65,438+074,878,438+04.