1, calculation formula

Interest =-ipmt (interest rate per period, which period, total number of periods, principal)

Principal =-ppmt (interest rate per installment, installment, total installment, principal)?

Monthly repayment amount = interest payable+principal payable

2, excel table preparation

Prepare the form as shown below. You can clearly calculate the interest and principal that should be paid back every month. (Current execution interest refers to monthly loan interest)

Two. Calculation of average capital Repayment Method

1, calculation formula

Monthly repayment interest = total amount of remaining loans * current execution interest/12.

Monthly repayment principal = total loan amount/loan months.

2. compile excel tables.

Prepare the form as shown below. You can clearly calculate how much you should pay back every month.