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%.

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 = 380000 * 0.41667%/[1-(1+0.41667%)-360]

= 2039.92 yuan

Second, after 12 installment, the repayment will be 200,000 yuan in one lump sum, and the monthly repayment will be calculated later.

Sum of present value of monthly repayment before step 1 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 = 2039.92 * [1-(1.41667%)-13]/0.41667%.

= 2576 1.37 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.

=189,476.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)

Sum of monthly repayment present value after 12 = (380000-25761.37-189476.16) * (1+0.41667%)

= 1739 13.66 yuan

Step 4: Monthly repayment amount after 12 = sum of 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 =173913.66/{[1-(1+0.41667%)-347]/0.4/kloc.

=948.80 yuan

Results:

Under the assumed conditions, the loan will be repaid in one lump sum of 200,000.00 yuan after 12, and the monthly repayment amount in the later period will be 948.80 yuan. This prepayment can save interest 177669+0 yuan.